CEDAR BARN
Recent sale
£765k
Sale price
£/sqft
-
Rent pcm
-
Yield
-
Mulberry House, Witham Friary, Frome, BA11 5HF
UPRN:250055033Detached House6 bedsBuilt -
FreeholdCouncil Tax: Band GEPC: -
Data freshness:Listing· freshListing: fresh, refreshed yesterday (2026-10-23T04:00:04.135672+00:00)Planning· 4mo agoPlanning: stale, refreshed 4mo ago (2026-07-10T08:40:27.163532+00:00)Risk· 2y agoRisk: stale, refreshed 2y ago (2024-12-31T00:00:00+00:00)Amenities· 1mo agoAmenities: ageing, refreshed 1mo ago (2026-09-23T00:00:00+00:00)Area· Census 2021Area: static reference data (Census 2021); authoritative and does not refresh
Valuation estimateUpdated yesterday
£1,216,000
Estimated value
Range: £1.16M - £1.28M|Last sold: £858k (2017-10-05)
Estimate of £1.22M for this detached house. 431 sales in BA11 in the last 12 months; median £320k.
Estimate confidence
High confidence
Value History
Current estimate
£1.22M
£1.16M - £1.28M - High confidence
Annualised (CAGR)
+3.89%
Over the full window
Peak estimate
£1.33M
May 2026
From peak
-8.43%
Drawdown from peak
AVM estimate (model)Repeat-sales index - BA11 district (quarterly)index YoY +3.04%
Growth by window
3m
-2.41%
6m
-6.25%
12m
-1.54%
24m
-3.57%
60m
+6.39%
Rental Market
Estimated rent (pcm)
£3,750
/ month
Gross yield
3.60%
Rent ÷ asking price
Net yield
2.50%
Assumes ~31% running costs (not this property's)
Vacancy trend
12-month change
Market Metrics
Median Area Price
£320k
BA11 sales, last 12 months
12m Price Growth
-
BA11 median, Land Registry
Days on Market
92d
BA11 average
Sales & Yield
3 metricsTransactions / 12m
431
BA11 sales
Area Gross Yield
5.69%
BA11 medians
Last Sold
£858k
2017-10-05
Investment Analysis
Buy-to-let cashflow + capital returns
Purchase
- Asking Price£1,250,000
- SDLT standard£68,750
- SDLT BTL surcharge (5%)£62,500
- Legal, survey + broker (assumed)£2,100
- RefurbishmentNot costed
- Total Cost (excl. refurb)£1,383,350
Funding
- Deposit (25%)£312,500
- Mortgage (75% LTV)£937,500
- Interest Rate (assumed)5.25%
- Mortgage TypeInterest Only
- Cash Required£445,850
Monthly Returns
- Monthly Rent (estimate)£3,750
- Mortgage Payment (IO)-£4,102
- Management (10%)-£375
- Insurance (assumed)-£40
- Maintenance (assumed)-£60
- Monthly Cashflow-£827
Capital Returns
- 5yr Property Value£1,250,000
- 5yr Capital Gain (0.00% pa, historical)+£0
- 5yr Cumulative Rent (net)+£204,770
- Less mortgage interest-£246,120
- 5yr Total Return-£41,350
Modelled on the live asking price. Assumed, as in the PDF report: 25% deposit, 5.25% interest-only mortgage, management 10% of rent, insurance £40/mo, maintenance £60/mo, legal, survey and broker £2,100. Refurbishment, voids and letting fees are not costed.
5-Year Projection
| Year | Property Value | Equity | Cashflow (cumulative) | Total Return | ROI |
|---|---|---|---|---|---|
| Year 1 | £1,250,000 | £312,500 | -£9,924 | -£9,924 | -2.2% |
| Year 2 | £1,250,000 | £312,500 | -£19,032 | -£19,032 | -4.3% |
| Year 3 | £1,250,000 | £312,500 | -£27,318 | -£27,318 | -6.1% |
| Year 4 | £1,250,000 | £312,500 | -£34,764 | -£34,764 | -7.8% |
| Year 5 | £1,250,000 | £312,500 | -£41,350 | -£41,350 | -9.3% |
Modelled on the live asking price. Capital growth 0.00% a year is the BA11 area's 5-year historical rate (Land Registry medians), not a forecast. Rent grows 2% a year (assumed); management is 10% of each year's rent. Mortgage held interest-only at 5.25% for 5 years. Refurbishment, voids and letting fees are not costed. ROI is on cash required (£445,850).
Price Forecast
No forecast available.
Demand & Supply
DemandSupply
Comparable Sales
CEDAR BARN
Recent sale
£765k
Sale price
£/sqft
-
Rent pcm
-
Yield
-
51
Recent sale
£435k
Sale price
£/sqft
-
Rent pcm
-
Yield
-
HOLLY COTTAGE
Recent sale
£773k
Sale price
£/sqft
-
Rent pcm
-
Yield
-
Area Economic Intelligence
Signal
£29,908
Median earnings (local authority)
Signal
2,321
Population
Signal
2.0%
Households Deprived