Appletrees Bar Hill, South Cambridgeshire

156 addresses across 4 postcodes (CB23), about 880 m (0.5 miles) long, classed as a local road. USRN 35301468.

  • Sales: 260 recorded sales since 1995; in 2026 the median was £320,000 across 3 sales.
  • Energy: 97 homes have an energy certificate (A: 1, B: 1, C: 47, D: 45, E: 2, F: 1).
  • Flood: 26 addresses on its postcodes are in areas at high or medium risk of flooding from rivers, the sea or surface water.
  • Council tax: Most homes around it are in council tax band C; Band D in South Cambridgeshire costs £2,536 a year in 2026-27.
  • Broadband: Gigabit broadband is available to 87% to 100% of premises.
  • Transport: The nearest railway station is Cambridge North, about 9.8 km (6.1 miles) away in a straight line.
  • Green space: The nearest park or garden is about 330 m away.
  • Air: Background air pollution in 2024 was 7.0 µg/m³ of nitrogen dioxide and 7.4 of PM2.5, within UK legal limits.
  • Height: Its addresses are 21 to 25 m above sea level.
  • Noise: 31 of its 156 addresses are modelled at 55 dB or more from road traffic.
  • Doctors: The nearest GP surgery is Maple Surgery Bar Hill Health Centre, about 370 m away, with 2 practices within 1.6 km (1 mile).
  • People: About 460 people lived in the census areas around it in 2021; 72% of households owned their home and 39% of adults held a degree or other higher qualification.
  • Crime: 11 crimes were recorded within 250 m between September 2025 and August 2026, most often anti-social behaviour.

Sales on this street

Source: HM Land Registry Price Paid Data, sales registered up to 28 August 2026, loaded 28 October 2026. Sales reach the register two weeks to two months after completion, so the last two months are incomplete. Matched by postcode and street name.

Sales by year (standard sales only; repossessions and buy-to-let transfers excluded)
YearSalesMedian priceLowestHighest
20263£320,000£255,000£360,000
20252£332,500£220,000£445,000
20246£233,000£215,000£467,000
20238£320,000£227,000£490,000
20222£341,000£262,000£420,000
20215£250,000£230,000£265,000
20202£251,500£218,000£285,000
20194£335,000£205,000£385,000
20188£250,000£211,000£400,000
20175£225,000£212,500£325,000
20163£232,000£197,500£235,000
20155£193,000£185,000£310,000
Most recent sales (latest 50 of 260)
DateAddressTypePriceNotes
3 Jun 2026135 CB23 8SPTerraced£185,000Not a standard sale (repossession, buy-to-let or transfer).
15 May 202666 CB23 8SWSemi-detached£360,000
22 Apr 202663 CB23 8SWSemi-detached£255,000
6 Feb 202689 CB23 8SWSemi-detached£320,000
29 Aug 202590 CB23 8SWDetached£445,000
30 May 202548 CB23 8SJSemi-detached£250,000Not a standard sale (repossession, buy-to-let or transfer).
14 Mar 202531 CB23 8SJTerraced£220,000
29 Nov 202412 CB23 8SJTerraced£215,000
7 Nov 2024116 CB23 8SPSemi-detached£467,000
14 Oct 2024197 CB23 8SNTerraced£250,000
14 Aug 2024127 CB23 8SPTerraced£215,000Not a standard sale (repossession, buy-to-let or transfer).
29 Jul 202443 CB23 8SJTerraced£230,000
15 May 202460 CB23 8SWSemi-detached£236,000
22 Mar 202433 CB23 8SJTerraced£228,500
29 Feb 202422 CB23 8SJTerraced£210,000Not a standard sale (repossession, buy-to-let or transfer).
26 Oct 2023130 CB23 8SPSemi-detached£385,000
5 Oct 202389 CB23 8SWSemi-detached£320,000
4 Oct 202341 CB23 8SJTerraced£250,000
11 Sep 2023136 CB23 8SPSemi-detached£320,000
19 May 202393 CB23 8SWDetached£430,000
19 May 202397 CB23 8SWSemi-detached£270,000
3 Mar 202392 CB23 8SWDetached£490,000
2 Mar 202327 CB23 8SJSemi-detached£227,000
30 Nov 202289 CB23 8SWSemi-detached£262,000
14 Apr 2022117 CB23 8SPSemi-detached£420,000
3 Dec 202150 CB23 8SJSemi-detached£241,000
3 Dec 20218 CB23 8SJTerraced£230,000
26 Oct 202111 CB23 8SJTerraced£262,500Not a standard sale (repossession, buy-to-let or transfer).
8 Oct 202126 CB23 8SJTerraced£250,000
30 Jun 2021125 CB23 8SPTerraced£265,000
13 May 2021198 CB23 8SNTerraced£205,000Not a standard sale (repossession, buy-to-let or transfer).
10 Mar 202151 CB23 8SWSemi-detached£260,000
20 Nov 202066 CB23 8SWSemi-detached£285,000
13 Oct 2020189 CB23 8SNSemi-detached£218,000
20 Sep 201992 CB23 8SWDetached£385,000
23 Aug 201982 CB23 8SWDetached£330,000
14 Jun 201918 CB23 8SJTerraced£205,000
29 Apr 201998 CB23 8SWDetached£340,000
18 Dec 2018131 CB23 8SPDetached£340,000
18 Dec 201847 CB23 8SJSemi-detached£235,000
12 Oct 2018125 CB23 8SPTerraced£250,000
12 Sep 201871 CB23 8SWSemi-detached£330,000
11 Sep 201841 CB23 8SJTerraced£211,000
12 Apr 2018108 CB23 8SPSemi-detached£400,000
18 Jan 201819 CB23 8SJTerraced£217,000
5 Jan 2018114 CB23 8SPSemi-detached£250,000
8 Dec 2017194 CB23 8SNTerraced£225,000
11 Aug 201794 CB23 8SWDetached£320,000
11 Aug 201726 CB23 8SJTerraced£223,000
4 May 20173 CB23 8SJTerraced£212,500

