Skip to property details

Upper Farm, 151 Alms Hill, Bourn, Cambridge, CB23 2SZ

UPRN:100090130567Detached House4 bedsBuilt before 1900
FreeholdCouncil Tax: Band GEPC: E (50)
Data freshness:Listing· freshListing: fresh, refreshed 4d ago (2026-11-17T04:00:05.967747+00:00)Planning· 3mo agoPlanning: stale, refreshed 3mo ago (2026-08-13T08:22:09.466716+00:00)EPC· 2mo agoEPC: ageing, refreshed 2mo ago (2026-10-01T13:29:54.950580+00:00)Risk· 5mo agoRisk: stale, refreshed 5mo ago (2026-06-18T00:00:00+00:00)Connectivity· 2mo agoConnectivity: ageing, refreshed 2mo ago (2026-10-03T06:43:10.905825+00:00)Schools· 2mo agoSchools: ageing, refreshed 2mo ago (2026-10-06T05:00:30.533230+00:00)Amenities· 2mo agoAmenities: ageing, refreshed 2mo ago (2026-09-23T00:00:00+00:00)Area· Census 2021Area: static reference data (Census 2021); authoritative and does not refreshCouncil Tax· 6mo agoCouncil Tax: stale, refreshed 6mo ago (2026-05-16T18:26:08.262453+00:00)
Upper Farm, 151 Alms Hill, Bourn, Cambridge, CB23 2SZ

HP Score

Mixed
Verdict
4 days ago
  • Verdict: INVESTIGATE, on a scale of Buy, Investigate, Avoid.

    Mixed signals - investigate

Evidence
18 of 21 sources
Sale Estimate
£1,259,000
£1.13M - £1.39MMedium
Estimate
£1.26M
Range
£1.13M – £1.39M
Rent Estimate (pcm)
£5,250
£5k - £6k
Monthly
£5,250
Yield
4.06%

Verdict

Derived from HomePortfolio scores

Upper Farm earns an INVESTIGATE rating with HP Score 64/100. Investment score 53/100 reflects moderate fundamentals. Crime intensity is low. Walkability is limited (29/100). Flood risk is not assessed: check the Environment Agency long-term flood map before offering. Tenure is freehold. Every figure here comes from the live HomePortfolio API; anything it does not publish is left out.

Key SourcesEPC RegisterPortal listingsOfcom Connected NationsMarket estimates (third-party AVM)HM Land Registry sales matched to addressDefra strategic noise mapping, England Round 4 (Contains Defra data © Crown copyright and database right 2023-2024, Open Government Licence v3.0)Walk ScoreONS Census 2021Police.ukHM Land Registry company ownershipHM Land Registry covenantsHM Land Registry Price PaidPlanIt / council planning portalsOverture Maps PlacesOfsted / DfE GIAS
HP Score
64/ 100
Mixed
Investment Score
53/ 100
Moderate
Crime Score
16/ 100
Moderate
Walkability
29/ 100
Low
Transit & Bike
Transit 29Bike 37
Walk Score, out of 100

Valuation & Market

Sale Estimate£1,259,000
Rent Estimate (pcm)£5,250
Gross Yield4.06%
1y Growth-
3y Growth-0.8%
5y Growth+2.2%
10y Growth+2.7%
Last Sold Price£385,000 (2001-06-22)

Risk Overview

  • Flood RiskUnknown
  • SubsidenceModerate
  • RadonLow
  • MiningUnknown
  • LandslideLow
  • Air QualityLow
  • NoiseLow

Planning Activity

Recent Apps
1CB23 2SZ
Approval Rate
-12mo
Development
low
  • 26/04184/FUL
    Extend existing compound to provide a new switch-house, vehicular access, perimeter fencing and boundary planting.
    Pending
  • 26/0954/TTCA
    T1- Maple- reduce in height and spread by 1.5 meters to maintain in its current location.
    Approved
  • 26/0892/TTCA
    T1- Ash- crown raise over entrance driveway to a height of 3.5 meters removing 3 meters. T2- Lime- crown raise over lawn to a height of 3 meters removing 2 meters to maintain in their current locations
    Approved

Ownership

  • Corporate Ownership60.6%
  • Overseas OwnershipNo
  • Lease Term Remaining-
  • CovenantsRestrictive
  • Lease TypeFreehold
  • Last Ownership Change2001-06-22
  • SourceLand Registry

Connectivity

Broadband (Standard)
7 Mbps
Mobile 4G/5G Coverage
-
EV Charger
-
PTAL Rating
-

Area Profile

Median EarningsLocal authority£42,690
Population Density200 /km²
Owner Occupied73%
Age Distribution
0-15 26%16-64 61%65+ 13%

Schools Nearby

  • Bourn CofE Primary Academy
    0.7 mi
    Good
  • The Vine Inter-Church Primary School
    1.2 mi
    Good
  • Monkfield Park Primary School
    1.4 mi
    Good
  • Jeavons Wood Primary School
    1.4 mi
    Report card2026

    Ofsted no longer awards a single overall grade.

3 of 14 nearby schools with published figures were oversubscribed in 2026 - demand, not a catchment.

Comparables

View All
  • 100 Alms Hill
    -
    £977k
    -
  • 207 Alms Hill
    -
    £250k
    -
  • 130 Alms Hill
    -
    £360k
    -
  • Crow End Farm, 152 Alms Hill
    -
    £850k
    -