Skip to site navigation Skip to main content
Trade Me
  • Watchlist
  • Favourites
  • Start a listing
  • Sign up Log in
  • For sale
  • For rent
  • Sold
  • New homes
  • Commercial
  • List a property
  • For sale
  • For rent
  • Sold
  • New homes
  • Flatmates
  • Commercial
  • Rural
  • Businesses
  • Retirement villages
Request an Appraisal Find an Agent News & Selling guides Seller's hub
List a property
    My Homes
    Buyers guides
    Renters guides
    Research sold properties

    homes logo

    Property tools and information to help you research the market.

main content
  1. Home
  2. Property
  3. Sold
  4. Auckland
  5. Ellerslie
  6. 40 Celtic Crescent
40 Celtic Crescent, Ellerslie, Auckland - Carousel 1
40 Celtic Crescent, Ellerslie, Auckland - Carousel 2
40 Celtic Crescent, Ellerslie, Auckland - Carousel 45
40 Celtic Crescent, Ellerslie, Auckland - Carousel 1
40 Celtic Crescent, Ellerslie, Auckland - Carousel 2
40 Celtic Crescent, Ellerslie, Auckland - Carousel 3
40 Celtic Crescent, Ellerslie, Auckland - Carousel 4
40 Celtic Crescent, Ellerslie, Auckland - Carousel 5
40 Celtic Crescent, Ellerslie, Auckland - Carousel 6
40 Celtic Crescent, Ellerslie, Auckland - Carousel 7
40 Celtic Crescent, Ellerslie, Auckland - Carousel 8
40 Celtic Crescent, Ellerslie, Auckland - Carousel 9
40 Celtic Crescent, Ellerslie, Auckland - Carousel 10
40 Celtic Crescent, Ellerslie, Auckland - Carousel 11
40 Celtic Crescent, Ellerslie, Auckland - Carousel 12
40 Celtic Crescent, Ellerslie, Auckland - Carousel 13
40 Celtic Crescent, Ellerslie, Auckland - Carousel 14
40 Celtic Crescent, Ellerslie, Auckland - Carousel 15
40 Celtic Crescent, Ellerslie, Auckland - Carousel 16
40 Celtic Crescent, Ellerslie, Auckland - Carousel 17
40 Celtic Crescent, Ellerslie, Auckland - Carousel 18
40 Celtic Crescent, Ellerslie, Auckland - Carousel 19
40 Celtic Crescent, Ellerslie, Auckland - Carousel 20
40 Celtic Crescent, Ellerslie, Auckland - Carousel 21
40 Celtic Crescent, Ellerslie, Auckland - Carousel 22
40 Celtic Crescent, Ellerslie, Auckland - Carousel 23
40 Celtic Crescent, Ellerslie, Auckland - Carousel 24
40 Celtic Crescent, Ellerslie, Auckland - Carousel 25
40 Celtic Crescent, Ellerslie, Auckland - Carousel 26
40 Celtic Crescent, Ellerslie, Auckland - Carousel 27
40 Celtic Crescent, Ellerslie, Auckland - Carousel 28
40 Celtic Crescent, Ellerslie, Auckland - Carousel 29
40 Celtic Crescent, Ellerslie, Auckland - Carousel 30
40 Celtic Crescent, Ellerslie, Auckland - Carousel 31
40 Celtic Crescent, Ellerslie, Auckland - Carousel 32
40 Celtic Crescent, Ellerslie, Auckland - Carousel 33
40 Celtic Crescent, Ellerslie, Auckland - Carousel 34
40 Celtic Crescent, Ellerslie, Auckland - Carousel 35
40 Celtic Crescent, Ellerslie, Auckland - Carousel 36
40 Celtic Crescent, Ellerslie, Auckland - Carousel 37
40 Celtic Crescent, Ellerslie, Auckland - Carousel 38
40 Celtic Crescent, Ellerslie, Auckland - Carousel 39
40 Celtic Crescent, Ellerslie, Auckland - Carousel 40
40 Celtic Crescent, Ellerslie, Auckland - Carousel 41
40 Celtic Crescent, Ellerslie, Auckland - Carousel 42
40 Celtic Crescent, Ellerslie, Auckland - Carousel 43
40 Celtic Crescent, Ellerslie, Auckland - Carousel 44
40 Celtic Crescent, Ellerslie, Auckland - Carousel 45
Estimate

