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 Evrenseki region, 45 km from Antalya airport and 10km from Side and Manavgat.
Accommodation: The total number of rooms is 300. Standard room 245 (35m², 2 + 1pax), room with 2 beds 45 (35m², 2 + 2pax), family room 10 (50m², two separate sleeping rooms, 2 baths, max4pax). All rooms are private bath with shower, hairdryer, central air-conditioned working in certain hours (where is opened the balcony door does not work), direct phone, mini bar (drinks and water recharge daily), cash register (with extra charge), direct telephone, satellite TV and music channels, balcony.
Service: All Inclusive - open buffet for breakfast, late morning, lunch, cakes in the afternoon, tea, coffee, dinners and soup at midnight. A'la Carte restaurant with pre-booking and only once during the stay, afternoon ice cream, all local alcoholic and non-alcoholic drinks are served until 24:00. Not included in the concept: all imported drinks, drinks after 24 o'clock, fresh fruit juice, all bottled drinks, room service, all drinks at Disco Club.
Content: Main restaurant with open buffet, A'la Carte Restaurants: Turkish - Turkish cuisine, Italian cuisine, Chinese cuisine with prior reservation, lobby bar, snack bar, grass near the pool and on the beach, Disco Club. Doctor, laundry, hairdresser, telephone, fax, internet café, computer games, shopping center, rent a car are at extra cost.
Beach: The private beach of the hotel with sand, beds, umbrellas and beach towels are free of charge.
Sports and recreation: Outdoor and indoor swimming pool for adults and children, water slides, Turkish bath, sauna, fitness center, table tennis, crazy volleyball are free of charge. Massages, water sports, bowls, billiards, tennis court lighting, beauty centers are at extra cost. Entertainment programs during the day and in the evening. Children's Mini Club.