Thanksgiving - The office will be closed on Thursday 11/27/25 and Friday 11/28/25
Christmas - The office will be closed on Thursday 12/25/25 and Friday 12/26/25
New Years - The office will be closed on Thursday 1/1/26 and Friday 1/2/26
Price: $1,600,000 Area: AG/PRESERVE Status: Active
Stream-Front, High-Traffic Agricultural Lot at the Gateway to Haleiwa & Waialua. Welcome to a rare opportunity at Thompson Corner—where Haleiwa and Waialua meet along Kaukonahua Road and Farrington Highway. This rare 5.482-acre stream-front agricultural property offers premium visibility, direct ocean access, and extraordinary potential for both commercial agriculture and private farm living. Enjoy direct stream access to the ocean—perfect for a Jet Ski, kayak, or small power boat. As a high-traffic inner lot positioned near the west entry to Haleiwa, the location is ideal for farm-based commercial ventures. Create your vision: a farm-to-table restaurant, food stands, an AG visitor center, or a hub for direct farm sales. The possibilities are virtually unlimited. The property allows for a single farm dwelling up to a 5,000 sq. ft. footprint (two stories)—offering the rare chance to live full-time on your farm. Build your home alongside supporting farm structures, barns, and work facilities, all designed to complement your agricultural operations. Set against the majestic backdrop of Mount Ka'ala. Your dream farm and business opportunity on Oahu’s North Shore countryside awaits. Listing by: Hawaii Homes International (808) 295-0704
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202524898"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(7) "61-1121"
}
["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) "5"
}
["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(43) "https://www.youtube.com/embed/
CCy5Emzq3Y0"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "1600000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(11) "AG/PRESERVE"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1204) "Stream-Front, High-Traffic Agricultural Lot at the Gateway to Haleiwa & Waialua. Welcome to a rare opportunity at Thompson Corner—where Haleiwa and Waialua meet along Kaukonahua Road and Farrington Highway. This rare 5.482-acre stream-front agricultural property offers premium visibility, direct ocean access, and extraordinary potential for both commercial agriculture and private farm living. Enjoy direct stream access to the ocean—perfect for a Jet Ski, kayak, or small power boat. As a high-traffic inner lot positioned near the west entry to Haleiwa, the location is ideal for farm-based commercial ventures. Create your vision: a farm-to-table restaurant, food stands, an AG visitor center, or a hub for direct farm sales. The possibilities are virtually unlimited. The property allows for a single farm dwelling up to a 5,000 sq. ft. footprint (two stories)—offering the rare chance to live full-time on your farm. Build your home alongside supporting farm structures, barns, and work facilities, all designed to complement your agricultural operations. Set against the majestic backdrop of Mount Ka'ala. Your dream farm and business opportunity on Oahu’s North Shore countryside awaits."
}
["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) "238795.92"
}
["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(14) "Mountain,Other"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(0) ""
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(7) "Waialua"
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(7) "Waialua"
}
["HighSchool"]=>
array(1) {
[0]=>
string(7) "Waialua"
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "REEW"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(15) "bgwvrdr@aol.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 295-0704"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(12) "Ralph S Gray"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "19082641"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-12-13T15:45:48.100"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2025-11-04"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(11) "North Shore"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(12) "Stream/Canal"
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "15:45:48.100"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "27236641"
}
["listing_image"]=>
array(20) {
[0]=>
string(8) "27236641"
[1]=>
string(8) "27236642"
[2]=>
string(8) "27236643"
[3]=>
string(8) "27236644"
[4]=>
string(8) "27236645"
[5]=>
string(8) "27236646"
[6]=>
string(8) "27236647"
[7]=>
string(8) "27236648"
[8]=>
string(8) "27236649"
[9]=>
string(8) "27236650"
[10]=>
string(8) "27236651"
[11]=>
string(8) "27236652"
[12]=>
string(8) "27236653"
[13]=>
string(8) "27236654"
[14]=>
string(8) "27236655"
[15]=>
string(8) "27236656"
[16]=>
string(8) "27237933"
[17]=>
string(8) "27237934"
[18]=>
string(8) "27237935"
[19]=>
string(8) "27237936"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202524898
)
[StreetNumber] => Array
(
[0] => 61-1121
)
[PropertyType] => Array
(
[0] => Lots/Acres/Farms
)
[StreetName] => Array
(
[0] => Kaukonahua
)
[StreetSuffix] => Array
(
[0] => Road
)
[UnitNumber] => Array
(
[0] => 5
)
[City] => Array
(
[0] => Waialua
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96791
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://www.youtube.com/embed/
CCy5Emzq3Y0
)
[ListPrice] => Array
(
[0] => 1600000.00
)
[Neighbourhood] => Array
(
[0] => AG/PRESERVE
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Stream-Front, High-Traffic Agricultural Lot at the Gateway to Haleiwa & Waialua. Welcome to a rare opportunity at Thompson Corner—where Haleiwa and Waialua meet along Kaukonahua Road and Farrington Highway. This rare 5.482-acre stream-front agricultural property offers premium visibility, direct ocean access, and extraordinary potential for both commercial agriculture and private farm living. Enjoy direct stream access to the ocean—perfect for a Jet Ski, kayak, or small power boat. As a high-traffic inner lot positioned near the west entry to Haleiwa, the location is ideal for farm-based commercial ventures. Create your vision: a farm-to-table restaurant, food stands, an AG visitor center, or a hub for direct farm sales. The possibilities are virtually unlimited. The property allows for a single farm dwelling up to a 5,000 sq. ft. footprint (two stories)—offering the rare chance to live full-time on your farm. Build your home alongside supporting farm structures, barns, and work facilities, all designed to complement your agricultural operations. Set against the majestic backdrop of Mount Ka'ala. Your dream farm and business opportunity on Oahu’s North Shore countryside awaits.
)
[ListOfficeName] => Array
(
[0] => Hawaii Homes International
)
[BedsTotal] => Array
(
[0] =>
)
[BathsFull] => Array
(
[0] =>
)
[BathsHalf] => Array
(
[0] =>
)
[LotSizeArea] => Array
(
[0] => 238795.92
)
[SqftTotal] => Array
(
[0] =>
)
[YearBuilt] => Array
(
[0] =>
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] =>
)
[ParkingTotal] => Array
(
[0] =>
)
[StoriesType] => Array
(
[0] =>
)
[View] => Array
(
[0] => Mountain,Other
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Waialua
)
[MiddleOrJuniorSchool] => Array
(
[0] => Waialua
)
[HighSchool] => Array
(
[0] => Waialua
)
[ListOfficeMLSID] => Array
(
[0] => REEW
)
[ListAgentEmail] => Array
(
[0] => bgwvrdr@aol.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 295-0704
)
[ListAgentFullName] => Array
(
[0] => Ralph S Gray
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 19082641
)
[MatrixModifiedDT] => Array
(
[0] => 2025-12-13T15:45:48.100
)
[ListingContractDate] => Array
(
[0] => 2025-11-04
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] => Stream/Canal
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 15:45:48.100
)
[_thumbnail_id] => Array
(
[0] => 27236641
)
[listing_image] => Array
(
[0] => 27236641
[1] => 27236642
[2] => 27236643
[3] => 27236644
[4] => 27236645
[5] => 27236646
[6] => 27236647
[7] => 27236648
[8] => 27236649
[9] => 27236650
[10] => 27236651
[11] => 27236652
[12] => 27236653
[13] => 27236654
[14] => 27236655
[15] => 27236656
[16] => 27237933
[17] => 27237934
[18] => 27237935
[19] => 27237936
)
)
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on December 13, 2025 - 3:45 PM
Information is deemed reliable but not guaranteed.
Copyright: 2025 by HiCentral MLS, Ltd.
Some of the active listings appearing on this site may be listed by other REALTORS®.
If you are interested in those active listings, our company may represent you as the buyer's agent.
If the active listing you are interested in is our company's active listing, you may speak to one of our agents
regarding your options for representation.
