Skip to site navigation Skip to main content
main content
  1. Home
  2. Property
  3. Sold
  4. Whangaparaoa
  5. Stanmore Bay
  6. 40a Duncansby Road, Stanmore Bay, Whangaparaoa
40A Duncansby Road, Stanmore Bay, Whangaparaoa - Carousel 1
40A Duncansby Road, Stanmore Bay, Whangaparaoa - Carousel 2
40A Duncansby Road, Stanmore Bay, Whangaparaoa - Carousel 41
40A Duncansby Road, Stanmore Bay, Whangaparaoa - Carousel 1
40A Duncansby Road, Stanmore Bay, Whangaparaoa - Carousel 2
40A Duncansby Road, Stanmore Bay, Whangaparaoa - Carousel 3
40A Duncansby Road, Stanmore Bay, Whangaparaoa - Carousel 4
40A Duncansby Road, Stanmore Bay, Whangaparaoa - Carousel 5
40A Duncansby Road, Stanmore Bay, Whangaparaoa - Carousel 6
40A Duncansby Road, Stanmore Bay, Whangaparaoa - Carousel 7
40A Duncansby Road, Stanmore Bay, Whangaparaoa - Carousel 8
40A Duncansby Road, Stanmore Bay, Whangaparaoa - Carousel 9
40A Duncansby Road, Stanmore Bay, Whangaparaoa - Carousel 10
40A Duncansby Road, Stanmore Bay, Whangaparaoa - Carousel 11
40A Duncansby Road, Stanmore Bay, Whangaparaoa - Carousel 12
40A Duncansby Road, Stanmore Bay, Whangaparaoa - Carousel 13
40A Duncansby Road, Stanmore Bay, Whangaparaoa - Carousel 14
40A Duncansby Road, Stanmore Bay, Whangaparaoa - Carousel 15
40A Duncansby Road, Stanmore Bay, Whangaparaoa - Carousel 16
40A Duncansby Road, Stanmore Bay, Whangaparaoa - Carousel 17
40A Duncansby Road, Stanmore Bay, Whangaparaoa - Carousel 18
40A Duncansby Road, Stanmore Bay, Whangaparaoa - Carousel 19
40A Duncansby Road, Stanmore Bay, Whangaparaoa - Carousel 20
40A Duncansby Road, Stanmore Bay, Whangaparaoa - Carousel 21
40A Duncansby Road, Stanmore Bay, Whangaparaoa - Carousel 22
40A Duncansby Road, Stanmore Bay, Whangaparaoa - Carousel 23
40A Duncansby Road, Stanmore Bay, Whangaparaoa - Carousel 24
40A Duncansby Road, Stanmore Bay, Whangaparaoa - Carousel 25
40A Duncansby Road, Stanmore Bay, Whangaparaoa - Carousel 26
40A Duncansby Road, Stanmore Bay, Whangaparaoa - Carousel 27
40A Duncansby Road, Stanmore Bay, Whangaparaoa - Carousel 28
40A Duncansby Road, Stanmore Bay, Whangaparaoa - Carousel 29
40A Duncansby Road, Stanmore Bay, Whangaparaoa - Carousel 30
40A Duncansby Road, Stanmore Bay, Whangaparaoa - Carousel 31
40A Duncansby Road, Stanmore Bay, Whangaparaoa - Carousel 32
40A Duncansby Road, Stanmore Bay, Whangaparaoa - Carousel 33
40A Duncansby Road, Stanmore Bay, Whangaparaoa - Carousel 34
40A Duncansby Road, Stanmore Bay, Whangaparaoa - Carousel 35
40A Duncansby Road, Stanmore Bay, Whangaparaoa - Carousel 36
40A Duncansby Road, Stanmore Bay, Whangaparaoa - Carousel 37
40A Duncansby Road, Stanmore Bay, Whangaparaoa - Carousel 38
40A Duncansby Road, Stanmore Bay, Whangaparaoa - Carousel 39
40A Duncansby Road, Stanmore Bay, Whangaparaoa - Carousel 40
40A Duncansby Road, Stanmore Bay, Whangaparaoa - Carousel 41
Sold on 21 Oct 2025

