select [type] from [customtable_price_data] where NodeID='20548' order by january;select [January],[Feburary],[March],[April],[May],[June],[July],[August],[September],[October],[November],[December] from [customtable_price_data] where NodeID='20548' order by january;
*average daily rates based on 7 day rental, search for todays best prices.
Useful things to know about Playa Del Carmen
- Playa del Carmen grew from being a ferry port to the island of Cozumel
- It was formerly a sleepy fishing village until the introduction of the ferry
- The city is the major conurbation along the tourist strip known as the Riviera Maya
- Playa del Carmen is blessed with beautiful white sandy beaches
- 150,000 people live in the city
Playa Del Carmen Mini Guide
How do I get to Playa del Carmen?
It’s very easy to get to Playa del Carmen from Europe and North America. Most of the big tour operators in the
UK have direct flights from
London and regional airports including
East Midlands, Glasgow and
Newcastle. The journey from the airport to the city is around twenty minutes and there are plenty of hire cars available at the airport if you don’t have a resort transfer booked.
What can I do in Playa del Carmen?
The easy answer to that is shop! The city has its own ‘Fifth Avenue’ called Quinta Avenida and the authorities have done their utmost to make sure the Mexican version is as populated as the New York one. You’ll find all the top designer names as well as the Apple Store and top restaurant chains. Many of them are there specifically to cater for the cruise ship guests but as you’re there you might as well take advantage. The other key attraction of the city is the beach. It’s absolutely perfect and dazzlingly white with attractive little beach bars and water sports. The sea can be a bit rough for little ones on times but there’s plenty for them to do.
Finally, if you have a hire car, why not explore a little of the Yucatan? You’ll be able to visit Xcaret, the semi-authentic nature and archaeological park on the Riviera Maya and do an underwater walk to see the marine life – no scuba skills required either! Inland there’s the world famous Chichen Itza with its step pyramids amidst the jungle.