Rarely available “end unit” single family, detached home by mile-long Beach park. This house feels like your own private beach with expansive ocean and sandy beach frontage. Built as a 1 bdrm, 1 bath, however it has two rooms and 1.5 baths. The scenery from your extra large windows are truly breathtaking! Hawaiian Monk seals regularly visit the beach, turtles feed around the reef, stingrays swim by, and whales breach in the distance. Cute and fully functional home ready to move in right away, with full furnishings available. Bring your imagination and build up to make this diamond in the rough your true dream home. Location, location, location!
Listing by: Century 21 Island Homes (808) 354-0789
array(164) {
["agency"]=>
array(1) {
[0]=>
string(23) "Century 21 Island Homes"
}
["assd_val_imprv"]=>
array(1) {
[0]=>
string(8) "89500.00"
}
["assd_val_land"]=>
array(1) {
[0]=>
string(9) "504000.00"
}
["assd_val_total"]=>
array(1) {
[0]=>
string(9) "893500.00"
}
["bedrooms"]=>
array(1) {
[0]=>
string(1) "2"
}
["building_style"]=>
array(1) {
[0]=>
string(20) "Detach Single Family"
}
["city"]=>
array(1) {
[0]=>
string(6) "Hauula"
}
["county"]=>
array(1) {
[0]=>
string(4) "Oahu"
}
["disclosures"]=>
array(1) {
[0]=>
string(40) "Pet on Property,Property Disclosure Stmt"
}
["easements"]=>
array(1) {
[0]=>
string(4) "None"
}
["floor_covering"]=>
array(1) {
[0]=>
string(27) "Ceramic Tile,Laminate,Vinyl"
}
["frontage"]=>
array(1) {
[0]=>
string(5) "Ocean"
}
["full_baths"]=>
array(1) {
[0]=>
string(1) "1"
}
["furnished"]=>
array(1) {
[0]=>
string(7) "Partial"
}
["half_baths"]=>
array(1) {
[0]=>
string(1) "1"
}
["home_exampt"]=>
array(1) {
[0]=>
string(1) "0"
}
["lanai_sf"]=>
array(1) {
[0]=>
string(3) "104"
}
["land_area_sf"]=>
array(1) {
[0]=>
string(7) "2875.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(24) "Laura@C21IslandHomes.com"
}
["list_agent_name"]=>
array(1) {
[0]=>
string(17) "Laura Awana Lewis"
}
["list_agent_phone_number"]=>
array(1) {
[0]=>
string(14) "(808) 354-0789"
}
["list_date"]=>
array(1) {
[0]=>
string(10) "2022-05-24"
}
["list_office_name"]=>
array(1) {
[0]=>
string(23) "Century 21 Island Homes"
}
["list_price"]=>
array(1) {
[0]=>
string(9) "749000.00"
}
["living_sf"]=>
array(1) {
[0]=>
string(3) "814"
}
["location"]=>
array(1) {
[0]=>
string(43) "54-065 Kamehameha Highway, Hauula, HI 96717"
}
["mls_"]=>
array(1) {
[0]=>
string(9) "202209932"
}
["neighborhood"]=>
array(1) {
[0]=>
string(6) "HAUULA"
}
["number_of_parking_spaces"]=>
array(1) {
[0]=>
string(1) "4"
}
["number_of_stories"]=>
array(1) {
[0]=>
string(3) "One"
}
["office_mls_id"]=>
array(1) {
[0]=>
string(6) "CENI04"
}
["parking_features"]=>
array(1) {
[0]=>
string(11) "3 Car+,Boat"
}
["pool_"]=>
array(1) {
[0]=>
string(4) "None"
}
["possession"]=>
array(1) {
[0]=>
string(10) "At Closing"
}
["postal_code"]=>
array(1) {
[0]=>
string(5) "96717"
}
["property_condition"]=>
array(1) {
[0]=>
string(7) "Average"
}
["property_type"]=>
array(1) {
[0]=>
string(13) "single_family"
}
["property_type_label"]=>
array(1) {
[0]=>
string(13) "single_family"
}
["region"]=>
array(1) {
[0]=>
string(7) "Kaneohe"
}
["rets_baths_full"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_baths_half"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_baths_total"]=>
array(1) {
[0]=>
string(4) "1.01"
}
["rets_beds_total"]=>
array(1) {
[0]=>
string(1) "2"
}
["rets_city"]=>
array(1) {
[0]=>
string(6) "Hauula"
}
["rets_co_list_agent_direct_work_phone"]=>
array(1) {
[0]=>
string(14) "(808) 354-0789"
}
["rets_co_list_agent_email"]=>
array(1) {
[0]=>
string(24) "patty@c21islandhomes.com"
}
["rets_co_list_agent_full_name"]=>
array(1) {
[0]=>
string(17) "Patricia L Parker"
}
["rets_co_list_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "51602"
}
["rets_co_list_agent_mui"]=>
array(1) {
[0]=>
string(8) "16079380"
}
["rets_co_list_office_mlsid"]=>
array(1) {
[0]=>
string(6) "CENI04"
}
["rets_co_list_office_mui"]=>
array(1) {
[0]=>
string(8) "14616840"
}
["rets_co_list_office_name"]=>
array(1) {
[0]=>
string(23) "Century 21 Island Homes"
}
["rets_co_list_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 354-0789"
}
["rets_compensation_method"]=>
array(1) {
[0]=>
string(1) "%"
}
["rets_condo_property_regime_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_current_price"]=>
array(1) {
[0]=>
string(9) "860000.00"
}
["rets_dom"]=>
array(1) {
[0]=>
string(2) "10"
}
["rets_dual_variable_compensation_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["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) "16664442"
}
["rets_immoviewer_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_internet_automated_valuation_dis"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_internet_consumer_comment_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_list_agent_direct_work_phone"]=>
array(1) {
[0]=>
string(14) "(808) 354-0789"
}
["rets_list_agent_email"]=>
array(1) {
[0]=>
string(24) "Laura@C21IslandHomes.com"
}
["rets_list_agent_full_name"]=>
array(1) {
[0]=>
string(17) "Laura Awana Lewis"
}
["rets_list_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "26114"
}
["rets_list_agent_mui"]=>
array(1) {
[0]=>
string(7) "3475835"
}
["rets_list_office_mlsid"]=>
array(1) {
[0]=>
string(6) "CENI04"
}
["rets_list_office_mui"]=>
array(1) {
[0]=>
string(8) "14616840"
}
["rets_list_office_name"]=>
array(1) {
[0]=>
string(23) "Century 21 Island Homes"
}
["rets_list_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 354-0789"
}
["rets_list_price"]=>
array(1) {
[0]=>
string(9) "749000.00"
}
["rets_listing_contract_date"]=>
array(1) {
[0]=>
string(10) "2022-05-24"
}
["rets_lot_size_area"]=>
array(1) {
[0]=>
string(7) "2875.00"
}
["rets_matrix_modified_dt"]=>
array(1) {
[0]=>
string(23) "2022-06-30T10:16:25.890"
}
["rets_matrix_unique_id"]=>
array(1) {
[0]=>
string(8) "16664442"
}
["rets_mls_number"]=>
array(1) {
[0]=>
string(9) "202209932"
}
["rets_neighbourhood"]=>
array(1) {
[0]=>
string(6) "HAUULA"
}
["rets_new_development_construction_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_original_entry_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-05-24T14:13:07.120"
}
["rets_original_list_price"]=>
array(1) {
[0]=>
string(9) "749000.00"
}
["rets_parcel_number"]=>
array(1) {
[0]=>
string(18) "1-5-4-009-030-0000"
}
["rets_parking_total"]=>
array(1) {
[0]=>
string(1) "4"
}
["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) "23"
}
["rets_photo_modification_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-05-24T14:13:07.120"
}
["rets_postal_code"]=>
array(1) {
[0]=>
string(5) "96717"
}
["rets_primary_key"]=>
array(1) {
[0]=>
string(8) "16664442"
}
["rets_private_remarks"]=>
array(1) {
[0]=>
string(361) "EZ2C. Please use Showing Time. Short notice may be okay, prefer at least 2 hours. Home is pet and owner-occupied. Open House Sunday 5/29 12:00 to 4:00pm. Seller wishes to give 7 to 10 days for market exposure, but reserves the right to accept an offer prior. See Supplements. Please use As-Is addendum. Actual bedrooms/baths do not match TMK / qPublic records."
}
["rets_public_remarks"]=>
array(1) {
[0]=>
string(660) "Rarely available "end unit" single family, detached home by mile-long Beach park. This house feels like your own private beach with expansive ocean and sandy beach frontage. Built as a 1 bdrm, 1 bath, however it has two rooms and 1.5 baths. The scenery from your extra large windows are truly breathtaking! Hawaiian Monk seals regularly visit the beach, turtles feed around the reef, stingrays swim by, and whales breach in the distance. Cute and fully functional home ready to move in right away, with full furnishings available. Bring your imagination and build up to make this diamond in the rough your true dream home. Location, location, location!"
}
["rets_room_count"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_sqft_lanai_open"]=>
array(1) {
[0]=>
string(3) "104"
}
["rets_sqft_roofed_living"]=>
array(1) {
[0]=>
string(3) "710"
}
["rets_sqft_total"]=>
array(1) {
[0]=>
string(3) "814"
}
["rets_state_or_province"]=>
array(1) {
[0]=>
string(2) "HI"
}
["rets_status_change_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-06-30T10:16:25.890"
}
["rets_status_contractual_search_date"]=>
array(1) {
[0]=>
string(10) "2022-06-30"
}
["rets_street_name"]=>
array(1) {
[0]=>
string(10) "Kamehameha"
}
["rets_street_number"]=>
array(1) {
[0]=>
string(6) "54-065"
}
["rets_street_view_param"]=>
array(1) {
[0]=>
string(104) "1$21.608262$-157.908631$5.98$13.33$1.00$CAoSLEFGMVFpcE9BT0NFdkdyY1ZYTnlGMGZzS25MZUZfRXd3MHppMVZqekpRMWht"
}
["rets_sub_agency_compensation"]=>
array(1) {
[0]=>
string(3) "2.5"
}
["rets_tax_amount"]=>
array(1) {
[0]=>
string(6) "174.00"
}
["rets_tax_annual_amount"]=>
array(1) {
[0]=>
string(7) "2088.00"
}
["rets_tax_assessed_value"]=>
array(1) {
[0]=>
string(9) "893500.00"
}
["rets_tax_assessed_value_improvements"]=>
array(1) {
[0]=>
string(8) "89500.00"
}
["rets_tax_assessed_value_land"]=>
array(1) {
[0]=>
string(9) "504000.00"
}
["rets_tax_excemption_owner_occupancy"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_tax_paid_by_seller_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_tax_year"]=>
array(1) {
[0]=>
string(4) "2021"
}
["rets_thumbnail_url"]=>
array(1) {
[0]=>
string(81) "https://cdn.rets.ci/marcusrealty-images/16664442/6f9417511a24f7b9835fb700ea8ad62d"
}
["rets_tmk_area"]=>
array(1) {
[0]=>
string(3) "154"
}
["rets_tmk_condo_property_regime_number"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_tmk_division"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_tmk_parcel"]=>
array(1) {
[0]=>
string(2) "30"
}
["rets_tmk_section"]=>
array(1) {
[0]=>
string(1) "4"
}
["rets_tmk_zone"]=>
array(1) {
[0]=>
string(1) "5"
}
["rets_tmkplat"]=>
array(1) {
[0]=>
string(1) "9"
}
["rets_year_built"]=>
array(1) {
[0]=>
string(4) "1947"
}
["rets_year_remodeled"]=>
array(1) {
[0]=>
string(4) "1987"
}
["security"]=>
array(1) {
[0]=>
string(3) "Key"
}
["setbacks"]=>
array(1) {
[0]=>
string(9) "Of Record"
}
["state_or_province"]=>
array(1) {
[0]=>
string(2) "HI"
}
["status"]=>
array(1) {
[0]=>
string(4) "Sold"
}
["street_name"]=>
array(1) {
[0]=>
string(10) "Kamehameha"
}
["street_number"]=>
array(1) {
[0]=>
string(6) "54-065"
}
["street_suffix"]=>
array(1) {
[0]=>
string(7) "Highway"
}
["terms_accept"]=>
array(1) {
[0]=>
string(17) "Cash,Conventional"
}
["tmk"]=>
array(1) {
[0]=>
string(18) "1-5-4-009-030-0000"
}
["topography"]=>
array(1) {
[0]=>
string(5) "Clear"
}
["view"]=>
array(1) {
[0]=>
string(23) "Coastline,Ocean,Sunrise"
}
["wpp::rets_pk"]=>
array(1) {
[0]=>
string(8) "16664442"
}
["wpp_gpid"]=>
array(1) {
[0]=>
string(9) "202209932"
}
["wpp_import_schedule_id"]=>
array(1) {
[0]=>
string(10) "1463343682"
}
["wpp_import_time"]=>
array(1) {
[0]=>
string(10) "1656620242"
}
["year_built"]=>
array(1) {
[0]=>
string(4) "1947"
}
["year_remodeled_"]=>
array(1) {
[0]=>
string(4) "1987"
}
["zoning"]=>
array(1) {
[0]=>
string(29) "05 - R-5 Residential District"
}
["new_attached_media"]=>
array(1) {
[0]=>
string(3111) "a:189:{i:0;i:22292023;i:1;i:22292024;i:2;i:22292025;i:3;i:22292026;i:4;i:22292027;i:5;i:22292028;i:6;i:22292029;i:7;i:22292030;i:8;i:22292031;i:9;i:22292032;i:10;i:22292033;i:11;i:22292034;i:12;i:22292035;i:13;i:22292036;i:14;i:22292037;i:15;i:22292038;i:16;i:22292039;i:17;i:22292040;i:18;i:22292041;i:19;i:22292042;i:20;i:22292043;i:21;i:22295355;i:22;i:22295356;i:23;i:22295357;i:24;i:22295358;i:25;i:22295359;i:26;i:22295360;i:27;i:22295361;i:28;i:22295362;i:29;i:22295363;i:30;i:22295364;i:31;i:22295365;i:32;i:22295366;i:33;i:22295367;i:34;i:22295368;i:35;i:22295369;i:36;i:22295370;i:37;i:22295371;i:38;i:22295372;i:39;i:22295373;i:40;i:22295374;i:41;i:22295375;i:42;i:22295802;i:43;i:22295803;i:44;i:22295804;i:45;i:22295805;i:46;i:22295806;i:47;i:22295807;i:48;i:22295808;i:49;i:22295809;i:50;i:22295810;i:51;i:22295811;i:52;i:22295812;i:53;i:22295813;i:54;i:22295814;i:55;i:22295815;i:56;i:22295816;i:57;i:22295817;i:58;i:22295818;i:59;i:22295819;i:60;i:22295820;i:61;i:22295821;i:62;i:22295822;i:63;i:22295865;i:64;i:22295866;i:65;i:22295867;i:66;i:22295868;i:67;i:22295869;i:68;i:22295870;i:69;i:22295871;i:70;i:22295872;i:71;i:22295873;i:72;i:22295874;i:73;i:22295875;i:74;i:22295876;i:75;i:22295877;i:76;i:22295878;i:77;i:22295879;i:78;i:22295880;i:79;i:22295881;i:80;i:22295882;i:81;i:22295883;i:82;i:22295884;i:83;i:22295885;i:84;i:22302019;i:85;i:22302020;i:86;i:22302021;i:87;i:22302022;i:88;i:22302023;i:89;i:22302024;i:90;i:22302025;i:91;i:22302026;i:92;i:22302027;i:93;i:22302028;i:94;i:22302029;i:95;i:22302030;i:96;i:22302031;i:97;i:22302032;i:98;i:22302033;i:99;i:22302034;i:100;i:22302035;i:101;i:22302036;i:102;i:22302037;i:103;i:22302038;i:104;i:22302039;i:105;i:22302040;i:106;i:22302041;i:107;i:22302042;i:108;i:22302043;i:109;i:22302044;i:110;i:22302045;i:111;i:22302046;i:112;i:22302047;i:113;i:22302048;i:114;i:22302049;i:115;i:22302050;i:116;i:22302051;i:117;i:22302052;i:118;i:22302053;i:119;i:22302054;i:120;i:22302055;i:121;i:22302056;i:122;i:22302057;i:123;i:22302058;i:124;i:22302059;i:125;i:22302060;i:126;i:22322144;i:127;i:22322145;i:128;i:22322146;i:129;i:22322147;i:130;i:22322148;i:131;i:22322149;i:132;i:22322150;i:133;i:22322151;i:134;i:22322152;i:135;i:22322153;i:136;i:22322154;i:137;i:22322155;i:138;i:22322156;i:139;i:22322157;i:140;i:22322158;i:141;i:22322159;i:142;i:22322160;i:143;i:22322161;i:144;i:22322162;i:145;i:22322163;i:146;i:22322164;i:147;i:22355460;i:148;i:22355461;i:149;i:22355462;i:150;i:22355463;i:151;i:22355464;i:152;i:22355465;i:153;i:22355466;i:154;i:22355467;i:155;i:22355468;i:156;i:22355469;i:157;i:22355470;i:158;i:22355471;i:159;i:22355472;i:160;i:22355473;i:161;i:22355474;i:162;i:22355475;i:163;i:22355476;i:164;i:22355477;i:165;i:22355478;i:166;i:22355479;i:167;i:22355480;i:168;i:22585995;i:169;i:22585996;i:170;i:22585997;i:171;i:22585998;i:172;i:22585999;i:173;i:22586000;i:174;i:22586001;i:175;i:22586002;i:176;i:22586003;i:177;i:22586004;i:178;i:22586005;i:179;i:22586006;i:180;i:22586007;i:181;i:22586008;i:182;i:22586009;i:183;i:22586010;i:184;i:22586011;i:185;i:22586012;i:186;i:22586013;i:187;i:22586014;i:188;i:22586015;}"
}
["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_supplement_count"]=>
array(1) {
[0]=>
string(1) "4"
}
["rets_supplement_modification_timestam"]=>
array(1) {
[0]=>
string(23) "2022-05-25T08:36:25.290"
}
["rets_pending_date"]=>
array(1) {
[0]=>
string(10) "2022-06-01"
}
["rets_close_date"]=>
array(1) {
[0]=>
string(10) "2022-06-30"
}
["rets_close_price"]=>
array(1) {
[0]=>
string(9) "860000.00"
}
["rets_expiration_date"]=>
array(1) {
[0]=>
string(10) "2022-11-24"
}
["rets_off_market_date"]=>
array(1) {
[0]=>
string(10) "2022-06-30"
}
["rets_selling_agent_direct_work_phone"]=>
array(1) {
[0]=>
string(14) "(808) 518-3429"
}
["rets_selling_agent_email"]=>
array(1) {
[0]=>
string(25) "tyler.hinderer@redfin.com"
}
["rets_selling_agent_full_name"]=>
array(1) {
[0]=>
string(14) "Tyler Hinderer"
}
["rets_selling_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "44286"
}
["rets_selling_agent_mui"]=>
array(1) {
[0]=>
string(7) "9013691"
}
["rets_selling_agent_remarks"]=>
array(1) {
[0]=>
string(42) "Thanks for the smooth transaction, Tyler!!"
}
["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) "22585995"
}
}
Array
(
[agency] => Array
(
[0] => Century 21 Island Homes
)
[assd_val_imprv] => Array
(
[0] => 89500.00
)
[assd_val_land] => Array
(
[0] => 504000.00
)
[assd_val_total] => Array
(
[0] => 893500.00
)
[bedrooms] => Array
(
[0] => 2
)
[building_style] => Array
(
[0] => Detach Single Family
)
[city] => Array
(
[0] => Hauula
)
[county] => Array
(
[0] => Oahu
)
[disclosures] => Array
(
[0] => Pet on Property,Property Disclosure Stmt
)
[easements] => Array
(
[0] => None
)
[floor_covering] => Array
(
[0] => Ceramic Tile,Laminate,Vinyl
)
[frontage] => Array
(
[0] => Ocean
)
[full_baths] => Array
(
[0] => 1
)
[furnished] => Array
(
[0] => Partial
)
[half_baths] => Array
(
[0] => 1
)
[home_exampt] => Array
(
[0] => 0
)
[lanai_sf] => Array
(
[0] => 104
)
[land_area_sf] => Array
(
[0] => 2875.00
)
[land_recorded] => Array
(
[0] => Regular System
)
[land_tenure] => Array
(
[0] => FS - Fee Simple
)
[list_agent_email] => Array
(
[0] => Laura@C21IslandHomes.com
)
[list_agent_name] => Array
(
[0] => Laura Awana Lewis
)
[list_agent_phone_number] => Array
(
[0] => (808) 354-0789
)
[list_date] => Array
(
[0] => 2022-05-24
)
[list_office_name] => Array
(
[0] => Century 21 Island Homes
)
[list_price] => Array
(
[0] => 749000.00
)
[living_sf] => Array
(
[0] => 814
)
[location] => Array
(
[0] => 54-065 Kamehameha Highway, Hauula, HI 96717
)
[mls_] => Array
(
[0] => 202209932
)
[neighborhood] => Array
(
[0] => HAUULA
)
[number_of_parking_spaces] => Array
(
[0] => 4
)
[number_of_stories] => Array
(
[0] => One
)
[office_mls_id] => Array
(
[0] => CENI04
)
[parking_features] => Array
(
[0] => 3 Car+,Boat
)
[pool_] => Array
(
[0] => None
)
[possession] => Array
(
[0] => At Closing
)
[postal_code] => Array
(
[0] => 96717
)
[property_condition] => Array
(
[0] => Average
)
[property_type] => Array
(
[0] => single_family
)
[property_type_label] => Array
(
[0] => single_family
)
[region] => Array
(
[0] => Kaneohe
)
[rets_baths_full] => Array
(
[0] => 1
)
[rets_baths_half] => Array
(
[0] => 1
)
[rets_baths_total] => Array
(
[0] => 1.01
)
[rets_beds_total] => Array
(
[0] => 2
)
[rets_city] => Array
(
[0] => Hauula
)
[rets_co_list_agent_direct_work_phone] => Array
(
[0] => (808) 354-0789
)
[rets_co_list_agent_email] => Array
(
[0] => patty@c21islandhomes.com
)
[rets_co_list_agent_full_name] => Array
(
[0] => Patricia L Parker
)
[rets_co_list_agent_mlsid] => Array
(
[0] => 51602
)
[rets_co_list_agent_mui] => Array
(
[0] => 16079380
)
[rets_co_list_office_mlsid] => Array
(
[0] => CENI04
)
[rets_co_list_office_mui] => Array
(
[0] => 14616840
)
[rets_co_list_office_name] => Array
(
[0] => Century 21 Island Homes
)
[rets_co_list_office_phone] => Array
(
[0] => (808) 354-0789
)
[rets_compensation_method] => Array
(
[0] => %
)
[rets_condo_property_regime_yn] => Array
(
[0] => 0
)
[rets_current_price] => Array
(
[0] => 860000.00
)
[rets_dom] => Array
(
[0] => 10
)
[rets_dual_variable_compensation_yn] => Array
(
[0] => 0
)
[rets_foreclosure_yn] => Array
(
[0] => 0
)
[rets_fractional_ownership_yn] => Array
(
[0] => 0
)
[rets_id] => Array
(
[0] => 16664442
)
[rets_immoviewer_yn] => Array
(
[0] => 0
)
[rets_internet_automated_valuation_dis] => Array
(
[0] => 0
)
[rets_internet_consumer_comment_yn] => Array
(
[0] => 0
)
[rets_list_agent_direct_work_phone] => Array
(
[0] => (808) 354-0789
)
[rets_list_agent_email] => Array
(
[0] => Laura@C21IslandHomes.com
)
[rets_list_agent_full_name] => Array
(
[0] => Laura Awana Lewis
)
[rets_list_agent_mlsid] => Array
(
[0] => 26114
)
[rets_list_agent_mui] => Array
(
[0] => 3475835
)
[rets_list_office_mlsid] => Array
(
[0] => CENI04
)
[rets_list_office_mui] => Array
(
[0] => 14616840
)
[rets_list_office_name] => Array
(
[0] => Century 21 Island Homes
)
[rets_list_office_phone] => Array
(
[0] => (808) 354-0789
)
[rets_list_price] => Array
(
[0] => 749000.00
)
[rets_listing_contract_date] => Array
(
[0] => 2022-05-24
)
[rets_lot_size_area] => Array
(
[0] => 2875.00
)
[rets_matrix_modified_dt] => Array
(
[0] => 2022-06-30T10:16:25.890
)
[rets_matrix_unique_id] => Array
(
[0] => 16664442
)
[rets_mls_number] => Array
(
[0] => 202209932
)
[rets_neighbourhood] => Array
(
[0] => HAUULA
)
[rets_new_development_construction_yn] => Array
(
[0] => 0
)
[rets_original_entry_timestamp] => Array
(
[0] => 2022-05-24T14:13:07.120
)
[rets_original_list_price] => Array
(
[0] => 749000.00
)
[rets_parcel_number] => Array
(
[0] => 1-5-4-009-030-0000
)
[rets_parking_total] => Array
(
[0] => 4
)
[rets_permit_address_internet_yn] => Array
(
[0] => 1
)
[rets_permit_internet_yn] => Array
(
[0] => 1
)
[rets_photo_count] => Array
(
[0] => 23
)
[rets_photo_modification_timestamp] => Array
(
[0] => 2022-05-24T14:13:07.120
)
[rets_postal_code] => Array
(
[0] => 96717
)
[rets_primary_key] => Array
(
[0] => 16664442
)
[rets_private_remarks] => Array
(
[0] => EZ2C. Please use Showing Time. Short notice may be okay, prefer at least 2 hours. Home is pet and owner-occupied. Open House Sunday 5/29 12:00 to 4:00pm. Seller wishes to give 7 to 10 days for market exposure, but reserves the right to accept an offer prior. See Supplements. Please use As-Is addendum. Actual bedrooms/baths do not match TMK / qPublic records.
)
[rets_public_remarks] => Array
(
[0] => Rarely available "end unit" single family, detached home by mile-long Beach park. This house feels like your own private beach with expansive ocean and sandy beach frontage. Built as a 1 bdrm, 1 bath, however it has two rooms and 1.5 baths. The scenery from your extra large windows are truly breathtaking! Hawaiian Monk seals regularly visit the beach, turtles feed around the reef, stingrays swim by, and whales breach in the distance. Cute and fully functional home ready to move in right away, with full furnishings available. Bring your imagination and build up to make this diamond in the rough your true dream home. Location, location, location!
)
[rets_room_count] => Array
(
[0] => 0
)
[rets_sqft_lanai_open] => Array
(
[0] => 104
)
[rets_sqft_roofed_living] => Array
(
[0] => 710
)
[rets_sqft_total] => Array
(
[0] => 814
)
[rets_state_or_province] => Array
(
[0] => HI
)
[rets_status_change_timestamp] => Array
(
[0] => 2022-06-30T10:16:25.890
)
[rets_status_contractual_search_date] => Array
(
[0] => 2022-06-30
)
[rets_street_name] => Array
(
[0] => Kamehameha
)
[rets_street_number] => Array
(
[0] => 54-065
)
[rets_street_view_param] => Array
(
[0] => 1$21.608262$-157.908631$5.98$13.33$1.00$CAoSLEFGMVFpcE9BT0NFdkdyY1ZYTnlGMGZzS25MZUZfRXd3MHppMVZqekpRMWht
)
[rets_sub_agency_compensation] => Array
(
[0] => 2.5
)
[rets_tax_amount] => Array
(
[0] => 174.00
)
[rets_tax_annual_amount] => Array
(
[0] => 2088.00
)
[rets_tax_assessed_value] => Array
(
[0] => 893500.00
)
[rets_tax_assessed_value_improvements] => Array
(
[0] => 89500.00
)
[rets_tax_assessed_value_land] => Array
(
[0] => 504000.00
)
[rets_tax_excemption_owner_occupancy] => Array
(
[0] => 0
)
[rets_tax_paid_by_seller_yn] => Array
(
[0] => 0
)
[rets_tax_year] => Array
(
[0] => 2021
)
[rets_thumbnail_url] => Array
(
[0] => https://cdn.rets.ci/marcusrealty-images/16664442/6f9417511a24f7b9835fb700ea8ad62d
)
[rets_tmk_area] => Array
(
[0] => 154
)
[rets_tmk_condo_property_regime_number] => Array
(
[0] => 0
)
[rets_tmk_division] => Array
(
[0] => 1
)
[rets_tmk_parcel] => Array
(
[0] => 30
)
[rets_tmk_section] => Array
(
[0] => 4
)
[rets_tmk_zone] => Array
(
[0] => 5
)
[rets_tmkplat] => Array
(
[0] => 9
)
[rets_year_built] => Array
(
[0] => 1947
)
[rets_year_remodeled] => Array
(
[0] => 1987
)
[security] => Array
(
[0] => Key
)
[setbacks] => Array
(
[0] => Of Record
)
[state_or_province] => Array
(
[0] => HI
)
[status] => Array
(
[0] => Sold
)
[street_name] => Array
(
[0] => Kamehameha
)
[street_number] => Array
(
[0] => 54-065
)
[street_suffix] => Array
(
[0] => Highway
)
[terms_accept] => Array
(
[0] => Cash,Conventional
)
[tmk] => Array
(
[0] => 1-5-4-009-030-0000
)
[topography] => Array
(
[0] => Clear
)
[view] => Array
(
[0] => Coastline,Ocean,Sunrise
)
[wpp::rets_pk] => Array
(
[0] => 16664442
)
[wpp_gpid] => Array
(
[0] => 202209932
)
[wpp_import_schedule_id] => Array
(
[0] => 1463343682
)
[wpp_import_time] => Array
(
[0] => 1656620242
)
[year_built] => Array
(
[0] => 1947
)
[year_remodeled_] => Array
(
[0] => 1987
)
[zoning] => Array
(
[0] => 05 - R-5 Residential District
)
[new_attached_media] => Array
(
[0] => a:189:{i:0;i:22292023;i:1;i:22292024;i:2;i:22292025;i:3;i:22292026;i:4;i:22292027;i:5;i:22292028;i:6;i:22292029;i:7;i:22292030;i:8;i:22292031;i:9;i:22292032;i:10;i:22292033;i:11;i:22292034;i:12;i:22292035;i:13;i:22292036;i:14;i:22292037;i:15;i:22292038;i:16;i:22292039;i:17;i:22292040;i:18;i:22292041;i:19;i:22292042;i:20;i:22292043;i:21;i:22295355;i:22;i:22295356;i:23;i:22295357;i:24;i:22295358;i:25;i:22295359;i:26;i:22295360;i:27;i:22295361;i:28;i:22295362;i:29;i:22295363;i:30;i:22295364;i:31;i:22295365;i:32;i:22295366;i:33;i:22295367;i:34;i:22295368;i:35;i:22295369;i:36;i:22295370;i:37;i:22295371;i:38;i:22295372;i:39;i:22295373;i:40;i:22295374;i:41;i:22295375;i:42;i:22295802;i:43;i:22295803;i:44;i:22295804;i:45;i:22295805;i:46;i:22295806;i:47;i:22295807;i:48;i:22295808;i:49;i:22295809;i:50;i:22295810;i:51;i:22295811;i:52;i:22295812;i:53;i:22295813;i:54;i:22295814;i:55;i:22295815;i:56;i:22295816;i:57;i:22295817;i:58;i:22295818;i:59;i:22295819;i:60;i:22295820;i:61;i:22295821;i:62;i:22295822;i:63;i:22295865;i:64;i:22295866;i:65;i:22295867;i:66;i:22295868;i:67;i:22295869;i:68;i:22295870;i:69;i:22295871;i:70;i:22295872;i:71;i:22295873;i:72;i:22295874;i:73;i:22295875;i:74;i:22295876;i:75;i:22295877;i:76;i:22295878;i:77;i:22295879;i:78;i:22295880;i:79;i:22295881;i:80;i:22295882;i:81;i:22295883;i:82;i:22295884;i:83;i:22295885;i:84;i:22302019;i:85;i:22302020;i:86;i:22302021;i:87;i:22302022;i:88;i:22302023;i:89;i:22302024;i:90;i:22302025;i:91;i:22302026;i:92;i:22302027;i:93;i:22302028;i:94;i:22302029;i:95;i:22302030;i:96;i:22302031;i:97;i:22302032;i:98;i:22302033;i:99;i:22302034;i:100;i:22302035;i:101;i:22302036;i:102;i:22302037;i:103;i:22302038;i:104;i:22302039;i:105;i:22302040;i:106;i:22302041;i:107;i:22302042;i:108;i:22302043;i:109;i:22302044;i:110;i:22302045;i:111;i:22302046;i:112;i:22302047;i:113;i:22302048;i:114;i:22302049;i:115;i:22302050;i:116;i:22302051;i:117;i:22302052;i:118;i:22302053;i:119;i:22302054;i:120;i:22302055;i:121;i:22302056;i:122;i:22302057;i:123;i:22302058;i:124;i:22302059;i:125;i:22302060;i:126;i:22322144;i:127;i:22322145;i:128;i:22322146;i:129;i:22322147;i:130;i:22322148;i:131;i:22322149;i:132;i:22322150;i:133;i:22322151;i:134;i:22322152;i:135;i:22322153;i:136;i:22322154;i:137;i:22322155;i:138;i:22322156;i:139;i:22322157;i:140;i:22322158;i:141;i:22322159;i:142;i:22322160;i:143;i:22322161;i:144;i:22322162;i:145;i:22322163;i:146;i:22322164;i:147;i:22355460;i:148;i:22355461;i:149;i:22355462;i:150;i:22355463;i:151;i:22355464;i:152;i:22355465;i:153;i:22355466;i:154;i:22355467;i:155;i:22355468;i:156;i:22355469;i:157;i:22355470;i:158;i:22355471;i:159;i:22355472;i:160;i:22355473;i:161;i:22355474;i:162;i:22355475;i:163;i:22355476;i:164;i:22355477;i:165;i:22355478;i:166;i:22355479;i:167;i:22355480;i:168;i:22585995;i:169;i:22585996;i:170;i:22585997;i:171;i:22585998;i:172;i:22585999;i:173;i:22586000;i:174;i:22586001;i:175;i:22586002;i:176;i:22586003;i:177;i:22586004;i:178;i:22586005;i:179;i:22586006;i:180;i:22586007;i:181;i:22586008;i:182;i:22586009;i:183;i:22586010;i:184;i:22586011;i:185;i:22586012;i:186;i:22586013;i:187;i:22586014;i:188;i:22586015;}
)
[rets_open_house_count] => Array
(
[0] => 1
)
[rets_active_open_house_count] => Array
(
[0] => 0
)
[rets_open_house_upcoming] => Array
(
[0] =>
)
[rets_supplement_count] => Array
(
[0] => 4
)
[rets_supplement_modification_timestam] => Array
(
[0] => 2022-05-25T08:36:25.290
)
[rets_pending_date] => Array
(
[0] => 2022-06-01
)
[rets_close_date] => Array
(
[0] => 2022-06-30
)
[rets_close_price] => Array
(
[0] => 860000.00
)
[rets_expiration_date] => Array
(
[0] => 2022-11-24
)
[rets_off_market_date] => Array
(
[0] => 2022-06-30
)
[rets_selling_agent_direct_work_phone] => Array
(
[0] => (808) 518-3429
)
[rets_selling_agent_email] => Array
(
[0] => tyler.hinderer@redfin.com
)
[rets_selling_agent_full_name] => Array
(
[0] => Tyler Hinderer
)
[rets_selling_agent_mlsid] => Array
(
[0] => 44286
)
[rets_selling_agent_mui] => Array
(
[0] => 9013691
)
[rets_selling_agent_remarks] => Array
(
[0] => Thanks for the smooth transaction, Tyler!!
)
[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] => 22585995
)
)
CONTACT US
#RB-7120
info@marcushawaii.com
(808)839-7446