40A Duncansby Road, Stanmore Bay, Whangaparaoa

SOLD: $1,010,000
  • 3 Beds
  • 2 Baths
  • 5 Parks

Property details

Cross Lease
140m² more or less
3 Bedrooms
2 Bathrooms
2 Garage parking
2 Off-street 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.

Ben Gibson
Harcourts Cooper & Co - Orewa

Ben Gibson

202 Reviews
Recent sales
48
Experience
3y 1m
Skills
Communication Skills Customer Relations Negotiation Problem Solving Sales & Marketing
Latest Review See all
13 days ago viaRateMyAgentSeller Review
Very approachable, highly efficient and extremely professional - Jun Qu
37A Doment Crescent, Orewa
3 1 1
Get access to exclusive benefits with this Platinum Partner
Learn More
Property estimateCapital valueTrends

HomesEstimate

Updated today

Updated: 02 Apr 2026

$950K - $1.06M

What is the HomesEstimate?

RentEstimate

Updated: 02 Apr 2026

$620 - $740 /week

Rental yield

3.5%

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

21 October 2025
Sold

$1,010,000

S11
Ben Gibson Ben Gibson
01 May 2024
Capital Value

$1,075,000

01 June 2021
Capital Value

$1,125,000

01 July 2017
Capital Value

$870,000

01 July 2014
Capital Value

$620,000

08 February 1992
Sold

$190,000

S11
01 January 1970
Decade built

1970

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
49 Duncansby Road, Stanmore Bay, Whangaparaoa
Sold: 06 Mar 2026
49 Duncansby Road, Stanmore Bay, Whangaparaoa
  • 3
  • 1
SOLD: $1,349,000
Sold
21 Donald Street, Stanmore Bay, Whangaparaoa
Sold: 28 Feb 2026
21 Donald Street, Stanmore Bay, Whangaparaoa
  • 3
  • 1
SOLD: $850,000
Sold
95 Vipond Road, Stanmore Bay, Whangaparaoa
Sold: 26 Feb 2026
95 Vipond Road, Stanmore Bay, Whangaparaoa
  • 6+
  • 2
SOLD: $850,000
Sold
No image
Sold: 23 Feb 2026
5 Hiwi Crescent, Stanmore Bay, Whangaparaoa
  • 3
  • 1
SOLD: $1,100,000
Sold
No image
Sold: 16 Feb 2026
16 Jean Place, Stanmore Bay, Whangaparaoa
  • 2
  • 1
SOLD: $580,000
Sold
20A Holiday Road, Stanmore Bay, Whangaparaoa
Sold: 09 Feb 2026
20A Holiday Road, Stanmore Bay, Whangaparaoa
  • 4
  • 1
SOLD: $867,500
Sold
22B Holiday Road, Stanmore Bay, Whangaparaoa
Sold: 07 Feb 2026
22B Holiday Road, Stanmore Bay, Whangaparaoa
  • 3
  • 1
SOLD: $710,000
Sold
23 John Road, Stanmore Bay, Whangaparaoa
Sold: 05 Feb 2026
23 John Road, Stanmore Bay, Whangaparaoa
  • 4
  • 1
SOLD: $800,000
Sold
267 Vipond Road, Stanmore Bay, Whangaparaoa
Sold: 04 Feb 2026
267 Vipond Road, Stanmore Bay, Whangaparaoa
  • 4
  • 2
SOLD: $1,155,000
Sold
23 Anehana Place, Stanmore Bay, Whangaparāoa
Sold: 31 Jan 2026
23 Anehana Place, Stanmore Bay, Whangaparāoa
  • 4
  • 3
SOLD: $1,550,000

Properties for sale around  Stanmore Bay

View all

