47-477 Waihee Place Kaneohe, HI 96744

Listing
Overview

Price: $14,000,000
Area: KAHALUU TOWN
Status: Active Under Contract

Welcome to your own private oasis with the option to live completely off grid! Take in the stunning 180 degree views of the ocean and Kaneohe Bay. This incredible property is a total of 40 acres, 16 acres of Ag-2 land, Approx 7 acres of Flat Land & 24 acres of preservation. Perfect for hiking, horseback riding, farming, equestrian center, helipad, or even a cluster development. MILLIONS have been spent on this meticulously planned infrastructure including an extensive drainage system to mitigate flooding and pooling, with 24 inch city grade pipes and a silting pond. The planning doesn't stop there, it also has 600 amp Electric & Wifi house, a private water well, extra wide paved driveways that provide easy access to multiple points on the property, underground electrical conduits, multiple fire hydrants and water hydrant access points for more structures. ***MAIN HOUSE 2,497 sqft 3 bed/3 bath w/ full chef's kitchen, heated pool and outdoor shower just off the large entertaining area. COTTAGE 1,100sqft 3 bed/2 bath. ***Also listed as LAND, see MLS# 202326790 Listing by: RE/MAX ALOHA HOMES (808) 393-9966

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202313852"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "47-477"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(13) "Single Family"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(6) "Waihee"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(5) "Place"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["City"]=>
  array(1) {
    [0]=>
    string(7) "Kaneohe"
  }
  ["StateOrProvince"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["PostalCode"]=>
  array(1) {
    [0]=>
    string(5) "96744"
  }
  ["VirtualTourURLUnbranded"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(11) "14000000.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    string(11) "14000000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(12) "KAHALUU TOWN"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(21) "Active Under Contract"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1075) "Welcome to your own private oasis with the option to live completely off grid! Take in the stunning 180 degree views of the ocean and Kaneohe Bay. This incredible property is a total of 40 acres, 16 acres of Ag-2 land, Approx 7 acres of Flat Land & 24 acres of preservation. Perfect for hiking, horseback riding, farming, equestrian center, helipad, or even a cluster development. MILLIONS have been spent on this meticulously planned infrastructure including an extensive drainage system to mitigate flooding and pooling, with 24 inch city grade pipes and a silting pond.  The planning doesn't stop there, it also has 600 amp Electric & Wifi house, a private water well, extra wide paved driveways that provide easy access to multiple points on the property, underground electrical conduits, multiple fire hydrants and water hydrant access points for more structures.  ***MAIN HOUSE 2,497 sqft 3 bed/3 bath w/ full chef's kitchen, heated pool and outdoor shower just off the large entertaining area. COTTAGE 1,100sqft 3 bed/2 bath. ***Also listed as LAND, see MLS# 202326790"
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(18) "RE/MAX ALOHA HOMES"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "6"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "5"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(10) "1728112.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "3595"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1959"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(13) "Above Average"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(2) "10"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "Two"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(38) "Coastline,Mountain,Ocean,Other,Sunrise"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["LandTenure"]=>
  array(1) {
    [0]=>
    string(15) "FS - Fee Simple"
  }
  ["ElementarySchool"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MiddleOrJuniorSchool"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["HighSchool"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ListOfficeMLSID"]=>
  array(1) {
    [0]=>
    string(4) "RMXA"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(30) "stephanie@hawaiidreamhomes.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 393-9966"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(18) "Stephanie Rae Band"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2024-05-13T11:33:45.497"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "17386797"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(23) "2023-06-25T12:55:56.397"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "25857785"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "25857785"
    [1]=>
    string(8) "25857786"
    [2]=>
    string(8) "25857787"
    [3]=>
    string(8) "25857788"
    [4]=>
    string(8) "25857789"
    [5]=>
    string(8) "25857790"
    [6]=>
    string(8) "25857791"
    [7]=>
    string(8) "25857792"
    [8]=>
    string(8) "25857793"
    [9]=>
    string(8) "25857794"
    [10]=>
    string(8) "25857795"
    [11]=>
    string(8) "25857796"
    [12]=>
    string(8) "25857797"
    [13]=>
    string(8) "25857798"
    [14]=>
    string(8) "25857799"
    [15]=>
    string(8) "25857800"
    [16]=>
    string(8) "25857801"
    [17]=>
    string(8) "25857802"
    [18]=>
    string(8) "25857803"
    [19]=>
    string(8) "25857804"
    [20]=>
    string(8) "25857805"
    [21]=>
    string(8) "25857806"
    [22]=>
    string(8) "25857807"
    [23]=>
    string(8) "25857808"
    [24]=>
    string(8) "25857809"
    [25]=>
    string(8) "25857810"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(7) "Kaneohe"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(12) "Preservation"
  }
  ["SpecialListingConditions"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202313852
        )

    [StreetNumber] => Array
        (
            [0] => 47-477
        )

    [PropertyType] => Array
        (
            [0] => Single Family
        )

    [StreetName] => Array
        (
            [0] => Waihee
        )

    [StreetSuffix] => Array
        (
            [0] => Place
        )

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

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

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

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

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

    [ListPrice] => Array
        (
            [0] => 14000000.00
        )

    [CurrentPrice] => Array
        (
            [0] => 14000000.00
        )

    [Neighbourhood] => Array
        (
            [0] => KAHALUU TOWN
        )

    [Status] => Array
        (
            [0] => Active Under Contract
        )

    [PublicRemarks] => Array
        (
            [0] => Welcome to your own private oasis with the option to live completely off grid! Take in the stunning 180 degree views of the ocean and Kaneohe Bay. This incredible property is a total of 40 acres, 16 acres of Ag-2 land, Approx 7 acres of Flat Land & 24 acres of preservation. Perfect for hiking, horseback riding, farming, equestrian center, helipad, or even a cluster development. MILLIONS have been spent on this meticulously planned infrastructure including an extensive drainage system to mitigate flooding and pooling, with 24 inch city grade pipes and a silting pond.  The planning doesn't stop there, it also has 600 amp Electric & Wifi house, a private water well, extra wide paved driveways that provide easy access to multiple points on the property, underground electrical conduits, multiple fire hydrants and water hydrant access points for more structures.  ***MAIN HOUSE 2,497 sqft 3 bed/3 bath w/ full chef's kitchen, heated pool and outdoor shower just off the large entertaining area. COTTAGE 1,100sqft 3 bed/2 bath. ***Also listed as LAND, see MLS# 202326790
        )

    [ListOfficeName] => Array
        (
            [0] => RE/MAX ALOHA HOMES
        )

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

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

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

    [LotSizeArea] => Array
        (
            [0] => 1728112.00
        )

    [SqftTotal] => Array
        (
            [0] => 3595
        )

    [YearBuilt] => Array
        (
            [0] => 1959
        )

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

    [PropertyCondition] => Array
        (
            [0] => Above Average
        )

    [ParkingTotal] => Array
        (
            [0] => 10
        )

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

    [View] => Array
        (
            [0] => Coastline,Mountain,Ocean,Other,Sunrise
        )

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

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

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

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

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

    [ListOfficeMLSID] => Array
        (
            [0] => RMXA
        )

    [ListAgentEmail] => Array
        (
            [0] => stephanie@hawaiidreamhomes.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 393-9966
        )

    [ListAgentFullName] => Array
        (
            [0] => Stephanie Rae Band
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2024-05-13T11:33:45.497
        )

    [Matrix_Unique_ID] => Array
        (
            [0] => 17386797
        )

    [OriginalEntryTimestamp] => Array
        (
            [0] => 2023-06-25T12:55:56.397
        )

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

    [listing_image] => Array
        (
            [0] => 25857785
            [1] => 25857786
            [2] => 25857787
            [3] => 25857788
            [4] => 25857789
            [5] => 25857790
            [6] => 25857791
            [7] => 25857792
            [8] => 25857793
            [9] => 25857794
            [10] => 25857795
            [11] => 25857796
            [12] => 25857797
            [13] => 25857798
            [14] => 25857799
            [15] => 25857800
            [16] => 25857801
            [17] => 25857802
            [18] => 25857803
            [19] => 25857804
            [20] => 25857805
            [21] => 25857806
            [22] => 25857807
            [23] => 25857808
            [24] => 25857809
            [25] => 25857810
        )

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

    [PropertyFrontage] => Array
        (
            [0] => Preservation
        )

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

)

  • BedsTotal: 6
  • Full Baths: 5
  • Land Area (sf): 1,728,112
  • Living (sf): 3,595
  • Year Built: 1959

  • Property Condition: Above Average
  • Number of Parking Spaces: 10
  • View: Coastline,Mountain,Ocean,Other,Sunrise
  • Listing Office: RE/MAX ALOHA HOMES

  • Land Tenure: FS - Fee Simple

CONTACT US

Marcus Realty

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