SELECT SQL_CALC_FOUND_ROWS wpyq_posts.*, (
SELECT SUM(rooms_available) rooms_available FROM (SELECT IFNULL(SUM(room_count), 0) rooms_available, availabilities.accommodation_id FROM wpyq_byt_accommodation_vacancies availabilities INNER JOIN (
select d.the_date from
(
select adddate('2024-12-08',t4.i*10000 + t3.i*1000 + t2.i*100 + t1.i*10 + t0.i) the_date from
(select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t0,
(select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t1,
(select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t2,
(select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t3,
(select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t4
having the_date between '2024-12-08' and '2026-12-08'
ORDER BY the_date
) d
where DATE(d.the_date) >= DATE(CURDATE())
group by d.the_date
order by d.the_date
) possible_dates ON (possible_dates.the_date >= DATE(availabilities.start_date) AND possible_dates.the_date < DATE(availabilities.end_date)) WHERE 1=1 AND ('2024-12-08' BETWEEN start_date AND end_date OR start_date <= '2026-12-08') AND end_date >= '2024-12-08' GROUP BY possible_dates.the_date, availabilities.accommodation_id ) as ra WHERE accommodation_id = wpyq_posts.ID ) rooms_available , (
SELECT IFNULL(SUM(rooms_booked), 0) rooms_booked FROM ((SELECT IFNULL(SUM(bookings.room_count), 0) rooms_booked, bookings.accommodation_id, possible_dates.the_date FROM wpyq_byt_accommodation_bookings bookings INNER JOIN (
select d.the_date from
(
select adddate('2024-12-08',t4.i*10000 + t3.i*1000 + t2.i*100 + t1.i*10 + t0.i) the_date from
(select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t0,
(select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t1,
(select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t2,
(select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t3,
(select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t4
having the_date between '2024-12-08' and '2026-12-08'
ORDER BY the_date
) d
where DATE(d.the_date) >= DATE(CURDATE())
group by d.the_date
order by d.the_date
) possible_dates ON (possible_dates.the_date >= DATE(bookings.date_from) AND possible_dates.the_date < DATE(bookings.date_to)) AND IFNULL(woo_status, '') IN ('pending','on-hold','completed') WHERE 1=1 GROUP BY possible_dates.the_date, accommodation_id ) as rb, (SELECT MIN(start_date) min_start_date, MAX(end_date) max_end_date, accommodation_id FROM wpyq_byt_accommodation_vacancies GROUP BY accommodation_id) min_max_available_dates ) WHERE rb.accommodation_id = wpyq_posts.ID AND min_max_available_dates.accommodation_id = wpyq_posts.ID AND rb.the_date >= min_max_available_dates.min_start_date AND rb.the_date < min_max_available_dates.max_end_date ) rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM wpyq_postmeta price_meta2 WHERE price_meta2.post_id=wpyq_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2024-12-08:2026-12-08' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM wpyq_postmeta price_meta3 WHERE price_meta3.post_id=wpyq_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM wpyq_posts
WHERE 1=1 AND wpyq_posts.post_type = 'accommodation' AND ((wpyq_posts.post_status = 'publish'))
GROUP BY wpyq_posts.ID HAVING 1=1 AND rooms_available > rooms_booked AND rooms_available >= 1
ORDER BY accommodation_price ASC
LIMIT 0, 24
Kelebek hotel is Family run and having just 22 rooms we pride ourselves on friendliness and guest satisfaction, which over the last 33 years has resulted in many repeat guests becoming family friends.
Situated in Kalkan town centre the apartments are within easy walking distance to restaurants, the town beach, shops, restaurants, bars and weekly market.
Newly renovated 2 bedroom apartments. Situated in Kalkan town centre the apartments are within easy walking distance to restaurants, the town beach, shops, restaurants, bars and weekly market.
Situated across the road from The Kelebek hotel they offer comfort and space for relaxing holiday you are looking for and also be able to use facilities in the hotel etc. bar and restaurant Easy Walking distance to Town centre of Kalkan On Market street.
Town centre 5 bedroom 4 Bathroom villa. All rooms are good size 3 double rooms 1 of them ensuite bathroom and 2 single rooms 1 of them ensuite bathroom . And 2 Shared bathrooms Big garden and big swimming pool.