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-06-19:2028-06-19' 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 108, 9
Hotel Piazza di S. Paolino, 1 - 50123 - Firenze (FI)
3 Meeting rooms
12 - 80 People
170 Rooms
From €
The design of 25hours Hotel Piazza San Paolino in Florence’s Santa Maria Novella district is eclectically inspired by Dante’s Divine Comedy. CECCHINI IN CITTÀ restaurant is the lively centre of the hotel. A Negroni bar and an Alimentari complete the culinary offering. Inhouse Cinema Paradiso shows curated movies.
Hotel Contrada Masseria San Pietro, 11450 - 74123 - Taranto (TA)
3 Meeting rooms
20 - 220 People
48 Rooms
From €
Relais Histò welcomes every event with warmth and charm, offering a setting of history, beauty, and authenticity where each moment feels truly special.
Surrounded by the vivid colours of the Mediterranean landscape, Ostuni a Mare is the perfect place to enjoy peaceful moments, immersed in the scents of Puglia and the fresh sea air.
In the heart of Rome, DoubleTree by Hilton Rome Monti offers modern and flexible meeting spaces, tailored services, and an exclusive rooftop for high-level corporate events.
Space for events Strada Statale 379 di Egnazia e delle Terme di Torre Canne - 72015 - Fasano (BR)
3 Meeting rooms
30 - 500 People
16 Rooms
From €
Exclusive Puglia venue for meetings, gala dinners, team-building and corporate events, with versatile indoor and outdoor spaces in an authentic masseria.
Hotel Piazza San Marco, 1243 - 30124 - Venezia (VE)
3 Meeting rooms
15 - 200 People
91 Rooms
From €
Only a few steps from St. Mark’s Square, Baglioni Hotel Luna features 3 flexible event venues, as well as prestigious rooms and suites with terraces overlooking the canals and gardens of Venice. We also provide exceptional amenities, white glove services & technical support.
Hotel business Località Boscofangone - 80035 - Nola (NA)
3 Meeting rooms
5 - 110 People
143 Rooms
From €
Located in Nola, Naples, Vulcano Buono combines a strategic position, modern design, and business-oriented services. The three meeting rooms are perfect for conferences, meetings, and team-building activities.
