59-056B Kamehameha Highway Unit 59-56B-1 Haleiwa, HI 96712

Listing
Overview

Price: $2,950,000
Area: SUNSET AREA
Status: Active

SPECTACULAR and one of a kind 2.6 ACRE lot overlooking Sunset Beach with views to Kaena Point!! With the beautiful Koolau Mountains behind and ocean views in front, this property is completely surrounded by all that makes country living so special. Bring your ideas and imagination to build your dream home in one of the most highly sought after areas of the North Shore. *Boundary lines on the drone aerial photos are just ESTIMATED locations. See CPR map or in person to know exact boundaries. **Please note that the CPR of this property was VERY recently completed so the assessed value and monthly taxes are accumulative between this lot and neighboring lot and will reflect differently once city comes up with valuation. Listing by: Sterman Realty (808) 780-5673 

array(48) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202419170"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(7) "59-056B"
  }
  ["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) "59-56B-1"
  }
  ["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) "2950000.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    string(10) "3250000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(11) "SUNSET AREA"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(725) "SPECTACULAR and one of a kind 2.6 ACRE lot overlooking Sunset Beach with views to Kaena Point!! With the beautiful Koolau Mountains behind and ocean views in front, this property is completely surrounded by all that makes country living so special. Bring your ideas and imagination to build your dream home in one of the most highly sought after areas of the North Shore. *Boundary lines on the drone aerial photos are just ESTIMATED locations. See CPR map or in person to know exact boundaries. **Please note that the CPR of this property was VERY recently completed so the assessed value and monthly taxes are accumulative between this lot and neighboring lot and will reflect differently once city comes up with valuation."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(14) "Sterman Realty"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(9) "113256.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(21) "Mountain,Ocean,Sunset"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["LandTenure"]=>
  array(1) {
    [0]=>
    string(15) "FS - Fee Simple"
  }
  ["ElementarySchool"]=>
  array(1) {
    [0]=>
    string(12) "Sunset Beach"
  }
  ["MiddleOrJuniorSchool"]=>
  array(1) {
    [0]=>
    string(6) "Kahuku"
  }
  ["HighSchool"]=>
  array(1) {
    [0]=>
    string(6) "Kahuku"
  }
  ["ListOfficeMLSID"]=>
  array(1) {
    [0]=>
    string(4) "STER"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(18) "sophia@sterman.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 780-5673"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(15) "Sophia L Miller"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-02-10T07:29:48.667"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18227161"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(23) "2024-08-31T19:52:57.440"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(11) "North Shore"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["SpecialListingConditions"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26678273"
  }
  ["listing_image"]=>
  array(11) {
    [0]=>
    string(8) "26678273"
    [1]=>
    string(8) "26678274"
    [2]=>
    string(8) "26678275"
    [3]=>
    string(8) "26678276"
    [4]=>
    string(8) "26678277"
    [5]=>
    string(8) "26678278"
    [6]=>
    string(8) "26695547"
    [7]=>
    string(8) "26695548"
    [8]=>
    string(8) "26695549"
    [9]=>
    string(8) "26695550"
    [10]=>
    string(8) "26695551"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2024-08-29"
  }
  ["ExemptListingEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "07:29:48.667"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202419170
        )

    [StreetNumber] => Array
        (
            [0] => 59-056B
        )

    [PropertyType] => Array
        (
            [0] => Lots/Acres/Farms
        )

    [StreetName] => Array
        (
            [0] => Kamehameha
        )

    [StreetSuffix] => Array
        (
            [0] => Highway
        )

    [UnitNumber] => Array
        (
            [0] => 59-56B-1
        )

    [City] => Array
        (
            [0] => Haleiwa
        )

    [StateOrProvince] => Array
        (
            [0] => HI
        )

    [PostalCode] => Array
        (
            [0] => 96712
        )

    [VirtualTourURLUnbranded] => Array
        (
            [0] => 
        )

    [ListPrice] => Array
        (
            [0] => 2950000.00
        )

    [CurrentPrice] => Array
        (
            [0] => 3250000.00
        )

    [Neighbourhood] => Array
        (
            [0] => SUNSET AREA
        )

    [Status] => Array
        (
            [0] => Active
        )

    [PublicRemarks] => Array
        (
            [0] => SPECTACULAR and one of a kind 2.6 ACRE lot overlooking Sunset Beach with views to Kaena Point!! With the beautiful Koolau Mountains behind and ocean views in front, this property is completely surrounded by all that makes country living so special. Bring your ideas and imagination to build your dream home in one of the most highly sought after areas of the North Shore. *Boundary lines on the drone aerial photos are just ESTIMATED locations. See CPR map or in person to know exact boundaries. **Please note that the CPR of this property was VERY recently completed so the assessed value and monthly taxes are accumulative between this lot and neighboring lot and will reflect differently once city comes up with valuation.
        )

    [ListOfficeName] => Array
        (
            [0] => Sterman Realty
        )

    [BedsTotal] => Array
        (
            [0] => 
        )

    [BathsFull] => Array
        (
            [0] => 
        )

    [BathsHalf] => Array
        (
            [0] => 
        )

    [LotSizeArea] => Array
        (
            [0] => 113256.00
        )

    [SqftTotal] => Array
        (
            [0] => 
        )

    [YearBuilt] => Array
        (
            [0] => 
        )

    [BuildingName] => Array
        (
            [0] => 
        )

    [PropertyCondition] => Array
        (
            [0] => 
        )

    [ParkingTotal] => Array
        (
            [0] => 
        )

    [StoriesType] => Array
        (
            [0] => 
        )

    [View] => Array
        (
            [0] => Mountain,Ocean,Sunset
        )

    [MaintenanceExpense] => Array
        (
            [0] => 
        )

    [LandTenure] => Array
        (
            [0] => FS - Fee Simple
        )

    [ElementarySchool] => Array
        (
            [0] => Sunset Beach
        )

    [MiddleOrJuniorSchool] => Array
        (
            [0] => Kahuku
        )

    [HighSchool] => Array
        (
            [0] => Kahuku
        )

    [ListOfficeMLSID] => Array
        (
            [0] => STER
        )

    [ListAgentEmail] => Array
        (
            [0] => sophia@sterman.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 780-5673
        )

    [ListAgentFullName] => Array
        (
            [0] => Sophia L Miller
        )

    [CloseDate] => Array
        (
            [0] => 
        )

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-02-10T07:29:48.667
        )

    [Matrix_Unique_ID] => Array
        (
            [0] => 18227161
        )

    [OriginalEntryTimestamp] => Array
        (
            [0] => 2024-08-31T19:52:57.440
        )

    [MLSAreaMajor] => Array
        (
            [0] => North Shore
        )

    [PropertyFrontage] => Array
        (
            [0] => 
        )

    [SpecialListingConditions] => Array
        (
            [0] => None
        )

    [_thumbnail_id] => Array
        (
            [0] => 26678273
        )

    [listing_image] => Array
        (
            [0] => 26678273
            [1] => 26678274
            [2] => 26678275
            [3] => 26678276
            [4] => 26678277
            [5] => 26678278
            [6] => 26695547
            [7] => 26695548
            [8] => 26695549
            [9] => 26695550
            [10] => 26695551
        )

    [ListingContractDate] => Array
        (
            [0] => 2024-08-29
        )

    [ExemptListingEntryTimestamp] => Array
        (
            [0] => 
        )

    [MatrixModifiedTime] => Array
        (
            [0] => 07:29:48.667
        )

)

  • Land Area (sf): 113,256 sf

  • View: Mountain,Ocean,Sunset
  • Listing Office: Sterman Realty

  • Land Tenure: FS - Fee Simple

  • Elementary School: Sunset Beach
  • Middle School: Kahuku
  • High School: Kahuku

CONTACT US

Marcus Realty

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

Based on information from the Multiple Listing Service of HiCentral MLS, Ltd. listings last updated on February 10, 2025 - 7:29 AM Information is deemed reliable but not guaranteed. Copyright: 2025 by HiCentral MLS, Ltd.
Some of the active listings appearing on this site may be listed by other REALTORS®. If you are interested in those active listings, our company may represent you as the buyer's agent. If the active listing you are interested in is our company's active listing, you may speak to one of our agents regarding your options for representation.

Terms of Use Privacy Policy DMCA Policy
© Marcus Realty. All Rights Reserved.