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 108, 9
In the heart of Bardolino, a stone's throw from Lake Garda, your 4-star Superior hotel with panoramic view, for a holiday among nature, art and relaxation. From the swimming pool to the Spa, everything is designed to offer you an authentic wellness experience.
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.
Spazio per eventi Via di Porrona 1 - 58044 - Cinigiano (GR)
9 Rooms
From €
Located in Cinigiano (Grosseto, TUSCANY), Ribusieri Country House offers luxury accommodation with air conditioning and access to a private park equipped with private sun loungers and umbrellas.
