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
        )

)

  • Land Area (sf): 217,800

  • View: Coastline,Mountain,Ocean
  • Listing Office: Deep Blue HI

  • Maintenance Fees: $141
  • Land Tenure: FS - Fee Simple

CONTACT US

Marcus Realty

#RB-7120
info@marcushawaii.com
(808)839-7446