59-023 Holawa Street Unit C Haleiwa, HI 96712

Listing
Overview

Price: $6,999,999
Area: SUNSET AREA
Status: Active

PRICE REDUCTION! This spectacular ocean front sits at the tip of Sunset Point, protected behind a LEGAL sea wall with direct beach access. Very private and set blocks back from traffic and the noise of Kamehameha Highway. Designed by multi award winning architect Joseph Lancor, the construction is like no other. The welded steel structure hidden inside the walls allows for a large open space living, dining and kitchen area with unobstructed views of Kaena Point, Sunset Beach and the Koolau mountains. Watch world class surfing at Backyards and Sunset Beach through the large glass windows or enjoy them from the lanai. Upstairs: Open living area, large ocean-view primary bedroom with ensuite, and a secondary ensuite bedroom/office with full laundry. Downstairs: Three bedrooms with ocean views and lanais, large laundry, large backyard and 2 two-car garages. Split AC throughout entire home. Listing by: Sterman Realty (808) 637-6200

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202319891"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "59-023"
  }
  ["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) "C"
  }
  ["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) "6999999.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    string(10) "6999999.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(11) "SUNSET AREA"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(899) "PRICE REDUCTION! This spectacular ocean front sits at the tip of Sunset Point, protected behind a LEGAL sea wall with direct beach access. Very private and set blocks back from traffic and the noise of Kamehameha Highway. Designed by multi award winning architect Joseph Lancor, the construction is like no other. The welded steel structure hidden inside the walls allows for a large
open space living, dining and kitchen area with unobstructed views of Kaena Point, Sunset Beach and the Koolau mountains. Watch world class surfing at Backyards and Sunset Beach through the large glass windows or enjoy them from the lanai. Upstairs: Open living area, large ocean-view primary bedroom with ensuite, and a secondary ensuite bedroom/office with full laundry. Downstairs: Three bedrooms with ocean views and lanais, large laundry, large backyard and 2 two-car garages. Split AC throughout entire home."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(14) "Sterman Realty"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "5"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "5"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(8) "10571.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "3773"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1989"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(9) "Excellent"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "5"
  }
  ["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) "sophia@sterman.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 637-6200"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(15) "Sophia L Miller"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2024-08-07T13:11:18.510"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "17519312"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(23) "2023-08-24T10:20:33.953"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(11) "North Shore"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(17) "Ocean,Sandy Beach"
  }
  ["SpecialListingConditions"]=>
  array(1) {
    [0]=>
    string(25) "Subject To Repl. Property"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "25950317"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "25950317"
    [1]=>
    string(8) "25950318"
    [2]=>
    string(8) "25950319"
    [3]=>
    string(8) "25950320"
    [4]=>
    string(8) "25950321"
    [5]=>
    string(8) "25950322"
    [6]=>
    string(8) "25950323"
    [7]=>
    string(8) "25950324"
    [8]=>
    string(8) "25950325"
    [9]=>
    string(8) "25950326"
    [10]=>
    string(8) "25950327"
    [11]=>
    string(8) "25950328"
    [12]=>
    string(8) "25950329"
    [13]=>
    string(8) "25950330"
    [14]=>
    string(8) "25950331"
    [15]=>
    string(8) "25950332"
    [16]=>
    string(8) "25950333"
    [17]=>
    string(8) "25950334"
    [18]=>
    string(8) "25950335"
    [19]=>
    string(8) "25950336"
    [20]=>
    string(8) "25950337"
    [21]=>
    string(8) "25950338"
    [22]=>
    string(8) "25950339"
    [23]=>
    string(8) "25950340"
    [24]=>
    string(8) "25950341"
    [25]=>
    string(8) "25950342"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202319891
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => PRICE REDUCTION! This spectacular ocean front sits at the tip of Sunset Point, protected behind a LEGAL sea wall with direct beach access. Very private and set blocks back from traffic and the noise of Kamehameha Highway. Designed by multi award winning architect Joseph Lancor, the construction is like no other. The welded steel structure hidden inside the walls allows for a large
open space living, dining and kitchen area with unobstructed views of Kaena Point, Sunset Beach and the Koolau mountains. Watch world class surfing at Backyards and Sunset Beach through the large glass windows or enjoy them from the lanai. Upstairs: Open living area, large ocean-view primary bedroom with ensuite, and a secondary ensuite bedroom/office with full laundry. Downstairs: Three bedrooms with ocean views and lanais, large laundry, large backyard and 2 two-car garages. Split AC throughout entire home.
        )

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 637-6200
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2024-08-07T13:11:18.510
        )

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

    [OriginalEntryTimestamp] => Array
        (
            [0] => 2023-08-24T10:20:33.953
        )

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

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

    [SpecialListingConditions] => Array
        (
            [0] => Subject To Repl. Property
        )

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

    [listing_image] => Array
        (
            [0] => 25950317
            [1] => 25950318
            [2] => 25950319
            [3] => 25950320
            [4] => 25950321
            [5] => 25950322
            [6] => 25950323
            [7] => 25950324
            [8] => 25950325
            [9] => 25950326
            [10] => 25950327
            [11] => 25950328
            [12] => 25950329
            [13] => 25950330
            [14] => 25950331
            [15] => 25950332
            [16] => 25950333
            [17] => 25950334
            [18] => 25950335
            [19] => 25950336
            [20] => 25950337
            [21] => 25950338
            [22] => 25950339
            [23] => 25950340
            [24] => 25950341
            [25] => 25950342
        )

)

  • BedsTotal: 5
  • Full Baths: 5
  • Land Area (sf): 10,571
  • Living (sf): 3,773
  • Year Built: 1989

  • Property Condition: Excellent
  • Number of Parking Spaces: 5
  • 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