Listing
Overview
Price: $500,000
Area: HALEIWA
Status: Active
Stream Front in Haleiwa. This is a 26,964 sqft. lot on Anahulu Stream, which allows 1 farm dwelling and supporting accessory AG structures. Off the grid lifestyle but close to everything. Perfect for grazing and farming with streamside views. Clear stream with wild prawns, smallmouth bass, and other life. Paddle board or kayak from the lower river to Haleiwa Harbor and Beach Park for fun in the sun. Additional larger lots are available if you need more space. Visitors say this is one of the most beautiful pieces of land they have seen in rural Oahu and is the best-kept secret on the North Shore. Perfect for a family compound or yoga retreat. Build a yurt today and enjoy the land while you build your farm home. 10-minute bike ride to the center of Haleiwa town. Easy access to Kam Hwy and no north shore traffic. A magical place in the Anahulu Valley. Locked behind gates. Water and power included and coming when and if approved. Listing by: Hawaii Homes International
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202225114"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(4) "0000"
}
["PropertyType"]=>
array(1) {
[0]=>
string(16) "Lots/Acres/Farms"
}
["StreetName"]=>
array(1) {
[0]=>
string(10) "Kamehameha"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(7) "Highway"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(6) "Lot 41"
}
["City"]=>
array(1) {
[0]=>
string(7) "Wahiawa"
}
["StateOrProvince"]=>
array(1) {
[0]=>
string(2) "HI"
}
["PostalCode"]=>
array(1) {
[0]=>
string(5) "96786"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(41) "https://www.youtube.com/embed/Guqfr5aUTf0"
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "500000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(9) "500000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "HALEIWA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(940) "Stream Front in Haleiwa. This is a 26,964 sqft. lot on Anahulu Stream, which allows 1 farm dwelling and supporting accessory AG structures. Off the grid lifestyle but close to everything. Perfect for grazing and farming with streamside views. Clear stream with wild prawns, smallmouth bass, and other life. Paddle board or kayak from the lower river to Haleiwa Harbor and Beach Park for fun in the sun. Additional larger lots are available if you need more space. Visitors say this is one of the most beautiful pieces of land they have seen in rural Oahu and is the best-kept secret on the North Shore. Perfect for a family compound or yoga retreat. Build a yurt today and enjoy the land while you build your farm home. 10-minute bike ride to the center of Haleiwa town. Easy access to Kam Hwy and no north shore traffic. A magical place in the Anahulu Valley. Locked behind gates. Water and power included and coming when and if approved."
}
["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(8) "26964.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(4) "0.00"
}
["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(0) ""
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(12) "Ralph S Gray"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2023-09-29T16:36:25.900"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "17027166"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2022-12-02T14:31:27.227"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "25869478"
}
["listing_image"]=>
array(25) {
[0]=>
string(8) "25869478"
[1]=>
string(8) "25869479"
[2]=>
string(8) "25869480"
[3]=>
string(8) "25869481"
[4]=>
string(8) "25869482"
[5]=>
string(8) "25869483"
[6]=>
string(8) "25869484"
[7]=>
string(8) "25869485"
[8]=>
string(8) "25869486"
[9]=>
string(8) "25869487"
[10]=>
string(8) "25869488"
[11]=>
string(8) "25869489"
[12]=>
string(8) "25869490"
[13]=>
string(8) "25869491"
[14]=>
string(8) "25869492"
[15]=>
string(8) "25869493"
[16]=>
string(8) "25869494"
[17]=>
string(8) "25869495"
[18]=>
string(8) "25869496"
[19]=>
string(8) "25869497"
[20]=>
string(8) "25869498"
[21]=>
string(8) "25869499"
[22]=>
string(8) "25869500"
[23]=>
string(8) "25869501"
[24]=>
string(8) "25869502"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(11) "North Shore"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(5) "Other"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202225114
)
[StreetNumber] => Array
(
[0] => 0000
)
[PropertyType] => Array
(
[0] => Lots/Acres/Farms
)
[StreetName] => Array
(
[0] => Kamehameha
)
[StreetSuffix] => Array
(
[0] => Highway
)
[UnitNumber] => Array
(
[0] => Lot 41
)
[City] => Array
(
[0] => Wahiawa
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96786
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://www.youtube.com/embed/Guqfr5aUTf0
)
[ListPrice] => Array
(
[0] => 500000.00
)
[CurrentPrice] => Array
(
[0] => 500000.00
)
[Neighbourhood] => Array
(
[0] => HALEIWA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Stream Front in Haleiwa. This is a 26,964 sqft. lot on Anahulu Stream, which allows 1 farm dwelling and supporting accessory AG structures. Off the grid lifestyle but close to everything. Perfect for grazing and farming with streamside views. Clear stream with wild prawns, smallmouth bass, and other life. Paddle board or kayak from the lower river to Haleiwa Harbor and Beach Park for fun in the sun. Additional larger lots are available if you need more space. Visitors say this is one of the most beautiful pieces of land they have seen in rural Oahu and is the best-kept secret on the North Shore. Perfect for a family compound or yoga retreat. Build a yurt today and enjoy the land while you build your farm home. 10-minute bike ride to the center of Haleiwa town. Easy access to Kam Hwy and no north shore traffic. A magical place in the Anahulu Valley. Locked behind gates. Water and power included and coming when and if approved.
)
[ListOfficeName] => Array
(
[0] => Hawaii Homes International
)
[BedsTotal] => Array
(
[0] =>
)
[BathsFull] => Array
(
[0] =>
)
[BathsHalf] => Array
(
[0] =>
)
[LotSizeArea] => Array
(
[0] => 26964.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] => 0.00
)
[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] =>
)
[ListAgentFullName] => Array
(
[0] => Ralph S Gray
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2023-09-29T16:36:25.900
)
[Matrix_Unique_ID] => Array
(
[0] => 17027166
)
[OriginalEntryTimestamp] => Array
(
[0] => 2022-12-02T14:31:27.227
)
[_thumbnail_id] => Array
(
[0] => 25869478
)
[listing_image] => Array
(
[0] => 25869478
[1] => 25869479
[2] => 25869480
[3] => 25869481
[4] => 25869482
[5] => 25869483
[6] => 25869484
[7] => 25869485
[8] => 25869486
[9] => 25869487
[10] => 25869488
[11] => 25869489
[12] => 25869490
[13] => 25869491
[14] => 25869492
[15] => 25869493
[16] => 25869494
[17] => 25869495
[18] => 25869496
[19] => 25869497
[20] => 25869498
[21] => 25869499
[22] => 25869500
[23] => 25869501
[24] => 25869502
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] => Other
)
[SpecialListingConditions] => Array
(
[0] => None
)
)
- View: Mountain,Other
- Listing Office: Hawaii Homes International
- Maintenance Fees: $0
- Land Tenure: FS - Fee Simple
