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 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_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_posts.post_title ASC
LIMIT 180, 9
Rose Garden Palace, renovated in 2023 on Via Boncompagni near Villa Borghese, offers 65 rooms, a restaurant, lounge bar, spa with pool, gym, and meeting and event spaces.
Hotel Via Gracco del Secco, 113 - 53034 - Colle di Val d'Elsa (SI)
5 Meeting rooms
10 - 180 People
181 Rooms
From €
Six 4-star boutique hotels across Chianti Classico and Val d’Elsa: 181 rooms, meeting venues and event spaces for up to 180 guests. A touch of Tuscany.
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.
Sheraton Diana Majestic is an iconic Milanese hotel and a popular reference point for locals and international travelers seeking a glamorous location for their stay and events.
Hotel business Viale Salvatore Rebecchini, 39 - 00148 - Roma (RM)
48 Meeting rooms
10 - 550 People
782 Rooms
From €
Sheraton Rome Parco de' Medici has 3 buildings in a green oasis with golf court and outdoor pools. Fiumicino Airport is 10 km away and the historical center 13km away.
Positioned between the sea and the splendid landscapes of a Pialassa rich in suggestive natural views, the Sole Family Camping Village is suitable for families but is also perfect for sports groups, with the utmost attention to accessibility.
