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 = 195' at line 10
Ischia, Italy SEASONAL HOTEL (OPEN FROM THE BEGINNING OF APRIL TO THE END OF OCTOBER). The Mezzatorre Resort & Spa is an exclusive hotel with 59 rooms and 7 suites facing the see and greenery. The main building is an ancient tower of the XVI century, put up against invaders and restored with its original arched, gothic windows; other buildings are scattered among the pines and oaks encircling the tower where you can enjoy the unique view of the sea and coast. A thermal department with a modern health & beauty center complete the facilities of this splendid hotel which represents the ideal place for a relaxing vacation.