Flat 1, 74 Newmarket Road, Cambridge, CB5 8DZ

UPRN:10090966085Flat/Maisonette1 bedsBuilt 2007-2011

Tenure: -Council Tax: Band CEPC: D (62)

Data freshness:Ownership· freshEPC· 6mo agoRisk· 5mo agoConnectivity· 1mo agoSchools· 1mo agoAmenities· 2mo agoArea· Census 2021Council Tax· 1mo ago

Flat 1, 74 Newmarket Road, Cambridge, CB5 8DZ

HP Score

/ 100

Mixed

Verdict

today

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

Evidence

19 of 21 sources

Sale Estimate

£325,000

£293k - £358kMedium

Estimate

£325k

Range

£293k – £358k

Rent Estimate (pcm)

£1,350

£1k - £1k

Monthly

£1,350

Yield

0.12%

Verdict

Derived from HomePortfolio scores

Flat 1 earns an INVESTIGATE rating with HP Score 62/100. Investment score 60/100 reflects moderate fundamentals. Crime intensity is elevated. Walkability is excellent (94/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 covenantsHM Land Registry leasesHM Land Registry Price PaidPlanIt / council planning portalsOverture Maps PlacesOfsted / DfE GIAS

HP Score

62/ 100

Mixed

Investment Score

60/ 100

Moderate

100

Crime Score

100/ 100

Elevated

Walkability

94/ 100

Excellent

Transit & Bike

Transit 52Bike 97

Walk Score, out of 100

Opportunity

Not scored as an opportunity

We will not put a number on this one.

2 live adverts with different prices, types or bedrooms on one UPRN (£13,990,000-£14,500,000) - several homes collapsed onto one address, so the UPRN's valuation describes none of them

Withholding a score is deliberate. A number built on missing or stale inputs would look more certain than the evidence allows.

Economics

What happens to your money

Your assumptions

Purchase price£13,990,000

At the asking price

Monthly rent£1,350/mo

Evidenced range £1,250-£1,450

Interest rate5.4%

Loan to value75%

Cash required: £5,790,850
Net cash flow: -£46,282/mo
Cash on cash: -9.6%
Score at this price: -

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

Risks

What could kill this deal

Score confidence is low
largely a single source - treat the number as a prompt, not a conclusion

Property risk deep-dive →flood, subsidence, crime, environment - the full domain

Plan

Before you offer

1. Commission a full structural survey, not a basic condition report.
The score prices market evidence, not the fabric of the building.

Every step above was generated from a specific gap or flag in the evidence - no generic advice, no invented tasks.

Valuation & Market

Sale Estimate£325,000

Rent Estimate (pcm)£1,350

Gross Yield0.12%

1y Growth-

3y Growth-11.5%

5y Growth-0.4%

10y Growth+1.9%

Last Sold Price-

View Market Details

Risk Overview

Flood RiskUnknown
SubsidenceLow
RadonLow
MiningLow
LandslideLow
Air QualityLow
NoiseModerate

View Full Risk Report

Planning Activity

Recent Apps

5CB5 8DZ

Approval Rate

-12mo

Development

low

26/04118/HFUL
Single storey rear extension
Pending
26/02671/CONDA
Submission of details required by condition 3 (Bespoke Conservation) of listed building consent 26/02671/LBC
Pending
26/1277/TTCA
Acacia (T1) crown reduce Easterly aspect by up to 1m. Crown reduce Westerly aspect by up to 2m to remove growth away from neighbours property, shape into the crown. Apple (T2) crown reduce Easterly aspect by up to 2m to previous pruning points (back to neighbour's boundary)
Pending

View Planning Timeline

Ownership

Corporate Ownership62.2%
Overseas OwnershipNo
Lease Term Remaining-
CovenantsRestrictive
Lease Type-
Last Ownership Change-
SourceLand Registry

View Ownership Details

Connectivity

Broadband (Standard)

16 Mbps

Mobile 4G/5G Coverage

EEThreeO2Vodafone

EV Charger

PTAL Rating

View Connectivity Map

Area Profile

Median EarningsLocal authority£38,711

Population Density-

Owner Occupied41%

Age Distribution

0-15 10%16-64 77%65+ 13%

View Area Profile

Schools Nearby

Brunswick Nursery School
0.2 mi
Report card2026
Ofsted no longer awards a single overall grade.
St Matthew's Primary School
0.3 mi
Good
Parkside Community College
0.4 mi
Outstanding
Cambridge Arts and Sciences (CATS and CSVPA)
0.6 mi
Inspected by ISI

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

View All Schools

Comparables

View All

Dukes Court Newmarket Road
-
£5.20M
-
70 Newmarket Road
-
£800k
-
76 - 78 Newmarket Road
-
£585k
-

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