Live from the Honolulu MLS
Homes for sale on Oʻahu
Loading the latest homes and search controls…
Loading listings…
Live from the Honolulu MLS
Loading the latest homes and search controls…
Loading listings…
$3,195,000
HALEIWA · Haleiwa · 96712 · MLS 202616719
Rare oceanfront legal duplex on Oahu’s legendary North Shore. Set on a spacious 7,786 sq ft beachfront parcel in Haleiwa’s “Fresh Airs” community, this coastal sanctuary captures sweeping ocean, mountain, and sunset views, with world-class surf just beyond the lawn. Fully updated with permitted improvements throughout, the property features two legal residences with separate addresses—ideal for multi-generational living or a luxury rental/investment opportunity. The main home (66-471 Pikai) offers 3 bedrooms, 2 full baths, open-concept living, and expansive dual oceanfront lanais for effortless indoor/outdoor island living. The attached second home (66-469 Pikai) features 2 bedrooms, 1 bath, complete privacy, and its own entrance. Upgrades include a new pitched roof, dual-meter electrical enclosure with new subpanels, EV charger, refreshed plumbing, rebuilt oceanfront lanai decking, premium Pella 250 Series impact-rated windows and sliders, designer appliances, and fresh coastal paint. A turnkey beachfront trophy offering rare dual-residence versatility and pure North Shore magic.
Loading property records…
Mortgage News Daily ↗ · Sep 4, 2026 · checking for updates
National index, adjusted for points; not an APR, zero-point quote, or Hawaiʻi lender offer.
Low-down-payment programs have eligibility requirements. High-balance and jumbo pricing may differ from the national conforming benchmark.
Use two quotes from the same lender: without points and with points. Points do not buy a fixed rate reduction. This models a permanent buydown, not a temporary 2-1 subsidy.
$0 estimated interest saved · 0 months sooner
Payoff in 30 years, 0 months.
Assumes the same fixed rate and extra payment every month from the first payment. Taxes, insurance and fees are separate.
Closing costs and prepaids start at 0 and must be entered for a fuller cash estimate. Subtotal is before earnest-money deposits and approved credits.
Estimated monthly payment · year one
Complete all fields with valid amounts. Enter missing tax and HOA costs (0 only if none), a rate from 0–25%, and a down payment from 0–100%.
Oʻahu Home Search and The Ulu Team do not provide a Loan Estimate, rate lock, credit decision, or guarantee of payment through this tool. Rates are national benchmarks or your inputs, not APRs or personalized quotes. Actual rates, points, loan limits, fees and eligibility depend on your lender, credit, income, occupancy, entitlement, property and appraisal.
Models fixed-rate purchase financing for a one-unit home. FHA rules shown are standard forward-loan rules, not Hawaiian Home Lands or other special programs. VA/FHA selection does not establish eligibility. Taxes, insurance, HOA fees, ground rent and assessments may change; omitted or zero costs are excluded. FHA MIP is a year-one estimate and can change; conventional PMI cancellation is subject to lender and servicing rules. Upfront cash is a subtotal, not a closing disclosure. Verify all terms, costs, coverage and credits with a licensed lender, insurer and escrow professional before making a financial decision.
Loan rules: VA · HUD / FHA · CFPB points guide
Listed by Sterman Realty
Information is from the Honolulu MLS and sources deemed reliable but is not guaranteed. Square footage, lot size, taxes, permits, and land tenure should be independently verified. Not a solicitation of property already listed.
A home is only one part of your day. Try the trip to work, school, or your next duty station.
Google Maps shows the route and estimated travel time. Check it at the time you expect to travel.
Before you offer
We’ll pull the comparable sales on this street and tell you where this price really sits — before you write.
Honolulu MLS · Update date unavailable
Assessed value is for property-tax purposes and may differ from today’s market value. Historical taxes may reflect exemptions and may not represent your future tax bill.
Recorded sale history is currently unavailable. This does not mean the property has never sold.
Honolulu parcel / CPR: 660300360000
Similar home type and price in Haleiwa.
Get to know the area
Explore neighborhood guides as you narrow your search.
Read neighborhood guides →