40 Celtic Crescent, Ellerslie, Auckland

HomesEstimate: $1.42M - $1.6M
  • 3 Beds
  • 1 Bath
  • 4 Parks

Property details

Ownership type (Council record)
Freehold
Floor Area (Council record)
131m² more or less
Land area (Council record)
607m² more or less
Bedrooms (Council record)
3 Bedrooms
Bathrooms (Council record)
1 Bathroom
Garage parking (Council record)
2 Garage parking
Off-street parking
2 Off-street parking
Has deck
Yes
View type
None
Decade built
1970s
Wall material
Wood in all forms, including treated plywood and compressed wood products
Roof material
Tiles, including all materials with a tile profile
Building footprint
100m² more or less
Contour
Level
Capital value (CV)
$1,575,000
Land value
$1,475,000
Improvement value
$100,000
Certificate of title
NA11C/130
Legal description
LOT 147 DP 56995 607M2
Track home card illustration

Stay updated on this property!

Receive updates on value estimates and be the first to know if it goes on sale.

Property estimateCapital valueTrends

HomesEstimate

Updated: 20 Aug 2026

$1.42M - $1.6M

What is the HomesEstimate?

RentEstimate

Updated: 02 Jun 2025

$730 - $870 /week

Rental yield

2.8%

What is rental yield?

These are computer-generated price estimates.
To understand your home’s value, get an appraisal from a local agent.

Sale history timeline

  1. 18 February 2025
    Sold

    $1,553,000

    S11
  2. 01 May 2024
    Capital Value

    $1,575,000

  3. 01 June 2021
    Capital Value

    $1,825,000

  4. 14 March 2020
    Sold

    $1,425,000

    S11
  5. 01 July 2017
    Capital Value

    $1,260,000

  6. 30 June 2016
    Sold

    $1,410,000

    S11
  7. 01 July 2014
    Capital Value

    $860,000

  8. 03 August 2011
    Sold

    $621,000

    S11
  9. 27 August 1997
    Sold

    $312,000

    S11
  10. 01 January 1970
    Decade built

    1970

Local Schools

All (0) Primary (0) Intermediate (0) Secondary (0)

While we've done our best to correctly list schools in this location, school zone information may not be exact, so please double check with the school.

Nearby Sold Properties

View all
Sold
2/32 Michaels Avenue, Ellerslie, Auckland
Sold: 24 Jul 2026
2/32 Michaels Avenue, Ellerslie, Auckland
  • -
  • 0
SOLD: $1,930,000
Sold
30F Umere Crescent, Ellerslie, Auckland
Sold: 12 Jul 2026
30F Umere Crescent, Ellerslie, Auckland
  • 4
  • 0
SOLD: $2,200,000
Sold
26 Umere Crescent, Ellerslie, Auckland
Sold: 10 Jul 2026
26 Umere Crescent, Ellerslie, Auckland
  • 4
  • 2
SOLD: $1,170,000
Sold
1/58 Ballarat Street, Ellerslie, Auckland
Sold: 03 Jul 2026
1/58 Ballarat Street, Ellerslie, Auckland
  • 3
  • 1
SOLD: $1,085,000
Sold
2/11 Lonsdale Street, Ellerslie, Auckland
Sold: 01 Jul 2026
2/11 Lonsdale Street, Ellerslie, Auckland
  • 3
  • 2
SOLD: $1,265,000
Sold
3/7 Celtic Crescent, Ellerslie, Auckland
Sold: 29 Jun 2026
3/7 Celtic Crescent, Ellerslie, Auckland
  • 2
  • 1
SOLD: $675,000
Sold
7/55 Ballarat Street, Mount Wellington, Auckland
Sold: 28 Jun 2026
7/55 Ballarat Street, Mount Wellington, Auckland
  • 3
  • 2
SOLD: $1,200,000
Sold
20A Pukerangi Crescent, Ellerslie, Auckland
Sold: 24 Jun 2026
20A Pukerangi Crescent, Ellerslie, Auckland
  • 1
  • 1
SOLD: $490,000
Sold
20B Ballin Street, Ellerslie, Auckland
Sold: 17 Jun 2026
20B Ballin Street, Ellerslie, Auckland
  • 4
  • 2
