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 Kizilagac region, 70 km from Antalya airport, 10km from Side and Mangavat
SETTING: The hotel possesses a total of 590 rooms. Standard room 366 (36m², one bedroom, one bathroom, max.2 + 1pax), family room type A rooms with double beds 105 (40m², one bedroom with double bed and French beds, bathroom, max. 2 + 2pax), family room type B 86 (60m², two bedrooms with a door in the middle, two bathrooms, max.4pax), Suita 15 room (two separate bedrooms with connecting doors, one bedroom and two bathrooms) , Economy room 12 (31m², one bedroom, one bathroom, no balcony, max.2 + 1pax). All rooms are equipped with private bathroom with shower, hairdryer, central air conditioning system, direct dial telephone, mini bar (non-alcoholic drinks, daily refreshing water), ark (extra charge), ceramic floors, satellite TV and and channels musical, balcony
SERVICE: All inclusive - open buffet for breakfast, morning, late morning, lunch, afternoon cakes, tea, coffee, dinner and soup at midnight, A'la Carte restaurants upon prior reservation (one time during stay), afternoon ice cream, all local alcoholic and non-alcoholic drinks up to 24.00 hours. Not included: all drinks from import, drinks after 24.00 hours, fresh fruit juices, all bottled drinks, room service, all drinks at Disco Club
TABLE OF CONTENTS: Main Acacia restaurant with open buffet A'la Carte restaurants: A'la Carte: Ottoman Turkish cuisine, Olive - (Italian cuisine), Bonsai - (Chinese cuisine), Fish restaurant with advance reservation, lobby bar, snack bar , a bar near the pool and on the beach, Disco club. Free of charge are: doctor, clothes washing, babysitter, hairdresser, telephone, fax, internet (in Lobby is free of charge, while in the paid room), shopping center, rent a car. WI-FI up to 50MB in the Lobby area is free of charge
PLAZA: The hotel has private beach - sand and pebble, beds, umbrellas and beach towels are free of charge.
SPORTS AND SPOTS: Outdoor and indoor pools for adults and children, water slides, Turkish bath, sauna, fitness center, tennis courts, table tennis are free of charge. Free of charge: Massage, water sports, Wellness & SPA Center, billiards. Entertainment programs during the day, and evening show programs. Mini Clubs for children aged 11-15 years.