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-22:2028-04-22' 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 72, 9
Esperienza incantevole al Parkhotel Laurin nel cuore di Bolzano: camere eleganti, fascino storico, sale multifunzionali, ristoranti raffinati e parco secolare.
The Radisson Blu GHR Rome was born from the merger of two iconic hotels - the Grand Hotel Ritz and the Hotel Regent - completely renovating 280 rooms - in 6 different types - 3 restaurants, the conference center with 5 meeting rooms, the private gym, and the common areas.
Hotel business Via Portogallo, 1/P - 37069 - Villafranca di Verona (VR)
9 Meeting rooms
8 - 250 People
113 Rooms
From €
The Best Western Plus Hotel Expo in Villafranca di Verona offers comfort, elegance, and quality services, ideal for business or leisure stays near the airport.
Hotel business Corso Sempione, 91 - 20149 - Milano (MI)
10 Meeting rooms
8 - 325 People
124 Rooms
From €
Enterprise Hotel, a comfortable and modern 4-star hotel in Corso Sempione, comprises 124 rooms, 8 meeting rooms, a restaurant, a panoramic spa, a fitness centre, a garden bar and a wine bar.
Hotel Indigo Milano, a new boutique hotel located in Corso Monforte, in the historic centre of the city, offers its guests 51 soundproofed rooms just 800 metres from Milan Cathedral.
Surrounded by the vivid colours of the Mediterranean landscape, Ostuni a Mare is the perfect place to enjoy peaceful moments, immersed in the scents of Puglia and the fresh sea air.
Hotel Via Beato Angelico 35 - 50014 - Fiesole (FI)
1 Meeting rooms
9 - 20 People
32 Rooms
From €
On the Florentine hills, FH55 Hotel Villa Fiesole with 32 rooms, swimming pool and panoramic terrace, is the perfect location for small meetings and incentives
GECOHOTELS® – Chosen by Travellers is a network of 3, 4 and 5 stars Hotels, in Italy, which has a varied range of location, ideal for hosting any type of event
