
The Esplanade, Oneroa
The Esplanade in Oneroa has 31 properties, valued by the council between $1,225,000 and $5,150,000 with a median of $2,125,000 (Oneroa: $1,550,000). More of its homes were built in the 1950s than in any other decade. We estimate its homes at a median $1,935,000. The last sale we have was in June 2025, for $2,600,000.
31 properties on The Esplanade, Oneroa
























Highest and lowest on The Esplanade
Property values on The Esplanade
The council values The Esplanade's 27 rated properties between $1,225,000 and $5,150,000. The middle half sit between about $1,852,500 and $2,547,500; the median is $2,125,000 and the mean $2,399,074.
| Bedrooms | Homes | Median council value | Sold, last 12 months | Median sale |
|---|---|---|---|---|
| 1 | 1 | $1.77m | 0 | — |
| 2 | 5 | $1.93m | 0 | — |
| 3 | 14 | $2.01m | 0 | — |
| 4 | 3 | $2.45m | 0 | — |
| 5+ | 3 | $4.85m | 0 | — |
Council rating valuations: the council's figure for apportioning rates, not a market appraisal.
The Esplanade compared with Oneroa
The Esplanade's median council value is 37% above Oneroa's.
| The Esplanade | Oneroa | Waiheke Island | |
|---|---|---|---|
| Median council value | $2.13m | $1.55m | $1.32m |
| Median section | 1,093 m² | 1,060 m² | 1,080 m² |
| Median year built | 1980 | 1980 | 1980 |
| Council value per m² of floor | $19k | $15k | $14k |
The Esplanade house prices over time
Median sale price by year; 2025 is the year so far. A year with fewer than two sales has no bar.
Sales by year as a table
| Year | Sales | Median price | Per m² floor |
|---|---|---|---|
| 2025 | 1 | $2,600,000 | $15,758 |
| 2024 | 1 | $1,950,000 | $33,051 |
| 2020 | 4 | $1,400,000 | $16,617 |
| 2019 | 2 | $2,550,000 | $9,716 |
| 2016 | 2 | $1,342,500 | $14,948 |
Recent sales on The Esplanade
- 72 The Esplanade$2,600,0004 Jun 2025 · 3 bed · 165 m² floor · 1,220 m² land
- 24 The Esplanade$1,950,00023 Oct 2024 · 1 bed · 59 m² floor · 976 m² land
- 16 The Esplanade$2,160,00027 Dec 2020 · 3 bed · 114 m² floor · 971 m² land
- 38 The Esplanade$1,180,00011 Oct 2020 · 3 bed · 160 m² floor · 1,024 m² land
- 74 The Esplanade$1,500,00031 Jul 2020 · 2 bed · 63 m² floor · 2,858 m² land
- 26 The Esplanade$1,300,00015 May 2020 · 3 bed · 91 m² floor · 953 m² land
- 34-36 The Esplanade$3,850,00013 May 2019 · 6 bed · 676 m² floor · 1,908 m² land
- 26 The Esplanade$1,250,00014 Mar 2019 · 3 bed · 91 m² floor · 953 m² land
- 4 The Esplanade$1,425,00026 Aug 2016 · 2 bed · 144 m² floor · 1,037 m² land
- 74 The Esplanade$1,260,0005 Apr 2016 · 2 bed · 63 m² floor · 2,858 m² land
- 78 The Esplanade$895,00024 Aug 2015 · 4 bed · 23 m² floor · 2,125 m² land
- 20 The Esplanade$913,00011 Jul 2012 · 4 bed · 152 m² floor · 921 m² land
- 72 The Esplanade$950,00022 Nov 2011 · 3 bed · 165 m² floor · 1,220 m² land
- 14 The Esplanade$835,00014 Jun 2011 · 3 bed · 98 m² floor · 966 m² land
- 4 The Esplanade$800,00010 May 2010 · 2 bed · 144 m² floor · 1,037 m² land
- 24 The Esplanade$650,0008 May 2009 · 1 bed · 59 m² floor · 976 m² land
- 78 The Esplanade$550,00028 Mar 2007 · 4 bed · 23 m² floor · 2,125 m² land
- 32 The Esplanade$1,030,00013 Jan 2006 · 5 bed · 250 m² floor · 953 m² land
- 2 The Esplanade$935,00022 Oct 2005 · 3 bed · 122 m² floor · 850 m² land
- 20 The Esplanade$950,0004 Mar 2005 · 4 bed · 152 m² floor · 921 m² land
The homes on The Esplanade
The Esplanade has 31 houses. More were built in the 1950s than in any other decade (19%).
Building and resource consents on The Esplanade
- 4 The Esplanade1 Feb 2022 · Building consentrbw - proposed bach on timber pile base with 2 bedrooms, 2 bathrooms. Long run trimrib roofing iron. Vertical adobo vulcan cladding, aluminum joinery. Onsite wastewater system.
- 20 The Esplanade28 Nov 2024 · Resource consentGeneral pruning to 20% to open canopy and pruning of growth extending over house roof living area while maintaining overall form of tree cluster.
- 26 The Esplanade28 Feb 2024 · Resource consentThe discharge of up to 1.015m3 1015 litres of domestic wastewater to land per day from an addition alteration to the existing dwelling to make it a 3 bedroom residential dwelling and a separate office
- 26 The Esplanade28 Feb 2024 · Resource consentDwelling additions alterations.
- 4 The Esplanade6 Sept 2023 · Resource consentReplace garage
- 70 The Esplanade28 Oct 2022 · Resource consentNew dwelling, and garage.
The Esplanade in other suburbs
More streets in Oneroa
- Ocean View Road145
- Queens Drive128
- Great Barrier Road96
- Coromandel Road94
- Hauraki Road73
- Korora Road71
- Makora Avenue62
- Tiri Road56
- Frank Street55
- Goodwin Avenue55
- Tahatai Road53
- Burrell Road52
Every street in Oneroa, and the suburb's house prices and sales.
Sales and valuations as at 11 September 2026, from council and LINZ records. Medians resting on fewer than 3 sales are not shown.