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-18:2023-01-18' 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 Lara-Kundu region, 15km from Antalya airport and 25km from the city center.
Setting: The hotel possesses a total of 441 rooms. Standard Room 319 (32m², one bedroom, one bathroom, max.2 + 1pax), Family Room 92 (65m², 2 + 2pax, two separate rooms with sliding door in the middle, max.2 + 2pax), Junior Suita with Jacuzzi 11 (45m²), Suita with Jacuzzi 15 (70m²), 4 disabled rooms. All rooms are equipped with private bath with shower, bathtub, hairdryer, central air conditioning system which works according to climatic conditions, direct telephone, cash box, mini bar (drinks, water and beer every day), satellite TV and music channels, WI-FI internet, balcony.
Service: Ultra All Inclusive - open buffet for breakfast, late morning, lunch, all morning and afternoon snacks, light snacks in late hours. All local and standard alcoholic and soft drinks, mini bars in the refilled rooms each day, ironing service two items per person, fresh fruit juice for breakfast. Not included in the all-inclusive concept: all local and imported bottled drinks, fresh fruit juices, imported luxury drinks, bottled drinks, packed ice cream, A'la Carte restaurants with advance reservation and extra charge , room service.
Contents: Zen - main restaurant, A'la Carte restaurant - La Cuccina (Italian cuisine), Revan (Turkish cuisine), Gringos (Mexican cuisine), Sushi Thai (Thai & Sushi restaurant), light groomed food, catering. Free of charge: doctor, baby caretaker, washing and cleaning of clothes, telephone, fax, internet, hairdresser, rent a car, shopping center. WI-FI in the hotel and in the rooms is free of charge.
Beach: The hotel has a private sandy beach, beds, umbrellas and beach towels are free of charge. Pavilions on the beach are on prior reservation and with extra charge.
Sports and recreation: Outdoor and indoor swimming pools for adults and children, 9 swimming pools and a toboggan run in the indoor pool, Turkish bath, sauna, fitness center, tennis courts, tennis courts, squash, table tennis. Massage and SPA center, tennis lessons and equipment, squash equipment, water sports, billiards, bowling are at extra charge. Daytime and evening entertainment programs, a mini-club for children, form the group of 4-12 years old and the small 13-16 year old club with special programs with the professional team.