48-564 Waiahole Valley N Branch Road
Kaneohe, HI 96744

Listing
Overview

Price: $2,100,000
Area: WAIAHOLE
Status: Sold

Back to Eden…rare estate property in Waiahole Valley! You’ll be instantly transported the moment you step foot here. Immerse yourself and surrender to its breathtaking views. Over 2 acres of largely flat property with lots of open space, surrounded by mature fruit trees and native Hawaiian plants. Formerly used as a golf course, trout farm and nursery. Let your farming dreams run wild…or just simply run wild! Go on a hike and stream walk in your own backyard. Gaze at the stars from the wrap-around deck overlooking the tranquil koi pond. Fall asleep to the sounds of the forest, stream and waterfalls. Don’t miss your opportunity on this truly special place. Turn off the highway at Waiahole Poi Factory and let this country road take you HOME!
*** (Main dwelling = 1700 sq ft of living space / 3 bedrooms / 3 baths | 2nd dwelling (detached cottage / approx. 1500+ additional sq ft of living space) = 2+ bedrooms / 3 half baths | Sale also includes vacant AG lot = TMK 1-4-8-012-015).

array(152) {
  ["assd_val_imprv"]=>
  array(1) {
    [0]=>
    string(9) "258500.00"
  }
  ["assd_val_land"]=>
  array(1) {
    [0]=>
    string(9) "952600.00"
  }
  ["assd_val_total"]=>
  array(1) {
    [0]=>
    string(10) "1211100.00"
  }
  ["bedrooms"]=>
  array(1) {
    [0]=>
    string(1) "5"
  }
  ["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(24) "Property Disclosure Stmt"
  }
  ["easements"]=>
  array(1) {
    [0]=>
    string(8) "Driveway"
  }
  ["elementary_school"]=>
  array(1) {
    [0]=>
    string(8) "Waiahole"
  }
  ["floor_covering"]=>
  array(1) {
    [0]=>
    string(23) "Hardwood,Laminate,Vinyl"
  }
  ["full_baths"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["furnished"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["half_baths"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["high_school"]=>
  array(1) {
    [0]=>
    string(6) "Castle"
  }
  ["home_exampt"]=>
  array(1) {
    [0]=>
    string(7) "$140100"
  }
  ["lanai_sf"]=>
  array(1) {
    [0]=>
    string(3) "128"
  }
  ["land_area_sf"]=>
  array(1) {
    [0]=>
    string(9) "102104.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(25) "jason.paulo@cbpacific.com"
  }
  ["list_agent_name"]=>
  array(1) {
    [0]=>
    string(11) "Jason Paulo"
  }
  ["list_agent_phone_number"]=>
  array(1) {
    [0]=>
    string(14) "(808) 261-3314"
  }
  ["list_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-06-25"
  }
  ["list_office_name"]=>
  array(1) {
    [0]=>
    string(22) "Coldwell Banker Realty"
  }
  ["list_price"]=>
  array(1) {
    [0]=>
    string(10) "2100000.00"
  }
  ["living_sf"]=>
  array(1) {
    [0]=>
    string(4) "3328"
  }
  ["location"]=>
  array(1) {
    [0]=>
    string(55) "48-564 Waiahole Valley N Branch Road, Kaneohe, HI 96744"
  }
  ["middle_school"]=>
  array(1) {
    [0]=>
    string(4) "King"
  }
  ["mls_"]=>
  array(1) {
    [0]=>
    string(9) "202115351"
  }
  ["neighborhood"]=>
  array(1) {
    [0]=>
    string(8) "WAIAHOLE"
  }
  ["number_of_parking_spaces"]=>
  array(1) {
    [0]=>
    string(1) "6"
  }
  ["number_of_stories"]=>
  array(1) {
    [0]=>
    string(3) "Two"
  }
  ["office_mls_id"]=>
  array(1) {
    [0]=>
    string(6) "CBPP04"
  }
  ["parking_features"]=>
  array(1) {
    [0]=>
    string(22) "3 Car+,Driveway,Garage"
  }
  ["pool_"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["possession"]=>
  array(1) {
    [0]=>
    string(15) "45 Days or More"
  }
  ["postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96744"
  }
  ["property_condition"]=>
  array(1) {
    [0]=>
    string(7) "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(7) "Kaneohe"
  }
  ["rets_baths_full"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["rets_baths_half"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["rets_baths_total"]=>
  array(1) {
    [0]=>
    string(4) "3.03"
  }
  ["rets_beds_total"]=>
  array(1) {
    [0]=>
    string(1) "5"
  }
  ["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) "2125000.00"
  }
  ["rets_dom"]=>
  array(1) {
    [0]=>
    string(2) "22"
  }
  ["rets_dual_variable_compensation_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_elementary_school"]=>
  array(1) {
    [0]=>
    string(8) "Waiahole"
  }
  ["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) "15974278"
  }
  ["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) 261-3314"
  }
  ["rets_list_agent_email"]=>
  array(1) {
    [0]=>
    string(25) "jason.paulo@cbpacific.com"
  }
  ["rets_list_agent_full_name"]=>
  array(1) {
    [0]=>
    string(11) "Jason Paulo"
  }
  ["rets_list_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "47750"
  }
  ["rets_list_agent_mui"]=>
  array(1) {
    [0]=>
    string(8) "12186516"
  }
  ["rets_list_office_mlsid"]=>
  array(1) {
    [0]=>
    string(6) "CBPP04"
  }
  ["rets_list_office_mui"]=>
  array(1) {
    [0]=>
    string(7) "3484714"
  }
  ["rets_list_office_name"]=>
  array(1) {
    [0]=>
    string(22) "Coldwell Banker Realty"
  }
  ["rets_list_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 261-3314"
  }
  ["rets_list_price"]=>
  array(1) {
    [0]=>
    string(10) "2100000.00"
  }
  ["rets_listing_contract_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-06-25"
  }
  ["rets_lot_size_area"]=>
  array(1) {
    [0]=>
    string(9) "102104.00"
  }
  ["rets_matrix_modified_dt"]=>
  array(1) {
    [0]=>
    string(23) "2021-11-08T10:46:51.607"
  }
  ["rets_matrix_unique_id"]=>
  array(1) {
    [0]=>
    string(8) "15974278"
  }
  ["rets_middle_or_junior_school"]=>
  array(1) {
    [0]=>
    string(4) "King"
  }
  ["rets_mls_number"]=>
  array(1) {
    [0]=>
    string(9) "202115351"
  }
  ["rets_neighbourhood"]=>
  array(1) {
    [0]=>
    string(8) "WAIAHOLE"
  }
  ["rets_new_development_construction_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_original_entry_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-06-25T08:57:20.270"
  }
  ["rets_original_list_price"]=>
  array(1) {
    [0]=>
    string(10) "2100000.00"
  }
  ["rets_parcel_number"]=>
  array(1) {
    [0]=>
    string(18) "1-4-8-012-014-0000"
  }
  ["rets_parking_total"]=>
  array(1) {
    [0]=>
    string(1) "6"
  }
  ["rets_pending_date"]=>
  array(1) {
    [0]=>
    NULL
  }
  ["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) "24"
  }
  ["rets_photo_modification_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-06-25T08:57:20.270"
  }
  ["rets_postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96744"
  }
  ["rets_price_change_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-06-25T08:57:20.270"
  }
  ["rets_primary_key"]=>
  array(1) {
    [0]=>
    string(8) "15974278"
  }
  ["rets_private_remarks"]=>
  array(1) {
    [0]=>
    string(519) "No Public Opens. Private showings by appt only to qualified buyers. Do not walk on property w/out appt. Call/Text/Email Listor. No ShowingTime. Main dwelling is 1700 liv sq ft / 3 beds / 3 baths | 2nd dwelling (detached cottage - not permitted / approx. 1500+ addtl liv sq ft) = 2+ beds / 3 half baths | Sale includes vacant AG lot = TMK 1-4-8-012-015). Buyer to do own due diligence. May not match tax records. Sold As-Is. Kindly consider Vern Heath - Premier Title HI (vheath@premiertitlehawaii.com / (808) 356-8977)."
  }
  ["rets_public_remarks"]=>
  array(1) {
    [0]=>
    string(995) "Back to Eden...rare estate property in Waiahole Valley! You'll be instantly transported the moment you step foot here. Immerse yourself and surrender to its breathtaking views. Over 2 acres of largely flat property with lots of open space, surrounded by mature fruit trees and native Hawaiian plants. Formerly used as a golf course, trout farm and nursery. Let your farming dreams run wild...or just simply run wild! Go on a hike and stream walk in your own backyard. Gaze at the stars from the wrap-around deck overlooking the tranquil koi pond. Fall asleep to the sounds of the forest, stream and waterfalls. Don't miss your opportunity on this truly special place. Turn off the highway at Waiahole Poi Factory and let this country road take you HOME! 
*** (Main dwelling = 1700 sq ft of living space / 3 bedrooms / 3 baths | 2nd dwelling (detached cottage / approx. 1500+ additional sq ft of living space) = 2+ bedrooms / 3 half baths | Sale also includes vacant AG lot = TMK 1-4-8-012-015)."
  }
  ["rets_room_count"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_sqft_garage_carport"]=>
  array(1) {
    [0]=>
    string(3) "416"
  }
  ["rets_sqft_lanai_open"]=>
  array(1) {
    [0]=>
    string(3) "128"
  }
  ["rets_sqft_roofed_living"]=>
  array(1) {
    [0]=>
    string(4) "3200"
  }
  ["rets_sqft_total"]=>
  array(1) {
    [0]=>
    string(4) "3328"
  }
  ["rets_state_or_province"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["rets_status_change_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-11-08T10:46:51.607"
  }
  ["rets_status_contractual_search_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-11-08"
  }
  ["rets_street_name"]=>
  array(1) {
    [0]=>
    string(24) "Waiahole Valley N Branch"
  }
  ["rets_street_number"]=>
  array(1) {
    [0]=>
    string(6) "48-564"
  }
  ["rets_street_view_param"]=>
  array(1) {
    [0]=>
    string(64) "1$21.484015$-157.869756$160.39$13.33$1.00$aoATFfor9IO5TQO18bXWdA"
  }
  ["rets_sub_agency_compensation"]=>
  array(1) {
    [0]=>
    string(3) "2.5"
  }
  ["rets_tax_amount"]=>
  array(1) {
    [0]=>
    string(6) "432.08"
  }
  ["rets_tax_assessed_value"]=>
  array(1) {
    [0]=>
    string(10) "1211100.00"
  }
  ["rets_tax_assessed_value_improvements"]=>
  array(1) {
    [0]=>
    string(9) "258500.00"
  }
  ["rets_tax_assessed_value_land"]=>
  array(1) {
    [0]=>
    string(9) "952600.00"
  }
  ["rets_tax_excemption_owner_occupancy"]=>
  array(1) {
    [0]=>
    string(7) "$140100"
  }
  ["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/15974278/f8d5dec031e661610d99f8909a9b9fcd"
  }
  ["rets_tmk_area"]=>
  array(1) {
    [0]=>
    string(3) "148"
  }
  ["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) "8"
  }
  ["rets_tmk_zone"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["rets_tmkplat"]=>
  array(1) {
    [0]=>
    string(2) "12"
  }
  ["rets_year_built"]=>
  array(1) {
    [0]=>
    string(4) "1988"
  }
  ["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(24) "Waiahole Valley N Branch"
  }
  ["street_number"]=>
  array(1) {
    [0]=>
    string(6) "48-564"
  }
  ["street_suffix"]=>
  array(1) {
    [0]=>
    string(4) "Road"
  }
  ["terms_accept"]=>
  array(1) {
    [0]=>
    string(32) "Cash,Conventional,USDA Financing"
  }
  ["tmk"]=>
  array(1) {
    [0]=>
    string(18) "1-4-8-012-014-0000"
  }
  ["topography"]=>
  array(1) {
    [0]=>
    string(12) "Clear,Wooded"
  }
  ["view"]=>
  array(1) {
    [0]=>
    string(21) "Garden,Mountain,Other"
  }
  ["wpp::rets_pk"]=>
  array(1) {
    [0]=>
    string(8) "15974278"
  }
  ["wpp_gpid"]=>
  array(1) {
    [0]=>
    string(9) "202115351"
  }
  ["wpp_import_schedule_id"]=>
  array(1) {
    [0]=>
    string(10) "1463343682"
  }
  ["wpp_import_time"]=>
  array(1) {
    [0]=>
    string(10) "1636404421"
  }
  ["year_built"]=>
  array(1) {
    [0]=>
    string(4) "1988"
  }
  ["zoning"]=>
  array(1) {
    [0]=>
    string(30) "52 - AG-2 General Agricultural"
  }
  ["new_attached_media"]=>
  array(1) {
    [0]=>
    string(2040) "a:126:{i:0;i:19994754;i:1;i:19994755;i:2;i:19994756;i:3;i:19994757;i:4;i:19994758;i:5;i:19994759;i:6;i:19994760;i:7;i:19994761;i:8;i:19994762;i:9;i:19994763;i:10;i:19994764;i:11;i:19994765;i:12;i:19994766;i:13;i:19994767;i:14;i:19994768;i:15;i:19994769;i:16;i:19994770;i:17;i:19994771;i:18;i:19994772;i:19;i:19994773;i:20;i:19994774;i:21;i:20243475;i:22;i:20243476;i:23;i:20243477;i:24;i:20243478;i:25;i:20243479;i:26;i:20243480;i:27;i:20243481;i:28;i:20243482;i:29;i:20243483;i:30;i:20243484;i:31;i:20243485;i:32;i:20243486;i:33;i:20243487;i:34;i:20243488;i:35;i:20243489;i:36;i:20243490;i:37;i:20243491;i:38;i:20243492;i:39;i:20243493;i:40;i:20243494;i:41;i:20243495;i:42;i:20667742;i:43;i:20667743;i:44;i:20667744;i:45;i:20667745;i:46;i:20667746;i:47;i:20667747;i:48;i:20667748;i:49;i:20667749;i:50;i:20667750;i:51;i:20667751;i:52;i:20667752;i:53;i:20667753;i:54;i:20667754;i:55;i:20667755;i:56;i:20667756;i:57;i:20667757;i:58;i:20667758;i:59;i:20667759;i:60;i:20667760;i:61;i:20667761;i:62;i:20667762;i:63;i:20667844;i:64;i:20667845;i:65;i:20667846;i:66;i:20667847;i:67;i:20667848;i:68;i:20667849;i:69;i:20667850;i:70;i:20667851;i:71;i:20667852;i:72;i:20667853;i:73;i:20667854;i:74;i:20667855;i:75;i:20667856;i:76;i:20667857;i:77;i:20667858;i:78;i:20667859;i:79;i:20667860;i:80;i:20667861;i:81;i:20667862;i:82;i:20667863;i:83;i:20667864;i:84;i:20817724;i:85;i:20817725;i:86;i:20817726;i:87;i:20817727;i:88;i:20817728;i:89;i:20817729;i:90;i:20817730;i:91;i:20817731;i:92;i:20817732;i:93;i:20817733;i:94;i:20817734;i:95;i:20817735;i:96;i:20817736;i:97;i:20817737;i:98;i:20817738;i:99;i:20817739;i:100;i:20817740;i:101;i:20817741;i:102;i:20817742;i:103;i:20817743;i:104;i:20817744;i:105;i:21118316;i:106;i:21118317;i:107;i:21118318;i:108;i:21118319;i:109;i:21118320;i:110;i:21118321;i:111;i:21118322;i:112;i:21118323;i:113;i:21118324;i:114;i:21118325;i:115;i:21118326;i:116;i:21118327;i:117;i:21118328;i:118;i:21118329;i:119;i:21118330;i:120;i:21118331;i:121;i:21118332;i:122;i:21118333;i:123;i:21118334;i:124;i:21118335;i:125;i:21118336;}"
  }
  ["rets_active_continue_to_show_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-07-17"
  }
  ["rets_close_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-11-08"
  }
  ["rets_close_price"]=>
  array(1) {
    [0]=>
    string(10) "2125000.00"
  }
  ["rets_expiration_date"]=>
  array(1) {
    [0]=>
    string(10) "2022-06-25"
  }
  ["rets_off_market_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-11-08"
  }
  ["rets_selling_agent_direct_work_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 261-3314"
  }
  ["rets_selling_agent_email"]=>
  array(1) {
    [0]=>
    string(18) "leonm@cbrealty.com"
  }
  ["rets_selling_agent_full_name"]=>
  array(1) {
    [0]=>
    string(11) "Leon Mosher"
  }
  ["rets_selling_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "28512"
  }
  ["rets_selling_agent_mui"]=>
  array(1) {
    [0]=>
    string(7) "3477684"
  }
  ["rets_selling_office_mlsid"]=>
  array(1) {
    [0]=>
    string(6) "CBPP04"
  }
  ["rets_selling_office_mui"]=>
  array(1) {
    [0]=>
    string(7) "3484714"
  }
  ["rets_selling_office_name"]=>
  array(1) {
    [0]=>
    string(22) "Coldwell Banker Realty"
  }
  ["rets_selling_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 261-3314"
  }
  ["rets_tax_annual_amount"]=>
  array(1) {
    [0]=>
    string(7) "5184.96"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "21118316"
  }
}
Array
(
    [assd_val_imprv] => Array
        (
            [0] => 258500.00
        )

    [assd_val_land] => Array
        (
            [0] => 952600.00
        )

    [assd_val_total] => Array
        (
            [0] => 1211100.00
        )

    [bedrooms] => Array
        (
            [0] => 5
        )

    [building_style] => Array
        (
            [0] => Detach Single Family
        )

    [city] => Array
        (
            [0] => Kaneohe
        )

    [county] => Array
        (
            [0] => Oahu
        )

    [disclosures] => Array
        (
            [0] => Property Disclosure Stmt
        )

    [easements] => Array
        (
            [0] => Driveway
        )

    [elementary_school] => Array
        (
            [0] => Waiahole
        )

    [floor_covering] => Array
        (
            [0] => Hardwood,Laminate,Vinyl
        )

    [full_baths] => Array
        (
            [0] => 3
        )

    [furnished] => Array
        (
            [0] => None
        )

    [half_baths] => Array
        (
            [0] => 3
        )

    [high_school] => Array
        (
            [0] => Castle
        )

    [home_exampt] => Array
        (
            [0] => $140100
        )

    [lanai_sf] => Array
        (
            [0] => 128
        )

    [land_area_sf] => Array
        (
            [0] => 102104.00
        )

    [land_recorded] => Array
        (
            [0] => Regular System
        )

    [land_tenure] => Array
        (
            [0] => FS - Fee Simple
        )

    [list_agent_email] => Array
        (
            [0] => jason.paulo@cbpacific.com
        )

    [list_agent_name] => Array
        (
            [0] => Jason Paulo
        )

    [list_agent_phone_number] => Array
        (
            [0] => (808) 261-3314
        )

    [list_date] => Array
        (
            [0] => 2021-06-25
        )

    [list_office_name] => Array
        (
            [0] => Coldwell Banker Realty
        )

    [list_price] => Array
        (
            [0] => 2100000.00
        )

    [living_sf] => Array
        (
            [0] => 3328
        )

    [location] => Array
        (
            [0] => 48-564 Waiahole Valley N Branch Road, Kaneohe, HI 96744
        )

    [middle_school] => Array
        (
            [0] => King
        )

    [mls_] => Array
        (
            [0] => 202115351
        )

    [neighborhood] => Array
        (
            [0] => WAIAHOLE
        )

    [number_of_parking_spaces] => Array
        (
            [0] => 6
        )

    [number_of_stories] => Array
        (
            [0] => Two
        )

    [office_mls_id] => Array
        (
            [0] => CBPP04
        )

    [parking_features] => Array
        (
            [0] => 3 Car+,Driveway,Garage
        )

    [pool_] => Array
        (
            [0] => None
        )

    [possession] => Array
        (
            [0] => 45 Days or More
        )

    [postal_code] => Array
        (
            [0] => 96744
        )

    [property_condition] => Array
        (
            [0] => Average
        )

    [property_type] => Array
        (
            [0] => single_family
        )

    [property_type_label] => Array
        (
            [0] => single_family
        )

    [region] => Array
        (
            [0] => Kaneohe
        )

    [rets_baths_full] => Array
        (
            [0] => 3
        )

    [rets_baths_half] => Array
        (
            [0] => 3
        )

    [rets_baths_total] => Array
        (
            [0] => 3.03
        )

    [rets_beds_total] => Array
        (
            [0] => 5
        )

    [rets_city] => Array
        (
            [0] => Kaneohe
        )

    [rets_condo_property_regime_yn] => Array
        (
            [0] => 0
        )

    [rets_current_price] => Array
        (
            [0] => 2125000.00
        )

    [rets_dom] => Array
        (
            [0] => 22
        )

    [rets_dual_variable_compensation_yn] => Array
        (
            [0] => 0
        )

    [rets_elementary_school] => Array
        (
            [0] => Waiahole
        )

    [rets_foreclosure_yn] => Array
        (
            [0] => 0
        )

    [rets_fractional_ownership_yn] => Array
        (
            [0] => 0
        )

    [rets_high_school] => Array
        (
            [0] => Castle
        )

    [rets_id] => Array
        (
            [0] => 15974278
        )

    [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) 261-3314
        )

    [rets_list_agent_email] => Array
        (
            [0] => jason.paulo@cbpacific.com
        )

    [rets_list_agent_full_name] => Array
        (
            [0] => Jason Paulo
        )

    [rets_list_agent_mlsid] => Array
        (
            [0] => 47750
        )

    [rets_list_agent_mui] => Array
        (
            [0] => 12186516
        )

    [rets_list_office_mlsid] => Array
        (
            [0] => CBPP04
        )

    [rets_list_office_mui] => Array
        (
            [0] => 3484714
        )

    [rets_list_office_name] => Array
        (
            [0] => Coldwell Banker Realty
        )

    [rets_list_office_phone] => Array
        (
            [0] => (808) 261-3314
        )

    [rets_list_price] => Array
        (
            [0] => 2100000.00
        )

    [rets_listing_contract_date] => Array
        (
            [0] => 2021-06-25
        )

    [rets_lot_size_area] => Array
        (
            [0] => 102104.00
        )

    [rets_matrix_modified_dt] => Array
        (
            [0] => 2021-11-08T10:46:51.607
        )

    [rets_matrix_unique_id] => Array
        (
            [0] => 15974278
        )

    [rets_middle_or_junior_school] => Array
        (
            [0] => King
        )

    [rets_mls_number] => Array
        (
            [0] => 202115351
        )

    [rets_neighbourhood] => Array
        (
            [0] => WAIAHOLE
        )

    [rets_new_development_construction_yn] => Array
        (
            [0] => 0
        )

    [rets_original_entry_timestamp] => Array
        (
            [0] => 2021-06-25T08:57:20.270
        )

    [rets_original_list_price] => Array
        (
            [0] => 2100000.00
        )

    [rets_parcel_number] => Array
        (
            [0] => 1-4-8-012-014-0000
        )

    [rets_parking_total] => Array
        (
            [0] => 6
        )

    [rets_pending_date] => Array
        (
            [0] => 
        )

    [rets_permit_address_internet_yn] => Array
        (
            [0] => 1
        )

    [rets_permit_internet_yn] => Array
        (
            [0] => 1
        )

    [rets_photo_count] => Array
        (
            [0] => 24
        )

    [rets_photo_modification_timestamp] => Array
        (
            [0] => 2021-06-25T08:57:20.270
        )

    [rets_postal_code] => Array
        (
            [0] => 96744
        )

    [rets_price_change_timestamp] => Array
        (
            [0] => 2021-06-25T08:57:20.270
        )

    [rets_primary_key] => Array
        (
            [0] => 15974278
        )

    [rets_private_remarks] => Array
        (
            [0] => No Public Opens. Private showings by appt only to qualified buyers. Do not walk on property w/out appt. Call/Text/Email Listor. No ShowingTime. Main dwelling is 1700 liv sq ft / 3 beds / 3 baths | 2nd dwelling (detached cottage - not permitted / approx. 1500+ addtl liv sq ft) = 2+ beds / 3 half baths | Sale includes vacant AG lot = TMK 1-4-8-012-015). Buyer to do own due diligence. May not match tax records. Sold As-Is. Kindly consider Vern Heath - Premier Title HI (vheath@premiertitlehawaii.com / (808) 356-8977).
        )

    [rets_public_remarks] => Array
        (
            [0] => Back to Eden...rare estate property in Waiahole Valley! You'll be instantly transported the moment you step foot here. Immerse yourself and surrender to its breathtaking views. Over 2 acres of largely flat property with lots of open space, surrounded by mature fruit trees and native Hawaiian plants. Formerly used as a golf course, trout farm and nursery. Let your farming dreams run wild...or just simply run wild! Go on a hike and stream walk in your own backyard. Gaze at the stars from the wrap-around deck overlooking the tranquil koi pond. Fall asleep to the sounds of the forest, stream and waterfalls. Don't miss your opportunity on this truly special place. Turn off the highway at Waiahole Poi Factory and let this country road take you HOME! 
*** (Main dwelling = 1700 sq ft of living space / 3 bedrooms / 3 baths | 2nd dwelling (detached cottage / approx. 1500+ additional sq ft of living space) = 2+ bedrooms / 3 half baths | Sale also includes vacant AG lot = TMK 1-4-8-012-015).
        )

    [rets_room_count] => Array
        (
            [0] => 0
        )

    [rets_sqft_garage_carport] => Array
        (
            [0] => 416
        )

    [rets_sqft_lanai_open] => Array
        (
            [0] => 128
        )

    [rets_sqft_roofed_living] => Array
        (
            [0] => 3200
        )

    [rets_sqft_total] => Array
        (
            [0] => 3328
        )

    [rets_state_or_province] => Array
        (
            [0] => HI
        )

    [rets_status_change_timestamp] => Array
        (
            [0] => 2021-11-08T10:46:51.607
        )

    [rets_status_contractual_search_date] => Array
        (
            [0] => 2021-11-08
        )

    [rets_street_name] => Array
        (
            [0] => Waiahole Valley N Branch
        )

    [rets_street_number] => Array
        (
            [0] => 48-564
        )

    [rets_street_view_param] => Array
        (
            [0] => 1$21.484015$-157.869756$160.39$13.33$1.00$aoATFfor9IO5TQO18bXWdA
        )

    [rets_sub_agency_compensation] => Array
        (
            [0] => 2.5
        )

    [rets_tax_amount] => Array
        (
            [0] => 432.08
        )

    [rets_tax_assessed_value] => Array
        (
            [0] => 1211100.00
        )

    [rets_tax_assessed_value_improvements] => Array
        (
            [0] => 258500.00
        )

    [rets_tax_assessed_value_land] => Array
        (
            [0] => 952600.00
        )

    [rets_tax_excemption_owner_occupancy] => Array
        (
            [0] => $140100
        )

    [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/15974278/f8d5dec031e661610d99f8909a9b9fcd
        )

    [rets_tmk_area] => Array
        (
            [0] => 148
        )

    [rets_tmk_condo_property_regime_number] => Array
        (
            [0] => 0
        )

    [rets_tmk_division] => Array
        (
            [0] => 1
        )

    [rets_tmk_parcel] => Array
        (
            [0] => 14
        )

    [rets_tmk_section] => Array
        (
            [0] => 8
        )

    [rets_tmk_zone] => Array
        (
            [0] => 4
        )

    [rets_tmkplat] => Array
        (
            [0] => 12
        )

    [rets_year_built] => Array
        (
            [0] => 1988
        )

    [setbacks] => Array
        (
            [0] => Of Record
        )

    [state_or_province] => Array
        (
            [0] => HI
        )

    [status] => Array
        (
            [0] => Sold
        )

    [street_name] => Array
        (
            [0] => Waiahole Valley N Branch
        )

    [street_number] => Array
        (
            [0] => 48-564
        )

    [street_suffix] => Array
        (
            [0] => Road
        )

    [terms_accept] => Array
        (
            [0] => Cash,Conventional,USDA Financing
        )

    [tmk] => Array
        (
            [0] => 1-4-8-012-014-0000
        )

    [topography] => Array
        (
            [0] => Clear,Wooded
        )

    [view] => Array
        (
            [0] => Garden,Mountain,Other
        )

    [wpp::rets_pk] => Array
        (
            [0] => 15974278
        )

    [wpp_gpid] => Array
        (
            [0] => 202115351
        )

    [wpp_import_schedule_id] => Array
        (
            [0] => 1463343682
        )

    [wpp_import_time] => Array
        (
            [0] => 1636404421
        )

    [year_built] => Array
        (
            [0] => 1988
        )

    [zoning] => Array
        (
            [0] => 52 - AG-2 General Agricultural
        )

    [new_attached_media] => Array
        (
            [0] => a:126:{i:0;i:19994754;i:1;i:19994755;i:2;i:19994756;i:3;i:19994757;i:4;i:19994758;i:5;i:19994759;i:6;i:19994760;i:7;i:19994761;i:8;i:19994762;i:9;i:19994763;i:10;i:19994764;i:11;i:19994765;i:12;i:19994766;i:13;i:19994767;i:14;i:19994768;i:15;i:19994769;i:16;i:19994770;i:17;i:19994771;i:18;i:19994772;i:19;i:19994773;i:20;i:19994774;i:21;i:20243475;i:22;i:20243476;i:23;i:20243477;i:24;i:20243478;i:25;i:20243479;i:26;i:20243480;i:27;i:20243481;i:28;i:20243482;i:29;i:20243483;i:30;i:20243484;i:31;i:20243485;i:32;i:20243486;i:33;i:20243487;i:34;i:20243488;i:35;i:20243489;i:36;i:20243490;i:37;i:20243491;i:38;i:20243492;i:39;i:20243493;i:40;i:20243494;i:41;i:20243495;i:42;i:20667742;i:43;i:20667743;i:44;i:20667744;i:45;i:20667745;i:46;i:20667746;i:47;i:20667747;i:48;i:20667748;i:49;i:20667749;i:50;i:20667750;i:51;i:20667751;i:52;i:20667752;i:53;i:20667753;i:54;i:20667754;i:55;i:20667755;i:56;i:20667756;i:57;i:20667757;i:58;i:20667758;i:59;i:20667759;i:60;i:20667760;i:61;i:20667761;i:62;i:20667762;i:63;i:20667844;i:64;i:20667845;i:65;i:20667846;i:66;i:20667847;i:67;i:20667848;i:68;i:20667849;i:69;i:20667850;i:70;i:20667851;i:71;i:20667852;i:72;i:20667853;i:73;i:20667854;i:74;i:20667855;i:75;i:20667856;i:76;i:20667857;i:77;i:20667858;i:78;i:20667859;i:79;i:20667860;i:80;i:20667861;i:81;i:20667862;i:82;i:20667863;i:83;i:20667864;i:84;i:20817724;i:85;i:20817725;i:86;i:20817726;i:87;i:20817727;i:88;i:20817728;i:89;i:20817729;i:90;i:20817730;i:91;i:20817731;i:92;i:20817732;i:93;i:20817733;i:94;i:20817734;i:95;i:20817735;i:96;i:20817736;i:97;i:20817737;i:98;i:20817738;i:99;i:20817739;i:100;i:20817740;i:101;i:20817741;i:102;i:20817742;i:103;i:20817743;i:104;i:20817744;i:105;i:21118316;i:106;i:21118317;i:107;i:21118318;i:108;i:21118319;i:109;i:21118320;i:110;i:21118321;i:111;i:21118322;i:112;i:21118323;i:113;i:21118324;i:114;i:21118325;i:115;i:21118326;i:116;i:21118327;i:117;i:21118328;i:118;i:21118329;i:119;i:21118330;i:120;i:21118331;i:121;i:21118332;i:122;i:21118333;i:123;i:21118334;i:124;i:21118335;i:125;i:21118336;}
        )

    [rets_active_continue_to_show_date] => Array
        (
            [0] => 2021-07-17
        )

    [rets_close_date] => Array
        (
            [0] => 2021-11-08
        )

    [rets_close_price] => Array
        (
            [0] => 2125000.00
        )

    [rets_expiration_date] => Array
        (
            [0] => 2022-06-25
        )

    [rets_off_market_date] => Array
        (
            [0] => 2021-11-08
        )

    [rets_selling_agent_direct_work_phone] => Array
        (
            [0] => (808) 261-3314
        )

    [rets_selling_agent_email] => Array
        (
            [0] => leonm@cbrealty.com
        )

    [rets_selling_agent_full_name] => Array
        (
            [0] => Leon Mosher
        )

    [rets_selling_agent_mlsid] => Array
        (
            [0] => 28512
        )

    [rets_selling_agent_mui] => Array
        (
            [0] => 3477684
        )

    [rets_selling_office_mlsid] => Array
        (
            [0] => CBPP04
        )

    [rets_selling_office_mui] => Array
        (
            [0] => 3484714
        )

    [rets_selling_office_name] => Array
        (
            [0] => Coldwell Banker Realty
        )

    [rets_selling_office_phone] => Array
        (
            [0] => (808) 261-3314
        )

    [rets_tax_annual_amount] => Array
        (
            [0] => 5184.96
        )

    [_thumbnail_id] => Array
        (
            [0] => 21118316
        )

)

  • Bedrooms: 5
  • Full Baths: 3
  • Half Baths: 3
  • Land Area (sf): 102,104
  • Living (sf): 3,328
  • Year Built: 1988

  • Property Condition: Average
  • Number of Parking Spaces: 6
  • Pool: None
  • Number of Stories: Two
  • View: Garden,Mountain,Other
  • Listing Office: Coldwell Banker Realty

  • Land Tenure: FS - Fee Simple

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

CONTACT US

Marcus Realty

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