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 126, 9
Resort Via Salemi Km 7, 100 - 91026 - Mazara del Vallo (TP)
8 Meeting rooms
12 - 900 People
84 Rooms
From €
Located a short distance from Mazara del Vallo, Almar Giardino di Costanza Mazara del Vallo offers 88 elegant suites, various culinary options, 8 meeting rooms and the Almablu Spa.
Resort Lungomare Marconi 41 - 30126 - Lido di Venezia (VE)
8 Meeting rooms
10 - 2000 People
198 Rooms
From €
Hotel Excelsior Venice Lido Resort is the legendary heart of the Venice Film Festival on the Adriatic coast. A Moorish palace offering Venice’s only private beach resort experience, featuring the city’s largest guestrooms and grand terraces, just 15 minutes from St. Mark’s Square. Our events spaces can accommodate approximately 500 people indoors and up to 2,000 outdoors.The hotel features 198 spacious and refined rooms and suites, characterized by a distinctive design in harmony with the building’s architecture and the city’s style. Rooms offer views of the Adriatic Sea, the lagoon and Venice, or the charming inner courtyard reminiscent of Andalusian-Moorish elegance.
Hotel km 23.500, Strada Statale 379 di Egnazia e delle Terme di Torre Canne, 72017 Ostuni Marina, Ostuni (BR)
8 Meeting rooms
10 - 1200 People
126 Rooms
From €
The property features 126 rooms, a conference center, reception and event spaces, a restaurant serving traditional Apulian and international cuisine, a wellness SPA, a swimming pool, and a private beach.
Hotel Rotonda Romea 1 - 35175 - Venezia Mestre (VE)
9 Meeting rooms
2 - 180 People
188 Rooms
From €
An oasis on the outskirts of Venice. The Hotel Belstay Venezia Mestre is ideal for both business and leisure travelers. Strategically positioned on the outskirts of Venice, it offers 188 Classic and Superior rooms, conference spaces, a bar with outdoor terrace.
The hotel is surrounded by a well-kept garden where Team Building activities can also be organised.
Historic villa Via Cavour, 6 - 37060 - Castel D'Azzano (VR)
9 Meeting rooms
2 - 250 People
67 Rooms
From €
Hotel Villa Malaspina, in Castel d'Azzano, is an elegant 4-star hotel in a 16th-century villa. It offers modern comforts with an antique charm, a fine restaurant, a pool, and proximity to Verona.
Hotel Riva del Mandracchio, 4 - 34124 - Trieste (TS)
9 Meeting rooms
30 - 320 People
144 Rooms
From €
Savoia Excelsior Palace, a historic hotel on Trieste’s waterfront, blends timeless elegance with breathtaking sea views. Opened in 1911, it embodies Mitteleuropean charm with modern comforts.
Hotel business Via Portogallo, 1/P - 37069 - Villafranca di Verona (VR)
9 Meeting rooms
8 - 250 People
113 Rooms
From €
The Best Western Plus Hotel Expo in Villafranca di Verona offers comfort, elegance, and quality services, ideal for business or leisure stays near the airport.
Space for events Via Ximenes, 662 - 51028 - Limestre (PT)
9 Meeting rooms
10 - 330 People
90 Rooms
From €
Dynamo Academy, within its Campus and the areas of Dynamo Camp, offers modern and versatile spaces for corporate events, meetings, training, and experiential activities, with fully equipped rooms and hospitality for up to 330 people.
Carattere Toscano Hotels & Resorts is a hospitality brand highlighting Tuscany’s authenticity, offering exclusive locations for MICE events, immersive experiences, quality service, and distinctive territorial identity.
The Grand Hotel Baglioni in the heart of Florence has been offering hospitality and quality for over 100 years in a 19th-century palace featuring elegant rooms and a panoramic restaurant.
The Roccamare Resort: elegance and comfort surrounded by greenery, set between crystal-clear sea, swimming pools, and exclusive services for an unforgettable stay.
Imagine the unique feeling of staying in a small, perfectly restored Tuscan medieval village, where you can enjoy peace and quiet, and where every space has been carefully designed down to the smallest detail to ensure you a truly memorable stay.
