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_capienza_minima'
) 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 36, 9
Hotel Piazzale Torino 16 - 48015 - Milano Marittima (RA)
10 Meeting rooms
10 - 400 People
110 Rooms
From €
Cross the threshold of the Grand Hotel Gallia, 4 star hotel in Milano Marittima with swimming pool, you will discover a world of tranquility, well-being, attention signed by the unmistakable Batani touch.
Located in a strategic position between the center of Rome and Fiumicino Airport, the hotel offers functional and flexible spaces, capable of hosting leisure and business customers, in a green and relaxing context on the outskirts of Rome.
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.
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.
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.
