SELECT SQL_CALC_FOUND_ROWS wp_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM wp_postmeta price_meta2 WHERE price_meta2.post_id=wpml_translations_default.element_id AND price_meta2.meta_key='_accommodation_min_price:2026-10-17:2028-10-17' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM wp_postmeta price_meta3 WHERE price_meta3.post_id=wpml_translations_default.element_id AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM wp_posts JOIN wp_icl_translations wpml_translations
ON wp_posts.ID = wpml_translations.element_id
AND wpml_translations.element_type = CONCAT('post_', wp_posts.post_type) LEFT JOIN wp_icl_translations wpml_translations_default ON wpml_translations_default.trid = wpml_translations.trid AND (wpml_translations_default.source_language_code IS NULL OR wpml_translations.source_language_code IS NULL)
WHERE 1=1 AND wp_posts.post_type = 'accommodation' AND ((wp_posts.post_status = 'publish')) AND ( ( ( wpml_translations.language_code = 'en' OR 0 ) AND wp_posts.post_type IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','location','accommodation','tour','acf-field-group','wpcf7_contact_form','mec-events','mec_calendars','mc4wp-form','popup' ) ) OR wp_posts.post_type NOT IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','location','accommodation','tour','acf-field-group','wpcf7_contact_form','mec-events','mec_calendars','mc4wp-form','popup' ) )
GROUP BY wp_posts.ID HAVING 1=1
ORDER BY wp_posts.post_title ASC
LIMIT 81, 9
Hotel Lungarno del Tempio 44 - 50121 - Firenze (FI)
13 Meeting rooms
10 - 300 People
327 Rooms
From €
FH55 Grand Hotel Mediterraneo, located along the Arno River in Florence and just a short walk from Santa Croce and the city’s main landmarks, is perfectly suited for both leisure and business stays.
L’FH55 Grand Hotel Palatino è la scelta migliore per un evento all’insegna del comfort e della tranquillità nel cuore di Roma. Posizione straordinaria: a pochi passi dal Colosseo e dal Foro Romano.
Located in the heart of Florence, FH55 Hotel Calzaiuoli takes its name from the street it overlooks, between the Duomo and Palazzo Vecchio, a few steps from Ponte Vecchio. The hotel creates a mix of style, optimal location and comfort, to savor the liveliness of the contemporary city among the greatest works of art of the Renaissance and the center of high fashion shopping.
Fidenza Village interpreta una nuova filosofia di shopping e ospitalità, capace di coniugare le espressioni più raffinate della moda e del turismo, a soli 60 minuti da Milano e Bologna, nel cuore della Food Valley.
Fioraio Bianchi Caffè is an unprecedented location where private and corporate events can be held in a cozy and convivial atmosphere, adaptable to different needs
A unique location overlooking the Grand Canal, Palazzo Barocci stands out like a unique gem among the city's narrow streets and alleys.
Palazzo 4 Fontane 12
In the enchanting setting of Rome's historic center, Palazzo 4 Fontane 12 welcomes you to an exceptional location, surrounded by the wonders of the Eternal City.
Palazzo Montebello
Among the villas and courtyards of Florence's city center stands Palazzo Montebello, a building where different eras and architectural structures meet.
Chalgrin Boutique Hotel Paris
A boutique hotel in perfect Haussmannian style where you can experience the true Parisian atmosphere by starting your journey in one of our welcoming 50 rooms.
Resort Viale delle terme 84, 35030 Galzignano Terme (Padova)
8 Meeting rooms
33 - 658 People
239 Rooms
From €
Galzignano Resort Terme & Golf, an extraordinary structure immersed in nature and made up of three 4-star hotels with one of the largest Thermal Centers in Europe and natural 37° waters, the Galzignano Wellness integrated medicine centre, wellness center and spa, a 9-hole golf course, haute cuisine and all the comforts necessary for a ""thousand and one nights"" stay.
Resort Località San Vigilio, 1 - 25010 - Pozzolengo (BS)
5 Meeting rooms
5 - 300 People
150 Rooms
From €
Crossing the entrance of Garda Hotel San Vigilio Golf you immerse yourself in a reality where modernity, efficiency and excellent standards of service blend with uncontaminated nature among rolling hills and rich vegetation.
