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

23 Ardern Avenue, Stanmore Bay, Whangaparaoa

HomesEstimate: $1.08M - $1.21M
  • 3 Beds
  • 2 Baths
  • 2 Parks

Property details

Freehold
160m² more or less
814m² more or less
3 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: 22 Jan 2026

$1.08M - $1.21M

What is the HomesEstimate?

RentEstimate

Updated: 02 Jan 2026

$610 - $770 /week

Rental yield

3.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

$1,175,000

01 June 2021
Capital Value

$1,250,000

01 July 2017
Capital Value

$980,000

01 July 2014
Capital Value

$700,000

20 May 1995
Sold

$255,000

S11
20 August 1993
Sold

$195,000

S11
24 August 1990
Sold

$190,000

S11
09 July 1989
Sold

$210,000

S11
15 August 1988
Sold

$192,000

S11
23 July 1985
Sold

$135,000

S11
01 January 1980
Decade built

1980

Local Schools

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/28 Holiday Road, Stanmore Bay, Whangaparaoa
Sold: 15 Dec 2025
2/28 Holiday Road, Stanmore Bay, Whangaparaoa
  • 3
  • 2
SOLD: $855,000
Sold
30 Langton Road, Stanmore Bay, Whangaparaoa
Sold: 13 Dec 2025
30 Langton Road, Stanmore Bay, Whangaparaoa
  • 5
  • 3
SOLD: $1,375,000
Sold
79 Elan Place, Stanmore Bay, Whangaparaoa
Sold: 11 Dec 2025
79 Elan Place, Stanmore Bay, Whangaparaoa
  • 3
  • 1
SOLD: $949,000
Sold
2/65 Charlotte Street, Stanmore Bay, Whangaparaoa
Sold: 04 Dec 2025
2/65 Charlotte Street, Stanmore Bay, Whangaparaoa
  • 3
  • 1
SOLD: $839,000
Sold
211/17 Link Crescent, Stanmore Bay, Whangaparaoa
Sold: 02 Dec 2025
211/17 Link Crescent, Stanmore Bay, Whangaparaoa
  • 2
  • 1
SOLD: $610,000
Sold
No image
Sold: 02 Dec 2025
16 Whenuateitei Crescent, Stanmore Bay, Whangaparāoa
  • -
  • 0
SOLD: $514,500
Sold
12B Penton Road, Stanmore Bay, Whangaparaoa
Sold: 27 Nov 2025
12B Penton Road, Stanmore Bay, Whangaparaoa
  • 3
  • 1
SOLD: $760,000
Sold
505 Whangaparaoa Road, Stanmore Bay, Whangaparaoa
Sold: 25 Nov 2025
505 Whangaparaoa Road, Stanmore Bay, Whangaparaoa
  • 4
  • 1
SOLD: $950,000
Sold
43 Waiora Road, Stanmore Bay, Whangaparaoa
Sold: 20 Nov 2025
43 Waiora Road, Stanmore Bay, Whangaparaoa
  • 3
  • 2
SOLD: $992,500
Sold
24 Jean Place, Stanmore Bay, Whangaparaoa
Sold: 20 Nov 2025
24 Jean Place, Stanmore Bay, Whangaparaoa
  • 4
  • 1
SOLD: $1,050,000
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
© 2026 Trade Me Limited
  • Desktop site
  • About Us
  • Careers
  • Advertise
  • Privacy policy
  • Terms & conditions
  • Contact Us
Log in
Sign up
© 2026 Trade Me Limited