NG17 2HA

a postcode in Nottinghamshire

Introduced in January 1980

NG17 2HA	Normal (geographic) postcodes	Large user postcodes

The nearby postcodes map only shows currently active postcodes. Postcode markers will cluster if they are close together, which may happen in densly populated built-up areas or where single premises have multiple postcodes.

Streets Associated with NG17 2HA

Columbia Avenue - 45 properties, USRN 1215846

Street names are those nearest to properties in this postcode, they are not necessarily the postal address

Coordinates

Latitude: 53.1254 / 53°7'31"N

Longitude: -1.284 / 1°17'2"W

UTM Reference: 30U 614824 5887598

OS Easting: 448011

OS Northing: 358932

OS Grid: SK480589

Location Encoding

Mapcode Local: GBR 7D4.06X

Mapcode Global: WHDFY.7PTV

Open Location Code: 9C5W4PG8+5C

Maidenhead Locator System: IO93id50

Demographics

Urban/Rural Indicator: C1

urban city or town
a town or city, surrounded by populated countryside

ONS Population Classification: 1b2

Retired Professionals
Small Town Suburbia
Older Established Suburban Communities

Index of Multiple Deprivation (IMD): 10159 / 32844

4th decile
somewhat more deprived

Demographics are based on the LSOA containing this postcode and not necessarily this postcode alone

Sun and Moon Times for NG17 2HA on Monday 8 June 2026

Nautical twilight begins (First light)	02:25
Civil twilight begins (Dawn)	03:49
Sunrise	04:39
Transit (sun is at its highest)	13:04
Sunset	21:28
Civil twilight ends (Dusk)	22:19
Nautical twilight ends (Nightfall)	23:43

Hours of daylight today	04:09 to 21:58
Hours of darkness tonight (lighting-up time)	21:58 to 04:09
Moon Phase	Waning Crescent
Moon Rises	00:27
Moon sets	12:08

For a full sun and moon calendar for NG17 2HA, go to The Time and Place

Residential Property Sales in NG17 2HA

Date	Address	Property Type	Tenure	Price
31 January 2024	34 Columbia Avenue, Sutton-in-Ashfield NG17 2HA	Semi-detached	Freehold	£250,000
16 December 2021	28 Columbia Avenue, Sutton-in-Ashfield NG17 2HA	Semi-detached	Freehold	£220,000
26 February 2021	12 Columbia Avenue, Sutton-in-Ashfield NG17 2HA	Semi-detached	Freehold	£170,000
19 June 2020	86 Columbia Avenue, Sutton-in-Ashfield NG17 2HA	Semi-detached	Freehold	£162,500
16 March 2020	24 Columbia Avenue, Sutton-in-Ashfield NG17 2HA	Semi-detached	Freehold	£167,000
16 August 2019	74 Columbia Avenue, Sutton-in-Ashfield NG17 2HA	Semi-detached	Freehold	£180,000
22 February 2018	26 Columbia Avenue, Sutton-in-Ashfield NG17 2HA	Semi-detached	Freehold	£139,000
26 January 2018	20 Columbia Avenue, Sutton-in-Ashfield NG17 2HA	Detached	Freehold	£172,500
31 July 2017	14 Columbia Avenue, Sutton-in-Ashfield NG17 2HA	Semi-detached	Freehold	£180,000
27 February 2017	18 Columbia Avenue, Sutton-in-Ashfield NG17 2HA	Semi-detached	Freehold	£150,000
16 December 2016	10 Columbia Avenue, Sutton-in-Ashfield NG17 2HA	Semi-detached	Freehold	£168,000
27 May 2016	60 Columbia Avenue, Sutton-in-Ashfield NG17 2HA	Semi-detached	Freehold	£145,000
11 March 2016	90 Columbia Avenue, Sutton-in-Ashfield NG17 2HA	Detached	Freehold	£180,000
24 July 2015	88 Columbia Avenue, Sutton-in-Ashfield NG17 2HA	Detached	Freehold	£140,000
29 May 2015	50 Columbia Avenue, Sutton-in-Ashfield NG17 2HA	Semi-detached	Freehold	£100,000
10 October 2014	34 Columbia Avenue, Sutton-in-Ashfield NG17 2HA	Semi-detached	Freehold	£153,000
13 February 2014	44 Columbia Avenue, Sutton-in-Ashfield NG17 2HA	Semi-detached	Freehold	£132,500
20 August 2010	14 Columbia Avenue, Sutton-in-Ashfield NG17 2HA	Semi-detached	Freehold	£145,000
3 December 2009	38 Columbia Avenue, Sutton-in-Ashfield NG17 2HA	Semi-detached	Freehold	£110,000
26 June 2007	74 Columbia Avenue, Sutton-in-Ashfield NG17 2HA	Semi-detached	Freehold	£152,000
23 June 2006	10 Columbia Avenue, Sutton-in-Ashfield NG17 2HA	Semi-detached	Freehold	£155,000
30 September 2005	4 Columbia Avenue, Sutton-in-Ashfield NG17 2HA	Semi-detached	Freehold	£146,000
13 September 2004	70 Columbia Avenue, Sutton-in-Ashfield NG17 2HA	Semi-detached	Freehold	£112,500
27 August 2003	6 Columbia Avenue, Sutton-in-Ashfield NG17 2HA	Semi-detached	Freehold	£110,000
22 August 2003	76 Columbia Avenue, Sutton-in-Ashfield NG17 2HA	Semi-detached	Freehold	£101,000
6 January 2003	74 Columbia Avenue, Sutton-in-Ashfield NG17 2HA	Semi-detached	Freehold	£80,000
13 December 2002	14a Columbia Avenue, Sutton-in-Ashfield NG17 2HA	Semi-detached	Freehold	£90,000
3 May 2002	70 Columbia Avenue, Sutton-in-Ashfield NG17 2HA	Semi-detached	Freehold	£65,000
18 January 2002	28 Columbia Avenue, Sutton-in-Ashfield NG17 2HA	Semi-detached	Freehold	£52,000
17 August 2001	10 Columbia Avenue, Sutton-in-Ashfield NG17 2HA	Semi-detached	Freehold	£65,000
10 August 2001	34 Columbia Avenue, Sutton-in-Ashfield NG17 2HA	Semi-detached	Freehold	£54,950
2 July 1999	72 Columbia Avenue, Sutton-in-Ashfield NG17 2HA	Detached	Freehold	£50,500
31 May 1996	18 Columbia Avenue, Sutton-in-Ashfield NG17 2HA	Semi-detached	Freehold	£49,950
14 February 1996	14a Columbia Avenue, Sutton-in-Ashfield NG17 2HA	Semi-detached	Freehold	£53,000
24 November 1995	14a Columbia Avenue, Sutton-in-Ashfield NG17 2HA	Semi-detached	Freehold	£59,950
15 September 1995	4 Columbia Avenue, Sutton-in-Ashfield NG17 2HA	Semi-detached	Freehold	£54,000

