Tinos
SELECT wp_1091640_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM wp_1091640_postmeta price_meta2 WHERE price_meta2.post_id=wp_1091640_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2026-04-17:2028-04-17' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM wp_1091640_postmeta price_meta3 WHERE price_meta3.post_id=wp_1091640_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM wp_1091640_posts INNER JOIN wp_1091640_postmeta ON ( wp_1091640_posts.ID = wp_1091640_postmeta.post_id )
WHERE 1=1 AND (
( wp_1091640_postmeta.meta_key = 'accommodation_location_post_id' AND wp_1091640_postmeta.meta_value IN ('7308') )
) AND wp_1091640_posts.post_type = 'accommodation' AND ((wp_1091640_posts.post_status = 'publish'))
GROUP BY wp_1091640_posts.ID HAVING 1=1
ORDER BY wp_1091640_posts.post_title ASC
Tinos Beach Hôtel
Île Cyclades
From
$
Tínos est une île du nord des Cyclades grecques, dans la mer Égée méridionale. Elle se situe entre Andros et Mykonos.
Unfortunately no cruises were found.
Unfortunately no car rentals were found.