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-01-16:2028-01-16' 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 (932)
) 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 0, 9
Location for meeting and events in Lombardy
Lombardy is known for its industry and finance but also for its extraordinary art and landscapes, starting with those of the picturesque lakes or its mountains, Valcamonica and Valtellina. Capital and symbolic city, Milan represents the beating heart of an industrious territory with a vibrant spirit.
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 P.za Ventiquattro Maggio, 8 - 20123 - Milano (MI)
4 Meeting rooms
15 - 150 People
32 Rooms
From €
Aethos is a new concept of modern club, rooted in hospitality, with dynamic spaces and a global network designed to promote connection, creativity and belonging.
Hotel business Corso Sempione 320 - 20028 - San Vittore Olona (MI)
1 Meeting rooms
1 - 90 People
82 Rooms
From €
Elegant 4-star hotel just a few minutes from the Rho-Pero exhibition center with a refined restaurant and a spectacular meeting room for high-level meetings.
Hotel business A50 Tangenziale Ovest km19 - 20090 - Assago (MI)
17 Meeting rooms
10 - 240 People
203 Rooms
From €
Our versatile environments and contemporary design make Belstay Milano Assago the most suitable hotel and business center on the outskirts of Milan for your next trip. All our services are built to meet your needs, to enjoy an excellent stay in the south of Milan a few steps from the Milanofiori Forum in our newly designed 4-star urban resort by Belstay.
Hotel business Via Bruno Buozzi 2 - 20068 - Peschiera Borromeo (MI)
3 Meeting rooms
10 - 60 People
142 Rooms
From €
Belstay Milano Linate leverages quality and its strong identity to interpret a new idea of suburbia on the outskirts of Milan. An innovative way to experience the hotel. A service built on spontaneity, which always puts the guest at the centre. Hospitality with a contemporary flavor and Italian design.
Hotel Via Melchiorre Gioia 73 - 20124 - Milano (MI)
3 Meeting rooms
2 - 60 People
109 Rooms
From €
L’hotel Crowne Plaza Milan City è situato nel cuore deldistretto finanziario di Milano, a pochi passi dalla Stazione Centrale. Il design moderno e raffinato vi accoglie sin dall’arrivo per accompagnarvi in un soggiorno confortevole.
