select [type] from [customtable_price_data] where NodeID='7830' order by january;select [January],[Feburary],[March],[April],[May],[June],[July],[August],[September],[October],[November],[December] from [customtable_price_data] where NodeID='7830' order by january;
*average daily rates based on 7 day rental, search for todays best prices.
Edgware Road Mini Guide
So, Tell me About Edgware Road…
Edgware Road is in the west of the city of London. It starts at Marble Arch
in Westminster and ends in Edgware in Barnet, a distance of 14km. It was originally a Roman road, and is now the modern A5. Beyond Edgware the A5 follows the old Roman route and ends in Holyhead, Wales
. In London, the road’s name changes in some districts, although it is still known as Edgware Road in its entirety. Kilburn High Road, Shoot-up Hill and Cricklewood Broadway are all part of Edgware Road. Due to the road’s distinct character and Middle Eastern population, this area is known to locals as Little Beirut, Little Cyprus
and Little Cairo
How do I get There?
There are a number of underground stations and bus routes along the road, connecting the area with central London. The night bus 16 is the only service that runs the whole length of the road.
Anything to see There?
At the southern end of the road, you will find a tavern called ‘The Tyburn’, named after the tyburn tree which was where executions took place in the city. Three golden triangles mark the spot, where the tree was located. Just opposite the underground station at Edgware, there is a sculpture by Allan Sly, called ‘The Window Cleaner’.
A Shopping Paradise?
There are plenty of opportunities to shop along the road but for something different head for the famous Church Street Market.
To eat or not to eat?
The Edgware Road near Marble Arch
is well known for its Middle Eastern cuisine. There you can sample Syrian food at Abu Zaad or try Maroush Restaurant for a taste of Lebanon and to watch the belly dancing. If you want a late night bite, go to one of the many shawarma or kebab shops.
You can visit one of the late night bars or Arabic themed nightclubs or take in the exotic aromas in a shisha café. Films are often shown in Arabic at the Odeon Cinema, reflecting the local culture. If you are feeling lucky, take a chance at the Grosvenor London Victoria Casino.
- See an exhibition by one of the most enigmatic pop artists of the 20th century at A & D Gallery until the 13th April. Works by Roy Lichtenstein have millions of fans across the world and you can see many of them for the first time in this country.