MULTI/FLEXIBLE LIVING OPTION large single level home with 2,246 living area and rarely available 11,386 sq.ft. of Land at the foothills of majestic Mt. Ka’ala in a well desired neighborhood called Ranch Camp. This 5 bedrooms/3 baths home with MULTI/FLEXIBLE LIVING OPTIONS has been well maintained. Ample storage space for all of those surfboards and workshop tools. Separate laundry rooms inside and outside. Secured fenced yard for added privacy. 22 Paneled Photovoltaic-owned, 2 panel solar water system, and a newer roof. Ample yard with lush tropical plants, an orchard of mango trees, avocado, citrus trees, mountain apple and room to grow more. Minutes from world renowned and uncrowded Northshore beaches, to swim, snorkel, surf the best spots, Close to mountains to escape to hiking trails. Near Ka’ena Point State Park with breath taking scenery and walking trails. Walk to schools. Enjoy Historical Waialua Sugar Mill and Haleiwa Town close by. Quick drive to Schofield, Honolulu, Airport, shopping etc. Come home and breath in the fresh country air! By appointment and FIRST OPEN IS APRIL 10.
Listing by: TLC Realty LLC
array(170) {
["assd_val_imprv"]=>
array(1) {
[0]=>
string(9) "335000.00"
}
["assd_val_land"]=>
array(1) {
[0]=>
string(9) "597700.00"
}
["assd_val_total"]=>
array(1) {
[0]=>
string(9) "932800.00"
}
["bedrooms"]=>
array(1) {
[0]=>
string(1) "5"
}
["building_style"]=>
array(1) {
[0]=>
string(20) "Detach Single Family"
}
["city"]=>
array(1) {
[0]=>
string(7) "Waialua"
}
["county"]=>
array(1) {
[0]=>
string(4) "Oahu"
}
["disclosures"]=>
array(1) {
[0]=>
string(37) "Photovoltaic,Property Disclosure Stmt"
}
["easements"]=>
array(1) {
[0]=>
string(4) "None"
}
["elementary_school"]=>
array(1) {
[0]=>
string(7) "Waialua"
}
["floor_covering"]=>
array(1) {
[0]=>
string(18) "Ceramic Tile,Vinyl"
}
["full_baths"]=>
array(1) {
[0]=>
string(1) "4"
}
["furnished"]=>
array(1) {
[0]=>
string(4) "None"
}
["half_baths"]=>
array(1) {
[0]=>
string(1) "0"
}
["high_school"]=>
array(1) {
[0]=>
string(7) "Waialua"
}
["home_exampt"]=>
array(1) {
[0]=>
string(6) "140000"
}
["land_area_sf"]=>
array(1) {
[0]=>
string(8) "11386.00"
}
["land_recorded"]=>
array(1) {
[0]=>
string(10) "Land Court"
}
["land_tenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["list_agent_email"]=>
array(1) {
[0]=>
string(18) "mlyons7734@aol.com"
}
["list_agent_name"]=>
array(1) {
[0]=>
string(15) "Marilee Y Lyons"
}
["list_agent_phone_number"]=>
array(1) {
[0]=>
string(14) "(808) 852-2555"
}
["list_date"]=>
array(1) {
[0]=>
string(10) "2022-03-31"
}
["list_office_name"]=>
array(1) {
[0]=>
string(14) "TLC Realty LLC"
}
["list_price"]=>
array(1) {
[0]=>
string(10) "1400000.00"
}
["living_sf"]=>
array(1) {
[0]=>
string(4) "2456"
}
["location"]=>
array(1) {
[0]=>
string(38) "67-568 Kahui Street, Waialua, HI 96791"
}
["middle_school"]=>
array(1) {
[0]=>
string(7) "Waialua"
}
["mls_"]=>
array(1) {
[0]=>
string(9) "202205732"
}
["neighborhood"]=>
array(1) {
[0]=>
string(7) "WAIALUA"
}
["number_of_parking_spaces"]=>
array(1) {
[0]=>
string(1) "2"
}
["number_of_stories"]=>
array(1) {
[0]=>
string(3) "One"
}
["office_mls_id"]=>
array(1) {
[0]=>
string(4) "TLCT"
}
["parking_features"]=>
array(1) {
[0]=>
string(29) "3 Car+,Driveway,Garage,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) "96791"
}
["property_condition"]=>
array(1) {
[0]=>
string(13) "Above 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(11) "North Shore"
}
["rets_baths_full"]=>
array(1) {
[0]=>
string(1) "4"
}
["rets_baths_half"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_baths_total"]=>
array(1) {
[0]=>
string(4) "4.00"
}
["rets_beds_total"]=>
array(1) {
[0]=>
string(1) "5"
}
["rets_city"]=>
array(1) {
[0]=>
string(7) "Waialua"
}
["rets_condo_property_regime_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_current_price"]=>
array(1) {
[0]=>
string(10) "1400000.00"
}
["rets_dom"]=>
array(1) {
[0]=>
string(2) "30"
}
["rets_dual_variable_compensation_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_elementary_school"]=>
array(1) {
[0]=>
string(7) "Waialua"
}
["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) "Waialua"
}
["rets_id"]=>
array(1) {
[0]=>
string(8) "16531391"
}
["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) 852-2555"
}
["rets_list_agent_email"]=>
array(1) {
[0]=>
string(18) "mlyons7734@aol.com"
}
["rets_list_agent_full_name"]=>
array(1) {
[0]=>
string(15) "Marilee Y Lyons"
}
["rets_list_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "15927"
}
["rets_list_agent_mui"]=>
array(1) {
[0]=>
string(7) "3473236"
}
["rets_list_office_mlsid"]=>
array(1) {
[0]=>
string(4) "TLCT"
}
["rets_list_office_mui"]=>
array(1) {
[0]=>
string(7) "3487727"
}
["rets_list_office_name"]=>
array(1) {
[0]=>
string(14) "TLC Realty LLC"
}
["rets_list_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 852-2555"
}
["rets_list_price"]=>
array(1) {
[0]=>
string(10) "1400000.00"
}
["rets_listing_contract_date"]=>
array(1) {
[0]=>
string(10) "2022-03-31"
}
["rets_lot_size_area"]=>
array(1) {
[0]=>
string(8) "11386.00"
}
["rets_matrix_modified_dt"]=>
array(1) {
[0]=>
string(23) "2022-06-17T15:59:00.050"
}
["rets_matrix_unique_id"]=>
array(1) {
[0]=>
string(8) "16531391"
}
["rets_middle_or_junior_school"]=>
array(1) {
[0]=>
string(7) "Waialua"
}
["rets_mls_number"]=>
array(1) {
[0]=>
string(9) "202205732"
}
["rets_neighbourhood"]=>
array(1) {
[0]=>
string(7) "WAIALUA"
}
["rets_new_development_construction_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_original_entry_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-03-31T12:40:42.093"
}
["rets_original_list_price"]=>
array(1) {
[0]=>
string(10) "1700000.00"
}
["rets_parcel_number"]=>
array(1) {
[0]=>
string(18) "1-6-7-011-067-0000"
}
["rets_parking_total"]=>
array(1) {
[0]=>
string(1) "2"
}
["rets_permit_address_internet_yn"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_permit_internet_yn"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_photo_count"]=>
array(1) {
[0]=>
string(2) "25"
}
["rets_photo_modification_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-03-31T12:40:42.093"
}
["rets_postal_code"]=>
array(1) {
[0]=>
string(5) "96791"
}
["rets_primary_key"]=>
array(1) {
[0]=>
string(8) "16531391"
}
["rets_private_remarks"]=>
array(1) {
[0]=>
string(250) "Call or text Marilee @808-722-3040 for showing appointments, do not use showtime. Please attach "As Is Addendum" and "Lead Base Paint Addendum", flyer to do own due diligence. Bedrooms do not match tax office records, permit package will be provided."
}
["rets_public_remarks"]=>
array(1) {
[0]=>
string(1105) "MULTI/FLEXIBLE LIVING OPTION large single level home with 2,246 living area and rarely available 11,386 sq.ft. of Land at the foothills of majestic Mt. Ka'ala in a well desired neighborhood called Ranch Camp. This 5 bedrooms/3 baths home with MULTI/FLEXIBLE LIVING OPTIONS has been well maintained. Ample storage space for all of those surfboards and workshop tools. Separate laundry rooms inside and outside. Secured fenced yard for added privacy. 22 Paneled Photovoltaic-owned, 2 panel solar water system, and a newer roof. Ample yard with lush tropical plants, an orchard of mango trees, avocado, citrus trees, mountain apple and room to grow more. Minutes from world renowned and uncrowded Northshore beaches, to swim, snorkel, surf the best spots, Close to mountains to escape to hiking trails. Near Ka'ena Point State Park with breath taking scenery and walking trails. Walk to schools. Enjoy Historical Waialua Sugar Mill and Haleiwa Town close by. Quick drive to Schofield, Honolulu, Airport, shopping etc. Come home and breath in the fresh country air! By appointment and FIRST OPEN IS APRIL 10."
}
["rets_room_count"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_sqft_garage_carport"]=>
array(1) {
[0]=>
string(3) "520"
}
["rets_sqft_roofed_living"]=>
array(1) {
[0]=>
string(4) "2246"
}
["rets_sqft_roofed_other"]=>
array(1) {
[0]=>
string(3) "210"
}
["rets_sqft_total"]=>
array(1) {
[0]=>
string(4) "2456"
}
["rets_state_or_province"]=>
array(1) {
[0]=>
string(2) "HI"
}
["rets_status_change_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-06-17T15:59:00.050"
}
["rets_status_contractual_search_date"]=>
array(1) {
[0]=>
string(10) "2022-06-17"
}
["rets_street_name"]=>
array(1) {
[0]=>
string(5) "Kahui"
}
["rets_street_number"]=>
array(1) {
[0]=>
string(6) "67-568"
}
["rets_street_view_param"]=>
array(1) {
[0]=>
string(63) "1$21.563987$-158.125446$83.91$13.33$1.00$ItYFWPqWcn8iMeQI-9x-yw"
}
["rets_sub_agency_compensation"]=>
array(1) {
[0]=>
string(3) "2.5"
}
["rets_supplement_count"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_supplement_modification_timestam"]=>
array(1) {
[0]=>
string(23) "2022-03-31T11:40:43.160"
}
["rets_tax_amount"]=>
array(1) {
[0]=>
string(6) "229.00"
}
["rets_tax_annual_amount"]=>
array(1) {
[0]=>
string(7) "2748.00"
}
["rets_tax_assessed_value"]=>
array(1) {
[0]=>
string(9) "932800.00"
}
["rets_tax_assessed_value_improvements"]=>
array(1) {
[0]=>
string(9) "335000.00"
}
["rets_tax_assessed_value_land"]=>
array(1) {
[0]=>
string(9) "597700.00"
}
["rets_tax_excemption_owner_occupancy"]=>
array(1) {
[0]=>
string(6) "140000"
}
["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/16531391/2d2dad8d721c11f49ff5d2e3d0229122"
}
["rets_tmk_area"]=>
array(1) {
[0]=>
string(3) "167"
}
["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) "67"
}
["rets_tmk_section"]=>
array(1) {
[0]=>
string(1) "7"
}
["rets_tmk_zone"]=>
array(1) {
[0]=>
string(1) "6"
}
["rets_tmkplat"]=>
array(1) {
[0]=>
string(2) "11"
}
["rets_virtual_tour_url_unbranded"]=>
array(1) {
[0]=>
string(53) "https://sun-rider-images.seehouseat.com/1976322?idx=1"
}
["rets_year_built"]=>
array(1) {
[0]=>
string(4) "1956"
}
["rets_year_remodeled"]=>
array(1) {
[0]=>
string(4) "1969"
}
["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(5) "Kahui"
}
["street_number"]=>
array(1) {
[0]=>
string(6) "67-568"
}
["street_suffix"]=>
array(1) {
[0]=>
string(6) "Street"
}
["terms_accept"]=>
array(1) {
[0]=>
string(20) "Cash,Conventional,VA"
}
["tmk"]=>
array(1) {
[0]=>
string(18) "1-6-7-011-067-0000"
}
["topography"]=>
array(1) {
[0]=>
string(5) "Clear"
}
["view"]=>
array(1) {
[0]=>
string(15) "Mountain,Sunset"
}
["virtual_tour"]=>
array(1) {
[0]=>
string(53) "https://sun-rider-images.seehouseat.com/1976322?idx=1"
}
["wpp::rets_pk"]=>
array(1) {
[0]=>
string(8) "16531391"
}
["wpp_gpid"]=>
array(1) {
[0]=>
string(9) "202205732"
}
["wpp_import_schedule_id"]=>
array(1) {
[0]=>
string(10) "1463343682"
}
["wpp_import_time"]=>
array(1) {
[0]=>
string(10) "1655517581"
}
["year_built"]=>
array(1) {
[0]=>
string(4) "1956"
}
["year_remodeled_"]=>
array(1) {
[0]=>
string(4) "1969"
}
["zoning"]=>
array(1) {
[0]=>
string(31) "04 - R-7.5 Residential District"
}
["new_attached_media"]=>
array(1) {
[0]=>
string(2397) "a:147:{i:0;i:21937069;i:1;i:21937070;i:2;i:21937071;i:3;i:21937072;i:4;i:21937073;i:5;i:21937074;i:6;i:21937075;i:7;i:21937076;i:8;i:21937077;i:9;i:21937078;i:10;i:21937079;i:11;i:21937080;i:12;i:21937081;i:13;i:21937082;i:14;i:21937083;i:15;i:21937084;i:16;i:21937085;i:17;i:21937086;i:18;i:21937087;i:19;i:21937088;i:20;i:21937089;i:21;i:21971910;i:22;i:21971911;i:23;i:21971912;i:24;i:21971913;i:25;i:21971914;i:26;i:21971915;i:27;i:21971916;i:28;i:21971917;i:29;i:21971918;i:30;i:21971919;i:31;i:21971920;i:32;i:21971921;i:33;i:21971922;i:34;i:21971923;i:35;i:21971924;i:36;i:21971925;i:37;i:21971926;i:38;i:21971927;i:39;i:21971928;i:40;i:21971929;i:41;i:21971930;i:42;i:21983072;i:43;i:21983073;i:44;i:21983074;i:45;i:21983075;i:46;i:21983076;i:47;i:21983077;i:48;i:21983078;i:49;i:21983079;i:50;i:21983080;i:51;i:21983081;i:52;i:21983082;i:53;i:21983083;i:54;i:21983084;i:55;i:21983085;i:56;i:21983086;i:57;i:21983087;i:58;i:21983088;i:59;i:21983089;i:60;i:21983090;i:61;i:21983091;i:62;i:21983092;i:63;i:22037111;i:64;i:22037112;i:65;i:22037113;i:66;i:22037114;i:67;i:22037115;i:68;i:22037116;i:69;i:22037117;i:70;i:22037118;i:71;i:22037119;i:72;i:22037120;i:73;i:22037121;i:74;i:22037122;i:75;i:22037123;i:76;i:22037124;i:77;i:22037125;i:78;i:22037126;i:79;i:22037127;i:80;i:22037128;i:81;i:22037129;i:82;i:22037130;i:83;i:22037131;i:84;i:22057437;i:85;i:22057438;i:86;i:22057439;i:87;i:22057440;i:88;i:22057441;i:89;i:22057442;i:90;i:22057443;i:91;i:22057444;i:92;i:22057445;i:93;i:22057446;i:94;i:22057447;i:95;i:22057448;i:96;i:22057449;i:97;i:22057450;i:98;i:22057451;i:99;i:22057452;i:100;i:22057453;i:101;i:22057454;i:102;i:22057455;i:103;i:22057456;i:104;i:22057457;i:105;i:22128227;i:106;i:22128228;i:107;i:22128229;i:108;i:22128230;i:109;i:22128231;i:110;i:22128232;i:111;i:22128233;i:112;i:22128234;i:113;i:22128235;i:114;i:22128236;i:115;i:22128237;i:116;i:22128238;i:117;i:22128239;i:118;i:22128240;i:119;i:22128241;i:120;i:22128242;i:121;i:22128243;i:122;i:22128244;i:123;i:22128245;i:124;i:22128246;i:125;i:22128247;i:126;i:22468612;i:127;i:22468613;i:128;i:22468614;i:129;i:22468615;i:130;i:22468616;i:131;i:22468617;i:132;i:22468618;i:133;i:22468619;i:134;i:22468620;i:135;i:22468621;i:136;i:22468622;i:137;i:22468623;i:138;i:22468624;i:139;i:22468625;i:140;i:22468626;i:141;i:22468627;i:142;i:22468628;i:143;i:22468629;i:144;i:22468630;i:145;i:22468631;i:146;i:22468632;}"
}
["rets_open_house_count"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_active_open_house_count"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_price_change_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-04-18T09:11:26.910"
}
["rets_active_continue_to_show_date"]=>
array(1) {
[0]=>
string(10) "2022-04-29"
}
["rets_close_date"]=>
array(1) {
[0]=>
string(10) "2022-06-17"
}
["rets_close_price"]=>
array(1) {
[0]=>
string(10) "1400000.00"
}
["rets_co_selling_agent_direct_work_pho"]=>
array(1) {
[0]=>
string(14) "(800) 370-3848"
}
["rets_co_selling_agent_email"]=>
array(1) {
[0]=>
string(20) "julia@hawaiilife.com"
}
["rets_co_selling_agent_full_name"]=>
array(1) {
[0]=>
string(18) "Julia Napua Fetzer"
}
["rets_co_selling_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "26358"
}
["rets_co_selling_agent_mui"]=>
array(1) {
[0]=>
string(7) "3476047"
}
["rets_co_selling_office_mlsid"]=>
array(1) {
[0]=>
string(4) "HLRE"
}
["rets_co_selling_office_mui"]=>
array(1) {
[0]=>
string(7) "3487136"
}
["rets_co_selling_office_name"]=>
array(1) {
[0]=>
string(11) "Hawaii Life"
}
["rets_co_selling_office_phone"]=>
array(1) {
[0]=>
string(14) "(800) 370-3848"
}
["rets_concessions"]=>
array(1) {
[0]=>
string(4) "3783"
}
["rets_expiration_date"]=>
array(1) {
[0]=>
string(10) "2022-08-31"
}
["rets_off_market_date"]=>
array(1) {
[0]=>
string(10) "2022-06-17"
}
["rets_selling_agent_direct_work_phone"]=>
array(1) {
[0]=>
string(14) "(800) 370-3848"
}
["rets_selling_agent_email"]=>
array(1) {
[0]=>
string(28) "kylebernhardt@hawaiilife.com"
}
["rets_selling_agent_full_name"]=>
array(1) {
[0]=>
string(14) "Kyle Bernhardt"
}
["rets_selling_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "46408"
}
["rets_selling_agent_mui"]=>
array(1) {
[0]=>
string(8) "10235678"
}
["rets_selling_agent_remarks"]=>
array(1) {
[0]=>
string(107) "Mahalo Kyle and Julia, it was a pleasure doing this transaction with you both! And for all your help Kyle."
}
["rets_selling_office_mlsid"]=>
array(1) {
[0]=>
string(4) "HLRE"
}
["rets_selling_office_mui"]=>
array(1) {
[0]=>
string(7) "3487136"
}
["rets_selling_office_name"]=>
array(1) {
[0]=>
string(11) "Hawaii Life"
}
["rets_selling_office_phone"]=>
array(1) {
[0]=>
string(14) "(800) 370-3848"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "22468612"
}
}
Array
(
[assd_val_imprv] => Array
(
[0] => 335000.00
)
[assd_val_land] => Array
(
[0] => 597700.00
)
[assd_val_total] => Array
(
[0] => 932800.00
)
[bedrooms] => Array
(
[0] => 5
)
[building_style] => Array
(
[0] => Detach Single Family
)
[city] => Array
(
[0] => Waialua
)
[county] => Array
(
[0] => Oahu
)
[disclosures] => Array
(
[0] => Photovoltaic,Property Disclosure Stmt
)
[easements] => Array
(
[0] => None
)
[elementary_school] => Array
(
[0] => Waialua
)
[floor_covering] => Array
(
[0] => Ceramic Tile,Vinyl
)
[full_baths] => Array
(
[0] => 4
)
[furnished] => Array
(
[0] => None
)
[half_baths] => Array
(
[0] => 0
)
[high_school] => Array
(
[0] => Waialua
)
[home_exampt] => Array
(
[0] => 140000
)
[land_area_sf] => Array
(
[0] => 11386.00
)
[land_recorded] => Array
(
[0] => Land Court
)
[land_tenure] => Array
(
[0] => FS - Fee Simple
)
[list_agent_email] => Array
(
[0] => mlyons7734@aol.com
)
[list_agent_name] => Array
(
[0] => Marilee Y Lyons
)
[list_agent_phone_number] => Array
(
[0] => (808) 852-2555
)
[list_date] => Array
(
[0] => 2022-03-31
)
[list_office_name] => Array
(
[0] => TLC Realty LLC
)
[list_price] => Array
(
[0] => 1400000.00
)
[living_sf] => Array
(
[0] => 2456
)
[location] => Array
(
[0] => 67-568 Kahui Street, Waialua, HI 96791
)
[middle_school] => Array
(
[0] => Waialua
)
[mls_] => Array
(
[0] => 202205732
)
[neighborhood] => Array
(
[0] => WAIALUA
)
[number_of_parking_spaces] => Array
(
[0] => 2
)
[number_of_stories] => Array
(
[0] => One
)
[office_mls_id] => Array
(
[0] => TLCT
)
[parking_features] => Array
(
[0] => 3 Car+,Driveway,Garage,Street
)
[pool_] => Array
(
[0] => None
)
[possession] => Array
(
[0] => 45 Days or Less
)
[postal_code] => Array
(
[0] => 96791
)
[property_condition] => Array
(
[0] => Above Average
)
[property_type] => Array
(
[0] => single_family
)
[property_type_label] => Array
(
[0] => single_family
)
[region] => Array
(
[0] => North Shore
)
[rets_baths_full] => Array
(
[0] => 4
)
[rets_baths_half] => Array
(
[0] => 0
)
[rets_baths_total] => Array
(
[0] => 4.00
)
[rets_beds_total] => Array
(
[0] => 5
)
[rets_city] => Array
(
[0] => Waialua
)
[rets_condo_property_regime_yn] => Array
(
[0] => 0
)
[rets_current_price] => Array
(
[0] => 1400000.00
)
[rets_dom] => Array
(
[0] => 30
)
[rets_dual_variable_compensation_yn] => Array
(
[0] => 0
)
[rets_elementary_school] => Array
(
[0] => Waialua
)
[rets_foreclosure_yn] => Array
(
[0] => 0
)
[rets_fractional_ownership_yn] => Array
(
[0] => 0
)
[rets_high_school] => Array
(
[0] => Waialua
)
[rets_id] => Array
(
[0] => 16531391
)
[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) 852-2555
)
[rets_list_agent_email] => Array
(
[0] => mlyons7734@aol.com
)
[rets_list_agent_full_name] => Array
(
[0] => Marilee Y Lyons
)
[rets_list_agent_mlsid] => Array
(
[0] => 15927
)
[rets_list_agent_mui] => Array
(
[0] => 3473236
)
[rets_list_office_mlsid] => Array
(
[0] => TLCT
)
[rets_list_office_mui] => Array
(
[0] => 3487727
)
[rets_list_office_name] => Array
(
[0] => TLC Realty LLC
)
[rets_list_office_phone] => Array
(
[0] => (808) 852-2555
)
[rets_list_price] => Array
(
[0] => 1400000.00
)
[rets_listing_contract_date] => Array
(
[0] => 2022-03-31
)
[rets_lot_size_area] => Array
(
[0] => 11386.00
)
[rets_matrix_modified_dt] => Array
(
[0] => 2022-06-17T15:59:00.050
)
[rets_matrix_unique_id] => Array
(
[0] => 16531391
)
[rets_middle_or_junior_school] => Array
(
[0] => Waialua
)
[rets_mls_number] => Array
(
[0] => 202205732
)
[rets_neighbourhood] => Array
(
[0] => WAIALUA
)
[rets_new_development_construction_yn] => Array
(
[0] => 0
)
[rets_original_entry_timestamp] => Array
(
[0] => 2022-03-31T12:40:42.093
)
[rets_original_list_price] => Array
(
[0] => 1700000.00
)
[rets_parcel_number] => Array
(
[0] => 1-6-7-011-067-0000
)
[rets_parking_total] => Array
(
[0] => 2
)
[rets_permit_address_internet_yn] => Array
(
[0] => 1
)
[rets_permit_internet_yn] => Array
(
[0] => 1
)
[rets_photo_count] => Array
(
[0] => 25
)
[rets_photo_modification_timestamp] => Array
(
[0] => 2022-03-31T12:40:42.093
)
[rets_postal_code] => Array
(
[0] => 96791
)
[rets_primary_key] => Array
(
[0] => 16531391
)
[rets_private_remarks] => Array
(
[0] => Call or text Marilee @808-722-3040 for showing appointments, do not use showtime. Please attach "As Is Addendum" and "Lead Base Paint Addendum", flyer to do own due diligence. Bedrooms do not match tax office records, permit package will be provided.
)
[rets_public_remarks] => Array
(
[0] => MULTI/FLEXIBLE LIVING OPTION large single level home with 2,246 living area and rarely available 11,386 sq.ft. of Land at the foothills of majestic Mt. Ka'ala in a well desired neighborhood called Ranch Camp. This 5 bedrooms/3 baths home with MULTI/FLEXIBLE LIVING OPTIONS has been well maintained. Ample storage space for all of those surfboards and workshop tools. Separate laundry rooms inside and outside. Secured fenced yard for added privacy. 22 Paneled Photovoltaic-owned, 2 panel solar water system, and a newer roof. Ample yard with lush tropical plants, an orchard of mango trees, avocado, citrus trees, mountain apple and room to grow more. Minutes from world renowned and uncrowded Northshore beaches, to swim, snorkel, surf the best spots, Close to mountains to escape to hiking trails. Near Ka'ena Point State Park with breath taking scenery and walking trails. Walk to schools. Enjoy Historical Waialua Sugar Mill and Haleiwa Town close by. Quick drive to Schofield, Honolulu, Airport, shopping etc. Come home and breath in the fresh country air! By appointment and FIRST OPEN IS APRIL 10.
)
[rets_room_count] => Array
(
[0] => 0
)
[rets_sqft_garage_carport] => Array
(
[0] => 520
)
[rets_sqft_roofed_living] => Array
(
[0] => 2246
)
[rets_sqft_roofed_other] => Array
(
[0] => 210
)
[rets_sqft_total] => Array
(
[0] => 2456
)
[rets_state_or_province] => Array
(
[0] => HI
)
[rets_status_change_timestamp] => Array
(
[0] => 2022-06-17T15:59:00.050
)
[rets_status_contractual_search_date] => Array
(
[0] => 2022-06-17
)
[rets_street_name] => Array
(
[0] => Kahui
)
[rets_street_number] => Array
(
[0] => 67-568
)
[rets_street_view_param] => Array
(
[0] => 1$21.563987$-158.125446$83.91$13.33$1.00$ItYFWPqWcn8iMeQI-9x-yw
)
[rets_sub_agency_compensation] => Array
(
[0] => 2.5
)
[rets_supplement_count] => Array
(
[0] => 0
)
[rets_supplement_modification_timestam] => Array
(
[0] => 2022-03-31T11:40:43.160
)
[rets_tax_amount] => Array
(
[0] => 229.00
)
[rets_tax_annual_amount] => Array
(
[0] => 2748.00
)
[rets_tax_assessed_value] => Array
(
[0] => 932800.00
)
[rets_tax_assessed_value_improvements] => Array
(
[0] => 335000.00
)
[rets_tax_assessed_value_land] => Array
(
[0] => 597700.00
)
[rets_tax_excemption_owner_occupancy] => Array
(
[0] => 140000
)
[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/16531391/2d2dad8d721c11f49ff5d2e3d0229122
)
[rets_tmk_area] => Array
(
[0] => 167
)
[rets_tmk_condo_property_regime_number] => Array
(
[0] => 0
)
[rets_tmk_division] => Array
(
[0] => 1
)
[rets_tmk_parcel] => Array
(
[0] => 67
)
[rets_tmk_section] => Array
(
[0] => 7
)
[rets_tmk_zone] => Array
(
[0] => 6
)
[rets_tmkplat] => Array
(
[0] => 11
)
[rets_virtual_tour_url_unbranded] => Array
(
[0] => https://sun-rider-images.seehouseat.com/1976322?idx=1
)
[rets_year_built] => Array
(
[0] => 1956
)
[rets_year_remodeled] => Array
(
[0] => 1969
)
[security] => Array
(
[0] => Key
)
[setbacks] => Array
(
[0] => Of Record
)
[state_or_province] => Array
(
[0] => HI
)
[status] => Array
(
[0] => Sold
)
[street_name] => Array
(
[0] => Kahui
)
[street_number] => Array
(
[0] => 67-568
)
[street_suffix] => Array
(
[0] => Street
)
[terms_accept] => Array
(
[0] => Cash,Conventional,VA
)
[tmk] => Array
(
[0] => 1-6-7-011-067-0000
)
[topography] => Array
(
[0] => Clear
)
[view] => Array
(
[0] => Mountain,Sunset
)
[virtual_tour] => Array
(
[0] => https://sun-rider-images.seehouseat.com/1976322?idx=1
)
[wpp::rets_pk] => Array
(
[0] => 16531391
)
[wpp_gpid] => Array
(
[0] => 202205732
)
[wpp_import_schedule_id] => Array
(
[0] => 1463343682
)
[wpp_import_time] => Array
(
[0] => 1655517581
)
[year_built] => Array
(
[0] => 1956
)
[year_remodeled_] => Array
(
[0] => 1969
)
[zoning] => Array
(
[0] => 04 - R-7.5 Residential District
)
[new_attached_media] => Array
(
[0] => a:147:{i:0;i:21937069;i:1;i:21937070;i:2;i:21937071;i:3;i:21937072;i:4;i:21937073;i:5;i:21937074;i:6;i:21937075;i:7;i:21937076;i:8;i:21937077;i:9;i:21937078;i:10;i:21937079;i:11;i:21937080;i:12;i:21937081;i:13;i:21937082;i:14;i:21937083;i:15;i:21937084;i:16;i:21937085;i:17;i:21937086;i:18;i:21937087;i:19;i:21937088;i:20;i:21937089;i:21;i:21971910;i:22;i:21971911;i:23;i:21971912;i:24;i:21971913;i:25;i:21971914;i:26;i:21971915;i:27;i:21971916;i:28;i:21971917;i:29;i:21971918;i:30;i:21971919;i:31;i:21971920;i:32;i:21971921;i:33;i:21971922;i:34;i:21971923;i:35;i:21971924;i:36;i:21971925;i:37;i:21971926;i:38;i:21971927;i:39;i:21971928;i:40;i:21971929;i:41;i:21971930;i:42;i:21983072;i:43;i:21983073;i:44;i:21983074;i:45;i:21983075;i:46;i:21983076;i:47;i:21983077;i:48;i:21983078;i:49;i:21983079;i:50;i:21983080;i:51;i:21983081;i:52;i:21983082;i:53;i:21983083;i:54;i:21983084;i:55;i:21983085;i:56;i:21983086;i:57;i:21983087;i:58;i:21983088;i:59;i:21983089;i:60;i:21983090;i:61;i:21983091;i:62;i:21983092;i:63;i:22037111;i:64;i:22037112;i:65;i:22037113;i:66;i:22037114;i:67;i:22037115;i:68;i:22037116;i:69;i:22037117;i:70;i:22037118;i:71;i:22037119;i:72;i:22037120;i:73;i:22037121;i:74;i:22037122;i:75;i:22037123;i:76;i:22037124;i:77;i:22037125;i:78;i:22037126;i:79;i:22037127;i:80;i:22037128;i:81;i:22037129;i:82;i:22037130;i:83;i:22037131;i:84;i:22057437;i:85;i:22057438;i:86;i:22057439;i:87;i:22057440;i:88;i:22057441;i:89;i:22057442;i:90;i:22057443;i:91;i:22057444;i:92;i:22057445;i:93;i:22057446;i:94;i:22057447;i:95;i:22057448;i:96;i:22057449;i:97;i:22057450;i:98;i:22057451;i:99;i:22057452;i:100;i:22057453;i:101;i:22057454;i:102;i:22057455;i:103;i:22057456;i:104;i:22057457;i:105;i:22128227;i:106;i:22128228;i:107;i:22128229;i:108;i:22128230;i:109;i:22128231;i:110;i:22128232;i:111;i:22128233;i:112;i:22128234;i:113;i:22128235;i:114;i:22128236;i:115;i:22128237;i:116;i:22128238;i:117;i:22128239;i:118;i:22128240;i:119;i:22128241;i:120;i:22128242;i:121;i:22128243;i:122;i:22128244;i:123;i:22128245;i:124;i:22128246;i:125;i:22128247;i:126;i:22468612;i:127;i:22468613;i:128;i:22468614;i:129;i:22468615;i:130;i:22468616;i:131;i:22468617;i:132;i:22468618;i:133;i:22468619;i:134;i:22468620;i:135;i:22468621;i:136;i:22468622;i:137;i:22468623;i:138;i:22468624;i:139;i:22468625;i:140;i:22468626;i:141;i:22468627;i:142;i:22468628;i:143;i:22468629;i:144;i:22468630;i:145;i:22468631;i:146;i:22468632;}
)
[rets_open_house_count] => Array
(
[0] => 1
)
[rets_active_open_house_count] => Array
(
[0] => 0
)
[rets_price_change_timestamp] => Array
(
[0] => 2022-04-18T09:11:26.910
)
[rets_active_continue_to_show_date] => Array
(
[0] => 2022-04-29
)
[rets_close_date] => Array
(
[0] => 2022-06-17
)
[rets_close_price] => Array
(
[0] => 1400000.00
)
[rets_co_selling_agent_direct_work_pho] => Array
(
[0] => (800) 370-3848
)
[rets_co_selling_agent_email] => Array
(
[0] => julia@hawaiilife.com
)
[rets_co_selling_agent_full_name] => Array
(
[0] => Julia Napua Fetzer
)
[rets_co_selling_agent_mlsid] => Array
(
[0] => 26358
)
[rets_co_selling_agent_mui] => Array
(
[0] => 3476047
)
[rets_co_selling_office_mlsid] => Array
(
[0] => HLRE
)
[rets_co_selling_office_mui] => Array
(
[0] => 3487136
)
[rets_co_selling_office_name] => Array
(
[0] => Hawaii Life
)
[rets_co_selling_office_phone] => Array
(
[0] => (800) 370-3848
)
[rets_concessions] => Array
(
[0] => 3783
)
[rets_expiration_date] => Array
(
[0] => 2022-08-31
)
[rets_off_market_date] => Array
(
[0] => 2022-06-17
)
[rets_selling_agent_direct_work_phone] => Array
(
[0] => (800) 370-3848
)
[rets_selling_agent_email] => Array
(
[0] => kylebernhardt@hawaiilife.com
)
[rets_selling_agent_full_name] => Array
(
[0] => Kyle Bernhardt
)
[rets_selling_agent_mlsid] => Array
(
[0] => 46408
)
[rets_selling_agent_mui] => Array
(
[0] => 10235678
)
[rets_selling_agent_remarks] => Array
(
[0] => Mahalo Kyle and Julia, it was a pleasure doing this transaction with you both! And for all your help Kyle.
)
[rets_selling_office_mlsid] => Array
(
[0] => HLRE
)
[rets_selling_office_mui] => Array
(
[0] => 3487136
)
[rets_selling_office_name] => Array
(
[0] => Hawaii Life
)
[rets_selling_office_phone] => Array
(
[0] => (800) 370-3848
)
[_thumbnail_id] => Array
(
[0] => 22468612
)
)
CONTACT US
#RB-7120
info@marcushawaii.com
(808)839-7446