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 126, 9
Hospitality and venue for events and meetings on the beachfront in Riccione city-center, up to 200 guests. A unique contact for hospitality, catering and dedicated event services.
Hotel Via Luigi Alamanni, 37 - 50123 - Firenze (FI)
2 Meeting rooms
1 - 75 People
82 Rooms
From €
For corporate events: panoramic terrace on the 6th floor overlooking the Duomo, outdoor pool with a platform for fashion shows, large meeting room, and interview room. Customized lunches and dinners available.
Art Nouveau building recently renovated, located on the seafront. Panoramic terrace facing the sea with Bar and Restaurant. 72 rooms, 2 Restaurants, 2 meeting rooms (100 ppl).
Completely renovated, immersed in the greenery of the EUR, 280 rooms, restaurant, bar, gym and more than 1800 m2 of conference center equipped with the latest technology.
Hotel Via S. Martino della Battaglia, 58 - 00185 - Roma (RM)
5 Meeting rooms
15 - 200 People
134 Rooms
From €
The Hotel St Martin, conveniently located just steps from Republic Square. Renovated and reopened in June 2021. It has 134 rooms divided into Easy, Classic, Deluxe, Superior, Junior Suite and Suite with private terraces and hot tubs. The Hotel offers the Sidus Café, Sidera Restaurant, gym and conference centre for 200 people.
Hotel Monte Baldo 22 - 37062 - Dossobuono di Villafranca (VR)
11 Meeting rooms
4 - 200 People
131 Rooms
From €
Hotel Veronesi La Torre offers 131 contemporary-style rooms, a new outdoor pool, and a conference center with 11 meeting rooms accommodating up to 200 people.
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.
