select [type] from [customtable_price_data] where NodeID='20557' order by january;select [January],[Feburary],[March],[April],[May],[June],[July],[August],[September],[October],[November],[December] from [customtable_price_data] where NodeID='20557' order by january;
*average daily rates based on 7 day rental, search for todays best prices.
Useful things to know about Harrogate
- Harrogate, properly called Harrogate Spa, grew from the merging of two towns, High and Low Harrogate in the 17th century
- The spring waters that rise in the town are rich in iron and sulphur
- Many of Harrogate’s finest buildings date from Georgian times when the spa brought the rich and famous to the town
- The town is a great base for exploring the Yorkshire Dales National Park
- The 2012 Olympic cauldron was built in Harrogate
A Mini Guide to Harrogate
Why Should I Travel To Harrogate?
The town is known for its genteel air, its beautiful public gardens and its healing springs. If you get bored of town life, all you need do is to step into your Harrogate hire car and head for the Yorkshire Dales where you can get away from it all in some of England’s most beautiful countryside. Enjoy a cream tea in Harrogate in one of the many old hotels or at Betty’s Tearooms and you’ll be transported back to a bygone age.
How Easy is it to get to Harrogate?
If you’re flying in then
car hire from Leeds Bradford Airport is only ten miles away, a journey that’ll take you around twenty minutes. You can hire a car there or, if it’s more convenient, wait until you get to Harrogate. There are many international flights to Leeds/Bradford, mostly from Europe but with one from Pakistan. If you’re travelling in from elsewhere, fly to
Heathrow first and get a connection with BA.
What is There to do in Harrogate?
There’s not a lot for the adventurous unless you head out of town and into the Yorkshire Dales. The attractions of Harrogate include taking tea at the Queen’s favourite tearooms; Betty’s, or taking a leisurely stroll through the town’s public gardens which have won ‘Britain in Bloom’ several times. There’s an important RHS garden at Harlow Carr as well as Harrogate’s pride and joy, Valley Gardens, just a little outside the town. Getting to the Dales is easy and there you’ll be able to hike, climb, abseil, kayak and more in fabulous scenery.
Latest Update from Harrogate:
25/02/13 - At nearby Skipton, they're well into their music concert season with the fifth concert of eight coming up later this week. If you're in Harrogate over the next few weeks check out Skipton Town Hall for more details.