59-023 Holawa Street Unit C Haleiwa, HI 96712

Listing
Overview

Price: $7,890,000
Area: SUNSET AREA
Status: Active

** PRICE REDUCED ** Located in the highly coveted Sunset Point neighborhood, this spacious home is situated right in the center of the “7 Mile Miracle”. With the notorious surf spot Sunset right out front, Velzyland to the right, and Pipeline to the left, one can not ask for a better location! The upstairs level has a large open kitchen, a dining area, and an airy living room with ocean view. On this level, you will also find a beautiful primary bedroom with a full bathroom with shower and bathtub and breathtaking views, as well as an office/guest room with an additional full bathroom. Downstairs you’ll find three bedrooms, each with ocean views, and three bathrooms, as well as a sizable laundry room. Other valuable features include split AC throughout home, direct beach access, a LEGAL sea wall, large backyard, two separate garages, and more. Luxurious living in the heart of the North Shore! Buyers & agents to do own due diligence and confirm all info & material facts. Listing by: Sterman Realty (808) 780-5673

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) "7890000.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    string(10) "7890000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(11) "SUNSET AREA"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(990) "** PRICE REDUCED ** Located in the highly coveted Sunset Point neighborhood, this spacious home is situated right in the center of the “7 Mile Miracle”. With the notorious surf spot Sunset right out front, Velzyland to the right, and Pipeline to the left, one can not ask for a better location! The upstairs level has a large open kitchen, a dining area, and an airy living room with ocean view. On this level, you will also find a beautiful primary bedroom with a full bathroom with shower and bathtub and breathtaking views, as well as an office/guest room with an additional full bathroom. Downstairs you’ll find three bedrooms, each with ocean views, and three bathrooms, as well as a sizable laundry room. Other valuable features include split AC throughout home, direct beach access, a LEGAL sea wall, large backyard, two separate garages, and more. Luxurious living in the heart of the North Shore! Buyers & agents to do own due diligence and confirm all info & material facts."
  }
  ["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) 780-5673"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(15) "Sophia L Miller"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2024-03-03T14:00:01.220"
  }
  ["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] => 7890000.00
        )

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

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

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

    [PublicRemarks] => Array
        (
            [0] => ** PRICE REDUCED ** Located in the highly coveted Sunset Point neighborhood, this spacious home is situated right in the center of the “7 Mile Miracle”. With the notorious surf spot Sunset right out front, Velzyland to the right, and Pipeline to the left, one can not ask for a better location! The upstairs level has a large open kitchen, a dining area, and an airy living room with ocean view. On this level, you will also find a beautiful primary bedroom with a full bathroom with shower and bathtub and breathtaking views, as well as an office/guest room with an additional full bathroom. Downstairs you’ll find three bedrooms, each with ocean views, and three bathrooms, as well as a sizable laundry room. Other valuable features include split AC throughout home, direct beach access, a LEGAL sea wall, large backyard, two separate garages, and more. Luxurious living in the heart of the North Shore! Buyers & agents to do own due diligence and confirm all info & material facts.
        )

    [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) 780-5673
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2024-03-03T14:00:01.220
        )

    [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