$5,200,000
$100K PRICE DROP

59-471 Ke Waena Rd Haleiwa, HI 96712

Estimated payment $31,299/month

Total Views 28,997
4 Beds
3 Baths
2,353 Sq Ft
$2,210 Price per Sq Ft

Highlights

  • Ocean Front
  • Building Patio
  • Entrance Foyer
  • Main Floor Bedroom
  • Card or Code Access
  • 4-minute walk to Banzai Skatepark

About This Home

This beautifully designed beachfront home is located on the 7 Mile Miracle of the North Shore of Oahu and features stunning oceanfront views, luxurious finishes, exquisite craftsmanship, and a large extra wide white sandy beach. Located on a quiet street, with the surf breaks of Log Cabins and Rockpile are situated out front, this property is situated between the world famous Banzai Pipeline and Waimea Bay. Originally built by one of the best high-end builders on Oahu, Mark Robison of Hawaii Custom Development, Inc. This home includes many updated features including a gourmet kitchen, concrete floors, a large second story primary bedroom and bathtub overlooking the ocean, a two car garage, a standing seam copper roof, and much more. Close to Haleiwa town, excellent North Shore surf breaks in either direction, world class golf, and the Turtle Bay Ritz Carlton Resort. Welcome home to paradise!

Listing Agent

Paul Javier

HomeSmart Island Homes Brokerage Phone: (808) 729-7643 License #RB-20364 Listed on: 12/31/2024

HomeSmart Island Homes

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $43,128

Year Built

  • Built in 2003

Lot Details

  • 6,452 Sq Ft Lot
  • Ocean Front
  • Property fronts a county road
  • Fenced
  • Landscaped
  • Level Lot
  • Property is in excellent condition
  • Zoning described as 05 - R-5 Residential District

Property Views

  • Ocean
  • Coastline

Home Design

  • Slab Foundation
  • Metal Roof

Interior Spaces

  • 2,353 Sq Ft Home
  • 3-Story Property
  • Entrance Foyer
  • Ceramic Tile Flooring

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Main Floor Bedroom
  • Bathroom on Main Level
  • 3 Full Bathrooms

Parking

  • 3 Car Garage
  • Driveway

Schools

  • Sunset Beach Elementary School
  • Kahuku Middle School
  • Kahuku High School

Utilities

  • Underground Utilities

Listing and Financial Details

  • Assessor Parcel Number 1-5-9-003-040-0000

Community Details

Amenities

  • Building Patio
  • Community Deck or Porch
  • Community Storage Space

Additional Features

  • Sunset Area Subdivision
  • Card or Code Access

Home Details

Home Type

Single Family

Est. Annual Taxes

$43,128

Year Built

Built in 2003

Lot Details

0

Listing Details

  • Architectural Style: Detached
  • Inclusions: AC Split,Auto Garage Door Opener,Cable TV,Dishwasher,Disposal,Dryer,Microwave,Range/Oven,Refrigerator,Washer,Water Heater
  • Property Sub Type: Single Family Residence
  • Prop. Type: Residential
  • Year Built: 2003
  • Attribution Contact: (808) 729-7643
  • CommunityFeatures: Deck/Porch, Patio, Storage Facilities
  • Fencing: Fenced, Wall
  • Road Frontage Type: Oceanfront, Waterfront
  • Road Frontage Type: County Road
  • Road Surface Type: Paved
  • SecurityFeatures: Key Card Entry
  • MLS Status: Active
  • Subdivision Name: SUNSET AREA
  • Interior Features: Bedroom on Main Level, Full Bath on Main Level
  • Unit Levels: Three Or More
  • Living Area: 2353.0
  • New Construction: No
  • Roof: Metal
  • RoomType: Entry/Foyer
  • Tax Year: 2024
  • Special Features: None

Interior Features

  • Flooring: Ceramic Tile, Other
  • Furnished: Furnished
  • Full Bathrooms: 3
  • Total Bedrooms: 4

Exterior Features

  • Construction Type: Double Wall, Concrete
  • Lot Features: Cleared, Other, Level
  • Pool Features: None
  • Property Condition: Excellent, Updated/Remodeled
  • Topography: Level
  • View: Coastline, Mountain(s), Ocean, Sunset
  • View: Yes
  • Waterfront: Yes
  • Disclosures: Seller Disclosure
  • Exterior Features: Landscaping
  • Foundation Details: Slab

Garage/Parking

  • Parking Features: Driveway, Garage, Three or more Spaces, On Street
  • Total Parking Spaces: 5.0
  • Attached Garage: Yes

Utilities

  • Utilities: Cable Available, Electricity Available, Natural Gas Available, Septic Available, Underground Utilities, Water Available
  • Sewer: Septic Tank
  • Water Source: Public

Fee Information

  • Association Fee Includes: None

Schools

  • Elementary School: Sunset Beach
  • High School: Kahuku
  • Middle Or Junior School: Kahuku

Lot Info

  • Parcel Number: 1-5-9-003-040-0000
  • Zoning Description: 05 - R-5 Residential District

Tax Info

  • Tax Annual Amount: 43128.0

Map

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2025 $43,128 $4,557,000 $3,241,500 $1,315,500
2024 $43,128 $4,432,300 $3,087,100 $1,345,200
2023 $34,416 $4,412,600 $3,087,100 $1,325,500
2022 $34,416 $3,849,100 $2,778,400 $1,070,700
2021 $27,727 $3,212,100 $2,469,700 $742,400
2020 $36,172 $4,016,400 $2,778,400 $1,238,000
2019 $33,420 $3,754,300 $2,778,400 $975,900
2018 $24,464 $3,218,200 $2,469,700 $748,500
2017 $20,204 $2,744,900 $2,109,500 $635,400
2016 $16,633 $2,772,100 $2,058,100 $714,000
2015 $16,234 $2,705,600 $2,058,100 $647,500
2014 -- $2,367,300 $1,775,100 $592,200
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
08/22/2025 08/22/25 Price Changed $5,200,000 -0.6% $2,210 / Sq Ft
07/12/2025 07/12/25 Price Changed $5,230,000 -0.4% $2,223 / Sq Ft
05/03/2025 05/03/25 Price Changed $5,250,000 -0.8% $2,231 / Sq Ft
01/10/2025 01/10/25 Price Changed $5,290,000 -0.2% $2,248 / Sq Ft
12/31/2024 12/31/24 For Sale $5,300,000 +41.3% $2,252 / Sq Ft
07/12/2017 07/12/17 Sold $3,750,000 -12.8% $1,594 / Sq Ft
06/12/2017 06/12/17 Pending -- -- --
12/16/2016 12/16/16 For Sale $4,300,000 -- $1,827 / Sq Ft
Source: HiCentral MLS (Honolulu Board of REALTORS®)

Purchase History

Date Type Sale Price Title Company
Warranty Deed $3,750,000 Tg
Warranty Deed $3,750,000 Tg
Warranty Deed $3,600,000 Tg
Warranty Deed $390,000 --
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $2,812,500 New Conventional
Closed $2,812,500 New Conventional
Previous Owner $1,500,000 Commercial
Previous Owner $500,000 Credit Line Revolving
Previous Owner $2,340,000 New Conventional
Previous Owner $351,000 No Value Available
Source: Public Records

Source: HiCentral MLS (Honolulu Board of REALTORS®)

MLS Number: 202428924

HiCentral MLS (Honolulu Board of REALTORS®)

APN: 1-5-9-003-040-0000