Cambridge · CM9 8JJ · 3-bed
School Road, Little Totham
© OpenStreetMap · click to open in maps
Asking price
£475,000
Verdict
Overpriced by £71,238 vs 3-bed homes nearby
What you could do with it
Estimated gross yields from current rental comps. Numbers are pre-cost — service, voids, mortgage, management still come off these.
Standard BTL
£1,375/mo
3.5% gross yield
Open-market tenant on a 12-month AST.
HMO (rooms)
Best fit£2,064/mo
5.2% gross yield
4–6 individual tenants, shared living. Highest yield, most management.
LHA / Section 8
£678/mo
1.7% gross yield
Council-paid tenant. Stable rent, longer tenancies, slight discount to market.
Council lease
£576/mo
1.5% gross yield
3–5 yr guaranteed-rent lease to a housing association. Hands-off.
Who is this for?
Quick read across the buyer personas. ✅ = good fit · ⚠ = workable with caveats · ❌ = look elsewhere.
Family home
3-bed but EPC unknown — factor retrofit cost or budget for it.
Standard BTL
3.5% gross — won't cover costs at current rates.
HMO (rooms)
5.2% HMO yield is too low for the management overhead.
Buy + rent later
Rent wouldn't cover mortgage — selling to exit may be your only option.
The numbers
England (SDLT) · 75% LTV mortgage at 5.5% over 25 years (capital repayment).
Stamp duty
First-time buyer
£2,500
Home mover
£11,250
2nd home / BTL
£35,000
Mortgage @ 75% LTV
- Loan
- £356,250
- Deposit
- £118,750
- Per month
- £2,188
Cash you'd need to walk in (deposit + investor SDLT, before legal/survey): £153,750
Should you pay this?
Asking price is roughly £71,238 above what 3-bed homes typically go for here.
You're paying £475,000. Comparable 3-bed homes in this area suggest a market price of around £403,762.
Contains HM Land Registry data © Crown copyright and database right.
What it'd rent for
£1,375/month3.47% gross yield
Based on 792 live rentals in Cambridge · 3-bed homes here average £2,156/mo.
Most landlords need 5%+ gross to break even after costs in this area, so this is tight as a fallback — worth running the numbers carefully.
Property features
- []
Loading nearby sold…
5-year price trend
Crime risk
Flood risk
Schools & Ofsted
No schools indexed yet for this postcode sector. The official sources below cover every UK postcode.
Catchments aren't published nationally; many schools use distance-from-school as the deciding factor. The links above give you the official data — only the local authority can confirm a specific year's catchment boundary.
Contains public sector information licensed under the Open Government Licence v3.0.
HMO licensing
£825 – £1,500typical UK HMO fee, 5-year licence
3-bed property. Mandatory licensing kicks in at 5+ unrelated occupants. Below that, a licence is only required if the council runs an additional or selective scheme — the link below is the way to check.
The council's HMO page lists the current mandatory fee plus any additional / selective scheme that catches smaller HMOs.
Find borough HMO licensing page on gov.ukMandatory licensing applies UK-wide for 5+ sharer HMOs (Housing Act 2004). Scotland licenses 3+ sharers; Wales also requires Rent Smart Wales registration for every landlord.
Area pulse
- 31,087 new listings here in the last month — good comparable supply.
Share this analysis
Want unlimited saved searches, the full investor breakdown, and the what-if calculator? Try Pro free for 3 days.