Home
Property
Sold
Whangaparaoa
Stanmore Bay
47 Duncansby Road, Stanmore Bay, Whangaparaoa

Sold on 01 Nov 2025

47 Duncansby Road, Stanmore Bay, Whangaparaoa

SOLD: $1,170,000

3 Beds
2 Baths
3 Parks

Stay updated on this property!

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

Harcourts Cooper & Co - Whangaparaoa

Tony Scheirlinck AREINZ

Recent sales

Experience

39y 9m

Get access to exclusive benefits with this Platinum Partner

Learn More

HomesEstimate

Updated today

Updated: 08 Jan 2026

$1.09M - $1.23M

What is the HomesEstimate?

RentEstimate

Updated: 02 Dec 2025

$600 - $710 /week

Rental yield

2.9%

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 November 2025

Sold

$1,170,000

01 May 2024

Capital Value

$1,050,000

01 June 2021

Capital Value

$1,100,000

01 July 2017

Capital Value

$860,000

18 January 2016

Sold

$792,500

01 July 2014

Capital Value

$610,000

14 October 2009

Sold

$490,000

21 September 2005

Sold

$448,000

28 June 1997

Sold

$264,000

23 May 1995

Sold

$165,000

15 September 1993

Sold

$138,000

08 January 1990

Sold

$155,000

31 March 1988

Sold

$134,000

07 August 1984

Sold

$88,000

01 January 1950

Decade built

1950

Local Schools

IN ZONE stanmore bay school
32 Waiora Road
1.4 km
Contributing (Primary), State, 519 enrolled
IN ZONE red beach school
20 Albert Hall Drive
1.6 km
Contributing (Primary), State, 460 enrolled
IN ZONE whangaparaoa college
8 Stanmore Bay Road
3.2 km
Secondary (Year 7-13) (Intermediate & Secondary), State, 1849 enrolled

UNZONED little wonders at home limited
31 D'Oyly Drive
1.2 km
Homebased Network (Early Childhood), Privately owned
UNZONED stanmore bay kindergarten
Waiora Road
1.6 km
Free Kindergarten (Early Childhood), Community based, 53 enrolled
UNZONED red beach playcentre
3 Bay Vista Drive
1.8 km
Playcentre (Early Childhood), Community based, 50 enrolled
UNZONED kingsway school
100 Jelas Road
3.3 km
Composite (Year 1-13) (Primary, Intermediate & Secondary), State : Integrated, 2019 enrolled
UNZONED whangaparaoa playcentre
41 A Stanmore Bay Road
3.4 km
Playcentre (Early Childhood), Community based, 38 enrolled
OUT OF ZONE orewa college
76 Riverside Road
3.5 km
Secondary (Year 7-13) (Intermediate & Secondary), State, 2167 enrolled
UNZONED orewa beach kindergarten
Riverside Road
3.6 km
Free Kindergarten (Early Childhood), Community based, 51 enrolled
OUT OF ZONE silverdale school
4 Longmore Lane
3.6 km
Contributing (Primary), State, 668 enrolled
UNZONED stella maris primary school
50 Silverdale Street
3.8 km
Contributing (Primary), State : Integrated, 336 enrolled
OUT OF ZONE whangaparaoa school (auckland)
39 Ladies Mile
4.1 km
Contributing (Primary), State, 818 enrolled
OUT OF ZONE orewa beach school
280 Centreway Road
4.6 km
Contributing (Primary), State, 399 enrolled
UNZONED meraki montessori school
293 Wainui Road
5.4 km
Full Primary (Primary & Intermediate), Private : Fully Registered, 71 enrolled
UNZONED wentworth college
65 Gulf Harbour Drive
6.4 km
Secondary (Year 7-13) (Intermediate & Secondary), Private : Fully Registered, 443 enrolled
UNZONED wentworth primary
95 Gulf Harbour Drive
6.7 km
Full Primary (Primary & Intermediate), Private : Fully Registered, 159 enrolled
OUT OF ZONE long bay college
Ashley Avenue
8.9 km
Secondary (Year 9-13) (Secondary), State, 1887 enrolled
UNZONED city impact church school
794 East Coast Road
12.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.