24 Longworth Avenue, Chesterton, Cambridge, CB4 1GU

UPRN:10002562124Purpose Built Flat3 bedsBuilt 1996-2002

LeaseholdCouncil Tax: Band EEPC: C (77)

Data freshness:Listing· freshOwnership· freshEPC· 3mo agoRisk· 5mo agoCrime· freshConnectivity· 1mo agoSchools· 1mo agoAmenities· 2mo agoArea· Census 2021Council Tax· 6mo ago

24 Longworth Avenue, Chesterton, Cambridge, CB4 1GU

HP Score

/ 100

Mixed

Verdict

yesterday

Verdict: INVESTIGATE, on a scale of Buy, Investigate, Avoid.
Mixed signals - investigate

Evidence

20 of 21 sources

Sale Estimate

£416,000

£396k - £437kHigh

Estimate

£416k

Range

£396k – £437k

Rent Estimate (pcm)

£1,950

£2k - £2k

Monthly

£1,950

Yield

7.43%

Verdict

Derived from HomePortfolio scores

24 Longworth Avenue earns an INVESTIGATE rating with HP Score 73/100. Investment score 61/100 reflects moderate fundamentals. Crime intensity is moderate. Walkability is good (83/100). Flood risk is not assessed: check the Environment Agency long-term flood map before offering. Tenure is leasehold. 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 company ownershipHM Land Registry covenantsHM Land Registry leasesHM Land Registry Price PaidPlanIt / council planning portalsOverture Maps PlacesOfsted / DfE GIAS

HP Score

73/ 100

Mixed

Investment Score

61/ 100

Moderate

Crime Score

41/ 100

Elevated

Walkability

83/ 100

High

Transit & Bike

Transit 58Bike 95

Walk Score, out of 100

Opportunity

Why this could be an opportunity

Low confidence1 independent sourceLead to verifyListing checked 11 Nov 2026

This rests largely on a single source. Treat the score as a prompt to investigate, not a conclusion.

Check before relying on this score: the estimate sits 24% above the ask; lead to verify: leasehold with no service charge disclosed - the stress test assumes GBP 0. It ranks after every home whose inputs are verified.

Valuation edge2.5/15
claims [AVM +24.3% (HIGH), sold-comps +38.6%, £/sqft +38.6%] → measured edge +0.50pp of the ask; on later-registered sales an AVM discount carried no edge and a sold-evidence gap at most +0.5pp
Market estimate used (HIGH confidence) · snapshot 14 Nov 2026
- valuation_snapshotsestimate for 10002562124· as of 14 Nov 2026
- property_comparablessold-evidence family (implied value + £/sqft): 12 comps, dispersion 17.2%· as of 12 Nov 2026
Rental economics17.3/40
gross yield 7.4%; range width penalty ×0.89; the estimate this rent rides on sits 24% above the ask - check the rent describes the advertised home
- valuation_snapshotsrent estimate 1950/mo (range 1800-2100)· as of 14 Nov 2026· verify before relying on this
- valuation_snapshotssale estimate 24% above the ask on the same snapshot - verify the rent describes this home· as of 14 Nov 2026· verify before relying on this
Stress margin0/30
stressed cash flow -26/mo, -1% of rent (6.75% on a 75% loan; no service charge or ground rent disclosed); fails the stress - earns nothing; leasehold with no service charge disclosed - the stress assumes GBP 0
- underwriting_assumptionscosts not disclosed by the advert· as of 11 Nov 2026· verify before relying on this
Seller motivationNot scored
context, not scored: 1 price cut(s), 74 days on market; homes with a cut sold 0.2-0.3pp further below the cut ask, which is not an edge
- portal_listingsprice_changes + first_published_date· as of 11 Nov 2026
Risk & liquidity14.7/15
250 sales/12mo in area; valuation range width 10%
- property_intelligencetransactions_12mo

4 of 4 components scored. Ranks on gross yield, the stress margin, risk and disclosed facts. A pricing claim earns only its measured edge: today 0 for the market estimate and at most +0.5pp for sold evidence. The score itself is not yet checked against the outcomes of homes it scored.

Economics

What happens to your money

Price sensitivity

£236,000£362,000

The same scorer re-run at hypothetical asking prices, holding rent, comps and listing history constant. Not a prediction of what the seller would accept.

Your assumptions

Purchase price£315,000

At the asking price

Monthly rent£1,950/mo

Evidenced range £1,800-£2,100

