Escape to your marina front oasis at Esplanade in the prestigious Hawaii Kai neighborhood. This expansive 2 bed 2 bath unit showcases an array of marina, garden, mountain and sunset views giving you a true sense of indoor/outdoor living. Modern kitchen renovations featuring open concept design, shaker cabinets, quartz counter tops and chic tile backsplash were completed in 2018. Smooth ceilings (no popcorn!) and recessed lighting further elevates the contemporary ambience. From your covered lanai, relish in the fresh breezes & calming waterfront sights. A new central AC system (2018) will keep you cool on those warmer summer days. Esplanade is highly coveted for its well maintained community & amenities galore. The full scale recreation deck offers a heated salt water pool, tennis courts, fitness center & grilling areas to name a few. Fond of evening walks? The marina and on site Lunakai Park is the perfect place to reflect on your day’s blessings. You’ll practically never have to leave home but when do, Koko Marina Shopping Center, Costco and many other retail businesses are just minutes away. Quick, this amazing opportunity won’t last long! *Patio furniture included.
Listing by: Keller Williams Honolulu (808) 596-2888
array(156) {
["agency"]=>
array(1) {
[0]=>
string(24) "Keller Williams Honolulu"
}
["assd_val_imprv"]=>
array(1) {
[0]=>
string(9) "603300.00"
}
["assd_val_land"]=>
array(1) {
[0]=>
string(9) "214300.00"
}
["assd_val_total"]=>
array(1) {
[0]=>
string(9) "817600.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(46) "Pets Allowed (Verify),Property Disclosure Stmt"
}
["exclusions"]=>
array(1) {
[0]=>
string(12) "Refrigerator"
}
["floor_covering"]=>
array(1) {
[0]=>
string(23) "Ceramic Tile,W/W Carpet"
}
["frontage"]=>
array(1) {
[0]=>
string(17) "Marina,Waterfront"
}
["full_baths"]=>
array(1) {
[0]=>
string(1) "2"
}
["half_baths"]=>
array(1) {
[0]=>
string(1) "0"
}
["home_exampt"]=>
array(1) {
[0]=>
string(8) "$100,000"
}
["lanai_sf"]=>
array(1) {
[0]=>
string(3) "119"
}
["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(21) "listing@iharateam.com"
}
["list_agent_name"]=>
array(1) {
[0]=>
string(14) "Daniel K Ihara"
}
["list_agent_phone_number"]=>
array(1) {
[0]=>
string(14) "(808) 596-2888"
}
["list_date"]=>
array(1) {
[0]=>
string(10) "2023-05-26"
}
["list_office_name"]=>
array(1) {
[0]=>
string(24) "Keller Williams Honolulu"
}
["list_price"]=>
array(1) {
[0]=>
string(9) "839000.00"
}
["living_sf"]=>
array(1) {
[0]=>
string(4) "1202"
}
["location"]=>
array(1) {
[0]=>
string(51) "500 Lunalilo Home Road Unit 25D, Honolulu, HI 96825"
}
["maintenance_fees"]=>
array(1) {
[0]=>
string(7) "1082.00"
}
["mls_"]=>
array(1) {
[0]=>
string(9) "202311382"
}
["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) "KWPP"
}
["parking_features"]=>
array(1) {
[0]=>
string(31) "Covered - 2,Guest,Secured Entry"
}
["possession"]=>
array(1) {
[0]=>
string(10) "At Closing"
}
["postal_code"]=>
array(1) {
[0]=>
string(5) "96825"
}
["property_condition"]=>
array(1) {
[0]=>
string(23) "Excellent,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(9) "HawaiiKai"
}
["rets_association_fee_total"]=>
array(1) {
[0]=>
string(4) "1082"
}
["rets_attribution_contact"]=>
array(1) {
[0]=>
string(14) "(808) 596-2888"
}
["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_co_list_agent_direct_work_phone"]=>
array(1) {
[0]=>
string(14) "(808) 596-2888"
}
["rets_co_list_agent_email"]=>
array(1) {
[0]=>
string(22) "tiffanyy@iharateam.com"
}
["rets_co_list_agent_full_name"]=>
array(1) {
[0]=>
string(13) "Tiffany Young"
}
["rets_co_list_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "48300"
}
["rets_co_list_agent_mui"]=>
array(1) {
[0]=>
string(8) "12532020"
}
["rets_co_list_office_mlsid"]=>
array(1) {
[0]=>
string(4) "KWPP"
}
["rets_co_list_office_mui"]=>
array(1) {
[0]=>
string(7) "8991040"
}
["rets_co_list_office_name"]=>
array(1) {
[0]=>
string(24) "Keller Williams Honolulu"
}
["rets_co_list_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 596-2888"
}
["rets_condo_parking_unit"]=>
array(1) {
[0]=>
string(6) "76, 77"
}
["rets_current_price"]=>
array(1) {
[0]=>
string(9) "839000.00"
}
["rets_dom"]=>
array(1) {
[0]=>
string(2) "10"
}
["rets_dual_variable_compensation_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_exempt_listing_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_exempt_signature_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_floor_number"]=>
array(1) {
[0]=>
string(1) "5"
}
["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) "17334979"
}
["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) 596-2888"
}
["rets_list_agent_email"]=>
array(1) {
[0]=>
string(21) "listing@iharateam.com"
}
["rets_list_agent_full_name"]=>
array(1) {
[0]=>
string(14) "Daniel K Ihara"
}
["rets_list_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "29754"
}
["rets_list_agent_mui"]=>
array(1) {
[0]=>
string(7) "3478215"
}
["rets_list_office_mlsid"]=>
array(1) {
[0]=>
string(4) "KWPP"
}
["rets_list_office_mui"]=>
array(1) {
[0]=>
string(7) "8991040"
}
["rets_list_office_name"]=>
array(1) {
[0]=>
string(24) "Keller Williams Honolulu"
}
["rets_list_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 596-2888"
}
["rets_list_price"]=>
array(1) {
[0]=>
string(9) "839000.00"
}
["rets_listing_contract_date"]=>
array(1) {
[0]=>
string(10) "2023-05-26"
}
["rets_maintenance_expense"]=>
array(1) {
[0]=>
string(7) "1082.00"
}
["rets_management_company_name"]=>
array(1) {
[0]=>
string(10) "Touchstone"
}
["rets_management_company_phone"]=>
array(1) {
[0]=>
string(12) "808-566-4100"
}
["rets_matrix_modified_dt"]=>
array(1) {
[0]=>
string(23) "2023-06-05T17:13:17.707"
}
["rets_matrix_unique_id"]=>
array(1) {
[0]=>
string(8) "17334979"
}
["rets_mls_number"]=>
array(1) {
[0]=>
string(9) "202311382"
}
["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) "2023-05-26T08:55:45.320"
}
["rets_original_list_price"]=>
array(1) {
[0]=>
string(9) "839000.00"
}
["rets_owner_occupancy_percentage"]=>
array(1) {
[0]=>
string(2) "73"
}
["rets_parcel_number"]=>
array(1) {
[0]=>
string(18) "1-3-9-008-009-0121"
}
["rets_parking_additional"]=>
array(1) {
[0]=>
string(1) "0"
}
["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) "25"
}
["rets_photo_modification_timestamp"]=>
array(1) {
[0]=>
string(23) "2023-05-26T08:55:45.320"
}
["rets_postal_code"]=>
array(1) {
[0]=>
string(5) "96825"
}
["rets_price_change_timestamp"]=>
array(1) {
[0]=>
string(23) "2023-05-26T08:55:45.320"
}
["rets_primary_key"]=>
array(1) {
[0]=>
string(8) "17334979"
}
["rets_private_remarks"]=>
array(1) {
[0]=>
string(527) "MF $946.52 + Cab/Int $55.63 + Marina fee $43.75 + Luna Kai Park fee $15.00 + A/C $21.10 = $1082. Separate $130.30 bi-monthly sewer fee to HI American Water. IMPORTANT: Check Supp Docs. Refrigerator EXCLUDED. Patio Furniture INCLUDED. Questions? Contact Tiffany (808) 371-6865. SHOWINGS use ShowingTime OFFERS to listing@iharateam.com. All info deemed reliable, must be verified by Buyer before close of escrow. Pls allow 48hrs to respond. Escrow: Pls use Brooke Takara at First American Title, 808-457-3787, btakara@firstam.com"
}
["rets_public_remarks"]=>
array(1) {
[0]=>
string(1188) "Escape to your marina front oasis at Esplanade in the prestigious Hawaii Kai neighborhood. This expansive 2 bed 2 bath unit showcases an array of marina, garden, mountain and sunset views giving you a true sense of indoor/outdoor living. Modern kitchen renovations featuring open concept design, shaker cabinets, quartz counter tops and chic tile backsplash were completed in 2018. Smooth ceilings (no popcorn!) and recessed lighting further elevates the contemporary ambience. From your covered lanai, relish in the fresh breezes & calming waterfront sights. A new central AC system (2018) will keep you cool on those warmer summer days. Esplanade is highly coveted for its well maintained community & amenities galore. The full scale recreation deck offers a heated salt water pool, tennis courts, fitness center & grilling areas to name a few. Fond of evening walks? The marina and on site Lunakai Park is the perfect place to reflect on your day's blessings. You'll practically never have to leave home but when do, Koko Marina Shopping Center, Costco and many other retail businesses are just minutes away. Quick, this amazing opportunity won't last long! *Patio furniture included."
}
["rets_room_count"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_sqft_lanai_open"]=>
array(1) {
[0]=>
string(3) "119"
}
["rets_sqft_roofed_living"]=>
array(1) {
[0]=>
string(4) "1083"
}
["rets_sqft_total"]=>
array(1) {
[0]=>
string(4) "1202"
}
["rets_state_or_province"]=>
array(1) {
[0]=>
string(2) "HI"
}
["rets_status_change_timestamp"]=>
array(1) {
[0]=>
string(23) "2023-05-26T08:55:45.320"
}
["rets_status_contractual_search_date"]=>
array(1) {
[0]=>
string(10) "2023-05-26"
}
["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(81) "1$21.284857873758998$-157.69853867304704$299.30$13.33$1.00$VMa08v2bn03r56nkSsyL5Q"
}
["rets_sub_agency_compensation"]=>
array(1) {
[0]=>
string(3) "2.5"
}
["rets_supplement_count"]=>
array(1) {
[0]=>
string(2) "10"
}
["rets_supplement_modification_timestam"]=>
array(1) {
[0]=>
string(23) "2023-05-25T13:40:12.503"
}
["rets_tax_amount"]=>
array(1) {
[0]=>
string(6) "209.00"
}
["rets_tax_annual_amount"]=>
array(1) {
[0]=>
string(7) "2508.00"
}
["rets_tax_assessed_value"]=>
array(1) {
[0]=>
string(9) "817600.00"
}
["rets_tax_assessed_value_improvements"]=>
array(1) {
[0]=>
string(9) "603300.00"
}
["rets_tax_assessed_value_land"]=>
array(1) {
[0]=>
string(9) "214300.00"
}
["rets_tax_excemption_owner_occupancy"]=>
array(1) {
[0]=>
string(8) "$100,000"
}
["rets_tax_paid_by_seller_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_tax_year"]=>
array(1) {
[0]=>
string(4) "2023"
}
["rets_thumbnail_url"]=>
array(1) {
[0]=>
string(81) "https://cdn.rets.ci/marcusrealty-images/17334979/53601d1ff52e30df12e0a7a72b6969c9"
}
["rets_tmk_area"]=>
array(1) {
[0]=>
string(3) "139"
}
["rets_tmk_condo_property_regime_number"]=>
array(1) {
[0]=>
string(3) "121"
}
["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) "25D"
}
["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(6) "Active"
}
["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(20) "Cash,Conventional,VA"
}
["tmk"]=>
array(1) {
[0]=>
string(18) "1-3-9-008-009-0121"
}
["unit"]=>
array(1) {
[0]=>
string(33) "Central AC,Odd# Unit,Single Level"
}
["unit_number"]=>
array(1) {
[0]=>
string(3) "25D"
}
["view"]=>
array(1) {
[0]=>
string(35) "Garden,Marina/Canal,Mountain,Sunset"
}
["wpp::rets_pk"]=>
array(1) {
[0]=>
string(8) "17334979"
}
["wpp_gpid"]=>
array(1) {
[0]=>
string(9) "202311382"
}
["wpp_import_schedule_id"]=>
array(1) {
[0]=>
string(10) "1463343682"
}
["wpp_import_time"]=>
array(1) {
[0]=>
string(10) "1686021235"
}
["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(2040) "a:126:{i:0;i:25405259;i:1;i:25405260;i:2;i:25405261;i:3;i:25405262;i:4;i:25405263;i:5;i:25405264;i:6;i:25405265;i:7;i:25405266;i:8;i:25405267;i:9;i:25405268;i:10;i:25405269;i:11;i:25405270;i:12;i:25405271;i:13;i:25405272;i:14;i:25405273;i:15;i:25405274;i:16;i:25405275;i:17;i:25405276;i:18;i:25405277;i:19;i:25405278;i:20;i:25405279;i:21;i:25405376;i:22;i:25405377;i:23;i:25405378;i:24;i:25405379;i:25;i:25405380;i:26;i:25405381;i:27;i:25405382;i:28;i:25405383;i:29;i:25405384;i:30;i:25405385;i:31;i:25405386;i:32;i:25405387;i:33;i:25405388;i:34;i:25405389;i:35;i:25405390;i:36;i:25405391;i:37;i:25405392;i:38;i:25405393;i:39;i:25405394;i:40;i:25405395;i:41;i:25405396;i:42;i:25405468;i:43;i:25405469;i:44;i:25405470;i:45;i:25405471;i:46;i:25405472;i:47;i:25405473;i:48;i:25405474;i:49;i:25405475;i:50;i:25405476;i:51;i:25405477;i:52;i:25405478;i:53;i:25405479;i:54;i:25405480;i:55;i:25405481;i:56;i:25405482;i:57;i:25405483;i:58;i:25405484;i:59;i:25405485;i:60;i:25405486;i:61;i:25405487;i:62;i:25405488;i:63;i:25423503;i:64;i:25423504;i:65;i:25423505;i:66;i:25423506;i:67;i:25423507;i:68;i:25423508;i:69;i:25423509;i:70;i:25423510;i:71;i:25423511;i:72;i:25423512;i:73;i:25423513;i:74;i:25423514;i:75;i:25423515;i:76;i:25423516;i:77;i:25423517;i:78;i:25423518;i:79;i:25423519;i:80;i:25423520;i:81;i:25423521;i:82;i:25423522;i:83;i:25423523;i:84;i:25480435;i:85;i:25480436;i:86;i:25480437;i:87;i:25480438;i:88;i:25480439;i:89;i:25480440;i:90;i:25480441;i:91;i:25480442;i:92;i:25480443;i:93;i:25480444;i:94;i:25480445;i:95;i:25480446;i:96;i:25480447;i:97;i:25480448;i:98;i:25480449;i:99;i:25480450;i:100;i:25480451;i:101;i:25480452;i:102;i:25480453;i:103;i:25480454;i:104;i:25480455;i:105;i:25490460;i:106;i:25490461;i:107;i:25490462;i:108;i:25490463;i:109;i:25490464;i:110;i:25490465;i:111;i:25490466;i:112;i:25490467;i:113;i:25490468;i:114;i:25490469;i:115;i:25490470;i:116;i:25490471;i:117;i:25490472;i:118;i:25490473;i:119;i:25490474;i:120;i:25490475;i:121;i:25490476;i:122;i:25490477;i:123;i:25490478;i:124;i:25490479;i:125;i:25490480;}"
}
["rets_open_house_count"]=>
array(1) {
[0]=>
string(1) "2"
}
["rets_active_open_house_count"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_open_house_upcoming"]=>
array(1) {
[0]=>
string(0) ""
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "25490460"
}
}
Array
(
[agency] => Array
(
[0] => Keller Williams Honolulu
)
[assd_val_imprv] => Array
(
[0] => 603300.00
)
[assd_val_land] => Array
(
[0] => 214300.00
)
[assd_val_total] => Array
(
[0] => 817600.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
)
[exclusions] => Array
(
[0] => Refrigerator
)
[floor_covering] => Array
(
[0] => Ceramic Tile,W/W Carpet
)
[frontage] => Array
(
[0] => Marina,Waterfront
)
[full_baths] => Array
(
[0] => 2
)
[half_baths] => Array
(
[0] => 0
)
[home_exampt] => Array
(
[0] => $100,000
)
[lanai_sf] => Array
(
[0] => 119
)
[land_recorded] => Array
(
[0] => Regular System
)
[land_tenure] => Array
(
[0] => FS - Fee Simple
)
[list_agent_email] => Array
(
[0] => listing@iharateam.com
)
[list_agent_name] => Array
(
[0] => Daniel K Ihara
)
[list_agent_phone_number] => Array
(
[0] => (808) 596-2888
)
[list_date] => Array
(
[0] => 2023-05-26
)
[list_office_name] => Array
(
[0] => Keller Williams Honolulu
)
[list_price] => Array
(
[0] => 839000.00
)
[living_sf] => Array
(
[0] => 1202
)
[location] => Array
(
[0] => 500 Lunalilo Home Road Unit 25D, Honolulu, HI 96825
)
[maintenance_fees] => Array
(
[0] => 1082.00
)
[mls_] => Array
(
[0] => 202311382
)
[neighborhood] => Array
(
[0] => WEST MARINA
)
[number_of_parking_spaces] => Array
(
[0] => 2
)
[office_mls_id] => Array
(
[0] => KWPP
)
[parking_features] => Array
(
[0] => Covered - 2,Guest,Secured Entry
)
[possession] => Array
(
[0] => At Closing
)
[postal_code] => Array
(
[0] => 96825
)
[property_condition] => Array
(
[0] => Excellent,Above Average
)
[property_type] => Array
(
[0] => condo_townhouse
)
[property_type_label] => Array
(
[0] => Condo Townhouse
)
[region] => Array
(
[0] => HawaiiKai
)
[rets_association_fee_total] => Array
(
[0] => 1082
)
[rets_attribution_contact] => Array
(
[0] => (808) 596-2888
)
[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_co_list_agent_direct_work_phone] => Array
(
[0] => (808) 596-2888
)
[rets_co_list_agent_email] => Array
(
[0] => tiffanyy@iharateam.com
)
[rets_co_list_agent_full_name] => Array
(
[0] => Tiffany Young
)
[rets_co_list_agent_mlsid] => Array
(
[0] => 48300
)
[rets_co_list_agent_mui] => Array
(
[0] => 12532020
)
[rets_co_list_office_mlsid] => Array
(
[0] => KWPP
)
[rets_co_list_office_mui] => Array
(
[0] => 8991040
)
[rets_co_list_office_name] => Array
(
[0] => Keller Williams Honolulu
)
[rets_co_list_office_phone] => Array
(
[0] => (808) 596-2888
)
[rets_condo_parking_unit] => Array
(
[0] => 76, 77
)
[rets_current_price] => Array
(
[0] => 839000.00
)
[rets_dom] => Array
(
[0] => 10
)
[rets_dual_variable_compensation_yn] => Array
(
[0] => 0
)
[rets_exempt_listing_yn] => Array
(
[0] => 0
)
[rets_exempt_signature_yn] => Array
(
[0] => 0
)
[rets_floor_number] => Array
(
[0] => 5
)
[rets_foreclosure_yn] => Array
(
[0] => 0
)
[rets_fractional_ownership_yn] => Array
(
[0] => 0
)
[rets_id] => Array
(
[0] => 17334979
)
[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) 596-2888
)
[rets_list_agent_email] => Array
(
[0] => listing@iharateam.com
)
[rets_list_agent_full_name] => Array
(
[0] => Daniel K Ihara
)
[rets_list_agent_mlsid] => Array
(
[0] => 29754
)
[rets_list_agent_mui] => Array
(
[0] => 3478215
)
[rets_list_office_mlsid] => Array
(
[0] => KWPP
)
[rets_list_office_mui] => Array
(
[0] => 8991040
)
[rets_list_office_name] => Array
(
[0] => Keller Williams Honolulu
)
[rets_list_office_phone] => Array
(
[0] => (808) 596-2888
)
[rets_list_price] => Array
(
[0] => 839000.00
)
[rets_listing_contract_date] => Array
(
[0] => 2023-05-26
)
[rets_maintenance_expense] => Array
(
[0] => 1082.00
)
[rets_management_company_name] => Array
(
[0] => Touchstone
)
[rets_management_company_phone] => Array
(
[0] => 808-566-4100
)
[rets_matrix_modified_dt] => Array
(
[0] => 2023-06-05T17:13:17.707
)
[rets_matrix_unique_id] => Array
(
[0] => 17334979
)
[rets_mls_number] => Array
(
[0] => 202311382
)
[rets_neighbourhood] => Array
(
[0] => WEST MARINA
)
[rets_new_development_construction_yn] => Array
(
[0] => 0
)
[rets_original_entry_timestamp] => Array
(
[0] => 2023-05-26T08:55:45.320
)
[rets_original_list_price] => Array
(
[0] => 839000.00
)
[rets_owner_occupancy_percentage] => Array
(
[0] => 73
)
[rets_parcel_number] => Array
(
[0] => 1-3-9-008-009-0121
)
[rets_parking_additional] => Array
(
[0] => 0
)
[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] => 25
)
[rets_photo_modification_timestamp] => Array
(
[0] => 2023-05-26T08:55:45.320
)
[rets_postal_code] => Array
(
[0] => 96825
)
[rets_price_change_timestamp] => Array
(
[0] => 2023-05-26T08:55:45.320
)
[rets_primary_key] => Array
(
[0] => 17334979
)
[rets_private_remarks] => Array
(
[0] => MF $946.52 + Cab/Int $55.63 + Marina fee $43.75 + Luna Kai Park fee $15.00 + A/C $21.10 = $1082. Separate $130.30 bi-monthly sewer fee to HI American Water. IMPORTANT: Check Supp Docs. Refrigerator EXCLUDED. Patio Furniture INCLUDED. Questions? Contact Tiffany (808) 371-6865. SHOWINGS use ShowingTime OFFERS to listing@iharateam.com. All info deemed reliable, must be verified by Buyer before close of escrow. Pls allow 48hrs to respond. Escrow: Pls use Brooke Takara at First American Title, 808-457-3787, btakara@firstam.com
)
[rets_public_remarks] => Array
(
[0] => Escape to your marina front oasis at Esplanade in the prestigious Hawaii Kai neighborhood. This expansive 2 bed 2 bath unit showcases an array of marina, garden, mountain and sunset views giving you a true sense of indoor/outdoor living. Modern kitchen renovations featuring open concept design, shaker cabinets, quartz counter tops and chic tile backsplash were completed in 2018. Smooth ceilings (no popcorn!) and recessed lighting further elevates the contemporary ambience. From your covered lanai, relish in the fresh breezes & calming waterfront sights. A new central AC system (2018) will keep you cool on those warmer summer days. Esplanade is highly coveted for its well maintained community & amenities galore. The full scale recreation deck offers a heated salt water pool, tennis courts, fitness center & grilling areas to name a few. Fond of evening walks? The marina and on site Lunakai Park is the perfect place to reflect on your day's blessings. You'll practically never have to leave home but when do, Koko Marina Shopping Center, Costco and many other retail businesses are just minutes away. Quick, this amazing opportunity won't last long! *Patio furniture included.
)
[rets_room_count] => Array
(
[0] => 0
)
[rets_sqft_lanai_open] => Array
(
[0] => 119
)
[rets_sqft_roofed_living] => Array
(
[0] => 1083
)
[rets_sqft_total] => Array
(
[0] => 1202
)
[rets_state_or_province] => Array
(
[0] => HI
)
[rets_status_change_timestamp] => Array
(
[0] => 2023-05-26T08:55:45.320
)
[rets_status_contractual_search_date] => Array
(
[0] => 2023-05-26
)
[rets_street_name] => Array
(
[0] => Lunalilo Home
)
[rets_street_number] => Array
(
[0] => 500
)
[rets_street_view_param] => Array
(
[0] => 1$21.284857873758998$-157.69853867304704$299.30$13.33$1.00$VMa08v2bn03r56nkSsyL5Q
)
[rets_sub_agency_compensation] => Array
(
[0] => 2.5
)
[rets_supplement_count] => Array
(
[0] => 10
)
[rets_supplement_modification_timestam] => Array
(
[0] => 2023-05-25T13:40:12.503
)
[rets_tax_amount] => Array
(
[0] => 209.00
)
[rets_tax_annual_amount] => Array
(
[0] => 2508.00
)
[rets_tax_assessed_value] => Array
(
[0] => 817600.00
)
[rets_tax_assessed_value_improvements] => Array
(
[0] => 603300.00
)
[rets_tax_assessed_value_land] => Array
(
[0] => 214300.00
)
[rets_tax_excemption_owner_occupancy] => Array
(
[0] => $100,000
)
[rets_tax_paid_by_seller_yn] => Array
(
[0] => 0
)
[rets_tax_year] => Array
(
[0] => 2023
)
[rets_thumbnail_url] => Array
(
[0] => https://cdn.rets.ci/marcusrealty-images/17334979/53601d1ff52e30df12e0a7a72b6969c9
)
[rets_tmk_area] => Array
(
[0] => 139
)
[rets_tmk_condo_property_regime_number] => Array
(
[0] => 121
)
[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] => 25D
)
[rets_year_built] => Array
(
[0] => 1973
)
[security] => Array
(
[0] => Keyed Elevator,Security Patrol,Video
)
[state_or_province] => Array
(
[0] => HI
)
[status] => Array
(
[0] => Active
)
[street_name] => Array
(
[0] => Lunalilo Home
)
[street_number] => Array
(
[0] => 500
)
[street_suffix] => Array
(
[0] => Road
)
[terms_accept] => Array
(
[0] => Cash,Conventional,VA
)
[tmk] => Array
(
[0] => 1-3-9-008-009-0121
)
[unit] => Array
(
[0] => Central AC,Odd# Unit,Single Level
)
[unit_number] => Array
(
[0] => 25D
)
[view] => Array
(
[0] => Garden,Marina/Canal,Mountain,Sunset
)
[wpp::rets_pk] => Array
(
[0] => 17334979
)
[wpp_gpid] => Array
(
[0] => 202311382
)
[wpp_import_schedule_id] => Array
(
[0] => 1463343682
)
[wpp_import_time] => Array
(
[0] => 1686021235
)
[year_built] => Array
(
[0] => 1973
)
[zoning] => Array
(
[0] => 12 - A-2 Medium Density Apartme
)
[new_attached_media] => Array
(
[0] => a:126:{i:0;i:25405259;i:1;i:25405260;i:2;i:25405261;i:3;i:25405262;i:4;i:25405263;i:5;i:25405264;i:6;i:25405265;i:7;i:25405266;i:8;i:25405267;i:9;i:25405268;i:10;i:25405269;i:11;i:25405270;i:12;i:25405271;i:13;i:25405272;i:14;i:25405273;i:15;i:25405274;i:16;i:25405275;i:17;i:25405276;i:18;i:25405277;i:19;i:25405278;i:20;i:25405279;i:21;i:25405376;i:22;i:25405377;i:23;i:25405378;i:24;i:25405379;i:25;i:25405380;i:26;i:25405381;i:27;i:25405382;i:28;i:25405383;i:29;i:25405384;i:30;i:25405385;i:31;i:25405386;i:32;i:25405387;i:33;i:25405388;i:34;i:25405389;i:35;i:25405390;i:36;i:25405391;i:37;i:25405392;i:38;i:25405393;i:39;i:25405394;i:40;i:25405395;i:41;i:25405396;i:42;i:25405468;i:43;i:25405469;i:44;i:25405470;i:45;i:25405471;i:46;i:25405472;i:47;i:25405473;i:48;i:25405474;i:49;i:25405475;i:50;i:25405476;i:51;i:25405477;i:52;i:25405478;i:53;i:25405479;i:54;i:25405480;i:55;i:25405481;i:56;i:25405482;i:57;i:25405483;i:58;i:25405484;i:59;i:25405485;i:60;i:25405486;i:61;i:25405487;i:62;i:25405488;i:63;i:25423503;i:64;i:25423504;i:65;i:25423505;i:66;i:25423506;i:67;i:25423507;i:68;i:25423508;i:69;i:25423509;i:70;i:25423510;i:71;i:25423511;i:72;i:25423512;i:73;i:25423513;i:74;i:25423514;i:75;i:25423515;i:76;i:25423516;i:77;i:25423517;i:78;i:25423518;i:79;i:25423519;i:80;i:25423520;i:81;i:25423521;i:82;i:25423522;i:83;i:25423523;i:84;i:25480435;i:85;i:25480436;i:86;i:25480437;i:87;i:25480438;i:88;i:25480439;i:89;i:25480440;i:90;i:25480441;i:91;i:25480442;i:92;i:25480443;i:93;i:25480444;i:94;i:25480445;i:95;i:25480446;i:96;i:25480447;i:97;i:25480448;i:98;i:25480449;i:99;i:25480450;i:100;i:25480451;i:101;i:25480452;i:102;i:25480453;i:103;i:25480454;i:104;i:25480455;i:105;i:25490460;i:106;i:25490461;i:107;i:25490462;i:108;i:25490463;i:109;i:25490464;i:110;i:25490465;i:111;i:25490466;i:112;i:25490467;i:113;i:25490468;i:114;i:25490469;i:115;i:25490470;i:116;i:25490471;i:117;i:25490472;i:118;i:25490473;i:119;i:25490474;i:120;i:25490475;i:121;i:25490476;i:122;i:25490477;i:123;i:25490478;i:124;i:25490479;i:125;i:25490480;}
)
[rets_open_house_count] => Array
(
[0] => 2
)
[rets_active_open_house_count] => Array
(
[0] => 0
)
[rets_open_house_upcoming] => Array
(
[0] =>
)
[_thumbnail_id] => Array
(
[0] => 25490460
)
)
CONTACT US
#RB-7120
info@marcushawaii.com
(808)839-7446