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
    International property

    homes logo

    Property tools and information to help you research the market.

main content
  1. Home
  2. Property
  3. Sold
  4. Auckland
  5. Saint Johns
  6. 24 Coldham Crescent, Saint Johns, Auckland
24 Coldham Crescent, Saint Johns, Auckland - Carousel 1
24 Coldham Crescent, Saint Johns, Auckland - Carousel 2
24 Coldham Crescent, Saint Johns, Auckland - Carousel 4
24 Coldham Crescent, Saint Johns, Auckland - Carousel 1
24 Coldham Crescent, Saint Johns, Auckland - Carousel 2
24 Coldham Crescent, Saint Johns, Auckland - Carousel 3
24 Coldham Crescent, Saint Johns, Auckland - Carousel 4
Estimate

24 Coldham Crescent, Saint Johns, Auckland

HomesEstimate: $2.41M - $2.7M
  • 4 Beds
  • 2 Baths
  • 6 Parks
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: 18 Sept 2025

$2.41M - $2.7M

What is the HomesEstimate?

RentEstimate

Updated: 02 Jul 2025

$950 - $1,150 /week

Rental yield

2.1%

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

01 May 2024
Capital Value

$2,825,000

01 January 2024
Consent issued
Rbw - total re-clad & slight wall & roof extension to gge area of existing single level 3 bdrm 2 bathrm existing residenceRead more
31 March 2023
Sold

$2,245,000

S11
01 June 2021
Capital Value

$3,000,000

01 July 2017
Capital Value

$2,275,000

01 July 2014
Capital Value

$1,230,000

17 September 1992
Sold

$340,000

S11
27 March 1992
Sold

$N/A

S43
28 January 1988
Sold

$N/A

S22
01 January 1980
Decade built

1980

Local Schools

All (20) Primary (10) Intermediate (10) Secondary (8)
  • IN ZONE

    Allum Street

    2.2 km

    Full Primary (Primary & Intermediate), State, 826 enrolled


  • IN ZONE

    Kohimarama Road

    2.3 km

    Secondary (Year 9-13) (Secondary), State, 1638 enrolled


  • IN ZONE

    237 Victoria Avenue

    3.5 km

    Secondary (Year 7-13) (Intermediate & Secondary), State : Integrated, 1505 enrolled


  • IN ZONE

    21 Crossfield Road

    3.8 km

    Secondary (Year 9-13) (Secondary), State, 1209 enrolled


  • UNZONED

    63 Magma Cres

    493 m

    Homebased Network (Early Childhood), Privately owned, 63 enrolled


  • OUT OF ZONE

    81 Tihi Street

    947 m

    Full Primary (Primary & Intermediate), State, 662 enrolled


  • UNZONED

    6 Mt Carmel Place

    1.2 km

    Contributing (Primary), State : Integrated, 217 enrolled


  • UNZONED

    122 Celtic Crescent

    1.3 km

    Free Kindergarten (Early Childhood), Community based, 46 enrolled


  • UNZONED

    49 Howard Hunter Avenue

    1.3 km

    Free Kindergarten (Early Childhood), Community based, 46 enrolled


  • UNZONED

    2/239 St Johns Road

    1.4 km

    Homebased Network (Early Childhood), Privately owned, 50 enrolled


  • OUT OF ZONE

    Waiatarua Road

    1.4 km

    Contributing (Primary), State, 808 enrolled


  • OUT OF ZONE

    2 B Harris Road

    1.5 km

    Full Primary (Primary & Intermediate), State, 582 enrolled


  • UNZONED

    122 Meadowbank Road

    1.6 km

    Free Kindergarten (Early Childhood), Community based, 44 enrolled


  • UNZONED

    55 Amy Street

    2 km

    Composite (Year 1-13) (Primary, Intermediate & Secondary), State : Integrated, 308 enrolled


  • UNZONED

    103 Castledine Crescent

    2.2 km

    Full Primary (Primary & Intermediate), State : Integrated, 123 enrolled


  • OUT OF ZONE

    87 Mount Wellington Highway

    2.3 km

    Full Primary (Primary & Intermediate), State, 183 enrolled


  • UNZONED

    18 Pilkington Road

    2.6 km

    Secondary (Year 7-13) (Intermediate & Secondary), Private : Fully Registered, 35 enrolled


  • UNZONED

    26 A Farringdon Street

    2.6 km

    Composite (Year 1-13) (Primary, Intermediate & Secondary), State, 98 enrolled


  • UNZONED

    21 Domain Road

    2.8 km

    Composite (Year 1-13) (Primary, Intermediate & Secondary), Private : Fully Registered, 13 enrolled


  • OUT OF ZONE

    Elstree Avenue

    3.1 km

    Secondary (Year 9-13) (Secondary), State, 788 enrolled


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
249A St Johns Road, Saint Johns, Auckland
Sold: 28 Aug 2025
249A St Johns Road, Saint Johns, Auckland
  • 4
  • 2
