select [type] from [customtable_price_data] where NodeID='20624' order by january;select [January],[Feburary],[March],[April],[May],[June],[July],[August],[September],[October],[November],[December] from [customtable_price_data] where NodeID='20624' order by january;
*average daily rates based on 7 day rental, search for todays best prices.
Useful things to know about North Cheam
- Cheam is a large village located just inside the Greater London area
- It’s divided into North Cheam and Cheam
- Cheam was part of the ancient Saxon region called the Wallington Hundred
- Its Saxon name was Ceiham and as such it appears in the Domesday Book
- It grew on the popularity of the pottery that was made there
North Cheam Mini Guide
What can you Tell me About Cheam?
North Cheam is a rather upmarket, large village just inside the Greater London area. Mainly a residential area, it has a number of shops in a small retail street and many places of interest to tourists who want to be able to visit London but not have to stay there.
How Easy is it to get to North Cheam?
North Cheam is within easy reach of both main London airports; Gatwick and Heathrow. Heathrow is best accessed by using the London Underground whilst Gatwick travellers can use the Gatwick Express on the
London Victoria line. Almost anywhere in the world connects to Heathrow and Gatwick so getting to North Cheam is reasonably easy. You can
rent a car at Heathrow or Gatwick Airport and make your way to North Cheam or take the tube and collect a rental car when you arrive.
What Should I see and do in North Cheam?
You’re well placed for the sights of south London including Kew, Richmond Park, the London Eye and more, whilst in Cheam itself you have the beautiful Nonsuch Park Mansion. In the park you’ll see the ruins of the former Nonsuch Palace built by Henry VIII but destroyed in 1683. Popular with weddings, only the service wing is generally open to the public but it’s a fascinating piece of Gothic revival architecture. From the same period is the building known as the Old Rectory which is a Tudor timber framed house. Not usually open to the public, it has regular open days – you simply need to look out locally for details. For a building that is more readily accessible, try Whitehall, in the village, a wattle and daub building now occupied by a museum dedicated to how it would have been furnished in the 18th century.
Latest Update from North Cheam:
03/03/13 - It might be a little soon but North Cheam is celebrating its Easter Fair in the grounds of Whitehall on the 16th March. There will be lots for children to do so why not make it a family day out!