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 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 126, 9
Hotel Via Europa 100 - 63821 - Porto Sant'Elpidio (FM)
1 Meeting rooms
10 - 150 People
211 Rooms
From €
La Risacca Family Camping Village offers the right environment to enjoy nature where the scents of the sea and the mountains combine, creating a unique sensation
Hotel business Via Briantea, 5 - 24129 - Bergamo (BG)
4 Meeting rooms
10 - 313 People
126 Rooms
From €
Life Source is an innovative hospitality center that, all in one location, offers high-tech Meeting Rooms, High-Level Food Experience , a 4*S Hotel and a private clinic.
Small luxury hotel Via Forcella 6 - 20144 - Milano
11 Meeting rooms
10 - 1000 People
68 Rooms
From €
“The Essence of Living”… the welcome built on the foundations of our former perfume factory" led the Martone family to found the five-star Hotel Magna Pars, the first Hotel à Parfum.
Restaurant 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.
Hotel business Via Masaccio, 19 - 20149 - Milano (MI)
18 Meeting rooms
10 - 600 People
291 Rooms
From €
Business Hotel located in the Lotto district, completely renovated in 2025, with 291 rooms, 18 meeting rooms and modern spaces for events and conferences.
Hotel LA ROQQA: Via Panoramica 7 - 58018 - Porto Ercole (GR) | TORRE DI CALA PICCOLA: Via Belvedere, loc. Cala Piccola - 58019 - Porto Santo Stefano (GR) | LA CAPITANA: Via della Capitana 1 - 58052 - Magliano in Toscana (GR)
2 Meeting rooms
0 People
103 Rooms
From €
The LA ROQQA hotel combines comfort, minimalist design, and iconic pieces from the '60s and '70s. With colors in harmony with the landscape, it offers modern elegance and an authentic Tuscan experience.
Boutique Hotel Torre di Cala Piccola, nestled on Monte Argentario's cliffs, offers 53 rooms and suites with terracotta and handcrafted furnishings, an infinity pool, and panoramic sea views.
La Capitana, an 18th-century estate in Tuscany, reopens in 2027, blending rustic charm with modern luxury. Stunning views, nature, and tranquility await.
Monrif Hotels is the Monrif Group's collection of 4-star hotels in the heart of Bologna.
Three elegant and strategically located properties offer quality hospitality for business and leisure travelers, with services dedicated to meetings, events, and comfortable stays.
Discover the Hotel Pfledererhof, an oasis of relaxation in the heart of the Alps! Skiing in winter, hiking in summer, and a dream spa with gourmet cuisine await you!
