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 = 192' at line 10
Ascona, Switzerland A small elegant hotel 10 minutes walking distance from town centre and lake, quietly located on the hill overlooking Ascona. It offers a magnificient view over Lake Maggiore, the Brissago Islands and the Ticinese Alps. All rooms are with balcony or terrace, bath/shower/WC, cable-TV, radio, minibar safe and direct-dial telephone. With its heated and covered swimmingpool, the whirl-pool, the solarium and sun terraces, the Michelangelo offers everything you need for a relaxing and enjoyable stay.