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-10-17:2028-10-17' 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 DESC
LIMIT 99, 9
Resort Lungomare Marconi 41 - 30126 - Lido di Venezia (VE)
8 Meeting rooms
10 - 2000 People
198 Rooms
From €
Hotel Excelsior Venice Lido Resort is the legendary heart of the Venice Film Festival on the Adriatic coast. A Moorish palace offering Venice’s only private beach resort experience, featuring the city’s largest guestrooms and grand terraces, just 15 minutes from St. Mark’s Square. Our events spaces can accommodate approximately 500 people indoors and up to 2,000 outdoors.The hotel features 198 spacious and refined rooms and suites, characterized by a distinctive design in harmony with the building’s architecture and the city’s style. Rooms offer views of the Adriatic Sea, the lagoon and Venice, or the charming inner courtyard reminiscent of Andalusian-Moorish elegance.
Hotel km 23.500, Strada Statale 379 di Egnazia e delle Terme di Torre Canne, 72017 Ostuni Marina, Ostuni (BR)
8 Meeting rooms
10 - 1200 People
126 Rooms
From €
The property features 126 rooms, a conference center, reception and event spaces, a restaurant serving traditional Apulian and international cuisine, a wellness SPA, a swimming pool, and a private beach.
Hotel Via Milanese, 3 - 20099 - Sesto San Giovanni (MI)
8 Meeting rooms
10 - 301 People
77 Rooms
From €
Discover the timeless beauty of Grand Hotel Villa Torretta: historic elegance, modern luxury, fine dining, and lush gardens just minutes from Milan’s vibrant center.
A unique location overlooking the Grand Canal, Palazzo Barocci stands out like a unique gem among the city's narrow streets and alleys.
Palazzo 4 Fontane 12
In the enchanting setting of Rome's historic center, Palazzo 4 Fontane 12 welcomes you to an exceptional location, surrounded by the wonders of the Eternal City.
Palazzo Montebello
Among the villas and courtyards of Florence's city center stands Palazzo Montebello, a building where different eras and architectural structures meet.
Chalgrin Boutique Hotel Paris
A boutique hotel in perfect Haussmannian style where you can experience the true Parisian atmosphere by starting your journey in one of our welcoming 50 rooms.
Hotel Via Gracco del Secco, 113 - 53034 - Colle di Val d'Elsa (SI)
5 Meeting rooms
10 - 180 People
181 Rooms
From €
Six 4-star boutique hotels across Chianti Classico and Val d’Elsa: 181 rooms, meeting venues and event spaces for up to 180 guests. A touch of Tuscany.
GECOHOTELS® – Chosen by Travellers is a network of 3, 4 and 5 stars Hotels, in Italy, which has a varied range of location, ideal for hosting any type of event
Hotel business Corso Como 52 - 20812- Limbiate (MB)
7 Meeting rooms
8 - 300 People
183 Rooms
From €
4 star design hotel with modern conference centre, a refined restaurant and lounge bar. A few minutes from Milan, Monza, Lake Como and the Rho-Pero exhibition center.
Esperienza incantevole al Parkhotel Laurin nel cuore di Bolzano: camere eleganti, fascino storico, sale multifunzionali, ristoranti raffinati e parco secolare.
