Nestled in GREEN, TROPICAL Ko’olau mountains, this BEAUTIFUL 3bed/2ba FAMILY home has UNSURPASSED VIEWS of MAGESTIC MOUNTAINS and WATERFALLS! Come home to SIZEABLE LAND surrounded by EXOTIC plants, FRUIT and FLOWER TREES. Relax on your LARGE PATIO and enjoy the sounds of chipping birds and tranquil stream! This breezy home has a LARGE DETACHED shed to create a home office or kids’ play area AND a separate tool shed. This extremely private home is MOVE IN READY w/renovated kitchen, baths, laminate floors, NEW paint, PEST treatment, & split AC. Escape urban life today!
CONTACT US
#RB-7120
info@marcushawaii.com
(808)839-7446
array(157) {
["assd_val_imprv"]=>
array(1) {
[0]=>
string(9) "342400.00"
}
["assd_val_land"]=>
array(1) {
[0]=>
string(9) "561900.00"
}
["assd_val_total"]=>
array(1) {
[0]=>
string(9) "904300.00"
}
["bedrooms"]=>
array(1) {
[0]=>
string(1) "3"
}
["building_style"]=>
array(1) {
[0]=>
string(20) "Detach Single Family"
}
["city"]=>
array(1) {
[0]=>
string(7) "Kaneohe"
}
["county"]=>
array(1) {
[0]=>
string(4) "Oahu"
}
["disclosures"]=>
array(1) {
[0]=>
string(4) "None"
}
["easements"]=>
array(1) {
[0]=>
string(8) "Driveway"
}
["elementary_school"]=>
array(1) {
[0]=>
string(8) "Ahuimanu"
}
["floor_covering"]=>
array(1) {
[0]=>
string(21) "Ceramic Tile,Laminate"
}
["frontage"]=>
array(1) {
[0]=>
string(5) "Other"
}
["full_baths"]=>
array(1) {
[0]=>
string(1) "2"
}
["furnished"]=>
array(1) {
[0]=>
string(7) "Partial"
}
["half_baths"]=>
array(1) {
[0]=>
string(1) "0"
}
["high_school"]=>
array(1) {
[0]=>
string(6) "Castle"
}
["home_exampt"]=>
array(1) {
[0]=>
string(7) "100,000"
}
["land_area_sf"]=>
array(1) {
[0]=>
string(8) "12566.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(24) "DianneB@BetterHawaii.com"
}
["list_agent_name"]=>
array(1) {
[0]=>
string(17) "Dianne S Bosworth"
}
["list_agent_phone_number"]=>
array(1) {
[0]=>
string(14) "(808) 738-3600"
}
["list_date"]=>
array(1) {
[0]=>
string(10) "2021-07-16"
}
["list_office_name"]=>
array(1) {
[0]=>
string(22) "BHGRE Advantage Realty"
}
["list_price"]=>
array(1) {
[0]=>
string(10) "1050000.00"
}
["living_sf"]=>
array(1) {
[0]=>
string(4) "1785"
}
["location"]=>
array(1) {
[0]=>
string(40) "47-544B Melekula Road, Kaneohe, HI 96744"
}
["middle_school"]=>
array(1) {
[0]=>
string(4) "King"
}
["mls_"]=>
array(1) {
[0]=>
string(9) "202118524"
}
["neighborhood"]=>
array(1) {
[0]=>
string(13) "AHUIMANU AREA"
}
["number_of_parking_spaces"]=>
array(1) {
[0]=>
string(1) "4"
}
["number_of_stories"]=>
array(1) {
[0]=>
string(3) "One"
}
["office_mls_id"]=>
array(1) {
[0]=>
string(4) "ADVG"
}
["parking_features"]=>
array(1) {
[0]=>
string(14) "3 Car+,Carport"
}
["pool_"]=>
array(1) {
[0]=>
string(4) "None"
}
["possession"]=>
array(1) {
[0]=>
string(26) "45 Days or Less,At Closing"
}
["postal_code"]=>
array(1) {
[0]=>
string(5) "96744"
}
["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_active_open_house_count"]=>
array(1) {
[0]=>
string(1) "0"
}
["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) "3"
}
["rets_city"]=>
array(1) {
[0]=>
string(7) "Kaneohe"
}
["rets_condo_property_regime_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_current_price"]=>
array(1) {
[0]=>
string(10) "1100000.00"
}
["rets_dom"]=>
array(1) {
[0]=>
string(2) "10"
}
["rets_dual_variable_compensation_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_elementary_school"]=>
array(1) {
[0]=>
string(8) "Ahuimanu"
}
["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(6) "Castle"
}
["rets_id"]=>
array(1) {
[0]=>
string(8) "16040986"
}
["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) 738-3600"
}
["rets_list_agent_email"]=>
array(1) {
[0]=>
string(24) "DianneB@BetterHawaii.com"
}
["rets_list_agent_full_name"]=>
array(1) {
[0]=>
string(17) "Dianne S Bosworth"
}
["rets_list_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "30969"
}
["rets_list_agent_mui"]=>
array(1) {
[0]=>
string(7) "3478761"
}
["rets_list_office_mlsid"]=>
array(1) {
[0]=>
string(4) "ADVG"
}
["rets_list_office_mui"]=>
array(1) {
[0]=>
string(7) "9695164"
}
["rets_list_office_name"]=>
array(1) {
[0]=>
string(22) "BHGRE Advantage Realty"
}
["rets_list_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 738-3600"
}
["rets_list_price"]=>
array(1) {
[0]=>
string(10) "1050000.00"
}
["rets_listing_contract_date"]=>
array(1) {
[0]=>
string(10) "2021-07-16"
}
["rets_lot_size_area"]=>
array(1) {
[0]=>
string(8) "12566.00"
}
["rets_matrix_modified_dt"]=>
array(1) {
[0]=>
string(23) "2021-09-09T08:41:11.890"
}
["rets_matrix_unique_id"]=>
array(1) {
[0]=>
string(8) "16040986"
}
["rets_middle_or_junior_school"]=>
array(1) {
[0]=>
string(4) "King"
}
["rets_mls_number"]=>
array(1) {
[0]=>
string(9) "202118524"
}
["rets_neighbourhood"]=>
array(1) {
[0]=>
string(13) "AHUIMANU AREA"
}
["rets_new_development_construction_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_open_house_count"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_open_house_upcoming"]=>
array(1) {
[0]=>
string(0) ""
}
["rets_original_entry_timestamp"]=>
array(1) {
[0]=>
string(23) "2021-07-16T09:27:05.447"
}
["rets_original_list_price"]=>
array(1) {
[0]=>
string(10) "1050000.00"
}
["rets_parcel_number"]=>
array(1) {
[0]=>
string(18) "1-4-7-046-090-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) "2021-07-16T16:13:56.350"
}
["rets_postal_code"]=>
array(1) {
[0]=>
string(5) "96744"
}
["rets_price_change_timestamp"]=>
array(1) {
[0]=>
string(23) "2021-07-16T09:27:05.447"
}
["rets_primary_key"]=>
array(1) {
[0]=>
string(8) "16040986"
}
["rets_private_remarks"]=>
array(1) {
[0]=>
string(225) "Tenant leaving early Aug. First Showing at Open House Sunday 2-5pm - Contact Dianne for showings and information 808-371-0516. Preference Jeff Lee/Title Guaranty Kahala. Please include BHGRE documents in supplemental section."
}
["rets_public_remarks"]=>
array(1) {
[0]=>
string(579) "Nestled in GREEN, TROPICAL Ko’olau mountains, this BEAUTIFUL 3bed/2ba FAMILY home has UNSURPASSED VIEWS of MAGESTIC MOUNTAINS and WATERFALLS! Come home to SIZEABLE LAND surrounded by EXOTIC plants, FRUIT and FLOWER TREES. Relax on your LARGE PATIO and enjoy the sounds of chipping birds and tranquil stream! This breezy home has a LARGE DETACHED shed to create a home office or kids’ play area AND a separate tool shed. This extremely private home is MOVE IN READY w/renovated kitchen, baths, laminate floors, NEW paint, PEST treatment, & split AC. Escape urban life today!"
}
["rets_sqft_garage_carport"]=>
array(1) {
[0]=>
string(3) "360"
}
["rets_sqft_roofed_living"]=>
array(1) {
[0]=>
string(4) "1785"
}
["rets_sqft_total"]=>
array(1) {
[0]=>
string(4) "1785"
}
["rets_state_or_province"]=>
array(1) {
[0]=>
string(2) "HI"
}
["rets_status_change_timestamp"]=>
array(1) {
[0]=>
string(23) "2021-09-09T08:41:11.890"
}
["rets_status_contractual_search_date"]=>
array(1) {
[0]=>
string(10) "2021-09-08"
}
["rets_street_name"]=>
array(1) {
[0]=>
string(8) "Melekula"
}
["rets_street_number"]=>
array(1) {
[0]=>
string(7) "47-544B"
}
["rets_street_view_param"]=>
array(1) {
[0]=>
string(64) "1$21.438959$-157.844785$295.09$13.33$1.00$ZNwUEkZOpKeirR4-pWg8AA"
}
["rets_sub_agency_compensation"]=>
array(1) {
[0]=>
string(3) "2.5"
}
["rets_supplement_count"]=>
array(1) {
[0]=>
string(1) "5"
}
["rets_supplement_modification_timestam"]=>
array(1) {
[0]=>
string(23) "2021-07-19T16:02:14.647"
}
["rets_tax_amount"]=>
array(1) {
[0]=>
string(6) "196.96"
}
["rets_tax_assessed_value"]=>
array(1) {
[0]=>
string(9) "904300.00"
}
["rets_tax_assessed_value_improvements"]=>
array(1) {
[0]=>
string(9) "342400.00"
}
["rets_tax_assessed_value_land"]=>
array(1) {
[0]=>
string(9) "561900.00"
}
["rets_tax_excemption_owner_occupancy"]=>
array(1) {
[0]=>
string(7) "100,000"
}
["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/16040986/dc8b224b7a8f774a626477adca21abc8"
}
["rets_tmk_area"]=>
array(1) {
[0]=>
string(3) "147"
}
["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) "90"
}
["rets_tmk_section"]=>
array(1) {
[0]=>
string(1) "7"
}
["rets_tmk_zone"]=>
array(1) {
[0]=>
string(1) "4"
}
["rets_tmkplat"]=>
array(1) {
[0]=>
string(2) "46"
}
["rets_unit_number"]=>
array(1) {
[0]=>
string(0) ""
}
["rets_virtual_tour_url_unbranded"]=>
array(1) {
[0]=>
string(51) "https://my.matterport.com/show/?m=wvHLK6rpPj7&mls=1"
}
["rets_year_built"]=>
array(1) {
[0]=>
string(4) "1985"
}
["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(8) "Melekula"
}
["street_number"]=>
array(1) {
[0]=>
string(7) "47-544B"
}
["street_suffix"]=>
array(1) {
[0]=>
string(4) "Road"
}
["terms_accept"]=>
array(1) {
[0]=>
string(20) "Cash,Conventional,VA"
}
["tmk"]=>
array(1) {
[0]=>
string(18) "1-4-7-046-090-0000"
}
["topography"]=>
array(1) {
[0]=>
string(5) "Clear"
}
["view"]=>
array(1) {
[0]=>
string(8) "Mountain"
}
["virtual_tour"]=>
array(1) {
[0]=>
string(51) "https://my.matterport.com/show/?m=wvHLK6rpPj7&mls=1"
}
["wpp::rets_pk"]=>
array(1) {
[0]=>
string(8) "16040986"
}
["wpp_gpid"]=>
array(1) {
[0]=>
string(9) "202118524"
}
["wpp_import_schedule_id"]=>
array(1) {
[0]=>
string(10) "1463343682"
}
["wpp_import_time"]=>
array(1) {
[0]=>
string(10) "1631212931"
}
["year_built"]=>
array(1) {
[0]=>
string(4) "1985"
}
["zoning"]=>
array(1) {
[0]=>
string(31) "03 - R10 - Residential District"
}
["new_attached_media"]=>
array(1) {
[0]=>
string(1341) "a:84:{i:0;i:19977949;i:1;i:19977950;i:2;i:19977951;i:3;i:19977952;i:4;i:19977953;i:5;i:19977954;i:6;i:19977955;i:7;i:19977956;i:8;i:19977957;i:9;i:19977958;i:10;i:19977959;i:11;i:19977960;i:12;i:19977961;i:13;i:19977962;i:14;i:19977963;i:15;i:19977964;i:16;i:19977965;i:17;i:19977966;i:18;i:19977967;i:19;i:19977968;i:20;i:19977969;i:21;i:20187546;i:22;i:20187547;i:23;i:20187548;i:24;i:20187549;i:25;i:20187550;i:26;i:20187551;i:27;i:20187552;i:28;i:20187553;i:29;i:20187554;i:30;i:20187555;i:31;i:20187556;i:32;i:20187557;i:33;i:20187558;i:34;i:20187559;i:35;i:20187560;i:36;i:20187561;i:37;i:20187562;i:38;i:20187563;i:39;i:20187564;i:40;i:20187565;i:41;i:20187566;i:42;i:20228975;i:43;i:20228976;i:44;i:20228977;i:45;i:20228978;i:46;i:20228979;i:47;i:20228980;i:48;i:20228981;i:49;i:20228982;i:50;i:20228983;i:51;i:20228984;i:52;i:20228985;i:53;i:20228986;i:54;i:20228987;i:55;i:20228988;i:56;i:20228989;i:57;i:20228990;i:58;i:20228991;i:59;i:20228992;i:60;i:20228993;i:61;i:20228994;i:62;i:20228995;i:63;i:20706996;i:64;i:20706997;i:65;i:20706998;i:66;i:20706999;i:67;i:20707000;i:68;i:20707001;i:69;i:20707002;i:70;i:20707003;i:71;i:20707004;i:72;i:20707005;i:73;i:20707006;i:74;i:20707007;i:75;i:20707008;i:76;i:20707009;i:77;i:20707010;i:78;i:20707011;i:79;i:20707012;i:80;i:20707013;i:81;i:20707014;i:82;i:20707015;i:83;i:20707016;}"
}
["rets_active_continue_to_show_date"]=>
array(1) {
[0]=>
string(10) "2021-07-24"
}
["rets_pending_date"]=>
array(1) {
[0]=>
string(10) "2021-07-24"
}
["rets_close_date"]=>
array(1) {
[0]=>
string(10) "2021-09-08"
}
["rets_close_price"]=>
array(1) {
[0]=>
string(10) "1100000.00"
}
["rets_expiration_date"]=>
array(1) {
[0]=>
string(10) "2022-07-11"
}
["rets_off_market_date"]=>
array(1) {
[0]=>
string(10) "2021-09-08"
}
["rets_selling_agent_direct_work_phone"]=>
array(1) {
[0]=>
string(14) "(808) 735-4200"
}
["rets_selling_agent_email"]=>
array(1) {
[0]=>
string(34) "anina.quaranto@locationshawaii.com"
}
["rets_selling_agent_full_name"]=>
array(1) {
[0]=>
string(16) "Anina M Quaranto"
}
["rets_selling_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "43950"
}
["rets_selling_agent_mui"]=>
array(1) {
[0]=>
string(7) "8806810"
}
["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) "20706996"
}
}