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. Whangaparaoa
  5. Stanmore Bay
  6. 24 Ardern Avenue, Stanmore Bay, Whangaparaoa
Estimate

24 Ardern Avenue, Stanmore Bay, Whangaparaoa

HomesEstimate: $1.61M - $1.8M
  • 4 Beds
  • 2 Baths
  • 2 Parks

Property details

Freehold
237m² more or less
885m² more or less
4 Bedrooms
2 Bathrooms
2 Garage parking
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: 16 Apr 2026

$1.61M - $1.8M

What is the HomesEstimate?

RentEstimate

Updated: 02 Apr 2026

$890 - $1,070 /week

Rental yield

3.0%

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

$1,775,000

01 June 2021
Capital Value

$1,875,000

18 August 2019
Sold

$1,000,000

S11
01 July 2017
Capital Value

$1,500,000

01 July 2014
Capital Value

$1,075,000

01 March 2002
Sold

$600,000

S12
08 February 1996
Sold

$250,000

S11
01 January 2000
Decade built

2000

Local Schools

All (17) Primary (8) Intermediate (7) Secondary (6)
  • IN ZONE

    8 Stanmore Bay Road

    1 km

    Secondary (Year 7-13) (Intermediate & Secondary), State, 1849 enrolled


  • IN ZONE

    39 Ladies Mile

    1.6 km

    Contributing (Primary), State, 818 enrolled


  • UNZONED

    41 A Stanmore Bay Road

    1 km

    Playcentre (Early Childhood), Community based, 38 enrolled


  • UNZONED

    Waiora Road

    1.5 km

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


  • OUT OF ZONE

    32 Waiora Road

    1.6 km

    Contributing (Primary), State, 519 enrolled


  • UNZONED

    7 Motutapu Avenue

    1.8 km

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


  • UNZONED

    31 D'Oyly Drive

    1.8 km

    Homebased Network (Early Childhood), Privately owned


  • OUT OF ZONE

    20 Albert Hall Drive

    4.2 km

    Contributing (Primary), State, 460 enrolled


  • UNZONED

    65 Gulf Harbour Drive

    4.3 km

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


  • UNZONED

    3 Bay Vista Drive

    4.4 km

    Playcentre (Early Childhood), Community based, 50 enrolled


  • UNZONED

    95 Gulf Harbour Drive

    4.5 km

    Full Primary (Primary & Intermediate), Private : Fully Registered, 159 enrolled


  • OUT OF ZONE

    65 Alec Craig Way

    5.1 km

    Contributing (Primary), State, 541 enrolled


  • UNZONED

    100 Jelas Road

    5.9 km

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


  • OUT OF ZONE

    76 Riverside Road

    6.1 km

    Secondary (Year 7-13) (Intermediate & Secondary), State, 2167 enrolled


  • OUT OF ZONE

    Ashley Avenue

    7.6 km

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


  • UNZONED

    293 Wainui Road

    7.9 km

    Full Primary (Primary & Intermediate), Private : Fully Registered, 71 enrolled


  • UNZONED

    794 East Coast Road

    11.1 km

    Composite (Year 1-13) (Primary, Intermediate & Secondary), Private : Fully Registered, 348 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
113 Vipond Road, Stanmore Bay, Whangaparaoa
Sold: 10 Apr 2026
113 Vipond Road, Stanmore Bay, Whangaparaoa
  • 4
  • 3
SOLD: $1,165,000
Sold
92 Stanmore Bay Road, Stanmore Bay, Whangaparaoa
Sold: 26 Mar 2026
92 Stanmore Bay Road, Stanmore Bay, Whangaparaoa
  • 2
  • 2
SOLD: $920,000
Sold
84 Stanmore Bay Road, Stanmore Bay, Whangaparaoa
Sold: 12 Mar 2026
84 Stanmore Bay Road, Stanmore Bay, Whangaparaoa
  • 4
  • 2
SOLD: $1,030,000
Sold
127 Vipond Road, Stanmore Bay, Whangaparaoa
Sold: 12 Mar 2026
127 Vipond Road, Stanmore Bay, Whangaparaoa
  • 3
  • 2
SOLD: $890,000
Sold
38 Scott Road, Stanmore Bay, Whangaparaoa
Sold: 11 Mar 2026
38 Scott Road, Stanmore Bay, Whangaparaoa
  • 2
  • 1