Energy performance certificates

Source: Energy Performance of Buildings Register (MHCLG), register as at 1 November 2026. Latest certificate per address; certificates last ten years, so the oldest here dates from December 2008 and some homes have none. Address data © Ordnance Survey and Royal Mail, shown for understanding the energy efficiency of buildings only.

97 homes with a current certificate; median floor area 57 m². Most common: House, detached (25); House, mid-terrace (16); House, end-terrace (14). Built: 1983-1990 (40); 1976-1982 (37); 1967-1975 (19). Tenure at assessment: owner-occupied (53); rented (private) (25); rented (social) (4).

Council tax

What each band costs in South Cambridgeshire in 2026-27: Band D £2,536 a year on average, including the police, fire and any county and parish charges.

ABCDEFGH
£1,691£1,973£2,254£2,536£3,100£3,663£4,227£5,073

Homes by band in the neighbourhood around this street: most are in band C (47% of about 780 homes).

Sources: Valuation Office Agency, Council Tax: stock of properties, homes at 31 March 2026 (counts rounded to the nearest 10), for the neighbourhood (census area of about 700 homes) around it, not just this street; Ministry of Housing, Communities and Local Government, council tax levels 2026-27. Bands are charged as fixed shares of Band D; the actual bill depends on the parish and on discounts such as the single-person discount. Check a home's own band with the official council tax band checker.

Planning and heritage

  • Conservation area: no postcode centre in this street's postcodes is in one.
  • Listed buildings on or by this street: none.
  • Article 4 direction (removing permitted development rights): none recorded, though not every council has published theirs.
  • Tree preservation orders: none recorded, though not every council has published theirs.
  • Green belt: no.

Brownfield land registered for housing within 1 km (0.6 miles)

