Our office will be closed on November 28 and 29, 2024, for Thanksgiving and the Day After Thanksgiving.
64-486 Kamehameha Highway Unit 33-A Haleiwa, HI 96712
Listing Overview
Price: $6,000,000 Area: GOVT/AG Status: Active
10 Acres of Panoramic Views in Haleiwa offers agricultural land set against the backdrop of the North Shore’s rolling hills and coastal vistas. Conveniently located above Haleiwa town and easy access to the vibrant surroundings, this property offers both tranquility and potential with ten incomparable acres known as the North Coast of Haleiwa Country Estates.
As part of the County’s AG-1 zone and Important Agricultural Lands (IAL) designation, this land enjoys lower property taxes and permit advantages. Its location within the Enterprise Zone (EZ) further enhances its appeal with potential state tax benefits providing a bespoke opportunity to create a Sustainable oasis in Oahu’s most desirable regions. Listing by: Deep Blue HI (808) 699-9159
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202423653"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "64-486"
}
["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(4) "33-A"
}
["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(0) ""
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "6000000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "6000000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "GOVT/AG"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(720) "10 Acres of Panoramic Views in Haleiwa offers agricultural land set against the backdrop of the North Shore’s rolling hills and coastal vistas. Conveniently located above Haleiwa town and easy access to the vibrant surroundings, this property offers both tranquility and potential with ten incomparable acres known as the North Coast of Haleiwa Country Estates.
As part of the County’s AG-1 zone and Important Agricultural Lands (IAL) designation, this land enjoys lower property taxes and permit advantages. Its location within the Enterprise Zone (EZ) further enhances its appeal with potential state tax benefits providing a bespoke opportunity to create a Sustainable oasis in Oahu’s most desirable regions."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(12) "Deep Blue HI"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(0) ""
}
["BathsFull"]=>
array(1) {
[0]=>
string(0) ""
}
["BathsHalf"]=>
array(1) {
[0]=>
string(0) ""
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(9) "435600.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(39) "Coastline,Mountain,Ocean,Sunrise,Sunset"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "281.55"
}
["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) "EKEY"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(19) "paul@deepbluehi.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 699-9159"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(13) "Paul B Stukin"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-10-14T07:47:55.397"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18316565"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-10-10T07:57:29.583"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(11) "North Shore"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(5) "Ocean"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26729921"
}
["listing_image"]=>
array(9) {
[0]=>
string(8) "26729921"
[1]=>
string(8) "26729922"
[2]=>
string(8) "26729923"
[3]=>
string(8) "26729924"
[4]=>
string(8) "26729925"
[5]=>
string(8) "26729926"
[6]=>
string(8) "26729927"
[7]=>
string(8) "26729928"
[8]=>
string(8) "26729929"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202423653
)
[StreetNumber] => Array
(
[0] => 64-486
)
[PropertyType] => Array
(
[0] => Lots/Acres/Farms
)
[StreetName] => Array
(
[0] => Kamehameha
)
[StreetSuffix] => Array
(
[0] => Highway
)
[UnitNumber] => Array
(
[0] => 33-A
)
[City] => Array
(
[0] => Haleiwa
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96712
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 6000000.00
)
[CurrentPrice] => Array
(
[0] => 6000000.00
)
[Neighbourhood] => Array
(
[0] => GOVT/AG
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => 10 Acres of Panoramic Views in Haleiwa offers agricultural land set against the backdrop of the North Shore’s rolling hills and coastal vistas. Conveniently located above Haleiwa town and easy access to the vibrant surroundings, this property offers both tranquility and potential with ten incomparable acres known as the North Coast of Haleiwa Country Estates.
As part of the County’s AG-1 zone and Important Agricultural Lands (IAL) designation, this land enjoys lower property taxes and permit advantages. Its location within the Enterprise Zone (EZ) further enhances its appeal with potential state tax benefits providing a bespoke opportunity to create a Sustainable oasis in Oahu’s most desirable regions.
)
[ListOfficeName] => Array
(
[0] => Deep Blue HI
)
[BedsTotal] => Array
(
[0] =>
)
[BathsFull] => Array
(
[0] =>
)
[BathsHalf] => Array
(
[0] =>
)
[LotSizeArea] => Array
(
[0] => 435600.00
)
[SqftTotal] => Array
(
[0] =>
)
[YearBuilt] => Array
(
[0] =>
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] =>
)
[ParkingTotal] => Array
(
[0] =>
)
[StoriesType] => Array
(
[0] =>
)
[View] => Array
(
[0] => Coastline,Mountain,Ocean,Sunrise,Sunset
)
[MaintenanceExpense] => Array
(
[0] => 281.55
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => EKEY
)
[ListAgentEmail] => Array
(
[0] => paul@deepbluehi.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 699-9159
)
[ListAgentFullName] => Array
(
[0] => Paul B Stukin
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-10-14T07:47:55.397
)
[Matrix_Unique_ID] => Array
(
[0] => 18316565
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-10-10T07:57:29.583
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] => Ocean
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26729921
)
[listing_image] => Array
(
[0] => 26729921
[1] => 26729922
[2] => 26729923
[3] => 26729924
[4] => 26729925
[5] => 26729926
[6] => 26729927
[7] => 26729928
[8] => 26729929
)
)