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-04-20:2026-04-20' 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 ('7747') )
) 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
Long Beach Luxury Resort
Coastal Road, Belle Mare
From
CHF
Un cadre magnifique avec un bord de mer avec plage de sable fin.
Trou aux Biches Beachcomber Golf Resort & Spa
Trou aux Biches
From
CHF
15% de réduction jusqu'au 31.10.2024
Unfortunately no tours were found.
Unfortunately no cruises were found.
Unfortunately no car rentals were found.