Only apartment at the Esplanade with exclusive Koi Pond and Waterfall frontage. Garden apartment with direct access to Luna Kai Marina Park and view of the Marina. Tiled 600 square-foot patio. Travertine tiles throughout. Original condition except for some improvements in the kitchen which include counter tops, new range and microwave. Good quality appliances. New ceiling fans. Central air conditioner purchased in 2019. Two assigned, covered parking stalls and 4 storage lockers. Sold AS IS.
Listing by: Nagwa Saas
array(164) {
["assd_val_imprv"]=>
array(1) {
[0]=>
string(9) "505300.00"
}
["assd_val_land"]=>
array(1) {
[0]=>
string(9) "172200.00"
}
["assd_val_total"]=>
array(1) {
[0]=>
string(9) "677500.00"
}
["bedrooms"]=>
array(1) {
[0]=>
string(1) "2"
}
["building_name"]=>
array(1) {
[0]=>
string(9) "Esplanade"
}
["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(58) "Pets Allowed (Verify),Property Disclosure Stmt,See Remarks"
}
["elementary_school"]=>
array(1) {
[0]=>
string(9) "Koko Head"
}
["floor_covering"]=>
array(1) {
[0]=>
string(5) "Other"
}
["frontage"]=>
array(1) {
[0]=>
string(22) "Lake/Pond,Marina,Other"
}
["full_baths"]=>
array(1) {
[0]=>
string(1) "2"
}
["half_baths"]=>
array(1) {
[0]=>
string(1) "0"
}
["high_school"]=>
array(1) {
[0]=>
string(6) "Kaiser"
}
["home_exampt"]=>
array(1) {
[0]=>
string(6) "100000"
}
["lanai_sf"]=>
array(1) {
[0]=>
string(3) "616"
}
["land_area_sf"]=>
array(1) {
[0]=>
string(9) "205821.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(20) "nagwa@alohahomes.biz"
}
["list_agent_name"]=>
array(1) {
[0]=>
string(10) "Nagwa Saas"
}
["list_agent_phone_number"]=>
array(1) {
[0]=>
string(14) "(808) 395-6827"
}
["list_date"]=>
array(1) {
[0]=>
string(10) "2022-03-28"
}
["list_office_name"]=>
array(1) {
[0]=>
string(10) "Nagwa Saas"
}
["list_price"]=>
array(1) {
[0]=>
string(9) "885000.00"
}
["living_sf"]=>
array(1) {
[0]=>
string(4) "1818"
}
["location"]=>
array(1) {
[0]=>
string(51) "500 Lunalilo Home Road Unit 21D, Honolulu, HI 96825"
}
["maintenance_fees"]=>
array(1) {
[0]=>
string(6) "948.00"
}
["middle_school"]=>
array(1) {
[0]=>
string(10) "Niu Valley"
}
["mls_"]=>
array(1) {
[0]=>
string(9) "202205794"
}
["neighborhood"]=>
array(1) {
[0]=>
string(11) "WEST MARINA"
}
["number_of_parking_spaces"]=>
array(1) {
[0]=>
string(1) "2"
}
["office_mls_id"]=>
array(1) {
[0]=>
string(4) "SAAS"
}
["parking_features"]=>
array(1) {
[0]=>
string(20) "Assigned,Covered - 2"
}
["possession"]=>
array(1) {
[0]=>
string(10) "At Closing"
}
["postal_code"]=>
array(1) {
[0]=>
string(5) "96825"
}
["property_condition"]=>
array(1) {
[0]=>
string(7) "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(9) "HawaiiKai"
}
["rets_association_fee_total"]=>
array(1) {
[0]=>
string(4) "1005"
}
["rets_baths_full"]=>
array(1) {
[0]=>
string(1) "2"
}
["rets_baths_half"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_baths_total"]=>
array(1) {
[0]=>
string(4) "2.00"
}
["rets_beds_total"]=>
array(1) {
[0]=>
string(1) "2"
}
["rets_building_name"]=>
array(1) {
[0]=>
string(9) "Esplanade"
}
["rets_city"]=>
array(1) {
[0]=>
string(8) "Honolulu"
}
["rets_condo_parking_unit"]=>
array(1) {
[0]=>
string(5) "68-69"
}
["rets_current_price"]=>
array(1) {
[0]=>
string(9) "880000.00"
}
["rets_dom"]=>
array(1) {
[0]=>
string(3) "130"
}
["rets_dual_variable_compensation_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_elementary_school"]=>
array(1) {
[0]=>
string(9) "Koko Head"
}
["rets_elevators_number_of"]=>
array(1) {
[0]=>
string(1) "7"
}
["rets_floor_number"]=>
array(1) {
[0]=>
string(1) "1"
}
["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(6) "Kaiser"
}
["rets_id"]=>
array(1) {
[0]=>
string(8) "16533022"
}
["rets_immoviewer_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["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) 395-6827"
}
["rets_list_agent_email"]=>
array(1) {
[0]=>
string(20) "nagwa@alohahomes.biz"
}
["rets_list_agent_full_name"]=>
array(1) {
[0]=>
string(10) "Nagwa Saas"
}
["rets_list_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "00027"
}
["rets_list_agent_mui"]=>
array(1) {
[0]=>
string(7) "8842358"
}
["rets_list_office_mlsid"]=>
array(1) {
[0]=>
string(4) "SAAS"
}
["rets_list_office_mui"]=>
array(1) {
[0]=>
string(7) "3485694"
}
["rets_list_office_name"]=>
array(1) {
[0]=>
string(10) "Nagwa Saas"
}
["rets_list_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 395-6827"
}
["rets_list_price"]=>
array(1) {
[0]=>
string(9) "885000.00"
}
["rets_listing_contract_date"]=>
array(1) {
[0]=>
string(10) "2022-03-28"
}
["rets_lot_size_area"]=>
array(1) {
[0]=>
string(9) "205821.00"
}
["rets_maintenance_expense"]=>
array(1) {
[0]=>
string(6) "948.00"
}
["rets_management_company_name"]=>
array(1) {
[0]=>
string(10) "Touchstone"
}
["rets_management_company_phone"]=>
array(1) {
[0]=>
string(12) "808-566-1400"
}
["rets_matrix_modified_dt"]=>
array(1) {
[0]=>
string(23) "2022-09-28T10:38:13.283"
}
["rets_matrix_unique_id"]=>
array(1) {
[0]=>
string(8) "16533022"
}
["rets_middle_or_junior_school"]=>
array(1) {
[0]=>
string(10) "Niu Valley"
}
["rets_mls_number"]=>
array(1) {
[0]=>
string(9) "202205794"
}
["rets_neighbourhood"]=>
array(1) {
[0]=>
string(11) "WEST MARINA"
}
["rets_new_development_construction_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_original_entry_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-03-28T13:34:08.493"
}
["rets_original_list_price"]=>
array(1) {
[0]=>
string(9) "897000.00"
}
["rets_owner_occupancy_percentage"]=>
array(1) {
[0]=>
string(2) "73"
}
["rets_parcel_number"]=>
array(1) {
[0]=>
string(18) "1-3-9-008-009-0069"
}
["rets_parking_additional"]=>
array(1) {
[0]=>
string(2) "12"
}
["rets_parking_total"]=>
array(1) {
[0]=>
string(1) "2"
}
["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) "18"
}
["rets_photo_modification_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-07-05T12:32:48.283"
}
["rets_postal_code"]=>
array(1) {
[0]=>
string(5) "96825"
}
["rets_price_change_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-06-24T13:40:14.153"
}
["rets_primary_key"]=>
array(1) {
[0]=>
string(8) "16533022"
}
["rets_private_remarks"]=>
array(1) {
[0]=>
string(364) "4% Commission to Buyer's broker if in escrow by August 31. 2022. Vacant and easy to show with lockbox. Please do not call listor for showings, make all showing requests through Showing time. Please use Barbara Paulo at TG as she helped with the estate, provided necessary documents to the estate representative and did the previous escrow before it fell through."
}
["rets_public_remarks"]=>
array(1) {
[0]=>
string(497) "Only apartment at the Esplanade with exclusive Koi Pond and Waterfall frontage. Garden apartment with direct access to Luna Kai Marina Park and view of the Marina. Tiled 600 square-foot patio. Travertine tiles throughout. Original condition except for some improvements in the kitchen which include counter tops, new range and microwave. Good quality appliances. New ceiling fans. Central air conditioner purchased in 2019. Two assigned, covered parking stalls and 4 storage lockers. Sold AS IS."
}
["rets_sqft_lanai_open"]=>
array(1) {
[0]=>
string(3) "616"
}
["rets_sqft_roofed_living"]=>
array(1) {
[0]=>
string(4) "1202"
}
["rets_sqft_total"]=>
array(1) {
[0]=>
string(4) "1818"
}
["rets_state_or_province"]=>
array(1) {
[0]=>
string(2) "HI"
}
["rets_status_change_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-09-28T10:38:13.283"
}
["rets_status_contractual_search_date"]=>
array(1) {
[0]=>
string(10) "2022-09-28"
}
["rets_street_name"]=>
array(1) {
[0]=>
string(13) "Lunalilo Home"
}
["rets_street_number"]=>
array(1) {
[0]=>
string(3) "500"
}
["rets_street_view_param"]=>
array(1) {
[0]=>
string(63) "1$21.285055$-157.69889$267.36$13.33$1.00$PxyJmW-XL2DyUVpyY84rNA"
}
["rets_sub_agency_compensation"]=>
array(1) {
[0]=>
string(2) "4%"
}
["rets_tax_amount"]=>
array(1) {
[0]=>
string(6) "157.00"
}
["rets_tax_annual_amount"]=>
array(1) {
[0]=>
string(7) "1884.00"
}
["rets_tax_assessed_value"]=>
array(1) {
[0]=>
string(9) "677500.00"
}
["rets_tax_assessed_value_improvements"]=>
array(1) {
[0]=>
string(9) "505300.00"
}
["rets_tax_assessed_value_land"]=>
array(1) {
[0]=>
string(9) "172200.00"
}
["rets_tax_excemption_owner_occupancy"]=>
array(1) {
[0]=>
string(6) "100000"
}
["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/16533022/77aa8717f9665a1dafebbb39ebfa4cc8"
}
["rets_tmk_area"]=>
array(1) {
[0]=>
string(3) "139"
}
["rets_tmk_condo_property_regime_number"]=>
array(1) {
[0]=>
string(2) "69"
}
["rets_tmk_division"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_tmk_parcel"]=>
array(1) {
[0]=>
string(1) "9"
}
["rets_tmk_section"]=>
array(1) {
[0]=>
string(1) "9"
}
["rets_tmk_zone"]=>
array(1) {
[0]=>
string(1) "3"
}
["rets_tmkplat"]=>
array(1) {
[0]=>
string(1) "8"
}
["rets_unit_number"]=>
array(1) {
[0]=>
string(3) "21D"
}
["rets_year_built"]=>
array(1) {
[0]=>
string(4) "1973"
}
["security"]=>
array(1) {
[0]=>
string(36) "Keyed Elevator,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(13) "Lunalilo Home"
}
["street_number"]=>
array(1) {
[0]=>
string(3) "500"
}
["street_suffix"]=>
array(1) {
[0]=>
string(4) "Road"
}
["terms_accept"]=>
array(1) {
[0]=>
string(17) "Cash,Conventional"
}
["tmk"]=>
array(1) {
[0]=>
string(18) "1-3-9-008-009-0069"
}
["unit"]=>
array(1) {
[0]=>
string(62) "Central AC,Corner/End,Ground Floor Unit,Odd# Unit,Single Level"
}
["unit_number"]=>
array(1) {
[0]=>
string(3) "21D"
}
["view"]=>
array(1) {
[0]=>
string(35) "Garden,Marina/Canal,Mountain,Sunset"
}
["wpp::rets_pk"]=>
array(1) {
[0]=>
string(8) "16533022"
}
["wpp_gpid"]=>
array(1) {
[0]=>
string(9) "202205794"
}
["wpp_import_schedule_id"]=>
array(1) {
[0]=>
string(10) "1463343682"
}
["wpp_import_time"]=>
array(1) {
[0]=>
string(10) "1664397549"
}
["year_built"]=>
array(1) {
[0]=>
string(4) "1973"
}
["zoning"]=>
array(1) {
[0]=>
string(31) "12 - A-2 Medium Density Apartme"
}
["new_attached_media"]=>
array(1) {
[0]=>
string(6562) "a:392:{i:0;i:21906720;i:1;i:21906721;i:2;i:21906722;i:3;i:21906723;i:4;i:21906724;i:5;i:21906725;i:6;i:21906726;i:7;i:21906727;i:8;i:21906728;i:9;i:21906729;i:10;i:21906730;i:11;i:21906731;i:12;i:21906732;i:13;i:21906733;i:14;i:21906734;i:15;i:21906735;i:16;i:21906736;i:17;i:21906737;i:18;i:21907894;i:19;i:21907895;i:20;i:21907896;i:21;i:21907897;i:22;i:21907898;i:23;i:21907899;i:24;i:21907900;i:25;i:21907901;i:26;i:21907902;i:27;i:21907903;i:28;i:21907904;i:29;i:21907905;i:30;i:21907906;i:31;i:21907907;i:32;i:21907908;i:33;i:21907909;i:34;i:21907910;i:35;i:21907911;i:36;i:21944068;i:37;i:21944069;i:38;i:21944070;i:39;i:21944071;i:40;i:21944072;i:41;i:21944073;i:42;i:21944074;i:43;i:21944075;i:44;i:21944076;i:45;i:21944077;i:46;i:21944078;i:47;i:21944079;i:48;i:21944080;i:49;i:21944081;i:50;i:21944082;i:51;i:21944083;i:52;i:21944084;i:53;i:21944085;i:54;i:22015984;i:55;i:22015985;i:56;i:22015986;i:57;i:22015987;i:58;i:22015988;i:59;i:22015989;i:60;i:22015990;i:61;i:22015991;i:62;i:22015992;i:63;i:22015993;i:64;i:22015994;i:65;i:22015995;i:66;i:22015996;i:67;i:22015997;i:68;i:22015998;i:69;i:22015999;i:70;i:22016000;i:71;i:22016001;i:72;i:22058538;i:73;i:22058539;i:74;i:22058540;i:75;i:22058541;i:76;i:22058542;i:77;i:22058543;i:78;i:22058544;i:79;i:22058545;i:80;i:22058546;i:81;i:22058547;i:82;i:22058548;i:83;i:22058549;i:84;i:22058550;i:85;i:22058551;i:86;i:22058552;i:87;i:22058553;i:88;i:22058554;i:89;i:22058555;i:90;i:22095250;i:91;i:22095251;i:92;i:22095252;i:93;i:22095253;i:94;i:22095254;i:95;i:22095255;i:96;i:22095256;i:97;i:22095257;i:98;i:22095258;i:99;i:22095259;i:100;i:22095260;i:101;i:22095261;i:102;i:22095262;i:103;i:22095263;i:104;i:22095264;i:105;i:22095265;i:106;i:22095266;i:107;i:22095267;i:108;i:22095306;i:109;i:22095307;i:110;i:22095308;i:111;i:22095309;i:112;i:22095310;i:113;i:22095311;i:114;i:22095312;i:115;i:22095313;i:116;i:22095314;i:117;i:22095315;i:118;i:22095316;i:119;i:22095317;i:120;i:22095318;i:121;i:22095319;i:122;i:22095320;i:123;i:22095321;i:124;i:22095322;i:125;i:22095323;i:126;i:22123210;i:127;i:22123211;i:128;i:22123212;i:129;i:22123213;i:130;i:22123214;i:131;i:22123215;i:132;i:22123216;i:133;i:22123217;i:134;i:22123218;i:135;i:22123219;i:136;i:22123220;i:137;i:22123221;i:138;i:22123222;i:139;i:22123223;i:140;i:22123224;i:141;i:22123225;i:142;i:22123226;i:143;i:22123227;i:144;i:22226146;i:145;i:22226147;i:146;i:22226148;i:147;i:22226149;i:148;i:22226150;i:149;i:22226151;i:150;i:22226152;i:151;i:22226153;i:152;i:22226154;i:153;i:22226155;i:154;i:22226156;i:155;i:22226157;i:156;i:22226158;i:157;i:22226159;i:158;i:22226160;i:159;i:22226161;i:160;i:22226162;i:161;i:22226163;i:162;i:22226164;i:163;i:22226165;i:164;i:22226166;i:165;i:22226167;i:166;i:22226168;i:167;i:22226169;i:168;i:22226170;i:169;i:22226171;i:170;i:22226172;i:171;i:22226173;i:172;i:22226174;i:173;i:22226175;i:174;i:22226176;i:175;i:22226177;i:176;i:22226178;i:177;i:22226179;i:178;i:22226180;i:179;i:22226181;i:180;i:22448624;i:181;i:22448625;i:182;i:22448626;i:183;i:22448627;i:184;i:22448628;i:185;i:22448629;i:186;i:22448630;i:187;i:22448631;i:188;i:22448632;i:189;i:22448633;i:190;i:22448634;i:191;i:22448635;i:192;i:22448636;i:193;i:22448637;i:194;i:22448638;i:195;i:22448639;i:196;i:22448640;i:197;i:22448641;i:198;i:22535290;i:199;i:22535291;i:200;i:22535292;i:201;i:22535293;i:202;i:22535294;i:203;i:22535295;i:204;i:22535296;i:205;i:22535297;i:206;i:22535298;i:207;i:22535299;i:208;i:22535300;i:209;i:22535301;i:210;i:22535302;i:211;i:22535303;i:212;i:22535304;i:213;i:22535305;i:214;i:22535306;i:215;i:22535307;i:216;i:22629399;i:217;i:22629400;i:218;i:22629401;i:219;i:22629402;i:220;i:22629403;i:221;i:22629404;i:222;i:22629405;i:223;i:22629406;i:224;i:22629407;i:225;i:22629408;i:226;i:22629409;i:227;i:22629410;i:228;i:22629411;i:229;i:22629412;i:230;i:22629413;i:231;i:22629414;i:232;i:22629415;i:233;i:22629562;i:234;i:22629563;i:235;i:22629564;i:236;i:22629565;i:237;i:22629566;i:238;i:22629567;i:239;i:22629568;i:240;i:22629569;i:241;i:22629570;i:242;i:22629571;i:243;i:22629572;i:244;i:22629573;i:245;i:22629574;i:246;i:22629575;i:247;i:22629576;i:248;i:22629577;i:249;i:22629578;i:250;i:22629579;i:251;i:22630051;i:252;i:22630052;i:253;i:22630053;i:254;i:22630054;i:255;i:22630055;i:256;i:22630056;i:257;i:22630057;i:258;i:22630058;i:259;i:22630059;i:260;i:22630060;i:261;i:22630061;i:262;i:22630062;i:263;i:22630063;i:264;i:22630064;i:265;i:22630065;i:266;i:22630066;i:267;i:22630067;i:268;i:22630068;i:269;i:22651807;i:270;i:22651808;i:271;i:22651809;i:272;i:22651810;i:273;i:22651811;i:274;i:22651812;i:275;i:22651813;i:276;i:22651814;i:277;i:22651815;i:278;i:22651816;i:279;i:22651817;i:280;i:22651818;i:281;i:22651819;i:282;i:22651820;i:283;i:22651821;i:284;i:22651822;i:285;i:22651823;i:286;i:22651824;i:287;i:22651925;i:288;i:22651926;i:289;i:22651927;i:290;i:22651928;i:291;i:22651929;i:292;i:22651930;i:293;i:22651931;i:294;i:22651932;i:295;i:22651933;i:296;i:22651934;i:297;i:22651935;i:298;i:22651936;i:299;i:22651937;i:300;i:22651938;i:301;i:22651939;i:302;i:22680052;i:303;i:22680053;i:304;i:22680054;i:305;i:22680055;i:306;i:22680056;i:307;i:22680057;i:308;i:22680058;i:309;i:22680059;i:310;i:22680060;i:311;i:22680061;i:312;i:22680062;i:313;i:22680063;i:314;i:22680064;i:315;i:22680065;i:316;i:22680066;i:317;i:22680067;i:318;i:22680068;i:319;i:22680069;i:320;i:22989029;i:321;i:22989030;i:322;i:22989031;i:323;i:22989032;i:324;i:22989033;i:325;i:22989034;i:326;i:22989035;i:327;i:22989036;i:328;i:22989037;i:329;i:22989038;i:330;i:22989039;i:331;i:22989040;i:332;i:22989041;i:333;i:22989042;i:334;i:22989043;i:335;i:22989044;i:336;i:22989045;i:337;i:22989046;i:338;i:23070185;i:339;i:23070186;i:340;i:23070187;i:341;i:23070188;i:342;i:23070189;i:343;i:23070190;i:344;i:23070191;i:345;i:23070192;i:346;i:23070193;i:347;i:23070194;i:348;i:23070195;i:349;i:23070196;i:350;i:23070197;i:351;i:23070198;i:352;i:23070199;i:353;i:23070200;i:354;i:23070201;i:355;i:23070202;i:356;i:23333466;i:357;i:23333467;i:358;i:23333468;i:359;i:23333469;i:360;i:23333470;i:361;i:23333471;i:362;i:23333472;i:363;i:23333473;i:364;i:23333474;i:365;i:23333475;i:366;i:23333476;i:367;i:23333477;i:368;i:23333478;i:369;i:23333479;i:370;i:23333480;i:371;i:23333481;i:372;i:23333482;i:373;i:23333483;i:374;i:23467192;i:375;i:23467193;i:376;i:23467194;i:377;i:23467195;i:378;i:23467196;i:379;i:23467197;i:380;i:23467198;i:381;i:23467199;i:382;i:23467200;i:383;i:23467201;i:384;i:23467202;i:385;i:23467203;i:386;i:23467204;i:387;i:23467205;i:388;i:23467206;i:389;i:23467207;i:390;i:23467208;i:391;i:23467209;}"
}
["rets_active_continue_to_show_date"]=>
array(1) {
[0]=>
string(10) "2022-08-16"
}
["rets_open_house_count"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_active_open_house_count"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_open_house_upcoming"]=>
array(1) {
[0]=>
string(0) ""
}
["rets_association_fee_2"]=>
array(1) {
[0]=>
string(2) "57"
}
["rets_pending_date"]=>
array(1) {
[0]=>
string(10) "2022-08-16"
}
["rets_close_date"]=>
array(1) {
[0]=>
string(10) "2022-09-28"
}
["rets_close_price"]=>
array(1) {
[0]=>
string(9) "880000.00"
}
["rets_expiration_date"]=>
array(1) {
[0]=>
string(10) "2022-09-30"
}
["rets_off_market_date"]=>
array(1) {
[0]=>
string(10) "2022-09-28"
}
["rets_selling_agent_direct_work_phone"]=>
array(1) {
[0]=>
string(14) "(808) 439-8250"
}
["rets_selling_agent_email"]=>
array(1) {
[0]=>
string(13) "jreich@kw.com"
}
["rets_selling_agent_full_name"]=>
array(1) {
[0]=>
string(13) "Jamie L Reich"
}
["rets_selling_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "43837"
}
["rets_selling_agent_mui"]=>
array(1) {
[0]=>
string(7) "3483847"
}
["rets_selling_office_mlsid"]=>
array(1) {
[0]=>
string(6) "KWPP04"
}
["rets_selling_office_mui"]=>
array(1) {
[0]=>
string(8) "10703481"
}
["rets_selling_office_name"]=>
array(1) {
[0]=>
string(24) "Keller Williams Honolulu"
}
["rets_selling_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 439-8250"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "23467192"
}
}
Array
(
[assd_val_imprv] => Array
(
[0] => 505300.00
)
[assd_val_land] => Array
(
[0] => 172200.00
)
[assd_val_total] => Array
(
[0] => 677500.00
)
[bedrooms] => Array
(
[0] => 2
)
[building_name] => Array
(
[0] => Esplanade
)
[building_style] => Array
(
[0] => High-Rise 7+ Stories
)
[city] => Array
(
[0] => Honolulu
)
[county] => Array
(
[0] => Oahu
)
[disclosures] => Array
(
[0] => Pets Allowed (Verify),Property Disclosure Stmt,See Remarks
)
[elementary_school] => Array
(
[0] => Koko Head
)
[floor_covering] => Array
(
[0] => Other
)
[frontage] => Array
(
[0] => Lake/Pond,Marina,Other
)
[full_baths] => Array
(
[0] => 2
)
[half_baths] => Array
(
[0] => 0
)
[high_school] => Array
(
[0] => Kaiser
)
[home_exampt] => Array
(
[0] => 100000
)
[lanai_sf] => Array
(
[0] => 616
)
[land_area_sf] => Array
(
[0] => 205821.00
)
[land_recorded] => Array
(
[0] => Regular System
)
[land_tenure] => Array
(
[0] => FS - Fee Simple
)
[list_agent_email] => Array
(
[0] => nagwa@alohahomes.biz
)
[list_agent_name] => Array
(
[0] => Nagwa Saas
)
[list_agent_phone_number] => Array
(
[0] => (808) 395-6827
)
[list_date] => Array
(
[0] => 2022-03-28
)
[list_office_name] => Array
(
[0] => Nagwa Saas
)
[list_price] => Array
(
[0] => 885000.00
)
[living_sf] => Array
(
[0] => 1818
)
[location] => Array
(
[0] => 500 Lunalilo Home Road Unit 21D, Honolulu, HI 96825
)
[maintenance_fees] => Array
(
[0] => 948.00
)
[middle_school] => Array
(
[0] => Niu Valley
)
[mls_] => Array
(
[0] => 202205794
)
[neighborhood] => Array
(
[0] => WEST MARINA
)
[number_of_parking_spaces] => Array
(
[0] => 2
)
[office_mls_id] => Array
(
[0] => SAAS
)
[parking_features] => Array
(
[0] => Assigned,Covered - 2
)
[possession] => Array
(
[0] => At Closing
)
[postal_code] => Array
(
[0] => 96825
)
[property_condition] => Array
(
[0] => Average
)
[property_type] => Array
(
[0] => condo_townhouse
)
[property_type_label] => Array
(
[0] => Condo Townhouse
)
[region] => Array
(
[0] => HawaiiKai
)
[rets_association_fee_total] => Array
(
[0] => 1005
)
[rets_baths_full] => Array
(
[0] => 2
)
[rets_baths_half] => Array
(
[0] => 0
)
[rets_baths_total] => Array
(
[0] => 2.00
)
[rets_beds_total] => Array
(
[0] => 2
)
[rets_building_name] => Array
(
[0] => Esplanade
)
[rets_city] => Array
(
[0] => Honolulu
)
[rets_condo_parking_unit] => Array
(
[0] => 68-69
)
[rets_current_price] => Array
(
[0] => 880000.00
)
[rets_dom] => Array
(
[0] => 130
)
[rets_dual_variable_compensation_yn] => Array
(
[0] => 0
)
[rets_elementary_school] => Array
(
[0] => Koko Head
)
[rets_elevators_number_of] => Array
(
[0] => 7
)
[rets_floor_number] => Array
(
[0] => 1
)
[rets_foreclosure_yn] => Array
(
[0] => 0
)
[rets_fractional_ownership_yn] => Array
(
[0] => 0
)
[rets_high_school] => Array
(
[0] => Kaiser
)
[rets_id] => Array
(
[0] => 16533022
)
[rets_immoviewer_yn] => Array
(
[0] => 0
)
[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) 395-6827
)
[rets_list_agent_email] => Array
(
[0] => nagwa@alohahomes.biz
)
[rets_list_agent_full_name] => Array
(
[0] => Nagwa Saas
)
[rets_list_agent_mlsid] => Array
(
[0] => 00027
)
[rets_list_agent_mui] => Array
(
[0] => 8842358
)
[rets_list_office_mlsid] => Array
(
[0] => SAAS
)
[rets_list_office_mui] => Array
(
[0] => 3485694
)
[rets_list_office_name] => Array
(
[0] => Nagwa Saas
)
[rets_list_office_phone] => Array
(
[0] => (808) 395-6827
)
[rets_list_price] => Array
(
[0] => 885000.00
)
[rets_listing_contract_date] => Array
(
[0] => 2022-03-28
)
[rets_lot_size_area] => Array
(
[0] => 205821.00
)
[rets_maintenance_expense] => Array
(
[0] => 948.00
)
[rets_management_company_name] => Array
(
[0] => Touchstone
)
[rets_management_company_phone] => Array
(
[0] => 808-566-1400
)
[rets_matrix_modified_dt] => Array
(
[0] => 2022-09-28T10:38:13.283
)
[rets_matrix_unique_id] => Array
(
[0] => 16533022
)
[rets_middle_or_junior_school] => Array
(
[0] => Niu Valley
)
[rets_mls_number] => Array
(
[0] => 202205794
)
[rets_neighbourhood] => Array
(
[0] => WEST MARINA
)
[rets_new_development_construction_yn] => Array
(
[0] => 0
)
[rets_original_entry_timestamp] => Array
(
[0] => 2022-03-28T13:34:08.493
)
[rets_original_list_price] => Array
(
[0] => 897000.00
)
[rets_owner_occupancy_percentage] => Array
(
[0] => 73
)
[rets_parcel_number] => Array
(
[0] => 1-3-9-008-009-0069
)
[rets_parking_additional] => Array
(
[0] => 12
)
[rets_parking_total] => Array
(
[0] => 2
)
[rets_permit_address_internet_yn] => Array
(
[0] => 1
)
[rets_permit_internet_yn] => Array
(
[0] => 1
)
[rets_photo_count] => Array
(
[0] => 18
)
[rets_photo_modification_timestamp] => Array
(
[0] => 2022-07-05T12:32:48.283
)
[rets_postal_code] => Array
(
[0] => 96825
)
[rets_price_change_timestamp] => Array
(
[0] => 2022-06-24T13:40:14.153
)
[rets_primary_key] => Array
(
[0] => 16533022
)
[rets_private_remarks] => Array
(
[0] => 4% Commission to Buyer's broker if in escrow by August 31. 2022. Vacant and easy to show with lockbox. Please do not call listor for showings, make all showing requests through Showing time. Please use Barbara Paulo at TG as she helped with the estate, provided necessary documents to the estate representative and did the previous escrow before it fell through.
)
[rets_public_remarks] => Array
(
[0] => Only apartment at the Esplanade with exclusive Koi Pond and Waterfall frontage. Garden apartment with direct access to Luna Kai Marina Park and view of the Marina. Tiled 600 square-foot patio. Travertine tiles throughout. Original condition except for some improvements in the kitchen which include counter tops, new range and microwave. Good quality appliances. New ceiling fans. Central air conditioner purchased in 2019. Two assigned, covered parking stalls and 4 storage lockers. Sold AS IS.
)
[rets_sqft_lanai_open] => Array
(
[0] => 616
)
[rets_sqft_roofed_living] => Array
(
[0] => 1202
)
[rets_sqft_total] => Array
(
[0] => 1818
)
[rets_state_or_province] => Array
(
[0] => HI
)
[rets_status_change_timestamp] => Array
(
[0] => 2022-09-28T10:38:13.283
)
[rets_status_contractual_search_date] => Array
(
[0] => 2022-09-28
)
[rets_street_name] => Array
(
[0] => Lunalilo Home
)
[rets_street_number] => Array
(
[0] => 500
)
[rets_street_view_param] => Array
(
[0] => 1$21.285055$-157.69889$267.36$13.33$1.00$PxyJmW-XL2DyUVpyY84rNA
)
[rets_sub_agency_compensation] => Array
(
[0] => 4%
)
[rets_tax_amount] => Array
(
[0] => 157.00
)
[rets_tax_annual_amount] => Array
(
[0] => 1884.00
)
[rets_tax_assessed_value] => Array
(
[0] => 677500.00
)
[rets_tax_assessed_value_improvements] => Array
(
[0] => 505300.00
)
[rets_tax_assessed_value_land] => Array
(
[0] => 172200.00
)
[rets_tax_excemption_owner_occupancy] => Array
(
[0] => 100000
)
[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/16533022/77aa8717f9665a1dafebbb39ebfa4cc8
)
[rets_tmk_area] => Array
(
[0] => 139
)
[rets_tmk_condo_property_regime_number] => Array
(
[0] => 69
)
[rets_tmk_division] => Array
(
[0] => 1
)
[rets_tmk_parcel] => Array
(
[0] => 9
)
[rets_tmk_section] => Array
(
[0] => 9
)
[rets_tmk_zone] => Array
(
[0] => 3
)
[rets_tmkplat] => Array
(
[0] => 8
)
[rets_unit_number] => Array
(
[0] => 21D
)
[rets_year_built] => Array
(
[0] => 1973
)
[security] => Array
(
[0] => Keyed Elevator,Security Patrol,Video
)
[state_or_province] => Array
(
[0] => HI
)
[status] => Array
(
[0] => Sold
)
[street_name] => Array
(
[0] => Lunalilo Home
)
[street_number] => Array
(
[0] => 500
)
[street_suffix] => Array
(
[0] => Road
)
[terms_accept] => Array
(
[0] => Cash,Conventional
)
[tmk] => Array
(
[0] => 1-3-9-008-009-0069
)
[unit] => Array
(
[0] => Central AC,Corner/End,Ground Floor Unit,Odd# Unit,Single Level
)
[unit_number] => Array
(
[0] => 21D
)
[view] => Array
(
[0] => Garden,Marina/Canal,Mountain,Sunset
)
[wpp::rets_pk] => Array
(
[0] => 16533022
)
[wpp_gpid] => Array
(
[0] => 202205794
)
[wpp_import_schedule_id] => Array
(
[0] => 1463343682
)
[wpp_import_time] => Array
(
[0] => 1664397549
)
[year_built] => Array
(
[0] => 1973
)
[zoning] => Array
(
[0] => 12 - A-2 Medium Density Apartme
)
[new_attached_media] => Array
(
[0] => a:392:{i:0;i:21906720;i:1;i:21906721;i:2;i:21906722;i:3;i:21906723;i:4;i:21906724;i:5;i:21906725;i:6;i:21906726;i:7;i:21906727;i:8;i:21906728;i:9;i:21906729;i:10;i:21906730;i:11;i:21906731;i:12;i:21906732;i:13;i:21906733;i:14;i:21906734;i:15;i:21906735;i:16;i:21906736;i:17;i:21906737;i:18;i:21907894;i:19;i:21907895;i:20;i:21907896;i:21;i:21907897;i:22;i:21907898;i:23;i:21907899;i:24;i:21907900;i:25;i:21907901;i:26;i:21907902;i:27;i:21907903;i:28;i:21907904;i:29;i:21907905;i:30;i:21907906;i:31;i:21907907;i:32;i:21907908;i:33;i:21907909;i:34;i:21907910;i:35;i:21907911;i:36;i:21944068;i:37;i:21944069;i:38;i:21944070;i:39;i:21944071;i:40;i:21944072;i:41;i:21944073;i:42;i:21944074;i:43;i:21944075;i:44;i:21944076;i:45;i:21944077;i:46;i:21944078;i:47;i:21944079;i:48;i:21944080;i:49;i:21944081;i:50;i:21944082;i:51;i:21944083;i:52;i:21944084;i:53;i:21944085;i:54;i:22015984;i:55;i:22015985;i:56;i:22015986;i:57;i:22015987;i:58;i:22015988;i:59;i:22015989;i:60;i:22015990;i:61;i:22015991;i:62;i:22015992;i:63;i:22015993;i:64;i:22015994;i:65;i:22015995;i:66;i:22015996;i:67;i:22015997;i:68;i:22015998;i:69;i:22015999;i:70;i:22016000;i:71;i:22016001;i:72;i:22058538;i:73;i:22058539;i:74;i:22058540;i:75;i:22058541;i:76;i:22058542;i:77;i:22058543;i:78;i:22058544;i:79;i:22058545;i:80;i:22058546;i:81;i:22058547;i:82;i:22058548;i:83;i:22058549;i:84;i:22058550;i:85;i:22058551;i:86;i:22058552;i:87;i:22058553;i:88;i:22058554;i:89;i:22058555;i:90;i:22095250;i:91;i:22095251;i:92;i:22095252;i:93;i:22095253;i:94;i:22095254;i:95;i:22095255;i:96;i:22095256;i:97;i:22095257;i:98;i:22095258;i:99;i:22095259;i:100;i:22095260;i:101;i:22095261;i:102;i:22095262;i:103;i:22095263;i:104;i:22095264;i:105;i:22095265;i:106;i:22095266;i:107;i:22095267;i:108;i:22095306;i:109;i:22095307;i:110;i:22095308;i:111;i:22095309;i:112;i:22095310;i:113;i:22095311;i:114;i:22095312;i:115;i:22095313;i:116;i:22095314;i:117;i:22095315;i:118;i:22095316;i:119;i:22095317;i:120;i:22095318;i:121;i:22095319;i:122;i:22095320;i:123;i:22095321;i:124;i:22095322;i:125;i:22095323;i:126;i:22123210;i:127;i:22123211;i:128;i:22123212;i:129;i:22123213;i:130;i:22123214;i:131;i:22123215;i:132;i:22123216;i:133;i:22123217;i:134;i:22123218;i:135;i:22123219;i:136;i:22123220;i:137;i:22123221;i:138;i:22123222;i:139;i:22123223;i:140;i:22123224;i:141;i:22123225;i:142;i:22123226;i:143;i:22123227;i:144;i:22226146;i:145;i:22226147;i:146;i:22226148;i:147;i:22226149;i:148;i:22226150;i:149;i:22226151;i:150;i:22226152;i:151;i:22226153;i:152;i:22226154;i:153;i:22226155;i:154;i:22226156;i:155;i:22226157;i:156;i:22226158;i:157;i:22226159;i:158;i:22226160;i:159;i:22226161;i:160;i:22226162;i:161;i:22226163;i:162;i:22226164;i:163;i:22226165;i:164;i:22226166;i:165;i:22226167;i:166;i:22226168;i:167;i:22226169;i:168;i:22226170;i:169;i:22226171;i:170;i:22226172;i:171;i:22226173;i:172;i:22226174;i:173;i:22226175;i:174;i:22226176;i:175;i:22226177;i:176;i:22226178;i:177;i:22226179;i:178;i:22226180;i:179;i:22226181;i:180;i:22448624;i:181;i:22448625;i:182;i:22448626;i:183;i:22448627;i:184;i:22448628;i:185;i:22448629;i:186;i:22448630;i:187;i:22448631;i:188;i:22448632;i:189;i:22448633;i:190;i:22448634;i:191;i:22448635;i:192;i:22448636;i:193;i:22448637;i:194;i:22448638;i:195;i:22448639;i:196;i:22448640;i:197;i:22448641;i:198;i:22535290;i:199;i:22535291;i:200;i:22535292;i:201;i:22535293;i:202;i:22535294;i:203;i:22535295;i:204;i:22535296;i:205;i:22535297;i:206;i:22535298;i:207;i:22535299;i:208;i:22535300;i:209;i:22535301;i:210;i:22535302;i:211;i:22535303;i:212;i:22535304;i:213;i:22535305;i:214;i:22535306;i:215;i:22535307;i:216;i:22629399;i:217;i:22629400;i:218;i:22629401;i:219;i:22629402;i:220;i:22629403;i:221;i:22629404;i:222;i:22629405;i:223;i:22629406;i:224;i:22629407;i:225;i:22629408;i:226;i:22629409;i:227;i:22629410;i:228;i:22629411;i:229;i:22629412;i:230;i:22629413;i:231;i:22629414;i:232;i:22629415;i:233;i:22629562;i:234;i:22629563;i:235;i:22629564;i:236;i:22629565;i:237;i:22629566;i:238;i:22629567;i:239;i:22629568;i:240;i:22629569;i:241;i:22629570;i:242;i:22629571;i:243;i:22629572;i:244;i:22629573;i:245;i:22629574;i:246;i:22629575;i:247;i:22629576;i:248;i:22629577;i:249;i:22629578;i:250;i:22629579;i:251;i:22630051;i:252;i:22630052;i:253;i:22630053;i:254;i:22630054;i:255;i:22630055;i:256;i:22630056;i:257;i:22630057;i:258;i:22630058;i:259;i:22630059;i:260;i:22630060;i:261;i:22630061;i:262;i:22630062;i:263;i:22630063;i:264;i:22630064;i:265;i:22630065;i:266;i:22630066;i:267;i:22630067;i:268;i:22630068;i:269;i:22651807;i:270;i:22651808;i:271;i:22651809;i:272;i:22651810;i:273;i:22651811;i:274;i:22651812;i:275;i:22651813;i:276;i:22651814;i:277;i:22651815;i:278;i:22651816;i:279;i:22651817;i:280;i:22651818;i:281;i:22651819;i:282;i:22651820;i:283;i:22651821;i:284;i:22651822;i:285;i:22651823;i:286;i:22651824;i:287;i:22651925;i:288;i:22651926;i:289;i:22651927;i:290;i:22651928;i:291;i:22651929;i:292;i:22651930;i:293;i:22651931;i:294;i:22651932;i:295;i:22651933;i:296;i:22651934;i:297;i:22651935;i:298;i:22651936;i:299;i:22651937;i:300;i:22651938;i:301;i:22651939;i:302;i:22680052;i:303;i:22680053;i:304;i:22680054;i:305;i:22680055;i:306;i:22680056;i:307;i:22680057;i:308;i:22680058;i:309;i:22680059;i:310;i:22680060;i:311;i:22680061;i:312;i:22680062;i:313;i:22680063;i:314;i:22680064;i:315;i:22680065;i:316;i:22680066;i:317;i:22680067;i:318;i:22680068;i:319;i:22680069;i:320;i:22989029;i:321;i:22989030;i:322;i:22989031;i:323;i:22989032;i:324;i:22989033;i:325;i:22989034;i:326;i:22989035;i:327;i:22989036;i:328;i:22989037;i:329;i:22989038;i:330;i:22989039;i:331;i:22989040;i:332;i:22989041;i:333;i:22989042;i:334;i:22989043;i:335;i:22989044;i:336;i:22989045;i:337;i:22989046;i:338;i:23070185;i:339;i:23070186;i:340;i:23070187;i:341;i:23070188;i:342;i:23070189;i:343;i:23070190;i:344;i:23070191;i:345;i:23070192;i:346;i:23070193;i:347;i:23070194;i:348;i:23070195;i:349;i:23070196;i:350;i:23070197;i:351;i:23070198;i:352;i:23070199;i:353;i:23070200;i:354;i:23070201;i:355;i:23070202;i:356;i:23333466;i:357;i:23333467;i:358;i:23333468;i:359;i:23333469;i:360;i:23333470;i:361;i:23333471;i:362;i:23333472;i:363;i:23333473;i:364;i:23333474;i:365;i:23333475;i:366;i:23333476;i:367;i:23333477;i:368;i:23333478;i:369;i:23333479;i:370;i:23333480;i:371;i:23333481;i:372;i:23333482;i:373;i:23333483;i:374;i:23467192;i:375;i:23467193;i:376;i:23467194;i:377;i:23467195;i:378;i:23467196;i:379;i:23467197;i:380;i:23467198;i:381;i:23467199;i:382;i:23467200;i:383;i:23467201;i:384;i:23467202;i:385;i:23467203;i:386;i:23467204;i:387;i:23467205;i:388;i:23467206;i:389;i:23467207;i:390;i:23467208;i:391;i:23467209;}
)
[rets_active_continue_to_show_date] => Array
(
[0] => 2022-08-16
)
[rets_open_house_count] => Array
(
[0] => 1
)
[rets_active_open_house_count] => Array
(
[0] => 0
)
[rets_open_house_upcoming] => Array
(
[0] =>
)
[rets_association_fee_2] => Array
(
[0] => 57
)
[rets_pending_date] => Array
(
[0] => 2022-08-16
)
[rets_close_date] => Array
(
[0] => 2022-09-28
)
[rets_close_price] => Array
(
[0] => 880000.00
)
[rets_expiration_date] => Array
(
[0] => 2022-09-30
)
[rets_off_market_date] => Array
(
[0] => 2022-09-28
)
[rets_selling_agent_direct_work_phone] => Array
(
[0] => (808) 439-8250
)
[rets_selling_agent_email] => Array
(
[0] => jreich@kw.com
)
[rets_selling_agent_full_name] => Array
(
[0] => Jamie L Reich
)
[rets_selling_agent_mlsid] => Array
(
[0] => 43837
)
[rets_selling_agent_mui] => Array
(
[0] => 3483847
)
[rets_selling_office_mlsid] => Array
(
[0] => KWPP04
)
[rets_selling_office_mui] => Array
(
[0] => 10703481
)
[rets_selling_office_name] => Array
(
[0] => Keller Williams Honolulu
)
[rets_selling_office_phone] => Array
(
[0] => (808) 439-8250
)
[_thumbnail_id] => Array
(
[0] => 23467192
)
)
CONTACT US
#RB-7120
info@marcushawaii.com
(808)839-7446