select [type] from [customtable_price_data] where NodeID='7924' order by january;select [January],[Feburary],[March],[April],[May],[June],[July],[August],[September],[October],[November],[December] from [customtable_price_data] where NodeID='7924' order by january;
*average daily rates based on 7 day rental, search for todays best prices.
Useful things to know about Twickenham
- Twickenham became a borough in 1925 and part of Greater London in 1965.
- It was originally called Tuiccanham, meaning ‘Tuiccan’s Village’.
- The first reference to it is in Saxon times when it was ceded to the Bishop of London.
- It was a major gunpowder producing area with ensuing major accidents causing loss of life in the 17th and 18th centuries.
- Reached by a small bridge is the quaintly named ‘Eel Pie Island’.
- Easily reached by tube from major rail stations in London like Kings Cross, Waterloo and Victoria.
Twickenham Mini Guide
Twickenham is a very old English settlement which has been inhabited right through the Neolithic, Bronze Age, Iron Age and Roman periods of history. Visitors who are interested in the past will find this a fascinating place to study with many old and beautiful buildings. Bizarrely enough a few of these buildings blew up in the 18th century as Twickenham was an English site for the manufacture of gunpowder.
Some of the main roads in Twickenham are very old too such as York Road and it is interesting to drive along these and get a feel for the place. Another way to get a good sense of Twickenham is to park your car and take a walk along the banks of the River Thames around which the suburb is situated.
By the Victorian era Twickenham had become a very fashionable district and even today it is an extremely desirable part of London to live in with high house prices. Many people choose to live in Twickenham (which almost feels like being a countryside city) and commute into central London. With its tree lined roads and a varied mix of original shops and cafes, it has an atmosphere all of its own.
Do go to a rugby match at Twickenham stadium if you get the chance, but otherwise avoid driving when the games are on due to heavy traffic.
Latest Update from Twickenham:
- Twickenham will host many of the games of the 2015 Rugby World Cup and already accommodation and car hire inthe borough are being snapped up. Don't miss out on yours if you're visiting Twickenham, book your hire car from our Richmond or Heathrow Airport offices.