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-10-17:2028-10-17' 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 63, 9
Hotel business Via Aurelia Antica 415 - 10065 - Roma (RM)
13 Meeting rooms
30 - 600 People
307 Rooms
From €
Located a stone's throw from the Vatican, our hotel meets the needs of both business travelers, with its 13 meeting rooms and free wi-fi, and tourists.
CX The Nexus Rome San Pietro combines a premium hotel, residence, convention center, dining options, and a panoramic terrace just steps away from St. Peter's for a local and global community.
Hotel Largo J. F. Kennedy, 1 - 20873 - Cavenago di Brianza (MB)
15 Meeting rooms
10 - 500 People
138 Rooms
From €
Devero Hotel is the perfect location for business man who are looking for attention to detail, in a professional and relaxing environment, also Devero Hotel can be the right place for tourists and families.
Thanks to its strategic location 20 km from either Milan and Bergamo airports and a few km from the most beautiful lakes in northern Italy (Garda and Como).
We’re a two-minute walk from Mompiano Metro Station and 800m from Mario Rigamonte Stadium. The Piazza della Loggia and the Santa Giulia Museum are within five kilometers. Valerio Catullo and Orio al Serio airports are under an hour’s drive. We have a fitness centre and seasonal outdoor pool. Enjoy a warm DoubleTree Cookie on arrival and free WiFi.
Hotel Via per Busto Arsizio, 7 - 21058 - SOLBIATE OLONA (VA)
8 Meeting rooms
12 - 320 People
246 Rooms
From €
Overlooking Le Robinie Golf Course, we’re 15 minutes from Malpensa Airport, and offer a shuttle there and to Busto Arsizio Railway Station. NATO Headquarters is across the street and MalpensaFiere Exhibition Center is five minutes away. Lake Maggiore and Lake Como are within 30 minutes. Enjoy our fitness center and 19,000 sq. ft. of event space.
In the heart of Rome, DoubleTree by Hilton Rome Monti offers modern and flexible meeting spaces, tailored services, and an exclusive rooftop for high-level corporate events.
The Due Torri Hotel is located in the historic center of Verona, near the Church of Sant'Anastasia, a stone's throw from the famous Juliet's balcony, Piazza Bra and the Arena.
