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-11-21:2026-11-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 ('439') )
) 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.
Popular
7 Days İstanbul – Cappadocia – Ephesus – Pamukkale Tour
Istanbul, Cappadocia, Ephesus, Pamukkale
From
€
Get this great opportunity to explore the highlights of Istanbul, Cappadocia, Ephesus, and Pamukkale. Discover Turkey's rich history, stunning landscapes, and vibrant culture all in one unforgettable journey!
Private
From
€
Get lost in the labyrinth of history. Discover the most important highlights of Byzantium and Ottoman Empires with absolute VIP privilege.
Regular
From
€
Get lost in the labyrinth of history. Discover the most important highlights of Byzantium and Ottoman Empires.
Popular
Carpet Factory Visit
Istanbul, Cappadocia
From
€
Factories are the best places to buy carpets. They are cheaper, they have all the sizes, designs and colors. You can touch them, feel them and maybe buy some of them…
VIP
Helicopter Tour Over İstanbul
Istanbul
From
€
İstanbul is a beautiful city and even more beautiful when viewed from the sky. This helicopter tour over the magical İstanbul sky is very convenient for couples and families who want to celebrate their special days.
Deal
Istanbul Discovery by Private Car
Istanbul
From
€
Spoil yourself and your beloved ones in a private Mercedes Vito van. Your local driver will take you to wherever you desire to go.
Istanbul Two Continents Regular Tour
Istanbul Asian Side
From
€
İstanbul, the city that lies in two continents with Bosphorus glueing them, has a lot to offer to its visitors. Let’s discover the major highlights of İstanbul that spread over two continents.
Shopping
Jewelry Factory Visit
Istanbul
From
€
Factories are the best places to buy gold and jewelry. They are cheaper, they have all the sizes, designs and varieties. You can try them, feel them and maybe buy some of them…
Shopping
Leather Factory Visit
Istanbul
From
€
Factories are the best places to buy leather and für. They are cheaper, they have all the sizes, designs and colors. You can touch them, try them and maybe buy some of them…
Unfortunately no cruises were found.
Unfortunately no car rentals were found.