Boutique building with rare, upgraded, large 1 bedroom with livable lanai – steps to beach, park, zoo. Owner/resident maintained with tender care. Parking is first come first serve for all residents. Not guaranteed all residents will find a stall. Please inquire. LEGAL zoning for vacation rental/airbnb – even with new Honolulu ordinance. Secure, well maintained, clean building. Coin laundry. Resident manager lives in blg. You will LOVE the location, love the lanai. Electric, hot water, cable included in maint. fee. 2 ACs. Wide open kitchen/entertaining dining/living area (granite counter tops). Peek of the ocean thru the coconut trees between buildings. This is the BEST end of Waikiki; easy in/out to building. Walk the park in the mornings/evenings. Parades. Living in paradise. Rich, beautiful flooring, luxurious walk in shower enclosure, marble floored bath, tiled lanai.
Listing by: Pacific Oasis Realty, LLC
array(161) {
["assd_val_imprv"]=>
array(1) {
[0]=>
string(9) "305200.00"
}
["assd_val_land"]=>
array(1) {
[0]=>
string(8) "42000.00"
}
["assd_val_total"]=>
array(1) {
[0]=>
string(9) "347200.00"
}
["bedrooms"]=>
array(1) {
[0]=>
string(1) "1"
}
["building_name"]=>
array(1) {
[0]=>
string(16) "Tradewinds Plaza"
}
["building_style"]=>
array(1) {
[0]=>
string(20) "High-Rise 7+ Stories"
}
["city"]=>
array(1) {
[0]=>
string(8) "Honolulu"
}
["county"]=>
array(1) {
[0]=>
string(4) "Oahu"
}
["disclosures"]=>
array(1) {
[0]=>
string(4) "None"
}
["exclusions"]=>
array(1) {
[0]=>
string(5) "Other"
}
["floor_covering"]=>
array(1) {
[0]=>
string(21) "Ceramic Tile,Laminate"
}
["full_baths"]=>
array(1) {
[0]=>
string(1) "1"
}
["furnished"]=>
array(1) {
[0]=>
string(7) "Partial"
}
["half_baths"]=>
array(1) {
[0]=>
string(1) "0"
}
["home_exampt"]=>
array(1) {
[0]=>
string(6) "140000"
}
["lanai_sf"]=>
array(1) {
[0]=>
string(3) "148"
}
["land_area_sf"]=>
array(1) {
[0]=>
string(8) "10019.00"
}
["land_recorded"]=>
array(1) {
[0]=>
string(14) "Regular System"
}
["land_tenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["list_agent_email"]=>
array(1) {
[0]=>
string(22) "neil@pacific-oasis.com"
}
["list_agent_name"]=>
array(1) {
[0]=>
string(10) "Neil Bates"
}
["list_agent_phone_number"]=>
array(1) {
[0]=>
string(14) "(808) 778-3275"
}
["list_date"]=>
array(1) {
[0]=>
string(10) "2022-07-09"
}
["list_office_name"]=>
array(1) {
[0]=>
string(25) "Pacific Oasis Realty, LLC"
}
["list_price"]=>
array(1) {
[0]=>
string(9) "547000.00"
}
["living_sf"]=>
array(1) {
[0]=>
string(3) "667"
}
["location"]=>
array(1) {
[0]=>
string(44) "2572 Lemon Road Unit 605, Honolulu, HI 96815"
}
["maintenance_fees"]=>
array(1) {
[0]=>
string(6) "703.00"
}
["mls_"]=>
array(1) {
[0]=>
string(9) "202213176"
}
["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) "One"
}
["office_mls_id"]=>
array(1) {
[0]=>
string(4) "HKNY"
}
["parking_features"]=>
array(1) {
[0]=>
string(26) "Covered - 1,Guest,Open - 1"
}
["possession"]=>
array(1) {
[0]=>
string(15) "45 Days or More"
}
["postal_code"]=>
array(1) {
[0]=>
string(5) "96815"
}
["property_condition"]=>
array(1) {
[0]=>
string(9) "Excellent"
}
["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_fee_total"]=>
array(1) {
[0]=>
string(3) "703"
}
["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(16) "Tradewinds Plaza"
}
["rets_city"]=>
array(1) {
[0]=>
string(8) "Honolulu"
}
["rets_condo_parking_unit"]=>
array(1) {
[0]=>
string(11) "FCFS - ask."
}
["rets_current_price"]=>
array(1) {
[0]=>
string(9) "510000.00"
}
["rets_dom"]=>
array(1) {
[0]=>
string(2) "46"
}
["rets_dual_variable_compensation_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_elevators_number_of"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_floor_number"]=>
array(1) {
[0]=>
string(1) "6"
}
["rets_foreclosure_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_fractional_ownership_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_id"]=>
array(1) {
[0]=>
string(8) "16753313"
}
["rets_immoviewer_yn"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_internet_automated_valuation_dis"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_internet_consumer_comment_yn"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_list_agent_direct_work_phone"]=>
array(1) {
[0]=>
string(14) "(808) 778-3275"
}
["rets_list_agent_email"]=>
array(1) {
[0]=>
string(22) "neil@pacific-oasis.com"
}
["rets_list_agent_full_name"]=>
array(1) {
[0]=>
string(10) "Neil Bates"
}
["rets_list_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "23290"
}
["rets_list_agent_mui"]=>
array(1) {
[0]=>
string(7) "3474629"
}
["rets_list_office_mlsid"]=>
array(1) {
[0]=>
string(4) "HKNY"
}
["rets_list_office_mui"]=>
array(1) {
[0]=>
string(7) "3486768"
}
["rets_list_office_name"]=>
array(1) {
[0]=>
string(25) "Pacific Oasis Realty, LLC"
}
["rets_list_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 778-3275"
}
["rets_list_price"]=>
array(1) {
[0]=>
string(9) "547000.00"
}
["rets_listing_contract_date"]=>
array(1) {
[0]=>
string(10) "2022-07-09"
}
["rets_lot_size_area"]=>
array(1) {
[0]=>
string(8) "10019.00"
}
["rets_maintenance_expense"]=>
array(1) {
[0]=>
string(6) "703.00"
}
["rets_management_company_name"]=>
array(1) {
[0]=>
string(10) "touchstone"
}
["rets_management_company_phone"]=>
array(1) {
[0]=>
string(10) "8085664100"
}
["rets_matrix_modified_dt"]=>
array(1) {
[0]=>
string(23) "2022-09-29T17:40:48.953"
}
["rets_matrix_unique_id"]=>
array(1) {
[0]=>
string(8) "16753313"
}
["rets_mls_number"]=>
array(1) {
[0]=>
string(9) "202213176"
}
["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-07-09T19:02:08.733"
}
["rets_original_list_price"]=>
array(1) {
[0]=>
string(9) "627000.00"
}
["rets_owner_occupancy_percentage"]=>
array(1) {
[0]=>
string(2) "16"
}
["rets_parcel_number"]=>
array(1) {
[0]=>
string(18) "1-2-6-027-020-0045"
}
["rets_parking_additional"]=>
array(1) {
[0]=>
string(2) "23"
}
["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) "17"
}
["rets_photo_modification_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-07-09T19:02:08.733"
}
["rets_postal_code"]=>
array(1) {
[0]=>
string(5) "96815"
}
["rets_primary_key"]=>
array(1) {
[0]=>
string(8) "16753313"
}
["rets_private_remarks"]=>
array(1) {
[0]=>
string(470) "Building does not allow lockboxes. lockbox at nearby building. Please include signed short term rental disclosure statement with offers. Allow 2 days for response. 23 FCFS (first come first serve) parking stalls on upper deck. 27 privately owned parking stalls on lower deck. Want to purchase a private stall - please ask. Please use Brandon Choi - Title Guaranty King. Accepting backup offers.
Your client will love the unit, the building and the location."
}
["rets_public_remarks"]=>
array(1) {
[0]=>
string(901) "Boutique building with rare, upgraded, large 1 bedroom with livable lanai - steps to beach, park, zoo. Owner/resident maintained with tender care. Parking is first come first serve for all residents. Not guaranteed all residents will find a stall. Please inquire. LEGAL zoning for vacation rental/airbnb - even with new Honolulu ordinance. Secure, well maintained, clean building. Coin laundry. Resident manager lives in blg. You will LOVE the location, love the lanai. Electric, hot water, cable included in maint. fee. 2 ACs. Wide open kitchen/entertaining dining/living area (granite counter tops). Peek of the ocean thru the coconut trees between buildings. This is the BEST end of Waikiki; easy in/out to building. Walk the park in the mornings/evenings. Parades. Living in paradise. Rich, beautiful flooring, luxurious walk in shower enclosure, marble floored bath, tiled lanai."
}
["rets_sqft_lanai_open"]=>
array(1) {
[0]=>
string(3) "148"
}
["rets_sqft_roofed_living"]=>
array(1) {
[0]=>
string(3) "519"
}
["rets_sqft_total"]=>
array(1) {
[0]=>
string(3) "667"
}
["rets_state_or_province"]=>
array(1) {
[0]=>
string(2) "HI"
}
["rets_status_change_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-09-29T17:40:48.953"
}
["rets_status_contractual_search_date"]=>
array(1) {
[0]=>
string(10) "2022-09-28"
}
["rets_street_name"]=>
array(1) {
[0]=>
string(5) "Lemon"
}
["rets_street_number"]=>
array(1) {
[0]=>
string(4) "2572"
}
["rets_sub_agency_compensation"]=>
array(1) {
[0]=>
string(4) "2.5%"
}
["rets_supplement_count"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_supplement_modification_timestam"]=>
array(1) {
[0]=>
string(23) "2022-07-09T12:20:18.633"
}
["rets_tax_amount"]=>
array(1) {
[0]=>
string(5) "86.00"
}
["rets_tax_annual_amount"]=>
array(1) {
[0]=>
string(7) "1032.00"
}
["rets_tax_assessed_value"]=>
array(1) {
[0]=>
string(9) "347200.00"
}
["rets_tax_assessed_value_improvements"]=>
array(1) {
[0]=>
string(9) "305200.00"
}
["rets_tax_assessed_value_land"]=>
array(1) {
[0]=>
string(8) "42000.00"
}
["rets_tax_excemption_owner_occupancy"]=>
array(1) {
[0]=>
string(6) "140000"
}
["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/16753313/52e8c5af1e1cd09bcd29135282dee3a6"
}
["rets_tmk_area"]=>
array(1) {
[0]=>
string(3) "126"
}
["rets_tmk_condo_property_regime_number"]=>
array(1) {
[0]=>
string(2) "45"
}
["rets_tmk_division"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_tmk_parcel"]=>
array(1) {
[0]=>
string(2) "20"
}
["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) "27"
}
["rets_unit_number"]=>
array(1) {
[0]=>
string(3) "605"
}
["rets_year_built"]=>
array(1) {
[0]=>
string(4) "1979"
}
["rets_year_remodeled"]=>
array(1) {
[0]=>
string(4) "2017"
}
["security"]=>
array(1) {
[0]=>
string(20) "Card,Gated Community"
}
["state_or_province"]=>
array(1) {
[0]=>
string(2) "HI"
}
["status"]=>
array(1) {
[0]=>
string(4) "Sold"
}
["street_name"]=>
array(1) {
[0]=>
string(5) "Lemon"
}
["street_number"]=>
array(1) {
[0]=>
string(4) "2572"
}
["street_suffix"]=>
array(1) {
[0]=>
string(4) "Road"
}
["terms_accept"]=>
array(1) {
[0]=>
string(17) "Cash,Conventional"
}
["tmk"]=>
array(1) {
[0]=>
string(18) "1-2-6-027-020-0045"
}
["unit"]=>
array(1) {
[0]=>
string(28) "Bedroom on 1st Level,Storage"
}
["unit_number"]=>
array(1) {
[0]=>
string(3) "605"
}
["view"]=>
array(1) {
[0]=>
string(5) "Ocean"
}
["wpp::rets_pk"]=>
array(1) {
[0]=>
string(8) "16753313"
}
["wpp_gpid"]=>
array(1) {
[0]=>
string(9) "202213176"
}
["wpp_import_schedule_id"]=>
array(1) {
[0]=>
string(10) "1463343682"
}
["wpp_import_time"]=>
array(1) {
[0]=>
string(10) "1664509318"
}
["year_built"]=>
array(1) {
[0]=>
string(4) "1979"
}
["year_remodeled_"]=>
array(1) {
[0]=>
string(4) "2017"
}
["zoning"]=>
array(1) {
[0]=>
string(30) "X6 - Resort Mixed Use Precinct"
}
["new_attached_media"]=>
array(1) {
[0]=>
string(3655) "a:221:{i:0;i:22675237;i:1;i:22675238;i:2;i:22675239;i:3;i:22675240;i:4;i:22675241;i:5;i:22675242;i:6;i:22675243;i:7;i:22675244;i:8;i:22675245;i:9;i:22675246;i:10;i:22675247;i:11;i:22675248;i:12;i:22675249;i:13;i:22675250;i:14;i:22675251;i:15;i:22675252;i:16;i:22675253;i:17;i:22677709;i:18;i:22677710;i:19;i:22677711;i:20;i:22677712;i:21;i:22677713;i:22;i:22677714;i:23;i:22677715;i:24;i:22677716;i:25;i:22677717;i:26;i:22677718;i:27;i:22677719;i:28;i:22677720;i:29;i:22677721;i:30;i:22677722;i:31;i:22677723;i:32;i:22677724;i:33;i:22677725;i:34;i:22694777;i:35;i:22694778;i:36;i:22694779;i:37;i:22694780;i:38;i:22694781;i:39;i:22694782;i:40;i:22694783;i:41;i:22694784;i:42;i:22694785;i:43;i:22694786;i:44;i:22694787;i:45;i:22694788;i:46;i:22694789;i:47;i:22694790;i:48;i:22694791;i:49;i:22694792;i:50;i:22694793;i:51;i:22694871;i:52;i:22694872;i:53;i:22694873;i:54;i:22694874;i:55;i:22694875;i:56;i:22694876;i:57;i:22694877;i:58;i:22694878;i:59;i:22694879;i:60;i:22694880;i:61;i:22694881;i:62;i:22694882;i:63;i:22694883;i:64;i:22694884;i:65;i:22694885;i:66;i:22694886;i:67;i:22694887;i:68;i:22847761;i:69;i:22847762;i:70;i:22847763;i:71;i:22847764;i:72;i:22847765;i:73;i:22847766;i:74;i:22847767;i:75;i:22847768;i:76;i:22847769;i:77;i:22847770;i:78;i:22847771;i:79;i:22847772;i:80;i:22847773;i:81;i:22847774;i:82;i:22847775;i:83;i:22847776;i:84;i:22847777;i:85;i:22857969;i:86;i:22857970;i:87;i:22857971;i:88;i:22857972;i:89;i:22857973;i:90;i:22857974;i:91;i:22857975;i:92;i:22857976;i:93;i:22857977;i:94;i:22857978;i:95;i:22857979;i:96;i:22857980;i:97;i:22857981;i:98;i:22857982;i:99;i:22857983;i:100;i:22857984;i:101;i:22857985;i:102;i:22858358;i:103;i:22858359;i:104;i:22858360;i:105;i:22858361;i:106;i:22858362;i:107;i:22858363;i:108;i:22858364;i:109;i:22858365;i:110;i:22858366;i:111;i:22858367;i:112;i:22858368;i:113;i:22858369;i:114;i:22858370;i:115;i:22858371;i:116;i:22858372;i:117;i:22858373;i:118;i:22858374;i:119;i:22858652;i:120;i:22858653;i:121;i:22858654;i:122;i:22858655;i:123;i:22858656;i:124;i:22858657;i:125;i:22858658;i:126;i:22858659;i:127;i:22858660;i:128;i:22858661;i:129;i:22858662;i:130;i:22858663;i:131;i:22858664;i:132;i:22858665;i:133;i:22858666;i:134;i:22858667;i:135;i:22858668;i:136;i:22928958;i:137;i:22928959;i:138;i:22928960;i:139;i:22928961;i:140;i:22928962;i:141;i:22928963;i:142;i:22928964;i:143;i:22928965;i:144;i:22928966;i:145;i:22928967;i:146;i:22928968;i:147;i:22928969;i:148;i:22928970;i:149;i:22928971;i:150;i:22928972;i:151;i:22928973;i:152;i:22928974;i:153;i:23074946;i:154;i:23074947;i:155;i:23074948;i:156;i:23074949;i:157;i:23074950;i:158;i:23074951;i:159;i:23074952;i:160;i:23074953;i:161;i:23074954;i:162;i:23074955;i:163;i:23074956;i:164;i:23074957;i:165;i:23074958;i:166;i:23074959;i:167;i:23074960;i:168;i:23074961;i:169;i:23074962;i:170;i:23142892;i:171;i:23142893;i:172;i:23142894;i:173;i:23142895;i:174;i:23142896;i:175;i:23142897;i:176;i:23142898;i:177;i:23142899;i:178;i:23142900;i:179;i:23142901;i:180;i:23142902;i:181;i:23142903;i:182;i:23142904;i:183;i:23142905;i:184;i:23142906;i:185;i:23142907;i:186;i:23142908;i:187;i:23142909;i:188;i:23142910;i:189;i:23142911;i:190;i:23142912;i:191;i:23142913;i:192;i:23142914;i:193;i:23142915;i:194;i:23142916;i:195;i:23142917;i:196;i:23142918;i:197;i:23142919;i:198;i:23142920;i:199;i:23142921;i:200;i:23142922;i:201;i:23142923;i:202;i:23142924;i:203;i:23142925;i:204;i:23483697;i:205;i:23483698;i:206;i:23483699;i:207;i:23483700;i:208;i:23483701;i:209;i:23483702;i:210;i:23483703;i:211;i:23483704;i:212;i:23483705;i:213;i:23483706;i:214;i:23483707;i:215;i:23483708;i:216;i:23483709;i:217;i:23483710;i:218;i:23483711;i:219;i:23483712;i:220;i:23483713;}"
}
["rets_street_view_param"]=>
array(1) {
[0]=>
string(64) "1$21.272353$-157.821618$349.12$13.33$1.00$P_uQAcpY3DiZPg5X4Rg73Q"
}
["rets_virtual_tour_url_unbranded"]=>
array(1) {
[0]=>
string(69) "https://app.immoviewer.com/landing/unbranded/62cfe46fe5b7aa0aadf6e4c6"
}
["virtual_tour"]=>
array(1) {
[0]=>
string(69) "https://app.immoviewer.com/landing/unbranded/62cfe46fe5b7aa0aadf6e4c6"
}
["rets_price_change_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-07-26T19:01:15.880"
}
["rets_active_continue_to_show_date"]=>
array(1) {
[0]=>
string(10) "2022-08-23"
}
["rets_close_date"]=>
array(1) {
[0]=>
string(10) "2022-09-28"
}
["rets_close_price"]=>
array(1) {
[0]=>
string(9) "510000.00"
}
["rets_expiration_date"]=>
array(1) {
[0]=>
string(10) "2022-11-01"
}
["rets_off_market_date"]=>
array(1) {
[0]=>
string(10) "2022-09-28"
}
["rets_selling_agent_direct_work_phone"]=>
array(1) {
[0]=>
string(14) "(808) 518-3429"
}
["rets_selling_agent_email"]=>
array(1) {
[0]=>
string(25) "jeffrey.haynes@redfin.com"
}
["rets_selling_agent_full_name"]=>
array(1) {
[0]=>
string(16) "Jeffrey R Haynes"
}
["rets_selling_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "48320"
}
["rets_selling_agent_mui"]=>
array(1) {
[0]=>
string(8) "12539399"
}
["rets_selling_office_mlsid"]=>
array(1) {
[0]=>
string(4) "RFIN"
}
["rets_selling_office_mui"]=>
array(1) {
[0]=>
string(7) "9626004"
}
["rets_selling_office_name"]=>
array(1) {
[0]=>
string(18) "Redfin Corporation"
}
["rets_selling_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 518-3429"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "23483697"
}
}
Array
(
[assd_val_imprv] => Array
(
[0] => 305200.00
)
[assd_val_land] => Array
(
[0] => 42000.00
)
[assd_val_total] => Array
(
[0] => 347200.00
)
[bedrooms] => Array
(
[0] => 1
)
[building_name] => Array
(
[0] => Tradewinds Plaza
)
[building_style] => Array
(
[0] => High-Rise 7+ Stories
)
[city] => Array
(
[0] => Honolulu
)
[county] => Array
(
[0] => Oahu
)
[disclosures] => Array
(
[0] => None
)
[exclusions] => Array
(
[0] => Other
)
[floor_covering] => Array
(
[0] => Ceramic Tile,Laminate
)
[full_baths] => Array
(
[0] => 1
)
[furnished] => Array
(
[0] => Partial
)
[half_baths] => Array
(
[0] => 0
)
[home_exampt] => Array
(
[0] => 140000
)
[lanai_sf] => Array
(
[0] => 148
)
[land_area_sf] => Array
(
[0] => 10019.00
)
[land_recorded] => Array
(
[0] => Regular System
)
[land_tenure] => Array
(
[0] => FS - Fee Simple
)
[list_agent_email] => Array
(
[0] => neil@pacific-oasis.com
)
[list_agent_name] => Array
(
[0] => Neil Bates
)
[list_agent_phone_number] => Array
(
[0] => (808) 778-3275
)
[list_date] => Array
(
[0] => 2022-07-09
)
[list_office_name] => Array
(
[0] => Pacific Oasis Realty, LLC
)
[list_price] => Array
(
[0] => 547000.00
)
[living_sf] => Array
(
[0] => 667
)
[location] => Array
(
[0] => 2572 Lemon Road Unit 605, Honolulu, HI 96815
)
[maintenance_fees] => Array
(
[0] => 703.00
)
[mls_] => Array
(
[0] => 202213176
)
[neighborhood] => Array
(
[0] => WAIKIKI
)
[number_of_parking_spaces] => Array
(
[0] => 1
)
[number_of_stories] => Array
(
[0] => One
)
[office_mls_id] => Array
(
[0] => HKNY
)
[parking_features] => Array
(
[0] => Covered - 1,Guest,Open - 1
)
[possession] => Array
(
[0] => 45 Days or More
)
[postal_code] => Array
(
[0] => 96815
)
[property_condition] => Array
(
[0] => Excellent
)
[property_type] => Array
(
[0] => condo_townhouse
)
[property_type_label] => Array
(
[0] => Condo Townhouse
)
[region] => Array
(
[0] => Metro
)
[rets_association_fee_total] => Array
(
[0] => 703
)
[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] => Tradewinds Plaza
)
[rets_city] => Array
(
[0] => Honolulu
)
[rets_condo_parking_unit] => Array
(
[0] => FCFS - ask.
)
[rets_current_price] => Array
(
[0] => 510000.00
)
[rets_dom] => Array
(
[0] => 46
)
[rets_dual_variable_compensation_yn] => Array
(
[0] => 0
)
[rets_elevators_number_of] => Array
(
[0] => 1
)
[rets_floor_number] => Array
(
[0] => 6
)
[rets_foreclosure_yn] => Array
(
[0] => 0
)
[rets_fractional_ownership_yn] => Array
(
[0] => 0
)
[rets_id] => Array
(
[0] => 16753313
)
[rets_immoviewer_yn] => Array
(
[0] => 1
)
[rets_internet_automated_valuation_dis] => Array
(
[0] => 1
)
[rets_internet_consumer_comment_yn] => Array
(
[0] => 1
)
[rets_list_agent_direct_work_phone] => Array
(
[0] => (808) 778-3275
)
[rets_list_agent_email] => Array
(
[0] => neil@pacific-oasis.com
)
[rets_list_agent_full_name] => Array
(
[0] => Neil Bates
)
[rets_list_agent_mlsid] => Array
(
[0] => 23290
)
[rets_list_agent_mui] => Array
(
[0] => 3474629
)
[rets_list_office_mlsid] => Array
(
[0] => HKNY
)
[rets_list_office_mui] => Array
(
[0] => 3486768
)
[rets_list_office_name] => Array
(
[0] => Pacific Oasis Realty, LLC
)
[rets_list_office_phone] => Array
(
[0] => (808) 778-3275
)
[rets_list_price] => Array
(
[0] => 547000.00
)
[rets_listing_contract_date] => Array
(
[0] => 2022-07-09
)
[rets_lot_size_area] => Array
(
[0] => 10019.00
)
[rets_maintenance_expense] => Array
(
[0] => 703.00
)
[rets_management_company_name] => Array
(
[0] => touchstone
)
[rets_management_company_phone] => Array
(
[0] => 8085664100
)
[rets_matrix_modified_dt] => Array
(
[0] => 2022-09-29T17:40:48.953
)
[rets_matrix_unique_id] => Array
(
[0] => 16753313
)
[rets_mls_number] => Array
(
[0] => 202213176
)
[rets_neighbourhood] => Array
(
[0] => WAIKIKI
)
[rets_new_development_construction_yn] => Array
(
[0] => 0
)
[rets_original_entry_timestamp] => Array
(
[0] => 2022-07-09T19:02:08.733
)
[rets_original_list_price] => Array
(
[0] => 627000.00
)
[rets_owner_occupancy_percentage] => Array
(
[0] => 16
)
[rets_parcel_number] => Array
(
[0] => 1-2-6-027-020-0045
)
[rets_parking_additional] => Array
(
[0] => 23
)
[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] => 17
)
[rets_photo_modification_timestamp] => Array
(
[0] => 2022-07-09T19:02:08.733
)
[rets_postal_code] => Array
(
[0] => 96815
)
[rets_primary_key] => Array
(
[0] => 16753313
)
[rets_private_remarks] => Array
(
[0] => Building does not allow lockboxes. lockbox at nearby building. Please include signed short term rental disclosure statement with offers. Allow 2 days for response. 23 FCFS (first come first serve) parking stalls on upper deck. 27 privately owned parking stalls on lower deck. Want to purchase a private stall - please ask. Please use Brandon Choi - Title Guaranty King. Accepting backup offers.
Your client will love the unit, the building and the location.
)
[rets_public_remarks] => Array
(
[0] => Boutique building with rare, upgraded, large 1 bedroom with livable lanai - steps to beach, park, zoo. Owner/resident maintained with tender care. Parking is first come first serve for all residents. Not guaranteed all residents will find a stall. Please inquire. LEGAL zoning for vacation rental/airbnb - even with new Honolulu ordinance. Secure, well maintained, clean building. Coin laundry. Resident manager lives in blg. You will LOVE the location, love the lanai. Electric, hot water, cable included in maint. fee. 2 ACs. Wide open kitchen/entertaining dining/living area (granite counter tops). Peek of the ocean thru the coconut trees between buildings. This is the BEST end of Waikiki; easy in/out to building. Walk the park in the mornings/evenings. Parades. Living in paradise. Rich, beautiful flooring, luxurious walk in shower enclosure, marble floored bath, tiled lanai.
)
[rets_sqft_lanai_open] => Array
(
[0] => 148
)
[rets_sqft_roofed_living] => Array
(
[0] => 519
)
[rets_sqft_total] => Array
(
[0] => 667
)
[rets_state_or_province] => Array
(
[0] => HI
)
[rets_status_change_timestamp] => Array
(
[0] => 2022-09-29T17:40:48.953
)
[rets_status_contractual_search_date] => Array
(
[0] => 2022-09-28
)
[rets_street_name] => Array
(
[0] => Lemon
)
[rets_street_number] => Array
(
[0] => 2572
)
[rets_sub_agency_compensation] => Array
(
[0] => 2.5%
)
[rets_supplement_count] => Array
(
[0] => 1
)
[rets_supplement_modification_timestam] => Array
(
[0] => 2022-07-09T12:20:18.633
)
[rets_tax_amount] => Array
(
[0] => 86.00
)
[rets_tax_annual_amount] => Array
(
[0] => 1032.00
)
[rets_tax_assessed_value] => Array
(
[0] => 347200.00
)
[rets_tax_assessed_value_improvements] => Array
(
[0] => 305200.00
)
[rets_tax_assessed_value_land] => Array
(
[0] => 42000.00
)
[rets_tax_excemption_owner_occupancy] => Array
(
[0] => 140000
)
[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/16753313/52e8c5af1e1cd09bcd29135282dee3a6
)
[rets_tmk_area] => Array
(
[0] => 126
)
[rets_tmk_condo_property_regime_number] => Array
(
[0] => 45
)
[rets_tmk_division] => Array
(
[0] => 1
)
[rets_tmk_parcel] => Array
(
[0] => 20
)
[rets_tmk_section] => Array
(
[0] => 6
)
[rets_tmk_zone] => Array
(
[0] => 2
)
[rets_tmkplat] => Array
(
[0] => 27
)
[rets_unit_number] => Array
(
[0] => 605
)
[rets_year_built] => Array
(
[0] => 1979
)
[rets_year_remodeled] => Array
(
[0] => 2017
)
[security] => Array
(
[0] => Card,Gated Community
)
[state_or_province] => Array
(
[0] => HI
)
[status] => Array
(
[0] => Sold
)
[street_name] => Array
(
[0] => Lemon
)
[street_number] => Array
(
[0] => 2572
)
[street_suffix] => Array
(
[0] => Road
)
[terms_accept] => Array
(
[0] => Cash,Conventional
)
[tmk] => Array
(
[0] => 1-2-6-027-020-0045
)
[unit] => Array
(
[0] => Bedroom on 1st Level,Storage
)
[unit_number] => Array
(
[0] => 605
)
[view] => Array
(
[0] => Ocean
)
[wpp::rets_pk] => Array
(
[0] => 16753313
)
[wpp_gpid] => Array
(
[0] => 202213176
)
[wpp_import_schedule_id] => Array
(
[0] => 1463343682
)
[wpp_import_time] => Array
(
[0] => 1664509318
)
[year_built] => Array
(
[0] => 1979
)
[year_remodeled_] => Array
(
[0] => 2017
)
[zoning] => Array
(
[0] => X6 - Resort Mixed Use Precinct
)
[new_attached_media] => Array
(
[0] => a:221:{i:0;i:22675237;i:1;i:22675238;i:2;i:22675239;i:3;i:22675240;i:4;i:22675241;i:5;i:22675242;i:6;i:22675243;i:7;i:22675244;i:8;i:22675245;i:9;i:22675246;i:10;i:22675247;i:11;i:22675248;i:12;i:22675249;i:13;i:22675250;i:14;i:22675251;i:15;i:22675252;i:16;i:22675253;i:17;i:22677709;i:18;i:22677710;i:19;i:22677711;i:20;i:22677712;i:21;i:22677713;i:22;i:22677714;i:23;i:22677715;i:24;i:22677716;i:25;i:22677717;i:26;i:22677718;i:27;i:22677719;i:28;i:22677720;i:29;i:22677721;i:30;i:22677722;i:31;i:22677723;i:32;i:22677724;i:33;i:22677725;i:34;i:22694777;i:35;i:22694778;i:36;i:22694779;i:37;i:22694780;i:38;i:22694781;i:39;i:22694782;i:40;i:22694783;i:41;i:22694784;i:42;i:22694785;i:43;i:22694786;i:44;i:22694787;i:45;i:22694788;i:46;i:22694789;i:47;i:22694790;i:48;i:22694791;i:49;i:22694792;i:50;i:22694793;i:51;i:22694871;i:52;i:22694872;i:53;i:22694873;i:54;i:22694874;i:55;i:22694875;i:56;i:22694876;i:57;i:22694877;i:58;i:22694878;i:59;i:22694879;i:60;i:22694880;i:61;i:22694881;i:62;i:22694882;i:63;i:22694883;i:64;i:22694884;i:65;i:22694885;i:66;i:22694886;i:67;i:22694887;i:68;i:22847761;i:69;i:22847762;i:70;i:22847763;i:71;i:22847764;i:72;i:22847765;i:73;i:22847766;i:74;i:22847767;i:75;i:22847768;i:76;i:22847769;i:77;i:22847770;i:78;i:22847771;i:79;i:22847772;i:80;i:22847773;i:81;i:22847774;i:82;i:22847775;i:83;i:22847776;i:84;i:22847777;i:85;i:22857969;i:86;i:22857970;i:87;i:22857971;i:88;i:22857972;i:89;i:22857973;i:90;i:22857974;i:91;i:22857975;i:92;i:22857976;i:93;i:22857977;i:94;i:22857978;i:95;i:22857979;i:96;i:22857980;i:97;i:22857981;i:98;i:22857982;i:99;i:22857983;i:100;i:22857984;i:101;i:22857985;i:102;i:22858358;i:103;i:22858359;i:104;i:22858360;i:105;i:22858361;i:106;i:22858362;i:107;i:22858363;i:108;i:22858364;i:109;i:22858365;i:110;i:22858366;i:111;i:22858367;i:112;i:22858368;i:113;i:22858369;i:114;i:22858370;i:115;i:22858371;i:116;i:22858372;i:117;i:22858373;i:118;i:22858374;i:119;i:22858652;i:120;i:22858653;i:121;i:22858654;i:122;i:22858655;i:123;i:22858656;i:124;i:22858657;i:125;i:22858658;i:126;i:22858659;i:127;i:22858660;i:128;i:22858661;i:129;i:22858662;i:130;i:22858663;i:131;i:22858664;i:132;i:22858665;i:133;i:22858666;i:134;i:22858667;i:135;i:22858668;i:136;i:22928958;i:137;i:22928959;i:138;i:22928960;i:139;i:22928961;i:140;i:22928962;i:141;i:22928963;i:142;i:22928964;i:143;i:22928965;i:144;i:22928966;i:145;i:22928967;i:146;i:22928968;i:147;i:22928969;i:148;i:22928970;i:149;i:22928971;i:150;i:22928972;i:151;i:22928973;i:152;i:22928974;i:153;i:23074946;i:154;i:23074947;i:155;i:23074948;i:156;i:23074949;i:157;i:23074950;i:158;i:23074951;i:159;i:23074952;i:160;i:23074953;i:161;i:23074954;i:162;i:23074955;i:163;i:23074956;i:164;i:23074957;i:165;i:23074958;i:166;i:23074959;i:167;i:23074960;i:168;i:23074961;i:169;i:23074962;i:170;i:23142892;i:171;i:23142893;i:172;i:23142894;i:173;i:23142895;i:174;i:23142896;i:175;i:23142897;i:176;i:23142898;i:177;i:23142899;i:178;i:23142900;i:179;i:23142901;i:180;i:23142902;i:181;i:23142903;i:182;i:23142904;i:183;i:23142905;i:184;i:23142906;i:185;i:23142907;i:186;i:23142908;i:187;i:23142909;i:188;i:23142910;i:189;i:23142911;i:190;i:23142912;i:191;i:23142913;i:192;i:23142914;i:193;i:23142915;i:194;i:23142916;i:195;i:23142917;i:196;i:23142918;i:197;i:23142919;i:198;i:23142920;i:199;i:23142921;i:200;i:23142922;i:201;i:23142923;i:202;i:23142924;i:203;i:23142925;i:204;i:23483697;i:205;i:23483698;i:206;i:23483699;i:207;i:23483700;i:208;i:23483701;i:209;i:23483702;i:210;i:23483703;i:211;i:23483704;i:212;i:23483705;i:213;i:23483706;i:214;i:23483707;i:215;i:23483708;i:216;i:23483709;i:217;i:23483710;i:218;i:23483711;i:219;i:23483712;i:220;i:23483713;}
)
[rets_street_view_param] => Array
(
[0] => 1$21.272353$-157.821618$349.12$13.33$1.00$P_uQAcpY3DiZPg5X4Rg73Q
)
[rets_virtual_tour_url_unbranded] => Array
(
[0] => https://app.immoviewer.com/landing/unbranded/62cfe46fe5b7aa0aadf6e4c6
)
[virtual_tour] => Array
(
[0] => https://app.immoviewer.com/landing/unbranded/62cfe46fe5b7aa0aadf6e4c6
)
[rets_price_change_timestamp] => Array
(
[0] => 2022-07-26T19:01:15.880
)
[rets_active_continue_to_show_date] => Array
(
[0] => 2022-08-23
)
[rets_close_date] => Array
(
[0] => 2022-09-28
)
[rets_close_price] => Array
(
[0] => 510000.00
)
[rets_expiration_date] => Array
(
[0] => 2022-11-01
)
[rets_off_market_date] => Array
(
[0] => 2022-09-28
)
[rets_selling_agent_direct_work_phone] => Array
(
[0] => (808) 518-3429
)
[rets_selling_agent_email] => Array
(
[0] => jeffrey.haynes@redfin.com
)
[rets_selling_agent_full_name] => Array
(
[0] => Jeffrey R Haynes
)
[rets_selling_agent_mlsid] => Array
(
[0] => 48320
)
[rets_selling_agent_mui] => Array
(
[0] => 12539399
)
[rets_selling_office_mlsid] => Array
(
[0] => RFIN
)
[rets_selling_office_mui] => Array
(
[0] => 9626004
)
[rets_selling_office_name] => Array
(
[0] => Redfin Corporation
)
[rets_selling_office_phone] => Array
(
[0] => (808) 518-3429
)
[_thumbnail_id] => Array
(
[0] => 23483697
)
)
CONTACT US
#RB-7120
info@marcushawaii.com
(808)839-7446