Previous Next

59-001 Holawa Street Unit K Haleiwa, HI 96712

Listing
Overview

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

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202528407"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "59-001"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(13) "Single Family"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(6) "Holawa"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(6) "Street"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(1) "K"
  }
  ["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) "4950000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(11) "SUNSET AREA"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(952) "Live the Dream at Sunset Point! Experience Hawaii lifestyle and endless sunsets in this beautiful beachfront home, fronting one of the most iconic surf breaks in the world. With direct access to Sunset Beach and unobstructed views of the legendary waves at Backyards and Sunset Point, you'll have a front-row seat to world-class surfing from your lanai.

Tucked within the private, gated community of Sunset Paumalu Estates, this 2,509 sq ft home sits on a 5,208 sq ft lot with over 60 feet of beachfront. Enjoy stunning sunsets, a lush beachfront yard with native plants, and a protective reef that helps preserve the shoreline. Whether you're watching pros charge the winter swells or enjoying tranquil summer beach days, the ocean is always the centerpiece.

Sold "as-is". One of the best beachfront values on Oahu's North Shore. Opportunity to customize your dream home. Tax records reflect 3 bedrooms 2.5 baths. Buyer to conduct due diligence."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(14) "Sterman Realty"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(7) "5208.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "2509"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1980"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(7) "Average"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "Two"
  }
  ["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) "nicole@sterman.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 797-9122"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(24) "Nicole Lee Carter-Zimmer"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "19184884"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2026-01-01T11:00:12.957"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2026-01-01"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(11) "North Shore"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(28) "Ocean,Sandy Beach,Waterfront"
  }
  ["ExemptListingEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "11:00:12.957"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27258502"
  }
  ["listing_image"]=>
  array(19) {
    [0]=>
    string(8) "27258502"
    [1]=>
    string(8) "27258503"
    [2]=>
    string(8) "27258504"
    [3]=>
    string(8) "27258505"
    [4]=>
    string(8) "27258506"
    [5]=>
    string(8) "27258507"
    [6]=>
    string(8) "27258508"
    [7]=>
    string(8) "27258509"
    [8]=>
    string(8) "27258510"
    [9]=>
    string(8) "27258511"
    [10]=>
    string(8) "27258512"
    [11]=>
    string(8) "27258513"
    [12]=>
    string(8) "27258514"
    [13]=>
    string(8) "27258515"
    [14]=>
    string(8) "27258516"
    [15]=>
    string(8) "27258517"
    [16]=>
    string(8) "27258518"
    [17]=>
    string(8) "27258519"
    [18]=>
    string(8) "27258520"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202528407
        )

    [StreetNumber] => Array
        (
            [0] => 59-001
        )

    [PropertyType] => Array
        (
            [0] => Single Family
        )

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

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

    [UnitNumber] => Array
        (
            [0] => K
        )

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Live the Dream at Sunset Point! Experience Hawaii lifestyle and endless sunsets in this beautiful beachfront home, fronting one of the most iconic surf breaks in the world. With direct access to Sunset Beach and unobstructed views of the legendary waves at Backyards and Sunset Point, you'll have a front-row seat to world-class surfing from your lanai.

Tucked within the private, gated community of Sunset Paumalu Estates, this 2,509 sq ft home sits on a 5,208 sq ft lot with over 60 feet of beachfront. Enjoy stunning sunsets, a lush beachfront yard with native plants, and a protective reef that helps preserve the shoreline. Whether you're watching pros charge the winter swells or enjoying tranquil summer beach days, the ocean is always the centerpiece.

Sold "as-is". One of the best beachfront values on Oahu's North Shore. Opportunity to customize your dream home. Tax records reflect 3 bedrooms 2.5 baths. Buyer to conduct due diligence.
        )

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

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

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

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

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

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

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

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

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

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

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

    [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] => nicole@sterman.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 797-9122
        )

    [ListAgentFullName] => Array
        (
            [0] => Nicole Lee Carter-Zimmer
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2026-01-01T11:00:12.957
        )

    [ListingContractDate] => Array
        (
            [0] => 2026-01-01
        )

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

    [PropertyFrontage] => Array
        (
            [0] => Ocean,Sandy Beach,Waterfront
        )

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

    [MatrixModifiedTime] => Array
        (
            [0] => 11:00:12.957
        )

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

    [listing_image] => Array
        (
            [0] => 27258502
            [1] => 27258503
            [2] => 27258504
            [3] => 27258505
            [4] => 27258506
            [5] => 27258507
            [6] => 27258508
            [7] => 27258509
            [8] => 27258510
            [9] => 27258511
            [10] => 27258512
            [11] => 27258513
            [12] => 27258514
            [13] => 27258515
            [14] => 27258516
            [15] => 27258517
            [16] => 27258518
            [17] => 27258519
            [18] => 27258520
        )

)

PROPERTY INFO

• BedsTotal: 3
• Full Baths: 2
• Half Baths: 1
• Land Area (sf): 5,208 sf
• Living (sf): 2,509
• Year Built: 1980

KEY FEATURES

• Property Condition: Average
• Number of Parking Spaces: 4
• View: Mountain,Ocean,Sunset
• Listing Office: Sterman Realty

FINANCIAL INFO

• Land Tenure: FS - Fee Simple

SCHOOLS

• 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 January 1, 2026 - 11:00 AM Information is deemed reliable but not guaranteed. Copyright: 2026 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.