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 564 rooms. Standard 408 (40m², one bedroom and a bathroom, max.3 + 1pax), Duplex Family Room 104 (60m², upper floor one bedroom and a bathroom, and downstairs one childrens bedroom and one bathroom with shower, no partition door, max.4pax), family room with dividing door 35 (60m² two bedrooms, a bathroom, is a door between max.2 + 2pax rooms), Junior Suite 14 (70m²; a bedroom, a living room, two bathrooms and a rooftop bathtub in the room, max.2 + 1pax), King Suite 3 (100m², two bedrooms, one living room, two bathrooms with a tub in room, max.2 + 2pax) and 5 rooms for disabled people. The rooms have direct or partial view of the sea and overlooking the garden, all rooms have private bath with shower / bath, hairdryer, central air conditioning system that works depending on weather conditions, direct telephone, mini bar (juices and beers, refilled daily), cash dispenser, LCD TV with satellite programs and a balcony.
Service: Ultra All Inclusive - open buffet for breakfast, late morning, light meals in the morning, lunch, afternoon cakes, biscuits, light meals, dinners, late meals easy meals, A'la Carte restaurants on reservation preliminary and once a week stay (the second time the 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: Imported luxury drinks, all local and imported wines, fresh fruit and vegetable juice, imported champagne, room service.
Contents: Main restaurant with open buffet, A'la Carte restaurants: Dulciena - Italian cuisine, Firuze - Turkish cuisine, Dorado - Seafood and Zen - Far East cuisine, bars along the hotel complex. Free of charge: doctor, guardian of children, clothes and dry cleaning, shopping center, telephone, fax, internet and computer games, rent a car.
Beach: The hotel has private sandy beach, umbrellas, beds and towels are free of charge.
Sports and recreation: The outdoor and indoor pool for adults and children, Aqua Park with 9 water slides, fitness center, Turkish bath, sauna, tennis court, beach volleyball, basketball, table tennis are free of charge. Free of charge: massage, SPA and beauty salon, lighting and equipment for tennis, bowling, billiards, all water sports. Entertainment program during the day, racing, entertainment show program, Luna Park and mini club for children from 04 to 12 years.