101 properties · Stanmore Bay, Whangaparāoa

Duncansby Road, Stanmore Bay

Duncansby Road in Stanmore Bay has 101 properties, valued by the council between $770,000 and $3,925,000 with a median of $1,500,000 (Stanmore Bay: $920,000). More of its homes were built in the 1950s than in any other decade. We estimate its homes at a median $1,420,000. 5 sold in the last twelve months, for a median $1,349,000. The highest sale in 2026 was 74 Duncansby Road, at $1,600,000.

$1.5mmedian council valuation
$1.42mour median estimate
$1.35mmedian sale, last 12 months · 5 sales
1980median year built
WhangaparāoaStanmore Bay ×Duncansby Road ×

104 properties on Duncansby Road, Stanmore Bay

Highest and lowest on Duncansby Road

Highest-valued home15 Duncansby Road$3,925,000council valuation · 4 bed · 621 m² floor · 2,025 m² land
Lowest-valued home14B Duncansby Road$770,000council valuation · 2 bed · 56 m² floor · 500 m² land
Highest sale in 202674 Duncansby Road$1,600,000sold 23 Jun 2026 · 3 bed · 213 m² floor · 1,376 m² land

Property values on Duncansby Road

The council values Duncansby Road's 98 rated properties between $770,000 and $3,925,000. The middle half sit between about $1,287,500 and $1,748,750; the median is $1,500,000 and the mean $1,576,582.

Lowest: $770k$770kLowest10%: $1.05m20%: $1.23m20%30%: $1.35m40%: $1.42m40%Median: $1.5m60%: $1.57m60%70%: $1.7m80%: $1.8m80%90%: $2.17mHighest: $3.92m$3.92mHighest
BedroomsHomesMedian council valueSold, last 12 monthsMedian sale
25$1.38m0—
330$1.34m4$1.26m
444$1.5m1—
5+18$1.69m0—

Council rating valuations: the council's figure for apportioning rates, not a market appraisal.

Duncansby Road compared with Stanmore Bay

Duncansby Road's median council value is 63% above Stanmore Bay's.

Duncansby RoadStanmore BayWhangaparāoa
Median council value$1.5m$920k$1.02m
Median sale, last 12 months$1.35m$905k$975k
Sold in the last 12 months5%4.7%4.7%
Time between sales9.5 yrs8.4 yrs8.5 yrs
Median section814 m²809 m²809 m²
Median year built198019901990
Council value per m² of floor$8k$6k$6k

Duncansby Road house prices over time

Median sale price by year; 2026 is the year so far. A year with fewer than two sales has no bar.

2016: $1.17m (5 sales)$1.17m20162017: $1.08m (4 sales)2018: $1.32m (4 sales)20182019: $1.09m (4 sales)2020: $1.19m (7 sales)20202021: $1.48m (6 sales)2022: $1.78m (7 sales)$1.78m20222023: $1.67m (2 sales)2024: $1.05m (5 sales)20242025: $1.25m (9 sales)2026: $1.47m (2 sales, this year so far)$1.47m2026
Sales by year as a table
YearSalesMedian pricePer m² floor
20262$1,474,500$10,709
20259$1,245,000$8,209
20245$1,055,000$6,314
20232$1,665,000$8,234
20227$1,780,000$8,306
20216$1,475,000$7,738
20207$1,190,000$6,389
20194$1,091,250$6,847
20184$1,317,500$5,697
20174$1,082,000$7,134
20165$1,170,000$5,513

Recent sales on Duncansby Road

The homes on Duncansby Road

Duncansby Road has 91 houses and 10 units and townhouses. More were built in the 1950s than in any other decade (21%).

1950s: 21 (21 homes)211950s1960s: 8 (8 homes)1960s1970s: 12 (12 homes)1970s1980s: 17 (17 homes)1980s1990s: 19 (19 homes)1990s2000s: 10 (10 homes)2000s2010s: 9 (9 homes)2010s2020s: 2 (2 homes)22020s

How long owners stay on Duncansby Road

Homes on Duncansby Road that resold in the last five years had been held a median 9.5 years (Stanmore Bay: 8.4 years).

Time between a home's sales, for 25 resales in the last five years. A home not sold since our records begin is not counted, so owners who stay longest are under-represented.

Building and resource consents on Duncansby Road

16building consents in the last 5 years
6resource consents in the last 5 years
  • 60 Duncansby Road1 Aug 2026 · Building consentBathrm & ensuite alterations only. No changes to any structural items such as walls & roofs. No changes to any windows & external, internal doors
  • 34A Duncansby Road1 Aug 2026 · Building consentInstall woodfire - replacement in same location (metro wee rad leg)
  • 51 Duncansby Road1 Apr 2026 · Building consentRbw - removal of existing timber deck. Construction of a new detached timber deck.
  • 8 Duncansby Road1 Mar 2026 · Building consentInstallation of a solid wood fire; new masport Cashmere replace old fire.
  • 48B Duncansby Road1 Jan 2026 · Building consentRbw - proposed amendment to deck foundation for building under consent.
  • 76 Duncansby Road13 Sept 2024 · Resource consentThe proposal involves alteration and addition to the existing dwelling which currently contains a family room including bedroom, bar kitchen, bathroom, garage and foyer within the ground floor, and a
  • 48B Duncansby Road21 Mar 2024 · Resource consentAdditions and alterations to the existing dwelling.
  • 19A Duncansby Road12 Oct 2023 · Resource consentTo vary condition 1 of resource consent LUC60404447 as a result of changing the site levels on the plans.
  • 68B Duncansby Road12 Sept 2023 · Resource consentTo install a 1.8m high by 0.250m wide chimney flue on the lower level of the existing dwelling
  • 19A Duncansby Road16 Aug 2022 · Resource consentTo construct a new, two storey detached dwelling on the subject site that requires consent for an infringement to height in relation to boundary and for exceeding the maximum permitted earthworks of 2

Sales and valuations as at 11 September 2026, from council and LINZ records. Medians resting on fewer than 3 sales are not shown.