223 properties · Ellerslie, Auckland

Celtic Crescent, Ellerslie

Celtic Crescent in Ellerslie has 223 properties, valued by the council between $540,000 and $3,225,000 with a median of $1,412,500 (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. 3 are for sale now.

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

223 properties on Celtic Crescent, Ellerslie

Highest and lowest on Celtic Crescent

Highest-valued home155-157 Celtic Crescent$3,225,000council valuation · 5 bed · 344 m² floor · 1,468 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 218 rated properties between $540,000 and $3,225,000. The middle half sit between about $897,000 and $1,707,500; the median is $1,412,500 and the mean $1,355,894.

Lowest: $540k$540kLowest10%: $710k20%: $744k20%30%: $1.05m40%: $1.13m40%Median: $1.41m60%: $1.57m60%70%: $1.63m80%: $1.79m80%90%: $1.96mHighest: $3.23m$3.23mHighest
BedroomsHomesMedian council valueSold, last 12 monthsMedian sale
15$610k1—
258$720k3$712k
394$1.55m2—
443$1.77m2—
5+5$2.05m0—

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 26% above Ellerslie's.

Celtic CrescentEllerslieAuckland
Median council value$1.41m$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 117 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: 35 (35 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

17building consents in the last 5 years
7resource consents in the last 5 years
  • 109 Celtic Crescent1 Aug 2026 · Building consentRbw - lot 1 - reinstate footing & slab to support construction of new external timber frame wall with brick veneer cladding only. Lot 2 - construction of one two-storey detached dwg with 4 bedr
  • 111 Celtic Crescent1 Jul 2026 · Building consentRbw - internal alt to single storey dwg- reconfigure existing laundry & bathrm, replace plumbing fixtures, replace e xisting window, replace hot water cylinder
  • 117 Celtic Crescent1 Jul 2026 · Building consentRbw - separation from bco10406726. Renovation & add to existing single storey dwg. New master bdrm, ensuite & wir to rear of property.
  • 27 Celtic Crescent1 Jul 2026 · Building consentinstallation of a solid wood fire - replace old fire with kent Rata insert fire.
  • 93 Celtic Crescent1 May 2026 · Building consentRbw - 3 x new two storey dwgs. Lots 1 & 2 each with three bedrooms, 2.5 bathrooms, & attached single gge; lots 3 with 4 bedrooms, three bathrooms, & attached dbl gge. New retaining
  • 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 consentThis discretionary activity under s127 of the Resource Management Act 1991 (RMA) is for changes to conditions of LUC60422954. To vary Conditions 1, 13, 14, 15, 17, 19, insert Condition 13A, and cance

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

Agents who sold on Celtic Crescent

The real estate agents credited on Celtic Crescent sales since 2016, most first. Selling here? These are the agents who have sold your neighbours' homes. A count of sales, not a rating. Every agent who sold in Ellerslie.

  1. Debbie-Lee WallaceBarfoot & Thompson Stonefields
    7 sales on Celtic Crescent · last Jul 2026
  2. Gary ThomasRay White Ellerslie
    4 sales on Celtic Crescent · last Jul 2021
  3. James BegleyRay White Ellerslie
    3 sales on Celtic Crescent · last Oct 2024
  4. Wendy SaddBarfoot & Thompson Greenlane
    2 sales on Celtic Crescent · last Nov 2025
  5. Krishin RamaRay White Parnell
    2 sales on Celtic Crescent · last Jul 2024
  6. Keri YildizRay White Remuera
    2 sales on Celtic Crescent · last Sep 2023
  7. Zafer YildizRay White Remuera
    2 sales on Celtic Crescent · last Sep 2023
  8. Ari StarrRay White Remuera
    2 sales on Celtic Crescent · last Aug 2022
  9. Colleen HarrisBayleys Real Estate Remuera
    2 sales on Celtic Crescent · last Jul 2019

115 sales on Celtic Crescent since 2016; 53 of them name an agent we can show, and the counts here are taken from those.

Every address on Celtic Crescent

223

About property on Celtic Crescent, Ellerslie

Every property in Celtic Crescent, Ellerslie, whether it is for sale or not: homes, sections, farms, lifestyle blocks, shops, offices and industrial land. Each is listed from the council rating roll and Toitū Te Whenua LINZ, with the listing beside it when an agent is marketing it.

Each property has its own page: our estimate of its value beside the council rating valuation, past sale prices, the title and land area, zoning and hazards, building consents, and what it would cost to own.

Listings are published by the agents who market them. Addresses, land details and rating valuations come from Toitū Te Whenua Land Information New Zealand and from the council. No ownership information is published.