SOLD: $1,765,000
Sold
147A Saint Johns Road, Saint Johns, Auckland
Sold: 23 Aug 2025
147A Saint Johns Road, Saint Johns, Auckland
  • 3
  • 2
SOLD: $860,000
Sold
No image
Sold: 13 Aug 2025
4/136 St Johns Road, Meadowbank, Auckland
  • 2
  • 1
SOLD: $830,000
Sold
24 Swainston Road, Saint Johns, Auckland
Sold: 01 Aug 2025
24 Swainston Road, Saint Johns, Auckland
  • 3
  • 1
SOLD: $1,750,000
Sold
No image
Sold: 24 Jul 2025
2 Morehu Wilson Road, St Johns, Auckland
  • -
  • 0
SOLD: $1,760,000
Sold
163B St Johns Road, Saint Johns, Auckland
Sold: 23 Jul 2025
163B St Johns Road, Saint Johns, Auckland
  • 3
  • 2
SOLD: $1,250,000
Sold
No image
Sold: 21 Jul 2025
1 Marutuahu Road, JOHNS
  • -
  • 0
SOLD: $2,025,000
Sold
2/58 St Johns Road, Meadowbank, Auckland
Sold: 21 Jul 2025
2/58 St Johns Road, Meadowbank, Auckland
  • 3
  • 2
SOLD: $1,174,595
Sold
1 Peart View, Saint Johns, Auckland
Sold: 18 Jul 2025
1 Peart View, Saint Johns, Auckland
  • 3
  • 1
SOLD: $1,280,000
Sold
15A Caulton Street, Saint Johns, Auckland
Sold: 16 Jul 2025
15A Caulton Street, Saint Johns, Auckland
  • 3
  • 1
SOLD: $1,010,694
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
  • International property
  • News & guides
  • Sold Properties
  • OneHub for agents
  • Find a Real Estate Agent
  • Motors
  • Browse all cars
  • Other vehicles
  • Buying & Selling
  • Dealer news & info
  • Sell my car
  • Jobs
  • Browse categories
  • Careers advice
  • JobSmart
  • Advertisers advice
  • Salary guide
  • Services
  • Trades
  • Domestic services
  • Events & entertainment
  • Health & wellbeing
  • List my services
  • Community
  • Help
  • Announcements
  • Trust & safety
  • Seller information
  • Help center community
  • Desktop site
  • Help
  • Contact Us
  • Terms & conditions
  • About Us
  • Newsroom
  • Careers
  • Advertise
  • Privacy policy
  • Trade Me Insurance
  • homes.co.nz
  • MotorWeb
  • Holiday Houses
  • FindSomeone
© 2025 Trade Me Limited
  • Desktop site
  • About Us
  • Careers
  • Advertise
  • Privacy policy
  • Terms & conditions
  • Contact Us
Log in
Sign up
© 2025 Trade Me Limited