Source: planning.data.gov.uk (Ministry of Housing, Communities and Local Government), compiled from councils and, for listed buildings, Historic England's National Heritage List. Conservation areas, Article 4 directions, tree preservation areas and the green belt are checked at each postcode's centre. Listed buildings and protected trees are counted on or by this street. Councils publish Article 4 directions, tree preservation orders and brownfield registers to different standards, and some not yet. Planning applications are not here: there is no national open record of them yet.

Roadworks

No street works under way, planned or finished in the last three months on this street, in permits up to 30 September 2026.

Source: Department for Transport, Street Manager open data, permits and works up to 30 September 2026. It is published once a month, so works arranged or started since then are not shown, and dates are the ones planned unless the works have started or finished. Emergency works are often permitted after they begin.

Flood risk

Rivers, the sea or surface water: in this street's postcodes, 9 addresses are in areas at high risk, 17 at medium risk and 13 at low risk. Each address counts once, at the higher of its rivers-and-sea and surface-water risk.

Rivers and the sea alone: of the 50 homes the Environment Agency counts, 0 are in areas at high risk, 0 medium, 1 low and 0 very low.

High: 3.3% (1 in 30) or more chance of flooding a year. Medium: 1% to 3.3%. Low: 0.1% to 1%. Very low: under 0.1%. The rivers and sea figures allow for flood defences. Counts cover whole postcodes, which can include other streets.

Flood zone for planning: no postcode centre on this street is in flood zone 2 or 3.

PostcodePlanning zoneAddresses at high / medium / low riskGroundwater
CB23 8SJnot in 2 or 3 3 / 0 / 6 unlikely
CB23 8SWnot in 2 or 3 1 / 5 / 1 unlikely
CB23 8SPnot in 2 or 3 5 / 12 / 4 unlikely
CB23 8SNnot in 2 or 3 0 / 0 / 2 unlikely

Sources: Environment Agency Flood risk: postcode search tool data (loaded 29 October 2026), Risk of Flooding from Rivers and Sea: postcodes in areas at risk (loaded 29 October 2026) and Flood Map for Planning (loaded 28 October 2026). Flood zones are checked at each postcode's centre point. These are models of areas, which their publishers say are not suitable for showing whether an individual property is at risk, and they do not cover flooding from sewers or drains. Check an address on the official long-term flood risk service.

© Environment Agency copyright and/or database right 2026. All rights reserved. Some features are based on digital spatial data from the Centre for Ecology & Hydrology, © NERC (CEH); the postcode data is produced in part from PAF® and Multiple Residence Data, © Royal Mail Group Limited.

Height above sea level

The street's 156 addresses are between 21 m and 25 m above sea level (24 m on average).

Source: Ordnance Survey, OS Terrain 50, July 2026: the height of the ground on a 50 m grid, read at each address, in metres above Ordnance Datum (mean sea level at Newlyn). It is the lie of the land, not floor or threshold levels, and is accurate to a few metres. Being low-lying is not in itself a flood risk; the flood section above says what the flood maps show.

Broadband

Source: Ofcom Connected Nations, data as at January 2026. Percentages are of premises in each postcode that can get the service, not take-up or speed achieved.

Availability by postcode (% of premises)
PostcodeSuperfast (30 Mbit/s+)Ultrafast (300 Mbit/s+)GigabitBelow 10 Mbit/s
CB23 8SJ100%100%100%0%
CB23 8SN87%87%87%0%
CB23 8SP97%97%97%0%
CB23 8SW100%100%100%0%

Getting around

Sources: Department for Transport, NaPTAN (every public transport stop), as at 31 October 2026; Office of Rail and Road, Estimates of station usage 2024–25 (which stations are on the National Rail network, and their journeys: entries and exits in the year to March); OurAirports (public domain, kept by volunteers); car parks and charging points from Overture Maps Foundation, release 2026-10-21.0, which gathers business listings from Meta, Microsoft, Foursquare and others: not an official register, so some will be missing, private or out of date. Distances are straight lines from the middle of the street, not routes, and say nothing about how often anything runs. Stations opened since the end of ORR's year appear when ORR publishes the next one, each December; heritage railways are left out.

