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 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_sale_meeting'
) 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 DESC
LIMIT 27, 9
Esperienza incantevole al Parkhotel Laurin nel cuore di Bolzano: camere eleganti, fascino storico, sale multifunzionali, ristoranti raffinati e parco secolare.
Hotel Via Principe Amedeo, 5/B - 00185 - Roma (RM)
10 Meeting rooms
10 - 270 People
197 Rooms
From €
Best Western Plus Hotel Universo is located in the center of Rome within walking distance of Roma Termini Station.
It has 197 rooms and offers guests, Rooftop lounge bar and a conference center offering 10 meeting rooms.
The hotel is an ideal location for corporate events and business stays in Rome with a Conference Center offering 10 meeting rooms.
The Best Western Plus Hotel Universo is not just a place to stay, but a fascinating piece of history that chronicles the evolution of Italian hospitality.
Hotel Rotonda Romea 1 - 35175 - Venezia Mestre (VE)
9 Meeting rooms
2 - 180 People
188 Rooms
From €
An oasis on the outskirts of Venice. The Hotel Belstay Venezia Mestre is ideal for both business and leisure travelers. Strategically positioned on the outskirts of Venice, it offers 188 Classic and Superior rooms, conference spaces, a bar with outdoor terrace.
The hotel is surrounded by a well-kept garden where Team Building activities can also be organised.
Villa storica Via Cavour, 6 - 37060 - Castel D'Azzano (VR)
9 Meeting rooms
2 - 250 People
67 Rooms
From €
Hotel Villa Malaspina, in Castel d'Azzano, is an elegant 4-star hotel in a 16th-century villa. It offers modern comforts with an antique charm, a fine restaurant, a pool, and proximity to Verona.
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.
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 Via Lanzo 160 - 10071- Borgaro Torinese (TO)
8 Meeting rooms
20 - 450 People
145 Rooms
From €
The B&B Hotel Borgaro Torinese is a modern 4-star hotel, with an elegant and refined taste, ideal both for business accommodation and for healthy relaxation after a busy day.
The pride of the structure is its SPA which will offer you a stay dedicated to well-being, the reception will be happy to give you all the information about it.
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.
