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-07-03:2026-07-03' 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','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
We are Hotel, Co(z)working, Bistrot, Events, but you can call us House of Stories: different realities live together in harmony under the same roof.Two hotels in Milan city center with unconventional events venues, multifunctional rooms, indoor & outdoor spaces to design an innovative hospitality concept. Home-feeling, sinergy, identity: a starting point to explore the city and yourself.
We are Hotel, Co(z)working, Bistrot, Events, but you can call us House of Stories: different realities live together in harmony under the same roof.Two hotels in Milan city center with unconventional events venues, multifunctional rooms, indoor & outdoor spaces to design an innovative hospitality concept. Home-feeling, sinergy, identity: a starting point to explore the city and yourself.
Hotel business Via Giorgio Zoega 59 - 00164 - Roma (RM)
19 Meeting rooms
10 - 550 People
276 Rooms
From €
A.Roma Lifestyle Hotel: il più grande ledwall in Italia nella sala plenaria (max 550 pax), cucina internazionale con 10 cookinglive station e 3000mq di SPA.
Hotel business Via Luciano Lama 10 - 20099 - Sesto San Giovanni (Milano)
6 Meeting rooms
2 - 180 People
155 Rooms
From €
AC Hotel Milan Sesto, with 155 rooms and 6 meeting rooms, is modern and elegant. It is located 200 metres from Sesto Marelli underground station for a quick access to the centre of Milan.
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.
Resort Via Salemi Km 7, 100 - 91026 - Mazara del Vallo (TP)
8 Meeting rooms
12 - 900 People
88 Rooms
From €
Situato a poca distanza da Mazara del Vallo, Almar Giardino di Costanza Resort & Spa presenta 88 eleganti Suites, diverse proposte culinarie, 8 sale meeting e la nuova Almablu Spa.
Resort Via Dante Alighieri 106- 30016 - Lido di Jesolo (VE)
10 Meeting rooms
12 - 530 People
195 Rooms
From €
Almar Jesolo Resort & Spa, located in Lido di Jesolo, is characterized by 195 elegant and modern rooms, 4 F&B Outlets, 10 different meeting rooms and the awards-winning Almablu Spa.
4-star boutique hotel in Piazza della Rotonda, in front of the Pantheon. Completely renovated in 2020, it is characterized by a refined and elegant design.