NearestDistance
Railway stationsCambridge North 1.5 million journeys in 2024–259.8 km (6.1 miles)
Cambridge 11 million journeys in 2024–2510.1 km (6.3 miles)
Waterbeach 372,000 journeys in 2024–2512 km (7.4 miles)
Bus stops3 stops within 400 m (0.2 miles), 13 within 800 m (0.5 miles); nearest Apple Trees Bar Hill200 m
Bus or coach stationDrummer St Bus Station Cambridge8.6 km (5.3 miles)
EV charging points3 within 1.6 km (1 mile); nearest Q-Arc Building, Cambridge Science Park600 m (0.4 miles)
Airport with scheduled flightsLondon Stansted Airport STN43.2 km (27 miles)

Local services

Sources: NHS Organisation Data Service, as at 31 October 2026: GP practices, community pharmacies and dental practices with an NHS contract, open now, each placed at the centre of its postcode; hospitals are NHS trust and Welsh health board sites named as hospitals, and may not have an emergency department. Police stations and cash machines from Overture Maps Foundation, release 2026-10-21.0, which gathers business listings: not an official register, so some will be missing or out of date. Distances are straight lines from the middle of the street. Nothing here says whether a practice is taking new patients or a dentist new NHS patients.

NearestDistance
GP surgeries2 practices within 1.6 km (1 mile); nearest Maple Surgery Bar Hill Health Centre370 m
Pharmacies1 pharmacies within 1.6 km (1 mile); nearest Tesco In-Store Pharmacy610 m (0.4 miles)
NHS dentists1 practices within 1.6 km (1 mile); nearest Bar Hill Dental Practice370 m
HospitalSpire Cambridge Lea Hospital6.3 km (3.9 miles)
Police stationHiston Police Station6.2 km (3.8 miles)
Cash machinesATM4 km (2.5 miles)

Parks and green space

Source: Ordnance Survey, OS Open Greenspace, April 2026: public parks and gardens, play spaces, playing fields and allotments, with their entrances. Distances are straight lines from the middle of the street to a site's nearest entrance (or its edge where none is recorded), not walking routes; sizes are the area OS maps for each site. Some sites, such as school playing fields, may not be open to the public.

NearestDistance
Park or garden2 within 800 m (0.5 miles); nearest Unnamed 2,520 m²330 m
Play area3 within 800 m (0.5 miles); nearest Unnamed 1,500 m²220 m
Playing field1 within 800 m (0.5 miles); nearest Unnamed 5.2 ha100 m
Allotments1 within 800 m (0.5 miles); nearest Unnamed 4,860 m²760 m (0.5 miles)

Within 800 m (0.5 miles): 2 parks and gardens, 0.3 hectares in all.

Landmarks

The nearest historic landmark is Madingley Hall, a registered park or garden (Grade II), 3 km (1.8 miles) south. 5 listed buildings are within 1 km (0.6 miles).

Historic places
NameWhat it isFrom the middle of the street
Madingley HallRegistered park or garden, Grade II3 km (1.8 miles) south
Natural landmarks within 5 km (3.1 miles)
NameWhat it isFrom the middle of the street
Craft's HillHill500 m (0.3 miles) south-east
The PlantationWood500 m (0.3 miles) south
Icehouse GroveWood1.1 km (0.7 miles) south-west
Lolworth SpringWood1.2 km (0.7 miles) north-west
Sheepclose SpinneyWood1.3 km (0.8 miles) south-west
Horseshoe PondLake or reservoir2.8 km (1.7 miles) south

Sources: Historic England's registers through planning.data.gov.uk (MHCLG), and Cadw through DataMapWales (Welsh Government): World Heritage Sites within 10 km (6.2 miles), battlefields within 5 km (3.1 miles), registered parks and gardens within 3 km (1.9 miles), scheduled monuments within 2 km (1.2 miles), and Grade I and II* listed buildings within 1 km (0.6 miles). Ordnance Survey, OS Open Names, October 2026: named hills, valleys, lakes, woods, wetlands and coast (it has no rivers). Distances are in a straight line to the middle of each site, and being on a register does not mean there is public access.

