Listing
Overview
Price: $850,000
Area: HALEIWA
Status: Active
Haleiwa Anahulu Stream front with 1.678 acres, fruit trees, water tank, a yurt, outside heated shower and small guest shed. This is a Kuleana parcel, which allows 1 farm dwelling up to 5,000 sqft on the 1st floor and can have a second floor and supporting AG sheds and structures. Perfect for farming or grazing. Private gated community with one way in and out. Paddleboard or kayak from the river to Haleiwa Harbor and Beach Park for fun in the sun. You can hike for miles into the mountains along the stream. 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 farm or yoga retreat. Enjoy the yurt and the land while you design your custom farm dwelling. Ten-minute bike ride to the center of Haleiwa town. Easy access to Kamehameha Hwy and no North Shore traffic. A magical place in the Anahulu Valley. Listing by: Hawaii Homes International
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202306793"
}
["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 38"
}
["City"]=>
array(1) {
[0]=>
string(7) "Haleiwa"
}
["StateOrProvince"]=>
array(1) {
[0]=>
string(2) "HI"
}
["PostalCode"]=>
array(1) {
[0]=>
string(5) "96712"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(41) "https://www.youtube.com/embed/Guqfr5aUTf0"
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "850000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(9) "850000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "HALEIWA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(913) "Haleiwa Anahulu Stream front with 1.678 acres, fruit trees, water tank, a yurt, outside heated shower and small guest shed. This is a Kuleana parcel, which allows 1 farm dwelling up to 5,000 sqft on the 1st floor and can have a second floor and supporting AG sheds and structures. Perfect for farming or grazing. Private gated community with one way in and out. Paddleboard or kayak from the river to Haleiwa Harbor and Beach Park for fun in the sun. You can hike for miles into the mountains along the stream. 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 farm or yoga retreat. Enjoy the yurt and the land while you design your custom farm dwelling. Ten-minute bike ride to the center of Haleiwa town. Easy access to Kamehameha Hwy and no North Shore traffic. A magical place in the Anahulu Valley."
}
["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) "73094.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:37:40.040"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "17227729"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2023-04-03T12:28:09.230"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "25869842"
}
["listing_image"]=>
array(25) {
[0]=>
string(8) "25869842"
[1]=>
string(8) "25869843"
[2]=>
string(8) "25869844"
[3]=>
string(8) "25869845"
[4]=>
string(8) "25869846"
[5]=>
string(8) "25869847"
[6]=>
string(8) "25869848"
[7]=>
string(8) "25869849"
[8]=>
string(8) "25869850"
[9]=>
string(8) "25869851"
[10]=>
string(8) "25869852"
[11]=>
string(8) "25869853"
[12]=>
string(8) "25869854"
[13]=>
string(8) "25869855"
[14]=>
string(8) "25869856"
[15]=>
string(8) "25869857"
[16]=>
string(8) "25869858"
[17]=>
string(8) "25869859"
[18]=>
string(8) "25869860"
[19]=>
string(8) "25869861"
[20]=>
string(8) "25869862"
[21]=>
string(8) "25869863"
[22]=>
string(8) "25869864"
[23]=>
string(8) "25869865"
[24]=>
string(8) "25869866"
}
["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] => 202306793
)
[StreetNumber] => Array
(
[0] => 0000
)
[PropertyType] => Array
(
[0] => Lots/Acres/Farms
)
[StreetName] => Array
(
[0] => Kamehameha
)
[StreetSuffix] => Array
(
[0] => Highway
)
[UnitNumber] => Array
(
[0] => Lot 38
)
[City] => Array
(
[0] => Haleiwa
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96712
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://www.youtube.com/embed/Guqfr5aUTf0
)
[ListPrice] => Array
(
[0] => 850000.00
)
[CurrentPrice] => Array
(
[0] => 850000.00
)
[Neighbourhood] => Array
(
[0] => HALEIWA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Haleiwa Anahulu Stream front with 1.678 acres, fruit trees, water tank, a yurt, outside heated shower and small guest shed. This is a Kuleana parcel, which allows 1 farm dwelling up to 5,000 sqft on the 1st floor and can have a second floor and supporting AG sheds and structures. Perfect for farming or grazing. Private gated community with one way in and out. Paddleboard or kayak from the river to Haleiwa Harbor and Beach Park for fun in the sun. You can hike for miles into the mountains along the stream. 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 farm or yoga retreat. Enjoy the yurt and the land while you design your custom farm dwelling. Ten-minute bike ride to the center of Haleiwa town. Easy access to Kamehameha Hwy and no North Shore traffic. A magical place in the Anahulu Valley.
)
[ListOfficeName] => Array
(
[0] => Hawaii Homes International
)
[BedsTotal] => Array
(
[0] =>
)
[BathsFull] => Array
(
[0] =>
)
[BathsHalf] => Array
(
[0] =>
)
[LotSizeArea] => Array
(
[0] => 73094.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:37:40.040
)
[Matrix_Unique_ID] => Array
(
[0] => 17227729
)
[OriginalEntryTimestamp] => Array
(
[0] => 2023-04-03T12:28:09.230
)
[_thumbnail_id] => Array
(
[0] => 25869842
)
[listing_image] => Array
(
[0] => 25869842
[1] => 25869843
[2] => 25869844
[3] => 25869845
[4] => 25869846
[5] => 25869847
[6] => 25869848
[7] => 25869849
[8] => 25869850
[9] => 25869851
[10] => 25869852
[11] => 25869853
[12] => 25869854
[13] => 25869855
[14] => 25869856
[15] => 25869857
[16] => 25869858
[17] => 25869859
[18] => 25869860
[19] => 25869861
[20] => 25869862
[21] => 25869863
[22] => 25869864
[23] => 25869865
[24] => 25869866
)
[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
