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 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 117, 9
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.
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.
Resort Isola delle Rose, Laguna di San Marco - 30133 - Venezia (VE)
12 Meeting rooms
1 - 380 People
266 Rooms
From €
Luxury resort on the exclusive Isola delle Rose, ideal for meetings and unforgettable events — just minutes from St. Mark’s, in the heart of the Venetian Lagoon.
Space for events Via Ancona, 11/A - 10152 - Torino (TO)
4 Meeting rooms
25 - 1095 People
From €
La Centrale, located in the Nuvola Lavazza complex, is an impressive space created within the former power plant in the Aurora neighborhood. The architectural renovation project preserved and enhanced the original 1897 structure, maintaining its majestic industrial architecture intact, enhanced by the large wrought-iron windows overlooking the city. Today, it is a symbol of Turin's cultural dynamism and houses: The Space, the Indoor Terrace, the Conference Rooms, the Foyer, and the Grand Foyer. Over the years, La Centrale has hosted national and international events: conventions, meetings, trade fairs, exhibitions, concerts, product launches, press conferences, and private events.
