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 Kiris region, 5 km from Kemeri and 70 km from Antalya airport.
Location: The hotel possesses a total of 815. Standard room in the main building (28m², one bedroom, one bathroom, sea view, sea and pool), Arycanda building (28-32m², one bedroom, one bathroom, sea and pool, max.2 + 2pax) (28 - 32m², one bedroom with a bathroom, max.2 + 2pac, located in the garden), Limra Park (parking space, side street and 4 * category, one bedroom, one bathroom, max .2 + 2pax), the rooms of the Jacuzzi studio are only in the main building, family rooms only on the side of the Garden (39m², 2 + 2pax, two bedrooms with the door in the middle, a bathroom). All rooms have a balcony or terrace with sea side or garden, private bathroom with bathtub, hairdryer, telephone with bathroom, central air-conditioning system working under atmospheric conditions, direct dial telephone, laminated flooring, safe, mini bar and refilled beer every day), satellite TV and music channels, Wi-Fi internet connection.
Service: Ultra All Inclusive - open buffet for breakfast, late morning, lunch, afternoon snack, ice cream at Café Bonjour, cakes and tea and coffee, dinner, midnight soup. All local alcoholic drinks and refreshments and some standard, Turkish coffee at Lykya, Atlantis and Lobby bar, A'la Carte (Sandal and Kazan) restaurants with advance reservation and mini bar in the rooms are free of charge. Not included in the ultra-inclusive concept: A'la Carte Italian, barbeque, Chinese restaurants will pay, all canned drinks and bottles, imported luxury drinks, specialty wines, fresh fruit juices, room service.
Contents: Main restaurant - Phaselis, Likya light snack, light galata, patisserie, A'la Carte restaurants - Ponte Veccio - Italian, China Garden - Chinese, Sandal Restaurant - Fish, Kazan Restaurant - Turk, BBQ Restaurant, Gringos - Mexican Restaurant and Japanese Sushida. Bars along the hotel complex. Shopping center, hairdresser, doctor, caretaker, room service, laundry and dry cleaning, computer games, telephone, fax, internet, rent a car are at a charge.
Beach: The hotel is located near the beach, pebble and sandy Towels, beds, umbrellas are free of charge. Private beaches on the beach are free of charge.
Sports and entertainment: Outdoor pool with children's pool, indoor pool, water slides, fitness center, sauna, Turkish bath, tennis court, squash, basketball, beach volleyball, darts, water sports without a motorcycle are free of charge. Water sports with diving school, massage, wellness center, tennis school, night lighting and equipment, billiards are at a charge. Animated program during the day and evening show program. Special programs for children and mini club.