Welcome Home! The best that Lualualei has to offer. Welcome to this FULLY renovated 4 bedroom 3 bath home. This single family home features an Open Concept floor plan with immaculate finishes from stainless steel appliances, quartz countertops, white shaker cabinets with modern fixtures, recessed lighting, as well as luxury vinyl tile flooring throughout. Entertain your family & friends while cooking your favorite meal as they sit at the open peninsula bar or in the living room. This home was thoughtfully
designed with ohana in mind; there’s a family room as well as a bedroom en suite on the 1st floor/ground level. There are 2 lanais overlooking the HUGE yard comprising of over 7,790 sq ft. Other noteworthy features include 2 car garage, new roof, new windows, new AC units, White Vinyl perimeter fencing which provides privacy and security, newly installed irrigation system, freshly grown el toro grass and lush landscaping. The list of improvements continues. Great location close to world famous Pokai
Bay Beach, Tamura Supermarket, Beach House by 604 Restaurant and many more attractions with Kapolei/Ewa and Ko Olina within 25 minutes.
array(167) {
["agency"]=>
array(1) {
[0]=>
string(13) "Locations LLC"
}
["assd_val_imprv"]=>
array(1) {
[0]=>
string(9) "241300.00"
}
["assd_val_land"]=>
array(1) {
[0]=>
string(9) "410300.00"
}
["assd_val_total"]=>
array(1) {
[0]=>
string(9) "651600.00"
}
["bedrooms"]=>
array(1) {
[0]=>
string(1) "4"
}
["building_style"]=>
array(1) {
[0]=>
string(20) "Detach Single Family"
}
["city"]=>
array(1) {
[0]=>
string(7) "Waianae"
}
["county"]=>
array(1) {
[0]=>
string(4) "Oahu"
}
["disclosures"]=>
array(1) {
[0]=>
string(36) "Property Disclosure Stmt,See Remarks"
}
["easements"]=>
array(1) {
[0]=>
string(5) "Other"
}
["elementary_school"]=>
array(1) {
[0]=>
string(7) "Leihoku"
}
["floor_covering"]=>
array(1) {
[0]=>
string(29) "Ceramic Tile,Vinyl,W/W Carpet"
}
["frontage"]=>
array(1) {
[0]=>
string(5) "Other"
}
["full_baths"]=>
array(1) {
[0]=>
string(1) "3"
}
["half_baths"]=>
array(1) {
[0]=>
string(1) "0"
}
["high_school"]=>
array(1) {
[0]=>
string(7) "Waianae"
}
["home_exampt"]=>
array(1) {
[0]=>
string(1) "0"
}
["land_area_sf"]=>
array(1) {
[0]=>
string(7) "7794.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(36) "nathaniel.forbes@locationshawaii.com"
}
["list_agent_name"]=>
array(1) {
[0]=>
string(16) "Nathaniel Forbes"
}
["list_agent_phone_number"]=>
array(1) {
[0]=>
string(14) "(808) 690-9555"
}
["list_date"]=>
array(1) {
[0]=>
string(10) "2022-04-06"
}
["list_office_name"]=>
array(1) {
[0]=>
string(13) "Locations LLC"
}
["list_price"]=>
array(1) {
[0]=>
string(9) "910000.00"
}
["living_sf"]=>
array(1) {
[0]=>
string(4) "1798"
}
["location"]=>
array(1) {
[0]=>
string(41) "86-343 Kauaopuu Street, Waianae, HI 96792"
}
["middle_school"]=>
array(1) {
[0]=>
string(7) "Waianae"
}
["mls_"]=>
array(1) {
[0]=>
string(9) "202206596"
}
["neighborhood"]=>
array(1) {
[0]=>
string(9) "LUALUALEI"
}
["number_of_parking_spaces"]=>
array(1) {
[0]=>
string(1) "4"
}
["number_of_stories"]=>
array(1) {
[0]=>
string(3) "Two"
}
["office_mls_id"]=>
array(1) {
[0]=>
string(6) "LOCA05"
}
["parking_features"]=>
array(1) {
[0]=>
string(18) "3 Car+,Boat,Garage"
}
["pool_"]=>
array(1) {
[0]=>
string(4) "None"
}
["possession"]=>
array(1) {
[0]=>
string(10) "At Closing"
}
["postal_code"]=>
array(1) {
[0]=>
string(5) "96792"
}
["property_condition"]=>
array(1) {
[0]=>
string(9) "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) "Leeward"
}
["rets_baths_full"]=>
array(1) {
[0]=>
string(1) "3"
}
["rets_baths_half"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_baths_total"]=>
array(1) {
[0]=>
string(4) "3.00"
}
["rets_beds_total"]=>
array(1) {
[0]=>
string(1) "4"
}
["rets_city"]=>
array(1) {
[0]=>
string(7) "Waianae"
}
["rets_co_list_agent_direct_work_phone"]=>
array(1) {
[0]=>
string(14) "(808) 735-4200"
}
["rets_co_list_agent_email"]=>
array(1) {
[0]=>
string(32) "leeroy.kusto@locationshawaii.com"
}
["rets_co_list_agent_full_name"]=>
array(1) {
[0]=>
string(12) "Leeroy Kusto"
}
["rets_co_list_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "51770"
}
["rets_co_list_agent_mui"]=>
array(1) {
[0]=>
string(8) "16202529"
}
["rets_co_list_office_mlsid"]=>
array(1) {
[0]=>
string(4) "LOCA"
}
["rets_co_list_office_mui"]=>
array(1) {
[0]=>
string(7) "3485305"
}
["rets_co_list_office_name"]=>
array(1) {
[0]=>
string(13) "Locations LLC"
}
["rets_co_list_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 735-4200"
}
["rets_condo_property_regime_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_current_price"]=>
array(1) {
[0]=>
string(9) "895000.00"
}
["rets_dom"]=>
array(1) {
[0]=>
string(2) "14"
}
["rets_dual_variable_compensation_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_elementary_school"]=>
array(1) {
[0]=>
string(7) "Leihoku"
}
["rets_foreclosure_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_fractional_ownership_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_high_school"]=>
array(1) {
[0]=>
string(7) "Waianae"
}
["rets_id"]=>
array(1) {
[0]=>
string(8) "16552081"
}
["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) 690-9555"
}
["rets_list_agent_email"]=>
array(1) {
[0]=>
string(36) "nathaniel.forbes@locationshawaii.com"
}
["rets_list_agent_full_name"]=>
array(1) {
[0]=>
string(16) "Nathaniel Forbes"
}
["rets_list_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "48220"
}
["rets_list_agent_mui"]=>
array(1) {
[0]=>
string(8) "12477811"
}
["rets_list_office_mlsid"]=>
array(1) {
[0]=>
string(6) "LOCA05"
}
["rets_list_office_mui"]=>
array(1) {
[0]=>
string(7) "9727981"
}
["rets_list_office_name"]=>
array(1) {
[0]=>
string(13) "Locations LLC"
}
["rets_list_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 690-9555"
}
["rets_list_price"]=>
array(1) {
[0]=>
string(9) "910000.00"
}
["rets_listing_contract_date"]=>
array(1) {
[0]=>
string(10) "2022-04-06"
}
["rets_lot_size_area"]=>
array(1) {
[0]=>
string(7) "7794.00"
}
["rets_matrix_modified_dt"]=>
array(1) {
[0]=>
string(23) "2022-06-13T17:08:08.530"
}
["rets_matrix_unique_id"]=>
array(1) {
[0]=>
string(8) "16552081"
}
["rets_middle_or_junior_school"]=>
array(1) {
[0]=>
string(7) "Waianae"
}
["rets_mls_number"]=>
array(1) {
[0]=>
string(9) "202206596"
}
["rets_neighbourhood"]=>
array(1) {
[0]=>
string(9) "LUALUALEI"
}
["rets_new_development_construction_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_original_entry_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-04-06T16:01:46.410"
}
["rets_original_list_price"]=>
array(1) {
[0]=>
string(9) "850000.00"
}
["rets_parcel_number"]=>
array(1) {
[0]=>
string(18) "1-8-6-021-013-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) "25"
}
["rets_photo_modification_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-04-06T18:10:42.670"
}
["rets_postal_code"]=>
array(1) {
[0]=>
string(5) "96792"
}
["rets_price_change_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-04-28T14:42:11.643"
}
["rets_primary_key"]=>
array(1) {
[0]=>
string(8) "16552081"
}
["rets_private_remarks"]=>
array(1) {
[0]=>
string(396) "First Open House Sat April 9th and Sun April 10th 2-5 pm. Offers are due on Wednesday April 13th at 5 pm. Vacant & Easy to Show. For Showing details, please contact Leeroy Kusto at 808-373-6272. Seller prefers Pam Sato from TG***For Offer Instructions and Home Features Sheet, please see the attached supplements*** (# baths differ from tax records). ***Monthly tax based on 2021 assessed values."
}
["rets_public_remarks"]=>
array(1) {
[0]=>
string(1155) "Welcome Home! The best that Lualualei has to offer. Welcome to this FULLY renovated 4 bedroom 3 bath home. This single family home features an Open Concept floor plan with immaculate finishes from stainless steel appliances, quartz countertops, white shaker cabinets with modern fixtures, recessed lighting, as well as luxury vinyl tile flooring throughout. Entertain your family & friends while cooking your favorite meal as they sit at the open peninsula bar or in the living room. This home was thoughtfully
designed with ohana in mind; there's a family room as well as a bedroom en suite on the 1st floor/ground level. There are 2 lanais overlooking the HUGE yard comprising of over 7,790 sq ft. Other noteworthy features include 2 car garage, new roof, new windows, new AC units, White Vinyl perimeter fencing which provides privacy and security, newly installed irrigation system, freshly grown el toro grass and lush landscaping. The list of improvements continues. Great location close to world famous Pokai
Bay Beach, Tamura Supermarket, Beach House by 604 Restaurant and many more attractions with Kapolei/Ewa and Ko Olina within 25 minutes."
}
["rets_room_count"]=>
array(1) {
[0]=>
string(1) "4"
}
["rets_sqft_roofed_living"]=>
array(1) {
[0]=>
string(4) "1798"
}
["rets_sqft_total"]=>
array(1) {
[0]=>
string(4) "1798"
}
["rets_state_or_province"]=>
array(1) {
[0]=>
string(2) "HI"
}
["rets_status_change_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-06-13T17:08:08.530"
}
["rets_status_contractual_search_date"]=>
array(1) {
[0]=>
string(10) "2022-06-09"
}
["rets_street_name"]=>
array(1) {
[0]=>
string(8) "Kauaopuu"
}
["rets_street_number"]=>
array(1) {
[0]=>
string(6) "86-343"
}
["rets_street_view_param"]=>
array(1) {
[0]=>
string(64) "1$21.440601$-158.176319$337.43$13.33$1.00$ADEBg8vZVzNIL5Yt3JGnIQ"
}
["rets_sub_agency_compensation"]=>
array(1) {
[0]=>
string(2) "2%"
}
["rets_tax_amount"]=>
array(1) {
[0]=>
string(6) "137.00"
}
["rets_tax_annual_amount"]=>
array(1) {
[0]=>
string(7) "1644.00"
}
["rets_tax_assessed_value"]=>
array(1) {
[0]=>
string(9) "651600.00"
}
["rets_tax_assessed_value_improvements"]=>
array(1) {
[0]=>
string(9) "241300.00"
}
["rets_tax_assessed_value_land"]=>
array(1) {
[0]=>
string(9) "410300.00"
}
["rets_tax_excemption_owner_occupancy"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_tax_paid_by_seller_yn"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_tax_year"]=>
array(1) {
[0]=>
string(4) "2022"
}
["rets_thumbnail_url"]=>
array(1) {
[0]=>
string(81) "https://cdn.rets.ci/marcusrealty-images/16552081/fbaf43eefa1d91b1b8ff5233bc93f73f"
}
["rets_tmk_area"]=>
array(1) {
[0]=>
string(3) "186"
}
["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) "13"
}
["rets_tmk_section"]=>
array(1) {
[0]=>
string(1) "6"
}
["rets_tmk_zone"]=>
array(1) {
[0]=>
string(1) "8"
}
["rets_tmkplat"]=>
array(1) {
[0]=>
string(2) "21"
}
["rets_year_built"]=>
array(1) {
[0]=>
string(4) "1974"
}
["security"]=>
array(1) {
[0]=>
string(3) "Key"
}
["setbacks"]=>
array(1) {
[0]=>
string(3) "C&C"
}
["state_or_province"]=>
array(1) {
[0]=>
string(2) "HI"
}
["status"]=>
array(1) {
[0]=>
string(4) "Sold"
}
["street_name"]=>
array(1) {
[0]=>
string(8) "Kauaopuu"
}
["street_number"]=>
array(1) {
[0]=>
string(6) "86-343"
}
["street_suffix"]=>
array(1) {
[0]=>
string(6) "Street"
}
["terms_accept"]=>
array(1) {
[0]=>
string(39) "Cash,Conventional,FHA,USDA Financing,VA"
}
["tmk"]=>
array(1) {
[0]=>
string(18) "1-8-6-021-013-0000"
}
["topography"]=>
array(1) {
[0]=>
string(5) "Clear"
}
["view"]=>
array(1) {
[0]=>
string(22) "Garden,Mountain,Sunset"
}
["wpp::rets_pk"]=>
array(1) {
[0]=>
string(8) "16552081"
}
["wpp_gpid"]=>
array(1) {
[0]=>
string(9) "202206596"
}
["wpp_import_schedule_id"]=>
array(1) {
[0]=>
string(10) "1463343682"
}
["wpp_import_time"]=>
array(1) {
[0]=>
string(10) "1655176116"
}
["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(4896) "a:294:{i:0;i:21966127;i:1;i:21966128;i:2;i:21966129;i:3;i:21966130;i:4;i:21966131;i:5;i:21966132;i:6;i:21966133;i:7;i:21966134;i:8;i:21966135;i:9;i:21966136;i:10;i:21966137;i:11;i:21966138;i:12;i:21966139;i:13;i:21966140;i:14;i:21966141;i:15;i:21966142;i:16;i:21966143;i:17;i:21966144;i:18;i:21966145;i:19;i:21966146;i:20;i:21966147;i:21;i:21966148;i:22;i:21966149;i:23;i:21966150;i:24;i:21966151;i:25;i:21966152;i:26;i:21966153;i:27;i:21966154;i:28;i:21966155;i:29;i:21966156;i:30;i:21966157;i:31;i:21966158;i:32;i:21966159;i:33;i:21966160;i:34;i:21966161;i:35;i:21966162;i:36;i:21966163;i:37;i:21966164;i:38;i:21966165;i:39;i:21966166;i:40;i:21966167;i:41;i:21966168;i:42;i:21966259;i:43;i:21966260;i:44;i:21966261;i:45;i:21966262;i:46;i:21966263;i:47;i:21966264;i:48;i:21966265;i:49;i:21966266;i:50;i:21966267;i:51;i:21966268;i:52;i:21966269;i:53;i:21966270;i:54;i:21966271;i:55;i:21966272;i:56;i:21966273;i:57;i:21966274;i:58;i:21966275;i:59;i:21966276;i:60;i:21966277;i:61;i:21966278;i:62;i:21966279;i:63;i:21967135;i:64;i:21967136;i:65;i:21967137;i:66;i:21967138;i:67;i:21967139;i:68;i:21967140;i:69;i:21967141;i:70;i:21967142;i:71;i:21967143;i:72;i:21967144;i:73;i:21967145;i:74;i:21967146;i:75;i:21967147;i:76;i:21967148;i:77;i:21967149;i:78;i:21967150;i:79;i:21967151;i:80;i:21967152;i:81;i:21967153;i:82;i:21967154;i:83;i:21967155;i:84;i:21971010;i:85;i:21971011;i:86;i:21971012;i:87;i:21971013;i:88;i:21971014;i:89;i:21971015;i:90;i:21971016;i:91;i:21971017;i:92;i:21971018;i:93;i:21971019;i:94;i:21971020;i:95;i:21971021;i:96;i:21971022;i:97;i:21971023;i:98;i:21971024;i:99;i:21971025;i:100;i:21971026;i:101;i:21971027;i:102;i:21971028;i:103;i:21971029;i:104;i:21971030;i:105;i:21981104;i:106;i:21981105;i:107;i:21981106;i:108;i:21981107;i:109;i:21981108;i:110;i:21981109;i:111;i:21981110;i:112;i:21981111;i:113;i:21981112;i:114;i:21981113;i:115;i:21981114;i:116;i:21981115;i:117;i:21981116;i:118;i:21981117;i:119;i:21981118;i:120;i:21981119;i:121;i:21981120;i:122;i:21981121;i:123;i:21981122;i:124;i:21981123;i:125;i:21981124;i:126;i:21981125;i:127;i:21981126;i:128;i:21981127;i:129;i:21981128;i:130;i:21981129;i:131;i:21981130;i:132;i:21981131;i:133;i:21981132;i:134;i:21981133;i:135;i:21981134;i:136;i:21981135;i:137;i:21981136;i:138;i:21981137;i:139;i:21981138;i:140;i:21981139;i:141;i:21981140;i:142;i:21981141;i:143;i:21981142;i:144;i:21981143;i:145;i:21981144;i:146;i:21981145;i:147;i:21996173;i:148;i:21996174;i:149;i:21996175;i:150;i:21996176;i:151;i:21996177;i:152;i:21996178;i:153;i:21996179;i:154;i:21996180;i:155;i:21996181;i:156;i:21996182;i:157;i:21996183;i:158;i:21996184;i:159;i:21996185;i:160;i:21996186;i:161;i:21996187;i:162;i:21996188;i:163;i:21996189;i:164;i:21996190;i:165;i:21996191;i:166;i:21996192;i:167;i:21996193;i:168;i:21998106;i:169;i:21998107;i:170;i:21998108;i:171;i:21998109;i:172;i:21998110;i:173;i:21998111;i:174;i:21998112;i:175;i:21998113;i:176;i:21998114;i:177;i:21998115;i:178;i:21998116;i:179;i:21998117;i:180;i:21998118;i:181;i:21998119;i:182;i:21998120;i:183;i:21998121;i:184;i:21998122;i:185;i:21998123;i:186;i:21998124;i:187;i:21998125;i:188;i:21998126;i:189;i:22016819;i:190;i:22016820;i:191;i:22016821;i:192;i:22016822;i:193;i:22016823;i:194;i:22016824;i:195;i:22016825;i:196;i:22016826;i:197;i:22016827;i:198;i:22016828;i:199;i:22016829;i:200;i:22016830;i:201;i:22016831;i:202;i:22016832;i:203;i:22016833;i:204;i:22016834;i:205;i:22016835;i:206;i:22016836;i:207;i:22016837;i:208;i:22016838;i:209;i:22016839;i:210;i:22056802;i:211;i:22056803;i:212;i:22056804;i:213;i:22056805;i:214;i:22056806;i:215;i:22056807;i:216;i:22056808;i:217;i:22056809;i:218;i:22056810;i:219;i:22056811;i:220;i:22056812;i:221;i:22056813;i:222;i:22056814;i:223;i:22056815;i:224;i:22056816;i:225;i:22056817;i:226;i:22056818;i:227;i:22056819;i:228;i:22056820;i:229;i:22056821;i:230;i:22056822;i:231;i:22063464;i:232;i:22063465;i:233;i:22063466;i:234;i:22063467;i:235;i:22063468;i:236;i:22063469;i:237;i:22063470;i:238;i:22063471;i:239;i:22063472;i:240;i:22063473;i:241;i:22063474;i:242;i:22063475;i:243;i:22063476;i:244;i:22063477;i:245;i:22063478;i:246;i:22063479;i:247;i:22063480;i:248;i:22063481;i:249;i:22063482;i:250;i:22063483;i:251;i:22063484;i:252;i:22114321;i:253;i:22114322;i:254;i:22114323;i:255;i:22114324;i:256;i:22114325;i:257;i:22114326;i:258;i:22114327;i:259;i:22114328;i:260;i:22114329;i:261;i:22114330;i:262;i:22114331;i:263;i:22114332;i:264;i:22114333;i:265;i:22114334;i:266;i:22114335;i:267;i:22114336;i:268;i:22114337;i:269;i:22114338;i:270;i:22114339;i:271;i:22114340;i:272;i:22114341;i:273;i:22430087;i:274;i:22430088;i:275;i:22430089;i:276;i:22430090;i:277;i:22430091;i:278;i:22430092;i:279;i:22430093;i:280;i:22430094;i:281;i:22430095;i:282;i:22430096;i:283;i:22430097;i:284;i:22430098;i:285;i:22430099;i:286;i:22430100;i:287;i:22430101;i:288;i:22430102;i:289;i:22430103;i:290;i:22430104;i:291;i:22430105;i:292;i:22430106;i:293;i:22430107;}"
}
["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_year_remodeled"]=>
array(1) {
[0]=>
string(4) "2022"
}
["year_remodeled_"]=>
array(1) {
[0]=>
string(4) "2022"
}
["rets_supplement_count"]=>
array(1) {
[0]=>
string(1) "3"
}
["rets_supplement_modification_timestam"]=>
array(1) {
[0]=>
string(23) "2022-04-11T17:20:39.323"
}
["rets_active_continue_to_show_date"]=>
array(1) {
[0]=>
string(10) "2022-04-18"
}
["rets_close_date"]=>
array(1) {
[0]=>
string(10) "2022-06-09"
}
["rets_close_price"]=>
array(1) {
[0]=>
string(9) "895000.00"
}
["rets_concessions"]=>
array(1) {
[0]=>
string(4) "5000"
}
["rets_expiration_date"]=>
array(1) {
[0]=>
string(10) "2023-04-03"
}
["rets_off_market_date"]=>
array(1) {
[0]=>
string(10) "2022-06-09"
}
["rets_selling_agent_direct_work_phone"]=>
array(1) {
[0]=>
string(14) "(808) 735-4200"
}
["rets_selling_agent_email"]=>
array(1) {
[0]=>
string(33) "aaron.johnson@locationshawaii.com"
}
["rets_selling_agent_full_name"]=>
array(1) {
[0]=>
string(15) "Aaron J Johnson"
}
["rets_selling_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "46281"
}
["rets_selling_agent_mui"]=>
array(1) {
[0]=>
string(8) "10146865"
}
["rets_selling_office_mlsid"]=>
array(1) {
[0]=>
string(4) "LOCA"
}
["rets_selling_office_mui"]=>
array(1) {
[0]=>
string(7) "3485305"
}
["rets_selling_office_name"]=>
array(1) {
[0]=>
string(13) "Locations LLC"
}
["rets_selling_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 735-4200"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "22430087"
}
}
Array
(
[agency] => Array
(
[0] => Locations LLC
)
[assd_val_imprv] => Array
(
[0] => 241300.00
)
[assd_val_land] => Array
(
[0] => 410300.00
)
[assd_val_total] => Array
(
[0] => 651600.00
)
[bedrooms] => Array
(
[0] => 4
)
[building_style] => Array
(
[0] => Detach Single Family
)
[city] => Array
(
[0] => Waianae
)
[county] => Array
(
[0] => Oahu
)
[disclosures] => Array
(
[0] => Property Disclosure Stmt,See Remarks
)
[easements] => Array
(
[0] => Other
)
[elementary_school] => Array
(
[0] => Leihoku
)
[floor_covering] => Array
(
[0] => Ceramic Tile,Vinyl,W/W Carpet
)
[frontage] => Array
(
[0] => Other
)
[full_baths] => Array
(
[0] => 3
)
[half_baths] => Array
(
[0] => 0
)
[high_school] => Array
(
[0] => Waianae
)
[home_exampt] => Array
(
[0] => 0
)
[land_area_sf] => Array
(
[0] => 7794.00
)
[land_recorded] => Array
(
[0] => Regular System
)
[land_tenure] => Array
(
[0] => FS - Fee Simple
)
[list_agent_email] => Array
(
[0] => nathaniel.forbes@locationshawaii.com
)
[list_agent_name] => Array
(
[0] => Nathaniel Forbes
)
[list_agent_phone_number] => Array
(
[0] => (808) 690-9555
)
[list_date] => Array
(
[0] => 2022-04-06
)
[list_office_name] => Array
(
[0] => Locations LLC
)
[list_price] => Array
(
[0] => 910000.00
)
[living_sf] => Array
(
[0] => 1798
)
[location] => Array
(
[0] => 86-343 Kauaopuu Street, Waianae, HI 96792
)
[middle_school] => Array
(
[0] => Waianae
)
[mls_] => Array
(
[0] => 202206596
)
[neighborhood] => Array
(
[0] => LUALUALEI
)
[number_of_parking_spaces] => Array
(
[0] => 4
)
[number_of_stories] => Array
(
[0] => Two
)
[office_mls_id] => Array
(
[0] => LOCA05
)
[parking_features] => Array
(
[0] => 3 Car+,Boat,Garage
)
[pool_] => Array
(
[0] => None
)
[possession] => Array
(
[0] => At Closing
)
[postal_code] => Array
(
[0] => 96792
)
[property_condition] => Array
(
[0] => Excellent
)
[property_type] => Array
(
[0] => single_family
)
[property_type_label] => Array
(
[0] => single_family
)
[region] => Array
(
[0] => Leeward
)
[rets_baths_full] => Array
(
[0] => 3
)
[rets_baths_half] => Array
(
[0] => 0
)
[rets_baths_total] => Array
(
[0] => 3.00
)
[rets_beds_total] => Array
(
[0] => 4
)
[rets_city] => Array
(
[0] => Waianae
)
[rets_co_list_agent_direct_work_phone] => Array
(
[0] => (808) 735-4200
)
[rets_co_list_agent_email] => Array
(
[0] => leeroy.kusto@locationshawaii.com
)
[rets_co_list_agent_full_name] => Array
(
[0] => Leeroy Kusto
)
[rets_co_list_agent_mlsid] => Array
(
[0] => 51770
)
[rets_co_list_agent_mui] => Array
(
[0] => 16202529
)
[rets_co_list_office_mlsid] => Array
(
[0] => LOCA
)
[rets_co_list_office_mui] => Array
(
[0] => 3485305
)
[rets_co_list_office_name] => Array
(
[0] => Locations LLC
)
[rets_co_list_office_phone] => Array
(
[0] => (808) 735-4200
)
[rets_condo_property_regime_yn] => Array
(
[0] => 0
)
[rets_current_price] => Array
(
[0] => 895000.00
)
[rets_dom] => Array
(
[0] => 14
)
[rets_dual_variable_compensation_yn] => Array
(
[0] => 0
)
[rets_elementary_school] => Array
(
[0] => Leihoku
)
[rets_foreclosure_yn] => Array
(
[0] => 0
)
[rets_fractional_ownership_yn] => Array
(
[0] => 0
)
[rets_high_school] => Array
(
[0] => Waianae
)
[rets_id] => Array
(
[0] => 16552081
)
[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) 690-9555
)
[rets_list_agent_email] => Array
(
[0] => nathaniel.forbes@locationshawaii.com
)
[rets_list_agent_full_name] => Array
(
[0] => Nathaniel Forbes
)
[rets_list_agent_mlsid] => Array
(
[0] => 48220
)
[rets_list_agent_mui] => Array
(
[0] => 12477811
)
[rets_list_office_mlsid] => Array
(
[0] => LOCA05
)
[rets_list_office_mui] => Array
(
[0] => 9727981
)
[rets_list_office_name] => Array
(
[0] => Locations LLC
)
[rets_list_office_phone] => Array
(
[0] => (808) 690-9555
)
[rets_list_price] => Array
(
[0] => 910000.00
)
[rets_listing_contract_date] => Array
(
[0] => 2022-04-06
)
[rets_lot_size_area] => Array
(
[0] => 7794.00
)
[rets_matrix_modified_dt] => Array
(
[0] => 2022-06-13T17:08:08.530
)
[rets_matrix_unique_id] => Array
(
[0] => 16552081
)
[rets_middle_or_junior_school] => Array
(
[0] => Waianae
)
[rets_mls_number] => Array
(
[0] => 202206596
)
[rets_neighbourhood] => Array
(
[0] => LUALUALEI
)
[rets_new_development_construction_yn] => Array
(
[0] => 0
)
[rets_original_entry_timestamp] => Array
(
[0] => 2022-04-06T16:01:46.410
)
[rets_original_list_price] => Array
(
[0] => 850000.00
)
[rets_parcel_number] => Array
(
[0] => 1-8-6-021-013-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] => 25
)
[rets_photo_modification_timestamp] => Array
(
[0] => 2022-04-06T18:10:42.670
)
[rets_postal_code] => Array
(
[0] => 96792
)
[rets_price_change_timestamp] => Array
(
[0] => 2022-04-28T14:42:11.643
)
[rets_primary_key] => Array
(
[0] => 16552081
)
[rets_private_remarks] => Array
(
[0] => First Open House Sat April 9th and Sun April 10th 2-5 pm. Offers are due on Wednesday April 13th at 5 pm. Vacant & Easy to Show. For Showing details, please contact Leeroy Kusto at 808-373-6272. Seller prefers Pam Sato from TG***For Offer Instructions and Home Features Sheet, please see the attached supplements*** (# baths differ from tax records). ***Monthly tax based on 2021 assessed values.
)
[rets_public_remarks] => Array
(
[0] => Welcome Home! The best that Lualualei has to offer. Welcome to this FULLY renovated 4 bedroom 3 bath home. This single family home features an Open Concept floor plan with immaculate finishes from stainless steel appliances, quartz countertops, white shaker cabinets with modern fixtures, recessed lighting, as well as luxury vinyl tile flooring throughout. Entertain your family & friends while cooking your favorite meal as they sit at the open peninsula bar or in the living room. This home was thoughtfully
designed with ohana in mind; there's a family room as well as a bedroom en suite on the 1st floor/ground level. There are 2 lanais overlooking the HUGE yard comprising of over 7,790 sq ft. Other noteworthy features include 2 car garage, new roof, new windows, new AC units, White Vinyl perimeter fencing which provides privacy and security, newly installed irrigation system, freshly grown el toro grass and lush landscaping. The list of improvements continues. Great location close to world famous Pokai
Bay Beach, Tamura Supermarket, Beach House by 604 Restaurant and many more attractions with Kapolei/Ewa and Ko Olina within 25 minutes.
)
[rets_room_count] => Array
(
[0] => 4
)
[rets_sqft_roofed_living] => Array
(
[0] => 1798
)
[rets_sqft_total] => Array
(
[0] => 1798
)
[rets_state_or_province] => Array
(
[0] => HI
)
[rets_status_change_timestamp] => Array
(
[0] => 2022-06-13T17:08:08.530
)
[rets_status_contractual_search_date] => Array
(
[0] => 2022-06-09
)
[rets_street_name] => Array
(
[0] => Kauaopuu
)
[rets_street_number] => Array
(
[0] => 86-343
)
[rets_street_view_param] => Array
(
[0] => 1$21.440601$-158.176319$337.43$13.33$1.00$ADEBg8vZVzNIL5Yt3JGnIQ
)
[rets_sub_agency_compensation] => Array
(
[0] => 2%
)
[rets_tax_amount] => Array
(
[0] => 137.00
)
[rets_tax_annual_amount] => Array
(
[0] => 1644.00
)
[rets_tax_assessed_value] => Array
(
[0] => 651600.00
)
[rets_tax_assessed_value_improvements] => Array
(
[0] => 241300.00
)
[rets_tax_assessed_value_land] => Array
(
[0] => 410300.00
)
[rets_tax_excemption_owner_occupancy] => Array
(
[0] => 0
)
[rets_tax_paid_by_seller_yn] => Array
(
[0] => 1
)
[rets_tax_year] => Array
(
[0] => 2022
)
[rets_thumbnail_url] => Array
(
[0] => https://cdn.rets.ci/marcusrealty-images/16552081/fbaf43eefa1d91b1b8ff5233bc93f73f
)
[rets_tmk_area] => Array
(
[0] => 186
)
[rets_tmk_condo_property_regime_number] => Array
(
[0] => 0
)
[rets_tmk_division] => Array
(
[0] => 1
)
[rets_tmk_parcel] => Array
(
[0] => 13
)
[rets_tmk_section] => Array
(
[0] => 6
)
[rets_tmk_zone] => Array
(
[0] => 8
)
[rets_tmkplat] => Array
(
[0] => 21
)
[rets_year_built] => Array
(
[0] => 1974
)
[security] => Array
(
[0] => Key
)
[setbacks] => Array
(
[0] => C&C
)
[state_or_province] => Array
(
[0] => HI
)
[status] => Array
(
[0] => Sold
)
[street_name] => Array
(
[0] => Kauaopuu
)
[street_number] => Array
(
[0] => 86-343
)
[street_suffix] => Array
(
[0] => Street
)
[terms_accept] => Array
(
[0] => Cash,Conventional,FHA,USDA Financing,VA
)
[tmk] => Array
(
[0] => 1-8-6-021-013-0000
)
[topography] => Array
(
[0] => Clear
)
[view] => Array
(
[0] => Garden,Mountain,Sunset
)
[wpp::rets_pk] => Array
(
[0] => 16552081
)
[wpp_gpid] => Array
(
[0] => 202206596
)
[wpp_import_schedule_id] => Array
(
[0] => 1463343682
)
[wpp_import_time] => Array
(
[0] => 1655176116
)
[year_built] => Array
(
[0] => 1974
)
[zoning] => Array
(
[0] => 05 - R-5 Residential District
)
[new_attached_media] => Array
(
[0] => a:294:{i:0;i:21966127;i:1;i:21966128;i:2;i:21966129;i:3;i:21966130;i:4;i:21966131;i:5;i:21966132;i:6;i:21966133;i:7;i:21966134;i:8;i:21966135;i:9;i:21966136;i:10;i:21966137;i:11;i:21966138;i:12;i:21966139;i:13;i:21966140;i:14;i:21966141;i:15;i:21966142;i:16;i:21966143;i:17;i:21966144;i:18;i:21966145;i:19;i:21966146;i:20;i:21966147;i:21;i:21966148;i:22;i:21966149;i:23;i:21966150;i:24;i:21966151;i:25;i:21966152;i:26;i:21966153;i:27;i:21966154;i:28;i:21966155;i:29;i:21966156;i:30;i:21966157;i:31;i:21966158;i:32;i:21966159;i:33;i:21966160;i:34;i:21966161;i:35;i:21966162;i:36;i:21966163;i:37;i:21966164;i:38;i:21966165;i:39;i:21966166;i:40;i:21966167;i:41;i:21966168;i:42;i:21966259;i:43;i:21966260;i:44;i:21966261;i:45;i:21966262;i:46;i:21966263;i:47;i:21966264;i:48;i:21966265;i:49;i:21966266;i:50;i:21966267;i:51;i:21966268;i:52;i:21966269;i:53;i:21966270;i:54;i:21966271;i:55;i:21966272;i:56;i:21966273;i:57;i:21966274;i:58;i:21966275;i:59;i:21966276;i:60;i:21966277;i:61;i:21966278;i:62;i:21966279;i:63;i:21967135;i:64;i:21967136;i:65;i:21967137;i:66;i:21967138;i:67;i:21967139;i:68;i:21967140;i:69;i:21967141;i:70;i:21967142;i:71;i:21967143;i:72;i:21967144;i:73;i:21967145;i:74;i:21967146;i:75;i:21967147;i:76;i:21967148;i:77;i:21967149;i:78;i:21967150;i:79;i:21967151;i:80;i:21967152;i:81;i:21967153;i:82;i:21967154;i:83;i:21967155;i:84;i:21971010;i:85;i:21971011;i:86;i:21971012;i:87;i:21971013;i:88;i:21971014;i:89;i:21971015;i:90;i:21971016;i:91;i:21971017;i:92;i:21971018;i:93;i:21971019;i:94;i:21971020;i:95;i:21971021;i:96;i:21971022;i:97;i:21971023;i:98;i:21971024;i:99;i:21971025;i:100;i:21971026;i:101;i:21971027;i:102;i:21971028;i:103;i:21971029;i:104;i:21971030;i:105;i:21981104;i:106;i:21981105;i:107;i:21981106;i:108;i:21981107;i:109;i:21981108;i:110;i:21981109;i:111;i:21981110;i:112;i:21981111;i:113;i:21981112;i:114;i:21981113;i:115;i:21981114;i:116;i:21981115;i:117;i:21981116;i:118;i:21981117;i:119;i:21981118;i:120;i:21981119;i:121;i:21981120;i:122;i:21981121;i:123;i:21981122;i:124;i:21981123;i:125;i:21981124;i:126;i:21981125;i:127;i:21981126;i:128;i:21981127;i:129;i:21981128;i:130;i:21981129;i:131;i:21981130;i:132;i:21981131;i:133;i:21981132;i:134;i:21981133;i:135;i:21981134;i:136;i:21981135;i:137;i:21981136;i:138;i:21981137;i:139;i:21981138;i:140;i:21981139;i:141;i:21981140;i:142;i:21981141;i:143;i:21981142;i:144;i:21981143;i:145;i:21981144;i:146;i:21981145;i:147;i:21996173;i:148;i:21996174;i:149;i:21996175;i:150;i:21996176;i:151;i:21996177;i:152;i:21996178;i:153;i:21996179;i:154;i:21996180;i:155;i:21996181;i:156;i:21996182;i:157;i:21996183;i:158;i:21996184;i:159;i:21996185;i:160;i:21996186;i:161;i:21996187;i:162;i:21996188;i:163;i:21996189;i:164;i:21996190;i:165;i:21996191;i:166;i:21996192;i:167;i:21996193;i:168;i:21998106;i:169;i:21998107;i:170;i:21998108;i:171;i:21998109;i:172;i:21998110;i:173;i:21998111;i:174;i:21998112;i:175;i:21998113;i:176;i:21998114;i:177;i:21998115;i:178;i:21998116;i:179;i:21998117;i:180;i:21998118;i:181;i:21998119;i:182;i:21998120;i:183;i:21998121;i:184;i:21998122;i:185;i:21998123;i:186;i:21998124;i:187;i:21998125;i:188;i:21998126;i:189;i:22016819;i:190;i:22016820;i:191;i:22016821;i:192;i:22016822;i:193;i:22016823;i:194;i:22016824;i:195;i:22016825;i:196;i:22016826;i:197;i:22016827;i:198;i:22016828;i:199;i:22016829;i:200;i:22016830;i:201;i:22016831;i:202;i:22016832;i:203;i:22016833;i:204;i:22016834;i:205;i:22016835;i:206;i:22016836;i:207;i:22016837;i:208;i:22016838;i:209;i:22016839;i:210;i:22056802;i:211;i:22056803;i:212;i:22056804;i:213;i:22056805;i:214;i:22056806;i:215;i:22056807;i:216;i:22056808;i:217;i:22056809;i:218;i:22056810;i:219;i:22056811;i:220;i:22056812;i:221;i:22056813;i:222;i:22056814;i:223;i:22056815;i:224;i:22056816;i:225;i:22056817;i:226;i:22056818;i:227;i:22056819;i:228;i:22056820;i:229;i:22056821;i:230;i:22056822;i:231;i:22063464;i:232;i:22063465;i:233;i:22063466;i:234;i:22063467;i:235;i:22063468;i:236;i:22063469;i:237;i:22063470;i:238;i:22063471;i:239;i:22063472;i:240;i:22063473;i:241;i:22063474;i:242;i:22063475;i:243;i:22063476;i:244;i:22063477;i:245;i:22063478;i:246;i:22063479;i:247;i:22063480;i:248;i:22063481;i:249;i:22063482;i:250;i:22063483;i:251;i:22063484;i:252;i:22114321;i:253;i:22114322;i:254;i:22114323;i:255;i:22114324;i:256;i:22114325;i:257;i:22114326;i:258;i:22114327;i:259;i:22114328;i:260;i:22114329;i:261;i:22114330;i:262;i:22114331;i:263;i:22114332;i:264;i:22114333;i:265;i:22114334;i:266;i:22114335;i:267;i:22114336;i:268;i:22114337;i:269;i:22114338;i:270;i:22114339;i:271;i:22114340;i:272;i:22114341;i:273;i:22430087;i:274;i:22430088;i:275;i:22430089;i:276;i:22430090;i:277;i:22430091;i:278;i:22430092;i:279;i:22430093;i:280;i:22430094;i:281;i:22430095;i:282;i:22430096;i:283;i:22430097;i:284;i:22430098;i:285;i:22430099;i:286;i:22430100;i:287;i:22430101;i:288;i:22430102;i:289;i:22430103;i:290;i:22430104;i:291;i:22430105;i:292;i:22430106;i:293;i:22430107;}
)
[rets_open_house_count] => Array
(
[0] => 4
)
[rets_active_open_house_count] => Array
(
[0] => 0
)
[rets_open_house_upcoming] => Array
(
[0] =>
)
[rets_year_remodeled] => Array
(
[0] => 2022
)
[year_remodeled_] => Array
(
[0] => 2022
)
[rets_supplement_count] => Array
(
[0] => 3
)
[rets_supplement_modification_timestam] => Array
(
[0] => 2022-04-11T17:20:39.323
)
[rets_active_continue_to_show_date] => Array
(
[0] => 2022-04-18
)
[rets_close_date] => Array
(
[0] => 2022-06-09
)
[rets_close_price] => Array
(
[0] => 895000.00
)
[rets_concessions] => Array
(
[0] => 5000
)
[rets_expiration_date] => Array
(
[0] => 2023-04-03
)
[rets_off_market_date] => Array
(
[0] => 2022-06-09
)
[rets_selling_agent_direct_work_phone] => Array
(
[0] => (808) 735-4200
)
[rets_selling_agent_email] => Array
(
[0] => aaron.johnson@locationshawaii.com
)
[rets_selling_agent_full_name] => Array
(
[0] => Aaron J Johnson
)
[rets_selling_agent_mlsid] => Array
(
[0] => 46281
)
[rets_selling_agent_mui] => Array
(
[0] => 10146865
)
[rets_selling_office_mlsid] => Array
(
[0] => LOCA
)
[rets_selling_office_mui] => Array
(
[0] => 3485305
)
[rets_selling_office_name] => Array
(
[0] => Locations LLC
)
[rets_selling_office_phone] => Array
(
[0] => (808) 735-4200
)
[_thumbnail_id] => Array
(
[0] => 22430087
)
)
CONTACT US
#RB-7120
info@marcushawaii.com
(808)839-7446