Quick request

Environment

Because of the central location in the heart of Merano's villa district hotel Zima is a perfect starting point for walks into the old town with its beautiful little streets, promenades and the thermes of Merano. The botanical garden of castle Trauttmansdorff is located in 10 minutes walking distance. The Sissi promenade for example connects the historical part of Merano with castle Trauttmansdorff, where the Austrian queen Sissi lived when she was in Merano.

Share & Print:

The Weather

Errore nella query:

SELECT
	offerte.titolo_en as titolo, offerte.anteprima_testo_en as testo, offerte.immagine, offerte.permalink_en as permalink,
	strutturapagine.permalink_en as permalink_pagina , 
        validita_en as validita , prezzo_en as prezzo
	FROM offerte , strutturapagine
	WHERE offerte.attivo = 'on'
        AND offerte.titolo_en != ''
	AND strutturapagine.id = offerte.pagina
	ORDER BY offerte.ordine DESC LIMIT 8

Deadlock found when trying to get lock; try restarting transaction