select [type] from [customtable_price_data] where NodeID='7869' order by january;select [January],[Feburary],[March],[April],[May],[June],[July],[August],[September],[October],[November],[December] from [customtable_price_data] where NodeID='7869' order by january;
*average daily rates based on 7 day rental, search for todays best prices.
Useful things to know about Newcastle under Lyme
- Newcastle-Under-Lyme is part of The Potteries district of Staffordshire.
- The Lyme part of its name is thought to refer to Saxon Lime forests that used to grace the countryside there.
- The town received its royal charter in 1173.
- Its wealth was built on the hatting and pipe making industries.
- It’s part of an international organisation of towns called Newcastle.
Newcastle Under Lyme Mini Guide
Where is Newcastle-under-Lyme?
Newcastle-under-Lyme is a market town in Staffordshire, England, close to the city of Stoke-on-Trent
. It is in the ‘Potteries’ area of England, so named as in the last few centuries, the main industries were pottery and china. However, Newcastle-under-Lyme is best known for the manufacture of felt hats and clay smoking pipes.
How do I get There?
Driving is the best way to get to the town via the M6 and A500. Of course with a hire car you can explore much more of the local area than by public transport. There is no rail station in the town, although you can travel by train to nearby Stoke-on-Trent. There is a bus station in the town should you wish to explore the locality by bus.
What is There to do in the Town?
To discover more about the town’s history, see the life size Victorian street scene at Borough Museum and Art Gallery in Brampton Park. Then take a stroll in the award winning Queens Gardens. In the evening you can see a play or concert at the New Vic Theatre, one of few ‘theatres in the round’.
What’s the Shopping Like?
At Roebuck Shopping Centre you will find all your high street names and more. The best place for a bargain is The Stones Market on High Street, an open air market with over 80 stalls. It is held 6 days a week, but Tuesdays is for antiques and Thursdays for bric-a-brac.
Anything to see out of Town?
Spend a lazy Sunday afternoon at Slater’s Country Hotel in Maer, visit their craft village and have a traditional lunch with roast beef and vegetables at their village inn. You could also visit Biddulph Grange Gardens, a National Trust property, just outside of town. Further afield, you can venture to Alton Towers Theme Park or discover more about the ‘Potteries’ region by visiting the Wedgwood or Royal Doulton factories.
Where can I Stay?
Try the Ramada Hotel in Newcastle-under-Lyme. It is a modern 50 room hotel with free Wi-Fi and two restaurants offering Indian fusion and Mediterranean food. The hotel is ideally located to explore the Lyme Valley, with a hire car you can also visit Stoke-on-Trent and the Peak District.
Latest Update from Newcastle under Lyme:
- in four days time, join the town for the annual St George's Day celebrations in the main square where you'll see a re-enactment of the famous man v dragon battle.