Listing
Overview
Price: $3,800,000
Area: SUNSET AREA
Status: Active
Nestled in the heart of one of the most coveted coastal neighborhoods, the "Point" House at Sunset Point offers an unparalleled opportunity to own a slice of paradise. Never before listed, this exceptional property boasts stunning, unobstructed views of the world-famous Sunset surf break. With its prime location and a tranquil, laid-back atmosphere, this is the perfect place to create your dream beach retreat.
Adjacent to the "Carriage" House, also for sale (MLS 20246668, TMK 1-5-9-001-110-0003), this is a rare opportunity to acquire one or both properties for a truly remarkable investment. Combined, these two homes offer 102 feet of beach frontage and come complete with a legal rock revetment wall, providing both beauty and stability along the shoreline.
Whether you're looking to build, renovate, or simply enjoy as-is, this beachfront property offers limitless potential in one of the most desirable locations along the coast. Don't miss your chance to own a piece of Sunset Point — an area known for its surf, sunsets, and sought-after coastal living.
Click on the film reel! Listing by: Sterman Realty (808) 271-1831
array(46) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202426554"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "59-029"
}
["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) "D"
}
["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(54) "https://shoots.styronphoto.com/sites/gewvlgl/unbranded"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "3800000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
NULL
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(11) "SUNSET AREA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1100) "Nestled in the heart of one of the most coveted coastal neighborhoods, the "Point" House at Sunset Point offers an unparalleled opportunity to own a slice of paradise. Never before listed, this exceptional property boasts stunning, unobstructed views of the world-famous Sunset surf break. With its prime location and a tranquil, laid-back atmosphere, this is the perfect place to create your dream beach retreat.
Adjacent to the "Carriage" House, also for sale (MLS 20246668, TMK 1-5-9-001-110-0003), this is a rare opportunity to acquire one or both properties for a truly remarkable investment. Combined, these two homes offer 102 feet of beach frontage and come complete with a legal rock revetment wall, providing both beauty and stability along the shoreline.
Whether you're looking to build, renovate, or simply enjoy as-is, this beachfront property offers limitless potential in one of the most desirable locations along the coast. Don't miss your chance to own a piece of Sunset Point — an area known for its surf, sunsets, and sought-after coastal living.
Click on the film reel!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(14) "Sterman Realty"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "3"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "6671.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "1956"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1938"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(7) "Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "5"
}
["StoriesType"]=>
array(1) {
[0]=>
string(12) "Basement,One"
}
["View"]=>
array(1) {
[0]=>
string(31) "Coastline,Mountain,Ocean,Sunset"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(4) "0.00"
}
["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(20) "cathyshanley@aol.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 271-1831"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(17) "Cathryn L Shanley"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-11-18T20:37:10.387"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18381118"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
NULL
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(11) "North Shore"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(28) "Ocean,Sandy Beach,Waterfront"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
NULL
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26769392"
}
["listing_image"]=>
array(19) {
[0]=>
string(8) "26769392"
[1]=>
string(8) "26769393"
[2]=>
string(8) "26769394"
[3]=>
string(8) "26769395"
[4]=>
string(8) "26769396"
[5]=>
string(8) "26769397"
[6]=>
string(8) "26769398"
[7]=>
string(8) "26769399"
[8]=>
string(8) "26769400"
[9]=>
string(8) "26769401"
[10]=>
string(8) "26769402"
[11]=>
string(8) "26769403"
[12]=>
string(8) "26769404"
[13]=>
string(8) "26769405"
[14]=>
string(8) "26769406"
[15]=>
string(8) "26769407"
[16]=>
string(8) "26769408"
[17]=>
string(8) "26769409"
[18]=>
string(8) "26769410"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2024-11-11"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202426554
)
[StreetNumber] => Array
(
[0] => 59-029
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Holawa
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] => D
)
[City] => Array
(
[0] => Haleiwa
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96712
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://shoots.styronphoto.com/sites/gewvlgl/unbranded
)
[ListPrice] => Array
(
[0] => 3800000.00
)
[CurrentPrice] => Array
(
[0] =>
)
[Neighbourhood] => Array
(
[0] => SUNSET AREA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Nestled in the heart of one of the most coveted coastal neighborhoods, the "Point" House at Sunset Point offers an unparalleled opportunity to own a slice of paradise. Never before listed, this exceptional property boasts stunning, unobstructed views of the world-famous Sunset surf break. With its prime location and a tranquil, laid-back atmosphere, this is the perfect place to create your dream beach retreat.
Adjacent to the "Carriage" House, also for sale (MLS 20246668, TMK 1-5-9-001-110-0003), this is a rare opportunity to acquire one or both properties for a truly remarkable investment. Combined, these two homes offer 102 feet of beach frontage and come complete with a legal rock revetment wall, providing both beauty and stability along the shoreline.
Whether you're looking to build, renovate, or simply enjoy as-is, this beachfront property offers limitless potential in one of the most desirable locations along the coast. Don't miss your chance to own a piece of Sunset Point — an area known for its surf, sunsets, and sought-after coastal living.
Click on the film reel!
)
[ListOfficeName] => Array
(
[0] => Sterman Realty
)
[BedsTotal] => Array
(
[0] => 4
)
[BathsFull] => Array
(
[0] => 3
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 6671.00
)
[SqftTotal] => Array
(
[0] => 1956
)
[YearBuilt] => Array
(
[0] => 1938
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Average
)
[ParkingTotal] => Array
(
[0] => 5
)
[StoriesType] => Array
(
[0] => Basement,One
)
[View] => Array
(
[0] => Coastline,Mountain,Ocean,Sunset
)
[MaintenanceExpense] => Array
(
[0] => 0.00
)
[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] => cathyshanley@aol.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 271-1831
)
[ListAgentFullName] => Array
(
[0] => Cathryn L Shanley
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-11-18T20:37:10.387
)
[Matrix_Unique_ID] => Array
(
[0] => 18381118
)
[OriginalEntryTimestamp] => Array
(
[0] =>
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] => Ocean,Sandy Beach,Waterfront
)
[SpecialListingConditions] => Array
(
[0] =>
)
[_thumbnail_id] => Array
(
[0] => 26769392
)
[listing_image] => Array
(
[0] => 26769392
[1] => 26769393
[2] => 26769394
[3] => 26769395
[4] => 26769396
[5] => 26769397
[6] => 26769398
[7] => 26769399
[8] => 26769400
[9] => 26769401
[10] => 26769402
[11] => 26769403
[12] => 26769404
[13] => 26769405
[14] => 26769406
[15] => 26769407
[16] => 26769408
[17] => 26769409
[18] => 26769410
)
[ListingContractDate] => Array
(
[0] => 2024-11-11
)
)
- BedsTotal: 4
- Full Baths: 3
- Land Area (sf): 6,671 sf
- Living (sf): 1,956
- Year Built: 1938
- Property Condition: Average
- Number of Parking Spaces: 5
- View: Coastline,Mountain,Ocean,Sunset
- Listing Office: Sterman Realty
- Maintenance Fees: $0
- Land Tenure: FS - Fee Simple
- Elementary School: Sunset Beach
- Middle School: Kahuku
- High School: Kahuku
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on November 18, 2024 - 8:37 PM
Information is deemed reliable but not guaranteed.
Copyright: 2025 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.
© Marcus Realty. All Rights Reserved.
