| Rebate | 20% Buyer's Rebate | $3,500 Flat Fee Selling | 2% Full Service Selling |
|---|---|
| Description | This Beautiful, Spacious Home with Great Ocean Views at Sunset Point is PRICED to SELL NOW!! An entire top to bottom renovation was done just two years ago and the photos clearly show the same! All three bedrooms have split A/C as does the kitchen/dining area on the upper floor! Disclosures: 1. Third bedroom is actually a den. 2. This is a two story house over a 6 car carport that belongs to the 6 beachfront condos. And at this price it shouldn't matter. A Buyer with vision could perhaps offer money down the line to individual owners and understand the value in scoring this property now at this price! FYI: The maintenance fee includes Flood Insurance which everyone else in the neighborhood and most coastal areas everywhere in the state pays about $500 a month for the same! The rest is water, maintenance of the new large capacity wastewater system, landscaping and AOA. The turnkey quality furnishings are available for an additional $15,000. |
| Status | Sold since 02-04-2018 |
| MLS# | 201802484 |
| Price | $1,250,000 |
| Original Price | $1,250,000 |
| Price Change | (0.00%) |
| Beds / Baths / Half | 3 / 2 / 1 |
| Parking Spaces | 2 |
| Living Sq Ft | 1,848 |
| Land Sq Ft | 27,966 |
| Land Tenure | FS - Fee Simple |
| Maintenance Fee | $922 |
| Building | Sunset Beach Vista |
| Address | 59-043 Huelo Street PRKG Haleiwa HI 96712 |
| Region | North Shore |
| Neighborhood | Sunset Area |
| Days on Market | 21 |
| Year Built | 1985 |
| Year Remodeled | 2015 |
| Condition | Excellent |
| View | Mountain, Ocean, Sunset |
| Pool | None |
| Parking | 2 Car, Driveway |
| Zoning | 05 - R-5 Residential District |
| Flood Zone | Zone VE · See flood zone map · Explain flood zones |
| Monthly Tax | $255 |
| Assessed Land | $154,000 |
| Assessed Building | $721,400 |
| Assessed Total | $875,400 |
| Assessed Ratio | 143% |
| Inclusions | AC Split, Blinds, Ceiling Fan, Dishwasher, Disposal, Dryer, Range/Oven, Refrigerator, Security System, Smoke Detector, Solar Heater, Washer |
| Amenities | Patio/Deck, Storage, Wall/Fence |
| Utilities | Cable, Public Water, Septic, Underground Electricity |
| Construction | Above Ground, Double Wall, Wood Frame |
| Lot Features | Clear |
| Flooring | Hardwood |
| Disclosures | Property Disclosure Stmt |
| Furnished | Negotiable |
| Land Recorded | Regular System |
| Possession | At Closing |
| Sale Conditions | None |
| Topography | Level |
| Building Style | CPR, Detach Single Family |
| Stories | Two |
| Roofing | Asphalt Shingle |
| Easements | None, Beach Access |
| Parcel # | 1-5-9-001-080-0007 |
| Listing courtesy of | REMAX Sunset Homes |
Property History from MLS · Top
| Date | MLS# | Change | Old Value | New Value | List Price | Sold Price | Assessed Total | Land | Building |
|---|---|---|---|---|---|---|---|---|---|
| 06-03-2025 | 202507756 | Sold | C | S | $1,240,000 | $1,220,000 | $1,564,200 | $225,400 | $1,338,800 |
| 04-07-2025 | 202507756 | Active Under Contract | A | C | $1,240,000 | $1,220,000 | $1,564,200 | $225,400 | $1,338,800 |
| 03-27-2025 | 202507756 | New Listing | A | $1,240,000 | $1,220,000 | $1,564,200 | $225,400 | $1,338,800 | |
| 03-11-2025 | 202406275 | Expired | A | X | $1,240,000 | $0 | $1,461,800 | $225,400 | $1,236,400 |
| 09-01-2024 | 202406275 | Price Decrease | $1,280,000 | $1,240,000 | $1,240,000 | $0 | $1,461,800 | $225,400 | $1,236,400 |
| 07-08-2024 | 202406275 | Price Decrease | $1,380,000 | $1,280,000 | $1,240,000 | $0 | $1,461,800 | $225,400 | $1,236,400 |
| 05-22-2024 | 202406275 | Price Decrease | $1,550,000 | $1,380,000 | $1,240,000 | $0 | $1,461,800 | $225,400 | $1,236,400 |
| 04-28-2024 | 202406275 | Price Decrease | $1,650,000 | $1,550,000 | $1,240,000 | $0 | $1,461,800 | $225,400 | $1,236,400 |
| 03-13-2024 | 202406275 | New Listing | A | $1,240,000 | $0 | $1,461,800 | $225,400 | $1,236,400 | |
| 10-23-2020 | 202007757 | Withdrawn | A | W | $1,299,000 | $0 | $1,243,100 | $202,900 | $1,040,200 |
| 04-06-2020 | 202007757 | New Listing | A | $1,299,000 | $0 | $1,243,100 | $202,900 | $1,040,200 | |
| 06-20-2018 | 201719222 | Withdrawn | A | W | $1,250,000 | $0 | $875,400 | $154,000 | $721,400 |
| 06-20-2018 | 201719222 | Back On Market | C | A | $1,250,000 | $0 | $875,400 | $154,000 | $721,400 |
| 06-20-2018 | 201802484 | Sold | C | S | $1,250,000 | $1,165,000 | $875,400 | $154,000 | $721,400 |
| 02-25-2018 | 201719222 | In Escrow Showing | A | C | $1,250,000 | $0 | $875,400 | $154,000 | $721,400 |
| 02-25-2018 | 201802484 | In Escrow Showing | A | C | $1,250,000 | $1,165,000 | $875,400 | $154,000 | $721,400 |
| 02-05-2018 | 201802484 | New Listing | A | $1,250,000 | $1,165,000 | $875,400 | $154,000 | $721,400 | |
| 02-05-2018 | 201719222 | Price Decrease | $1,500,000 | $1,250,000 | $1,250,000 | $0 | $875,400 | $154,000 | $721,400 |
| 10-26-2017 | 201719222 | Price Decrease | $1,700,000 | $1,500,000 | $1,250,000 | $0 | $875,400 | $154,000 | $721,400 |
| 09-08-2017 | 201719222 | New Listing | A | $1,250,000 | $0 | $875,400 | $154,000 | $721,400 | |
| 08-26-2004 | 2410099 | Withdrawn | A | W | $900,000 | $0 | $241,200 | $38,900 | $202,300 |
| 08-26-2004 | 2410497 | Withdrawn | A | W | $900,000 | $0 | $241,200 | $38,900 | $202,300 |
| 07-09-2004 | 2410497 | New Listing | A | $900,000 | $0 | $241,200 | $38,900 | $202,300 | |
| 07-06-2004 | 2410099 | New Listing | A | $900,000 | $0 | $241,200 | $38,900 | $202,300 | |
| 04-11-2001 | 2100647 | Sold | P | S | $204,900 | $204,900 | $119,500 | $38,900 | $80,600 |
| 04-04-2001 | 2100647 | Pending | C | P | $204,900 | $204,900 | $119,500 | $38,900 | $80,600 |
| 01-18-2001 | 2100647 | New Listing | A | $204,900 | $204,900 | $119,500 | $38,900 | $80,600 |
Similar properties in this Region · Similar properties in this neighborhood · Similar properties island-wide
Show Buyer's Closing Costs · Show Seller's Closing Costs · Receive automatic email updates for this property
Public Schools · City Tax Record / Plat Map · Tsunami Evacuation Zones · Mortgage Calculator · Neighborhood Boundary Map · Traffic Maps
Google Maps · This property · Supermarkets · Schools · Hospitals · Restaurants · Beaches · Beach access points all over Oahu · Top
