Listing
Overview
Price: $6,999,999
Area: SUNSET AREA
Status: Active
This spectacular ocean front sits at the tip of Sunset Point with renowned surfing at Sunset Beach and Backyards directly below the lanai and in full view from the kitchen, family room, and dining table. Set blocks back from the bustling Kamehameha Hwy and protected behind a LEGAL seawall with direct beach access, this home is an oasis of privacy and security. Designed by multi award-winning architect Joseph Lancor, the construction is like no other. The magnificent ceiling construction, featuring a welded steel structure hidden inside the walls, provides for an open living space that includes a spacious dining and kitchen area with breathtaking views of Kaena Point, Sunset Beach and the Koolau mountains. Watch world-class surfing and picturesque sunsets through the large glass windows or enjoy from the lanai. Upstairs: Open living area, large ocean-view primary bedroom with ensuite, and a secondary ensuite bedroom/office with full laundry. Downstairs: 3 bedrooms with ocean views and lanais, laundry room, large backyard and 2 two-car garages. Additional amenities include split AC throughout the entire home for maximum comfort. Luxury meets coastal charm with this incredible home! Listing by: Sterman Realty (808) 780-5673
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202418797"
}
["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(60) "https://my.matterport.com/show/?m=AwihYx3PBd9&brand=0&mls=1&"
}
["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(1199) "This spectacular ocean front sits at the tip of Sunset Point with renowned surfing at Sunset Beach and Backyards directly below the lanai and in full view from the kitchen, family room, and dining table. Set blocks back from the bustling Kamehameha Hwy and protected behind a LEGAL seawall with direct beach access, this home is an oasis of privacy and security. Designed by multi award-winning architect Joseph Lancor, the construction is like no other. The magnificent ceiling construction, featuring a welded steel structure hidden inside the walls, provides for an open living space that includes a spacious dining and kitchen area with breathtaking views of Kaena Point, Sunset Beach and the Koolau mountains. Watch world-class surfing and picturesque sunsets through the large glass windows or enjoy from the lanai. Upstairs: Open living area, large ocean-view primary bedroom with ensuite, and a secondary ensuite bedroom/office with full laundry. Downstairs: 3 bedrooms with ocean views and lanais, laundry room, large backyard and 2 two-car garages. Additional amenities include split AC throughout the entire home for maximum comfort. Luxury meets coastal charm with this incredible 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) 780-5673"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(15) "Sophia L Miller"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-09-22T16:59:07.423"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18216458"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-08-26T09:43:50.687"
}
["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) "26704282"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26704282"
[1]=>
string(8) "26704283"
[2]=>
string(8) "26704284"
[3]=>
string(8) "26704285"
[4]=>
string(8) "26704286"
[5]=>
string(8) "26704287"
[6]=>
string(8) "26704288"
[7]=>
string(8) "26704289"
[8]=>
string(8) "26704290"
[9]=>
string(8) "26704291"
[10]=>
string(8) "26704292"
[11]=>
string(8) "26704293"
[12]=>
string(8) "26704294"
[13]=>
string(8) "26704295"
[14]=>
string(8) "26704296"
[15]=>
string(8) "26704297"
[16]=>
string(8) "26704298"
[17]=>
string(8) "26704299"
[18]=>
string(8) "26704300"
[19]=>
string(8) "26704301"
[20]=>
string(8) "26704302"
[21]=>
string(8) "26704303"
[22]=>
string(8) "26704304"
[23]=>
string(8) "26704305"
[24]=>
string(8) "26704306"
[25]=>
string(8) "26704307"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202418797
)
[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] => https://my.matterport.com/show/?m=AwihYx3PBd9&brand=0&mls=1&
)
[ListPrice] => Array
(
[0] => 6999999.00
)
[CurrentPrice] => Array
(
[0] => 6999999.00
)
[Neighbourhood] => Array
(
[0] => SUNSET AREA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => This spectacular ocean front sits at the tip of Sunset Point with renowned surfing at Sunset Beach and Backyards directly below the lanai and in full view from the kitchen, family room, and dining table. Set blocks back from the bustling Kamehameha Hwy and protected behind a LEGAL seawall with direct beach access, this home is an oasis of privacy and security. Designed by multi award-winning architect Joseph Lancor, the construction is like no other. The magnificent ceiling construction, featuring a welded steel structure hidden inside the walls, provides for an open living space that includes a spacious dining and kitchen area with breathtaking views of Kaena Point, Sunset Beach and the Koolau mountains. Watch world-class surfing and picturesque sunsets through the large glass windows or enjoy from the lanai. Upstairs: Open living area, large ocean-view primary bedroom with ensuite, and a secondary ensuite bedroom/office with full laundry. Downstairs: 3 bedrooms with ocean views and lanais, laundry room, large backyard and 2 two-car garages. Additional amenities include split AC throughout the entire home for maximum comfort. Luxury meets coastal charm with this incredible 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) 780-5673
)
[ListAgentFullName] => Array
(
[0] => Sophia L Miller
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-09-22T16:59:07.423
)
[Matrix_Unique_ID] => Array
(
[0] => 18216458
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-08-26T09:43:50.687
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] => Ocean,Sandy Beach
)
[SpecialListingConditions] => Array
(
[0] => Subject To Repl. Property
)
[_thumbnail_id] => Array
(
[0] => 26704282
)
[listing_image] => Array
(
[0] => 26704282
[1] => 26704283
[2] => 26704284
[3] => 26704285
[4] => 26704286
[5] => 26704287
[6] => 26704288
[7] => 26704289
[8] => 26704290
[9] => 26704291
[10] => 26704292
[11] => 26704293
[12] => 26704294
[13] => 26704295
[14] => 26704296
[15] => 26704297
[16] => 26704298
[17] => 26704299
[18] => 26704300
[19] => 26704301
[20] => 26704302
[21] => 26704303
[22] => 26704304
[23] => 26704305
[24] => 26704306
[25] => 26704307
)
)
- 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
