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-01-17:2023-01-17' 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 Beldibi region 25 km from Antalya and 50 km to Antalya Airport. It is spreading on the 250,000m² surface with 720m long coastline.
Setting: The hotel possesses a total of 1094. All rooms have the same contents: private bathroom with bath, shower and hairdryer, central air-conditioning system, direct dial telephone, daily refreshing mini bar with refreshing water and beer, safe, satellite TV and music channels, internet connection (free Wi-Fi standard), service, bathrobes and slippers, carpet flooring and balcony. Standard rooms, 871 - including 134 connecting rooms + 38 rooms without balcony + 7 rooms for people with disabilities, (38m², max.3 + 1pax, main building or terrace houses), Family suits (75m², two bedrooms (85m², two bedrooms, two bathrooms, max.4 + 2pax), Jacuzzi Room (35m², standard rooms have Jacuzzi, main building, max.2 + 1pax), suites (53m², bedroom, two bathrooms, two LCD TVs, main building, max.5 + 1pax), King Suit (85m², one bedroom, one bedroom, sea view Jacuzzi, two bathrooms, two TVs, Terrace Family Houses (58m², Terrace area, one bedroom for parents, one bedroom for children, two bathrooms, two LED TVs, downstairs - terrace, upper rooms have balconies, max.3 + 2pax), Family Lake Houses (72m², Terrace Terrace and main building, two bedrooms, one hall, two bathrooms, three LED TVs, (72m², Terrace and postal building, two bedrooms, one hall, two bathrooms, 3 LED TVs, direct from the pool, max.6pax) , Villa Lake Houses (72m², two bedrooms, one bedroom, two bathrooms, three TVs, direct access to the pool from (51m², one bedroom, a bathroom with jacuzzi, max. 2px), luxury pool suits (63m², large living room with one bedroom, one hall, two bathrooms and Jacuzzi, max.2pax) and Grand deluxe Villas (those villas are with entry and garden, with three bedrooms, annex kitchen, living room, bathroom on each floor, Jacuzzi, swimming pool, private van service).
Service: All Exclusive All Inclusive - breakfast, late morning, light meals in the morning, afternoon and evening, A'la Carte restaurants with advance reservation and extra charge, local alcoholic and non-alcoholic beverages, All drinks and meals in the red marked menu is at extra charge. Maxi bar and room service.
Content: Main restaurant with open buffet, A'la Carte restaurants (Italian, Turkish, Japanese, Chinese, Tepenyaki, Sea Food, Kebab House, Mexican, Snack Internacional). Bars along the hotel complex, special children's bars, Disco bar and Night Club. Doctor, child custody, dry cleaning and dry cleaning, telephone, fax, internet, hairdresser and beauty center, shopping center, rent a car, are at extra charge.
Beach: The hotel is near the long 720m long beach, with two gates and sandy. Beach beds, umbrellas and towels are free of charge. Private beach tents at the beach are at extra charge.
Sports and recreation: Includes a huge Aqua Park with ten toboggans in the water, 16 different indoor and outdoor pools with various sports, soccer field, fitness center, table tennis, basketball, gunshot wrecks, water sports are free of charge. At extra charge are: motorized water sports, tennis courts and equipment, diving school, bowling alley, go-carting, paintball. Entertainment programs are organized by the professional team. During the day time various competitions, evening colorful color programs, dance shows, live music, theme evening. For children there is a Rixy and Kid kingdom, spread over 20,000m², children's restaurants, swimming pools and aqua park for children, a playground, disco, movie theaters, with special programs during the day and evening.