Our office will be closed on Monday, November 11th, 2024.
64-486 Kamehameha Highway Unit 33C Haleiwa, HI 96712
Listing Overview
Price: $3,500,000 Area: GOVT/AG Status: Active
Mauka Ridge represents the ultimate in North Shore luxury, offering 5 acres of stunning agricultural land with breathtaking views of the picturesque mountain ridgeline, Haleiwa town and the ocean beyond. This exclusive parcel is one of three gems in Haleiwa Country Estates, providing the perfect setting for an elevated lifestyle or investment opportunity.
Located within the County’s AG-1 zone and designated as Important Agricultural Lands (IAL), this land offers tax benefits and streamlined permit processes. Additionally, being part of the Enterprise Zone (EZ) presents the potential for additional state tax advantages. This is your opportunity to own a remarkable piece of Oahu’s North Shore, where privacy and natural beauty converge. Listing by: Deep Blue HI (808) 699-9159
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202423663"
}
["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(3) "33C"
}
["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) "3500000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "3500000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "GOVT/AG"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(751) "Mauka Ridge represents the ultimate in North Shore luxury, offering 5 acres of stunning agricultural land with breathtaking views of the picturesque mountain ridgeline, Haleiwa town and the ocean beyond. This exclusive parcel is one of three gems in Haleiwa Country Estates, providing the perfect setting for an elevated lifestyle or investment opportunity.
Located within the County’s AG-1 zone and designated as Important Agricultural Lands (IAL), this land offers tax benefits and streamlined permit processes. Additionally, being part of the Enterprise Zone (EZ) presents the potential for additional state tax advantages. This is your opportunity to own a remarkable piece of Oahu’s North Shore, where privacy and natural beauty converge."
}
["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) "142.16"
}
["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:13.887"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18316742"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-10-10T07:58:39.747"
}
["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) "26729942"
}
["listing_image"]=>
array(11) {
[0]=>
string(8) "26729942"
[1]=>
string(8) "26729943"
[2]=>
string(8) "26729944"
[3]=>
string(8) "26729945"
[4]=>
string(8) "26729946"
[5]=>
string(8) "26729947"
[6]=>
string(8) "26729948"
[7]=>
string(8) "26729949"
[8]=>
string(8) "26729950"
[9]=>
string(8) "26729951"
[10]=>
string(8) "26729952"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202423663
)
[StreetNumber] => Array
(
[0] => 64-486
)
[PropertyType] => Array
(
[0] => Lots/Acres/Farms
)
[StreetName] => Array
(
[0] => Kamehameha
)
[StreetSuffix] => Array
(
[0] => Highway
)
[UnitNumber] => Array
(
[0] => 33C
)
[City] => Array
(
[0] => Haleiwa
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96712
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 3500000.00
)
[CurrentPrice] => Array
(
[0] => 3500000.00
)
[Neighbourhood] => Array
(
[0] => GOVT/AG
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Mauka Ridge represents the ultimate in North Shore luxury, offering 5 acres of stunning agricultural land with breathtaking views of the picturesque mountain ridgeline, Haleiwa town and the ocean beyond. This exclusive parcel is one of three gems in Haleiwa Country Estates, providing the perfect setting for an elevated lifestyle or investment opportunity.
Located within the County’s AG-1 zone and designated as Important Agricultural Lands (IAL), this land offers tax benefits and streamlined permit processes. Additionally, being part of the Enterprise Zone (EZ) presents the potential for additional state tax advantages. This is your opportunity to own a remarkable piece of Oahu’s North Shore, where privacy and natural beauty converge.
)
[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] => 142.16
)
[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:13.887
)
[Matrix_Unique_ID] => Array
(
[0] => 18316742
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-10-10T07:58:39.747
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] => Ocean
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26729942
)
[listing_image] => Array
(
[0] => 26729942
[1] => 26729943
[2] => 26729944
[3] => 26729945
[4] => 26729946
[5] => 26729947
[6] => 26729948
[7] => 26729949
[8] => 26729950
[9] => 26729951
[10] => 26729952
)
)
