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-06-19:2028-06-19' 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 ASC
LIMIT 90, 9
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.
Space for events 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.
The Estate represents a typical example of the ancient farms of the Maremma: a group of stone buildings and its Manor Villa form the old village of the Montecucco Estate with the Church of S. Pietro S. Antonio Abate in the centre. The historic cellar from the 1300s and the ziri dating back to the 1600s tell the story of our products which you can savor in the tasting room or inside our "I Granai" restaurant.
