Views, upgrades, renovations and ready to move into! This unit is stunning with a complete kitchen remodel, brand new master bathroom, popcorn ceilings removed, freshly painted interior, Remote Controlled Retractable Lanai Screen for sun filtering and creates extra indoor space as necessary, security screen front door to allow for wonderful cross breeze, Brand new washer and dryer, Bosch AC Unit updated in 2020, Waterproof Pergo Laminate Flooring in Kitchen, Hallway, Dining and Living Areas, California Closets in both bedrooms and 2 assigned covered parking with extra storage lockers. The Esplanade provides resort style amenities that will satisfy all your senses! This lovely unit truly has everything you need and want!
Listing by: Fathom Realty HI LLC
array(159) {
["assd_val_imprv"]=>
array(1) {
[0]=>
string(9) "522900.00"
}
["assd_val_land"]=>
array(1) {
[0]=>
string(9) "183600.00"
}
["assd_val_total"]=>
array(1) {
[0]=>
string(9) "706500.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(62) "Pet on Property,Pets Allowed (Verify),Property Disclosure Stmt"
}
["floor_covering"]=>
array(1) {
[0]=>
string(19) "Laminate,W/W Carpet"
}
["frontage"]=>
array(1) {
[0]=>
string(6) "Marina"
}
["full_baths"]=>
array(1) {
[0]=>
string(1) "2"
}
["furnished"]=>
array(1) {
[0]=>
string(4) "None"
}
["half_baths"]=>
array(1) {
[0]=>
string(1) "0"
}
["home_exampt"]=>
array(1) {
[0]=>
string(6) "100000"
}
["lanai_sf"]=>
array(1) {
[0]=>
string(3) "119"
}
["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(17) "Jodi@Jodimews.com"
}
["list_agent_name"]=>
array(1) {
[0]=>
string(9) "Jodi Mews"
}
["list_agent_phone_number"]=>
array(1) {
[0]=>
string(14) "(808) 260-6684"
}
["list_date"]=>
array(1) {
[0]=>
string(10) "2022-06-26"
}
["list_office_name"]=>
array(1) {
[0]=>
string(20) "Fathom Realty HI LLC"
}
["list_price"]=>
array(1) {
[0]=>
string(9) "870000.00"
}
["living_sf"]=>
array(1) {
[0]=>
string(4) "1202"
}
["location"]=>
array(1) {
[0]=>
string(51) "500 Lunalilo Home Road Unit 23B, Honolulu, HI 96825"
}
["maintenance_fees"]=>
array(1) {
[0]=>
string(6) "947.67"
}
["mls_"]=>
array(1) {
[0]=>
string(9) "202212268"
}
["neighborhood"]=>
array(1) {
[0]=>
string(11) "WEST MARINA"
}
["number_of_parking_spaces"]=>
array(1) {
[0]=>
string(1) "2"
}
["number_of_stories"]=>
array(1) {
[0]=>
string(3) "One"
}
["office_mls_id"]=>
array(1) {
[0]=>
string(4) "PAKU"
}
["parking_features"]=>
array(1) {
[0]=>
string(11) "Covered - 2"
}
["possession"]=>
array(1) {
[0]=>
string(10) "At Closing"
}
["postal_code"]=>
array(1) {
[0]=>
string(5) "96825"
}
["property_condition"]=>
array(1) {
[0]=>
string(13) "Above Average"
}
["property_type"]=>
array(1) {
[0]=>
string(15) "condo_townhouse"
}
["property_type_label"]=>
array(1) {
[0]=>
string(15) "Condo Townhouse"
}
["region"]=>
array(1) {
[0]=>
string(9) "HawaiiKai"
}
["rets_active_continue_to_show_date"]=>
array(1) {
[0]=>
string(10) "2022-06-26"
}
["rets_association_fee_total"]=>
array(1) {
[0]=>
string(3) "948"
}
["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_compensation_method"]=>
array(1) {
[0]=>
string(1) "%"
}
["rets_condo_parking_unit"]=>
array(1) {
[0]=>
string(8) "112, 113"
}
["rets_current_price"]=>
array(1) {
[0]=>
string(9) "870000.00"
}
["rets_dom"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_dual_variable_compensation_yn"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_elevators_number_of"]=>
array(1) {
[0]=>
string(1) "6"
}
["rets_floor_number"]=>
array(1) {
[0]=>
string(1) "3"
}
["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) "16727266"
}
["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) 260-6684"
}
["rets_list_agent_email"]=>
array(1) {
[0]=>
string(17) "Jodi@Jodimews.com"
}
["rets_list_agent_full_name"]=>
array(1) {
[0]=>
string(9) "Jodi Mews"
}
["rets_list_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "46520"
}
["rets_list_agent_mui"]=>
array(1) {
[0]=>
string(8) "10326742"
}
["rets_list_office_mlsid"]=>
array(1) {
[0]=>
string(4) "PAKU"
}
["rets_list_office_mui"]=>
array(1) {
[0]=>
string(7) "3486719"
}
["rets_list_office_name"]=>
array(1) {
[0]=>
string(20) "Fathom Realty HI LLC"
}
["rets_list_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 260-6684"
}
["rets_list_price"]=>
array(1) {
[0]=>
string(9) "870000.00"
}
["rets_listing_contract_date"]=>
array(1) {
[0]=>
string(10) "2022-06-26"
}
["rets_lot_size_area"]=>
array(1) {
[0]=>
string(9) "205821.00"
}
["rets_maintenance_expense"]=>
array(1) {
[0]=>
string(6) "947.67"
}
["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) "2022-07-26T09:13:34.343"
}
["rets_matrix_unique_id"]=>
array(1) {
[0]=>
string(8) "16727266"
}
["rets_mls_number"]=>
array(1) {
[0]=>
string(9) "202212268"
}
["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-06-27T09:47:03.867"
}
["rets_original_list_price"]=>
array(1) {
[0]=>
string(9) "870000.00"
}
["rets_owner_occupancy_percentage"]=>
array(1) {
[0]=>
string(2) "70"
}
["rets_parcel_number"]=>
array(1) {
[0]=>
string(18) "1-3-9-008-009-0093"
}
["rets_parking_additional"]=>
array(1) {
[0]=>
string(2) "10"
}
["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) "24"
}
["rets_photo_modification_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-06-27T09:47:03.867"
}
["rets_postal_code"]=>
array(1) {
[0]=>
string(5) "96825"
}
["rets_price_change_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-06-27T09:47:03.867"
}
["rets_primary_key"]=>
array(1) {
[0]=>
string(8) "16727266"
}
["rets_private_remarks"]=>
array(1) {
[0]=>
string(139) "Please consider Kevin Batungbacal at First American Title. For additional information and questions, please contact Jodi Mews 808-260-6684."
}
["rets_public_remarks"]=>
array(1) {
[0]=>
string(732) "Views, upgrades, renovations and ready to move into! This unit is stunning with a complete kitchen remodel, brand new master bathroom, popcorn ceilings removed, freshly painted interior, Remote Controlled Retractable Lanai Screen for sun filtering and creates extra indoor space as necessary, security screen front door to allow for wonderful cross breeze, Brand new washer and dryer, Bosch AC Unit updated in 2020, Waterproof Pergo Laminate Flooring in Kitchen, Hallway, Dining and Living Areas, California Closets in both bedrooms and 2 assigned covered parking with extra storage lockers. The Esplanade provides resort style amenities that will satisfy all your senses! This lovely unit truly has everything you need and want!"
}
["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) "2022-07-26T09:13:34.343"
}
["rets_status_contractual_search_date"]=>
array(1) {
[0]=>
string(10) "2022-07-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(63) "1$21.285055$-157.69889$267.54$13.33$1.00$PxyJmW-XL2DyUVpyY84rNA"
}
["rets_sub_agency_compensation"]=>
array(1) {
[0]=>
string(3) "2.5"
}
["rets_tax_amount"]=>
array(1) {
[0]=>
string(6) "165.78"
}
["rets_tax_annual_amount"]=>
array(1) {
[0]=>
string(7) "1989.36"
}
["rets_tax_assessed_value"]=>
array(1) {
[0]=>
string(9) "706500.00"
}
["rets_tax_assessed_value_improvements"]=>
array(1) {
[0]=>
string(9) "522900.00"
}
["rets_tax_assessed_value_land"]=>
array(1) {
[0]=>
string(9) "183600.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/16727266/680e460508a63f4cb5f763be7bb76c91"
}
["rets_tmk_area"]=>
array(1) {
[0]=>
string(3) "139"
}
["rets_tmk_condo_property_regime_number"]=>
array(1) {
[0]=>
string(2) "93"
}
["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) "23B"
}
["rets_year_built"]=>
array(1) {
[0]=>
string(4) "1973"
}
["rets_year_remodeled"]=>
array(1) {
[0]=>
string(4) "2019"
}
["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(20) "Cash,Conventional,VA"
}
["tmk"]=>
array(1) {
[0]=>
string(18) "1-3-9-008-009-0093"
}
["unit"]=>
array(1) {
[0]=>
string(20) "Central AC,Odd# Unit"
}
["unit_number"]=>
array(1) {
[0]=>
string(3) "23B"
}
["view"]=>
array(1) {
[0]=>
string(21) "Marina/Canal,Mountain"
}
["wpp::rets_pk"]=>
array(1) {
[0]=>
string(8) "16727266"
}
["wpp_gpid"]=>
array(1) {
[0]=>
string(9) "202212268"
}
["wpp_import_schedule_id"]=>
array(1) {
[0]=>
string(10) "1463343682"
}
["wpp_import_time"]=>
array(1) {
[0]=>
string(10) "1658862828"
}
["year_built"]=>
array(1) {
[0]=>
string(4) "1973"
}
["year_remodeled_"]=>
array(1) {
[0]=>
string(4) "2019"
}
["zoning"]=>
array(1) {
[0]=>
string(31) "12 - A-2 Medium Density Apartme"
}
["new_attached_media"]=>
array(1) {
[0]=>
string(1005) "a:63:{i:0;i:22556226;i:1;i:22556227;i:2;i:22556228;i:3;i:22556229;i:4;i:22556230;i:5;i:22556231;i:6;i:22556232;i:7;i:22556233;i:8;i:22556234;i:9;i:22556235;i:10;i:22556236;i:11;i:22556237;i:12;i:22556238;i:13;i:22556239;i:14;i:22556240;i:15;i:22556241;i:16;i:22556242;i:17;i:22556243;i:18;i:22556244;i:19;i:22556245;i:20;i:22556246;i:21;i:22562835;i:22;i:22562836;i:23;i:22562837;i:24;i:22562838;i:25;i:22562839;i:26;i:22562840;i:27;i:22562841;i:28;i:22562842;i:29;i:22562843;i:30;i:22562844;i:31;i:22562845;i:32;i:22562846;i:33;i:22562847;i:34;i:22562848;i:35;i:22562849;i:36;i:22562850;i:37;i:22562851;i:38;i:22562852;i:39;i:22562853;i:40;i:22562854;i:41;i:22562855;i:42;i:22850131;i:43;i:22850132;i:44;i:22850133;i:45;i:22850134;i:46;i:22850135;i:47;i:22850136;i:48;i:22850137;i:49;i:22850138;i:50;i:22850139;i:51;i:22850140;i:52;i:22850141;i:53;i:22850142;i:54;i:22850143;i:55;i:22850144;i:56;i:22850145;i:57;i:22850146;i:58;i:22850147;i:59;i:22850148;i:60;i:22850149;i:61;i:22850150;i:62;i:22850151;}"
}
["rets_close_date"]=>
array(1) {
[0]=>
string(10) "2022-07-26"
}
["rets_close_price"]=>
array(1) {
[0]=>
string(9) "870000.00"
}
["rets_expiration_date"]=>
array(1) {
[0]=>
string(10) "2022-12-31"
}
["rets_off_market_date"]=>
array(1) {
[0]=>
string(10) "2022-07-26"
}
["rets_selling_agent_direct_work_phone"]=>
array(1) {
[0]=>
string(14) "(808) 260-6684"
}
["rets_selling_agent_email"]=>
array(1) {
[0]=>
string(17) "Jodi@Jodimews.com"
}
["rets_selling_agent_full_name"]=>
array(1) {
[0]=>
string(9) "Jodi Mews"
}
["rets_selling_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "46520"
}
["rets_selling_agent_mui"]=>
array(1) {
[0]=>
string(8) "10326742"
}
["rets_selling_office_mlsid"]=>
array(1) {
[0]=>
string(4) "PAKU"
}
["rets_selling_office_mui"]=>
array(1) {
[0]=>
string(7) "3486719"
}
["rets_selling_office_name"]=>
array(1) {
[0]=>
string(20) "Fathom Realty HI LLC"
}
["rets_selling_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 260-6684"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "22850131"
}
}
Array
(
[assd_val_imprv] => Array
(
[0] => 522900.00
)
[assd_val_land] => Array
(
[0] => 183600.00
)
[assd_val_total] => Array
(
[0] => 706500.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] => Pet on Property,Pets Allowed (Verify),Property Disclosure Stmt
)
[floor_covering] => Array
(
[0] => Laminate,W/W Carpet
)
[frontage] => Array
(
[0] => Marina
)
[full_baths] => Array
(
[0] => 2
)
[furnished] => Array
(
[0] => None
)
[half_baths] => Array
(
[0] => 0
)
[home_exampt] => Array
(
[0] => 100000
)
[lanai_sf] => Array
(
[0] => 119
)
[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] => Jodi@Jodimews.com
)
[list_agent_name] => Array
(
[0] => Jodi Mews
)
[list_agent_phone_number] => Array
(
[0] => (808) 260-6684
)
[list_date] => Array
(
[0] => 2022-06-26
)
[list_office_name] => Array
(
[0] => Fathom Realty HI LLC
)
[list_price] => Array
(
[0] => 870000.00
)
[living_sf] => Array
(
[0] => 1202
)
[location] => Array
(
[0] => 500 Lunalilo Home Road Unit 23B, Honolulu, HI 96825
)
[maintenance_fees] => Array
(
[0] => 947.67
)
[mls_] => Array
(
[0] => 202212268
)
[neighborhood] => Array
(
[0] => WEST MARINA
)
[number_of_parking_spaces] => Array
(
[0] => 2
)
[number_of_stories] => Array
(
[0] => One
)
[office_mls_id] => Array
(
[0] => PAKU
)
[parking_features] => Array
(
[0] => Covered - 2
)
[possession] => Array
(
[0] => At Closing
)
[postal_code] => Array
(
[0] => 96825
)
[property_condition] => Array
(
[0] => Above Average
)
[property_type] => Array
(
[0] => condo_townhouse
)
[property_type_label] => Array
(
[0] => Condo Townhouse
)
[region] => Array
(
[0] => HawaiiKai
)
[rets_active_continue_to_show_date] => Array
(
[0] => 2022-06-26
)
[rets_association_fee_total] => Array
(
[0] => 948
)
[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_compensation_method] => Array
(
[0] => %
)
[rets_condo_parking_unit] => Array
(
[0] => 112, 113
)
[rets_current_price] => Array
(
[0] => 870000.00
)
[rets_dom] => Array
(
[0] => 1
)
[rets_dual_variable_compensation_yn] => Array
(
[0] => 1
)
[rets_elevators_number_of] => Array
(
[0] => 6
)
[rets_floor_number] => Array
(
[0] => 3
)
[rets_foreclosure_yn] => Array
(
[0] => 0
)
[rets_fractional_ownership_yn] => Array
(
[0] => 0
)
[rets_id] => Array
(
[0] => 16727266
)
[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) 260-6684
)
[rets_list_agent_email] => Array
(
[0] => Jodi@Jodimews.com
)
[rets_list_agent_full_name] => Array
(
[0] => Jodi Mews
)
[rets_list_agent_mlsid] => Array
(
[0] => 46520
)
[rets_list_agent_mui] => Array
(
[0] => 10326742
)
[rets_list_office_mlsid] => Array
(
[0] => PAKU
)
[rets_list_office_mui] => Array
(
[0] => 3486719
)
[rets_list_office_name] => Array
(
[0] => Fathom Realty HI LLC
)
[rets_list_office_phone] => Array
(
[0] => (808) 260-6684
)
[rets_list_price] => Array
(
[0] => 870000.00
)
[rets_listing_contract_date] => Array
(
[0] => 2022-06-26
)
[rets_lot_size_area] => Array
(
[0] => 205821.00
)
[rets_maintenance_expense] => Array
(
[0] => 947.67
)
[rets_management_company_name] => Array
(
[0] => Touchstone
)
[rets_management_company_phone] => Array
(
[0] => 808-566-4100
)
[rets_matrix_modified_dt] => Array
(
[0] => 2022-07-26T09:13:34.343
)
[rets_matrix_unique_id] => Array
(
[0] => 16727266
)
[rets_mls_number] => Array
(
[0] => 202212268
)
[rets_neighbourhood] => Array
(
[0] => WEST MARINA
)
[rets_new_development_construction_yn] => Array
(
[0] => 0
)
[rets_original_entry_timestamp] => Array
(
[0] => 2022-06-27T09:47:03.867
)
[rets_original_list_price] => Array
(
[0] => 870000.00
)
[rets_owner_occupancy_percentage] => Array
(
[0] => 70
)
[rets_parcel_number] => Array
(
[0] => 1-3-9-008-009-0093
)
[rets_parking_additional] => Array
(
[0] => 10
)
[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] => 24
)
[rets_photo_modification_timestamp] => Array
(
[0] => 2022-06-27T09:47:03.867
)
[rets_postal_code] => Array
(
[0] => 96825
)
[rets_price_change_timestamp] => Array
(
[0] => 2022-06-27T09:47:03.867
)
[rets_primary_key] => Array
(
[0] => 16727266
)
[rets_private_remarks] => Array
(
[0] => Please consider Kevin Batungbacal at First American Title. For additional information and questions, please contact Jodi Mews 808-260-6684.
)
[rets_public_remarks] => Array
(
[0] => Views, upgrades, renovations and ready to move into! This unit is stunning with a complete kitchen remodel, brand new master bathroom, popcorn ceilings removed, freshly painted interior, Remote Controlled Retractable Lanai Screen for sun filtering and creates extra indoor space as necessary, security screen front door to allow for wonderful cross breeze, Brand new washer and dryer, Bosch AC Unit updated in 2020, Waterproof Pergo Laminate Flooring in Kitchen, Hallway, Dining and Living Areas, California Closets in both bedrooms and 2 assigned covered parking with extra storage lockers. The Esplanade provides resort style amenities that will satisfy all your senses! This lovely unit truly has everything you need and want!
)
[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] => 2022-07-26T09:13:34.343
)
[rets_status_contractual_search_date] => Array
(
[0] => 2022-07-26
)
[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.54$13.33$1.00$PxyJmW-XL2DyUVpyY84rNA
)
[rets_sub_agency_compensation] => Array
(
[0] => 2.5
)
[rets_tax_amount] => Array
(
[0] => 165.78
)
[rets_tax_annual_amount] => Array
(
[0] => 1989.36
)
[rets_tax_assessed_value] => Array
(
[0] => 706500.00
)
[rets_tax_assessed_value_improvements] => Array
(
[0] => 522900.00
)
[rets_tax_assessed_value_land] => Array
(
[0] => 183600.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/16727266/680e460508a63f4cb5f763be7bb76c91
)
[rets_tmk_area] => Array
(
[0] => 139
)
[rets_tmk_condo_property_regime_number] => Array
(
[0] => 93
)
[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] => 23B
)
[rets_year_built] => Array
(
[0] => 1973
)
[rets_year_remodeled] => Array
(
[0] => 2019
)
[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,VA
)
[tmk] => Array
(
[0] => 1-3-9-008-009-0093
)
[unit] => Array
(
[0] => Central AC,Odd# Unit
)
[unit_number] => Array
(
[0] => 23B
)
[view] => Array
(
[0] => Marina/Canal,Mountain
)
[wpp::rets_pk] => Array
(
[0] => 16727266
)
[wpp_gpid] => Array
(
[0] => 202212268
)
[wpp_import_schedule_id] => Array
(
[0] => 1463343682
)
[wpp_import_time] => Array
(
[0] => 1658862828
)
[year_built] => Array
(
[0] => 1973
)
[year_remodeled_] => Array
(
[0] => 2019
)
[zoning] => Array
(
[0] => 12 - A-2 Medium Density Apartme
)
[new_attached_media] => Array
(
[0] => a:63:{i:0;i:22556226;i:1;i:22556227;i:2;i:22556228;i:3;i:22556229;i:4;i:22556230;i:5;i:22556231;i:6;i:22556232;i:7;i:22556233;i:8;i:22556234;i:9;i:22556235;i:10;i:22556236;i:11;i:22556237;i:12;i:22556238;i:13;i:22556239;i:14;i:22556240;i:15;i:22556241;i:16;i:22556242;i:17;i:22556243;i:18;i:22556244;i:19;i:22556245;i:20;i:22556246;i:21;i:22562835;i:22;i:22562836;i:23;i:22562837;i:24;i:22562838;i:25;i:22562839;i:26;i:22562840;i:27;i:22562841;i:28;i:22562842;i:29;i:22562843;i:30;i:22562844;i:31;i:22562845;i:32;i:22562846;i:33;i:22562847;i:34;i:22562848;i:35;i:22562849;i:36;i:22562850;i:37;i:22562851;i:38;i:22562852;i:39;i:22562853;i:40;i:22562854;i:41;i:22562855;i:42;i:22850131;i:43;i:22850132;i:44;i:22850133;i:45;i:22850134;i:46;i:22850135;i:47;i:22850136;i:48;i:22850137;i:49;i:22850138;i:50;i:22850139;i:51;i:22850140;i:52;i:22850141;i:53;i:22850142;i:54;i:22850143;i:55;i:22850144;i:56;i:22850145;i:57;i:22850146;i:58;i:22850147;i:59;i:22850148;i:60;i:22850149;i:61;i:22850150;i:62;i:22850151;}
)
[rets_close_date] => Array
(
[0] => 2022-07-26
)
[rets_close_price] => Array
(
[0] => 870000.00
)
[rets_expiration_date] => Array
(
[0] => 2022-12-31
)
[rets_off_market_date] => Array
(
[0] => 2022-07-26
)
[rets_selling_agent_direct_work_phone] => Array
(
[0] => (808) 260-6684
)
[rets_selling_agent_email] => Array
(
[0] => Jodi@Jodimews.com
)
[rets_selling_agent_full_name] => Array
(
[0] => Jodi Mews
)
[rets_selling_agent_mlsid] => Array
(
[0] => 46520
)
[rets_selling_agent_mui] => Array
(
[0] => 10326742
)
[rets_selling_office_mlsid] => Array
(
[0] => PAKU
)
[rets_selling_office_mui] => Array
(
[0] => 3486719
)
[rets_selling_office_name] => Array
(
[0] => Fathom Realty HI LLC
)
[rets_selling_office_phone] => Array
(
[0] => (808) 260-6684
)
[_thumbnail_id] => Array
(
[0] => 22850131
)
)
CONTACT US
#RB-7120
info@marcushawaii.com
(808)839-7446