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-04-22:2028-04-22' 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 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.
Admiral Park Hotel, an elegant 4-star S hotel surrounded by 250,000 m2 of parkland, is ideal for organizing team building activities and outdoor events. It is located a few minutes from Bologna airport and the main motorway junctions with ample parking available. The Hotel has 120 spacious and bright rooms of different types. The conference center offers 11 modular rooms: the main room has a maximum capacity of 300 people. The Tulipano restaurant can accommodate up to 250 people. A delightful panoramic swimming pool, a fitness space and a relaxation area complete the offer.
Exclusive environments, modular solutions and tailor-made services transform your event into the perfect working day for an emotional corporate meeting experience in the heart of Cesenatico and directly on the sea.
