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

    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. 5 Duncansby Road
5 Duncansby Road, Stanmore Bay, Whangaparaoa - Carousel 1
5 Duncansby Road, Stanmore Bay, Whangaparaoa - Carousel 2
5 Duncansby Road, Stanmore Bay, Whangaparaoa - Carousel 21
5 Duncansby Road, Stanmore Bay, Whangaparaoa - Carousel 1
5 Duncansby Road, Stanmore Bay, Whangaparaoa - Carousel 2
5 Duncansby Road, Stanmore Bay, Whangaparaoa - Carousel 3
5 Duncansby Road, Stanmore Bay, Whangaparaoa - Carousel 4
5 Duncansby Road, Stanmore Bay, Whangaparaoa - Carousel 5
5 Duncansby Road, Stanmore Bay, Whangaparaoa - Carousel 6
5 Duncansby Road, Stanmore Bay, Whangaparaoa - Carousel 7
5 Duncansby Road, Stanmore Bay, Whangaparaoa - Carousel 8
5 Duncansby Road, Stanmore Bay, Whangaparaoa - Carousel 9
5 Duncansby Road, Stanmore Bay, Whangaparaoa - Carousel 10
5 Duncansby Road, Stanmore Bay, Whangaparaoa - Carousel 11
5 Duncansby Road, Stanmore Bay, Whangaparaoa - Carousel 12
5 Duncansby Road, Stanmore Bay, Whangaparaoa - Carousel 13
5 Duncansby Road, Stanmore Bay, Whangaparaoa - Carousel 14
5 Duncansby Road, Stanmore Bay, Whangaparaoa - Carousel 15
5 Duncansby Road, Stanmore Bay, Whangaparaoa - Carousel 16
5 Duncansby Road, Stanmore Bay, Whangaparaoa - Carousel 17
5 Duncansby Road, Stanmore Bay, Whangaparaoa - Carousel 18
5 Duncansby Road, Stanmore Bay, Whangaparaoa - Carousel 19
5 Duncansby Road, Stanmore Bay, Whangaparaoa - Carousel 20
5 Duncansby Road, Stanmore Bay, Whangaparaoa - Carousel 21
Estimate

5 Duncansby Road, Stanmore Bay, Whangaparaoa

HomesEstimate: $1.8M - $2.02M
  • 5 Beds
  • 3 Baths
  • 2 Parks

Property details

Ownership type (Council record)
Freehold
Floor Area (Council record)
290m² more or less
Land area (Council record)
1100m² more or less
Bedrooms (Council record)
5 Bedrooms
Bathrooms (Council record)
3 Bathrooms
Garage parking (Council record)
3 Garage parking
Off-street parking
2 Off-street parking
Has deck
Yes
View type
Water
Decade built
1990s
Wall material
Wood in all forms, including treated plywood and compressed wood products
Roof material
Iron, including steel and corrugated long-run
Building footprint
148m² more or less
Contour
Level
Capital value (CV)
$2,025,000
Land value
$1,125,000
Improvement value
$900,000
Certificate of title
NA968/147
Legal description
LOT 43 DP 37285
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: 20 Aug 2026

$1.8M - $2.02M

What is the HomesEstimate?

RentEstimate

Not yet available

Rental yield

What is rental yield?

