SELECT trvl57ch_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM trvl57ch_postmeta price_meta2 WHERE price_meta2.post_id=trvl57ch_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2024-05-05:2026-05-05' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM trvl57ch_postmeta price_meta3 WHERE price_meta3.post_id=trvl57ch_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM trvl57ch_posts INNER JOIN trvl57ch_postmeta ON ( trvl57ch_posts.ID = trvl57ch_postmeta.post_id )
WHERE 1=1 AND (
( trvl57ch_postmeta.meta_key = 'accommodation_location_post_id' AND trvl57ch_postmeta.meta_value IN ('7331','8826') )
) AND trvl57ch_posts.post_type = 'accommodation' AND ((trvl57ch_posts.post_status = 'publish'))
GROUP BY trvl57ch_posts.ID HAVING 1=1
ORDER BY trvl57ch_posts.post_title ASC
20% de réduction jusqu'au 31.03.2024 en Family vue jardin, ou en Deluxe Side sea View ou en Deluxe devant la piscine, en Club vue mer, en Club vue mer avec piscine privée.
Location de voiture pour vos visites dans les îles de Crète - Rhodes - Kos -Corfou–Zante–Athènes–Thessalonique–Kalamata-Mykonos-Santorin dès CHF 240.00