Columbia Avenue - NG17 2HA
Key Postcode Insights
NG17 2HA is a residential postcode situated on Columbia Avenue, Sutton-In-Ashfield, NG17 with 45 addresses.
It ranks as the 1395th largest and 1140th most expensive of the 1,548 postcodes in the NG17 area. The most common property type is a early-century house built between 1912 and 1935.
The postcode contains a total of 45 properties: 45 houses.
- Ave. Sale Price
- £221,480
- 10 Year change
- up 52.4%
- Ave. Rental Price
- £1,056pcm
- 10 Year change
- up 61.5%
- Ave. £ per ft²
- £216/ft²
- Ave. Gross Yield
- 5.7%/year/yr
Key Postcode Insights
NG17 2HA is a residential postcode situated on Columbia Avenue, Sutton-In-Ashfield, NG17 with 45 addresses.
It ranks as the 1395th largest and 1140th most expensive of the 1,548 postcodes in the NG17 area. The most common property type is a early-century house built between 1912 and 1935.
The postcode contains a total of 45 properties: 45 houses.
- Ave. Sale Price
- £221,480
- 10 Year change
- up 52.4%
- Ave. Rental Price
- £1,056pcm
- 10 Year change
- up 61.5%
- Ave. £ per ft²
- £216/ft²
- Ave. Gross Yield
- 5.7%/year/yr
Explore Propertiesin NG17 2HA
- 2 Columbia Avenue
3 Bed Mid-century House
- 4 Columbia Avenue
Unknown
- 6 Columbia Avenue
Unknown
- 8 Columbia Avenue
Unknown
- 10 Columbia Avenue
3 Bed Early-century House
Sales Market Trends
The last sale in NG17 2HA sold for £227,500 on 9th December 2025. Since then prices are down an average of 0.7%.
The current average value in the postcode is £221,480.
The NG17 2HA Sales Market has increased by 52.4% over the last 10 years.
| Period | Year on Year | Average Price |
|---|---|---|
| June 2026 | -3.1% | £221,480 |
| June 2025 | 1.7% | £228,555 |
| June 2024 | 2.2% | £224,840 |
| June 2023 | 2.4% | £219,916 |
| June 2022 | 12.6% | £214,722 |
| June 2021 | 8.4% | £190,748 |
| June 2020 | 4.2% | £175,949 |
| June 2019 | 5.2% | £168,856 |
| June 2018 | 4.3% | £160,470 |
| June 2017 | 5.9% | £153,846 |
| June 2016 | 3.4% | £145,295 |
| June 2015 | 2% | £140,578 |
| June 2014 | 7.8% | £137,849 |
| June 2013 | 0.3% | £127,885 |
| June 2012 | -1.5% | £127,462 |
| June 2011 | -0.4% | £129,346 |
| June 2010 | 2.8% | £129,916 |
| June 2009 | -9.4% | £126,435 |
| June 2008 | -3.1% | £139,571 |
| June 2007 | 0% | £143,986 |
Rental Market Trends
The current average rental value in the postcode is £1,056.
The NG17 2HA Rental Market has increased by 61.5% over the last 10 years.
| Period | Year on Year | Average Price |
|---|---|---|
| June 2026 | 2.6% | £1,056pcm |
| June 2025 | 4.3% | £1,029pcm |
| June 2024 | 6.8% | £987pcm |
| June 2023 | 7.7% | £923pcm |
| June 2022 | 10.3% | £857pcm |
| June 2021 | 9.3% | £777pcm |
| June 2020 | 2.1% | £712pcm |
| June 2019 | 2.9% | £697pcm |
| June 2018 | 2.1% | £677pcm |
| June 2017 | 1.4% | £663pcm |
| June 2016 | 2.4% | £654pcm |
| June 2015 | 3.4% | £638pcm |
| June 2014 | 0.6% | £618pcm |
| June 2013 | 1.2% | £614pcm |
| June 2012 | 0.7% | £607pcm |
| June 2011 | 3.8% | £602pcm |
| June 2010 | 3.4% | £580pcm |
| June 2009 | -7.2% | £561pcm |
| June 2008 | 0.3% | £604pcm |
| June 2007 | 0% | £603pcm |
Sales History
The last sale was on 9th December 2025 for £227,500 and since then the market in the area has decreased by 0.7%. The postcode has had a total of 42 sales since 1995.
NG17 2HA has seen 7 sales in the last three years and 2 sales in the last twelve months.
- Sold Dec 2025£227,500 | 3 Bed House60, Columbia Avenue, Sutton-In-Ashfield, NG17 2HA60, Columbia Avenue, Sutton-In-Ashfield, NG17 2HA
- Sold Oct 2025£205,000 | 3 Bed House36, Columbia Avenue, Sutton-In-Ashfield, NG17 2HA36, Columbia Avenue, Sutton-In-Ashfield, NG17 2HA
- Sold Feb 2025£210,000 | 3 Bed House86, Columbia Avenue, Sutton-In-Ashfield, NG17 2HA86, Columbia Avenue, Sutton-In-Ashfield, NG17 2HA
- Sold Sep 2024£210,000 | 3 Bed House2, Columbia Avenue, Sutton-In-Ashfield, NG17 2HA2, Columbia Avenue, Sutton-In-Ashfield, NG17 2HA
- Sold Aug 2024£230,000 | 3 Bed House10, Columbia Avenue, Sutton-In-Ashfield, NG17 2HA10, Columbia Avenue, Sutton-In-Ashfield, NG17 2HA
Nearby Postcodes
NG17 2HA is the 1395th largest and the 1140th most expensive postcode out of the 1,548 postcodes in the NG17 area.
- NG17 2GZ, Columbia Avenue, Sutton-In-Ashfield, NG17NG17 2GZ46 Addresses|40 m away
- NG17 2HB, Huthwaite Road, Sutton-In-Ashfield, NG17NG17 2HB52 Addresses|102 m away
- NG17 2GX, Huthwaite Road, Sutton-In-Ashfield, NG17NG17 2GX45 Addresses|158 m away
- NG17 2HQ, Foxhill Close, Sutton-In-Ashfield, NG17NG17 2HQ31 Addresses|188 m away
- NG17 2HP, Crampton Close, Sutton-In-Ashfield, NG17NG17 2HP8 Addresses|217 m away
Property Types
- 10 mid-century houses built between 1936 and 1979
- 15 early-century houses built between 1912 and 1935
- 20 other addresses of unknown type
- mid-century house (10)
- early-century house (15)
- Unknown (20)
Energy Efficiency
- Energy Performance Certificate (EPC) surveys conducted for 25 properties.
- The most common rating is D.
- A (0)
- E (3)
- B (0)
- F (1)
- C (8)
- G (0)
- D (13)
- No EPC (20)
Top 3 Most Expensive Sales
- Sold Apr 2020£250,000 | 3 Bed House83, Columbia Avenue, Sutton-In-Ashfield, NG17 2GZ83, Columbia Avenue, Sutton-In-Ashfield, NG17 2GZ
- Sold Mar 2021£250,000 | 4 Bed House85, Columbia Avenue, Sutton-In-Ashfield, NG17 2GZ85, Columbia Avenue, Sutton-In-Ashfield, NG17 2GZ
- Sold Jan 2024£250,000 | 4 Bed House34, Columbia Avenue, Sutton-In-Ashfield, NG17 2HA34, Columbia Avenue, Sutton-In-Ashfield, NG17 2HA
Schools Nearby
- St Mary Magdalene CofE Primary School300 m away
- Mapplewells Primary and Nursery School700 m away
- Brierley Forest Primary and Nursery School900 m away
- Sutton Community Academy1.6 km away
- Quarrydale Academy1.6 km away
- Ashfield Comprehensive School1.9 km away
More reading links
Public Transport Nearby
The closest station to NG17 2HA is Sutton Parkway station, which is 2.8 kilometres away.
- Sutton Parkway|2.8 km away
- Kirkby-in-Ashfield|3.5 km away
- Mansfield|6.1 km away
- Alfreton|6.4 km away
