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 INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) 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_postmeta.meta_key = 'accommodation_sale_meeting'
) 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_postmeta.meta_value+0 DESC
LIMIT 18, 9
Hotel Largo J. F. Kennedy, 1 - 20873 - Cavenago di Brianza (MB)
15 Meeting rooms
10 - 500 People
138 Rooms
From €
Devero Hotel is the perfect location for business man who are looking for attention to detail, in a professional and relaxing environment, also Devero Hotel can be the right place for tourists and families.
Thanks to its strategic location 20 km from either Milan and Bergamo airports and a few km from the most beautiful lakes in northern Italy (Garda and Como).
Hotel business Via Aurelia Antica 415 - 10065 - Roma (RM)
13 Meeting rooms
30 - 600 People
307 Rooms
From €
Located a stone's throw from the Vatican, our hotel meets the needs of both business travelers, with its 13 meeting rooms and free wi-fi, and tourists.
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.
Completely renovated, immersed in the greenery of the EUR, 280 rooms, restaurant, bar, gym and more than 1800 m2 of conference center equipped with the latest technology.
Hotel business Porta d'Europa, 5 - 73100 - Lecce (LE)
13 Meeting rooms
6 - 800 People
273 Rooms
From €
Grand Hotel Tiziano & dei Congressi: MICE venue in Lecce with modular meeting rooms, advanced technology, and dedicated services for meetings, conferences, and corporate events.
Resort Isola delle Rose, Laguna di San Marco - 30133 - Venezia (VE)
12 Meeting rooms
1 - 380 People
266 Rooms
From €
Luxury resort on the exclusive Isola delle Rose, ideal for meetings and unforgettable events — just minutes from St. Mark’s, in the heart of the Venetian Lagoon.
Monrif Hotels is the Monrif Group's collection of 4-star hotels in the heart of Bologna.
Three elegant and strategically located properties offer quality hospitality for business and leisure travelers, with services dedicated to meetings, events, and comfortable stays.
Resort Via Ca' Masino 611/A - 40024 - Varignana (BO)
12 Meeting rooms
5 - 280 People
150 Rooms
From €
Nestled in the countryside just outside Bologna, Palazzo di Varignana Resort is the perfect venue for conferences, meetings, and team-building experiences.
