DB Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND areas.stateID =
AND areas.areaID = 112' at line 10
Venice, Italy Located in Mira (About 15km from Venice) at a key point on the route between the nearby cities of Padua and Venice, the hotel overlooks the Brenta Riviera Canal, renowned for the richness of its artistic and architectural treasures, and for the famous palladian villas in the area. The 'Riviera dei dogi' has 43 rooms, each with air conditioning, minibar, colour T.V, telephone with direct dialing and en-suite bathroom with shower. The hotel's bar, private car park and attractive breakfast room add the finishing touches to its features, making it an ideal place for a pleasant, quiet stay for tourism or business purposes in a homely and comfortable atmosphere. From recently discovered historical records, it has been established that the hotel dates back to 1537. Initially planned as a weekend retreat for Contarini aristocratic family, around the middle of the seventeenth century it was used as an inn, and retained this function until the end of the 19th century. It was during these years that the Hotel first started its activity, initially under the name ?Hotel Cima?. It was the first hotel on the Riviera del Brenta to offer a series of innovations which were to make it famous, even amongst the Venetian aristocracy, and it flourished until the end of the Second World War. Following the war, after a long period of neglect, conservative, expert restoration brought the building back to its original splendour, making the 'Riviera Dei Dogi' a hotel of unique style. Transportation to airport upon request extra charge. Breakfast is not included in the room rates. (if you want you can take it at 6.00 ? per person and pay at check-out)