Interest rate5.4%

Loan to value75%

Cash required: £101,550
Net cash flow: £287/mo
Cash on cash: 3.4%
Score at this price: 34

After a 8% void allowance, 15% management and 10% maintenance. Lender coverage (rent ÷ interest): 1.83 - clears the usual 1.25 test. These are your assumptions, not evidence: only the pre-filled rent and price come from the record.

Evidence

Where every number comes from

valuation_snapshotsestimate for 10002562124Valuation edge · as of 14 Nov 2026
property_comparablessold-evidence family (implied value + £/sqft): 12 comps, dispersion 17.2%Valuation edge · as of 12 Nov 2026
valuation_snapshotsrent estimate 1950/mo (range 1800-2100)Rental economics · as of 14 Nov 2026 · verify before relying on this
valuation_snapshotssale estimate 24% above the ask on the same snapshot - verify the rent describes this homeRental economics · as of 14 Nov 2026 · verify before relying on this
underwriting_assumptionscosts not disclosed by the advert

Risks

What could kill this deal

Score confidence is low
largely a single source - treat the number as a prompt, not a conclusion
Rental economics needs verification before you rely on it
rent estimate 1950/mo (range 1800-2100)
Rental economics needs verification before you rely on it
sale estimate 24% above the ask on the same snapshot - verify the rent describes this home

Plan

Before you offer

1. Get two written rental appraisals from local lettings agents.
The market estimate this rent rides on sits far above the asking price, so the rent may describe a different home.
2. Ask the agent why the price was reduced and whether a previous sale fell through.
1 price cut(s) recorded on the listing history.
3. Treat the gap to the estimate as unproven - compare recent sold prices on the street yourself before pricing an offer around it.
On later completions, homes listed below their estimate sold at the same share of the asking price as the rest.
4. Commission a full structural survey, not a basic condition report.
The score prices market evidence, not the fabric of the building.

Valuation & Market

Sale Estimate£416,000

Rent Estimate (pcm)£1,950

Gross Yield7.43%

1y Growth+35.6%

3y Growth-2.7%

5y Growth+0.1%

10y Growth+0.8%

Last Sold Price£295,000 (2012-01-16)

View Market Details

Risk Overview

Flood RiskUnknown
SubsidenceLow
RadonLow
MiningLow
LandslideLow
Air QualityLow
NoiseLow

View Full Risk Report

Planning Activity

Recent Apps

1CB4 1GU

Approval Rate

100%12mo

Development

low

26/1315/TTCA
T1 Rowan - Fell. Reason: Parking space too short for vehicle and applicant wishes to have room to install an EV charger
Pending
26/1313/TTCA
Acacia tree - Removal, third of the tree has come down in the storm and the remaining tree has been classified as unsafe.
Pending
26/1292/TTCA
T 1 - Yew - Reduce the height by 1.5m and the width in all directions by 1m.
Pending

View Planning Timeline

Ownership

Corporate Ownership59.7%
Overseas OwnershipNo
Lease Term Remaining100 yrs
CovenantsRestrictive
Lease TypeLeasehold
Last Ownership Change2012-01-16
SourceLand Registry

View Ownership Details

Connectivity

Broadband (Standard)

7 Mbps

Mobile 4G/5G Coverage

EEThreeO2Vodafone

EV Charger

PTAL Rating

View Connectivity Map

Area Profile

Median EarningsLocal authority£38,711

Population Density6,622 /km²

Owner Occupied40%

Age Distribution

0-15 13%16-64 70%65+ 17%

View Area Profile

Schools Nearby

Cambridge Arts and Sciences (CATS and CSVPA)
0.2 mi
Inspected by ISI
Milton Road Primary School
0.4 mi
Area grades2025
Inspected after Ofsted withdrew the single overall grade.
OA - Cambridge
0.4 mi
Good
Brunswick Nursery School
0.6 mi
Report card2026
Ofsted no longer awards a single overall grade.

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

View All Schools

Comparables

View All

72 Longworth Avenue
-
£857k
-
17 Longworth Avenue
-
£818k
-
66 Longworth Avenue
-
£340k
-
44 Longworth Avenue
-
£790k
-

Boundary data not available for this property

No registered title polygon, building footprint, or street match for this property yet.

Why: No HMLR INSPIRE / OSM footprint / OS Open USRN match for this UPRN

Source: HM Land Registry INSPIRE / OpenStreetMap / OS Open USRN