SELECT SQL_CALC_FOUND_ROWS wp_rh9xgp_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM wp_rh9xgp_postmeta price_meta2 WHERE price_meta2.post_id=wp_rh9xgp_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2021-04-15:2023-04-15' LIMIT 1), 0) accommodation_price FROM wp_rh9xgp_posts JOIN wp_rh9xgp_icl_translations wpml_translations
ON wp_rh9xgp_posts.ID = wpml_translations.element_id
AND wpml_translations.element_type = CONCAT('post_', wp_rh9xgp_posts.post_type) LEFT JOIN wp_rh9xgp_icl_translations wpml_translations_default ON wpml_translations_default.trid = wpml_translations.trid AND wpml_translations_default.source_language_code IS NULL WHERE 1=1 AND wp_rh9xgp_posts.post_type = 'accommodation' AND ((wp_rh9xgp_posts.post_status = 'publish')) AND ( ( ( wpml_translations.language_code = 'en' OR (
wpml_translations.language_code = 'en'
AND wp_rh9xgp_posts.post_type IN ( 'product' )
AND ( (
( SELECT COUNT(element_id)
WHERE trid = wpml_translations.trid
AND language_code = 'en'
) = 0
) OR (
( SELECT COUNT(element_id)
FROM wp_rh9xgp_icl_translations t2
JOIN wp_rh9xgp_posts p ON p.id = t2.element_id
WHERE t2.trid = wpml_translations.trid
AND t2.language_code = 'en'
p.post_status = 'publish' OR
p.post_type='attachment' AND p.post_status = 'inherit'
) = 0 ) )
) ) AND wp_rh9xgp_posts.post_type IN ('post','page','attachment','custom_css','customize_changeset','oembed_cache','user_request','wp_block','wpforms','wpb_safe-file','wpb_safe-metrics','wp-backitup_backup','wp-backitup_restore','wp-backitup_cleanup','location','extra_item','room_type','accommodation','tour','cabin_type','cruise','car_rental','product','product_variation','shop_order_refund','wpcf7_contact_form' ) ) OR wp_rh9xgp_posts.post_type NOT IN ('post','page','attachment','custom_css','customize_changeset','oembed_cache','user_request','wp_block','wpforms','wpb_safe-file','wpb_safe-metrics','wp-backitup_backup','wp-backitup_restore','wp-backitup_cleanup','location','extra_item','room_type','accommodation','tour','cabin_type','cruise','car_rental','product','product_variation','shop_order_refund','wpcf7_contact_form' ) ) GROUP BY wp_rh9xgp_posts.ID HAVING 1=1 ORDER BY wp_rh9xgp_posts.post_date DESC LIMIT 0, 3
POSITION: The hotel is located in the Kumkoy region, 6 km from Side and 65 km from Antalya Airport.
SETTING: The hotel possesses a total of 241 in three-story buildings. Standard rooms (25-35m², one bedroom, one bathroom, max.3 + 1pax), Family Room (45m², two bedrooms, bathroom, max.4pax). The rooms have private bathroom with shower, hairdryer, central air-conditioning system, direct dial telephone, mini bar (water and mineral water replenished every day), safe box (extra charge), laminate flooring, LCD TV with satellite programs , balcony.
SERVICE: All inclusive - open buffet for breakfast, late breakfast, lunch, afternoon cake, biscuits, meals, dinner, late night dinner, local alcoholic and local alcoholic drinks from 10.00 to 24.00, mini bar in rooms, ice cream during the hours certain, beach bar from 10:00 to 17:00, A'la Carte Restaurants with reservation at, Snack bar on the beach from 10:00 to 17:30, ice cream during certain hours. Not included: imported drinks, all imported and imported local wine bottles, imported champagne, Turkish coffee, fresh fruit juices, drinks at Disco club, room service. Not included: imported drinks, all wines of local and imported bottles, imported champagne, Turkish coffee, fresh fruit juices, room service, drinks at Disco club.
CONTENTS: The main restaurant for open buffet, Lobby, Pool and Beach bars. Doctor, babysitting, laundry and dry cleaning, shopping area, telephone, fax, internet corner and computer games, rent a car are extra charge. The WI-FI internet connection in the Lobby area is free of charge.
PLAZA: Private hotel beach, 750m from hotel, with sand, with sun beds, sun umbrella and beach towel free of charge.
SPORTS AND ENTERTAINMENT: Outdoor and indoor pools for adults and children, Aqua Park, tennis courts, basketball, gymnastics, beach volleyball, Turkish bath, sauna, steam room, Jacuzzi. At extra charge are: water sports, table tennis, bowling, billiards, all massages and treatments at the SPA center. Entertainment programs during the day from the pool and the beach, racing, in the evening show programs. Mini club for children from 4-12 years with special programs during the day and evening.