Amazing Hauula front-gated coastal home affords you true Hawaiian lifestyle. Every detail has been thought of from the 2nd story glass-enclosed lanai with end-to-end skyline ocean view to the separate home office/bonus studio off the master bedroom, all on a walled lot for private parking and entertaining with lilikoi abounding and plumeria scents. Enjoy split ACs in the open-concept Oahu dream home. Flow from indoor to outdoor all while viewing smelling, hearing infinite ocean. Granite counters, SS appliances, and an amazing kitchen area all overlooking the water. Surf and beaches minutes away in both directions, board stand, outdoor twin showers, plenty of organized storage, solar water heater, ultimate island life. Upper and lower levels separate for easy 2-unit conversion to enjoy extended family or supplemental income. Sunrise and mountain views. Do not hesitate for the chance to own this rare move-in ready gem waiting for you with ocean calling. Current flood insurance is $210 per month
Listing by: eXp Realty (808) 478-5118
array(164) {
["agency"]=>
array(1) {
[0]=>
string(10) "eXp Realty"
}
["assd_val_imprv"]=>
array(1) {
[0]=>
string(9) "293800.00"
}
["assd_val_land"]=>
array(1) {
[0]=>
string(9) "439900.00"
}
["assd_val_total"]=>
array(1) {
[0]=>
string(9) "733700.00"
}
["bedrooms"]=>
array(1) {
[0]=>
string(1) "4"
}
["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(24) "Property Disclosure Stmt"
}
["easements"]=>
array(1) {
[0]=>
string(4) "None"
}
["floor_covering"]=>
array(1) {
[0]=>
string(14) "Hardwood,Other"
}
["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) "120000"
}
["land_area_sf"]=>
array(1) {
[0]=>
string(7) "4997.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(26) "sherine@hawaiiluxhomes.com"
}
["list_agent_name"]=>
array(1) {
[0]=>
string(16) "Sherine M Duncan"
}
["list_agent_phone_number"]=>
array(1) {
[0]=>
string(14) "(808) 478-5118"
}
["list_date"]=>
array(1) {
[0]=>
string(10) "2021-09-08"
}
["list_office_name"]=>
array(1) {
[0]=>
string(10) "eXp Realty"
}
["list_price"]=>
array(1) {
[0]=>
string(10) "1200000.00"
}
["living_sf"]=>
array(1) {
[0]=>
string(4) "1656"
}
["location"]=>
array(1) {
[0]=>
string(43) "53-898 Kamehameha Highway, Hauula, HI 96717"
}
["mls_"]=>
array(1) {
[0]=>
string(9) "202123430"
}
["neighborhood"]=>
array(1) {
[0]=>
string(6) "HAUULA"
}
["number_of_parking_spaces"]=>
array(1) {
[0]=>
string(1) "6"
}
["number_of_stories"]=>
array(1) {
[0]=>
string(3) "One"
}
["office_mls_id"]=>
array(1) {
[0]=>
string(4) "EXPI"
}
["parking_features"]=>
array(1) {
[0]=>
string(27) "3 Car+,Boat,Driveway,Street"
}
["pool_"]=>
array(1) {
[0]=>
string(4) "None"
}
["possession"]=>
array(1) {
[0]=>
string(15) "45 Days or Less"
}
["postal_code"]=>
array(1) {
[0]=>
string(5) "96717"
}
["property_condition"]=>
array(1) {
[0]=>
string(23) "Above Average,Excellent"
}
["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) "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) "4"
}
["rets_city"]=>
array(1) {
[0]=>
string(6) "Hauula"
}
["rets_co_list_agent_direct_work_phone"]=>
array(1) {
[0]=>
string(14) "(808) 478-5118"
}
["rets_co_list_agent_email"]=>
array(1) {
[0]=>
string(27) "traci@HawaiiHomeAdviser.com"
}
["rets_co_list_agent_full_name"]=>
array(1) {
[0]=>
string(12) "T Malan Huie"
}
["rets_co_list_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "51384"
}
["rets_co_list_agent_mui"]=>
array(1) {
[0]=>
string(8) "15926354"
}
["rets_co_list_office_mlsid"]=>
array(1) {
[0]=>
string(4) "EXPI"
}
["rets_co_list_office_mui"]=>
array(1) {
[0]=>
string(8) "10013908"
}
["rets_co_list_office_name"]=>
array(1) {
[0]=>
string(10) "eXp Realty"
}
["rets_co_list_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 478-5118"
}
["rets_condo_property_regime_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_current_price"]=>
array(1) {
[0]=>
string(10) "1200000.00"
}
["rets_dom"]=>
array(1) {
[0]=>
string(2) "11"
}
["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) "16152259"
}
["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) 478-5118"
}
["rets_list_agent_email"]=>
array(1) {
[0]=>
string(26) "sherine@hawaiiluxhomes.com"
}
["rets_list_agent_full_name"]=>
array(1) {
[0]=>
string(16) "Sherine M Duncan"
}
["rets_list_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "45029"
}
["rets_list_agent_mui"]=>
array(1) {
[0]=>
string(7) "9445684"
}
["rets_list_office_mlsid"]=>
array(1) {
[0]=>
string(4) "EXPI"
}
["rets_list_office_mui"]=>
array(1) {
[0]=>
string(8) "10013908"
}
["rets_list_office_name"]=>
array(1) {
[0]=>
string(10) "eXp Realty"
}
["rets_list_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 478-5118"
}
["rets_list_price"]=>
array(1) {
[0]=>
string(10) "1200000.00"
}
["rets_listing_contract_date"]=>
array(1) {
[0]=>
string(10) "2021-09-08"
}
["rets_lot_size_area"]=>
array(1) {
[0]=>
string(7) "4997.00"
}
["rets_matrix_modified_dt"]=>
array(1) {
[0]=>
string(23) "2021-11-08T17:26:42.433"
}
["rets_matrix_unique_id"]=>
array(1) {
[0]=>
string(8) "16152259"
}
["rets_mls_number"]=>
array(1) {
[0]=>
string(9) "202123430"
}
["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) "2021-09-08T16:17:08.433"
}
["rets_original_list_price"]=>
array(1) {
[0]=>
string(10) "1200000.00"
}
["rets_parcel_number"]=>
array(1) {
[0]=>
string(18) "1-5-3-014-017-0000"
}
["rets_parking_total"]=>
array(1) {
[0]=>
string(1) "6"
}
["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) "2021-09-08T18:09:10.717"
}
["rets_postal_code"]=>
array(1) {
[0]=>
string(5) "96717"
}
["rets_primary_key"]=>
array(1) {
[0]=>
string(8) "16152259"
}
["rets_private_remarks"]=>
array(1) {
[0]=>
string(278) "Call/Text Traci for showings - 808-435-4843 or Sherine at 808-554-2262
Open Houses! 9/10 Friday 11am-6pm // 9/11 Saturday 10am-5pm // 9/12 Sunday 10am-5pm
Property being sold AS-IS!!! TRULY
Please use David Palk of Fidelity National Title
Buyer to accept Survey from 2016"
}
["rets_public_remarks"]=>
array(1) {
[0]=>
string(1016) "Amazing Hauula front-gated coastal home affords you true Hawaiian lifestyle. Every detail has been thought of from the 2nd story glass-enclosed lanai with end-to-end skyline ocean view to the separate home office/bonus studio off the master bedroom, all on a walled lot for private parking and entertaining with lilikoi abounding and plumeria scents. Enjoy split ACs in the open-concept Oahu dream home. Flow from indoor to outdoor all while viewing smelling, hearing infinite ocean. Granite counters, SS appliances, and an amazing kitchen area all overlooking the water. Surf and beaches minutes away in both directions, board stand, outdoor twin showers, plenty of organized storage, solar water heater, ultimate island life. Upper and lower levels separate for easy 2-unit conversion to enjoy extended family or supplemental income. Sunrise and mountain views. Do not hesitate for the chance to own this rare move-in ready gem waiting for you with ocean calling. Current flood insurance is $210 per month"
}
["rets_sqft_roofed_living"]=>
array(1) {
[0]=>
string(4) "1656"
}
["rets_sqft_total"]=>
array(1) {
[0]=>
string(4) "1656"
}
["rets_state_or_province"]=>
array(1) {
[0]=>
string(2) "HI"
}
["rets_status_change_timestamp"]=>
array(1) {
[0]=>
string(23) "2021-11-08T17:26:42.433"
}
["rets_status_contractual_search_date"]=>
array(1) {
[0]=>
string(10) "2021-11-08"
}
["rets_street_name"]=>
array(1) {
[0]=>
string(10) "Kamehameha"
}
["rets_street_number"]=>
array(1) {
[0]=>
string(6) "53-898"
}
["rets_street_view_param"]=>
array(1) {
[0]=>
string(64) "1$21.604165$-157.900545$101.48$13.33$1.00$rfzJX5ILNU-3Dspfns2g1Q"
}
["rets_sub_agency_compensation"]=>
array(1) {
[0]=>
string(3) "2.5"
}
["rets_tax_amount"]=>
array(1) {
[0]=>
string(6) "184.83"
}
["rets_tax_assessed_value"]=>
array(1) {
[0]=>
string(9) "733700.00"
}
["rets_tax_assessed_value_improvements"]=>
array(1) {
[0]=>
string(9) "293800.00"
}
["rets_tax_assessed_value_land"]=>
array(1) {
[0]=>
string(9) "439900.00"
}
["rets_tax_excemption_owner_occupancy"]=>
array(1) {
[0]=>
string(6) "120000"
}
["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/16152259/e74eb193aced201e2c590fb5c6ae308d"
}
["rets_tmk_area"]=>
array(1) {
[0]=>
string(3) "153"
}
["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) "17"
}
["rets_tmk_section"]=>
array(1) {
[0]=>
string(1) "3"
}
["rets_tmk_zone"]=>
array(1) {
[0]=>
string(1) "5"
}
["rets_tmkplat"]=>
array(1) {
[0]=>
string(2) "14"
}
["rets_year_built"]=>
array(1) {
[0]=>
string(4) "1974"
}
["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) "53-898"
}
["street_suffix"]=>
array(1) {
[0]=>
string(7) "Highway"
}
["terms_accept"]=>
array(1) {
[0]=>
string(20) "Cash,Conventional,VA"
}
["tmk"]=>
array(1) {
[0]=>
string(18) "1-5-3-014-017-0000"
}
["topography"]=>
array(1) {
[0]=>
string(5) "Clear"
}
["view"]=>
array(1) {
[0]=>
string(22) "Mountain,Ocean,Sunrise"
}
["wpp::rets_pk"]=>
array(1) {
[0]=>
string(8) "16152259"
}
["wpp_gpid"]=>
array(1) {
[0]=>
string(9) "202123430"
}
["wpp_import_schedule_id"]=>
array(1) {
[0]=>
string(10) "1463343682"
}
["wpp_import_time"]=>
array(1) {
[0]=>
string(10) "1636428451"
}
["year_built"]=>
array(1) {
[0]=>
string(4) "1974"
}
["zoning"]=>
array(1) {
[0]=>
string(29) "05 - R-5 Residential District"
}
["new_attached_media"]=>
array(1) {
[0]=>
string(5967) "a:357:{i:0;i:20704014;i:1;i:20704015;i:2;i:20704016;i:3;i:20704017;i:4;i:20704018;i:5;i:20704019;i:6;i:20704020;i:7;i:20704021;i:8;i:20704022;i:9;i:20704023;i:10;i:20704024;i:11;i:20704025;i:12;i:20704026;i:13;i:20704027;i:14;i:20704028;i:15;i:20704029;i:16;i:20704030;i:17;i:20704031;i:18;i:20704032;i:19;i:20704033;i:20;i:20704034;i:21;i:20704118;i:22;i:20704119;i:23;i:20704120;i:24;i:20704121;i:25;i:20704122;i:26;i:20704123;i:27;i:20704124;i:28;i:20704125;i:29;i:20704126;i:30;i:20704127;i:31;i:20704128;i:32;i:20704129;i:33;i:20704130;i:34;i:20704131;i:35;i:20704132;i:36;i:20704133;i:37;i:20704134;i:38;i:20704135;i:39;i:20704136;i:40;i:20704137;i:41;i:20704138;i:42;i:20704179;i:43;i:20704180;i:44;i:20704181;i:45;i:20704182;i:46;i:20704183;i:47;i:20704184;i:48;i:20704185;i:49;i:20704186;i:50;i:20704187;i:51;i:20704188;i:52;i:20704189;i:53;i:20704190;i:54;i:20704191;i:55;i:20704192;i:56;i:20704193;i:57;i:20704194;i:58;i:20704195;i:59;i:20704196;i:60;i:20704197;i:61;i:20704198;i:62;i:20704199;i:63;i:20704409;i:64;i:20704410;i:65;i:20704411;i:66;i:20704412;i:67;i:20704413;i:68;i:20704414;i:69;i:20704415;i:70;i:20704416;i:71;i:20704417;i:72;i:20704418;i:73;i:20704419;i:74;i:20704420;i:75;i:20704421;i:76;i:20704422;i:77;i:20704423;i:78;i:20704424;i:79;i:20704425;i:80;i:20704426;i:81;i:20704427;i:82;i:20704428;i:83;i:20704429;i:84;i:20704430;i:85;i:20704431;i:86;i:20704432;i:87;i:20704433;i:88;i:20704434;i:89;i:20704435;i:90;i:20704436;i:91;i:20704437;i:92;i:20704438;i:93;i:20704439;i:94;i:20704440;i:95;i:20704441;i:96;i:20704442;i:97;i:20704443;i:98;i:20704444;i:99;i:20704445;i:100;i:20704446;i:101;i:20704447;i:102;i:20704448;i:103;i:20704449;i:104;i:20704450;i:105;i:20704472;i:106;i:20704473;i:107;i:20704474;i:108;i:20704475;i:109;i:20704476;i:110;i:20704477;i:111;i:20704478;i:112;i:20704479;i:113;i:20704480;i:114;i:20704481;i:115;i:20704482;i:116;i:20704483;i:117;i:20704484;i:118;i:20704485;i:119;i:20704486;i:120;i:20704487;i:121;i:20704488;i:122;i:20704489;i:123;i:20704490;i:124;i:20704491;i:125;i:20704492;i:126;i:20704888;i:127;i:20704889;i:128;i:20704890;i:129;i:20704891;i:130;i:20704892;i:131;i:20704893;i:132;i:20704894;i:133;i:20704895;i:134;i:20704896;i:135;i:20704897;i:136;i:20704898;i:137;i:20704899;i:138;i:20704900;i:139;i:20704901;i:140;i:20704902;i:141;i:20704903;i:142;i:20704904;i:143;i:20704905;i:144;i:20704906;i:145;i:20704907;i:146;i:20704908;i:147;i:20704909;i:148;i:20704910;i:149;i:20704911;i:150;i:20704912;i:151;i:20704913;i:152;i:20704914;i:153;i:20704915;i:154;i:20704916;i:155;i:20704917;i:156;i:20704918;i:157;i:20704919;i:158;i:20704920;i:159;i:20704921;i:160;i:20704922;i:161;i:20704923;i:162;i:20704924;i:163;i:20704925;i:164;i:20704926;i:165;i:20704927;i:166;i:20704928;i:167;i:20704929;i:168;i:20704951;i:169;i:20704952;i:170;i:20704953;i:171;i:20704954;i:172;i:20704955;i:173;i:20704956;i:174;i:20704957;i:175;i:20704958;i:176;i:20704959;i:177;i:20704960;i:178;i:20704961;i:179;i:20704962;i:180;i:20704963;i:181;i:20704964;i:182;i:20704965;i:183;i:20704966;i:184;i:20704967;i:185;i:20704968;i:186;i:20704969;i:187;i:20704970;i:188;i:20704971;i:189;i:20704993;i:190;i:20704994;i:191;i:20704995;i:192;i:20704996;i:193;i:20704997;i:194;i:20704998;i:195;i:20704999;i:196;i:20705000;i:197;i:20705001;i:198;i:20705002;i:199;i:20705003;i:200;i:20705004;i:201;i:20705005;i:202;i:20705006;i:203;i:20705007;i:204;i:20705008;i:205;i:20705009;i:206;i:20705010;i:207;i:20705011;i:208;i:20705012;i:209;i:20705013;i:210;i:20705076;i:211;i:20705077;i:212;i:20705078;i:213;i:20705079;i:214;i:20705080;i:215;i:20705081;i:216;i:20705082;i:217;i:20705083;i:218;i:20705084;i:219;i:20705085;i:220;i:20705086;i:221;i:20705087;i:222;i:20705088;i:223;i:20705089;i:224;i:20705090;i:225;i:20705091;i:226;i:20705092;i:227;i:20705093;i:228;i:20705094;i:229;i:20705095;i:230;i:20705096;i:231;i:20705139;i:232;i:20705140;i:233;i:20705141;i:234;i:20705142;i:235;i:20705143;i:236;i:20705144;i:237;i:20705145;i:238;i:20705146;i:239;i:20705147;i:240;i:20705148;i:241;i:20705149;i:242;i:20705150;i:243;i:20705151;i:244;i:20705152;i:245;i:20705153;i:246;i:20705154;i:247;i:20705155;i:248;i:20705156;i:249;i:20705157;i:250;i:20705158;i:251;i:20705159;i:252;i:20716010;i:253;i:20716011;i:254;i:20716012;i:255;i:20716013;i:256;i:20716014;i:257;i:20716015;i:258;i:20716016;i:259;i:20716017;i:260;i:20716018;i:261;i:20716019;i:262;i:20716020;i:263;i:20716021;i:264;i:20716022;i:265;i:20716023;i:266;i:20716024;i:267;i:20716025;i:268;i:20716026;i:269;i:20716027;i:270;i:20716028;i:271;i:20716029;i:272;i:20716030;i:273;i:20716041;i:274;i:20716042;i:275;i:20716043;i:276;i:20716044;i:277;i:20716045;i:278;i:20716046;i:279;i:20716047;i:280;i:20716048;i:281;i:20716049;i:282;i:20716050;i:283;i:20716051;i:284;i:20716052;i:285;i:20716053;i:286;i:20716054;i:287;i:20716055;i:288;i:20716056;i:289;i:20716057;i:290;i:20716058;i:291;i:20716059;i:292;i:20716060;i:293;i:20716061;i:294;i:20719429;i:295;i:20719430;i:296;i:20719431;i:297;i:20719432;i:298;i:20719433;i:299;i:20719434;i:300;i:20719435;i:301;i:20719436;i:302;i:20719437;i:303;i:20719438;i:304;i:20719439;i:305;i:20719440;i:306;i:20719441;i:307;i:20719442;i:308;i:20719443;i:309;i:20719444;i:310;i:20719445;i:311;i:20719446;i:312;i:20719447;i:313;i:20719448;i:314;i:20719449;i:315;i:20774579;i:316;i:20774580;i:317;i:20774581;i:318;i:20774582;i:319;i:20774583;i:320;i:20774584;i:321;i:20774585;i:322;i:20774586;i:323;i:20774587;i:324;i:20774588;i:325;i:20774589;i:326;i:20774590;i:327;i:20774591;i:328;i:20774592;i:329;i:20774593;i:330;i:20774594;i:331;i:20774595;i:332;i:20774596;i:333;i:20774597;i:334;i:20774598;i:335;i:20774599;i:336;i:21122187;i:337;i:21122188;i:338;i:21122189;i:339;i:21122190;i:340;i:21122191;i:341;i:21122192;i:342;i:21122193;i:343;i:21122194;i:344;i:21122195;i:345;i:21122196;i:346;i:21122197;i:347;i:21122198;i:348;i:21122199;i:349;i:21122200;i:350;i:21122201;i:351;i:21122202;i:352;i:21122203;i:353;i:21122204;i:354;i:21122205;i:355;i:21122206;i:356;i:21122207;}"
}
["rets_open_house_count"]=>
array(1) {
[0]=>
string(1) "4"
}
["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) "1"
}
["rets_supplement_modification_timestam"]=>
array(1) {
[0]=>
string(23) "2021-09-10T15:55:39.737"
}
["rets_active_continue_to_show_date"]=>
array(1) {
[0]=>
string(10) "2021-09-15"
}
["rets_close_date"]=>
array(1) {
[0]=>
string(10) "2021-11-08"
}
["rets_close_price"]=>
array(1) {
[0]=>
string(10) "1200000.00"
}
["rets_co_selling_agent_direct_work_pho"]=>
array(1) {
[0]=>
string(14) "(808) 478-5118"
}
["rets_co_selling_agent_email"]=>
array(1) {
[0]=>
string(27) "traci@HawaiiHomeAdviser.com"
}
["rets_co_selling_agent_full_name"]=>
array(1) {
[0]=>
string(12) "T Malan Huie"
}
["rets_co_selling_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "51384"
}
["rets_co_selling_agent_mui"]=>
array(1) {
[0]=>
string(8) "15926354"
}
["rets_co_selling_office_mlsid"]=>
array(1) {
[0]=>
string(4) "EXPI"
}
["rets_co_selling_office_mui"]=>
array(1) {
[0]=>
string(8) "10013908"
}
["rets_co_selling_office_name"]=>
array(1) {
[0]=>
string(10) "eXp Realty"
}
["rets_co_selling_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 478-5118"
}
["rets_expiration_date"]=>
array(1) {
[0]=>
string(10) "2022-09-01"
}
["rets_off_market_date"]=>
array(1) {
[0]=>
string(10) "2021-11-08"
}
["rets_selling_agent_direct_work_phone"]=>
array(1) {
[0]=>
string(14) "(808) 478-5118"
}
["rets_selling_agent_email"]=>
array(1) {
[0]=>
string(26) "sherine@hawaiiluxhomes.com"
}
["rets_selling_agent_full_name"]=>
array(1) {
[0]=>
string(16) "Sherine M Duncan"
}
["rets_selling_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "45029"
}
["rets_selling_agent_mui"]=>
array(1) {
[0]=>
string(7) "9445684"
}
["rets_selling_office_mlsid"]=>
array(1) {
[0]=>
string(4) "EXPI"
}
["rets_selling_office_mui"]=>
array(1) {
[0]=>
string(8) "10013908"
}
["rets_selling_office_name"]=>
array(1) {
[0]=>
string(10) "eXp Realty"
}
["rets_selling_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 478-5118"
}
["rets_tax_annual_amount"]=>
array(1) {
[0]=>
string(7) "2217.96"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "21122187"
}
}
Array
(
[agency] => Array
(
[0] => eXp Realty
)
[assd_val_imprv] => Array
(
[0] => 293800.00
)
[assd_val_land] => Array
(
[0] => 439900.00
)
[assd_val_total] => Array
(
[0] => 733700.00
)
[bedrooms] => Array
(
[0] => 4
)
[building_style] => Array
(
[0] => Detach Single Family
)
[city] => Array
(
[0] => Hauula
)
[county] => Array
(
[0] => Oahu
)
[disclosures] => Array
(
[0] => Property Disclosure Stmt
)
[easements] => Array
(
[0] => None
)
[floor_covering] => Array
(
[0] => Hardwood,Other
)
[full_baths] => Array
(
[0] => 2
)
[furnished] => Array
(
[0] => None
)
[half_baths] => Array
(
[0] => 0
)
[home_exampt] => Array
(
[0] => 120000
)
[land_area_sf] => Array
(
[0] => 4997.00
)
[land_recorded] => Array
(
[0] => Regular System
)
[land_tenure] => Array
(
[0] => FS - Fee Simple
)
[list_agent_email] => Array
(
[0] => sherine@hawaiiluxhomes.com
)
[list_agent_name] => Array
(
[0] => Sherine M Duncan
)
[list_agent_phone_number] => Array
(
[0] => (808) 478-5118
)
[list_date] => Array
(
[0] => 2021-09-08
)
[list_office_name] => Array
(
[0] => eXp Realty
)
[list_price] => Array
(
[0] => 1200000.00
)
[living_sf] => Array
(
[0] => 1656
)
[location] => Array
(
[0] => 53-898 Kamehameha Highway, Hauula, HI 96717
)
[mls_] => Array
(
[0] => 202123430
)
[neighborhood] => Array
(
[0] => HAUULA
)
[number_of_parking_spaces] => Array
(
[0] => 6
)
[number_of_stories] => Array
(
[0] => One
)
[office_mls_id] => Array
(
[0] => EXPI
)
[parking_features] => Array
(
[0] => 3 Car+,Boat,Driveway,Street
)
[pool_] => Array
(
[0] => None
)
[possession] => Array
(
[0] => 45 Days or Less
)
[postal_code] => Array
(
[0] => 96717
)
[property_condition] => Array
(
[0] => Above Average,Excellent
)
[property_type] => Array
(
[0] => single_family
)
[property_type_label] => Array
(
[0] => single_family
)
[region] => Array
(
[0] => Kaneohe
)
[rets_baths_full] => Array
(
[0] => 2
)
[rets_baths_half] => Array
(
[0] => 0
)
[rets_baths_total] => Array
(
[0] => 2.00
)
[rets_beds_total] => Array
(
[0] => 4
)
[rets_city] => Array
(
[0] => Hauula
)
[rets_co_list_agent_direct_work_phone] => Array
(
[0] => (808) 478-5118
)
[rets_co_list_agent_email] => Array
(
[0] => traci@HawaiiHomeAdviser.com
)
[rets_co_list_agent_full_name] => Array
(
[0] => T Malan Huie
)
[rets_co_list_agent_mlsid] => Array
(
[0] => 51384
)
[rets_co_list_agent_mui] => Array
(
[0] => 15926354
)
[rets_co_list_office_mlsid] => Array
(
[0] => EXPI
)
[rets_co_list_office_mui] => Array
(
[0] => 10013908
)
[rets_co_list_office_name] => Array
(
[0] => eXp Realty
)
[rets_co_list_office_phone] => Array
(
[0] => (808) 478-5118
)
[rets_condo_property_regime_yn] => Array
(
[0] => 0
)
[rets_current_price] => Array
(
[0] => 1200000.00
)
[rets_dom] => Array
(
[0] => 11
)
[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] => 16152259
)
[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) 478-5118
)
[rets_list_agent_email] => Array
(
[0] => sherine@hawaiiluxhomes.com
)
[rets_list_agent_full_name] => Array
(
[0] => Sherine M Duncan
)
[rets_list_agent_mlsid] => Array
(
[0] => 45029
)
[rets_list_agent_mui] => Array
(
[0] => 9445684
)
[rets_list_office_mlsid] => Array
(
[0] => EXPI
)
[rets_list_office_mui] => Array
(
[0] => 10013908
)
[rets_list_office_name] => Array
(
[0] => eXp Realty
)
[rets_list_office_phone] => Array
(
[0] => (808) 478-5118
)
[rets_list_price] => Array
(
[0] => 1200000.00
)
[rets_listing_contract_date] => Array
(
[0] => 2021-09-08
)
[rets_lot_size_area] => Array
(
[0] => 4997.00
)
[rets_matrix_modified_dt] => Array
(
[0] => 2021-11-08T17:26:42.433
)
[rets_matrix_unique_id] => Array
(
[0] => 16152259
)
[rets_mls_number] => Array
(
[0] => 202123430
)
[rets_neighbourhood] => Array
(
[0] => HAUULA
)
[rets_new_development_construction_yn] => Array
(
[0] => 0
)
[rets_original_entry_timestamp] => Array
(
[0] => 2021-09-08T16:17:08.433
)
[rets_original_list_price] => Array
(
[0] => 1200000.00
)
[rets_parcel_number] => Array
(
[0] => 1-5-3-014-017-0000
)
[rets_parking_total] => Array
(
[0] => 6
)
[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] => 2021-09-08T18:09:10.717
)
[rets_postal_code] => Array
(
[0] => 96717
)
[rets_primary_key] => Array
(
[0] => 16152259
)
[rets_private_remarks] => Array
(
[0] => Call/Text Traci for showings - 808-435-4843 or Sherine at 808-554-2262
Open Houses! 9/10 Friday 11am-6pm // 9/11 Saturday 10am-5pm // 9/12 Sunday 10am-5pm
Property being sold AS-IS!!! TRULY
Please use David Palk of Fidelity National Title
Buyer to accept Survey from 2016
)
[rets_public_remarks] => Array
(
[0] => Amazing Hauula front-gated coastal home affords you true Hawaiian lifestyle. Every detail has been thought of from the 2nd story glass-enclosed lanai with end-to-end skyline ocean view to the separate home office/bonus studio off the master bedroom, all on a walled lot for private parking and entertaining with lilikoi abounding and plumeria scents. Enjoy split ACs in the open-concept Oahu dream home. Flow from indoor to outdoor all while viewing smelling, hearing infinite ocean. Granite counters, SS appliances, and an amazing kitchen area all overlooking the water. Surf and beaches minutes away in both directions, board stand, outdoor twin showers, plenty of organized storage, solar water heater, ultimate island life. Upper and lower levels separate for easy 2-unit conversion to enjoy extended family or supplemental income. Sunrise and mountain views. Do not hesitate for the chance to own this rare move-in ready gem waiting for you with ocean calling. Current flood insurance is $210 per month
)
[rets_sqft_roofed_living] => Array
(
[0] => 1656
)
[rets_sqft_total] => Array
(
[0] => 1656
)
[rets_state_or_province] => Array
(
[0] => HI
)
[rets_status_change_timestamp] => Array
(
[0] => 2021-11-08T17:26:42.433
)
[rets_status_contractual_search_date] => Array
(
[0] => 2021-11-08
)
[rets_street_name] => Array
(
[0] => Kamehameha
)
[rets_street_number] => Array
(
[0] => 53-898
)
[rets_street_view_param] => Array
(
[0] => 1$21.604165$-157.900545$101.48$13.33$1.00$rfzJX5ILNU-3Dspfns2g1Q
)
[rets_sub_agency_compensation] => Array
(
[0] => 2.5
)
[rets_tax_amount] => Array
(
[0] => 184.83
)
[rets_tax_assessed_value] => Array
(
[0] => 733700.00
)
[rets_tax_assessed_value_improvements] => Array
(
[0] => 293800.00
)
[rets_tax_assessed_value_land] => Array
(
[0] => 439900.00
)
[rets_tax_excemption_owner_occupancy] => Array
(
[0] => 120000
)
[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/16152259/e74eb193aced201e2c590fb5c6ae308d
)
[rets_tmk_area] => Array
(
[0] => 153
)
[rets_tmk_condo_property_regime_number] => Array
(
[0] => 0
)
[rets_tmk_division] => Array
(
[0] => 1
)
[rets_tmk_parcel] => Array
(
[0] => 17
)
[rets_tmk_section] => Array
(
[0] => 3
)
[rets_tmk_zone] => Array
(
[0] => 5
)
[rets_tmkplat] => Array
(
[0] => 14
)
[rets_year_built] => Array
(
[0] => 1974
)
[setbacks] => Array
(
[0] => Of Record
)
[state_or_province] => Array
(
[0] => HI
)
[status] => Array
(
[0] => Sold
)
[street_name] => Array
(
[0] => Kamehameha
)
[street_number] => Array
(
[0] => 53-898
)
[street_suffix] => Array
(
[0] => Highway
)
[terms_accept] => Array
(
[0] => Cash,Conventional,VA
)
[tmk] => Array
(
[0] => 1-5-3-014-017-0000
)
[topography] => Array
(
[0] => Clear
)
[view] => Array
(
[0] => Mountain,Ocean,Sunrise
)
[wpp::rets_pk] => Array
(
[0] => 16152259
)
[wpp_gpid] => Array
(
[0] => 202123430
)
[wpp_import_schedule_id] => Array
(
[0] => 1463343682
)
[wpp_import_time] => Array
(
[0] => 1636428451
)
[year_built] => Array
(
[0] => 1974
)
[zoning] => Array
(
[0] => 05 - R-5 Residential District
)
[new_attached_media] => Array
(
[0] => a:357:{i:0;i:20704014;i:1;i:20704015;i:2;i:20704016;i:3;i:20704017;i:4;i:20704018;i:5;i:20704019;i:6;i:20704020;i:7;i:20704021;i:8;i:20704022;i:9;i:20704023;i:10;i:20704024;i:11;i:20704025;i:12;i:20704026;i:13;i:20704027;i:14;i:20704028;i:15;i:20704029;i:16;i:20704030;i:17;i:20704031;i:18;i:20704032;i:19;i:20704033;i:20;i:20704034;i:21;i:20704118;i:22;i:20704119;i:23;i:20704120;i:24;i:20704121;i:25;i:20704122;i:26;i:20704123;i:27;i:20704124;i:28;i:20704125;i:29;i:20704126;i:30;i:20704127;i:31;i:20704128;i:32;i:20704129;i:33;i:20704130;i:34;i:20704131;i:35;i:20704132;i:36;i:20704133;i:37;i:20704134;i:38;i:20704135;i:39;i:20704136;i:40;i:20704137;i:41;i:20704138;i:42;i:20704179;i:43;i:20704180;i:44;i:20704181;i:45;i:20704182;i:46;i:20704183;i:47;i:20704184;i:48;i:20704185;i:49;i:20704186;i:50;i:20704187;i:51;i:20704188;i:52;i:20704189;i:53;i:20704190;i:54;i:20704191;i:55;i:20704192;i:56;i:20704193;i:57;i:20704194;i:58;i:20704195;i:59;i:20704196;i:60;i:20704197;i:61;i:20704198;i:62;i:20704199;i:63;i:20704409;i:64;i:20704410;i:65;i:20704411;i:66;i:20704412;i:67;i:20704413;i:68;i:20704414;i:69;i:20704415;i:70;i:20704416;i:71;i:20704417;i:72;i:20704418;i:73;i:20704419;i:74;i:20704420;i:75;i:20704421;i:76;i:20704422;i:77;i:20704423;i:78;i:20704424;i:79;i:20704425;i:80;i:20704426;i:81;i:20704427;i:82;i:20704428;i:83;i:20704429;i:84;i:20704430;i:85;i:20704431;i:86;i:20704432;i:87;i:20704433;i:88;i:20704434;i:89;i:20704435;i:90;i:20704436;i:91;i:20704437;i:92;i:20704438;i:93;i:20704439;i:94;i:20704440;i:95;i:20704441;i:96;i:20704442;i:97;i:20704443;i:98;i:20704444;i:99;i:20704445;i:100;i:20704446;i:101;i:20704447;i:102;i:20704448;i:103;i:20704449;i:104;i:20704450;i:105;i:20704472;i:106;i:20704473;i:107;i:20704474;i:108;i:20704475;i:109;i:20704476;i:110;i:20704477;i:111;i:20704478;i:112;i:20704479;i:113;i:20704480;i:114;i:20704481;i:115;i:20704482;i:116;i:20704483;i:117;i:20704484;i:118;i:20704485;i:119;i:20704486;i:120;i:20704487;i:121;i:20704488;i:122;i:20704489;i:123;i:20704490;i:124;i:20704491;i:125;i:20704492;i:126;i:20704888;i:127;i:20704889;i:128;i:20704890;i:129;i:20704891;i:130;i:20704892;i:131;i:20704893;i:132;i:20704894;i:133;i:20704895;i:134;i:20704896;i:135;i:20704897;i:136;i:20704898;i:137;i:20704899;i:138;i:20704900;i:139;i:20704901;i:140;i:20704902;i:141;i:20704903;i:142;i:20704904;i:143;i:20704905;i:144;i:20704906;i:145;i:20704907;i:146;i:20704908;i:147;i:20704909;i:148;i:20704910;i:149;i:20704911;i:150;i:20704912;i:151;i:20704913;i:152;i:20704914;i:153;i:20704915;i:154;i:20704916;i:155;i:20704917;i:156;i:20704918;i:157;i:20704919;i:158;i:20704920;i:159;i:20704921;i:160;i:20704922;i:161;i:20704923;i:162;i:20704924;i:163;i:20704925;i:164;i:20704926;i:165;i:20704927;i:166;i:20704928;i:167;i:20704929;i:168;i:20704951;i:169;i:20704952;i:170;i:20704953;i:171;i:20704954;i:172;i:20704955;i:173;i:20704956;i:174;i:20704957;i:175;i:20704958;i:176;i:20704959;i:177;i:20704960;i:178;i:20704961;i:179;i:20704962;i:180;i:20704963;i:181;i:20704964;i:182;i:20704965;i:183;i:20704966;i:184;i:20704967;i:185;i:20704968;i:186;i:20704969;i:187;i:20704970;i:188;i:20704971;i:189;i:20704993;i:190;i:20704994;i:191;i:20704995;i:192;i:20704996;i:193;i:20704997;i:194;i:20704998;i:195;i:20704999;i:196;i:20705000;i:197;i:20705001;i:198;i:20705002;i:199;i:20705003;i:200;i:20705004;i:201;i:20705005;i:202;i:20705006;i:203;i:20705007;i:204;i:20705008;i:205;i:20705009;i:206;i:20705010;i:207;i:20705011;i:208;i:20705012;i:209;i:20705013;i:210;i:20705076;i:211;i:20705077;i:212;i:20705078;i:213;i:20705079;i:214;i:20705080;i:215;i:20705081;i:216;i:20705082;i:217;i:20705083;i:218;i:20705084;i:219;i:20705085;i:220;i:20705086;i:221;i:20705087;i:222;i:20705088;i:223;i:20705089;i:224;i:20705090;i:225;i:20705091;i:226;i:20705092;i:227;i:20705093;i:228;i:20705094;i:229;i:20705095;i:230;i:20705096;i:231;i:20705139;i:232;i:20705140;i:233;i:20705141;i:234;i:20705142;i:235;i:20705143;i:236;i:20705144;i:237;i:20705145;i:238;i:20705146;i:239;i:20705147;i:240;i:20705148;i:241;i:20705149;i:242;i:20705150;i:243;i:20705151;i:244;i:20705152;i:245;i:20705153;i:246;i:20705154;i:247;i:20705155;i:248;i:20705156;i:249;i:20705157;i:250;i:20705158;i:251;i:20705159;i:252;i:20716010;i:253;i:20716011;i:254;i:20716012;i:255;i:20716013;i:256;i:20716014;i:257;i:20716015;i:258;i:20716016;i:259;i:20716017;i:260;i:20716018;i:261;i:20716019;i:262;i:20716020;i:263;i:20716021;i:264;i:20716022;i:265;i:20716023;i:266;i:20716024;i:267;i:20716025;i:268;i:20716026;i:269;i:20716027;i:270;i:20716028;i:271;i:20716029;i:272;i:20716030;i:273;i:20716041;i:274;i:20716042;i:275;i:20716043;i:276;i:20716044;i:277;i:20716045;i:278;i:20716046;i:279;i:20716047;i:280;i:20716048;i:281;i:20716049;i:282;i:20716050;i:283;i:20716051;i:284;i:20716052;i:285;i:20716053;i:286;i:20716054;i:287;i:20716055;i:288;i:20716056;i:289;i:20716057;i:290;i:20716058;i:291;i:20716059;i:292;i:20716060;i:293;i:20716061;i:294;i:20719429;i:295;i:20719430;i:296;i:20719431;i:297;i:20719432;i:298;i:20719433;i:299;i:20719434;i:300;i:20719435;i:301;i:20719436;i:302;i:20719437;i:303;i:20719438;i:304;i:20719439;i:305;i:20719440;i:306;i:20719441;i:307;i:20719442;i:308;i:20719443;i:309;i:20719444;i:310;i:20719445;i:311;i:20719446;i:312;i:20719447;i:313;i:20719448;i:314;i:20719449;i:315;i:20774579;i:316;i:20774580;i:317;i:20774581;i:318;i:20774582;i:319;i:20774583;i:320;i:20774584;i:321;i:20774585;i:322;i:20774586;i:323;i:20774587;i:324;i:20774588;i:325;i:20774589;i:326;i:20774590;i:327;i:20774591;i:328;i:20774592;i:329;i:20774593;i:330;i:20774594;i:331;i:20774595;i:332;i:20774596;i:333;i:20774597;i:334;i:20774598;i:335;i:20774599;i:336;i:21122187;i:337;i:21122188;i:338;i:21122189;i:339;i:21122190;i:340;i:21122191;i:341;i:21122192;i:342;i:21122193;i:343;i:21122194;i:344;i:21122195;i:345;i:21122196;i:346;i:21122197;i:347;i:21122198;i:348;i:21122199;i:349;i:21122200;i:350;i:21122201;i:351;i:21122202;i:352;i:21122203;i:353;i:21122204;i:354;i:21122205;i:355;i:21122206;i:356;i:21122207;}
)
[rets_open_house_count] => Array
(
[0] => 4
)
[rets_active_open_house_count] => Array
(
[0] => 0
)
[rets_open_house_upcoming] => Array
(
[0] =>
)
[rets_supplement_count] => Array
(
[0] => 1
)
[rets_supplement_modification_timestam] => Array
(
[0] => 2021-09-10T15:55:39.737
)
[rets_active_continue_to_show_date] => Array
(
[0] => 2021-09-15
)
[rets_close_date] => Array
(
[0] => 2021-11-08
)
[rets_close_price] => Array
(
[0] => 1200000.00
)
[rets_co_selling_agent_direct_work_pho] => Array
(
[0] => (808) 478-5118
)
[rets_co_selling_agent_email] => Array
(
[0] => traci@HawaiiHomeAdviser.com
)
[rets_co_selling_agent_full_name] => Array
(
[0] => T Malan Huie
)
[rets_co_selling_agent_mlsid] => Array
(
[0] => 51384
)
[rets_co_selling_agent_mui] => Array
(
[0] => 15926354
)
[rets_co_selling_office_mlsid] => Array
(
[0] => EXPI
)
[rets_co_selling_office_mui] => Array
(
[0] => 10013908
)
[rets_co_selling_office_name] => Array
(
[0] => eXp Realty
)
[rets_co_selling_office_phone] => Array
(
[0] => (808) 478-5118
)
[rets_expiration_date] => Array
(
[0] => 2022-09-01
)
[rets_off_market_date] => Array
(
[0] => 2021-11-08
)
[rets_selling_agent_direct_work_phone] => Array
(
[0] => (808) 478-5118
)
[rets_selling_agent_email] => Array
(
[0] => sherine@hawaiiluxhomes.com
)
[rets_selling_agent_full_name] => Array
(
[0] => Sherine M Duncan
)
[rets_selling_agent_mlsid] => Array
(
[0] => 45029
)
[rets_selling_agent_mui] => Array
(
[0] => 9445684
)
[rets_selling_office_mlsid] => Array
(
[0] => EXPI
)
[rets_selling_office_mui] => Array
(
[0] => 10013908
)
[rets_selling_office_name] => Array
(
[0] => eXp Realty
)
[rets_selling_office_phone] => Array
(
[0] => (808) 478-5118
)
[rets_tax_annual_amount] => Array
(
[0] => 2217.96
)
[_thumbnail_id] => Array
(
[0] => 21122187
)
)
CONTACT US
#RB-7120
info@marcushawaii.com
(808)839-7446