Flat 3, The Red House, 155 Chesterton Road, Cambridge, CB4 1AA
UPRN:200004169746Flat/Maisonette1 bedsBuilt before 1900
Tenure: -Council Tax: -EPC: D (64)
Data freshness:Listing· freshListing: fresh, refreshed 5d ago (2026-11-11T04:00:09.660235+00:00)Planning· 4mo agoPlanning: stale, refreshed 4mo ago (2026-07-10T08:05:53.592756+00:00)Ownership· freshOwnership: fresh, refreshed 5d ago (2026-11-10T18:40:27.452272+00:00)EPC· 6mo agoEPC: stale, refreshed 6mo ago (2026-05-20T10:58:39.129138+00:00)Risk· 5mo agoRisk: stale, refreshed 5mo ago (2026-06-18T00:00:00+00:00)Crime· freshCrime: fresh, refreshed 4d ago (2026-11-11T13:01:03.839912+00:00)Connectivity· 1mo agoConnectivity: ageing, refreshed 1mo ago (2026-10-03T06:43:10.905825+00:00)Schools· 1mo agoSchools: ageing, refreshed 1mo ago (2026-10-06T08:24:30.427161+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 refresh
HP Score
61
/ 100
Mixed
Verdict
3 days ago
- Verdict: INVESTIGATE, on a scale of Buy, Investigate, Avoid.
Mixed signals - investigate
Evidence
17 of 21 sourcesSale Estimate
£312,000
£250k - £375kLow
Estimate
£312k
Range
£250k – £375k
Rent Estimate (pcm)
£1,500
£1k - £2k
Monthly
£1,500
Yield
5.77%
Verdict
Derived from HomePortfolio scores
Flat 3 earns an INVESTIGATE rating with HP Score 61/100. Investment score 59/100 reflects moderate fundamentals. Crime intensity is elevated. Walkability is good (84/100). Flood risk is not assessed: check the Environment Agency long-term flood map before offering. 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)Defra 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 Price PaidPlanIt / council planning portalsOverture Maps PlacesOfsted / DfE GIAS
61
HP Score
61/ 100
Mixed
59
Investment Score
59/ 100
Moderate
91
Crime Score
91/ 100
Elevated
84
Walkability
84/ 100
High
Transit & Bike
Transit 59Bike 95
Walk Score, out of 100
Valuation & Market
Sale Estimate£312,000
Rent Estimate (pcm)£1,500
Gross Yield5.77%
1y Growth-
3y Growth-2.7%
5y Growth+0.1%
10y Growth+0.8%
Last Sold Price-
Risk Overview
- Flood RiskUnknown
- SubsidenceLow
- RadonLow
- MiningLow
- LandslideLow
- Air QualityLow
- NoiseHigh
Planning Activity
Recent Apps
0CB4 1AA
Approval Rate
-12mo
Development
low
- Pending26/1315/TTCAT1 Rowan - Fell. Reason: Parking space too short for vehicle and applicant wishes to have room to install an EV charger
- Pending26/1313/TTCAAcacia tree - Removal, third of the tree has come down in the storm and the remaining tree has been classified as unsafe.
- Pending26/04186/CL2PDCertificate of lawfulness under S192 for facade remedial works.
Ownership
- Corporate Ownership59.7%
- Overseas OwnershipNo
- Lease Term Remaining-
- CovenantsNone
- Lease Type-
- Last Ownership Change-
- SourceLand Registry
Connectivity
Broadband (Standard)
9 Mbps
Mobile 4G/5G Coverage
EEThreeO2Vodafone
EV Charger
-
PTAL Rating
-
Area Profile
Median EarningsLocal authority£38,711
Population Density7,558 /km²
Owner Occupied37%
Age Distribution
0-15 13%16-64 74%65+ 13%
Schools Nearby
- Chesterton Community College0.2 miArea grades2025
Inspected after Ofsted withdrew the single overall grade.
- Milton Road Primary School0.3 miArea grades2025
Inspected after Ofsted withdrew the single overall grade.
- Castle School, Cambridge0.3 miRequires improvementConcerns
- OA - Cambridge0.3 miGood
3 of 9 nearby schools with published figures were oversubscribed in 2026 - demand, not a catchment.
Comparables
- 153 Chesterton Road-£825k-
- 155 Chesterton Road-£837k-
- 137 Chesterton Road-£765k-
- 151 Chesterton Road-£700k-