222 properties · Ellerslie, Auckland

Celtic Crescent, Ellerslie

Celtic Crescent in Ellerslie has 222 properties, valued by the council between $540,000 and $2,750,000 with a median of $1,400,000 (Ellerslie: $1,125,000). More of its homes were built in the 1970s than in any other decade. We estimate its homes at a median $1,340,000. 10 sold in the last twelve months, for a median $1,117,500. The highest sale in 2026 was 77 Celtic Crescent, at $1,930,000.

$1.4mmedian council valuation
$1.34mour median estimate
$1.12mmedian sale, last 12 months · 10 sales
1970median year built
AucklandEllerslie ×Celtic Crescent ×

222 properties on Celtic Crescent, Ellerslie

Highest and lowest on Celtic Crescent

Highest-valued home113 Celtic Crescent$2,750,000council valuation · 4 bed · 269 m² floor · 958 m² land
Lowest-valued home2/137 Celtic Crescent$540,000council valuation · 1 bed · 44 m² floor
Highest sale in 202677 Celtic Crescent$1,930,000sold 6 May 2026 · 4 bed · 96 m² floor · 607 m² land

Property values on Celtic Crescent

The council values Celtic Crescent's 217 rated properties between $540,000 and $2,750,000. The middle half sit between about $896,000 and $1,700,000; the median is $1,400,000 and the mean $1,347,281.

Lowest: $540k$540kLowest10%: $710k20%: $742k20%30%: $1.05m40%: $1.13m40%Median: $1.4m60%: $1.57m60%70%: $1.63m80%: $1.77m80%90%: $1.95mHighest: $2.75m$2.75mHighest
BedroomsHomesMedian council valueSold, last 12 monthsMedian sale
15$610k1—
258$720k3$712k
394$1.55m2—
443$1.77m2—
5+4$2.0m0—

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

Celtic Crescent compared with Ellerslie

Celtic Crescent's median council value is 24% above Ellerslie's.

Celtic CrescentEllerslieAuckland
Median council value$1.4m$1.13m$1.07m
Median sale, last 12 months$1.12m$1.04m$1.0m
Sold in the last 12 months4.5%4%3.6%
Time between sales12.2 yrs10.2 yrs8.9 yrs
Median section607 m²498 m²607 m²
Median year built197019801980
Council value per m² of floor$11k$10k$8k

Celtic Crescent house prices over time

Median sale price by year; 2026 is the year so far. A year with fewer than two sales has no bar.

2016: $1.12m (7 sales)$1.12m20162017: $730k (15 sales)2018: $933k (6 sales)20182019: $1.08m (12 sales)2020: $973k (10 sales)20202021: $1.55m (11 sales)2022: $955k (9 sales)20222023: $1.46m (6 sales)2024: $1.57m (9 sales)$1.57m20242025: $1.33m (12 sales)2026: $906k (4 sales, this year so far)$906k2026
Sales by year as a table
YearSalesMedian pricePer m² floor
20264$906,000$11,957
202512$1,333,500$10,575
20249$1,570,000$11,074
20236$1,457,500$9,353
20229$955,000$12,742
202111$1,554,000$15,603
202010$972,500$11,558
201912$1,080,000$10,880
20186$932,500$7,171
201715$730,000$9,958
20167$1,121,000$8,630

Recent sales on Celtic Crescent

The homes on Celtic Crescent

Celtic Crescent has 116 houses, 97 units and townhouses and 9 apartments. More were built in the 1970s than in any other decade (41%).

1950s: 1 (1 home)11950s1960s: 70 (70 homes)1960s1970s: 89 (89 homes)891970s1980s: 34 (34 homes)1980s1990s: 7 (7 homes)1990s2000s: 2 (2 homes)2000s2010s: 2 (2 homes)2010s2020s: 12 (12 homes)122020s

How long owners stay on Celtic Crescent

Homes on Celtic Crescent that resold in the last five years had been held a median 12.2 years (Ellerslie: 10.2 years).

Time between a home's sales, for 35 resales in the last five years. A home not sold since our records begin is not counted, so owners who stay longest are under-represented.

Building and resource consents on Celtic Crescent

7resource consents in the last 5 years
  • 83 Celtic Crescent22 Apr 2025 · Resource consentTo establish three dwellings and undertaken a fee simple subdivision around the approved development
  • 83 Celtic Crescent22 Apr 2025 · Resource consentTo establish three dwellings and undertaken a fee simple subdivision around the approved development
  • 127 Celtic Crescent21 Nov 2024 · Resource consentTo construct three new stand-alone double-storey dwellings on site and subsequently subdivide into 3 fee-simple lots. A new shared d riveway is to be established with right-of-way arrangement. The ass
  • 127 Celtic Crescent21 Nov 2024 · Resource consentTo construct three new stand-alone double-storey dwellings on site and subsequently subdivide into 3 fee-simple lots. A new shared d riveway is to be established with right-of-way arrangement. The ass
  • 52B Celtic Crescent31 Oct 2024 · Resource consentALL FEES to LUC60422954-A This discretionary activity under s127 of the Resource Management Act 1991 (RMA) is for changes to the conditions of consent SUB60422955 of BUN60422953. To vary Conditions 1

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