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 45, 9
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.
Hotel business Via Lanzo 160 - 10071- Borgaro Torinese (TO)
8 Meeting rooms
20 - 450 People
145 Rooms
From €
The B&B Hotel Borgaro Torinese is a modern 4-star hotel, with an elegant and refined taste, ideal both for business accommodation and for healthy relaxation after a busy day.
The pride of the structure is its SPA which will offer you a stay dedicated to well-being, the reception will be happy to give you all the information about it.
Resort Viale delle terme 84, 35030 Galzignano Terme (Padova)
8 Meeting rooms
33 - 658 People
239 Rooms
From €
Galzignano Resort Terme & Golf, an extraordinary structure immersed in nature and made up of three 4-star hotels with one of the largest Thermal Centers in Europe and natural 37° waters, the Galzignano Wellness integrated medicine centre, wellness center and spa, a 9-hole golf course, haute cuisine and all the comforts necessary for a ""thousand and one nights"" stay.
Hotel business Via Giulio Petroni, 15 - 70124 Bari (BA)
8 Meeting rooms
5 - 450 People
146 Rooms
From €
Just a few metres from the main train station, the Hotel Excelsior Bari awaits you with its spacious and bright rooms, its restaurant serving Mediterranean cuisine and its renovated conference centre.
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.