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 171, 9
Resort Località Torre Mezza Praia SS18 - 88022 - Acconia di Curinga (CZ)
3 Meeting rooms
30 - 300 People
518 Rooms
From €
Falkensteiner Club Funimation Garden Calabria is a resort with 518 rooms (of which 218 renovated) just 14 km from Lamezia Terme airport with 3 meeting rooms for a total capacity of 380 people. Numerous services and activities.
Hotel Riva del Mandracchio, 4 - 34124 - Trieste (TS)
9 Meeting rooms
30 - 320 People
144 Rooms
From €
Savoia Excelsior Palace, a historic hotel on Trieste’s waterfront, blends timeless elegance with breathtaking sea views. Opened in 1911, it embodies Mitteleuropean charm with modern comforts.
Space for events Strada Statale 379 di Egnazia e delle Terme di Torre Canne - 72015 - Fasano (BR)
3 Meeting rooms
30 - 500 People
16 Rooms
From €
Exclusive Puglia venue for meetings, gala dinners, team-building and corporate events, with versatile indoor and outdoor spaces in an authentic masseria.
Resort Viale delle terme 84, 35030 Galzignano Terme (Padova)
8 Meeting rooms
33 - 658 People
239 Rooms
From €
Galzignano Resort Terme & Golf, an extraordinary structure immersed in nature and made up of three 4-star hotels with one of the largest Thermal Centers in Europe and natural 37° waters, the Galzignano Wellness integrated medicine centre, wellness center and spa, a 9-hole golf course, haute cuisine and all the comforts necessary for a ""thousand and one nights"" stay.
Located near Otranto, and surrounded by verdant olive groves and the Sea, Baglioni Masseria Muzza Resort & Spa, is a historic property nestled deep in the Salento countryside.
Hotel business Via Einstein 4 - 52100 - Arezzo (AR)
2 Meeting rooms
40 - 70 People
79 Rooms
From €
The B&B Hotel Arezzo is a 4-star hotel which is 3km from the city centre, a 5-minute walk from the Arezzo Fair, a 7-minute drive from the train station and a few minutes from the main points of interest in the area such as the Medici Fortress and Piazza Grande. The hotel is the ideal solution for both family leisure trips and business trips, it is in fact located in a strategic position 5 minutes by car from Arezzo station, which easily connects the hotel to the towns of San Gimignano, Chianti, Siena, Montepulciano and Montalcino, has two meeting rooms and a large, free car park in front of the structure.
Resort Località Santa Lucia - Cefalù - 90015 - Palermo (PA)
3 Meeting rooms
42 - 143 People
From €
Our first Exclusive Collection Resort in the Mediterranean opened in 2018 on the historic site of Cefalù. Located at the top of the cliffs, with a breathtaking view of the bay of Cefalù, you will admire the charm of this fabulous Resort which offers the best Premium All Inclusive service
