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-06-19:2028-06-19' 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 ASC
LIMIT 126, 9
Space for events Via Rocca Castello, 2 - Angera - 21021 (VA)
6 Meeting rooms
10 - 250 People
From €
The Rocca di Angera is a place of timeless charm that rises between the Lombardy shore of Lake Maggiore and the sky. The walls are characterised by swallowtail battlements that make it recognisable from afar, as you climb towards the rocky cliff on which it stands in a panoramic position.
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.
At the gates of Andalusia, Magna Marbella is an oasis of freshness protected by the Sierra Blanca mountains. A stone's throw from the picturesque old town of Marbella, the Club Med Magna Marbella imposes its design structure full of vegetation amidst twelve hectares of terraced gardens
Sheraton Diana Majestic is an iconic Milanese hotel and a popular reference point for locals and international travelers seeking a glamorous location for their stay and events.
Resort Via Dante Alighieri 106 - 30016 - Lido di Jesolo (VE)
10 Meeting rooms
12 - 530 People
184 Rooms
From €
Almar Lido Jesolo, located in Lido di Jesolo, is characterized by 184 elegant and modern rooms, 4 F&B Outlets, 10 different meeting rooms and the awards-winning Almablu Spa.
Hotel Piazza di S. Paolino, 1 - 50123 - Firenze (FI)
3 Meeting rooms
12 - 80 People
170 Rooms
From €
The design of 25hours Hotel Piazza San Paolino in Florence’s Santa Maria Novella district is eclectically inspired by Dante’s Divine Comedy. CECCHINI IN CITTÀ restaurant is the lively centre of the hotel. A Negroni bar and an Alimentari complete the culinary offering. Inhouse Cinema Paradiso shows curated movies.