32 Swann Beach Road, Stanmore Bay, Rodney

  • 4
  • 3
Asking price $1,850,000
Renovated Coastal Living with Sea Views

5 Waititiro Rise, Stanmore Bay, Rodney

  • 6+
  • 4
Auction on 14 Apr, 6:00 pm
Live Large, Earn Smart , Legal Home & Income

890 Whangaparaoa Road, Manly, Rodney

  • 5
  • 2
Price by negotiation
The Beachside Opportunity.

2B Palmgreen Court, Stanmore Bay, Rodney

  • 5
  • 3
Asking price $1,249,000
SPACE, STYLE & COMFORT - STUNNING FAMILY HOME!

45 Cochrane Avenue, Arkles Bay, Rodney

  • 4
  • 2
Price by negotiation
Views That Stop You Mid-Sentence

7 South Avenue, Manly, Rodney

  • 4
  • 3
Deadline sale by 15 Apr
Exceptional Coast Retreat - This is EXTRA Special

40 Manly Park Avenue, Manly, Rodney

  • 2
  • 1
Auction on 9 Apr, 10:00 am
Single level living, short stroll to the beach!

52B D'oyly Drive, Stanmore Bay, Rodney

  • 3
  • 1
Asking price $970,000
Stress-Free, Freehold, Family Living

7B Melia Place, Stanmore Bay, Rodney

  • 4
  • 2
Asking price $969,000
Concrete Block Beauty, Ready for You!

31a Ardern Avenue, Stanmore Bay, Rodney

  • 3
  • 2
Deadline sale by 15 Apr
Prime Location, Character & Seaviews

5/20 Melia Place, Stanmore Bay, Rodney

  • 3
  • 2
Price by negotiation
Brand New Freehold Living in Stanmore Bay

21a Zealandia Road, Manly, Rodney

  • 3
  • 2
Price by negotiation
Private Freehold - Owners Upsizing, New Buyers Win

19 Rishworth Avenue, Stanmore Bay, Rodney

  • 3
  • 2
Asking price $920,000
All Day Sun, Sea Views - Priced to Sell!

8/142 Stanmore Bay Road, Stanmore Bay, Rodney

  • 2
  • 1
Deadline sale by 2 Apr
Kiwi Beach Bach - Rare and Exclusive

37B Polkinghorne Drive, Manly, Rodney

  • 3
  • 1
Asking price $885,000
Manly Magic!

12 Mata Lane, Stanmore Bay, Rodney

  • 3
  • 1
Asking price $779,000
Smart, Easy-Care Living in Stanmore Bay

48A Brixton Road, Manly, Rodney

  • 5
  • 2
Price by negotiation
3 bdr home + 2 bdr separate accommodation

236 Vipond Road, Stanmore Bay, Rodney

  • 6+
  • 4
Asking price $3,845,000
MOTIVATED VENDORS - LUXURY HOME WITH SEAVIEWS!

26 Monyash Road, Manly, Rodney

  • 5
  • 2
Asking price $1,795,000
Views for Days from This Hilltop Showstopper

1/43 David Sidwell Place, Stanmore Bay, Rodney

  • 1
  • 1
Deadline sale by 21 Apr
YOUR HOME AND BUSINESS, ALL IN ONE.

50A D'Oyly Drive, Stanmore Bay, Rodney

  • 3
  • 2
Auction on 9 Apr, 4:00 pm
Final week - View now or miss out!

10 Ardern Avenue, Stanmore Bay, Rodney

  • 6+
  • 2
Price by negotiation
Spacious family home, beach access, granny flat

33 Woodridge Drive, Stanmore Bay, Rodney

  • 4
  • 3
Asking price $1,339,000
Single-level Modern Family Living in Stanmore Bay

43 Polkinghorne Drive, Manly, Rodney

  • 4
  • 3
Asking price $1,299,000
Sun, Space and Lifestyle

827 Whangaparaoa Road, Manly, Rodney

  • 3
  • 2
