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:2025-06-21:2027-06-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 ('458') )
) 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.
PRIVATE MINIVAN
15 DAY TURKEY ITINERARY WITH PRIVATE MINIVAN
ISTANBUL TO EPHESUS & PAMUKKALE & BODRUM & ANTALYA & CAPPADOCIA
From
€
15 DAY ISTANBUL TO EPHESUS & PAMUKKALE & BODRUM & ANTALYA & CAPPADOCIA ITINERARY. Travel Privately with Chauffeured Minivan / Minibus from ISTANBUL TO EPHESUS & PAMUKKALE & BODRUM & ANTALYA & CAPPADOCIA 15 DAYS / 14 NIGHTS PRIVATE TOUR. Enjoy seamless travel with VIP Minivan, airport transfers & expert-guided tours.
PRIVATE
3 DAYS ITINERARY ISTANBUL TO CAPPADOCIA / PRIVATE TOUR
ISTANBUL TO CAPPADOCIA
From
€
3 DAY CAPPADOCIA ITINERARY. Unforgettable escape from ISTANBUL TO CAPPADOCIA 3 DAYS / 2 NIGHTS PRIVATE TOUR. Best to cover most of the sites & valleys in Cappadocia. Enjoy seamless travel with included flights, private transfers, and expert-guided tours.
PRIVATE
4 DAYS ITINERARY ISTANBUL & CAPPADOCIA / PRIVATE TOUR
ISTANBUL TO CAPPADOCIA
From
€
4 DAY ISTANBUL to CAPPADOCIA ITINERARY is the best option for the guests who want to cover the most of Istanbul & Cappadocia in 4 days. It includes tour guide fees, all transfers, flight tickets, hot air balloon (optional) and a Bosphorus Dinner Cruise Tour.
PRIVATE
From
€
4 DAY ISTANBUL, CAPPADOCIA & EPHESUS ITINERARY. Unforgettable escape from ISTANBUL TO CAPPADOCIA & EPHESUS 4 DAYS / 3 NIGHTS PRIVATE TOUR. Enjoy seamless travel with included flights, airport transfers, hotel accommodation and expert-guided tours.
PRIVATE
6 DAYS ITINERARY ISTANBUL & CAPPADOCIA & EPHESUS / PRIVATE TOUR
ISTANBUL TO CAPPADOCIA, EPHESUS & PAMUKKALE
From
€
6 DAY TURKEY ITINERARY is the best option for the guests who want to cover the most of Istanbul, Ephesus, Pamukkale & Cappadocia in 6 days. It includes tour guide fees, all transfers, flight tickets, hot air balloon (optional) and a Bosphorus Dinner Cruise Tour.
PRIVATE MINIVAN
9 DAY TURKEY ITINERARY WITH PRIVATE MINIVAN
ISTANBUL TO CAPPADOCIA & EPHESUS & PAMUKKALE WITH MINIVAN
From
€
9 DAY ISTANBUL, CAPPADOCIA & EPHESUS & PAMUKKALE ITINERARY. Travel Privately with Chauffeured Minivan / Minibus from ISTANBUL TO CAPPADOCIA & EPHESUS & PAMUKKALE 9 DAYS / 8 NIGHTS PRIVATE TOUR. Enjoy seamless travel with VIP Minivan, airport transfers & expert-guided tours.
ATTRACTIONS
ATV Motorbike Riding in Cappadocia
Cappadocia
From
€
Experience the thrill of riding an ATV quad bike across stunning landscapes in search of the magic of the Cappadocia region. Perfect choice for adventure-seekers!
Popular
Cappadocia Hot Air Balloon Flight
Cappadocia
From
€
Magical, surreal, and absolutely breathtaking—there’s no better way to describe Cappadocia. Soaring above its unique landscape in a hot air balloon is a once-in-a-lifetime experience you simply can’t miss!
ATTRACTIONS
Horseback Riding in Cappadocia
Cappadocia
From
€
Come along for a full day outdoor adventure with a thrilling guided horseback riding tour in Cappadocia’s fairy-tale-like surroundings. Gallop through the valleys and mountains on horseback.
ATTRACTIONS
Jeep Safari in Cappadocia
Cappadocia
From
€
Embark on a journey in a 4 x 4 jeep through the amazing landscapes of Cappadocia, where magic and mystery truly come alive. Pass through Cappadocia's top attractions and explore the region.
VIP
VIP Hot Air Baloon Flight in Cappadocia
Cappadocia
From
€
Glide over the fairy chimneys and rock-cut houses of Cappadocia on a 1-hour hot air balloon flight. A perfect occasion for marriage proposals or anniversaries.
Unfortunately no cruises were found.
Unfortunately no car rentals were found.