
Celmisia Retreat in Papamoa Beach has 15 properties, valued by the council between $910,000 and $1,260,000 with a median of $1,040,000 (Papamoa Beach: $970,000). Most of its homes were built in the 2010s. We estimate its homes at a median $1,100,000. 3 sold in the last twelve months, for a median $1,170,000. The highest sale in 2026 was 8 Celmisia Retreat, at $1,325,000.















The council values Celmisia Retreat's 13 rated properties between $910,000 and $1,260,000. The middle half sit between about $990,000 and $1,076,000; the median is $1,040,000 and the mean $1,039,615.
| Bedrooms | Homes | Median council value | Sold, last 12 months | Median sale |
|---|---|---|---|---|
| 2 | 1 | $1.26m | 0 | — |
| 3 | 5 | $990k | 1 | — |
| 4 | 7 | $1.04m | 2 | — |
Council rating valuations: the council's figure for apportioning rates, not a market appraisal.
Celmisia Retreat's median council value is 7% above Papamoa Beach's.
| Celmisia Retreat | Papamoa Beach | Papamoa | |
|---|---|---|---|
| Median council value | $1.04m | $970k | $945k |
| Median sale, last 12 months | $1.17m | $1.01m | $980k |
| Sold in the last 12 months | 20% | 4.8% | 4.9% |
| Median section | 361 m² | 551 m² | 524 m² |
| Median year built | 2010 | 2000 | 2000 |
| Council value per m² of floor | $6k | $6k | $6k |
Median sale price by year; 2026 is the year so far. A year with fewer than two sales has no bar.
| Year | Sales | Median price | Per m² floor |
|---|---|---|---|
| 2026 | 3 | $1,170,000 | $6,257 |
| 2024 | 1 | $1,010,000 | $5,872 |
| 2022 | 2 | $1,350,000 | $8,074 |
| 2021 | 2 | $1,232,500 | $6,345 |
| 2020 | 1 | $989,000 | $5,588 |
| 2019 | 3 | $788,500 | $4,305 |
| 2018 | 3 | $675,000 | $3,765 |
| 2017 | 4 | $724,000 | $3,882 |
| 2016 | 8 | $692,000 | $3,822 |
Celmisia Retreat has 15 houses. Most were built in the 2010s (100%).
Every street in Papamoa Beach, 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.