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 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_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_posts.post_title ASC
LIMIT 54, 9
Resort SS 106 Km 466,600 - 74010 - Castellaneta Marina (TA)
30 Meeting rooms
15 - 1000 People
790 Rooms
From €
The Ethra Congress Center is in the renovated Ethra Reserve complex - an exclusive destination by the sea, surrounded by the greenery of the Natural Reserve in Stornara.
Resort 12 avenue des Spélugues - 98000- Monaco (MC)
18 Meeting rooms
2 - 1500 People
569 Rooms
From €
The Fairmont Monte Carlo located in the heart of the Principality of Monaco, between the Mediterranean and the legendary Monte-Carlo Casino, is one of the largest luxury hotels in Europe with 596 rooms, suites and residences, the world-renowned Nobu restaurant International, Nikki Beach Rooftop Restaurant, Lobby Lounge Restaurant, Horizon Rooftop International Panoramic Restaurant, 2 Bars, Fairmont Spa Treatment Rooms, Fitness Center, Year-Round Heated Pool, 18 Meeting Rooms and Luxury Boutiques.
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 Lungarno del Tempio 44 - 50121 - Firenze (FI)
13 Meeting rooms
10 - 300 People
327 Rooms
From €
FH55 Grand Hotel Mediterraneo, located along the Arno River in Florence and just a short walk from Santa Croce and the city’s main landmarks, is perfectly suited for both leisure and business stays.
L’FH55 Grand Hotel Palatino è la scelta migliore per un evento all’insegna del comfort e della tranquillità nel cuore di Roma. Posizione straordinaria: a pochi passi dal Colosseo e dal Foro Romano.
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.
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
Fidenza Village interpreta una nuova filosofia di shopping e ospitalità, capace di coniugare le espressioni più raffinate della moda e del turismo, a soli 60 minuti da Milano e Bologna, nel cuore della Food Valley.
