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!
Active
Price cut: $40K (5/3)
$5,250,000
59-471 Ke Waena Rd, Haleiwa, HI 96712
4beds
2,353sqft
Est.:
Single Family Residence
Built in 2003
-- sqft lot
$4,901,300 Zestimate®
$2,231/sqft
$-- HOA
What's special
Beachfront homeBathtub overlooking the oceanLuxurious finishesExquisite craftsmanshipGourmet kitchenStanding seam copper roofStunning oceanfront views
- 151 days
- on Zillow |
- 1,628 |
- 70 |
Zillow last checked: 7 hours ago
Listing updated: May 14, 2025 at 06:59pm
Listed by:
Paul M Javier 808-232-1233,
HomeSmart Island Homes
Source: HiCentral MLS,MLS#: 202428924

Travel times
Tour with a buyer’s agent
Tour with a buyer’s agent
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 3
- Full bathrooms: 3
Rooms
- Room types: Entry/Foyer
Features
- Bedroom on Main Level, Full Bath on Main Level
- Flooring: Ceramic Tile, Other
- Furnished: Yes
Interior area
- Total structure area: 2,905
- Total interior livable area: 2,353 sqft
Property
Parking
- Total spaces: 5
- Parking features: Driveway, Garage, Three or more Spaces, On Street
- Has garage: Yes
Features
- Levels: Three Or More
- 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, Other, Level
- Topography: Level
Details
- Parcel number: 1590030400000
- 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, Concrete
- Foundation: Slab
Condition
- Excellent,Updated/Remodeled
- New construction: No
- Year built: 2003
- Major remodel year: 2023
Utilities & green energy
- Sewer: Septic Tank
- Water: Public
- Utilities for property: Cable Available, Electricity Available, Natural Gas Available, Septic Available, Underground Utilities, Water Available
Community & HOA
Community
- Features: Deck/Porch, Patio, Storage Facilities
- Security: Key Card Entry
- Subdivision: Sunset Area
HOA
- Services included: None
Location
- Region: Haleiwa
Financial & listing details
- Price per square foot: $2,231/sqft
- Tax assessed value: $4,432,300
- Annual tax amount: $43,128
- Date on market: 12/31/2024
- Inclusions: AC Split, Auto Garage Door Opener, Cable TV, Dishwasher, Disposal, Dryer, Microwave, Range/Oven, Refrigerator, Washer, Water Heater
- Loading
- Loading