Listing
Overview
Price: $4,977,000
Area: AG/PRESERVE
Status: Active Under Contract
This stately farmhouse graces a 5-acre former chocolate farm of world award-winning Paris acclaim! Behind the 400-foot lava rock wall, landscaped mature gardens delight your senses. The elegant, classic home, built to last for generations, boasts magnificent sweeping views of the mountain and ocean vistas, 12-foot ceilings, a guest/caretaker house, custom walnut-paneled study, 2 fireplaces, 12-foot-high kitchen with double-high cabinets, a massive 8-foot island, a 68-foot-long covered lanai facing vibrant sunsets, and overlooks the entire north shore countryside. Enjoy the best of both worlds with horses, as a gentleman farmer, or stroll the expansive green lawns and grounds. It is a net-zero energy home as well and opens fully to Hawaii’s breezes. Located on the hillside five minutes from Haleiwa for shopping and fine dinning and 45 minutes to Honolulu. Listing by: Hawaii Homes International (808) 949-0020
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202322190"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "65-660"
}
["PropertyType"]=>
array(1) {
[0]=>
string(16) "Lots/Acres/Farms"
}
["StreetName"]=>
array(1) {
[0]=>
string(10) "Kaukonahua"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(4) "Road"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(1) "A"
}
["City"]=>
array(1) {
[0]=>
string(7) "Waialua"
}
["StateOrProvince"]=>
array(1) {
[0]=>
string(2) "HI"
}
["PostalCode"]=>
array(1) {
[0]=>
string(5) "96791"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(41) "https://www.youtube.com/embed/wiXQvieH8Jk"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "4977000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "4977000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(11) "AG/PRESERVE"
}
["Status"]=>
array(1) {
[0]=>
string(21) "Active Under Contract"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(869) "This stately farmhouse graces a 5-acre former chocolate farm of world award-winning Paris acclaim! Behind the 400-foot lava rock wall, landscaped mature gardens delight your senses. The elegant, classic home, built to last for generations, boasts magnificent sweeping views of the mountain and ocean vistas, 12-foot ceilings, a guest/caretaker house, custom walnut-paneled study, 2 fireplaces, 12-foot-high kitchen with double-high cabinets, a massive 8-foot island, a 68-foot-long covered lanai facing vibrant sunsets, and overlooks the entire north shore countryside. Enjoy the best of both worlds with horses, as a gentleman farmer, or stroll the expansive green lawns and grounds. It is a net-zero energy home as well and opens fully to Hawaii’s breezes. Located on the hillside five minutes from Haleiwa for shopping and fine dinning and 45 minutes to Honolulu."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(26) "Hawaii Homes International"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(0) ""
}
["BathsFull"]=>
array(1) {
[0]=>
string(0) ""
}
["BathsHalf"]=>
array(1) {
[0]=>
string(0) ""
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(9) "221633.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(0) ""
}
["YearBuilt"]=>
array(1) {
[0]=>
string(0) ""
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(0) ""
}
["ParkingTotal"]=>
array(1) {
[0]=>
NULL
}
["StoriesType"]=>
array(1) {
[0]=>
NULL
}
["View"]=>
array(1) {
[0]=>
string(38) "Coastline,Garden,Mountain,Ocean,Sunset"
}
["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) "REEW"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(15) "bgwvrdr@aol.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 949-0020"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(12) "Ralph S Gray"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-08-27T09:44:53.973"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "17592609"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2023-10-04T14:23:32.670"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(11) "North Shore"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(5) "Other"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "25978218"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "25978218"
[1]=>
string(8) "25978219"
[2]=>
string(8) "25978220"
[3]=>
string(8) "25978221"
[4]=>
string(8) "25978222"
[5]=>
string(8) "25978223"
[6]=>
string(8) "25978224"
[7]=>
string(8) "25978225"
[8]=>
string(8) "25978226"
[9]=>
string(8) "25978227"
[10]=>
string(8) "25978228"
[11]=>
string(8) "25978229"
[12]=>
string(8) "25978230"
[13]=>
string(8) "25978231"
[14]=>
string(8) "25978232"
[15]=>
string(8) "25978233"
[16]=>
string(8) "25978234"
[17]=>
string(8) "25978235"
[18]=>
string(8) "25978236"
[19]=>
string(8) "25978237"
[20]=>
string(8) "25978238"
[21]=>
string(8) "25978239"
[22]=>
string(8) "25978240"
[23]=>
string(8) "25978241"
[24]=>
string(8) "25978242"
[25]=>
string(8) "25978243"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202322190
)
[StreetNumber] => Array
(
[0] => 65-660
)
[PropertyType] => Array
(
[0] => Lots/Acres/Farms
)
[StreetName] => Array
(
[0] => Kaukonahua
)
[StreetSuffix] => Array
(
[0] => Road
)
[UnitNumber] => Array
(
[0] => A
)
[City] => Array
(
[0] => Waialua
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96791
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://www.youtube.com/embed/wiXQvieH8Jk
)
[ListPrice] => Array
(
[0] => 4977000.00
)
[CurrentPrice] => Array
(
[0] => 4977000.00
)
[Neighbourhood] => Array
(
[0] => AG/PRESERVE
)
[Status] => Array
(
[0] => Active Under Contract
)
[PublicRemarks] => Array
(
[0] => This stately farmhouse graces a 5-acre former chocolate farm of world award-winning Paris acclaim! Behind the 400-foot lava rock wall, landscaped mature gardens delight your senses. The elegant, classic home, built to last for generations, boasts magnificent sweeping views of the mountain and ocean vistas, 12-foot ceilings, a guest/caretaker house, custom walnut-paneled study, 2 fireplaces, 12-foot-high kitchen with double-high cabinets, a massive 8-foot island, a 68-foot-long covered lanai facing vibrant sunsets, and overlooks the entire north shore countryside. Enjoy the best of both worlds with horses, as a gentleman farmer, or stroll the expansive green lawns and grounds. It is a net-zero energy home as well and opens fully to Hawaii’s breezes. Located on the hillside five minutes from Haleiwa for shopping and fine dinning and 45 minutes to Honolulu.
)
[ListOfficeName] => Array
(
[0] => Hawaii Homes International
)
[BedsTotal] => Array
(
[0] =>
)
[BathsFull] => Array
(
[0] =>
)
[BathsHalf] => Array
(
[0] =>
)
[LotSizeArea] => Array
(
[0] => 221633.00
)
[SqftTotal] => Array
(
[0] =>
)
[YearBuilt] => Array
(
[0] =>
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] =>
)
[ParkingTotal] => Array
(
[0] =>
)
[StoriesType] => Array
(
[0] =>
)
[View] => Array
(
[0] => Coastline,Garden,Mountain,Ocean,Sunset
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => REEW
)
[ListAgentEmail] => Array
(
[0] => bgwvrdr@aol.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 949-0020
)
[ListAgentFullName] => Array
(
[0] => Ralph S Gray
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-08-27T09:44:53.973
)
[Matrix_Unique_ID] => Array
(
[0] => 17592609
)
[OriginalEntryTimestamp] => Array
(
[0] => 2023-10-04T14:23:32.670
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] => Other
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 25978218
)
[listing_image] => Array
(
[0] => 25978218
[1] => 25978219
[2] => 25978220
[3] => 25978221
[4] => 25978222
[5] => 25978223
[6] => 25978224
[7] => 25978225
[8] => 25978226
[9] => 25978227
[10] => 25978228
[11] => 25978229
[12] => 25978230
[13] => 25978231
[14] => 25978232
[15] => 25978233
[16] => 25978234
[17] => 25978235
[18] => 25978236
[19] => 25978237
[20] => 25978238
[21] => 25978239
[22] => 25978240
[23] => 25978241
[24] => 25978242
[25] => 25978243
)
)
- View: Coastline,Garden,Mountain,Ocean,Sunset
- Listing Office: Hawaii Homes International
- Land Tenure: FS - Fee Simple
