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-04-21:2028-04-21' 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 153, 9
Resort Isola delle Rose, Laguna di San Marco - 30133 - Venezia (VE)
12 Meeting rooms
1 - 380 People
266 Rooms
From €
Luxury resort on the exclusive Isola delle Rose, ideal for meetings and unforgettable events — just minutes from St. Mark’s, in the heart of the Venetian Lagoon.
Completely renovated, immersed in the greenery of the EUR, 280 rooms, restaurant, bar, gym and more than 1800 m2 of conference center equipped with the latest technology.
Hotel via Derna, 4 - 37014 - Castelnuovo del Garda (VR)
6 Meeting rooms
1 - 1250 People
475 Rooms
From €
Gardaland Resort, in addition to the Theme Park, the LEGOLAND® Water Park Gardaland and the themed Gardaland SEA LIFE Aquarium, offers three themed hotels with a total of 475 rooms.
Hotel Via Luigi Alamanni, 37 - 50123 - Firenze (FI)
2 Meeting rooms
1 - 75 People
82 Rooms
From €
For corporate events: panoramic terrace on the 6th floor overlooking the Duomo, outdoor pool with a platform for fashion shows, large meeting room, and interview room. Customized lunches and dinners available.
Shopping destination Via Ponte di Piscina Cupa, 64 00128 Castel Romano (RM)
From €
Castel Romano Designer Outlet is the capital's outlet where you can find the best of fashion at prices reduced by up to 70% every day and the biggest brands such as Burberry, Michael Kors, Furla, Coach, Valentino and many others.
With its splendid architectural setting, bars and restaurants, children's play area, convenient free parking and more than 150 shops, the Designer Outlet in Rome offers its customers and all visitors a unique shopping experience.
We are located just 25 km from the center of Rome.
The Brieis Relais Alpino is a widespread hotel created from the careful and complete renovation of an Alpine village, it is set in a small corner of paradise at 1500 m among the pristine mountains of the Maira Valley in the province of Cuneo.
4-star boutique hotel in Piazza della Rotonda, in front of the Pantheon. Completely renovated in 2020, it is characterized by a refined and elegant design.
Located in the heart of Florence, FH55 Hotel Calzaiuoli takes its name from the street it overlooks, between the Duomo and Palazzo Vecchio, a few steps from Ponte Vecchio. The hotel creates a mix of style, optimal location and comfort, to savor the liveliness of the contemporary city among the greatest works of art of the Renaissance and the center of high fashion shopping.
