31 Sherlock Close, Cambridge, CB3 0HP

UPRN:200004159158Flat/Maisonette2 bedsBuilt 1976-1982

Shared ownershipCouncil Tax: Band CEPC: C (75)

Data freshness:Listing· freshPlanning· 4mo agoOwnership· freshEPC· 5mo agoRisk· 5mo agoCrime· freshConnectivity· 1mo agoSchools· 1mo agoAmenities· 2mo agoArea· Census 2021Council Tax· 1mo ago

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

£324,000

£308k - £340kHigh

Estimate

£324k

Range

£308k – £340k

Rent Estimate (pcm)

£1,350

£1k - £1k

Monthly

£1,350

Yield

5.40%

Verdict

Derived from HomePortfolio scores

31 Sherlock Close earns an INVESTIGATE rating with HP Score 73/100. Investment score 60/100 reflects moderate fundamentals. Crime intensity is low. Walkability is limited (57/100). Flood risk is not assessed: check the Environment Agency long-term flood map before offering. Tenure is shared ownership. 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

73/ 100

Mixed

Investment Score

60/ 100

Moderate

Crime Score

20/ 100

Moderate

Walkability

57/ 100

Moderate

Transit & Bike

Transit 33Bike 88

Walk Score, out of 100

Opportunity

Why this could be an opportunity

Low confidence0 independent sourcesListing checked 7 Nov 2026

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

Valuation edge0/15
claims [AVM +7.4% (HIGH)] → measured edge +0.00pp 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 9 Nov 2026
- valuation_snapshotsestimate for 200004159158· as of 9 Nov 2026
Rental economics2.9/40
gross yield 5.4%; range width penalty ×0.90
- valuation_snapshotsrent estimate 1350/mo (range 1250-1450)· as of 9 Nov 2026· verify before relying on this
- listing_factslisting text signals condition works - budget before trusting any yield· as of 7 Nov 2026· verify before relying on this
Stress margin0/30
stressed cash flow -558/mo, -41% of rent (6.75% on a 75% loan; disclosed service charge and ground rent); fails the stress - earns nothing
- listing_factsservice charge / ground rent from the advert· as of 7 Nov 2026
Seller motivationNot scored
context, not scored: 0 price cut(s), 297 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 7 Nov 2026
Risk & liquidity14.7/15
91 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

£225,000£345,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£300,000

At the asking price

Monthly rent£1,350/mo

Evidenced range £1,250-£1,450

Interest rate5.4%

Loan to value75%

Cash required: £96,300
Net cash flow: -£78/mo
Cash on cash: -1.0%
Score at this price: 18

After a 8% void allowance, 15% management and 10% maintenance. Lender coverage (rent ÷ interest): 1.33 - 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 200004159158Valuation edge · as of 9 Nov 2026
valuation_snapshotsrent estimate 1350/mo (range 1250-1450)Rental economics · as of 9 Nov 2026 · verify before relying on this
listing_factslisting text signals condition works - budget before trusting any yieldRental economics · as of 7 Nov 2026 · verify before relying on this
listing_factsservice charge / ground rent from the advertStress margin · as of 7 Nov 2026
portal_listingsprice_changes + first_published_dateSeller motivation · as of 7 Nov 2026

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 1350/mo (range 1250-1450)
Rental economics needs verification before you rely on it
listing text signals condition works - budget before trusting any yield

Plan

Before you offer

1. Get two written rental appraisals from local lettings agents.
The rent estimate rests on area-level evidence, not lettings on this street.
2. 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.
3. 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£324,000

Rent Estimate (pcm)£1,350

Gross Yield5.40%

1y Growth-

3y Growth+3.5%

5y Growth-0.6%

10y Growth+0.4%

Last Sold Price-

View Market Details

Risk Overview

Flood RiskUnknown
SubsidenceSignificant
RadonLow
MiningUnknown
LandslideLow
Air QualityLow
NoiseLow

View Full Risk Report

Planning Activity

Recent Apps

0CB3 0HP

Approval Rate

-12mo

Development

low

26/1303/TTCA
T1 - Silver Birch - Crown reduce in height by 5m - Tree is blocking out light to windows Flat 16
Pending
26/04147/S73
S73 to vary condition 2 (approved plans) of ref: 25/04720/HFUL (Single storey side and rear extension, including 2no. rooflights. Replacement of existing juliette balcony and 1no. rear window with 2no. windows.) to allow revision of the ground floor internal layout, including the addition of a small opaque window to the wc and a door to the utility room.
Pending
26/1278/TTPO
Group of lime x 3 - crown lift to 4m over road and parking bays 7 & 8. Reason to improve access on pavement and in parking area.
Pending

View Planning Timeline

Ownership

Corporate Ownership62.4%
Overseas OwnershipNo
Lease Term Remaining121 yrs
CovenantsRestrictive
Lease TypeShared ownership
Last Ownership Change-
SourceLand Registry

View Ownership Details

Connectivity

Broadband (Standard)

13 Mbps

Mobile 4G/5G Coverage

EEThreeO2Vodafone

EV Charger

PTAL Rating

View Connectivity Map

Area Profile

Median EarningsLocal authority£38,711

Population Density3,171 /km²

Owner Occupied56%

Age Distribution

0-15 22%16-64 69%65+ 9%

View Area Profile

Schools Nearby

Mayfield Primary School
0.3 mi
Inspected as Mayfield Primary School (URN 110666) on 21 Mar 2023
University of Cambridge Primary School
0.4 mi
-
St Luke's CofE Primary School
0.5 mi
Requires improvement
St John's College School
0.7 mi
Inspected by ISI

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

View All Schools

Comparables

View All

34 Sherlock Close
-
£372k
-
56 Sherlock Close
-
£340k
-
52 Sherlock Close
-
£315k
-
60 Sherlock Close
-
£393k
-

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