Holiday Hours: Our office will close at Noon on December 24th and 31st and will be closed all day on December 25th and January 1st. Happy Holidays!
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(46) {
["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"
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "13:11:18.510"
}
}
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
)
[MatrixModifiedTime] => Array
(
[0] => 13:11:18.510
)
)
