Our office will be closed on November 28 and 29, 2024, for Thanksgiving and the Day After Thanksgiving.
64-486 Kamehameha Highway Unit 33-B Haleiwa, HI 96712
Listing Overview
Price: $2,500,000 Area: GOVT/AG Status: Active
Makai Ridge offers 5 acres of pristine agricultural land, perfectly positioned in the countryside overlooking Haleiwa coastline. With sweeping views of the North Shore, this property is an ideal haven for those looking for peace, privacy, and natural beauty. Surrounded by lush landscapes and open skies, this parcel is one of three gems in The Haleiwa Country Estates community, the perfect backdrop for whatever vision you may have.
Benefiting from Important Agricultural Lands (IAL) designation and County AG-1 zoning, Lot B comes with significant tax and permit advantages. The property is also located within the Enterprise Zone (EZ), offering state tax incentives. With endless possibilities, this lot is an incredible opportunity for those seeking a peaceful slice of Hawaii. Listing by: Deep Blue HI (808) 699-9159
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202423660"
}
["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-B"
}
["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) "2500000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "2500000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "GOVT/AG"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(785) "Makai Ridge offers 5 acres of pristine agricultural land, perfectly positioned in the countryside overlooking Haleiwa coastline. With sweeping views of the North Shore, this property is an ideal haven for those looking for peace, privacy, and natural beauty. Surrounded by lush landscapes and open skies, this parcel is one of three gems in The Haleiwa Country Estates community, the perfect backdrop for whatever vision you may have.
Benefiting from Important Agricultural Lands (IAL) designation and County AG-1 zoning, Lot B comes with significant tax and permit advantages. The property is also located within the Enterprise Zone (EZ), offering state tax incentives. With endless possibilities, this lot is an incredible opportunity for those seeking a peaceful slice of Hawaii."
}
["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) "217800.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) "140.78"
}
["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:27.637"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18316720"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-10-10T07:57:57.617"
}
["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) "26729931"
}
["listing_image"]=>
array(10) {
[0]=>
string(8) "26729931"
[1]=>
string(8) "26729932"
[2]=>
string(8) "26729933"
[3]=>
string(8) "26729934"
[4]=>
string(8) "26729935"
[5]=>
string(8) "26729936"
[6]=>
string(8) "26729937"
[7]=>
string(8) "26729938"
[8]=>
string(8) "26729939"
[9]=>
string(8) "26729940"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202423660
)
[StreetNumber] => Array
(
[0] => 64-486
)
[PropertyType] => Array
(
[0] => Lots/Acres/Farms
)
[StreetName] => Array
(
[0] => Kamehameha
)
[StreetSuffix] => Array
(
[0] => Highway
)
[UnitNumber] => Array
(
[0] => 33-B
)
[City] => Array
(
[0] => Haleiwa
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96712
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 2500000.00
)
[CurrentPrice] => Array
(
[0] => 2500000.00
)
[Neighbourhood] => Array
(
[0] => GOVT/AG
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Makai Ridge offers 5 acres of pristine agricultural land, perfectly positioned in the countryside overlooking Haleiwa coastline. With sweeping views of the North Shore, this property is an ideal haven for those looking for peace, privacy, and natural beauty. Surrounded by lush landscapes and open skies, this parcel is one of three gems in The Haleiwa Country Estates community, the perfect backdrop for whatever vision you may have.
Benefiting from Important Agricultural Lands (IAL) designation and County AG-1 zoning, Lot B comes with significant tax and permit advantages. The property is also located within the Enterprise Zone (EZ), offering state tax incentives. With endless possibilities, this lot is an incredible opportunity for those seeking a peaceful slice of Hawaii.
)
[ListOfficeName] => Array
(
[0] => Deep Blue HI
)
[BedsTotal] => Array
(
[0] =>
)
[BathsFull] => Array
(
[0] =>
)
[BathsHalf] => Array
(
[0] =>
)
[LotSizeArea] => Array
(
[0] => 217800.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] => 140.78
)
[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:27.637
)
[Matrix_Unique_ID] => Array
(
[0] => 18316720
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-10-10T07:57:57.617
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] => Ocean
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26729931
)
[listing_image] => Array
(
[0] => 26729931
[1] => 26729932
[2] => 26729933
[3] => 26729934
[4] => 26729935
[5] => 26729936
[6] => 26729937
[7] => 26729938
[8] => 26729939
[9] => 26729940
)
)
