Skip to property details

5 Red Hill Close, Great Shelford, Cambridge, CB22 5JP

UPRN:100090155577Detached House6 bedsBuilt 1950-1966
FreeholdCouncil Tax: Band FEPC: C (76)
Data freshness:Listing· 3mo agoListing: ageing, refreshed 3mo ago (2026-08-27T04:00:02.996045+00:00)Planning· 4mo agoPlanning: stale, refreshed 4mo ago (2026-07-10T08:02:17.914963+00:00)EPC· 5mo agoEPC: stale, refreshed 5mo ago (2026-07-01T02:04:50.057738+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· 1mo agoSchools: ageing, refreshed 1mo 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· 1mo agoCouncil Tax: ageing, refreshed 1mo ago (2026-10-19T23:17:27.814396+00:00)
5 Red Hill Close, Great Shelford, Cambridge, CB22 5JP

HP Score

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

    Mixed signals - investigate

Evidence
18 of 21 sources
Sale Estimate
£1,249,000
£1.19M - £1.31MHigh
Estimate
£1.25M
Range
£1.19M – £1.31M
Rent Estimate (pcm)
£4,400
£4k - £5k
Monthly
£4,400
Yield
4.23%

Verdict

Derived from HomePortfolio scores

5 Red Hill Close earns an INVESTIGATE rating with HP Score 68/100. Investment score 60/100 reflects moderate fundamentals. Crime intensity is very low. Walkability is limited (17/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 NationsOfcom mobile coverageMarket 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 covenantsHM Land Registry Price PaidPlanIt / council planning portalsOverture Maps PlacesOfsted / DfE GIAS
HP Score
68/ 100
Mixed
Investment Score
60/ 100
Moderate
Crime Score
9/ 100
Low
Walkability
17/ 100
Low
Transit & Bike
Transit 39Bike 78
Walk Score, out of 100

Valuation & Market

Sale Estimate£1,249,000
Rent Estimate (pcm)£4,400
Gross Yield4.23%
1y Growth-
3y Growth-3.5%
5y Growth-0.5%
10y Growth+1.0%
Last Sold Price£630,000 (2014-02-06)

Risk Overview

  • Flood RiskUnknown
  • SubsidenceLow
  • RadonLow
  • MiningLow
  • LandslideLow
  • Air QualityLow
  • NoiseLow

Planning Activity

Recent Apps
0CB22 5JP
Approval Rate
-12mo
Development
low
  • 26/04220/FUL
    Installation of a 33kV to 11kV substation, modified access alongside new internal road, fencing, landscaping and associated works.
    Pending
  • 26/04202/CL2PD
    Changing front door and adjacent wall, converting loft into habitable accommodation, construction of 5no. new dormer windows
    Pending
  • 26/1248/TTPO
    Willow tree - - The small snapped limb is approximately 5m long with a diameter of about 120-150mm, its removal will have minimal impact on the summer foliage in that part of the tree. - The first main limb, which is completely cracked at the base where it has grown from the main trunk, is estimated to be 8-10m long with a diameter of 450-500mm (at its base). It probably weights about 4 tons and is currently resting on another limb of the same size, placing that lower limb at serious risk of snapping. - The second main limb, currently still attached but has dropped due to the weight of the leaves, is also estimated to be 8-10m long with a diameter of 450-500mm and will have a similar weight. This limb needs to be removed due to that risk, but also because it has dropped to a height where it is not possible for an adult to walk underneath it without bending down.
    Pending

Ownership

  • Corporate Ownership42.4%
  • Overseas OwnershipNo
  • Lease Term Remaining-
  • CovenantsRestrictive
  • Lease TypeFreehold
  • Last Ownership Change2014-02-06
  • SourceLand Registry

Connectivity

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

Area Profile

Median EarningsLocal authority£42,690
Population Density-
Owner Occupied80%
Age Distribution
0-15 18%16-64 57%65+ 25%

Schools Nearby

  • Trumpington Park Primary School
    0.5 mi
    Report card2026

    Ofsted no longer awards a single overall grade.

  • Trumpington Meadows Primary School
    0.7 mi
    Good
  • Fawcett Primary School
    0.9 mi
    Report card2026

    Ofsted no longer awards a single overall grade.

  • Cambridge Academy for Science and Technology
    1.1 mi
    Good

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

Comparables

View All
  • 16 Red Hill Close
    -
    £617k
    -
  • 10 Red Hill Close
    -
    £575k
    -
  • 3 Red Hill Close
    -
    £740k
    -
  • 11 Red Hill Close
    -
    £700k
    -