Finding postcode…
These only choose where you start. Every page and every lens is still one tap away.
Sign in to keep them on every device →Finding postcode…
On The Avenue, in King's Walk, Berry Hill & Oakham
What it's like at NG18 4PD: every home that has sold on The Avenue since 1995 and who owns them, what's happening down the road, crime on the street, a day in the life, history on the doorstep and what's changing nearby. Moving, buying, selling, improving or investing? Pick a lens above for what matters to you.
Street View and the aerial view come from Google, which receives your IP address and may set cookies once you choose them. We'll remember your choice on this device.
Compared with all 7,264 neighbourhoods in England and Wales (council well-being: all councils). Open a tab below for the detail.
ORR, DfE, police.uk, OS Terrain 50 and Open Greenspace, Forestry Commission, Defra noise maps (England), Xoserve. Every distance: Moving; radon, ground and flood checks: Buying.
3 homes on the street extended (energy certificates).
Sales and extensions on The Avenue; new homes, planning permissions and schools within 1 km over the last five years. Everything changing within 2 km.
None of the 32 homes on the street is owned by a company.
| 21, The AvenueDetached | Jun 2021 | £350,000 | 124 m² | £2,823/m² | 1 |
|---|---|---|---|---|---|
| 22, The AvenueDetached | Jun 2016 | £355,000 | 165 m² | £2,152/m² | 2 |
| 23, The AvenueDetached | Feb 2025 | £565,000 | 179 m² | £3,156/m² | 2 |
| 27, The AvenueDetached | Dec 2016 | £320,000 | 179 m² | £1,788/m² | 2 |
| 28, The AvenueDetached | Nov 2013 | £460,000 | 231 m² | £1,991/m² | 2 |
| 29, The AvenueDetached | Jun 2019 | £390,000 | 153 m² | £2,549/m² | 3 |
| 30, The AvenueDetached | Mar 2023 | £505,000 | 157 m² | £3,217/m² | 2 |
| 31, The AvenueDetached | Jun 2020 | £425,000 | 160 m² | £2,656/m² | 4 |
| 34, The AvenueDetached | Jan 2021 | £432,000 | 207 m² | £2,087/m² | 2 |
| 35, The AvenueDetached | Sept 2010 | £405,000 | 202 m² | £2,005/m² | 1 |
| 37, The AvenueDetached | May 2017 | £317,500 | 118 m² | £2,691/m² | 1 |
| 38, The AvenueDetached | Jul 2018 | £395,000 | 183 m² | £2,158/m² | 2 |
| 39, The AvenueDetached | Dec 2015 | £290,000 | 225 m² | £1,289/m² | 1 |
| 40, The AvenueDetached | May 2024 | £750,000 | 282 m² | £2,660/m² | 3 |
| 42, The AvenueDetached | Jan 2017 | £300,000 | 131 m² | £2,290/m² | 3 |
From HM Land Registry sale records (standard sales) and energy certificates. Tap a home for its full history.
The nearest station is Mansfield, a short drive or bike ride (2.7 km), with 323k journeys a year; its busiest route is to Nottingham.
The nearest bus stop is The Avenue, 250 m away, with fewer than one bus an hour on weekdays (route 218); 12 departures an hour from the 8 stops within a 5-minute walk.
This is car country: only 10% of households have no car.
The nearest primary school is Berry Hill Primary School, about a 5-minute walk (550 m); 53% met the expected standard.
None of the state primaries within 2 km has Ofsted's top rating.
The nearest secondary is Sherwood Church Academy, 2.4 km away; Attainment 8: 37.1 · 5.1% of GCSEs at 8–9.
The nearest supermarket is Tesco, 600 m away; Bellamy Road (600 m) for top-ups.
The nearest GP surgery is Oak Tree Lane Health Centre (1.3 km), with Tesco Instore Pharmacy the closest pharmacy (1.4 km).
For a haircut, Alexsa Beauty & Holistic Studio is 1.1 km away.
The nearest full A&E is King's Mill Hospital, 3.3 km away, rated good by the CQC.
At its trust, 69% of major A&E patients were seen within 4 hours in September 2026 (the NHS standard is 95%), and 64% of people waiting for planned treatment had waited under 18 weeks (typical wait 13 weeks).
There's a handful of places to eat and drink locally: 26 restaurants and cafés, 9 pubs and bars.
South Mansfield Community Association is the closest café or restaurant (300 m), and Sherwood Childcare the nearest pub (550 m).
Crime is around the national middle: about 85 per 1,000 residents a year.
There are 13 listed buildings.
Detached houses make up 57% of homes.
The typical home here was built in 1973-1982.
It's growing: about 318 new homes were completed in 2021–2025.
The nearest park is King George V Recreation Ground, 250 m away; for exercise, Bannatyne Health Club (850 m).
Air quality is around the national middle (nitrogen dioxide 9.3 µg/m³).
For holidays, East Midlands is 35 km away, and Manchester, with far more destinations, 77 km.
Neighbours tend to stay put: 42% of households own their home outright.
Written from the figures on this page: Census 2021, DfT journey times (2019), NaPTAN/ORR, Ofsted, CQC, FSA, police.uk and planning registers. Figures describe the neighbourhood around the street.
10 places on this map are within about a 10-minute walk.
Walking times are estimates from straight-line distance. Food businesses from the FSA food hygiene register; schools from the DfE register; nurseries from Ofsted's childcare register; care homes from the Care Quality Commission; pools, sports halls, tennis and golf from Sport England Active Places (contains data © Sport England); everything else © OpenStreetMap contributors (ODbL). Map © OpenFreeMap, OpenMapTiles, OpenStreetMap contributors.
Mansfield constituency: Steve Yemm MP (Labour), since July 2024. 2024 general election: Lab gain from Con, majority 3,485 (8.5%), turnout 55%. Vote shares: Labour 39%, Conservative 31%, Reform UK 23%, Green Party 3%.
6 new homes, planning permissions and school changes on record within 2 km, plus energy projects, road works, storm overflows and major infrastructure. Everything changing near NG18 4PD →
No crimes recorded "on or near" The Avenue in the last 12 months.
On this street: 0 of 28 homes with certificates have solar panels, 1 a heat pump, and 1 are heated by something other than mains gas.
| Neighbourhood | Council | England and Wales | |
|---|---|---|---|
| Homes with solar panels | 1.2% | 1.8% | 1.2% |
| Heated by a heat pump | 0.3% | 0.4% | 1.1% |
| Mains gas | 98.3% | 96.3% | 84.0% |
| Oil or LPG | 0.2% | 0.4% | 4.1% |
| Electric heating | 0.9% | 1.8% | 8.3% |
| Community heating | 0.0% | 0.2% | 2.1% |
From each home's latest energy certificate, so panels or heat pumps fitted since aren't counted and the shares are lower than today's real figures. Compare areas in the data explorer.
Nearest: Rutland Water Whitwell Creek · about 63 min
The most notable of each. Rough times by car in free-flowing traffic, between neighbourhood centres. Check opening times before you travel.