Listings | Photo View | Sold Listings
5 Active 0 Contract 0 Pending 5 Total
To see one photo and the description, move the pointer over Status.
| Legend | Photos | Status | MLS# | Current Price |
Original Price |
Tax | Fees | Region | Neighborhood | Address | Condition | Beds | Baths | DOM | List Date | Living Sq Ft |
Avg. Living |
Land Sq Ft |
Avg. Land |
Year Built |
Year Rem |
Assessed Total |
Assessed Land |
Assessed Improve |
Assessed Ratio |
View | Frontage | Pool | Parking | Elementary | Junior | High | Zoning |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| FS | Photos | Active | 202616525 | $1,199,888 | $1,199,888 | $434 | North Shore | Haleiwa | 66-54 Haleiwa Loop | Average | 3 | 2/0 | 51 | 08-28-2026 | 1,012 | $1,186 | 5,059 | $237 | 1956 | 2019 | $1,106,300 | $1,001,200 | $105,100 | 108% | Garden, Sunrise, Sunset | Other | None | 1 Car, 2 Car, Carport, Driveway, Street | Haleiwa | Waialua | Waialua | 05 - R-5 | |
| FS|OH|OV|MV | Photos | Active | 202609976 | $1,295,000 | $1,469,000 | $271 | North Shore | Haleiwa | 66-34 Haleiwa Loop | Excellent | 3 | 1/0 | 151 | 05-20-2026 | 1,000 | $1,295 | 5,120 | $253 | 1958 | 2024 | $1,113,600 | $1,002,400 | $111,200 | 116% | Coastline, Garden, Mountain, Ocean, Sunrise, Sunset | Other | None | 1 Car, Driveway, Garage, Street | Haleiwa | Waialua | Waialua | 05 - R-5 | |
| FS|OH | Photos | Active | 202618531 | $1,295,000 | $1,295,000 | $284 | North Shore | Haleiwa | 62-106 Emerson Road | Above Average | 3 | 2/0 | 17 | 10-01-2026 | 1,104 | $1,173 | 10,000 | $130 | 1963 | 2025 | $974,900 | $792,000 | $182,900 | 133% | Sunrise, Sunset | Other | None | 3 Car+, Carport, Driveway, Street | 05 - R-5 | ||||
| FS|OH | Photos | Active | 202615934 | $1,699,000 | $1,749,000 | $402 | North Shore | Haleiwa | 66-474 Pikai Street | Excellent | 4 | 2/0 | 53 | 08-26-2026 | 1,246 | $1,364 | 5,200 | $327 | 1959 | 2026 | $1,141,900 | $1,004,000 | $137,900 | 149% | Garden | Other | None | Driveway | 05 - R-5 | ||||
| FS|OV|MV | Photos | Active | 202616719 | $3,195,000 | $3,195,000 | $625 | North Shore | Haleiwa | 66-471 Pikai Street | Excellent | 5 | 3/0 | 39 | 09-09-2026 | 2,856 | $1,119 | 7,786 | $410 | 1969 | 2026 | $2,303,200 | $1,400,100 | $903,100 | 139% | Coastline, Mountain, Ocean, Sunset | Ocean, Sandy Beach, Waterfront | None | 2 Car | Haleiwa | Waialua | Waialua | 05 - R-5 |
| Guide | |
|---|---|
| DOM | Days on Market until in escrow. |
| Up to 30 Days on Market | Light Green |
| 31 to 60 Days on Market | Pink |
| Over 60 Days on Market | Yellow |
| Active | Available for sale — Under or equal to 10 Days on Market. |
| Active | Available for sale — Over 10 Days on Market. |
| Contract | In escrow but still showing and looking for backup offers. |
| Pending | In escrow and not looking for backup offers and possibly closing soon. |
| Sold | Not available for sale. |
| Cancelled | The seller canceled the listing contract. Not available for sale. |
| Expired | The listing contract expired. Might still be in escrow. |
| Hold | Active listing that is paused. Does not accrue Days on Market. |
| FS | Fee Simple — you own the land. |
| LH | Leasehold — you do not own the land, you are leasing it. |
| OH | Open House — Upcoming Open House |
| FC | Foreclosure — Bank owned. |
| SS | Short Sale — needs lender approval to sell for less than the mortgage balance. |
| SU | Subject to replacement property. Seller must find a replacement property to close. |
| OV | Ocean View |
| MV | Mountain View |
| CPR | Condo — Condominium Property Regime. |
| PL | Pool — Example: Above Ground, Heated, In Ground, Spa/HotTub, Tile, Pool on Property, Community Association Pool |
| BF | Beachfront |
| OF | Oceanfront |