Our office will be closed on Monday, November 11th, 2024.
64-486 Kamehameha Highway Unit 33 A/B/C Haleiwa, HI 96712
Listing Overview
Price: $12,000,000 Area: GOVT/AG Status: Active
Welcome to Haleiwa Country Estates. 20 acres of top rated, untouched, agricultural land nestled in the mountains above the historic and charming Haleiwa town on Oahu’s North Shore. The unique property is fortified on all three sides offering expansive unobstructed views of the ocean, mountain, and valley, this property delivers an unparalleled sense of serenity and privacy within a gated community of just three parcels, a convenient 30 minutes from Daniel Inouye Airport. Whether you're seeking an escape or an investment, the land offers vast potential amidst stunning natural surroundings.
Located in the County Agricultural Zone (AG-1) and designated as Important Agricultural Lands (IAL), the property provides numerous benefits including favorable tax rates and expedited permit processes. Additionally, its inclusion in the Enterprise Zone (EZ) allows for attractive state tax incentives. This is more than just land; it’s an opportunity to own a piece of paradise with boundless possibilities. Listing by: Deep Blue HI (808) 699-9159
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202423664"
}
["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(8) "33 A/B/C"
}
["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(11) "12000000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(11) "12000000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "GOVT/AG"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1011) "Welcome to Haleiwa Country Estates. 20 acres of top rated, untouched, agricultural land nestled in the mountains above the historic and charming Haleiwa town on Oahu’s North Shore. The unique property is fortified on all three sides offering expansive unobstructed views of the ocean, mountain, and valley, this property delivers an unparalleled sense of serenity and privacy within a gated community of just three parcels, a convenient 30 minutes from Daniel Inouye Airport. Whether you're seeking an escape or an investment, the land offers vast potential amidst stunning natural surroundings.
Located in the County Agricultural Zone (AG-1) and designated as Important Agricultural Lands (IAL), the property provides numerous benefits including favorable tax rates and expedited permit processes. Additionally, its inclusion in the Enterprise Zone (EZ) allows for attractive state tax incentives. This is more than just land; it’s an opportunity to own a piece of paradise with boundless possibilities."
}
["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) "871200.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(24) "Coastline,Mountain,Ocean"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "564.49"
}
["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:48:39.177"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18316763"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-10-10T08:00:29.870"
}
["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) "26729954"
}
["listing_image"]=>
array(10) {
[0]=>
string(8) "26729954"
[1]=>
string(8) "26729955"
[2]=>
string(8) "26729956"
[3]=>
string(8) "26729957"
[4]=>
string(8) "26729958"
[5]=>
string(8) "26729959"
[6]=>
string(8) "26729960"
[7]=>
string(8) "26729961"
[8]=>
string(8) "26729962"
[9]=>
string(8) "26729963"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202423664
)
[StreetNumber] => Array
(
[0] => 64-486
)
[PropertyType] => Array
(
[0] => Lots/Acres/Farms
)
[StreetName] => Array
(
[0] => Kamehameha
)
[StreetSuffix] => Array
(
[0] => Highway
)
[UnitNumber] => Array
(
[0] => 33 A/B/C
)
[City] => Array
(
[0] => Haleiwa
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96712
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 12000000.00
)
[CurrentPrice] => Array
(
[0] => 12000000.00
)
[Neighbourhood] => Array
(
[0] => GOVT/AG
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Welcome to Haleiwa Country Estates. 20 acres of top rated, untouched, agricultural land nestled in the mountains above the historic and charming Haleiwa town on Oahu’s North Shore. The unique property is fortified on all three sides offering expansive unobstructed views of the ocean, mountain, and valley, this property delivers an unparalleled sense of serenity and privacy within a gated community of just three parcels, a convenient 30 minutes from Daniel Inouye Airport. Whether you're seeking an escape or an investment, the land offers vast potential amidst stunning natural surroundings.
Located in the County Agricultural Zone (AG-1) and designated as Important Agricultural Lands (IAL), the property provides numerous benefits including favorable tax rates and expedited permit processes. Additionally, its inclusion in the Enterprise Zone (EZ) allows for attractive state tax incentives. This is more than just land; it’s an opportunity to own a piece of paradise with boundless possibilities.
)
[ListOfficeName] => Array
(
[0] => Deep Blue HI
)
[BedsTotal] => Array
(
[0] =>
)
[BathsFull] => Array
(
[0] =>
)
[BathsHalf] => Array
(
[0] =>
)
[LotSizeArea] => Array
(
[0] => 871200.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
)
[MaintenanceExpense] => Array
(
[0] => 564.49
)
[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:48:39.177
)
[Matrix_Unique_ID] => Array
(
[0] => 18316763
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-10-10T08:00:29.870
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] => Ocean
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26729954
)
[listing_image] => Array
(
[0] => 26729954
[1] => 26729955
[2] => 26729956
[3] => 26729957
[4] => 26729958
[5] => 26729959
[6] => 26729960
[7] => 26729961
[8] => 26729962
[9] => 26729963
)
)