These are computer-generated price estimates.
To understand your home’s value, get an appraisal from a local agent.
Estimated value history for 5 Duncansby Road, Stanmore Bay, Whangaparaoa
DateThis homeThis suburb
7 August 2025 $915K
21 August 2025 $925K
4 September 2025 $1.98M (range $1.86M to $2.09M) $920K
18 September 2025 $1.94M (range $1.83M to $2.05M) $920K
2 October 2025 $1.95M (range $1.84M to $2.06M) $920K
16 October 2025 $1.96M (range $1.84M to $2.07M) $920K
30 October 2025 $1.93M (range $1.82M to $2.04M) $920K
13 November 2025 $1.92M (range $1.8M to $2.03M) $925K
27 November 2025 $1.96M (range $1.85M to $2.08M) $920K
11 December 2025 $1.99M (range $1.87M to $2.1M) $915K
25 December 2025 $1.97M (range $1.85M to $2.08M) $925K
8 January 2026 $1.98M (range $1.86M to $2.09M) $920K
22 January 2026 $1.95M (range $1.84M to $2.07M) $920K
5 February 2026 $1.99M (range $1.87M to $2.1M) $920K
19 February 2026 $1.92M (range $1.8M to $2.03M) $920K
5 March 2026 $1.94M (range $1.82M to $2.05M) $910K
19 March 2026 $1.95M (range $1.84M to $2.06M) $915K
2 April 2026 $1.93M (range $1.82M to $2.04M) $910K
16 April 2026 $1.87M (range $1.76M to $1.97M) $915K
30 April 2026 $1.93M (range $1.82M to $2.04M) $910K
14 May 2026 $1.93M (range $1.82M to $2.04M) $910K
28 May 2026 $1.94M (range $1.83M to $2.05M) $900K
11 June 2026 $1.91M (range $1.8M to $2.01M) $910K
25 June 2026 $1.93M (range $1.83M to $2.04M) $910K
9 July 2026 $1.97M (range $1.86M to $2.08M) $905K
23 July 2026 $1.94M (range $1.83M to $2.06M) $900K
6 August 2026 $1.93M (range $1.81M to $2.04M) $905K
20 August 2026 $1.91M (range $1.8M to $2.02M) $905K
Capital value
$2.025M
Capital value updated
01 May 2024
Land value
$1.125M
Improvement value
$900K

Sale history timeline

  1. 01 May 2024
    Capital Value

    $2,025,000

  2. 27 September 2022
    Sold

    $2,300,000

    S11
  3. 01 June 2021
    Capital Value

    $2,100,000

  4. 01 July 2017
    Capital Value

    $1,450,000

  5. 01 July 2014
    Capital Value

    $900,000

  6. 17 September 2010
    Sold

    $N/A

    S13
  7. 13 May 2010
    Sold

    $685,000

    S11
  8. 01 November 2005
    Sold

    $N/A

    S13
  9. 25 June 2002
    Sold

    $515,000

    S11
  10. 06 October 2001
    Sold

    $489,000

    S11
  11. 21 May 1991
    Sold

    $112,000

    S11
  12. 15 September 1981
    Sold

    $25,000

    S11
  13. 01 January 1990
    Decade built

    1990

Local Schools

All (0) Primary (0) Intermediate (0) Secondary (0)

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
40 Brightside Road, Stanmore Bay, Whangaparaoa
Sold: 12 Aug 2026
40 Brightside Road, Stanmore Bay, Whangaparaoa
  • 3
  • 2
SOLD: $1,150,000
Sold
195 Vipond Road, Stanmore Bay, Whangaparaoa
Sold: 22 Jul 2026
195 Vipond Road, Stanmore Bay, Whangaparaoa
  • 2
  • 1
SOLD: $755,000
Sold
16 Dobell Road, Stanmore Bay, Whangaparaoa
Sold: 09 Jul 2026
16 Dobell Road, Stanmore Bay, Whangaparaoa
  • 3
  • 1
SOLD: $902,000
Sold
88 Brian Crescent, Stanmore Bay, Whangaparaoa
Sold: 06 Jul 2026
88 Brian Crescent, Stanmore Bay, Whangaparaoa
  • 4
  • 2
SOLD: $1,130,000
Sold
74 Duncansby Road, Stanmore Bay, Whangaparaoa
Sold: 23 Jun 2026
74 Duncansby Road, Stanmore Bay, Whangaparaoa
  • 3
  • 2
SOLD: $1,600,000
Sold
45 Vipond Road, Stanmore Bay, Whangaparaoa
Sold: 22 Jun 2026
45 Vipond Road, Stanmore Bay, Whangaparaoa
  • 3
  • 3
