SELECT pubname,street,village,locality,town,county,postcode,tel_no,url,lat,lon, (3959 * acos(cos(radians(53.45)) * cos(radians(lat)) * cos(radians(lon) - radians(-2.54)) + sin(radians(53.45)) * sin(radians(lat)))) AS distance FROM visitr.data_pubs WHERE (lat BETWEEN '53.03' AND '53.87' AND lon BETWEEN '-3.03' AND '-2.05') GROUP BY postcode HAVING distance<=5 ORDER BY distance ASC LIMIT 0,60
0.8MILES

The Cherry Tree

Address: 35 Common Lane, Culcheth, Warrington, WA3 4EX

0.8MILES

The New Inn

Address: 474 Warrington Road, Culcheth, Warrington, WA3 5QX

0.9MILES

The General Elliot

Address: 51 Lord Street, Croft, Warrington, WA3 7DE

1.1MILES

Horseshoe Inn

Address: Smithy Lane, Croft, Warrington, WA3 7HQ

1.2MILES

Pack Horse Inn

Address: Church Lane, Culcheth, Warrington, WA3 5ET

1.7MILES

The Red Lion Hotel

Address: Newton Road, Lowton, Warrington, WA3 1HE

1.7MILES

The Toby Carvery

Address: 322 Newton Road, Lowton, Warrington, WA3 1HD

1.8MILES

The Shepherd Inn

Address: 9 Newton Road, Lowton, Warrington, WA3 1EH

1.9MILES

Church Inn

Address: Newton Road, Lowton, Warrington, WA3 1DG

1.9MILES

Turf & Feather

Address: Glover Road, Birchwood, Warrington, WA3 7PH

2.1MILES

The Raven Inn The Raven Inn

Address: Warrington Road, Glazebury, Warrington, WA3 5LA

2.1MILES

The Robin Hood

Address: St. Helens Road, Leigh, WN7 3PA

2.1MILES

The Poacher

Address: 40 Gorse Covert Road, Birchwood, Warrington, WA3 6UG

2.1MILES

The Travellers Rest

Address: 443 Newton Road, Lowton, Warrington, WA3 1NZ

2.2MILES

The George & Dragon

Address: Warrington Road, Glazebury, Warrington, WA3 5LF

2.3MILES

The Plough

Address: Mill Lane, Houghton Green, Warrington, WA2 0SU

2.3MILES

Chat Moss Hotel

Address: Warrington Road, Glazebury, Warrington, WA3 5LL

2.3MILES

Neil Rossington The Grey Horse Inn

Address: Warrington Road, Glazebury, Warrington, WA3 5LZ

2.3MILES

Hermit Inn

Address: Golborne Road, Winwick, Warrington, WA2 8SN

2.4MILES

Nelsons Quarterdeck

Address: Admirals Road, Birchwood, Warrington, WA3 6QG


2.4MILES

The Millhouse

Address: Ballater Drive, Warrington, WA2 0LX

2.4MILES

The Rams Head

Address: 248 Slag Lane, Lowton, Warrington, WA3 2ED

2.5MILES

Stonecross Brewers Fayre & Travel Inn

Address: Yew Tree Way, Golborne, Warrington, WA3 3JD

2.5MILES

Bulls Head

Address: Southworth Road, Newton-le-Willows, WA12 0JE

2.5MILES

The Horse Shoe Inn

Address: Ilex Avenue, Winwick, Warrington, WA2 8LP

2.5MILES

Comfortable Gill Inn

Address: 458 Warrington Road, Leigh End, Glazebury, Warrington, WA3 5NX

2.5MILES

The Hare & Hounds

Address: 1 Golborne Road, Lowton, Warrington, WA3 2DP

2.7MILES

The Swan Tavern & Premier Lodge

Address: Golborne Road, Winwick, Warrington, WA2 8LF

2.7MILES

The Horns Inn

Address: 124 Lowton Road, Golborne, Warrington, WA3 3HU

2.8MILES

Jolly Falstaff

Address: Blackbrook Square, Padgate, Warrington, WA2 0SP

