Listing
Overview

Price: $975,000
Area: WAIHEE
Status: Sold

A gorgeous private country setting with sweeping mountain views of the Koolaus and a running stream along the back boundary of the property. This 2.87 acres of AG (agricultural) land is located towards the end of Waihee Road, tucked away in the back of a residential neighborhood providing easy access to utilities and a quiet setting for your own private oasis, with a mostly level lot and some mature growth trees.

  • Land Area (sf): 125,017

  • View: Mountain
  • Listing Office: List Sotheby's Int'l Realty

  • Land Tenure: FS - Fee Simple

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

CONTACT US

Marcus Realty

#RB-7120
info@marcushawaii.com
(808)839-7446

array(123) {
  ["assd_val_imprv"]=>
  array(1) {
    [0]=>
    string(4) "0.00"
  }
  ["assd_val_land"]=>
  array(1) {
    [0]=>
    string(9) "709800.00"
  }
  ["assd_val_total"]=>
  array(1) {
    [0]=>
    string(9) "709800.00"
  }
  ["city"]=>
  array(1) {
    [0]=>
    string(7) "Kaneohe"
  }
  ["county"]=>
  array(1) {
    [0]=>
    string(4) "Oahu"
  }
  ["disclosures"]=>
  array(1) {
    [0]=>
    string(24) "Property Disclosure Stmt"
  }
  ["easements"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["elementary_school"]=>
  array(1) {
    [0]=>
    string(7) "Kahaluu"
  }
  ["high_school"]=>
  array(1) {
    [0]=>
    string(6) "Castle"
  }
  ["land_area_sf"]=>
  array(1) {
    [0]=>
    string(9) "125017.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(19) "scott@hiestates.com"
  }
  ["list_agent_name"]=>
  array(1) {
    [0]=>
    string(17) "Scott K Startsman"
  }
  ["list_agent_phone_number"]=>
  array(1) {
    [0]=>
    string(14) "(808) 735-2411"
  }
  ["list_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-06-25"
  }
  ["list_office_name"]=>
  array(1) {
    [0]=>
    string(27) "List Sotheby's Int'l Realty"
  }
  ["list_price"]=>
  array(1) {
    [0]=>
    string(9) "975000.00"
  }
  ["middle_school"]=>
  array(1) {
    [0]=>
    string(4) "King"
  }
  ["mls_"]=>
  array(1) {
    [0]=>
    string(9) "202116436"
  }
  ["neighborhood"]=>
  array(1) {
    [0]=>
    string(6) "WAIHEE"
  }
  ["office_mls_id"]=>
  array(1) {
    [0]=>
    string(4) "LIST"
  }
  ["postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96744"
  }
  ["property_type"]=>
  array(1) {
    [0]=>
    string(16) "lots_acres_farms"
  }
  ["property_type_label"]=>
  array(1) {
    [0]=>
    string(16) "Lots Acres Farms"
  }
  ["region"]=>
  array(1) {
    [0]=>
    string(7) "Kaneohe"
  }
  ["rets_additional_parcels_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_city"]=>
  array(1) {
    [0]=>
    string(7) "Kaneohe"
  }
  ["rets_current_price"]=>
  array(1) {
    [0]=>
    string(9) "900000.00"
  }
  ["rets_dom"]=>
  array(1) {
    [0]=>
    string(2) "42"
  }
  ["rets_dual_variable_compensation_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_elementary_school"]=>
  array(1) {
    [0]=>
    string(7) "Kahaluu"
  }
  ["rets_foreclosure_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_high_school"]=>
  array(1) {
    [0]=>
    string(6) "Castle"
  }
  ["rets_id"]=>
  array(1) {
    [0]=>
    string(8) "16003446"
  }
  ["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) 735-2411"
  }
  ["rets_list_agent_email"]=>
  array(1) {
    [0]=>
    string(19) "scott@hiestates.com"
  }
  ["rets_list_agent_full_name"]=>
  array(1) {
    [0]=>
    string(17) "Scott K Startsman"
  }
  ["rets_list_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "28540"
  }
  ["rets_list_agent_mui"]=>
  array(1) {
    [0]=>
    string(7) "3477701"
  }
  ["rets_list_office_mlsid"]=>
  array(1) {
    [0]=>
    string(4) "LIST"
  }
  ["rets_list_office_mui"]=>
  array(1) {
    [0]=>
    string(7) "9066313"
  }
  ["rets_list_office_name"]=>
  array(1) {
    [0]=>
    string(27) "List Sotheby's Int'l Realty"
  }
  ["rets_list_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 735-2411"
  }
  ["rets_list_price"]=>
  array(1) {
    [0]=>
    string(9) "975000.00"
  }
  ["rets_listing_contract_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-06-25"
  }
  ["rets_lot_size_area"]=>
  array(1) {
    [0]=>
    string(9) "125017.00"
  }
  ["rets_matrix_modified_dt"]=>
  array(1) {
    [0]=>
    string(23) "2021-11-17T11:02:32.513"
  }
  ["rets_matrix_unique_id"]=>
  array(1) {
    [0]=>
    string(8) "16003446"
  }
  ["rets_middle_or_junior_school"]=>
  array(1) {
    [0]=>
    string(4) "King"
  }
  ["rets_mls_number"]=>
  array(1) {
    [0]=>
    string(9) "202116436"
  }
  ["rets_neighbourhood"]=>
  array(1) {
    [0]=>
    string(6) "WAIHEE"
  }
  ["rets_original_entry_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-06-28T08:37:20.493"
  }
  ["rets_original_list_price"]=>
  array(1) {
    [0]=>
    string(9) "975000.00"
  }
  ["rets_parcel_number"]=>
  array(1) {
    [0]=>
    string(18) "1-4-7-064-014-0000"
  }
  ["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) "15"
  }
  ["rets_photo_modification_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-06-28T09:01:10.600"
  }
  ["rets_postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96744"
  }
  ["rets_price_change_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-06-28T08:37:20.493"
  }
  ["rets_primary_key"]=>
  array(1) {
    [0]=>
    string(8) "16003446"
  }
  ["rets_private_remarks"]=>
  array(1) {
    [0]=>
    string(181) "Set up showing requests through ShowingTime. Call, text, email Scott at 291-5441 or scott@hiestates.com with questions and information. Do not go on the property without permission."
  }
  ["rets_public_remarks"]=>
  array(1) {
    [0]=>
    string(416) "A gorgeous private country setting with sweeping mountain views of the Koolaus and a running stream along the back boundary of the property. This 2.87 acres of AG (agricultural) land is located towards the end of Waihee Road, tucked away in the back of a residential neighborhood providing easy access to utilities and a quiet setting for your own private oasis, with a mostly level lot and some mature growth trees."
  }
  ["rets_state_or_province"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["rets_status_change_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-11-17T11:02:32.513"
  }
  ["rets_status_contractual_search_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-11-17"
  }
  ["rets_street_name"]=>
  array(1) {
    [0]=>
    string(6) "Waihee"
  }
  ["rets_street_number"]=>
  array(1) {
    [0]=>
    string(6) "Lot 62"
  }
  ["rets_street_view_param"]=>
  array(1) {
    [0]=>
    string(64) "1$21.457673$-157.846065$255.92$13.33$1.00$YUt53bCnDQ2WsfvxGcgE5Q"
  }
  ["rets_sub_agency_compensation"]=>
  array(1) {
    [0]=>
    string(2) "3%"
  }
  ["rets_tax_amount"]=>
  array(1) {
    [0]=>
    string(6) "337.00"
  }
  ["rets_tax_assessed_value"]=>
  array(1) {
    [0]=>
    string(9) "709800.00"
  }
  ["rets_tax_assessed_value_improvements"]=>
  array(1) {
    [0]=>
    string(4) "0.00"
  }
  ["rets_tax_assessed_value_land"]=>
  array(1) {
    [0]=>
    string(9) "709800.00"
  }
  ["rets_tax_paid_by_seller_yn"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_tax_year"]=>
  array(1) {
    [0]=>
    string(4) "2020"
  }
  ["rets_thumbnail_url"]=>
  array(1) {
    [0]=>
    string(81) "https://cdn.rets.ci/marcusrealty-images/16003446/471b1c5f7f352cac9844546122c5b748"
  }
  ["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) "14"
  }
  ["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) "64"
  }
  ["rets_virtual_tour_url_unbranded"]=>
  array(1) {
    [0]=>
    string(66) "https://tours.1viewmedia.com/public/vtour/display/1708718?idx=1#!/"
  }
  ["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_address"]=>
  array(1) {
    [0]=>
    string(37) "Lot 62 Waihee Road, Kaneohe, HI 96744"
  }
  ["street_name"]=>
  array(1) {
    [0]=>
    string(6) "Waihee"
  }
  ["street_number"]=>
  array(1) {
    [0]=>
    string(6) "Lot 62"
  }
  ["street_suffix"]=>
  array(1) {
    [0]=>
    string(4) "Road"
  }
  ["terms_accept"]=>
  array(1) {
    [0]=>
    string(17) "Cash,Conventional"
  }
  ["tmk"]=>
  array(1) {
    [0]=>
    string(18) "1-4-7-064-014-0000"
  }
  ["topography"]=>
  array(1) {
    [0]=>
    string(22) "Clear,Irregular,Wooded"
  }
  ["view"]=>
  array(1) {
    [0]=>
    string(8) "Mountain"
  }
  ["virtual_tour"]=>
  array(1) {
    [0]=>
    string(66) "https://tours.1viewmedia.com/public/vtour/display/1708718?idx=1#!/"
  }
  ["wpp::rets_pk"]=>
  array(1) {
    [0]=>
    string(8) "16003446"
  }
  ["wpp_gpid"]=>
  array(1) {
    [0]=>
    string(9) "202116436"
  }
  ["wpp_import_schedule_id"]=>
  array(1) {
    [0]=>
    string(10) "1463079227"
  }
  ["wpp_import_time"]=>
  array(1) {
    [0]=>
    string(10) "1637183028"
  }
  ["zoning"]=>
  array(1) {
    [0]=>
    string(30) "52 - AG-2 General Agricultural"
  }
  ["new_attached_media"]=>
  array(1) {
    [0]=>
    string(1197) "a:75:{i:0;i:19926018;i:1;i:19926019;i:2;i:19926020;i:3;i:19926021;i:4;i:19926022;i:5;i:19926023;i:6;i:19926024;i:7;i:19926025;i:8;i:19926026;i:9;i:19926027;i:10;i:19926028;i:11;i:19926029;i:12;i:19926030;i:13;i:19926031;i:14;i:19926032;i:15;i:20215268;i:16;i:20215269;i:17;i:20215270;i:18;i:20215271;i:19;i:20215272;i:20;i:20215273;i:21;i:20215274;i:22;i:20215275;i:23;i:20215276;i:24;i:20215277;i:25;i:20215278;i:26;i:20215279;i:27;i:20215280;i:28;i:20215281;i:29;i:20215282;i:30;i:20539973;i:31;i:20539974;i:32;i:20539975;i:33;i:20539976;i:34;i:20539977;i:35;i:20539978;i:36;i:20539979;i:37;i:20539980;i:38;i:20539981;i:39;i:20539982;i:40;i:20539983;i:41;i:20539984;i:42;i:20539985;i:43;i:20539986;i:44;i:20539987;i:45;i:20808427;i:46;i:20808428;i:47;i:20808429;i:48;i:20808430;i:49;i:20808431;i:50;i:20808432;i:51;i:20808433;i:52;i:20808434;i:53;i:20808435;i:54;i:20808436;i:55;i:20808437;i:56;i:20808438;i:57;i:20808439;i:58;i:20808440;i:59;i:20808441;i:60;i:21176886;i:61;i:21176887;i:62;i:21176888;i:63;i:21176889;i:64;i:21176890;i:65;i:21176891;i:66;i:21176892;i:67;i:21176893;i:68;i:21176894;i:69;i:21176895;i:70;i:21176896;i:71;i:21176897;i:72;i:21176898;i:73;i:21176899;i:74;i:21176900;}"
  }
  ["rets_active_continue_to_show_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-08-14"
  }
  ["rets_expiration_date"]=>
  array(1) {
    [0]=>
    string(10) "2022-06-30"
  }
  ["rets_close_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-11-17"
  }
  ["rets_close_price"]=>
  array(1) {
    [0]=>
    string(9) "900000.00"
  }
  ["rets_off_market_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-11-17"
  }
  ["rets_selling_agent_direct_work_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 596-8801"
  }
  ["rets_selling_agent_email"]=>
  array(1) {
    [0]=>
    string(22) "tomoko@sachihawaii.com"
  }
  ["rets_selling_agent_full_name"]=>
  array(1) {
    [0]=>
    string(15) "Tomoko Yamamoto"
  }
  ["rets_selling_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "25082"
  }
  ["rets_selling_agent_mui"]=>
  array(1) {
    [0]=>
    string(7) "3475175"
  }
  ["rets_selling_office_mlsid"]=>
  array(1) {
    [0]=>
    string(4) "SACH"
  }
  ["rets_selling_office_mui"]=>
  array(1) {
    [0]=>
    string(7) "3486539"
  }
  ["rets_selling_office_name"]=>
  array(1) {
    [0]=>
    string(30) "Sachi HI Pacific Century Prop."
  }
  ["rets_selling_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 596-8801"
  }
  ["rets_tax_annual_amount"]=>
  array(1) {
    [0]=>
    string(7) "4044.00"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "21176886"
  }
}