SELECT 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=wp_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2024-12-21:2026-12-21' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM wp_postmeta price_meta3 WHERE price_meta3.post_id=wp_posts.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 )
WHERE 1=1 AND (
( wp_postmeta.meta_key = 'accommodation_location_post_id' AND wp_postmeta.meta_value IN ('476') )
) AND wp_posts.post_type = 'accommodation' AND ((wp_posts.post_status = 'publish'))
GROUP BY wp_posts.ID HAVING 1=1
ORDER BY wp_posts.post_title ASC
Unfortunately no accommodations were found.
DAILY TROY TOUR BY BUS
ISTANBUL TO TROY
From
€
Explore the legendary ancient city of Troy on a full-day tour from İstanbul. Learn about Trojan mythology and see the ruins of the UNESCO World Heritage site, as you walk in the footsteps of Achilles, Hector, Helen, and Paris.
2 Days
GALLIPOLI & TROY 2 DAYS BY BUS
ISTANBUL TO GALLIPOLI & TROY
From
€
Explore the legendary ancient city of Troy and Gallipoli's World War I battlefields on the same day. You'll learn about the history of Troy, which may have been the first world war, before visiting Gallipoli, where the last "gentleman's war" took place.
Unfortunately no cruises were found.
Unfortunately no car rentals were found.