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-22:2026-11-22' 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 ('17294') )
) 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.
Unfortunately no tours were found.
Unfortunately no cruises were found.
Unfortunately no car rentals were found.
Istanbul (Turkey) & Dubai (UAE)7 days / 6 nights
Experience the ultimate blend of luxury and history with our
Dubai Turkey tour packages from Pakistan. Explore Dubai’s iconic Burj Khalifa, Dubai Mall, and vibrant city life. Then, discover Turkey’s ancient wonders, including Istanbul’s Hagia Sophia, Blue Mosque, and Topkapi Palace, and Cappadocia’s breathtaking landscapes.
Price: PKR 284999 per adult in double occupancy
Inclusions:
• UAE visa fee
• Dubai travel insurance
• Meet & greet at Istanbul and Dubai International airports
• 3 night’s accommodation in 4-Star hotel at Istanbul
• 3 night’s accommodation in 4-Star hotel at Dubai
• Daily breakfast at hotel
• Full day Istanbul city tour with lunch Hagia Sophia, Blue Mosque, Grand Bazaar, Hippodrome on SIC
• Return transfer from Istanbul airport to hotel by private vehicle
• Return transfer from Dubai airport to hotel by private vehicle