SOLD: $777,000
Sold
245 Vipond Road, Stanmore Bay, Whangaparaoa
Sold: 09 Mar 2026
245 Vipond Road, Stanmore Bay, Whangaparaoa
  • 3
  • 1
SOLD: $830,000
Sold
25 Carento Way, Stanmore Bay, Whangaparaoa
Sold: 04 Mar 2026
25 Carento Way, Stanmore Bay, Whangaparaoa
  • 3
  • 2
SOLD: $910,000
Sold
21 Donald Street, Stanmore Bay, Whangaparaoa
Sold: 28 Feb 2026
21 Donald Street, Stanmore Bay, Whangaparaoa
  • 3
  • 1
SOLD: $850,000
Sold
29 Melandra Road, Stanmore Bay, Whangaparaoa
Sold: 26 Feb 2026
29 Melandra Road, Stanmore Bay, Whangaparaoa
  • 4
  • 2
SOLD: $1,115,000
Sold
95 Vipond Road, Stanmore Bay, Whangaparaoa
Sold: 26 Feb 2026
95 Vipond Road, Stanmore Bay, Whangaparaoa
  • 6+
  • 2
SOLD: $850,000

Properties for sale around  Stanmore Bay

View all

18 Mata Lane, Stanmore Bay, Rodney

  • 3
  • 2
Price by negotiation
YXRTQ1GWMCS5XMHM0XUM

62 Seafarer Crescent, Stanmore Bay, Rodney

  • 3
  • 2
Asking price $985,000
Contemporary & Elegant Lifestyle

Lot 3 - 20 Melia Place, Stanmore Bay, Rodney

  • 3
  • 2
Price by negotiation
9YYSBQ7SZXFB8F01S9QJ

43 Mata Lane, Stanmore Bay, Rodney

  • 3
  • 3
Deadline sale by 3 Dec
Family & Investor Gem: 3 Bedrooms, 3 Ensuites!

74 Vipond Road, Stanmore Bay, Rodney

  • 3
  • 1
Auction on 5 Nov, 2:00 pm
G518Q0SL74GLR2R4Z83T

62 Seafarer Crescent, Stanmore Bay, Rodney

  • 3
  • 2
Asking price $985,000
UEPQ6O2EN1QEZX7GB7WA

Lot 3 - 20 Melia Place, Stanmore Bay, Rodney

  • 3
  • 2
Price by negotiation
Modern Living in Stanmore Bay!

22 East Point, Manly, Rodney

  • 3
  • 2
For sale by tender, 4 Jul
No image

82 Wade River Road, Stanmore Bay, Rodney

  • 3
  • 2
Price by negotiation
No image

52 Ferry Road, Arkles Bay, Rodney

  • 3
  • 1
Asking price $726,000
52 Ferry Road Arkles Bay Silverdale 932

52 Ferry Road, Arkles Bay, Rodney

  • 3
  • 1
Asking price $726,000
52 Ferry Road Arkles Bay Silverdale 932

9//11 Red Hibiscus Rd, Stanmore Bay, Rodney

  • 2
  • 1
Asking price $615,000
Red Hibiscus-Be In Early To Secure "Pre Constr...

20, Great South Road, Stanmore Bay, Rodney

  • 3
  • 2
Asking price $549,000
"Catch Me If You Can"

19/19 Sydney Street, Manly, Rodney

  • 1
  • 1
Asking price $50,000
Michael Release Testing 3/28

1/35A Manila Road, Manly, Rodney

  • 5
  • 2
Asking price $1,234,537
No image

34 Pine Street, Manly, Rodney

  • 3
  • 1
Asking price $16,161,616
No image

20, Great South Road, Stanmore Bay, Rodney

  • 3
  • 1
Asking price $529,000
3 Beds, Private Setting, Large Section

20, Great South Road, Stanmore Bay, Rodney

  • 3
  • 1
Asking price $529,000
3 Beds, Private Setting, Large Section

70 The Circle, Manly, Rodney

  • 4
  • 2
Asking price $899,000
IRRESISTIBLE ONE-LEVEL LIVING

Arkles Bay, Rodney

Asking price $600,000
No image
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
  • Property news & guides
  • Sold Properties
  • 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
  • Seller information
  • Help center community
  • Desktop site
  • Help
  • Contact Us
  • Terms & conditions
  • About Us
  • News
  • Careers
  • Advertise
  • Privacy policy
  • 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
  • Contact Us
Log in
Sign up
© 2026 Trade Me Limited