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-21:2028-04-21' 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 ASC
LIMIT 162, 9
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.
At the gates of Andalusia, Magna Marbella is an oasis of freshness protected by the Sierra Blanca mountains. A stone's throw from the picturesque old town of Marbella, the Club Med Magna Marbella imposes its design structure full of vegetation amidst twelve hectares of terraced gardens
The “Grand Hotel Vanvitelli” is a four-star Superior Hotel excellently located 20km from Naples, at the entrance to Caserta, on the same street planned by the same architect who designed the magnificent Bourbonic Royal Palace.
At the hotel, other than team building activities, it’s possible to plan a day at prestigious and award-winning Naboo Spa. The 240 room hotel has a Conference Centre with 17 meeting rooms, 5 dinning areas, an outdoor swimming pool, a fitness centre, and 1200m2 Spa. Parking is available in our spacious car park with 300 stalls and parking available for tour operator buses.
Resort 12 avenue des Spélugues - 98000- Monaco (MC)
18 Meeting rooms
2 - 1500 People
569 Rooms
From €
The Fairmont Monte Carlo located in the heart of the Principality of Monaco, between the Mediterranean and the legendary Monte-Carlo Casino, is one of the largest luxury hotels in Europe with 596 rooms, suites and residences, the world-renowned Nobu restaurant International, Nikki Beach Rooftop Restaurant, Lobby Lounge Restaurant, Horizon Rooftop International Panoramic Restaurant, 2 Bars, Fairmont Spa Treatment Rooms, Fitness Center, Year-Round Heated Pool, 18 Meeting Rooms and Luxury Boutiques.
Hotel business Via Masaccio, 19 - 20149 - Milano (MI)
18 Meeting rooms
10 - 600 People
291 Rooms
From €
Business Hotel located in the Lotto district, completely renovated in 2025, with 291 rooms, 18 meeting rooms and modern spaces for events and conferences.
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.
Resort SS 106 Km 466,600 - 74010 - Castellaneta Marina (TA)
30 Meeting rooms
15 - 1000 People
790 Rooms
From €
The Ethra Congress Center is in the renovated Ethra Reserve complex - an exclusive destination by the sea, surrounded by the greenery of the Natural Reserve in Stornara.
