47-477 Waihee Place
Kaneohe, HI 96744

Take a Virtual Tour

Listing
Overview

Price: $12,500,000
Area: KAHALUU TOWN
Status: Active

Grand estate property for the ultimate privacy and serenity. Surrounded by the Koolau mountain range, and overlooking Kaneohe bay, Hale Waihee boasts two dwellings and all the infrastructure to create your dream. The property is equipped with its own wells to irrigate as well as provide water for the homes. The extensive drainage system and engineered driveway connect the different spaces within your sanctuary. There are tropical plants and fruit trees throughout, and abundant open space to grow your own crops. A commercial style kitchen would impress the most discerning home cooks. The seller has done much of the costly and hard work to prepare the property, creating many future options for this beautiful estate.

  • Land Area (sf): 1,728,112
  • Living (sf): 3,595
  • Year Built: 1959

  • Property Condition: Above Average
  • Number of Parking Spaces: 10
  • Number of Stories: Two
  • View: Coastline,Garden,Mountain,Ocean
  • Listing Office: List Sotheby's Int'l Realty

  • Land Tenure: FS - Fee Simple

CONTACT US

Marcus Realty

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

array(140) {
  ["address_is_formatted"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["assd_val_imprv"]=>
  array(1) {
    [0]=>
    string(9) "252700.00"
  }
  ["assd_val_land"]=>
  array(1) {
    [0]=>
    string(10) "1743500.00"
  }
  ["assd_val_total"]=>
  array(1) {
    [0]=>
    string(10) "1996200.00"
  }
  ["county"]=>
  array(1) {
    [0]=>
    string(4) "Oahu"
  }
  ["disclosures"]=>
  array(1) {
    [0]=>
    string(24) "Property Disclosure Stmt"
  }
  ["easements"]=>
  array(1) {
    [0]=>
    string(5) "Other"
  }
  ["formatted_address"]=>
  array(1) {
    [0]=>
    string(40) "47-477 Waihee Pl, Kaneohe, HI 96744, USA"
  }
  ["formatted_address_simple"]=>
  array(1) {
    [0]=>
    string(29) "47-477 Waihee Pl, Kaneohe, HI"
  }
  ["frontage"]=>
  array(1) {
    [0]=>
    string(31) "Conservation,Other,Preservation"
  }
  ["google_place_id"]=>
  array(1) {
    [0]=>
    string(27) "ChIJN0yMdwJqAHwRiPvbmlhLBXo"
  }
  ["land_area_sf"]=>
  array(1) {
    [0]=>
    string(10) "1728112.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(25) "jeffhughes96743@gmail.com"
  }
  ["list_agent_name"]=>
  array(1) {
    [0]=>
    string(16) "Jeffrey A Hughes"
  }
  ["list_agent_phone_number"]=>
  array(1) {
    [0]=>
    string(14) "(808) 735-2411"
  }
  ["list_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-01-13"
  }
  ["list_office_name"]=>
  array(1) {
    [0]=>
    string(27) "List Sotheby's Int'l Realty"
  }
  ["list_price"]=>
  array(1) {
    [0]=>
    string(11) "12500000.00"
  }
  ["living_sf"]=>
  array(1) {
    [0]=>
    string(4) "3595"
  }
  ["location"]=>
  array(1) {
    [0]=>
    string(38) "47-477 Waihee Place, Kaneohe, HI 96744"
  }
  ["mls_"]=>
  array(1) {
    [0]=>
    string(9) "202100527"
  }
  ["neighborhood"]=>
  array(1) {
    [0]=>
    string(12) "KAHALUU TOWN"
  }
  ["number_of_parking_spaces"]=>
  array(1) {
    [0]=>
    string(2) "10"
  }
  ["number_of_stories"]=>
  array(1) {
    [0]=>
    string(3) "Two"
  }
  ["office_mls_id"]=>
  array(1) {
    [0]=>
    string(4) "LIST"
  }
  ["parking_features"]=>
  array(1) {
    [0]=>
    string(12) "Covered,Open"
  }
  ["possession"]=>
  array(1) {
    [0]=>
    string(10) "At Closing"
  }
  ["property_condition"]=>
  array(1) {
    [0]=>
    string(13) "Above Average"
  }
  ["property_type"]=>
  array(1) {
    [0]=>
    string(11) "multifamily"
  }
  ["property_type_label"]=>
  array(1) {
    [0]=>
    string(11) "multifamily"
  }
  ["region"]=>
  array(1) {
    [0]=>
    string(7) "Kaneohe"
  }
  ["rets_city"]=>
  array(1) {
    [0]=>
    string(7) "Kaneohe"
  }
  ["rets_co_list_agent_direct_work_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 439-8510"
  }
  ["rets_co_list_agent_email"]=>
  array(1) {
    [0]=>
    string(17) "yyang@listsir.com"
  }
  ["rets_co_list_agent_full_name"]=>
  array(1) {
    [0]=>
    string(11) "Yukiko Yang"
  }
  ["rets_co_list_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "36326"
  }
  ["rets_co_list_agent_mui"]=>
  array(1) {
    [0]=>
    string(7) "3480888"
  }
  ["rets_co_list_office_mlsid"]=>
  array(1) {
    [0]=>
    string(6) "LIST03"
  }
  ["rets_co_list_office_mui"]=>
  array(1) {
    [0]=>
    string(8) "10234197"
  }
  ["rets_co_list_office_name"]=>
  array(1) {
    [0]=>
    string(27) "List Sotheby's Int'l Realty"
  }
  ["rets_co_list_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 439-8510"
  }
  ["rets_current_price"]=>
  array(1) {
    [0]=>
    string(11) "12500000.00"
  }
  ["rets_dom"]=>
  array(1) {
    [0]=>
    string(3) "253"
  }
  ["rets_dual_variable_compensation_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_foreclosure_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_id"]=>
  array(1) {
    [0]=>
    string(8) "15649218"
  }
  ["rets_immoviewer_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_is_deleted"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_list_agent_direct_work_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 735-2411"
  }
  ["rets_list_agent_email"]=>
  array(1) {
    [0]=>
    string(25) "jeffhughes96743@gmail.com"
  }
  ["rets_list_agent_full_name"]=>
  array(1) {
    [0]=>
    string(16) "Jeffrey A Hughes"
  }
  ["rets_list_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "25917"
  }
  ["rets_list_agent_mui"]=>
  array(1) {
    [0]=>
    string(7) "8843301"
  }
  ["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(11) "12500000.00"
  }
  ["rets_listing_contract_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-01-13"
  }
  ["rets_lock_box_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_lot_size_area"]=>
  array(1) {
    [0]=>
    string(10) "1728112.00"
  }
  ["rets_matrix_modified_dt"]=>
  array(1) {
    [0]=>
    string(23) "2021-09-23T06:44:04.947"
  }
  ["rets_matrix_unique_id"]=>
  array(1) {
    [0]=>
    string(8) "15649218"
  }
  ["rets_mls_number"]=>
  array(1) {
    [0]=>
    string(9) "202100527"
  }
  ["rets_neighbourhood"]=>
  array(1) {
    [0]=>
    string(12) "KAHALUU TOWN"
  }
  ["rets_net_operating_income"]=>
  array(1) {
    [0]=>
    string(4) "0.00"
  }
  ["rets_number_of_units_total"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["rets_original_entry_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-01-13T17:42:31.657"
  }
  ["rets_original_list_price"]=>
  array(1) {
    [0]=>
    string(11) "12500000.00"
  }
  ["rets_other_income"]=>
  array(1) {
    [0]=>
    string(4) "0.00"
  }
  ["rets_parcel_number"]=>
  array(1) {
    [0]=>
    string(18) "1-4-7-006-001-0000"
  }
  ["rets_parking_total"]=>
  array(1) {
    [0]=>
    string(2) "10"
  }
  ["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-05-07T13:56:22.203"
  }
  ["rets_postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96744"
  }
  ["rets_price_change_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-01-13T17:42:31.657"
  }
  ["rets_primary_key"]=>
  array(1) {
    [0]=>
    string(8) "15649218"
  }
  ["rets_private_remarks"]=>
  array(1) {
    [0]=>
    string(224) "Showings to prequalified buyers by appointment only. Contact Jeff, Yukiko, or Toshi at 808-393-0391 with questions and for scheduling. Seller has done extensive work on the property: drainage, water wells, roadways, grading."
  }
  ["rets_public_remarks"]=>
  array(1) {
    [0]=>
    string(723) "Grand estate property for the ultimate privacy and serenity. Surrounded by the Koolau mountain range, and overlooking Kaneohe bay, Hale Waihee boasts two dwellings and all the infrastructure to create your dream. The property is equipped with its own wells to irrigate as well as provide water for the homes. The extensive drainage system and engineered driveway connect the different spaces within your sanctuary. There are tropical plants and fruit trees throughout, and abundant open space to grow your own crops. A commercial style kitchen would impress the most discerning home cooks. The seller has done much of the costly and hard work to prepare the property, creating many future options for this beautiful estate."
  }
  ["rets_sqft_building"]=>
  array(1) {
    [0]=>
    string(4) "3595"
  }
  ["rets_sqft_total"]=>
  array(1) {
    [0]=>
    string(4) "3595"
  }
  ["rets_state_or_province"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["rets_status_change_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-01-13T17:42:31.657"
  }
  ["rets_status_contractual_search_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-01-13"
  }
  ["rets_street_name"]=>
  array(1) {
    [0]=>
    string(6) "Waihee"
  }
  ["rets_street_number"]=>
  array(1) {
    [0]=>
    string(6) "47-477"
  }
  ["rets_studio_units_number_of"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_sub_agency_compensation"]=>
  array(1) {
    [0]=>
    string(4) "2.5%"
  }
  ["rets_tax_amount"]=>
  array(1) {
    [0]=>
    string(6) "948.17"
  }
  ["rets_tax_assessed_value"]=>
  array(1) {
    [0]=>
    string(10) "1996200.00"
  }
  ["rets_tax_assessed_value_improvements"]=>
  array(1) {
    [0]=>
    string(9) "252700.00"
  }
  ["rets_tax_assessed_value_land"]=>
  array(1) {
    [0]=>
    string(10) "1743500.00"
  }
  ["rets_tax_paid_by_seller_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_tax_year"]=>
  array(1) {
    [0]=>
    string(4) "2020"
  }
  ["rets_thumbnail_url"]=>
  array(1) {
    [0]=>
    string(81) "https://cdn.rets.ci/marcusrealty-images/15649218/ce2384fc1475661db8be1405373ffa65"
  }
  ["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(1) "1"
  }
  ["rets_tmk_section"]=>
  array(1) {
    [0]=>
    string(1) "7"
  }
  ["rets_tmk_zone"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["rets_tmkplat"]=>
  array(1) {
    [0]=>
    string(1) "6"
  }
  ["rets_total_actual_rent"]=>
  array(1) {
    [0]=>
    string(4) "0.00"
  }
  ["rets_total_annual_operating_expenses"]=>
  array(1) {
    [0]=>
    string(4) "0.00"
  }
  ["rets_total_income"]=>
  array(1) {
    [0]=>
    string(4) "0.00"
  }
  ["rets_unit_one_bed_number_of"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_unit_three_bed_number_of"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_unit_two_bed_number_of"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_year_built"]=>
  array(1) {
    [0]=>
    string(4) "1959"
  }
  ["setbacks"]=>
  array(1) {
    [0]=>
    string(3) "C&C"
  }
  ["status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["terms_accept"]=>
  array(1) {
    [0]=>
    string(17) "Cash,Conventional"
  }
  ["tmk"]=>
  array(1) {
    [0]=>
    string(18) "1-4-7-006-001-0000"
  }
  ["topography"]=>
  array(1) {
    [0]=>
    string(19) "Clear,Other,Rim Lot"
  }
  ["view"]=>
  array(1) {
    [0]=>
    string(31) "Coastline,Garden,Mountain,Ocean"
  }
  ["wpp::rets_pk"]=>
  array(1) {
    [0]=>
    string(8) "15649218"
  }
  ["wpp_gpid"]=>
  array(1) {
    [0]=>
    string(9) "202100527"
  }
  ["wpp_import_schedule_id"]=>
  array(1) {
    [0]=>
    string(11) "01463079115"
  }
  ["wpp_import_time"]=>
  array(1) {
    [0]=>
    string(10) "1632415569"
  }
  ["year_built"]=>
  array(1) {
    [0]=>
    string(4) "1959"
  }
  ["zoning"]=>
  array(1) {
    [0]=>
    string(30) "52 - AG-2 General Agricultural"
  }
  ["latitude"]=>
  array(1) {
    [0]=>
    string(10) "21.4565635"
  }
  ["longitude"]=>
  array(1) {
    [0]=>
    string(10) "-157.85687"
  }
  ["new_attached_media"]=>
  array(1) {
    [0]=>
    string(2754) "a:168:{i:0;i:17356350;i:1;i:17356352;i:2;i:17356354;i:3;i:17356356;i:4;i:17356357;i:5;i:17356359;i:6;i:17356362;i:7;i:17356363;i:8;i:17356365;i:9;i:17356367;i:10;i:17356368;i:11;i:17356370;i:12;i:17356372;i:13;i:17356374;i:14;i:17356376;i:15;i:17356378;i:16;i:17356380;i:17;i:17356382;i:18;i:17356384;i:19;i:17356386;i:20;i:17356387;i:21;i:17358453;i:22;i:17358454;i:23;i:17358455;i:24;i:17358456;i:25;i:17358457;i:26;i:17358458;i:27;i:17358459;i:28;i:17358460;i:29;i:17358461;i:30;i:17358462;i:31;i:17358463;i:32;i:17358464;i:33;i:17358465;i:34;i:17358466;i:35;i:17358467;i:36;i:17358468;i:37;i:17358469;i:38;i:17358470;i:39;i:17358471;i:40;i:17358472;i:41;i:17358473;i:42;i:17505390;i:43;i:17505391;i:44;i:17505392;i:45;i:17505393;i:46;i:17505394;i:47;i:17505395;i:48;i:17505396;i:49;i:17505397;i:50;i:17505398;i:51;i:17505399;i:52;i:17505400;i:53;i:17505401;i:54;i:17505402;i:55;i:17505403;i:56;i:17505404;i:57;i:17505405;i:58;i:17505406;i:59;i:17505407;i:60;i:17505408;i:61;i:17505409;i:62;i:17505410;i:63;i:17777067;i:64;i:17777068;i:65;i:17777069;i:66;i:17777070;i:67;i:17777071;i:68;i:17777072;i:69;i:17777073;i:70;i:17777074;i:71;i:17777075;i:72;i:17777076;i:73;i:17777077;i:74;i:17777078;i:75;i:17777079;i:76;i:17777080;i:77;i:17777081;i:78;i:17777082;i:79;i:17777083;i:80;i:17777084;i:81;i:17777085;i:82;i:17777086;i:83;i:17777087;i:84;i:19807849;i:85;i:19807850;i:86;i:19807851;i:87;i:19807852;i:88;i:19807853;i:89;i:19807854;i:90;i:19807855;i:91;i:19807856;i:92;i:19807857;i:93;i:19807858;i:94;i:19807859;i:95;i:19807860;i:96;i:19807861;i:97;i:19807862;i:98;i:19807863;i:99;i:19807864;i:100;i:19807865;i:101;i:19807866;i:102;i:19807867;i:103;i:19807868;i:104;i:19807869;i:105;i:19974147;i:106;i:19974148;i:107;i:19974149;i:108;i:19974150;i:109;i:19974151;i:110;i:19974152;i:111;i:19974153;i:112;i:19974154;i:113;i:19974155;i:114;i:19974156;i:115;i:19974157;i:116;i:19974158;i:117;i:19974159;i:118;i:19974160;i:119;i:19974161;i:120;i:19974162;i:121;i:19974163;i:122;i:19974164;i:123;i:19974165;i:124;i:19974166;i:125;i:19974167;i:126;i:20208728;i:127;i:20208729;i:128;i:20208730;i:129;i:20208731;i:130;i:20208732;i:131;i:20208733;i:132;i:20208734;i:133;i:20208735;i:134;i:20208736;i:135;i:20208737;i:136;i:20208738;i:137;i:20208739;i:138;i:20208740;i:139;i:20208741;i:140;i:20208742;i:141;i:20208743;i:142;i:20208744;i:143;i:20208745;i:144;i:20208746;i:145;i:20208747;i:146;i:20208748;i:147;i:20803752;i:148;i:20803753;i:149;i:20803754;i:150;i:20803755;i:151;i:20803756;i:152;i:20803757;i:153;i:20803758;i:154;i:20803759;i:155;i:20803760;i:156;i:20803761;i:157;i:20803762;i:158;i:20803763;i:159;i:20803764;i:160;i:20803765;i:161;i:20803766;i:162;i:20803767;i:163;i:20803768;i:164;i:20803769;i:165;i:20803770;i:166;i:20803771;i:167;i:20803772;}"
  }
  ["rets_virtual_tour_url_unbranded"]=>
  array(1) {
    [0]=>
    string(93) "https://players.brightcove.net/5782054075001/default_default/index.html?videoId=6222925234001"
  }
  ["virtual_tour"]=>
  array(1) {
    [0]=>
    string(93) "https://players.brightcove.net/5782054075001/default_default/index.html?videoId=6222925234001"
  }
  ["rets_supplement_count"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_supplement_modification_timestam"]=>
  array(1) {
    [0]=>
    string(23) "2021-02-08T15:34:52.280"
  }
  ["city"]=>
  array(1) {
    [0]=>
    string(7) "Kaneohe"
  }
  ["postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96744"
  }
  ["state_or_province"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["street_name"]=>
  array(1) {
    [0]=>
    string(6) "Waihee"
  }
  ["street_number"]=>
  array(1) {
    [0]=>
    string(6) "47-477"
  }
  ["street_suffix"]=>
  array(1) {
    [0]=>
    string(5) "Place"
  }
  ["rets_expiration_date"]=>
  array(1) {
    [0]=>
    string(10) "2022-01-13"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "20803752"
  }
}