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-19:2023-04-19' 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, 5km from Side and 48km from Antalya airport.
Location: The hotel possesses a total of 579 rooms, Superior Standard rooms 414 (48m²; 3 + 1pax), Duplex family rooms 48 (80m², upstairs, a bedroom and a bathroom, downstairs a children's room and a bath with shower, no door in the middle, max.4pax), family room with connecting door 35 (72m², two sleeping rooms with partition door, one bathroom, max.2 + 2pax), Junior Suita 20 (70m²; one bedroom, one living room, two bathrooms, a bathtub in the bedroom, max.2 + 1pax), Suita Alhambra 60 (63m², a bedroom, part of a living room, a bathroom, max.2 + 1pax) and 5 rooms for people with disabilities. Rooms have a partial view of the sea, directly by the sea or the garden. All rooms have private bath / shower, hairdryer, central air conditioning system (and works according to climatic conditions), direct telephone, mini bar (drinks and beer, refills every day), cash box, LCD TV, satellite programs, balcony .
Service: Ultra All Inclusive - open buffet for breakfast, late morning, light meals in the morning, lunch, afternoon cakes, biscuits, light meals, dinners, light meals in the late hours, A'la Carte restaurant on reservation advance and once a week stay (other times A'la Carte are paid), all local alcoholic and non-alcoholic drinks and from import, ice cream at dinner, mini bar in the room. Free of charge: luxurious imported drinks, all local and imported bottled wines, fresh fruit and vegetable juice, imported champagne, room service.
Contents: Main restaurant with open buffet, A'la Carte restaurants - Fettucini - Italian cuisine, Kuzine - Turkish cuisine, Captain - Fish restaurant, Miyako - Cuisine from the Far East and La Viva Fiesta - Mexican cuisine, bars along the catering complex. Free of charge: doctor, caretaker, clothes washing and dry cleaning, shopping center, telephone, fax, internet, computer games, rent a car. WI-FI internet in the lobby is free of charge.
Beach: The hotel has private sandy beach, beds, sun umbrellas, towels are free of charge.
Sport and recreation: Outdoor and indoor pool for adults and children, 8 water slides, Luna Park, fitness center, Turkish bath, sauna, tennis court, beach volleyball, basketball, ping-pong are free of charge . Free of charge: massage, SPA and beauty salon, lighting and equipment for tennis, bowling, billiards, all water sports. Daytime entertainment programs, racing, show programs, Luna Park and mini club for children from 04-12 years.