SQL = select memberid,businessname,address,town,county,country,postcode,tel, starrating,CONCAT("http://www.enjoyablestay.com/images/memberimages/",image),description from members where status<>4 and county="Staffordshire" and country="England" and businessname like "%"

Bullīs Head, Alton, Alton Towers

Bullīs Head
Three Stars
High St Alton Staffordshire England ST10 4AQ 01538 702307
This popular old village inn is ideally situated for visitors to Alton Towers. It provides well equipped modern accommodation and has public areas of some character. The traditional bar has an inglenook fireplace, and the separate dining room is attractively decorated.

Granary & Loft, Leek, Alton Towers

Granary & Loft
Four Stars
Heaton House Farm, Rushton Leek Staffordshire England SK11 0RD
Set in scenic Staffordshire Moorlands, Heaton House Farm is situated between Leek and Macclesfield, just off the A523 at Rushton Spencer.

List your property