Trabzon located at the foot of naturally beautiful, woody Karadağ mountains in the eastern part of the Black Sea coast of Turkey.& offers numerous historical landmarks, evidences of the past grandeur of the Byzantine era
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 ('10736') )
) 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.
Tour Highlighted : From Islamabad-Karachi-Lahore-Istanbul-bursa-Trabzon-Black sea-eastern Turkey.
08 Days, 07 Nights Istanbul & Trabzon
Day 01 : Arrive IST/ SAW airport & transfer to hotel.
Day 02 : Full Day Istanbul Ottoman Relics and Byzantium Tour with Lunch
Day 03 : Full Day Bursa Cable Car + Shopping Tour with Lunch
Day 04 : Full Day Princess Island Tour with Lunch (with Electric car)
Day 05 : Transfer to airport for Flight to Trabzon. Arrive & transfer to hotel.
Day 06 : Full Day Ayder National Park Tour.
Day 07 : Full Day Uzungol Lake Tour.
Day 08 : Free time until transfer to airport to catch suitable flight to Istanbul. Arrive & catch home-bound flight. (WE WILL CHOOSE THE MOST SUITABLE FLIGHT!)