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:2020-10-28:2022-10-28' 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','wpforms_log','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','wpforms_log','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
Location: The hotel is located in the Incekum region 22km to Alanya and 98km from Antalya airport. .
Accommodation: Total number of rooms 330. Luxury room (30 - 32m², one bedroom with French bed + 1 single bed, bathroom, max.2 + 2pax), Family room (50m², two bedrooms in the middle, one bathroom, max 4 + 1pax), Fantasy room (55m², one bedroom, one bathroom, large terrace with Jacuzzi, max.2pax) and four rooms for disabled guests. All rooms are equipped with private bathroom with shower, hairdryer, separate air-conditioning system, mini bar (water and refreshment upon arrival, later only water and mineral water), coffee and tea storage, safes, Satellite TV and music channels, laminated floors and a balcony. WI-FI connection in the rooms is free of charge.
Service: Ultra all inclusive - Inclusive buffet, open for breakfast, late morning, lunch, snacks during the day, dinner, late night snack, all local and non-alcoholic drinks and some imported standards, fresh orange juice for breakfast, ice cream during certain hours, restaurants A'la Carte with advance reservation and only once in one during stay 7 nights. Not included: all types of imported drinks, fresh fruit juices, Turkish coffee, all bottled drinks, room service, second use of A'la Carte restaurants ..
CONTENTS: The main open buffet restaurant, Restaurants A'la Carte - Ottoman - Turkish Cuisine, Bella Azura - Italian cuisine, zucchini, bars near the pool and around the hotel complex, Disco club. The doctor, laundry and dry cleaning, hair cabinet, telephone, fax, internet corner, computer games, shopping center, rent a car are extra charge. Wi-Fi internet throughout the hotel is free of charge.
PLAZA: Private hotel beach - send and pebble, (there is a tunnel under the road to the beach), with sun beds, sun umbrellas and beach towels free of charge.
SPORTS AND ENTERTAINMENT: Open and closed pools, two water slides, fitness center, Turkish bath, sauna, tennis courts, aerobics, beach volleyball, table tennis. At extra charge: water sports, massage, tennis court lighting, tennis lessons, billiards. Entertainment programs during the day, show the evening programs (Hotel Annabella Diamond). Mini-club for children from 04-12 years old (Hotel Anabella Diamond).