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:2024-10-10:2026-10-10' 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 LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_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_term_relationships.term_taxonomy_id IN (290)
) 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','popup','location','accommodation','tour','acf-field-group','wpcf7_contact_form','mec-events','mec_calendars','mc4wp-form' ) ) OR wp_posts.post_type NOT IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','popup','location','accommodation','tour','acf-field-group','wpcf7_contact_form','mec-events','mec_calendars','mc4wp-form' ) )
GROUP BY wp_posts.ID HAVING 1=1
ORDER BY wp_posts.post_title ASC
LIMIT 0, 9
Location for meeting and events in Emilia-Romagna
With its Riviera Romagnola it offers seaside tourism which every summer attracts families and young people along its coasts. Emilia Romagna is rich in sites of historical and cultural interest, boasting a food and wine tradition appreciated all over the world.
Admiral Park Hotel, an elegant 4-star S hotel surrounded by 250,000 m2 of parkland, is ideal for organizing team building activities and outdoor events. It is located a few minutes from Bologna airport and the main motorway junctions with ample parking available. The Hotel has 120 spacious and bright rooms of different types. The conference center offers 11 modular rooms: the main room has a maximum capacity of 300 people. The Tulipano restaurant can accommodate up to 250 people. A delightful panoramic swimming pool, a fitness space and a relaxation area complete the offer.
Fidenza Village interpreta una nuova filosofia di shopping e ospitalità, capace di coniugare le espressioni più raffinate della moda e del turismo, a soli 60 minuti da Milano e Bologna, nel cuore della Food Valley.
Exclusive environments, modular solutions and tailor-made services transform your event into the perfect working day for an emotional corporate meeting experience in the heart of Cesenatico and directly on the sea.
Hotel Piazzale Torino 16 - 48015 - Milano Marittima (RA)
10 Meeting rooms
10 - 400 People
110 Rooms
From €
Cross the threshold of the Grand Hotel Gallia, 4 star hotel in Milano Marittima with swimming pool, you will discover a world of tranquility, well-being, attention signed by the unmistakable Batani touch.
