WESTHILL
Recent sale
£590k
Sale price
£/sqft
-
Rent pcm
-
Yield
-
Moon Cottage, Top Lane, Mells, Frome, BA11 3QN
UPRN:250043615Detached House3 bedsBuilt -
FreeholdCouncil Tax: Band EEPC: -
Data freshness:Listing· freshListing: fresh, refreshed yesterday (2026-10-23T04:00:04.135672+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
£619,000
Estimated value
Range: £557k - £681k|Last sold: -- (-)
Estimate of £619k for this detached house. 431 sales in BA11 in the last 12 months; median £320k.
Estimate confidence
Medium confidence
Value History
Current estimate
£619k
£557k - £681k - Medium confidence
Annualised (CAGR)
+3.04%
Over the full window
Peak estimate
£806k
Feb 2024
From peak
-23.20%
Drawdown from peak
AVM estimate (model)Repeat-sales index - BA11 district (quarterly)index YoY +3.04%
Growth by window
3m
-5.64%
6m
-3.28%
12m
-2.83%
24m
-4.03%
60m
+8.22%
Rental Market
Estimated rent (pcm)
£2,300
/ month
Gross yield
3.07%
Rent ÷ asking price
Net yield
1.43%
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
-
-
Investment Analysis
Buy-to-let cashflow + capital returns
Purchase
- Asking Price£900,000
- SDLT standard£35,000
- SDLT BTL surcharge (5%)£45,000
- Legal, survey + broker (assumed)£2,100
- RefurbishmentNot costed
- Total Cost (excl. refurb)£982,100
Funding
- Deposit (25%)£225,000
- Mortgage (75% LTV)£675,000
- Interest Rate (assumed)5.25%
- Mortgage TypeInterest Only
- Cash Required£307,100
Monthly Returns
- Monthly Rent (estimate)£2,300
- Mortgage Payment (IO)-£2,953
- Management (10%)-£230
- Insurance (assumed)-£40
- Maintenance (assumed)-£60
- Monthly Cashflow-£983
Capital Returns
- 5yr Property Value£900,000
- 5yr Capital Gain (0.00% pa, historical)+£0
- 5yr Cumulative Rent (net)+£123,268
- Less mortgage interest-£177,180
- 5yr Total Return-£53,912
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 | £900,000 | £225,000 | -£11,796 | -£11,796 | -3.8% |
| Year 2 | £900,000 | £225,000 | -£23,100 | -£23,100 | -7.5% |
| Year 3 | £900,000 | £225,000 | -£33,889 | -£33,889 | -11.0% |
| Year 4 | £900,000 | £225,000 | -£44,164 | -£44,164 | -14.4% |
| Year 5 | £900,000 | £225,000 | -£53,912 | -£53,912 | -17.6% |
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 (£307,100).
Price Forecast
No forecast available.
Demand & Supply
DemandSupply
Comparable Sales
KAVISA HOUSE
Recent sale
£915k
Sale price
£/sqft
-
Rent pcm
-
Yield
-
BROOK COTTAGE
Recent sale
£710k
Sale price
£/sqft
-
Rent pcm
-
Yield
-
SPRINGFIELD
Recent sale
£650k
Sale price
£/sqft
-
Rent pcm
-
Yield
-
Area Economic Intelligence
Signal
£29,908
Median earnings (local authority)
Signal
2,364
Population
Signal
2.0%
Households Deprived