Air quality

Source: Defra, modelled background air pollution, annual means for 2024, for the 1 km square that holds the middle of the street. These are background levels, away from the kerb: beside a busy road nitrogen dioxide in particular can be several times higher. UK limits are the legal annual limits for England and Wales; the World Health Organization's 2021 guidelines are much stricter, and most towns and cities are above them.

Annual means in µg/m³ (micrograms per cubic metre of air)
PollutantHereUK limitWHO guideline
Nitrogen dioxide (NO2)7.04010
Fine particles (PM2.5)7.4205
Particles (PM10)14.84015

All three are within the UK legal limits; PM2.5 is above the WHO guideline, as in most towns and cities.

Road and rail noise

Source: Defra, strategic noise mapping Round 4 (England), modelled for 2021 and published in December 2023, and its airport maps of the same round for the fifteen largest English airports, published in April 2026: Lden, the average sound level over a whole day with extra weight for the evening and night, on a 10 m grid, read at each address. These are models of traffic, not measurements; they leave out smaller airports and airfields, industry and neighbours, and a room at the back of a house is often much quieter than the front. The World Health Organization's guidelines are 53 dB for road traffic, 54 dB for railways and 45 dB for aircraft (below the lowest level shown here).

Addresses by modelled noise level (Lden, dB)
LevelRoad trafficRailways
55 to 59310
Under 55125156

31 of the street's 156 addresses are modelled at 55 dB or more from road traffic, above the WHO guidelines.

Climate, daylight and earthquakes

Monthly temperatures and rainfall, sunrise and sunset through the year, and earthquakes recorded nearby since 1970 are much the same across the area, so they are worked out once for South Cambridgeshire: see them on the South Cambridgeshire page.

Nearest schools

Source: Get Information About Schools (Department for Education), 1 November 2026; Ofsted monthly management information as at September 2026. Distances are straight lines from the middle of the street to the school; catchments and admissions are not shown. Since November 2025 Ofsted gives report-card grades by area, not one overall grade; older grades stand until a school is re-inspected.

SchoolPhaseAgesDistanceInspection
Bar Hill Community Primary SchoolPrimary4–11290 m No published inspection
Dry Drayton CofE (C) Primary School, and Pre-School Church of EnglandPrimary4–111.2 km (0.8 miles) Good (Mar 2023, overall grade under the previous framework)

Food hygiene ratings nearby

Source: Food Standards Agency, Food Hygiene Rating Scheme, extract of 1 November 2026. Each rating is shown with the date it was given; a business may have been re-inspected since the extract. Within 500 m (0.3 miles) of the middle of the street.

BusinessTypeDistanceRatingRated
Bar Hill Day Nursery CB23 8DYHospitals/Childcare/Caring Premises250 m4 Good14 Jul 2026
Churchill's Fish & Chips CB23 8DZTakeaway/sandwich shop380 m5 Very good28 May 2025
Costa Coffee CB23 8DZRestaurant/Cafe/Canteen390 m5 Very good4 Jun 2025
Tesco (Main Shop) CB23 8ELRetailers - supermarkets/hypermarkets500 m (0.3 miles)5 Very good27 Nov 2025
Tesco (Family Dining Cafe) CB23 8ELRestaurant/Cafe/Canteen500 m (0.3 miles)5 Very good4 Jun 2025
Holland & Barrett CB23 8ELRetailers - other500 m (0.3 miles)5 Very good20 Nov 2020
Greggs PLC CB23 8ELRetailers - other500 m (0.3 miles)5 Very good24 Feb 2026
Yo! To Go! CB23 8ELTakeaway/sandwich shop500 m (0.3 miles)5 Very good28 Jan 2026
The Fox CB23 8DYPub/bar/nightclub500 m (0.3 miles)5 Very good27 Oct 2025

Crime within 250 m

