47-544B Melekula Road
Kaneohe, HI 96744

Take a Virtual Tour

Listing
Overview

Price: $1,050,000
Area: AHUIMANU AREA
Status: Sold

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!

  • Bedrooms: 3
  • Full Baths: 2
  • Land Area (sf): 12,566
  • Living (sf): 1,785
  • Year Built: 1985

  • Property Condition: Above Average,Excellent
  • Number of Parking Spaces: 4
  • Pool: None
  • Number of Stories: One
  • View: Mountain
  • Listing Office: BHGRE Advantage Realty

  • Land Tenure: FS - Fee Simple

  • Elementary School: Ahuimanu
  • Middle School: King
  • High School: Castle

CONTACT US

Marcus Realty

#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"
  }
}