Listing
Overview
Price: $995,000
Area: HALEIWA
Status: Active
1.7 acres of Haleiwa Stream Front Kuleana land, which allows 1 farm home up to 5,000 sqft. on the 1st floor and A 2nd floor. Can also build supporting AG structures. Perfect for grazing and or farming. Direct stream front for prawn fishing and fun. Paddleboard or kayak from the river to Haleiwa Harbor and Beach Park for fun in the sun. Additional 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 custom home. Ten-minute bike ride to the center of Haleiwa town. Easy access to Kam Hwy and no north shore traffic. Price includes road, electrical access & freshwater line stub when and if completed. Listing by: Hawaii Homes International
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202220143"
}
["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 35"
}
["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) "995000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(9) "995000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "HALEIWA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(837) "1.7 acres of Haleiwa Stream Front Kuleana land, which allows 1 farm home up to 5,000 sqft. on the 1st floor and A 2nd floor. Can also build supporting AG structures. Perfect for grazing and or farming. Direct stream front for prawn fishing and fun. Paddleboard or kayak from the river to Haleiwa Harbor and Beach Park for fun in the sun. Additional 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 custom home. Ten-minute bike ride to the center of Haleiwa town. Easy access to Kam Hwy and no north shore traffic. Price includes road, electrical access & freshwater line stub when and if completed."
}
["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) "69827.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(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:01.913"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "16907580"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2022-10-06T10:55:56.427"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "25869384"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "25869384"
[1]=>
string(8) "25869385"
[2]=>
string(8) "25869386"
[3]=>
string(8) "25869387"
[4]=>
string(8) "25869388"
[5]=>
string(8) "25869389"
[6]=>
string(8) "25869390"
[7]=>
string(8) "25869391"
[8]=>
string(8) "25869392"
[9]=>
string(8) "25869393"
[10]=>
string(8) "25869394"
[11]=>
string(8) "25869395"
[12]=>
string(8) "25869396"
[13]=>
string(8) "25869397"
[14]=>
string(8) "25869398"
[15]=>
string(8) "25869399"
[16]=>
string(8) "25869400"
[17]=>
string(8) "25869401"
[18]=>
string(8) "25869402"
[19]=>
string(8) "25869403"
[20]=>
string(8) "25869404"
[21]=>
string(8) "25869405"
[22]=>
string(8) "25869406"
[23]=>
string(8) "25869407"
[24]=>
string(8) "25869408"
[25]=>
string(8) "25869409"
}
["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] => 202220143
)
[StreetNumber] => Array
(
[0] => 0000
)
[PropertyType] => Array
(
[0] => Lots/Acres/Farms
)
[StreetName] => Array
(
[0] => Kamehameha
)
[StreetSuffix] => Array
(
[0] => Highway
)
[UnitNumber] => Array
(
[0] => Lot 35
)
[City] => Array
(
[0] => Haleiwa
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96712
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://www.youtube.com/embed/Guqfr5aUTf0
)
[ListPrice] => Array
(
[0] => 995000.00
)
[CurrentPrice] => Array
(
[0] => 995000.00
)
[Neighbourhood] => Array
(
[0] => HALEIWA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => 1.7 acres of Haleiwa Stream Front Kuleana land, which allows 1 farm home up to 5,000 sqft. on the 1st floor and A 2nd floor. Can also build supporting AG structures. Perfect for grazing and or farming. Direct stream front for prawn fishing and fun. Paddleboard or kayak from the river to Haleiwa Harbor and Beach Park for fun in the sun. Additional 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 custom home. Ten-minute bike ride to the center of Haleiwa town. Easy access to Kam Hwy and no north shore traffic. Price includes road, electrical access & freshwater line stub when and if completed.
)
[ListOfficeName] => Array
(
[0] => Hawaii Homes International
)
[BedsTotal] => Array
(
[0] =>
)
[BathsFull] => Array
(
[0] =>
)
[BathsHalf] => Array
(
[0] =>
)
[LotSizeArea] => Array
(
[0] => 69827.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] =>
)
[ListAgentFullName] => Array
(
[0] => Ralph S Gray
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2023-09-29T16:36:01.913
)
[Matrix_Unique_ID] => Array
(
[0] => 16907580
)
[OriginalEntryTimestamp] => Array
(
[0] => 2022-10-06T10:55:56.427
)
[_thumbnail_id] => Array
(
[0] => 25869384
)
[listing_image] => Array
(
[0] => 25869384
[1] => 25869385
[2] => 25869386
[3] => 25869387
[4] => 25869388
[5] => 25869389
[6] => 25869390
[7] => 25869391
[8] => 25869392
[9] => 25869393
[10] => 25869394
[11] => 25869395
[12] => 25869396
[13] => 25869397
[14] => 25869398
[15] => 25869399
[16] => 25869400
[17] => 25869401
[18] => 25869402
[19] => 25869403
[20] => 25869404
[21] => 25869405
[22] => 25869406
[23] => 25869407
[24] => 25869408
[25] => 25869409
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] => Other
)
[SpecialListingConditions] => Array
(
[0] => None
)
)
- View: Mountain,Other
- Listing Office: Hawaii Homes International
- Land Tenure: FS - Fee Simple