Huge Price Reduction! Best Sandy-Beachfront VALUE on the North Shore!
This has been a multi-generational family home…and now it can be yours!
Incredible Beachfront Location - with a direct Northerly View of Pipeline!
Dramatic Ocean, Sunset and Backdoor Pipeline views!
White Sand Beach is protected by "Rock Pile" and this property is NOT in a Flood Zone!
A bit of a fixer-upper however, with lots of potential including adding an ADU Unit.
"In the Action", however, just far enough away from Pipeline to make it "Super Private"!
Banzai Skate Park & Bike Path are just steps away.
Must experience the location and see the views to really appreciate this incredible property!:
Closed
$3,100,000
59-459 Ke Waena Rd, Haleiwa, HI 96712
3beds
1,500sqft
Single Family Residence
Built in 1958
-- sqft lot
$3,756,100 Zestimate®
$2,067/sqft
$5,508 Estimated rent
Home value
$3,756,100
$3.38M - $4.21M
$5,508/mo
Zestimate® history
Owner options
List your home for rent
$5,508/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
$5,508/mo
Rent Zestimate®
Refinance and save
$13,829/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
$13,829/mo
Est. payment
Explore your selling options
Work with a Zillow partner agent
Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.
Get startedList with your own agent
Get your home in front of millions of buyers by listing it on Zillow.
Learn how to do itSell it yourself
Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).
List your homeWhat's special
Zillow last checked:
Listing updated:
Listed by:
Richard D Sterman 808-638-8600,
Sterman Realty,
Monta R Koch 808-222-6336,
Sterman Realty
Bought with:
Mikey Bruneau, RS-81640
HomeSmart Island Homes
Source: HiCentral MLS,MLS#: 202326437
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 2
- Full bathrooms: 2
Features
- Flooring: Hardwood
Interior area
- Total structure area: 2,344
- Total interior livable area: 1,500 sqft
Property
Parking
- Total spaces: 2
- Parking features: Garage, Two Car Garage, Two Spaces
- Garage spaces: 2
Features
- Levels: Two
- Stories: 2
- Exterior features: Landscaping
- Pool features: None
- Fencing: Fenced,Wall
- Has view: Yes
- View description: Coastline, Mountain(s), Ocean, Sunset
- Has water view: Yes
- Water view: Coastline,Ocean
- Frontage type: Oceanfront,Waterfront
Lot
- Features: Cleared, Interior Lot, Level
- Topography: Level
Details
- Parcel number: 1590030350000
- Zoning description: 05 - R-5 Residential District
- Special conditions: None
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Detached
- Property subtype: Single Family Residence
Materials
- Double Wall, Wood Frame
Condition
- Average Condition,Updated/Remodeled
- New construction: No
- Year built: 1958
- Major remodel year: 1968
Utilities & green energy
- Sewer: Cesspool
- Water: Public
- Utilities for property: Above Ground Utilities, Cable Available, Electricity Available, High Speed Internet Available, Phone Available, Water Available
Community & neighborhood
Community
- Community features: Deck/Porch, Patio, Storage Facilities
Location
- Region: Haleiwa
- Subdivision: Sunset Area
Price history
| Date | Event | Price |
|---|---|---|
| 7/19/2024 | Sold | $3,100,000-8.8%$2,067/sqft |
Source:  HiCentral MLS #202326437 Report a problem | ||
| 7/18/2024 | Pending sale | $3,400,000$2,267/sqft |
Source: HiCentral MLS #202326437 Report a problem | ||
| 6/24/2024 | Contingent | $3,400,000$2,267/sqft |
Source: HiCentral MLS #202326437 Report a problem | ||
| 6/7/2024 | Listed for sale | $3,400,000-5.6%$2,267/sqft |
Source: HiCentral MLS #202326437 Report a problem | ||
| 5/4/2024 | Contingent | $3,600,000$2,400/sqft |
Source: HiCentral MLS #202326437 Report a problem | ||
| 5/4/2024 | Price change | $3,600,000-8.9%$2,400/sqft |
Source: HiCentral MLS #202326437 Report a problem | ||
| 3/31/2024 | Price change | $3,950,000-1.3%$2,633/sqft |
Source: HiCentral MLS #202326437 Report a problem | ||
| 2/1/2024 | Price change | $4,000,000-27.3%$2,667/sqft |
Source: HiCentral MLS #202326437 Report a problem | ||
| 1/4/2024 | Listed for sale | $5,500,000$3,667/sqft |
Source: HiCentral MLS #202326437 Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $32,027 +176.1% | $3,458,500 -0.4% |
| 2024 | $11,599 -4.8% | $3,473,900 -4% |
| 2023 | $12,179 +4.2% | $3,619,600 +4% |
| 2022 | $11,687 +39.6% | $3,479,000 +37.4% |
| 2021 | $8,369 -14.2% | $2,531,200 -13.5% |
| 2020 | $9,751 -1.8% | $2,925,900 -1.1% |
| 2019 | $9,933 +8.3% | $2,958,000 +8% |
| 2018 | $9,168 +23.8% | $2,739,300 +22.5% |
| 2017 | $7,406 -5.7% | $2,236,100 -5.4% |
| 2016 | $7,851 +16.6% | $2,363,100 +15.6% |
| 2015 | $6,735 | $2,044,300 +3.4% |
| 2014 | -- | $1,976,700 +6.9% |
| 2013 | -- | $1,848,900 +4% |
| 2012 | -- | $1,777,100 -6.7% |
| 2011 | -- | $1,904,600 -3.6% |
| 2010 | -- | $1,976,000 -10.6% |
| 2009 | -- | $2,210,300 -13.4% |
| 2008 | -- | $2,553,500 +1.1% |
| 2007 | -- | $2,525,500 +27.2% |
| 2006 | -- | $1,985,300 +86.4% |
| 2005 | -- | $1,065,300 +24.7% |
| 2004 | -- | $854,200 +43.6% |
| 2003 | $2,169 +4.1% | $594,700 +0.1% |
| 2002 | $2,083 | $594,200 |
| 2000 | -- | -- |
| 1999 | -- | $398,900 |
Find assessor info on the county website
Neighborhood: 96712
Nearby schools
GreatSchools rating
- 6/10Sunset Beach Elementary SchoolGrades: PK-6Distance: 0.4 mi
- 4/10Kahuku High & Intermediate SchoolGrades: 7-12Distance: 7 mi
- 8/10Anuenue SchoolGrades: PK-12Distance: 30 mi
Schools provided by the listing agent
- Elementary: Sunset Beach
- Middle: Kahuku
- High: Kahuku
Source: HiCentral MLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
Sell for more on Zillow
Get a Zillow Showcase℠ listing at no additional cost and you could sell for .
$3,756,100
2% more
+$75,122
With Zillow Showcase(estimated)
$3,831,222
- Hawaii
- Honolulu County
- Haleiwa
- 96712
- 59-459 Ke Waena Rd
Nearby cities
Nearby zip codes
Other Haleiwa Topics
