167 The Rowans, Milton, Cambridge, CB24 6YZ

UPRN:100090161237Semi-Detached House3 bedsBuilt 1983-1990

FreeholdCouncil Tax: Band CEPC: C (72)

Data freshness:Listing· freshPrice Paid· freshPlanning· 4mo agoEPC· 3mo agoRisk· 5mo agoConnectivity· 1mo agoSchools· 1mo agoAmenities· 1mo agoArea· Census 2021

167 The Rowans, Milton, Cambridge, CB24 6YZ

HP Score

/ 100

Mixed

Verdict

yesterday

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

Evidence

18 of 21 sources

Sale Estimate

£410,000

£389k - £430kHigh

Estimate

£410k

Range

£389k – £430k

Rent Estimate (pcm)

£1,700

£2k - £2k

Monthly

£1,700

Yield

4.92%

Verdict

Derived from HomePortfolio scores

167 The Rowans earns an INVESTIGATE rating with HP Score 60/100. Investment score 51/100 reflects moderate fundamentals. Crime intensity is moderate. Walkability is limited (51/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

60/ 100

Mixed

Investment Score

51/ 100

Moderate

Crime Score

59/ 100

Elevated

Walkability

51/ 100

Moderate

Transit & Bike

Transit 45Bike 82

Walk Score, out of 100

Opportunity

Why this could be an opportunity

Low confidence0 independent sourcesListing checked 5 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 -1.2% (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 10 Oct 2026
- valuation_snapshotsestimate for 100090161237· as of 10 Oct 2026
Rental economics0/40
gross yield 4.9%; range width penalty ×0.91
- valuation_snapshotsrent estimate 1700/mo (range 1600-1850)· as of 10 Oct 2026· verify before relying on this
Stress margin0/30
stressed cash flow -631/mo, -37% of rent (6.75% on a 75% loan; no service charge or ground rent disclosed); fails the stress - earns nothing
- underwriting_assumptionscosts not disclosed by the advert· as of 5 Nov 2026
Seller motivationNot scored
context, not scored: 0 price cut(s), 160 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 5 Nov 2026
Risk & liquidity14.6/15
336 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

£311,000£477,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£415,000

At the asking price

Monthly rent£1,700/mo

Evidenced range £1,600-£1,850

Interest rate5.4%

Loan to value75%

Cash required: £136,550
Net cash flow: -£224/mo
Cash on cash: -2.0%
Score at this price: 15

After a 8% void allowance, 15% management and 10% maintenance. Lender coverage (rent ÷ interest): 1.21 - below 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 100090161237Valuation edge · as of 10 Oct 2026
valuation_snapshotsrent estimate 1700/mo (range 1600-1850)Rental economics · as of 10 Oct 2026 · verify before relying on this
underwriting_assumptionscosts not disclosed by the advertStress margin · as of 5 Nov 2026
portal_listingsprice_changes + first_published_dateSeller motivation · as of 5 Nov 2026
property_intelligencetransactions_12moRisk & liquidity

Sold comparables in depth

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 1700/mo (range 1600-1850)
Seller motivation could not be scored
context, not scored: 0 price cut(s), 160 days on market; homes with a cut sold 0.2-0.3pp further below the cut ask, which is not an edge

Property risk deep-dive →

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. 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£410,000

Rent Estimate (pcm)£1,700

Gross Yield4.92%

1y Growth+31.0%

3y Growth-1.9%

5y Growth+0.5%

10y Growth+1.8%

Last Sold Price£171,000 (2004-06-21)

View Market Details

Risk Overview

Flood RiskUnknown
SubsidenceSignificant
RadonLow
MiningUnknown
LandslideLow
Air QualityLow
NoiseLow

View Full Risk Report

Planning Activity

Recent Apps

0CB24 6YZ

Approval Rate

-12mo

Development

low

26/1230/TTCA
T1 - WALNUT x 12ms high - CONSIDERABLE CANOPY OVERHANG TO NEIGHBOURING PROPERTY AT 2 FEN ROAD, MILTON KNOCKING AGAINST SECOND FLOOR WINDOW - cut back lateral branches house side (2 Fen Rd) to boundary, being a reduction of approximately 2ms and up to height of 4ms to provide building clearance, this will leave lateral branches approximately 4 ms long,
Pending
26/03957/HFUL
Installation of an external ground floor Air Conditioning Unit to front elevation.
Pending
23/03249/CONDA
Submission of details required by condition 4 (Brickwork Details) of planning permission 23/03249/FUL
Pending

View Planning Timeline