9 properties · Red Beach, Whangaparāoa

Mermaid Mews, Red Beach

Mermaid Mews in Red Beach has 9 properties, valued by the council between $1,150,000 and $1,300,000 with a median of $1,237,500 (Red Beach: $1,175,000). Most of its homes were built in the 2000s. We estimate its homes at a median $1,270,000. The last sale we have was in August 2025, for $1,325,000.

$1.24mmedian council valuation
$1.27mour median estimate
2000median year built
WhangaparāoaRed Beach ×Mermaid Mews ×

9 properties on Mermaid Mews, Red Beach

Highest and lowest on Mermaid Mews

Highest-valued home5 Mermaid Mews$1,300,000council valuation · 4 bed · 228 m² floor · 665 m² land
Lowest-valued home6 Mermaid Mews$1,150,000council valuation · 4 bed · 194 m² floor · 557 m² land

Property values on Mermaid Mews

The council values Mermaid Mews's 8 rated properties between $1,150,000 and $1,300,000. The middle half sit between about $1,217,500 and $1,250,000; the median is $1,237,500 and the mean $1,231,250.

Lowest: $1.15m$1.15mLowest10%: $1.19m20%: $1.21m20%30%: $1.23m40%: $1.23m40%Median: $1.24m60%: $1.25m60%70%: $1.25m80%: $1.25m80%90%: $1.26mHighest: $1.3m$1.3mHighest
BedroomsHomesMedian council valueSold, last 12 monthsMedian sale
48$1.24m0—

Council rating valuations: the council's figure for apportioning rates, not a market appraisal.

Mermaid Mews compared with Red Beach

Mermaid Mews's median council value is 5% above Red Beach's.

Mermaid MewsRed BeachWhangaparāoa
Median council value$1.24m$1.18m$1.02m
Median section616 m²674 m²809 m²
Median year built200019901990
Council value per m² of floor$6k$7k$6k

Recent sales on Mermaid Mews

  • 2 Mermaid Mews$1,325,00020 Aug 2025 · 4 bed · 212 m² floor · 670 m² land
  • 4 Mermaid Mews$1,199,00020 Nov 2022 · 4 bed · 212 m² floor · 641 m² land
  • 3 Mermaid Mews$1,500,0003 Feb 2022 · 4 bed · 214 m² floor · 621 m² land
  • 11 Mermaid Mews$1,002,00010 Oct 2019 · 4 bed · 205 m² floor · 589 m² land
  • 6 Mermaid Mews$760,00015 Oct 2014 · 4 bed · 194 m² floor · 557 m² land
  • 11 Mermaid Mews$601,0001 Mar 2012 · 4 bed · 205 m² floor · 589 m² land
  • 11 Mermaid Mews$585,0003 May 2010 · 4 bed · 205 m² floor · 589 m² land
  • 3 Mermaid Mews$590,00016 Sept 2009 · 4 bed · 214 m² floor · 621 m² land
  • 7 Mermaid Mews$610,00030 Apr 2009 · 4 bed · 215 m² floor · 587 m² land
  • 5 Mermaid Mews$617,42524 Apr 2009 · 4 bed · 228 m² floor · 665 m² land
  • 4 Mermaid Mews$557,5005 Apr 2009 · 4 bed · 212 m² floor · 641 m² land
  • 2 Mermaid Mews$542,00026 Mar 2009 · 4 bed · 212 m² floor · 670 m² land
  • 6 Mermaid Mews$520,00016 Mar 2009 · 4 bed · 194 m² floor · 557 m² land
  • 11 Mermaid Mews$559,00016 Dec 2008 · 4 bed · 205 m² floor · 589 m² land
  • 9 Mermaid Mews$605,00028 Nov 2008 · 4 bed · 217 m² floor · 611 m² land

The homes on Mermaid Mews

Mermaid Mews has 9 houses. Most were built in the 2000s (100%).

Sales and valuations as at 11 September 2026, from council and LINZ records. Medians resting on fewer than 3 sales are not shown.