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-10:2027-10-10' 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 18, 9
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 viale Lombardia 76/78 - 20900 - Monza (MB)
1 Meeting rooms
2 - 50 People
66 Rooms
From €
4-star hotel with a classic style just a few minutes from the Monza racetrack and the Villa Reale with a welcoming and charming restaurant and meeting spaces for small gatherings.
Hotel Via Vittorio Emanuele 291 - 90133 - Palermo (PA)
1 Meeting rooms
1 - 100 People
143 Rooms
From €
The B&B Hotels Hotel Palermo Quattro Canti is a 3-star hotel located in the heart of the historic center of the city of Palermo, in the Loggia district. Located along Via Vittorio Emanuele, the hotel is just a few meters from the Quattro Canti and the church of San Giuseppe. On the top floor of the building, a typical Sicilian restaurant and a splendid terrace are available to all guests, offering an exclusive view of the characteristic Piazza Pretoria and the roofs of the historic center of Palermo, where you can dine or enjoy a moment of relaxation surrounded with an evocative atmosphere.
Hotel business Via Guglielmo Silva 12 - 20149 - Milano (MI)
1 Meeting rooms
10 - 40 People
96 Rooms
From €
The B&B Hotel Milano Portello is a 4-star hotel with a modern design ideal for business trips, for organizing meetings with clients or simply for leisure. It is located a stone's throw from Fiera Milano City and MiCo, near the brand new City Life shopping district and is convenient for reaching the San Siro stadium.
Just 200 meters from the hotel is the Metro M5 Portello lilac line stop and the Metro M1 Lotto stop is 600 meters away.
The B&B Hotel Milano Central Station is a three-star hotel that allows you to stay in Milan in the city center, a few steps from Milan Central Station.
The closest metro stop is Centrale, 300 meters from the hotel and in Centrale station. The hotel is also a 5-minute walk from bus connections leading to Milan Malpensa and Bergamo Orio al Serio airports. The B&B Hotel Milano Central Station can be reached both by train and with the M2 (green line) and M3 (yellow line).
Spazio per eventi Piazza Diaz 7- 20121-Milano (MI)
1 Meeting rooms
1 - 150 People
From €
Terrazza Martini composed of the 15th and 16th floors of the skyscraper in Piazza Armando Diaz 7 is not a bar / restaurant open to the public, but is a location for events rented exclusively only.
To organize an event it’s necessary to rent the entire structure. The entrance to Terrazza Martini is via two lifts that only reach the 15th floor.
The location cannot be split because the 16th floor rooftop can only be reached via an internal staircase from the 15th floor.
The 16th floor consists of a “gazebo” structure surrounded by windows, and an external part from which enjoy the panoramic view of the city.
Spazio per eventi Piazza Luigi Rossi 2-10023- Pessione (TO)
1 Meeting rooms
10 - 180 People
4 Rooms
From €
CASA MARTINI is the ideal reception venue. Located in Pessione, at Martini & Rossi’s historic premises, it marks the meeting point between the company’s traditions and future.
