new - 4 days on rocket

59-029 Holawa St Unit D, Haleiwa, HI, 96712

$3,800,000

4 Bedrooms
3 Full Baths
1,544 SqFt
$2,461/SqFt
House

Location

Image provided by Mapbox

Property Highlights

Home TypeSingle Family Residence
ParkingDriveway, Three or more Spaces
Year Built1938
CoolingCeiling Fan(s)
WaterfrontOcean Front, Waterfront
ViewOther, Mountain(s), Ocean
MLS #202426554
StatusActive

About 59-029 Holawa St Unit D

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!

Property Details

Property Features

Property Information:

  • Architectural Style: Detached, Multi-Family
  • Year Built: 1938
  • Stories: 1
  • Living Area: 1,544 SqFt

Listing Office:

  • Office Name: Sterman Realty
  • Office Phone: (808) 637-6200
  • Agent Phone: (808) 271-1831

Interior Features

Interior Information:

  • Appliances: Ceiling Fan(s), Dishwasher, Dryer, Range, Oven, Refrigerator, Washer
  • Flooring Type: Hardwood, Laminate
  • Interior: Ceiling Fan(s)

Bedroom and Bathroom Information:

  • Full Bathrooms: 3
  • Total Bedroom Count: 4

Exterior Features

Exterior Information:

  • Waterfront: Ocean Front, Waterfront
  • View: Other, Mountain(s), Ocean

Parking Information:

  • Parking: Driveway, Three or more Spaces

Lot Features

Lot Information:

  • Lot: Cleared, Interior Lot, Level

Utilities

Utilities Information:

  • Cooling: Ceiling Fan(s)

Price Information

Listing Price Info

Price Summary:

  • List Price: $3,800,000
  • Price Per SqFt: $2,461/SqFt
House and calculator

What can I afford?

Understand what home price range makes sense for your budget.

Housing Market Comparison

See how this home compares to others in Haleiwa, HI.

Med. Sold Price

$2.8M

Med. Price/SqFt

$1,324

Avg. Days On Market

39

# of Sold Homes

1

59-029 Holawa St Unit D vs Haleiwa

4 DAYS ON ROCKET

-35 Days

$3,800,000

+$982.5K More

$2,461/SqFt

+$1.1K More

KEY TAKEAWAY

This property is $982.5K more than the Median Sold Price and $1.1K/SqFt more than other homes in Haleiwa, HI.

Based on homes sold in October 2024

MLS Details

MLS Information:

  • MLS Name: HICMLS
  • MLS Number: #202426554

Listing Office:

  • Office Name: Sterman Realty
  • Office Phone: (808) 637-6200
  • Agent Phone: (808) 271-1831

Based on information from the Multiple Listing Service of HiCentral MLS, Ltd. Information is deemed reliable but not guaranteed. Copyright: 2024 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.

Data displayed may be a portion of, and not a complete set of all listings published in the MLS.
Last updated on: 11/19/2024, 6:20:54 AM Eastern. If you have any questions regarding the accuracy of this data, please contact us at help@rockethomes.com.

Property Sales & Tax

We're sorry, we currently don't have sales or tax history data for this listing.

Payment Calculator

$19K

Per Month

Recommended Financing

30-Year Fixed

Rate/APR

7.5% / 6.68%

Total Monthly Payment

$11.4K

Powered By

Rocket Mortgage

Advertisement

NMLS#3030

Schools

Schools Nearby

The school rating is a score out of 10, where 10 is the highest and 1 is the lowest. Assigned schools have a bold outline.

Nearby Schools

school-card-donut-904037
4
/10
  • Sunset Beach Elementary School

  • 59-360 Kamehameha Hwy

  • 1.29 miles

  • Public District Grades PK-6

school-card-donut-904038
2
/10
  • Kahuku Elementary School

  • 56-170 Pualalea St

  • 5.61 miles

  • Public District Grades PK-6

school-card-donut-904039
5
/10
  • Laie Elementary School

  • 55-109 Kulanui St

  • 7.50 miles

  • Public District Grades PK-6

Neighborhood

What Are The Neighbors Like?

The neighbors living near this home have an average income of $65,132. Residents of Haleiwa, HI typically earn between $35k-100k each year. Most families are single, no kids. Residents of this area typically have post secondary degree education.

All data provided by Home Junction and Claritas

Frequently Asked Questions About 59-029 Holawa St Unit D

What is the listing price of this property?

The listing price of 59-029 Holawa St Unit D property is $3,800,000.

What type of property is this?

The property 59-029 Holawa St Unit D is a house located in Haleiwa, Hawaii, 96712.

Is this property for sale now?

Active Listing: 59-029 Holawa St Unit D is For Sale (Active/New) which means the seller is accepting offers.

How many bedrooms and bathrooms does this property have?

The property at 59-029 Holawa St Unit D has 4 bedrooms and 3 bathrooms.

What is the square footage of this property?

The property 59-029 Holawa St Unit D is 1,544 SqFt (source: MLS/tax record).

Which year was this property built?

The year of construction for 59-029 Holawa St Unit D is 1938.
Rocket Homes logo

Interested in 59-029 Holawa St Unit D? Let's connect.

Let Us Contact You

By checking this box and submitting your personal information, you agree to our Terms of Use and Privacy Policy. You also expressly consent to having Rocket Homes Real Estate LLC, its Family of Companies, Rocket Homes Network Partners, and potentially our mortgage partners contact you about your inquiry by text message or phone (including automatic telephone dialing system, AI voice, or an artificial or prerecorded voice) to the residential or cellular telephone number you have provided, even if that telephone number is on a corporate, state, or national Do Not Call Registry. You do not have to agree to receive such calls or messages as a condition of getting any services from Rocket Homes Real Estate, LLC or its partners. By communicating with us by phone, you consent to calls being recorded and monitored. You also agree that we can share your personal data and contact information with third parties such as mortgage partners, partner companies, and affiliates, and that these parties may use your personal data and contact information for marketing and analytic purposes, and to improve your experience.


Rocket HomesHawaiiHonolulu CountyHaleiwa9671259-029 Holawa St Unit D

This home is located at 59-029 Holawa St Unit D in Haleiwa, HI and zip code 96712 in the North Shore neighborhood. This 1,544 square foot home was built in 1938. Features: 4 bedrooms, 3 bathrooms. It has been listed on Rocket Homes since November 15, 2024 and is currently priced at $3,800,000.

Over 0 listings were sold over their listed price in October 2024 in Haleiwa, HI. In the same period over 1 listings were sold below the listed price and 0 listings were sold for the listed price. The inventory of homes for sale in Haleiwa, HI between September 2024 and October 2024 increased by 20%. The median list price of listings available in October 2024 was $2,817,500, while the average time on the real estate market was 39 days.

From Rocket Homes Real Estate and based on county public records data.

More Resources