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 Evrenseki region, 5 km from Side and 48 km from Antalya Airport.
RENDITION: Total number of rooms 450. Standard room 351 (52m², one bedroom and one bathroom, max.3 + 1pax), Duplex family room 20 (70m², one upstairs bedroom and bathroom downstairs for children and bathroom with shower, door to the parents' room, max 4pax), family room with connecting door 10 (77m²; two bedrooms, bedroom, no door between rooms, max.2 + 2pax), Junior Suita 26 (85m², one bedroom, living room, bathroom with Jacuzzi, sea view room, max.3 + 1pax), Taj Mahal family rooms 38 (77m², two bedrooms, and corridor, bedroom is with bathroom with Jacuzzi, another bedroom is connected to the corridor and have a shower, max.4pax) and 5 rooms for people with disabilities. The rooms are on the sea side, overlooking the sea and garden views, private bathrooms with shower and bathtub, hairdryer, central air conditioning system, direct dial telephone, mini bar (fresh drinks and refilled beer every day), kettle , set for coffee and tea, sheets, carpeted floors, LCD TV with satellite programs, balcony.
SERVICE: Ultra All Inclusive - open buffet for breakfast, late morning, light meals, lunch, afternoon dessert, dinner, light meals, all local alcoholic beverages and standard alcoholic beverages, no open ice cream service during dinner, mini bar in the rooms. Not included: luxurious imported drinks, all local and imported wines, A'la Carte restaurants with advance reservation with extra charge, fresh fruit and vegetable juices, imported champagne, room service.
CONTENTS: Main restaurant with open buffet, A'la Carte restaurants - Gusto Della Note - (Italian cuisine), La Filika - (Seafood) and Agra - (Mexican and Indian cuisine). Free of charge are: doctor, washing and ironing, baby caretaker, hairdresser, telephone, fax, internet, shopping center, rent a car. The low-speed Internet WiFi is available free of charge.
PLAZA: The hotel has a private sandy beach, 300m from the hotel, beds, umbrellas and beach towels are free of charge
SPORTS AND SPORTS: Outdoor and indoor swimming pools for adults and children, Aqua park with 9 water slides, Turkish bath, sauna, fitness center, steam bath, table tennis, beach volleyball, basketball are free of charge. Free of charge: Massage, water sports, SPA & Wellness, bowling, billiards. Entertainment programs during the day, show programs, entertainment programs and Mini Club for children from 04 to 12 years. Aqua Parka, Luna Park and Tennis court are used together with the rooftops of the Royal Dragon Hotel.