Listing
Overview
Price: $1,425,000
Area: AG/PRESERVE
Status: Active Under Contract
High traffic corner lot at the west entry to Haleiwa and Waialua. A farm dwelling is allowed on this lot so you can reside here full time while farming in Paradise. Discover this exceptional premium farmland, spanning approximately 5.633 acres, situated at the coveted Thompson Corner where the communities of Haleiwa and Waialua meet along Kaukonahua Road and Farrington Hwy. Boasting an impressive 400 yards of corner and road frontage, this prime piece of land offers boundless opportunities for AG commercial use. Ideal for cultivating a thriving farm-to-table restaurant or creating a welcoming space for direct sales to the public through food stands or a visitor center, the potential is limitless. This property allows for a single farm dwelling you can live in, along with supporting farm structures, barns, and facilities, all while enjoying gorgeous views of the majestic Mount Ka'ala. Currently adorned with mature, fruit-bearing trees, this exquisite farmland stands as a blank canvas, awaiting your agricultural dreams to unfold. Call for details. Listing by: Hawaii Homes International (808) 949-0020
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202411707"
}
["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) "1"
}
["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/myiQkp213Wg"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "1425000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "1425000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(11) "AG/PRESERVE"
}
["Status"]=>
array(1) {
[0]=>
string(21) "Active Under Contract"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1062) "High traffic corner lot at the west entry to Haleiwa and Waialua. A farm dwelling is allowed on this lot so you can reside here full time while farming in Paradise. Discover this exceptional premium farmland, spanning approximately 5.633 acres, situated at the coveted Thompson Corner where the communities of Haleiwa and Waialua meet along Kaukonahua Road and Farrington Hwy. Boasting an impressive 400 yards of corner and road frontage, this prime piece of land offers boundless opportunities for AG commercial use. Ideal for cultivating a thriving farm-to-table restaurant or creating a welcoming space for direct sales to the public through food stands or a visitor center, the potential is limitless. This property allows for a single farm dwelling you can live in, along with supporting farm structures, barns, and facilities, all while enjoying gorgeous views of the majestic Mount Ka'ala. Currently adorned with mature, fruit-bearing trees, this exquisite farmland stands as a blank canvas, awaiting your agricultural dreams to unfold. Call for details."
}
["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) "234571.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(14) "Mountain,Other"
}
["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-09-12T16:30:13.803"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18018080"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-06-07T11:51:46.313"
}
["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) "26571844"
}
["listing_image"]=>
array(17) {
[0]=>
string(8) "26571844"
[1]=>
string(8) "26571845"
[2]=>
string(8) "26571846"
[3]=>
string(8) "26571847"
[4]=>
string(8) "26571848"
[5]=>
string(8) "26571849"
[6]=>
string(8) "26571850"
[7]=>
string(8) "26571851"
[8]=>
string(8) "26571852"
[9]=>
string(8) "26571853"
[10]=>
string(8) "26571854"
[11]=>
string(8) "26571855"
[12]=>
string(8) "26571856"
[13]=>
string(8) "26571857"
[14]=>
string(8) "26571858"
[15]=>
string(8) "26572917"
[16]=>
string(8) "26572918"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202411707
)
[StreetNumber] => Array
(
[0] => 61-1121
)
[PropertyType] => Array
(
[0] => Lots/Acres/Farms
)
[StreetName] => Array
(
[0] => Kaukonahua
)
[StreetSuffix] => Array
(
[0] => Road
)
[UnitNumber] => Array
(
[0] => 1
)
[City] => Array
(
[0] => Waialua
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96791
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://www.youtube.com/embed/myiQkp213Wg
)
[ListPrice] => Array
(
[0] => 1425000.00
)
[CurrentPrice] => Array
(
[0] => 1425000.00
)
[Neighbourhood] => Array
(
[0] => AG/PRESERVE
)
[Status] => Array
(
[0] => Active Under Contract
)
[PublicRemarks] => Array
(
[0] => High traffic corner lot at the west entry to Haleiwa and Waialua. A farm dwelling is allowed on this lot so you can reside here full time while farming in Paradise. Discover this exceptional premium farmland, spanning approximately 5.633 acres, situated at the coveted Thompson Corner where the communities of Haleiwa and Waialua meet along Kaukonahua Road and Farrington Hwy. Boasting an impressive 400 yards of corner and road frontage, this prime piece of land offers boundless opportunities for AG commercial use. Ideal for cultivating a thriving farm-to-table restaurant or creating a welcoming space for direct sales to the public through food stands or a visitor center, the potential is limitless. This property allows for a single farm dwelling you can live in, along with supporting farm structures, barns, and facilities, all while enjoying gorgeous views of the majestic Mount Ka'ala. Currently adorned with mature, fruit-bearing trees, this exquisite farmland stands as a blank canvas, awaiting your agricultural dreams to unfold. Call for details.
)
[ListOfficeName] => Array
(
[0] => Hawaii Homes International
)
[BedsTotal] => Array
(
[0] =>
)
[BathsFull] => Array
(
[0] =>
)
[BathsHalf] => Array
(
[0] =>
)
[LotSizeArea] => Array
(
[0] => 234571.00
)
[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] =>
)
[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-09-12T16:30:13.803
)
[Matrix_Unique_ID] => Array
(
[0] => 18018080
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-06-07T11:51:46.313
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] => Other
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26571844
)
[listing_image] => Array
(
[0] => 26571844
[1] => 26571845
[2] => 26571846
[3] => 26571847
[4] => 26571848
[5] => 26571849
[6] => 26571850
[7] => 26571851
[8] => 26571852
[9] => 26571853
[10] => 26571854
[11] => 26571855
[12] => 26571856
[13] => 26571857
[14] => 26571858
[15] => 26572917
[16] => 26572918
)
)
- View: Mountain,Other
- Listing Office: Hawaii Homes International
- Land Tenure: FS - Fee Simple
