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-11:2027-10-11' 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 ASC
LIMIT 63, 9
Hotel business Via Manzoni 99/B - 20811- Cesano Maderno (MB)
4 Meeting rooms
2 - 90 People
134 Rooms
From €
4-star hotel in the heart of Brianza with large meeting spaces, refined restaurant and ample parking. In a strategic position to reach Milan, Monza and Lake Como.
Hotel Lungomare Stati Uniti, 2 - 16011 - Arenzano (GE)
4 Meeting rooms
4 - 200 People
109 Rooms
From €
Grand Hotel in Arenzano nestled in the heart of the Ligurian Riviera has 109 rooms and a conference center consisting of a 220 m2 plenary room and four naturally lit sub-rooms.
Available for breakfasts and business lunches are the elegant La Veranda restaurant, a large terrace and the Maraja pool bar.
Spazio per eventi VIA MARISA BELLISARIO 300-00155-Roma (RM)
4 Meeting rooms
2 - 400 People
148 Rooms
From €
The countryside in the city.
With its unmistakable red walls and galvanized metal interiors, the Borgo della Mistica stands among the hills and olive trees of the Roman countryside, bordered by the Alessandria Aqueduct. Our landscape cuisine and a vast selection of natural wines lead you among the flavors and smells of the countryside for an aperitif in the cellar, an à la carte dinner in our restaurant or a Sunday in the open air.
Thanks to the swimming pool surrounded by greenery and an event space with a lively and contemporary offer, Borgo della Mistica is your country home. In your eternal city.
Restaurant Ristorante Via dei Brunelleschi 1 - 50123 - Firenze (FI)
4 Meeting rooms
20 - 400 People
From €
Large and elegant location situated in the city center with open space design, stage, bar and quality cuisine as well as technological equipment suitable for any tipe of event.
Resort Via dei Ginepri, 3 - 09049 Villasimius (SU)
4 Meeting rooms
2 - 300 People
238 Rooms
From €
Nestled in an idyllic bay in southern Sardinia, the Almar Timi Ama Resort & Spa offers 238 rooms, 4 meeting rooms, extensive spaces for events and exhibitions, 3 restaurants, and a Thalasso Spa.
L’FH55 Grand Hotel Palatino è la scelta migliore per un evento all’insegna del comfort e della tranquillità nel cuore di Roma. Posizione straordinaria: a pochi passi dal Colosseo e dal Foro Romano.
Hotel P.za Ventiquattro Maggio, 8 - 20123 - Milano (MI)
4 Meeting rooms
15 - 150 People
32 Rooms
From €
Aethos is a new concept of modern club, rooted in hospitality, with dynamic spaces and a global network designed to promote connection, creativity and belonging.
Resort Località San Vigilio, 1 - 25010 - Pozzolengo (BS)
5 Meeting rooms
5 - 300 People
150 Rooms
From €
Crossing the entrance of Garda Hotel San Vigilio Golf you immerse yourself in a reality where modernity, efficiency and excellent standards of service blend with uncontaminated nature among rolling hills and rich vegetation.
Il Grand Hotel Des Bains è un hotel 5 stelle storico e in stile liberty sito nel centro città a 100 m dal mare. Ideale per soggiorni esclusivi, eventi aziendali e matrimoni.
