The Bee Hive Coach House, Main Street, Farnsfield, Newark, NG22 8EF

UPRN:10090267406Detached House2 bedsBuilt 2007-2011

FreeholdCouncil Tax: Band CEPC: C (74)

Data freshness:Listing· freshOwnership· freshEPC· 6mo agoRisk· 5mo agoConnectivity· 1mo agoSchools· 1mo agoAmenities· 2mo agoArea· Census 2021Council Tax· 1mo ago

The Bee Hive Coach House, Main Street, Farnsfield, Newark, NG22 8EF

HP Score

/ 100

Mixed

Verdict

today

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

Evidence

20 of 21 sources

Sale Estimate

£369,000

£350k - £387kHigh

Estimate

£369k

Range

£350k – £387k

Rent Estimate (pcm)

£1,650

£2k - £2k

Monthly

£1,650

Yield

5.28%

Verdict

Derived from HomePortfolio scores

The Bee Hive Coach House earns an INVESTIGATE rating with HP Score 71/100. Investment score 59/100 reflects moderate fundamentals. Crime intensity is very low. Walkability is limited (47/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 company ownershipHM Land Registry covenantsHM Land Registry leasesHM Land Registry Price PaidPlanIt / council planning portalsOverture Maps PlacesOfsted / DfE GIAS

HP Score

71/ 100

Mixed

Investment Score

59/ 100

Moderate

Crime Score

13/ 100

Low

Walkability

47/ 100

Mixed

Transit & Bike

Transit 10Bike 24

Walk Score, out of 100

Opportunity

Not scored as an opportunity

We will not put a number on this one.

listing is 'Sold subject to contract' - sale already progressing, not an actionable opportunity

Withholding a score is deliberate. A number built on missing or stale inputs would look more certain than the evidence allows.

Economics

What happens to your money

Your assumptions

Purchase price£375,000

At the asking price

Monthly rent£1,650/mo

Evidenced range £1,500-£1,800

Interest rate5.4%

Loan to value75%

Cash required: £122,550
Net cash flow: -£123/mo
Cash on cash: -1.2%
Score at this price: -

After a 8% void allowance, 15% management and 10% maintenance. Lender coverage (rent ÷ interest): 1.30 - clears the usual 1.25 test. These are your assumptions, not evidence: only the pre-filled rent and price come from the record.

Risks

What could kill this deal

Score confidence is low
largely a single source - treat the number as a prompt, not a conclusion

Property risk deep-dive →flood, subsidence, crime, environment - the full domain

Plan

Before you offer

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

Rent Estimate (pcm)£1,650

Gross Yield5.28%

1y Growth-

3y Growth-0.8%

5y Growth+1.8%

10y Growth+4.1%

Last Sold Price£212,500 (2017-06-23)

View Market Details

Risk Overview

Flood RiskUnknown
SubsidenceLow
RadonLow
MiningUnknown
LandslideModerate
Air QualityLow
NoiseLow

View Full Risk Report

Planning Activity

Recent Apps

5NG22 8EF

Approval Rate

100%12mo

Development

low

26/01754/TWCA
T1 Sweet Chestnut ? Crown Reduction Overall crown reduction of the sweet chestnut by approximately 2?3 metres, as indicated in the attached photograph, to reduce the overall size and spread of the crown whilst retaining the tree?s natural shape and form. All pruning to be carried out in accordance with good arboricultural practice, retaining a balanced crown and healthy growth.
Pending
26/01697/LDCP
Certificate of Lawfulness for proposed first floor dormer extension on side (LHS)
Pending
26/01680/TWCA
T1 - Weeping Silver Birch - Full sympatheic crown reduction, prune back from house to create 1m clearance. Use this as a starting point and match in the rest of the crown, ideally keeping the same characteristics of the tree but just reduced. Thin out bits on the front and the garden side and rim to be 2.5m lift
Pending

View Planning Timeline

Ownership

Corporate Ownership61.4%
Overseas OwnershipNo
Lease Term Remaining-
CovenantsRestrictive
Lease TypeFreehold
Last Ownership Change2017-06-23
SourceLand Registry

View Ownership Details

Connectivity

Broadband (Standard)

18 Mbps

Mobile 4G/5G Coverage

EEThreeO2Vodafone

EV Charger

PTAL Rating

View Connectivity Map

Area Profile

Median EarningsLocal authority£29,806

Population Density-

Owner Occupied87%

Age Distribution

0-15 17%16-64 51%65+ 32%

View Area Profile

Schools Nearby

Farnsfield St Michael's Church of England Primary School
0.2 mi
Good
Kirklington Primary School
1.9 mi
Inspected as Kirklington Primary School (URN 122653) on 31 Jan 2023
Halam Church of England Primary School
2.4 mi
Good
Dukes Wood School
2.4 mi
Good

3 of 12 nearby schools with published figures were oversubscribed in 2026 - demand, not a catchment.

View All Schools

Comparables

View All

White Cottage Main Street
-
£295k
-
Rose Cottage Main Street
-
£430k
-
54 Main Street
-
£198k
-
Lollipop Cottage, 49 Main Street
-
£264k
-

Boundary data not available for this property

No registered title polygon, building footprint, or street match for this property yet.

Why: No HMLR INSPIRE / OSM footprint / OS Open USRN match for this UPRN

Source: HM Land Registry INSPIRE / OpenStreetMap / OS Open USRN