SOLD: $1,260,000
Sold
20 Brian Crescent, Stanmore Bay, Whangaparaoa
Sold: 22 Jun 2026
20 Brian Crescent, Stanmore Bay, Whangaparaoa
  • 5
  • 2
SOLD: $1,250,000
Sold
23 Langton Road, Stanmore Bay, Whangaparaoa
Sold: 19 Jun 2026
23 Langton Road, Stanmore Bay, Whangaparaoa
  • 2
  • 1
SOLD: $702,000
Sold
36B Charlotte Street, Stanmore Bay, Whangaparaoa
Sold: 18 Jun 2026
36B Charlotte Street, Stanmore Bay, Whangaparaoa
  • 3
  • 1
SOLD: $815,000
Sold
18B Brian Crescent, Stanmore Bay, Whangaparaoa
Sold: 14 Jun 2026
18B Brian Crescent, Stanmore Bay, Whangaparaoa
  • 2
  • 1
SOLD: $610,000

Properties for sale around Stanmore Bay

View all

355 Whangaparaoa Road, Stanmore Bay, Rodney

  • 2
  • 1
Auction on 14 Oct, 2:00 pm
MORTGAGEE SALE

32 Waiora Road, Stanmore Bay, Rodney

  • 1
  • 2
Auction on 12 Aug, 2:00 pm
MORTGAGEE SALE

66 Stanmore Bay Road, Stanmore Bay, Rodney

  • 2
  • 1
Auction on 15 Jul, 2:00 pm
MORTGAGEE SALE

45 Mata Lane, Stanmore Bay, Rodney

  • 3
  • 3
Asking price $779,000
IPTPM2QEEL1Z7MWU6UES

88 Brian Crescent, Stanmore Bay, Rodney

  • 4
  • 2
Auction on 1 Jul, 2:00 pm
9ST07QK90K14RE48W36C

66 Stanmore Bay Road, Stanmore Bay, Rodney

  • 2
  • 1
Auction on 15 Jul, 2:00 pm
SNFWHYH6EUC1RZUJLX0Q

66 Stanmore Bay Road, Stanmore Bay, Rodney

  • 2
  • 1
Auction on 18 Jun, 9:49 am
MORTGAGEE SALE

33 Mata Lane, Stanmore Bay, Rodney

  • 3
  • 2
Asking price $729,000
SRR1JWO28VGAKA8QZHSS

88 Brian Crescent, Stanmore Bay, Rodney

  • 4
  • 2
Auction on 1 Jul, 2:00 pm
MORTGAGEE SALE

1006 Whangaparaoa Road, Tindalls Beach, Rodney

  • 4
  • 2
Auction on 15 Apr, 2:00 pm
MORTGAGEE SALE

18 Mata Lane, Stanmore Bay, Rodney

  • 3
  • 2
Price by negotiation
YXRTQ1GWMCS5XMHM0XUM

18 Mata Lane, Stanmore Bay, Rodney

  • 3
  • 2
Asking price $799,000
J1ALIFJPH2Z3NLE98Z27

18 Mata Lane, Stanmore Bay, Rodney

  • 3
  • 2
Asking price $799,000
EWXCNDAG6RGJZ6UMEHDC

18 Mata Lane, Stanmore Bay, Rodney

  • 3
  • 2
Asking price $799,000
Stop Renting, Start Living

62 Seafarer Crescent, Stanmore Bay, Rodney

  • 3
  • 2
Asking price $985,000
Contemporary & Elegant Lifestyle
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
  • Property news & guides
  • Sold Properties
  • Open Homes
  • 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
  • 3rd Party Licenses
  • Seller information
  • Help center community
  • Desktop site
  • Help
  • Contact Us
  • Terms & conditions
  • About Us
  • News
  • Careers
  • Advertise
  • Privacy policy
  • 3rd Party Licenses
  • 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
  • 3rd Party Licenses
  • Contact Us
Log in
Sign up
© 2026 Trade Me Limited