SOLD: $1,555,000
Sold
15B Glenties Lane, Ellerslie, Auckland
Sold: 13 Jun 2026
15B Glenties Lane, Ellerslie, Auckland
  • 3
  • 1
SOLD: $1,030,000

Properties for sale around Ellerslie

View all

62A Ballarat Street, Ellerslie, Auckland City

  • 3
  • 1
Deadline sale by 16 Sept
Affordable Central Gem with Endless Potential

10 Flax Place, Stonefields, Auckland City

  • 3
  • 2
Auction on 7 Aug, 9:52 am
Freehold End-Unit Living with Sun, Space & Privacy

10 Flax Place, Stonefields, Auckland City

  • 3
  • 2
Auction on 6 Aug, 9:55 am
Freehold End-Unit Living with Sun, Space & Privacy

20 Park Avenue (Hotel), Ellerslie, Auckland City

  • 1
  • 1
Asking price $254,999
2CAPPRHN9JYNOHN26V9T

12 Mapau Road, Greenlane, Auckland City

  • 4
  • 2
Auction on 10 Jun, 10:00 am
Charming Family Living in DGZ

12 Mapau Road, Greenlane, Auckland City

  • 4
  • 2
Auction on 10 Jun, 10:00 am
Charming Family Living in DGZ

66/666B Great South Road, Ellerslie, Auckland City

  • 2
  • 2
Auction on 4 Jun, 5:04 am
MORTGAGEE SALE

66/666B Great South Road, Ellerslie, Auckland City

  • 2
  • 2
Auction on 31 May, 5:02 am
MORTGAGEE SALE

60,64,64A Walls Road, Penrose, Auckland City

  • 1
  • 1
For sale by tender, 30 Apr
MORTGAGEE SALE

2/2 Marua Road, Ellerslie, Auckland City

  • 3
  • 2
Auction on 1 Apr, 10:00 am
Elevated Ellerslie – 3 Bed, 2.5 Bath, Dble Garage

1/2 Marua Road, Ellerslie, Auckland City

  • 3
  • 2
Auction on 1 Apr, 10:00 am
Sunny Ellerslie – 3 Bed, 2.5 Bath, Dble Garage

20-20A Kalmia Street, Ellerslie, Auckland City

Price by negotiation
A5INVGEKMDI2AD2B7QQL

3/28 Matai Road, Greenlane, Auckland City

  • 2
  • 1
Auction on 19 Nov, 10:00 am
XGUGQLKTVG713R13C66O

20-20A Kalmia Street, Ellerslie, Auckland City

Price by negotiation
MAAVKOLXHUSW9OQZU26Q

38A Waiohua Road, Greenlane, Auckland City

  • 3
  • 2
Auction on 11 Dec, 9:57 am
Elevated Outlook - First Home, Downsize or Invest
Thinking of selling?Determine your property's value with an appraisal
We are upgrading some of our systems
Learn more
  • Trade Me
  • Start a listing
  • Watchlist
  • Favourites
  • Log in
    Sign up
  • Marketplace
  • Latest deals
  • Stores
  • Closing soon
  • $1 reserve
  • Home & Living
  • Property
  • Property news & guides
  • Sold Properties
  • Open Homes
  • OneHub for agents
  • Find a Real Estate Agent
  • Motors
  • Cars for sale
  • Motorbikes for sale
  • Buying & selling advice
  • Dealer news & info
  • Sell my car
  • Jobs
  • Browse job categories
  • Careers advice
  • JobSmart
  • Advertisers advice
  • Salary guide
  • Services
  • Trades
  • Domestic services
  • Events & entertainment
  • Health & wellbeing
  • List my services
  • Community
  • Help
  • Announcements
  • Trust & safety
  • 3rd Party Licenses
  • Seller information
  • Help center community
  • Desktop site
  • Help
  • Contact Us
  • Terms & conditions
  • About Us
  • News
  • Careers
  • Advertise
  • Privacy policy
  • 3rd Party Licenses
  • Trade Me Insurance
  • homes.co.nz
  • MotorWeb
  • CarExpert
  • Holiday Houses
  • FindSomeone
© 2026 Trade Me Limited
  • Desktop site
  • About Us
  • Careers
  • News
  • Advertise
  • Privacy policy
  • Terms & conditions
  • 3rd Party Licenses
  • Contact Us
Log in
Sign up
© 2026 Trade Me Limited