Spacious 1-Bed/1-Bath unit in Waikiki Sunset has open lanai with stunning unobstructed view of ocean and Diamond Head over the Kapiolani Park. Nicely renovated and fully furnished. Carpet & drapery have been replaced and entire walls including ceiling have been freshly painted in 2018. Close to Waikiki Beach, dining, shopping and bus stop. Ideal property for vacation home and investment. Aston Hotel Rental Program generates great income and unit is properly maintained by in-house maintenance dept. Unit has NUC which allows short term rental less than 30-days.
Listing by: Map Vision Inc.
array(169) {
["assd_val_imprv"]=>
array(1) {
[0]=>
string(9) "425100.00"
}
["assd_val_land"]=>
array(1) {
[0]=>
string(8) "84200.00"
}
["assd_val_total"]=>
array(1) {
[0]=>
string(9) "509300.00"
}
["bedrooms"]=>
array(1) {
[0]=>
string(1) "1"
}
["building_name"]=>
array(1) {
[0]=>
string(14) "Waikiki Sunset"
}
["building_style"]=>
array(1) {
[0]=>
string(29) "Condotel,High-Rise 7+ Stories"
}
["city"]=>
array(1) {
[0]=>
string(8) "Honolulu"
}
["county"]=>
array(1) {
[0]=>
string(4) "Oahu"
}
["disclosures"]=>
array(1) {
[0]=>
string(18) "Non Resident Owner"
}
["elementary_school"]=>
array(1) {
[0]=>
string(9) "Jefferson"
}
["exclusions"]=>
array(1) {
[0]=>
string(5) "Other"
}
["floor_covering"]=>
array(1) {
[0]=>
string(16) "Other,W/W Carpet"
}
["frontage"]=>
array(1) {
[0]=>
string(5) "Other"
}
["full_baths"]=>
array(1) {
[0]=>
string(1) "1"
}
["furnished"]=>
array(1) {
[0]=>
string(4) "Full"
}
["half_baths"]=>
array(1) {
[0]=>
string(1) "0"
}
["high_school"]=>
array(1) {
[0]=>
string(7) "Kaimuki"
}
["home_exampt"]=>
array(1) {
[0]=>
string(1) "0"
}
["lanai_sf"]=>
array(1) {
[0]=>
string(2) "67"
}
["land_area_sf"]=>
array(1) {
[0]=>
string(8) "49963.00"
}
["land_recorded"]=>
array(1) {
[0]=>
string(12) "Dual Systems"
}
["land_tenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["list_agent_email"]=>
array(1) {
[0]=>
string(24) "jiro@mapvisionhawaii.com"
}
["list_agent_name"]=>
array(1) {
[0]=>
string(13) "Jiro Mizukami"
}
["list_agent_phone_number"]=>
array(1) {
[0]=>
string(14) "(808) 971-0101"
}
["list_date"]=>
array(1) {
[0]=>
string(10) "2022-03-15"
}
["list_office_name"]=>
array(1) {
[0]=>
string(15) "Map Vision Inc."
}
["list_price"]=>
array(1) {
[0]=>
string(9) "680000.00"
}
["living_sf"]=>
array(1) {
[0]=>
string(3) "610"
}
["location"]=>
array(1) {
[0]=>
string(51) "229 Paoakalani Avenue Unit 3106, Honolulu, HI 96815"
}
["maintenance_fees"]=>
array(1) {
[0]=>
string(6) "797.74"
}
["middle_school"]=>
array(1) {
[0]=>
string(10) "Washington"
}
["mls_"]=>
array(1) {
[0]=>
string(9) "202204875"
}
["neighborhood"]=>
array(1) {
[0]=>
string(7) "WAIKIKI"
}
["number_of_parking_spaces"]=>
array(1) {
[0]=>
string(1) "1"
}
["number_of_stories"]=>
array(1) {
[0]=>
string(3) "21+"
}
["office_mls_id"]=>
array(1) {
[0]=>
string(4) "MAPV"
}
["parking_features"]=>
array(1) {
[0]=>
string(22) "Covered - 1,Unassigned"
}
["possession"]=>
array(1) {
[0]=>
string(23) "Subject to Rental Lease"
}
["postal_code"]=>
array(1) {
[0]=>
string(5) "96815"
}
["property_condition"]=>
array(1) {
[0]=>
string(13) "Above Average"
}
["property_type"]=>
array(1) {
[0]=>
string(15) "condo_townhouse"
}
["property_type_label"]=>
array(1) {
[0]=>
string(15) "Condo Townhouse"
}
["region"]=>
array(1) {
[0]=>
string(5) "Metro"
}
["rets_association_community_name"]=>
array(1) {
[0]=>
string(19) "AOAO Waikiki Sunset"
}
["rets_association_fee_2"]=>
array(1) {
[0]=>
string(3) "520"
}
["rets_association_fee_total"]=>
array(1) {
[0]=>
string(4) "1318"
}
["rets_association_phone"]=>
array(1) {
[0]=>
string(12) "808-931-6077"
}
["rets_baths_full"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_baths_half"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_baths_total"]=>
array(1) {
[0]=>
string(4) "1.00"
}
["rets_beds_total"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_building_name"]=>
array(1) {
[0]=>
string(14) "Waikiki Sunset"
}
["rets_city"]=>
array(1) {
[0]=>
string(8) "Honolulu"
}
["rets_condo_parking_unit"]=>
array(1) {
[0]=>
string(8) "Unassign"
}
["rets_current_price"]=>
array(1) {
[0]=>
string(9) "670000.00"
}
["rets_dom"]=>
array(1) {
[0]=>
string(2) "13"
}
["rets_dual_variable_compensation_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_elementary_school"]=>
array(1) {
[0]=>
string(9) "Jefferson"
}
["rets_elevators_number_of"]=>
array(1) {
[0]=>
string(1) "4"
}
["rets_floor_number"]=>
array(1) {
[0]=>
string(2) "31"
}
["rets_foreclosure_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_fractional_ownership_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_high_school"]=>
array(1) {
[0]=>
string(7) "Kaimuki"
}
["rets_id"]=>
array(1) {
[0]=>
string(8) "16509207"
}
["rets_immoviewer_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_internet_automated_valuation_dis"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_internet_consumer_comment_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_list_agent_direct_work_phone"]=>
array(1) {
[0]=>
string(14) "(808) 971-0101"
}
["rets_list_agent_email"]=>
array(1) {
[0]=>
string(24) "jiro@mapvisionhawaii.com"
}
["rets_list_agent_full_name"]=>
array(1) {
[0]=>
string(13) "Jiro Mizukami"
}
["rets_list_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "20622"
}
["rets_list_agent_mui"]=>
array(1) {
[0]=>
string(7) "8843020"
}
["rets_list_office_mlsid"]=>
array(1) {
[0]=>
string(4) "MAPV"
}
["rets_list_office_mui"]=>
array(1) {
[0]=>
string(7) "3484662"
}
["rets_list_office_name"]=>
array(1) {
[0]=>
string(15) "Map Vision Inc."
}
["rets_list_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 971-0101"
}
["rets_list_price"]=>
array(1) {
[0]=>
string(9) "680000.00"
}
["rets_listing_contract_date"]=>
array(1) {
[0]=>
string(10) "2022-03-15"
}
["rets_lot_size_area"]=>
array(1) {
[0]=>
string(8) "49963.00"
}
["rets_maintenance_expense"]=>
array(1) {
[0]=>
string(6) "797.74"
}
["rets_management_company_name"]=>
array(1) {
[0]=>
string(9) "Hawaiiana"
}
["rets_management_company_phone"]=>
array(1) {
[0]=>
string(12) "808-593-9100"
}
["rets_matrix_modified_dt"]=>
array(1) {
[0]=>
string(23) "2022-06-02T08:42:54.827"
}
["rets_matrix_unique_id"]=>
array(1) {
[0]=>
string(8) "16509207"
}
["rets_middle_or_junior_school"]=>
array(1) {
[0]=>
string(10) "Washington"
}
["rets_mls_number"]=>
array(1) {
[0]=>
string(9) "202204875"
}
["rets_neighbourhood"]=>
array(1) {
[0]=>
string(7) "WAIKIKI"
}
["rets_new_development_construction_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_original_entry_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-03-14T16:43:23.287"
}
["rets_original_list_price"]=>
array(1) {
[0]=>
string(9) "680000.00"
}
["rets_owner_occupancy_percentage"]=>
array(1) {
[0]=>
string(1) "4"
}
["rets_parcel_number"]=>
array(1) {
[0]=>
string(18) "1-2-6-028-011-0336"
}
["rets_parking_additional"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_parking_total"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_permit_address_internet_yn"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_permit_internet_yn"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_photo_count"]=>
array(1) {
[0]=>
string(2) "25"
}
["rets_photo_modification_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-03-21T09:51:55.380"
}
["rets_postal_code"]=>
array(1) {
[0]=>
string(5) "96815"
}
["rets_primary_key"]=>
array(1) {
[0]=>
string(8) "16509207"
}
["rets_private_remarks"]=>
array(1) {
[0]=>
string(209) "Unit is in Aston Rental Program. Call Waikiki Sunset Front Desk at (808) 922-0511 for showing availability. Other fee $520 is special assessment and will end May 2022. Income statements available upon request."
}
["rets_public_remarks"]=>
array(1) {
[0]=>
string(565) "Spacious 1-Bed/1-Bath unit in Waikiki Sunset has open lanai with stunning unobstructed view of ocean and Diamond Head over the Kapiolani Park. Nicely renovated and fully furnished. Carpet & drapery have been replaced and entire walls including ceiling have been freshly painted in 2018. Close to Waikiki Beach, dining, shopping and bus stop. Ideal property for vacation home and investment. Aston Hotel Rental Program generates great income and unit is properly maintained by in-house maintenance dept. Unit has NUC which allows short term rental less than 30-days."
}
["rets_public_report_number"]=>
array(1) {
[0]=>
string(4) "1015"
}
["rets_sqft_garage_carport"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_sqft_lanai_open"]=>
array(1) {
[0]=>
string(2) "67"
}
["rets_sqft_roofed_living"]=>
array(1) {
[0]=>
string(3) "543"
}
["rets_sqft_total"]=>
array(1) {
[0]=>
string(3) "610"
}
["rets_state_or_province"]=>
array(1) {
[0]=>
string(2) "HI"
}
["rets_status_change_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-06-02T08:42:54.827"
}
["rets_status_contractual_search_date"]=>
array(1) {
[0]=>
string(10) "2022-06-02"
}
["rets_street_name"]=>
array(1) {
[0]=>
string(10) "Paoakalani"
}
["rets_street_number"]=>
array(1) {
[0]=>
string(3) "229"
}
["rets_street_view_param"]=>
array(1) {
[0]=>
string(106) "1$21.274277$-157.820363$276.78$13.33$1.00$CAoSLEFGMVFpcE1mNl8wWDZlaU81cUlwcGpGOFZvc0RWcktJR3lobmQyVVZKNDd5"
}
["rets_sub_agency_compensation"]=>
array(1) {
[0]=>
string(4) "2.5%"
}
["rets_tax_amount"]=>
array(1) {
[0]=>
string(6) "155.00"
}
["rets_tax_annual_amount"]=>
array(1) {
[0]=>
string(7) "1860.00"
}
["rets_tax_assessed_value"]=>
array(1) {
[0]=>
string(9) "509300.00"
}
["rets_tax_assessed_value_improvements"]=>
array(1) {
[0]=>
string(9) "425100.00"
}
["rets_tax_assessed_value_land"]=>
array(1) {
[0]=>
string(8) "84200.00"
}
["rets_tax_excemption_owner_occupancy"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_tax_paid_by_seller_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_tax_year"]=>
array(1) {
[0]=>
string(4) "2021"
}
["rets_thumbnail_url"]=>
array(1) {
[0]=>
string(81) "https://cdn.rets.ci/marcusrealty-images/16509207/8794a5e92d4af8d890b4b26c3d231d1d"
}
["rets_tmk_area"]=>
array(1) {
[0]=>
string(3) "126"
}
["rets_tmk_condo_property_regime_number"]=>
array(1) {
[0]=>
string(3) "336"
}
["rets_tmk_division"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_tmk_parcel"]=>
array(1) {
[0]=>
string(2) "11"
}
["rets_tmk_section"]=>
array(1) {
[0]=>
string(1) "6"
}
["rets_tmk_zone"]=>
array(1) {
[0]=>
string(1) "2"
}
["rets_tmkplat"]=>
array(1) {
[0]=>
string(2) "28"
}
["rets_unit_number"]=>
array(1) {
[0]=>
string(4) "3106"
}
["rets_year_built"]=>
array(1) {
[0]=>
string(4) "1979"
}
["rets_year_remodeled"]=>
array(1) {
[0]=>
string(4) "2018"
}
["security"]=>
array(1) {
[0]=>
string(21) "Security Patrol,Video"
}
["state_or_province"]=>
array(1) {
[0]=>
string(2) "HI"
}
["status"]=>
array(1) {
[0]=>
string(4) "Sold"
}
["street_name"]=>
array(1) {
[0]=>
string(10) "Paoakalani"
}
["street_number"]=>
array(1) {
[0]=>
string(3) "229"
}
["street_suffix"]=>
array(1) {
[0]=>
string(6) "Avenue"
}
["terms_accept"]=>
array(1) {
[0]=>
string(26) "Cash,Conventional,Exchange"
}
["tmk"]=>
array(1) {
[0]=>
string(18) "1-2-6-028-011-0336"
}
["unit"]=>
array(1) {
[0]=>
string(21) "Central AC,Even# Unit"
}
["unit_number"]=>
array(1) {
[0]=>
string(4) "3106"
}
["view"]=>
array(1) {
[0]=>
string(23) "City,Diamond Head,Ocean"
}
["wpp::rets_pk"]=>
array(1) {
[0]=>
string(8) "16509207"
}
["wpp_gpid"]=>
array(1) {
[0]=>
string(9) "202204875"
}
["wpp_import_schedule_id"]=>
array(1) {
[0]=>
string(10) "1463343682"
}
["wpp_import_time"]=>
array(1) {
[0]=>
string(10) "1654195391"
}
["year_built"]=>
array(1) {
[0]=>
string(4) "1979"
}
["year_remodeled_"]=>
array(1) {
[0]=>
string(4) "2018"
}
["zoning"]=>
array(1) {
[0]=>
string(23) "X2 - Apartment Precinct"
}
["new_attached_media"]=>
array(1) {
[0]=>
string(1819) "a:113:{i:0;i:21824677;i:1;i:21824678;i:2;i:21824679;i:3;i:21824680;i:4;i:21824681;i:5;i:21824682;i:6;i:21824683;i:7;i:21824684;i:8;i:21859755;i:9;i:21859756;i:10;i:21859757;i:11;i:21859758;i:12;i:21859759;i:13;i:21859760;i:14;i:21859761;i:15;i:21859762;i:16;i:21859763;i:17;i:21859764;i:18;i:21859765;i:19;i:21859766;i:20;i:21859767;i:21;i:21859768;i:22;i:21859769;i:23;i:21859770;i:24;i:21859771;i:25;i:21859772;i:26;i:21859773;i:27;i:21859774;i:28;i:21859775;i:29;i:21859966;i:30;i:21859967;i:31;i:21859968;i:32;i:21859969;i:33;i:21859970;i:34;i:21859971;i:35;i:21859972;i:36;i:21859973;i:37;i:21859974;i:38;i:21859975;i:39;i:21859976;i:40;i:21859977;i:41;i:21859978;i:42;i:21859979;i:43;i:21859980;i:44;i:21859981;i:45;i:21859982;i:46;i:21859983;i:47;i:21859984;i:48;i:21859985;i:49;i:21859986;i:50;i:21901639;i:51;i:21901640;i:52;i:21901641;i:53;i:21901642;i:54;i:21901643;i:55;i:21901644;i:56;i:21901645;i:57;i:21901646;i:58;i:21901647;i:59;i:21901648;i:60;i:21901649;i:61;i:21901650;i:62;i:21901651;i:63;i:21901652;i:64;i:21901653;i:65;i:21901654;i:66;i:21901655;i:67;i:21901656;i:68;i:21901657;i:69;i:21901658;i:70;i:21901659;i:71;i:22315261;i:72;i:22315262;i:73;i:22315263;i:74;i:22315264;i:75;i:22315265;i:76;i:22315266;i:77;i:22315267;i:78;i:22315268;i:79;i:22315269;i:80;i:22315270;i:81;i:22315271;i:82;i:22315272;i:83;i:22315273;i:84;i:22315274;i:85;i:22315275;i:86;i:22315276;i:87;i:22315277;i:88;i:22315278;i:89;i:22315279;i:90;i:22315280;i:91;i:22315281;i:92;i:22347092;i:93;i:22347093;i:94;i:22347094;i:95;i:22347095;i:96;i:22347096;i:97;i:22347097;i:98;i:22347098;i:99;i:22347099;i:100;i:22347100;i:101;i:22347101;i:102;i:22347102;i:103;i:22347103;i:104;i:22347104;i:105;i:22347105;i:106;i:22347106;i:107;i:22347107;i:108;i:22347108;i:109;i:22347109;i:110;i:22347110;i:111;i:22347111;i:112;i:22347112;}"
}
["rets_active_continue_to_show_date"]=>
array(1) {
[0]=>
string(10) "2022-03-27"
}
["rets_pending_date"]=>
array(1) {
[0]=>
string(10) "2022-03-27"
}
["rets_close_date"]=>
array(1) {
[0]=>
string(10) "2022-06-02"
}
["rets_close_price"]=>
array(1) {
[0]=>
string(9) "670000.00"
}
["rets_expiration_date"]=>
array(1) {
[0]=>
string(10) "2023-03-14"
}
["rets_off_market_date"]=>
array(1) {
[0]=>
string(10) "2022-06-02"
}
["rets_selling_agent_direct_work_phone"]=>
array(1) {
[0]=>
string(14) "(808) 263-6000"
}
["rets_selling_agent_email"]=>
array(1) {
[0]=>
string(21) "lucyliushen@gmail.com"
}
["rets_selling_agent_full_name"]=>
array(1) {
[0]=>
string(13) "Lucy Liu Shen"
}
["rets_selling_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "45737"
}
["rets_selling_agent_mui"]=>
array(1) {
[0]=>
string(7) "9802532"
}
["rets_selling_office_mlsid"]=>
array(1) {
[0]=>
string(4) "KAIL"
}
["rets_selling_office_mui"]=>
array(1) {
[0]=>
string(7) "3485137"
}
["rets_selling_office_name"]=>
array(1) {
[0]=>
string(25) "Kailua Beach Realty, Ltd."
}
["rets_selling_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 263-6000"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "22347092"
}
}
Array
(
[assd_val_imprv] => Array
(
[0] => 425100.00
)
[assd_val_land] => Array
(
[0] => 84200.00
)
[assd_val_total] => Array
(
[0] => 509300.00
)
[bedrooms] => Array
(
[0] => 1
)
[building_name] => Array
(
[0] => Waikiki Sunset
)
[building_style] => Array
(
[0] => Condotel,High-Rise 7+ Stories
)
[city] => Array
(
[0] => Honolulu
)
[county] => Array
(
[0] => Oahu
)
[disclosures] => Array
(
[0] => Non Resident Owner
)
[elementary_school] => Array
(
[0] => Jefferson
)
[exclusions] => Array
(
[0] => Other
)
[floor_covering] => Array
(
[0] => Other,W/W Carpet
)
[frontage] => Array
(
[0] => Other
)
[full_baths] => Array
(
[0] => 1
)
[furnished] => Array
(
[0] => Full
)
[half_baths] => Array
(
[0] => 0
)
[high_school] => Array
(
[0] => Kaimuki
)
[home_exampt] => Array
(
[0] => 0
)
[lanai_sf] => Array
(
[0] => 67
)
[land_area_sf] => Array
(
[0] => 49963.00
)
[land_recorded] => Array
(
[0] => Dual Systems
)
[land_tenure] => Array
(
[0] => FS - Fee Simple
)
[list_agent_email] => Array
(
[0] => jiro@mapvisionhawaii.com
)
[list_agent_name] => Array
(
[0] => Jiro Mizukami
)
[list_agent_phone_number] => Array
(
[0] => (808) 971-0101
)
[list_date] => Array
(
[0] => 2022-03-15
)
[list_office_name] => Array
(
[0] => Map Vision Inc.
)
[list_price] => Array
(
[0] => 680000.00
)
[living_sf] => Array
(
[0] => 610
)
[location] => Array
(
[0] => 229 Paoakalani Avenue Unit 3106, Honolulu, HI 96815
)
[maintenance_fees] => Array
(
[0] => 797.74
)
[middle_school] => Array
(
[0] => Washington
)
[mls_] => Array
(
[0] => 202204875
)
[neighborhood] => Array
(
[0] => WAIKIKI
)
[number_of_parking_spaces] => Array
(
[0] => 1
)
[number_of_stories] => Array
(
[0] => 21+
)
[office_mls_id] => Array
(
[0] => MAPV
)
[parking_features] => Array
(
[0] => Covered - 1,Unassigned
)
[possession] => Array
(
[0] => Subject to Rental Lease
)
[postal_code] => Array
(
[0] => 96815
)
[property_condition] => Array
(
[0] => Above Average
)
[property_type] => Array
(
[0] => condo_townhouse
)
[property_type_label] => Array
(
[0] => Condo Townhouse
)
[region] => Array
(
[0] => Metro
)
[rets_association_community_name] => Array
(
[0] => AOAO Waikiki Sunset
)
[rets_association_fee_2] => Array
(
[0] => 520
)
[rets_association_fee_total] => Array
(
[0] => 1318
)
[rets_association_phone] => Array
(
[0] => 808-931-6077
)
[rets_baths_full] => Array
(
[0] => 1
)
[rets_baths_half] => Array
(
[0] => 0
)
[rets_baths_total] => Array
(
[0] => 1.00
)
[rets_beds_total] => Array
(
[0] => 1
)
[rets_building_name] => Array
(
[0] => Waikiki Sunset
)
[rets_city] => Array
(
[0] => Honolulu
)
[rets_condo_parking_unit] => Array
(
[0] => Unassign
)
[rets_current_price] => Array
(
[0] => 670000.00
)
[rets_dom] => Array
(
[0] => 13
)
[rets_dual_variable_compensation_yn] => Array
(
[0] => 0
)
[rets_elementary_school] => Array
(
[0] => Jefferson
)
[rets_elevators_number_of] => Array
(
[0] => 4
)
[rets_floor_number] => Array
(
[0] => 31
)
[rets_foreclosure_yn] => Array
(
[0] => 0
)
[rets_fractional_ownership_yn] => Array
(
[0] => 0
)
[rets_high_school] => Array
(
[0] => Kaimuki
)
[rets_id] => Array
(
[0] => 16509207
)
[rets_immoviewer_yn] => Array
(
[0] => 0
)
[rets_internet_automated_valuation_dis] => Array
(
[0] => 0
)
[rets_internet_consumer_comment_yn] => Array
(
[0] => 0
)
[rets_list_agent_direct_work_phone] => Array
(
[0] => (808) 971-0101
)
[rets_list_agent_email] => Array
(
[0] => jiro@mapvisionhawaii.com
)
[rets_list_agent_full_name] => Array
(
[0] => Jiro Mizukami
)
[rets_list_agent_mlsid] => Array
(
[0] => 20622
)
[rets_list_agent_mui] => Array
(
[0] => 8843020
)
[rets_list_office_mlsid] => Array
(
[0] => MAPV
)
[rets_list_office_mui] => Array
(
[0] => 3484662
)
[rets_list_office_name] => Array
(
[0] => Map Vision Inc.
)
[rets_list_office_phone] => Array
(
[0] => (808) 971-0101
)
[rets_list_price] => Array
(
[0] => 680000.00
)
[rets_listing_contract_date] => Array
(
[0] => 2022-03-15
)
[rets_lot_size_area] => Array
(
[0] => 49963.00
)
[rets_maintenance_expense] => Array
(
[0] => 797.74
)
[rets_management_company_name] => Array
(
[0] => Hawaiiana
)
[rets_management_company_phone] => Array
(
[0] => 808-593-9100
)
[rets_matrix_modified_dt] => Array
(
[0] => 2022-06-02T08:42:54.827
)
[rets_matrix_unique_id] => Array
(
[0] => 16509207
)
[rets_middle_or_junior_school] => Array
(
[0] => Washington
)
[rets_mls_number] => Array
(
[0] => 202204875
)
[rets_neighbourhood] => Array
(
[0] => WAIKIKI
)
[rets_new_development_construction_yn] => Array
(
[0] => 0
)
[rets_original_entry_timestamp] => Array
(
[0] => 2022-03-14T16:43:23.287
)
[rets_original_list_price] => Array
(
[0] => 680000.00
)
[rets_owner_occupancy_percentage] => Array
(
[0] => 4
)
[rets_parcel_number] => Array
(
[0] => 1-2-6-028-011-0336
)
[rets_parking_additional] => Array
(
[0] => 0
)
[rets_parking_total] => Array
(
[0] => 1
)
[rets_permit_address_internet_yn] => Array
(
[0] => 1
)
[rets_permit_internet_yn] => Array
(
[0] => 1
)
[rets_photo_count] => Array
(
[0] => 25
)
[rets_photo_modification_timestamp] => Array
(
[0] => 2022-03-21T09:51:55.380
)
[rets_postal_code] => Array
(
[0] => 96815
)
[rets_primary_key] => Array
(
[0] => 16509207
)
[rets_private_remarks] => Array
(
[0] => Unit is in Aston Rental Program. Call Waikiki Sunset Front Desk at (808) 922-0511 for showing availability. Other fee $520 is special assessment and will end May 2022. Income statements available upon request.
)
[rets_public_remarks] => Array
(
[0] => Spacious 1-Bed/1-Bath unit in Waikiki Sunset has open lanai with stunning unobstructed view of ocean and Diamond Head over the Kapiolani Park. Nicely renovated and fully furnished. Carpet & drapery have been replaced and entire walls including ceiling have been freshly painted in 2018. Close to Waikiki Beach, dining, shopping and bus stop. Ideal property for vacation home and investment. Aston Hotel Rental Program generates great income and unit is properly maintained by in-house maintenance dept. Unit has NUC which allows short term rental less than 30-days.
)
[rets_public_report_number] => Array
(
[0] => 1015
)
[rets_sqft_garage_carport] => Array
(
[0] => 0
)
[rets_sqft_lanai_open] => Array
(
[0] => 67
)
[rets_sqft_roofed_living] => Array
(
[0] => 543
)
[rets_sqft_total] => Array
(
[0] => 610
)
[rets_state_or_province] => Array
(
[0] => HI
)
[rets_status_change_timestamp] => Array
(
[0] => 2022-06-02T08:42:54.827
)
[rets_status_contractual_search_date] => Array
(
[0] => 2022-06-02
)
[rets_street_name] => Array
(
[0] => Paoakalani
)
[rets_street_number] => Array
(
[0] => 229
)
[rets_street_view_param] => Array
(
[0] => 1$21.274277$-157.820363$276.78$13.33$1.00$CAoSLEFGMVFpcE1mNl8wWDZlaU81cUlwcGpGOFZvc0RWcktJR3lobmQyVVZKNDd5
)
[rets_sub_agency_compensation] => Array
(
[0] => 2.5%
)
[rets_tax_amount] => Array
(
[0] => 155.00
)
[rets_tax_annual_amount] => Array
(
[0] => 1860.00
)
[rets_tax_assessed_value] => Array
(
[0] => 509300.00
)
[rets_tax_assessed_value_improvements] => Array
(
[0] => 425100.00
)
[rets_tax_assessed_value_land] => Array
(
[0] => 84200.00
)
[rets_tax_excemption_owner_occupancy] => Array
(
[0] => 0
)
[rets_tax_paid_by_seller_yn] => Array
(
[0] => 0
)
[rets_tax_year] => Array
(
[0] => 2021
)
[rets_thumbnail_url] => Array
(
[0] => https://cdn.rets.ci/marcusrealty-images/16509207/8794a5e92d4af8d890b4b26c3d231d1d
)
[rets_tmk_area] => Array
(
[0] => 126
)
[rets_tmk_condo_property_regime_number] => Array
(
[0] => 336
)
[rets_tmk_division] => Array
(
[0] => 1
)
[rets_tmk_parcel] => Array
(
[0] => 11
)
[rets_tmk_section] => Array
(
[0] => 6
)
[rets_tmk_zone] => Array
(
[0] => 2
)
[rets_tmkplat] => Array
(
[0] => 28
)
[rets_unit_number] => Array
(
[0] => 3106
)
[rets_year_built] => Array
(
[0] => 1979
)
[rets_year_remodeled] => Array
(
[0] => 2018
)
[security] => Array
(
[0] => Security Patrol,Video
)
[state_or_province] => Array
(
[0] => HI
)
[status] => Array
(
[0] => Sold
)
[street_name] => Array
(
[0] => Paoakalani
)
[street_number] => Array
(
[0] => 229
)
[street_suffix] => Array
(
[0] => Avenue
)
[terms_accept] => Array
(
[0] => Cash,Conventional,Exchange
)
[tmk] => Array
(
[0] => 1-2-6-028-011-0336
)
[unit] => Array
(
[0] => Central AC,Even# Unit
)
[unit_number] => Array
(
[0] => 3106
)
[view] => Array
(
[0] => City,Diamond Head,Ocean
)
[wpp::rets_pk] => Array
(
[0] => 16509207
)
[wpp_gpid] => Array
(
[0] => 202204875
)
[wpp_import_schedule_id] => Array
(
[0] => 1463343682
)
[wpp_import_time] => Array
(
[0] => 1654195391
)
[year_built] => Array
(
[0] => 1979
)
[year_remodeled_] => Array
(
[0] => 2018
)
[zoning] => Array
(
[0] => X2 - Apartment Precinct
)
[new_attached_media] => Array
(
[0] => a:113:{i:0;i:21824677;i:1;i:21824678;i:2;i:21824679;i:3;i:21824680;i:4;i:21824681;i:5;i:21824682;i:6;i:21824683;i:7;i:21824684;i:8;i:21859755;i:9;i:21859756;i:10;i:21859757;i:11;i:21859758;i:12;i:21859759;i:13;i:21859760;i:14;i:21859761;i:15;i:21859762;i:16;i:21859763;i:17;i:21859764;i:18;i:21859765;i:19;i:21859766;i:20;i:21859767;i:21;i:21859768;i:22;i:21859769;i:23;i:21859770;i:24;i:21859771;i:25;i:21859772;i:26;i:21859773;i:27;i:21859774;i:28;i:21859775;i:29;i:21859966;i:30;i:21859967;i:31;i:21859968;i:32;i:21859969;i:33;i:21859970;i:34;i:21859971;i:35;i:21859972;i:36;i:21859973;i:37;i:21859974;i:38;i:21859975;i:39;i:21859976;i:40;i:21859977;i:41;i:21859978;i:42;i:21859979;i:43;i:21859980;i:44;i:21859981;i:45;i:21859982;i:46;i:21859983;i:47;i:21859984;i:48;i:21859985;i:49;i:21859986;i:50;i:21901639;i:51;i:21901640;i:52;i:21901641;i:53;i:21901642;i:54;i:21901643;i:55;i:21901644;i:56;i:21901645;i:57;i:21901646;i:58;i:21901647;i:59;i:21901648;i:60;i:21901649;i:61;i:21901650;i:62;i:21901651;i:63;i:21901652;i:64;i:21901653;i:65;i:21901654;i:66;i:21901655;i:67;i:21901656;i:68;i:21901657;i:69;i:21901658;i:70;i:21901659;i:71;i:22315261;i:72;i:22315262;i:73;i:22315263;i:74;i:22315264;i:75;i:22315265;i:76;i:22315266;i:77;i:22315267;i:78;i:22315268;i:79;i:22315269;i:80;i:22315270;i:81;i:22315271;i:82;i:22315272;i:83;i:22315273;i:84;i:22315274;i:85;i:22315275;i:86;i:22315276;i:87;i:22315277;i:88;i:22315278;i:89;i:22315279;i:90;i:22315280;i:91;i:22315281;i:92;i:22347092;i:93;i:22347093;i:94;i:22347094;i:95;i:22347095;i:96;i:22347096;i:97;i:22347097;i:98;i:22347098;i:99;i:22347099;i:100;i:22347100;i:101;i:22347101;i:102;i:22347102;i:103;i:22347103;i:104;i:22347104;i:105;i:22347105;i:106;i:22347106;i:107;i:22347107;i:108;i:22347108;i:109;i:22347109;i:110;i:22347110;i:111;i:22347111;i:112;i:22347112;}
)
[rets_active_continue_to_show_date] => Array
(
[0] => 2022-03-27
)
[rets_pending_date] => Array
(
[0] => 2022-03-27
)
[rets_close_date] => Array
(
[0] => 2022-06-02
)
[rets_close_price] => Array
(
[0] => 670000.00
)
[rets_expiration_date] => Array
(
[0] => 2023-03-14
)
[rets_off_market_date] => Array
(
[0] => 2022-06-02
)
[rets_selling_agent_direct_work_phone] => Array
(
[0] => (808) 263-6000
)
[rets_selling_agent_email] => Array
(
[0] => lucyliushen@gmail.com
)
[rets_selling_agent_full_name] => Array
(
[0] => Lucy Liu Shen
)
[rets_selling_agent_mlsid] => Array
(
[0] => 45737
)
[rets_selling_agent_mui] => Array
(
[0] => 9802532
)
[rets_selling_office_mlsid] => Array
(
[0] => KAIL
)
[rets_selling_office_mui] => Array
(
[0] => 3485137
)
[rets_selling_office_name] => Array
(
[0] => Kailua Beach Realty, Ltd.
)
[rets_selling_office_phone] => Array
(
[0] => (808) 263-6000
)
[_thumbnail_id] => Array
(
[0] => 22347092
)
)
CONTACT US
#RB-7120
info@marcushawaii.com
(808)839-7446