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: Hotel Rixos Premium is located in the pine and lisa part along the Mediterranean Sea in Belek region, 50km away from Antalya and 40km away from Antalya International Airport.
Setting: The hotel possesses a total of 700 rooms and pool suits. Luxury rooms (37m², main building, including 50 connected and 6 for disabled people, sea or garden view, one room, one bathroom, max.2 + 1pax), Family suits (49m², main building, two rooms (94m², main building, one bedroom with French bed and jacuzzi, bathroom, max.4pax), luxury suits (73m², main building, one bedroom with double bed, one bedroom, one bedroom (64m², located in the garden around the lake and river, two bedrooms, two bathrooms, max.4pax - 15 rooms are with direct access to the swimming pool) , the legend fits garden view (64m², is located in the garden around the lake and river, two bedrooms, two bathrooms, max.4pax), Queen Suite (195m², main building, one bedroom with mat bed and Jacuzzi, living room and spacious terrace), Royal Premium Suite (315m², main building of two bedrooms with double bed and Jac uzzi, living room, living room, kitchen and spacious terrace). Standard equipment in the rooms: private bathroom with shower and bathtub, hairdryer, climate, direct phone, mini bar (water, mineral water, soft drinks, energy drinks, milk, chocolate, beer, refilled daily chips) coffee and tea Set, safe box, marble floor and carpet, balcony, LCD TV, satellite TV and music channels, Wi-Fi internet connection is free of charge in all hotels and rooms.
Service and contents: All inclusive - open buffet for breakfast, lunch, dinner served in the Mozaik restaurant. Chef Restaurant (Vegetarian & Sushi), Churrasco Restaurant (South American Cuisine), Restaurant L'Amante - A'la Carte Restaurant Frenchz, Italian Restaurant La Rosetta, La Lezar Restaurant, Turkish A'la Carte Restaurant, Ying Restaurant - Restaurant Vila - only for villa guests, BBQ Restaurant, Fishbon Restaurant, Fish Restaurant A'la Carte, Meyhane Restaurant - Greek and Turkish Cuisine, Restaurant 1001 with - special decorations, dresser, live music (additional payment). Restaurant Hum - Hum is a special children's restaurant located in the Rixy Kids Club. The food yard - with various fast food services. Bars serving alcoholic and non-alcoholic beverages are along the entire hotel complex. For A'la Carte restaurant reservations are required. Additional supplements include: Premium Alcoholic Beverages, special imported wines, cigars, room service between 00.70-02.00, 1001 Nights restaurant, Maxi Bar, some of the special dishes such as lobster, sea shrimp in restaurants A ' La Carte, two-person dinners, dinner in pavilions and lakes, Ying Restaurant, Turkish coffe house, exclusive dinner at A'la Carte Restaurant, Dinner Show, Medical Services, SPA center, telephone, fax, internet, photocopying, cleaning clothes, rent a car, caretaker, hairdresser, shopping center are at extra charge.
Beach: The hotel has private beach 1000m long and 100m wide with two private scaffolds. Towels, beds and umbrellas are free of charge. Beach tents are with additional payment and advance reservation.
Sport and recreation: Open-air swimming pool and swimming pools, swimming pools only for adults open 24 hours, new outdoor swimming pool near the beach (2002m²), gym, sauna, Turkish bath, Russian sauna, snow room, jacuzzi, tennis courts, squash, basketball, volleyball, (under the guidance of 18 professional trainer opportunities for Crossfit, Spinning, Zumba, Yoga, Pilates, Tai Chi, and many others for 24 hours a day), Survivor Park. At extra charge are: SPA & Wellness Center, all types of massage and body treatments, beauty center, water sports, tennis courses, diving, remote control cars, computer games, game lands, game station, billiards American and Russian,, Rixos hobby center worker and bowling. There is a special team that organizes your holidays in the best way. During the day, there are unforgettable activities, sports, racing and evenings. During the summer there are special organizations such as the Beach Party, Lunch and Gala, the October Festival, French Street Square - the effects of rain and thunder three times a day, the show of the fountain with the fountain show every hour for 5 minutes from 08:00 to 23:00 , Shoe Center - with two international performances per week, and live music every day. For children and teenagers there is a Rixy club, a children's playground, a children's pool, a children's restaurant, mini-disc. The gaming center - for each room 10 free tickets after arrival. There is free shuttle service and free entrance to the Land of Legends theme park for hotel guests.