2.8MILES

Queen Anne

Address: Bridge Street, Golborne, Warrington, WA3 3PZ

2.9MILES

Smithy's

Address: Harpers Road, Padgate, Warrington, WA2 0PB

2.9MILES

Bridgewater Arms

Address: 33 St. Helens Road, Leigh, WN7 4HA

3MILES

The Sir Charles Napier

Address: 69 High Street, Golborne, Warrington, WA3 3AH

3MILES

The Ellesmere

Address: 20 St Helens Road, Leigh, WN7 4HW

3MILES

Railway Hotel

Address: High Street, Golborne, Warrington, WA3 3TG

3MILES

The Millstone

Address: 71 Mill Lane, Newton-le-Willows, WA12 8BG

3MILES

Rowlands Bar

Address: Church Street, Golborne, Warrington, WA3 3TL

3MILES

Legh Arms Hotel

Address: Mill Lane, Newton-le-Willows, WA12 9SF

3.1MILES

The Pennington

Address: Henry Street, Leigh, WN7 3HA

3.1MILES

Stocks Hotel

Address: Station Rd South, Padgate, Warrington, WA2 0QS

3.1MILES

Nevison

Address: 96b Plank Lane, Leigh, WN7 4QE

3.1MILES

Toffs

Address: West Bridgewater Street, Leigh, WN7 4HB

3.1MILES

Sams Bar

Address: 52 Church Street, Golborne, Warrington, WA3 3TW

3.1MILES

Spa Brook Hotel

Address: Howson Road, Warrington, WA2 9UB

3.2MILES

Waterside Inn

Address: Canal Street, Leigh, WN7 4DB

3.2MILES

Blue Bell Hotel

Address: 6-8 High Street, Newton-le-Willows, WA12 9SN

3.2MILES

The Moonraker

Address: 77 King Street, Leigh, WN7 4LJ

3.2MILES

Millstone Inn

Address: 52 Harvey Lane, Golborne, Warrington, WA3 3RS

3.2MILES

The Red Brick Inn

Address: Twist Lane, Leigh, WN7 4DP

3.3MILES

The Railway Hotel

Address: 160 Twist Lane, Leigh, WN7 4ED

3.3MILES

The New Inn

Address: 239 Firs Lane, Leigh, WN7 4TJ

3.3MILES

Cafe Stella

Address: 38 King Street, Leigh, WN7 4LR

3.3MILES

John Tunstall Fir Tree Inn

Address: Firs Lane, Leigh, WN7 4TT

3.3MILES

The Bottle & Basket

Address: Thirlmere Street, Leigh, WN7 4DX

3.3MILES

Blue Bell Hotel

Address: High Street, Newton-Le-Willows, WA12 9SL

3.3MILES

Sportsman

Address: 1 Firs Lane, Leigh, WN7 4SA

3.3MILES

Spinners Arms

Address: 70-72 Firs Lane, Leigh, WN7 4SB

3.4MILES

Eagle & Hawk

Address: Chapel Street, Leigh, WN7 2PQ

3.4MILES

Globe Inn

Address: 81-85 Bradshawgate, Leigh, WN7 4ND

From the Postcode Area blog

Discrimination by Postcode

Discrimination by Postcode

You really couldn't make it up, could you? Some of the country's most vulnerable people are missing out on their weekly £25 Cold Weather Payment, just because the system that's in operation is discriminating against them because payments are based on postcode, rather than geographic location.

Read more

The Redesign is Underway

The Redesign is Underway

Well, the current website was absolutely in dire need of a good redesign - from the ground up. So I set out to pull it all apart and get it up and running again to become the most comprehensive guide to every postcode in the UK. And it's been a long, tough job from start to finish - and quite possibly the biggest project I've ever undertaken.

Read more

The Impossible Challenge of Affordability

The Impossible Challenge of Affordability

No wonder the younger generation are getting more and more frustrated with money - new research has revealed that even with a 10% deposit, 25-34 year olds are struggling to afford even the CHEAPEST houses on the market. Is there a solution to the 'impossible challenge'?

Read more