SELECT * FROM tblprovider p, tblaccommodationtype a, tblestfacilities f, tblestratings r, tblpricerange pr WHERE p.SouthShropWeb = 1 and p.DisplayShrop = 1 and p.AccommID = a.ID and p.EstID = f.EstID and p.EstID = r.EstID and p.EstID = pr.EstID and (a.ID < 21 or a.ID > 30) and (r.CyclistsWelcome = 1 or r.VWCyclistsWelcome = 1) group by p.EstID
The Dragon Hotel![]() ![]() ![]() ![]()
Prices: From: £51.00 - To: £120.00 Description: The Dragon Hotel is a 17th Century family run coaching Inn in the lee of the ruins of Montgomery Castle. Phone: 01686 668359 Email: reception@dragonhotel.com The Squire Farm Holiday Cottages![]() ![]() ![]()
Prices: From: £270.00 - To: £550.00 Description: The Squire Farm is an idyllic smallholding in the secluded, peacefúl surroundings of Red lake Valley in the southwest comer of Shropshire. Phone: 01547 530530 Email: becky@squirefarm.co.uk Victoria House![]() ![]() ![]()
Prices: From: £55.00 - To: £75.00 Description: Victorian town house in centre of Church Stretton with beautifully furnished rooms containing antiques and quality finishing touches. Phone: 01694 723823 Email: victoriahouse@fsmail.net Orchard House![]() ![]() ![]()
Prices: From: £45.00 - To: £78.00 Description: Orchard House luxury bed & breakfast is set in a cosy 300 year old converted barn in a pretty hamlet, 5 minutes from the centre of Ludlow. Judith & Noel Eyres offer warm personal service, excellent accommodation and delicious breakfasts. Phone: 01584 831270 Email: judith@orchard-barn.co.uk Middle Woodbatch Farm![]() ![]() ![]()
Prices: From: £60.00 Description: Middle Woodbatch farm is a small family run livestock farm, that dates back to the 1700's. It is located 1 1/2 miles from the small market town of Bishop's Castle, in a designated Area of Outstanding Natural Beauty. Phone: 01588 630141 Ashley Moor Farm Holiday Cottages![]() ![]() ![]()
Prices: From: £170.00 - To: £700.00 Description: Two Shropshire/Herefordshire border cottages with National Trust and Mortimer Trail on doorstep. Wainhouse sleeps six/eight. The Cottage sleeps two. Phone: 01568 780266 Email: ashleymoorfarm@btconnect.com Pooh Hall Cottages![]() ![]() ![]()
Prices: From: £280.00 - To: £475.00 Description: Three beautiful stone cottages each with their own characters. Phone: 01588 640075 Email: pooh-hall@dsl.pipex.com Elm Lodge Self Catering![]() ![]() ![]()
Prices: From: £320.00 - To: £420.00 Description: Elm Lodge/Coach House Apartments. One mile town centre. Ample on-site parking. Nine hole golf course on site. Brochure available. Short Breaks. Phone: 01584 872308 Email: info@elm-lodge.org.uk Westhope Country Retreats![]() ![]() ![]()
Prices: From: £275.00 - To: £715.00 Description: 4 Prestigious barn conversions, decorated and furnished to a very high standard, set in a lovely courtyard in the beautiful Hope Valley. GOLD AWARD 2009/2010 Phone: 01584 861617 Email: jonnbett@tiscali.co.uk Jessamine Cottage![]() ![]() ![]()
Prices: From: £242.00 - To: £415.00 Description: Jessamine Cottage is nestled in the small village of Little Stretton and is ideally placed to explore the Long Mynd and to take in the breathtaking scenery. Phone: 01743 873608 Email: info@strettoncottages.co.uk |
||
Website Maintained by: Shropshire Tourism
|