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 ASC
LIMIT 90, 9
Hotel P.za Ventiquattro Maggio, 8 - 20123 - Milano (MI)
4 Meeting rooms
15 - 150 People
32 Rooms
From €
Aethos is a new concept of modern club, rooted in hospitality, with dynamic spaces and a global network designed to promote connection, creativity and belonging.
Hotel business Via Briantea, 5 - 24129 - Bergamo (BG)
4 Meeting rooms
10 - 313 People
126 Rooms
From €
Life Source is an innovative hospitality center that, all in one location, offers high-tech Meeting Rooms, High-Level Food Experience , a 4*S Hotel and a private clinic.
Space for events Via Giovanni Bovio 6 - 20159 - Milano (MI)
4 Meeting rooms
5 - 150 People
From €
Dynamo Camp spaces available for events with strong social significance. Beauty, inclusivity, storytelling, and meaning. Three meeting rooms, a theater, and a café in Milan.
Space for events Via Ancona, 11/A - 10152 - Torino (TO)
4 Meeting rooms
25 - 1095 People
From €
La Centrale, located in the Nuvola Lavazza complex, is an impressive space created within the former power plant in the Aurora neighborhood. The architectural renovation project preserved and enhanced the original 1897 structure, maintaining its majestic industrial architecture intact, enhanced by the large wrought-iron windows overlooking the city. Today, it is a symbol of Turin's cultural dynamism and houses: The Space, the Indoor Terrace, the Conference Rooms, the Foyer, and the Grand Foyer. Over the years, La Centrale has hosted national and international events: conventions, meetings, trade fairs, exhibitions, concerts, product launches, press conferences, and private events.
Hospitality and venue for events and meetings on the beachfront in Riccione city-center, up to 200 guests. A unique contact for hospitality, catering and dedicated event services.
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.
Il Grand Hotel Des Bains è un hotel 5 stelle storico e in stile liberty sito nel centro città a 100 m dal mare. Ideale per soggiorni esclusivi, eventi aziendali e matrimoni.
The Radisson Blu GHR Rome was born from the merger of two iconic hotels - the Grand Hotel Ritz and the Hotel Regent - completely renovating 280 rooms - in 6 different types - 3 restaurants, the conference center with 5 meeting rooms, the private gym, and the common areas.
The Poiano Resort Congress Centre, surrounded by the greenery of Lake Garda, offers 5 conference rooms for up to 250 people, ideal for corporate events and meetings.
