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 ASC
LIMIT 144, 9
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 Via Milanese, 3 - 20099 - Sesto San Giovanni (MI)
8 Meeting rooms
10 - 301 People
77 Rooms
From €
Discover the timeless beauty of Grand Hotel Villa Torretta: historic elegance, modern luxury, fine dining, and lush gardens just minutes from Milan’s vibrant center.
Hotel Via per Busto Arsizio, 7 - 21058 - SOLBIATE OLONA (VA)
8 Meeting rooms
12 - 320 People
246 Rooms
From €
Overlooking Le Robinie Golf Course, we’re 15 minutes from Malpensa Airport, and offer a shuttle there and to Busto Arsizio Railway Station. NATO Headquarters is across the street and MalpensaFiere Exhibition Center is five minutes away. Lake Maggiore and Lake Como are within 30 minutes. Enjoy our fitness center and 19,000 sq. ft. of event space.
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.