Price by negotiation
SPECTACULAR CLIFFTOP SANCTUARY

2D Vipond Road, Stanmore Bay, Rodney

  • 3
  • 3
Enquiries over $1,445,000
Coastal Outlook, Modern Build, Serious Space

35 Surf Road, Stanmore Bay, Rodney

  • 4
  • 3
Asking price $1,299,000
Solid Family Home + Granny Flat

47 Brixton Road, Manly, Rodney

  • 4
  • 3
Asking price $1,389,000
Sellers Don't Need Two Homes: It's Got To Go!

7 Walbrook Road, Manly, Rodney

  • 3
  • 1
Auction on 23 Apr, 12:00 pm
Sun, Space & Serious Motivation

13/17 Link Crescent, Stanmore Bay, Rodney

  • 1
  • 1
Asking price $569,000
Sleeps 4 - Hot deal alert!

23 Vipond Road, Stanmore Bay, Rodney

  • 3
  • 1
Price by negotiation
Sunshine Inside & Out

60a Ladies Mile, Manly, Rodney

  • 3
  • 2
Auction on 15 Apr, 9:30 am
Your Slice of Manly Paradise

773 Whangaparaoa Road, Manly, Rodney

  • 3
  • 2
Auction on 15 Apr, 9:30 am
Views. Privacy. Pool. This One Has It All!

7 Rivervale Grove, Stanmore Bay, Rodney

  • 5
  • 3
Price by negotiation
Prime Coastal Living - Room for the Whole Family

15A Rimu Road, Stanmore Bay, Rodney

  • 3
  • 1
Asking price $775,000
Sun, Sea & The Stanmore Dream

313/17 Link Crescent, Stanmore Bay, Rodney

  • 2
  • 1
Asking price $599,000
Safe, Secure & Superior!!

14A Layton Road, Manly, Rodney

  • 3
  • 1
Price by negotiation
Elevated Living in Manly

77 Brightside Road, Stanmore Bay, Rodney

  • 3
  • 2
Deadline sale by 13 Apr
Coastal Elegance in Prime Location

28 Swann Beach Road, Stanmore Bay, Rodney

  • 4
  • 3
Price by negotiation
25 Years Loved, Now Selling!

21B & 21C Brixton Road, Manly, Rodney

  • 6+
  • 3
Asking price $1,679,000
Home & Income, Lifestyle, Financial Returns!

24B Tindalls Bay Road, Manly, Rodney

  • 2
  • 1
Price by negotiation
Value packed beachside buying

23a Monyash Road, Manly, Rodney

  • 4
  • 3
Price by negotiation
Walk to the Beach, take in the View and Brand-new!

82A Vipond Road, Stanmore Bay, Rodney

  • 4
  • 3
Asking price $2,194,000
Panoramic Perfection in Every Direction+Pool

3A Glamis Avenue, Manly, Rodney

  • 4
  • 2
Asking price $1,985,000
Affordable beachside living - smart buy in Manly!

3 Glengarry Avenue, Manly, Rodney

  • 4
  • 3
Price by negotiation
Park-Like Grounds. Pure Opportunity.

27a Rakino Avenue, Manly, Rodney

  • 3
  • 1
Price by negotiation
Deceased Estate - Packed with Potential

11 Shuttleworth Place, Manly, Rodney

  • 4
  • 3
Auction on 9 Apr, 10:00 am
Views to love, location to keep

20 Totara Road, Stanmore Bay, Rodney

  • 4
  • 2
Asking price $1,465,000
The One With the Pool and Sea Views

55 Hawaiian Parade, Arkles Bay, Rodney

  • 5
  • 4
Price by negotiation
Cliff-Top Luxury with Panoramic Sea Views

17 Swann Beach Road, Stanmore Bay, Rodney

  • 5
  • 3
Price by negotiation
A Premium Clifftop Residence!
We are upgrading some of our systems
Learn more