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:2025-10-11:2027-10-11' 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 INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_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_postmeta.meta_key = 'accommodation_sale_meeting'
) 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_postmeta.meta_value+0 DESC
LIMIT 63, 9
Sheraton Diana Majestic is an iconic Milanese hotel and a popular reference point for locals and international travelers seeking a glamorous location for their stay and events.
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 Viale delle Industrie snc - 20040 - Cambiago (MI)
3 Meeting rooms
2 - 100 People
140 Rooms
From €
Modern 4-star hotel in a strategic position on the outskirts of Milan with elegant restaurant, modular meeting rooms, fitness center and a relaxing wellness spa.
The B&B Hotel Affi Lago di Garda is a 3-star hotel located in a quiet and strategic area near the Brennero A22 motorway exit.
The city of Verona is only a 20-minute drive from the Affi Lago di Garda hotel, which offers an excellent accommodation to rest after a day spent on Lake Garda or in the nearby amusement parks such as Gardaland, Caneva Acquapark, Parco Natura Viva .
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.
Resort Località Santa Lucia - Cefalù - 90015 - Palermo (PA)
3 Meeting rooms
42 - 143 People
From €
Our first Exclusive Collection Resort in the Mediterranean opened in 2018 on the historic site of Cefalù. Located at the top of the cliffs, with a breathtaking view of the bay of Cefalù, you will admire the charm of this fabulous Resort which offers the best Premium All Inclusive service
