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 108, 9
Hotel Via Lazzaretto, 1 - 21019 - Somma Lombardo (VA)
4 Meeting rooms
6 - 100 People
143 Rooms
From €
Find us 10 kilometers from Milan Malpensa Airport and 50 kilometers from the center of Milan. Castello Visconti di San Vito is a few minutes’ drive away, and Volandia Park and Flight Museum is just eight kilometers from us. Lake Maggiore is an hour’s drive. We offer a 24-hour fitness center, spacious meeting rooms, and a restaurant with outdoor space.
Hotel business Via Lucio Giunio Columella, 36 - 20128 - Milano (MI)
10 Meeting rooms
20 - 320 People
193 Rooms
From €
We’re steps from the Villa San Giovanni metro link to Milan city center, Duomo Square, and Grand Galleria Vittorio Emanuele – Italy’s oldest mall. We have event space for 850 guests, an all-day restaurant, and a 24-hour shop. Perks include free WiFi, underground parking, and fitness center access. Linate Airport is 12 km away.
Located in Rome’s EUR district, featuring modern design, panoramic views, and quick access to the city center. Close to the metro, airports, shopping, and dining.
Hotel Via dell'Arcivescovado, 18 - 10121 - Torino (TO)
11 Meeting rooms
6 - 120 People
175 Rooms
From €
In central Turin, our hotel is within walking distance of the popular Museo Egizio. Porta Nuova Station is just 700 mt away, and the Mole Antonelliana is two kilometers from our hotel. Turin-Caselle Airport TRN is reachable within 30 minutes. Enjoy Italian cuisine at our on-site restaurant, as well as our event rooms and fitness center.
Hotel Via Po' di Levante 4 - 45010 - Rosolina (RO)
1 Meeting rooms
10 - 300 People
86 Rooms
From €
Surrounded by nature, in front of the beach, with swimming pool, elegant rooms, conference room and spacious restaurant, excellent service: ideal setting for corporate events or team building.
Hotel business Via Cristoforo Colombo 710 - 00144 - Roma (RM)
6 Meeting rooms
1 - 550 People
323 Rooms
From €
In the heart of the Eur district, Hotel Cristoforo Colombo in Rome, completely renovated and expanded in 2019, is a modern design hotel that offers 323 elegantly furnished rooms, created specifically for the comfort of its guests.
