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_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 72, 9
Spazio per eventi Piazza Luigi Rossi 2-10023- Pessione (TO)
1 Meeting rooms
10 - 180 People
4 Rooms
From €
CASA MARTINI is the ideal reception venue. Located in Pessione, at Martini & Rossi’s historic premises, it marks the meeting point between the company’s traditions and future.
The Estate represents a typical example of the ancient farms of the Maremma: a group of stone buildings and its Manor Villa form the old village of the Montecucco Estate with the Church of S. Pietro S. Antonio Abate in the centre. The historic cellar from the 1300s and the ziri dating back to the 1600s tell the story of our products which you can savor in the tasting room or inside our "I Granai" restaurant.
Hotel Désirée, founded in 1957 by famous opera singer Tancredi Pasero, is located in the enchanting and exclusive Bay of Spartaia, surrounded by luxurious Mediterranean vegetation, in a 7-hectare private park.
The perfect place to let yourself be pampered by our staff. Relaxing at our beach or immersed in the green that surrounds our seawater pool.
Hotel Lungarno del Tempio 44 - 50121 - Firenze (FI)
13 Meeting rooms
10 - 300 People
327 Rooms
From €
FH55 Grand Hotel Mediterraneo, located along the Arno River in Florence and just a short walk from Santa Croce and the city’s main landmarks, is perfectly suited for both leisure and business stays.
Located in the historic center of Florence, Grand Hotel Cavour offers 98 rooms, 3 meeting rooms with a maximum capacity of 70 people, a restaurant and a spectacular terrace with a view.
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.
Grand Hotel Poltu Quatu is a 5-star hotel located on the Costa Smeralda, which has 143 rooms and 66 apartments furnished with great style and elegance. The Hotel has three restaurants, private beach, (reachable by shuttle service) swimming pool, wellness center, fitness room, tennis and padel courts and a modern conference center with 7 modular rooms.
Hotel Via Europa 100 - 63821 - Porto Sant'Elpidio (FM)
1 Meeting rooms
10 - 150 People
211 Rooms
From €
La Risacca Family Camping Village offers the right environment to enjoy nature where the scents of the sea and the mountains combine, creating a unique sensation
Positioned between the sea and the splendid landscapes of a Pialassa rich in suggestive natural views, the Sole Family Camping Village is suitable for families but is also perfect for sports groups, with the utmost attention to accessibility.