Key to property sale icons:

	First sale of newbuild property. This includes new properties created from existing properties, such as residential conversions of commercial or agricultural property, or subdivision of a larger residential property.
	Subsequent sale of existing property.
	Standard sale at market value to private individual.
	Additional (non-standard) sale. This includes repossessions, buy-to-lets and transfers of property sold to non-private individuals.

Elected Representatives for NG17 2HA

United Kingdom Parliament

Constituency

Ashfield

MP

Lee Anderson Reform UK

Nottinghamshire County Council

County council electoral division

Sutton West

Councillor

Terry Cox Reform UK

Ashfield District Council

District council ward

Huthwaite & Brierley

Councillors

Tom Hollis Ashfield Independents

Paul Grafton Ashfield Independents

Elected representative data is updated approximately monthly, so may not include recent by-elections or vacancies.

Government Statistical Services (GSS) data for NG17 2HA

Code	Name	Data Type	Data Theme	Active Since	Data Owner
E00142600		Output Areas	Statistical Building Block	1 January 2009	ONS
E01027991	Ashfield 006E	Lower layer Super Output Areas	Statistical Building Block	1 February 2004	ONS
E02005824	Ashfield 006	Middle layer Super Output Areas	Statistical Building Block	1 August 2004	ONS
E05010682	Huthwaite & Brierley	Electoral Wards/Divisions	Administrative/Electoral	7 May 2015	DLUHC
E07000170	Ashfield	Non-metropolitan Districts	Administrative	1 January 2009	DLUHC
E10000024	Nottinghamshire	Counties	Administrative	1 January 2009	DLUHC
E12000004	East Midlands	Regions	Administrative	1 January 2009	DLUHC
E14001068	Ashfield	Westminster Parliamentary Constituencies	Electoral	4 July 2024	LGBC
E23000019	Nottinghamshire	Police Force Areas	Other	1 January 2009	Home Office
E30000240	Mansfield	Travel to Work Areas	Other	31 July 2015	ONS
E33017525		Workplace Zones	Census	31 December 2011	ONS
E37000045	D2N2	Local Enterprise Partnerships	Other	31 December 2022	BEIS
E38000243	NHS Nottingham and Nottinghamshire ICB - 52R	Sub Integrated Care Board Locations	Health	1 July 2022	ODS
E40000011	Midlands	NHS England Regions	Health	1 July 2022	ODS
E43000122	Ashfield, unparished area	Non-Civil Parished Areas	Census	31 December 2011	ONS
E54000060	NHS Nottingham and Nottinghamshire Integrated Care Board	Integrated Care Boards	Health	1 July 2022	ODS
E56000031	East Midlands	Cancer Alliances	Health	1 July 2023	NHS England
E58001211	Sutton West ED	County Electoral Divisions	Electoral	4 May 2017	DLUHC
E63008854	Sutton in Ashfield	Built Up Areas	Census	17 April 2024	OS
E65000001	England Non-National Park Area	England Non-National Park Area	Census	27 February 2023	ONS
E92000001	England	Country	Administrative	1 January 2009	ONS

The UK Postcode Database