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 27, 9
Hotel Via Vittorio Emanuele 291 - 90133 - Palermo (PA)
1 Meeting rooms
1 - 100 People
143 Rooms
From €
The B&B Hotels Hotel Palermo Quattro Canti is a 3-star hotel located in the heart of the historic center of the city of Palermo, in the Loggia district. Located along Via Vittorio Emanuele, the hotel is just a few meters from the Quattro Canti and the church of San Giuseppe. On the top floor of the building, a typical Sicilian restaurant and a splendid terrace are available to all guests, offering an exclusive view of the characteristic Piazza Pretoria and the roofs of the historic center of Palermo, where you can dine or enjoy a moment of relaxation surrounded with an evocative atmosphere.
Hotel Piazza San Marco, 1243 - 30124 - Venezia (VE)
3 Meeting rooms
15 - 200 People
91 Rooms
From €
Only a few steps from St. Mark’s Square, Baglioni Hotel Luna features 3 flexible event venues, as well as prestigious rooms and suites with terraces overlooking the canals and gardens of Venice. We also provide exceptional amenities, white glove services & technical support.
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.
Resort Via Tavolara, Località Lu Fraili di Sotto - 07052 - San Teodoro (SS)
78 Rooms
From €
Reconnect with nature in a stunning resort setting within the Tavolara Marine Reserve, a short distance from the incomparable Lu Impostu beach, and one of the best wine regions in Sardinia.
Hotel business A50 Tangenziale Ovest km19 - 20090 - Assago (MI)
17 Meeting rooms
10 - 240 People
203 Rooms
From €
Our versatile environments and contemporary design make Belstay Milano Assago the most suitable hotel and business center on the outskirts of Milan for your next trip. All our services are built to meet your needs, to enjoy an excellent stay in the south of Milan a few steps from the Milanofiori Forum in our newly designed 4-star urban resort by Belstay.
Hotel business Via Bruno Buozzi 2 - 20068 - Peschiera Borromeo (MI)
3 Meeting rooms
10 - 60 People
142 Rooms
From €
Belstay Milano Linate leverages quality and its strong identity to interpret a new idea of suburbia on the outskirts of Milan. An innovative way to experience the hotel. A service built on spontaneity, which always puts the guest at the centre. Hospitality with a contemporary flavor and Italian design.
