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 Kings Stand, in King's Walk, Berry Hill & Oakham
What it's like at NG18 4AY: every home that has sold on Kings Stand 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 Kings Stand; new homes, planning permissions and schools within 1 km over the last five years. Everything changing within 2 km.
1 of the 70 homes on the street are owned by companies.
| 1, Kings StandDetached | Nov 2002 | £177,000 | 161 m² | £1,099/m² | 1 |
|---|---|---|---|---|---|
| 2, Kings StandDetached | Dec 2024 | £320,000 | 115 m² | £2,783/m² | 5 |
| 3, Kings StandDetached | Dec 2020 | £285,000 | 116 m² | £2,457/m² | 4 |
| 4, Kings StandDetached | Dec 2024 | £330,000 | 154 m² | £2,143/m² | 6 |
| 5, Kings StandDetached | May 2023 | £362,000 | 147 m² | £2,463/m² | 3 |
| 6, Kings StandDetached | May 2018 | £300,000 | 200 m² | £1,500/m² | 4 |
| 7, Kings StandDetached | Feb 2007 | £319,000 | 166 m² | £1,922/m² | 2 |
| 8, Kings StandDetached | Nov 2024 | £385,000 | 172 m² | £2,238/m² | 5 |
| 9, Kings StandDetached | Jul 2000 | £147,000 | – | – | 1 |
| 10, Kings StandDetached | Dec 2013 | £212,000 | 122 m² | £1,738/m² | 2 |
| 11, Kings StandDetached | Aug 2024 | £330,000 | 107 m² | £3,084/m² | 3 |
| 12, Kings StandDetached | Aug 2001 | £145,000 | – | – | 1 |
| 14, Kings StandDetached | Jun 2003 | £193,000 | 118 m² | £1,636/m² | 2 |
| 15, Kings StandDetached | Aug 2021 | £285,000 | 123 m² | £2,317/m² | 2 |
| 16, Kings StandDetached | Sept 2013 | £240,000 | 137 m² | £1,752/m² | 3 |
| 17, Kings StandDetached | Oct 2001 | £135,000 | – | – | 1 |
| 18, Kings StandDetached | Feb 2025 | £342,500 | 118 m² | £2,903/m² | 5 |
| 19, Kings StandDetached | Nov 2001 | £140,000 | – | – | 1 |
| 20, Kings StandDetached | Dec 2013 | £232,000 | 135 m² | £1,719/m² | 4 |
| 21, Kings StandDetached | Sept 2014 | £197,000 | 140 m² | £1,407/m² | 3 |
| 22, Kings StandDetached | Dec 2008 | £190,000 | – | – | 2 |
| 23, Kings StandDetached | Jun 2004 | £206,000 | – | – | 2 |
| 24, Kings StandDetached | Jan 2025 | £365,000 | 125 m² | £2,920/m² | 5 |
| 25, Kings StandSemi-detached | Aug 2002 | £84,000 | 67 m² | £1,254/m² | 1 |
| 26, Kings StandDetached | Sept 2005 | £220,000 | 120 m² | £1,833/m² | 2 |
| 27, Kings StandSemi-detached | Dec 2006 | £134,950 | 71 m² | £1,901/m² | 2 |
| 28, Kings StandDetached | Nov 2001 | £125,000 | 131 m² | £954/m² | 1 |
| 29, Kings StandFlat | Feb 2026 | £135,000 | 55 m² | £2,455/m² | 3 |
| 30, Kings StandDetached | Jan 2020 | £263,000 | 125 m² | £2,104/m² | 3 |
| 31, Kings StandFlat | Sept 2002 | £85,000 | 88 m² | £966/m² | 1 |
| 32, Kings StandDetached | Nov 2001 | £115,000 | 98 m² | £1,173/m² | 1 |
| 33, Kings StandFlat | Sept 2004 | £117,500 | – | – | 1 |
| 34, Kings StandSemi-detached | Nov 2001 | £78,000 | – | – | 1 |
| 35, Kings StandFlat | Sept 2024 | £128,000 | 60 m² | £2,133/m² | 4 |
| 36, Kings StandSemi-detached | Nov 2024 | £200,000 | 71 m² | £2,817/m² | 5 |
| 37, Kings StandFlat · company-owned | Oct 2019 | £119,995 | 68 m² | £1,765/m² | 2 |
| 38, Kings StandSemi-detached | Dec 2002 | £80,000 | – | – | 2 |
| 39, Kings StandFlat | Nov 2021 | £130,000 | 68 m² | £1,912/m² | 3 |
| 40, Kings StandSemi-detached | Jan 2020 | £152,000 | 69 m² | £2,203/m² | 4 |
| 41, Kings StandDetached | Nov 2003 | £132,500 | – | – | 2 |
| 42, Kings StandDetached | Feb 2026 | £312,500 | 105 m² | £2,976/m² | 3 |
| 43, Kings StandDetached | Apr 2010 | £195,000 | 140 m² | £1,393/m² | 3 |
| 44, Kings StandDetached | Jan 2002 | £128,000 | – | – | 1 |
| 45, Kings StandDetached | Jun 2014 | £212,000 | 117 m² | £1,812/m² | 3 |
| 46, Kings StandDetached | Aug 2017 | £226,500 | – | – | 2 |
| 47, Kings StandDetached | Jun 2018 | £330,000 | 167 m² | £1,976/m² | 5 |
| 48, Kings StandDetached | Jan 2024 | £347,000 | 140 m² | £2,479/m² | 2 |
| 49, Kings StandDetached | May 2002 | £165,000 | – | – | 1 |
| 50, Kings StandDetached | Mar 2016 | £245,000 | 101 m² | £2,426/m² | 3 |
| 51, Kings StandDetached | Aug 2004 | £223,000 | 115 m² | £1,939/m² | 2 |
| 52, Kings StandDetached | Jul 2026 | £295,000 | 109 m² | £2,706/m² | 5 |
| 53, Kings StandDetached | Jan 2009 | £242,500 | – | – | 2 |
| 54, Kings StandDetached | Mar 2022 | £405,000 | 170 m² | £2,382/m² | 3 |
| 55, Kings StandDetached | Jan 2014 | £215,000 | 116 m² | £1,853/m² | 3 |
| 56, Kings StandDetached | Dec 2017 | £253,000 | 133 m² | £1,902/m² | 3 |
| 57, Kings StandDetached | Jun 2025 | £325,000 | 118 m² | £2,754/m² | 2 |
| 59, Kings StandDetached | Aug 2016 | £290,000 | 155 m² | £1,871/m² | 3 |
| 61, Kings StandDetached | Jun 2022 | £426,265 | 183 m² | £2,329/m² | 2 |
| 63, Kings StandDetached | Mar 2002 | £145,000 | 131 m² | £1,107/m² | 1 |
| 65, Kings StandDetached | May 2014 | £230,000 | 125 m² | £1,840/m² | 2 |
| 67, Kings StandDetached | Mar 2002 | £145,000 | – | – | 1 |
| 69, Kings StandDetached | Dec 2014 | £299,950 | 161 m² | £1,863/m² | 2 |
| 71, Kings StandDetached | Sept 2013 | £155,000 | 85 m² | £1,824/m² | 3 |
| 73, Kings StandDetached | Apr 2002 | £133,000 | 115 m² | £1,157/m² | 1 |
| 75, Kings StandFlat | May 2022 | £130,000 | 58 m² | £2,241/m² | 4 |
| 77, Kings StandFlat | Jul 2004 | £109,000 | 62 m² | £1,758/m² | 2 |
| 79, Kings StandFlat | Aug 2023 | £125,000 | 66 m² | £1,894/m² | 6 |
| 81, Kings StandFlat | Jun 2002 | £79,000 | 73 m² | £1,082/m² | 1 |
| 83, Kings StandFlat | Sept 2016 | £115,000 | 64 m² | £1,797/m² | 3 |
| 85, Kings StandFlat | Aug 2018 | £120,000 | 73 m² | £1,644/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 (1.8 km), with 323k journeys a year; its busiest route is to Nottingham.
The nearest bus stop is Care Home, 100 m away, with fewer than one bus an hour on weekdays (routes 219, 6); 2 departures an hour from the 6 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, a few minutes' walk (450 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, 1.8 km away; Attainment 8: 37.1 · 5.1% of GCSEs at 8–9.
The nearest supermarket is Tesco, 1.4 km away, with One Stop closer still (250 m) for top-ups.
The nearest GP surgery is Nottingham Road Healthcare (1.2 km), with Newgate Pharmacy the closest pharmacy (1.4 km).
For a haircut, Alexsa Beauty & Holistic Studio is 850 m 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.
Cellos Bar and Brasserie is the closest café or restaurant (250 m), and Sherwood Childcare the nearest pub (450 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 Berry Hill Park, 400 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.
11 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.
| Building | Grade | Distance |
|---|---|---|
| Coach House and Attached Gate Piers at Berry Hill Hall | II | 140 m |
| Berry Hill Hall | II | 170 m |
Grade I and II* are the most important few per cent. Listing means consent is needed for most changes, inside and out. Contains Historic England data © Historic England 2026 (via planning.data.gov.uk), OGL.
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%.
17 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 4AY →
On this street: 2 of 48 homes with certificates have solar panels, 0 a heat pump, and 0 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.
Tap a type to see what it covers and how it has changed in Mansfield since 2011.
police.uk, 2025-09 to 2026-08. Crimes are mapped to the nearest of a set of anonymised points and labelled with that point's street, so busy roads and junctions collect crimes from nearby; the street has about 70 homes that have sold since 1995. Greater Manchester Police data is not published, and national totals leave Greater Manchester out.