Cambridge · SG4 8YD · 3-bed
35 Goldcrest Avenue, Codicote
© OpenStreetMap · click to open in maps
Asking price
£129,375
Verdict
Worth a closer look — area data is mixed
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
£2,700/mo
25.0% gross yield
Open-market tenant on a 12-month AST.
HMO (rooms)
Best fit£4,445/mo
41.2% gross yield
4–6 individual tenants, shared living. Highest yield, most management.
LHA / Section 8
£678/mo
6.3% gross yield
Council-paid tenant. Stable rent, longer tenancies, slight discount to market.
Council lease
£576/mo
5.3% 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
25.0% gross — clears typical 5%+ break-even threshold.
HMO (rooms)
41.2% HMO yield, no Article 4 — strong on paper.
Buy + rent later
Rents would more than cover BTL mortgage costs if life changes.
The numbers
England (SDLT) · 75% LTV mortgage at 5.5% over 25 years (capital repayment).
Stamp duty
First-time buyer
£0
Home mover
£0
2nd home / BTL
£6,469
Mortgage @ 75% LTV
- Loan
- £97,031
- Deposit
- £32,344
- Per month
- £596
Cash you'd need to walk in (deposit + investor SDLT, before legal/survey): £38,813
Should you pay this?
City-wide stats vary too much within the 3-bed homes segment to give you a confident £ comparison. A 3-bed home in a quieter postcode can sit £200k+ apart from one in a hot postcode just down the road.
Before bidding: walk the street, pull HM Land Registry sold prices for this postcode sector, and check what genuinely-similar homes have actually transacted at over the last 12 months.
What it'd rent for
£2,700/month25.04% 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 a decent fallback if your plans shift.
Property features
- []
Loading nearby sold…
5-year price trend
Crime risk
Flood risk
Schools & Ofsted
Catchment area is the #1 driver of family-let demand and exit liquidity in the suburbs. Verify the local primary + secondary ratings before offering — an Outstanding catchment can add 5–10% to £/sqft; Inadequate is a permanent drag.
- All schools within 2 miles (DfE GIAS) — official register, last Ofsted, type
- Ofsted reports for SG4 8YD — full inspection reports + history
- Catchment visualiser (Locrating) — free-tier school-catchment map
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.
HMO licensing
No curated HMO data for this area. Most UK councils run mandatory licensing for 5+ sharers (statutory) plus area-specific additional / selective schemes. Verify with the local authority before completing a purchase.
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.