Source: data.police.uk street-level crime, September 2025 to August 2026. Police forces move every crime to the nearest of about 760,000 anonymised map points before publishing, so these are crimes near this street, not on it, and a busy point can collect crimes from a wider area. Counts are of records, not convictions.

11 recorded crimes by category
CategoryCrimes
Anti-social behaviour6
Violence and sexual offences2
Criminal damage and arson1
Shoplifting1
Public order1

Most of these are attached to: On or near Appletrees (7); On or near Watermead (2); On or near Brookdale (2).

People and work

Source: ONS Census 2021, taken on 21 March 2021, for the 2 Output Areas (small census areas of about 125 households each) that this street's postcodes are in: 455 residents in 222 households. The census was taken during a lockdown, so working from home is high and travel to work low compared with now. ONS swaps a few records between neighbouring areas and adds small amounts of noise to counts to protect privacy, so small differences mean little. Industry is not published for areas this small.

Who lives here

Around this streetEngland
Median age4440
Children under 1517%17%
Aged 65 and over20%18%

Homes

Around this streetEngland
Owned (outright or with a mortgage)72%61%
Owned outright41%33%
Shared ownershipunder 1%1%
Social rented4%17%
Private rented24%21%

Work and commuting

Around this streetEngland
Adults (16 and over) in work63%57%
Unemployment (of those working or looking for work)6%6%
Retired (of adults)23%22%
Long-term sick or disabled (of adults)3%4%
Work mainly from home (of those in work)38%32%
Travel to work by car or van41%48%
By train, Underground, metro or tramunder 1%4%
By any public transport, including bus8%8%
On foot or by bicycle12%10%
Work within 10 km (6 miles) of home (of those who travel to work)63%65%
Work 30 km (19 miles) or more away6%8%

Education and languages

Around this streetEngland
Degree or other higher qualification, Level 4+ (of adults)39%34%
No qualifications13%18%
Apprenticeship as highest qualification6%5%
Main language English (aged 3 and over)88%91%
Cannot speak English well or at all2%2%

Deprivation

The neighbourhood around this street is in decile 9 of 10 on the English Indices of Deprivation 2025, where 1 is the most deprived tenth of England's 33,755 neighbourhoods and 10 the least.

Source: English Indices of Deprivation 2025 (Ministry of Housing, Communities and Local Government), by LSOA (about 1,500 people), through the ONS Postcode Directory. The index combines income, employment, health, education, crime, housing and living environment; it ranks areas against each other and does not describe any one household. Ranks in England and Wales are worked out separately and cannot be compared.

What has changed

Nothing new since the change feed started on 30 October 2026. New sales and energy certificates, and hygiene ratings, school inspections and flood figures nearby, will be listed here as the sources update.

Everything that has changed on and near this street

Postcodes on this street

Source: ONS Postcode Directory August 2026, ONS UPRN Directory September 2026, OS Open Linked Identifiers September 2026. A postcode can cover more than one street; the share shows how many of its addresses are on this one.

Nearby streets

Watermead · Brookdale · Foxhollow · Fox Hollow · Acorn Avenue · Hollytrees · Hillcrest · The Spinney · Almond Grove · Hanover Close

All the streets in CB23 and across South Cambridgeshire.

What this page cannot tell you

  • Whether a particular house is at risk of flooding, subsiding or anything else: the flood map is a model of areas and there is no property-level data here.
  • What a home is worth now: sales are historic prices for the homes that happened to sell.
  • How safe the street is: crime points are moved to anonymised locations and many crimes are never reported.
  • Whether you would get a place at a school: distances are straight lines, not catchments.
  • Who lives on the street now: census figures describe the small areas around it in March 2021, during a lockdown.
  • How long a journey takes or how often anything runs: transport distances are straight lines to the nearest stops.
  • Whether a GP practice is taking new patients, or a dentist new NHS patients.
  • How loud a home is inside, or noise from industry, neighbours or smaller airfields: noise figures are models of road, rail and air traffic outside.

How each figure on this page is matched to the street and worked out: methodology.