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 Turkler region, 15 km from Alanya and 100 km from Antalya Airport
SETTING : The hotel has a total of 804 rooms. The rooms in the hotel building are with superior standard 634 (37m², one bedroom, one bathroom, max.3 + 1pax); family room 126 (50m², two bedrooms with a door in the middle, a bathroom, max.4pax); 8 rooms for guests with disabilities; Garden family rooms 16 (53m², one bedroom, one room of the day, one bathroom, direct access to the pool, max.3 + 1pax); VIP Villas (120m², located around the private pool, three bedrooms, dayroom, two showers and a bathroom with Jacuzzi, three balconies, max.4 + 1pax). All rooms are with private bathroom with shower, hairdryer, central air conditioning system, direct dial telephone, mini bar (water and mineral water recharge every day), cash register, satellite TV and channels musical, laminate floors and balconies.
SERVICE : Ultra All inclusive - open buffet for breakfast, late breakfast, lunch, light afternoon meals, light meal meals in the late hours, all standard alcoholic and non-alcoholic drinks from local and local imports are free of charge, ice cream during the specified hours A'la Carte restaurant with advance reservation (only once during stay), meals and drinks, Beach Bar from 10.00 to 18.00. Not included: all imported drinks, fresh fruit juices, all bottled drinks, room service, imported champagne and special wines .
CONTENTS : Main restaurant with open buffet A'la Carte restaurants: Turkish Cuisine Italian Cuisine, Fish Restaurants, bars along the catering complex. Free of charge are: doctor, clothes washing, babysitter, hairdresser, telephone, fax, internet (in Lobby is free of charge, while in the paid room), shopping center, rent a car. .
PLAZA : The hotel has private beach - sand and pebble, beds, umbrellas and beach towels are free of charge. The beach is 550m away from the hotel and every 15 minutes is offered shuttle service to the beach and back to the hotel.
SPORTS AND SPOTS: Outdoor and indoor pools for adults and children, water slides, Turkish bath, sauna, fitness center, tennis courts, table tennis are free of charge. Free of charge: Massage, water sports , Wellness & SPA Center, billiards.
Entertainment programs during the day, racing near the pool and on the beach, evening show programs. Mini Clubs for children aged 04 to 12 years.