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 Kemer city center, 56km from Antalya airport.
Location: The hotel possesses a total of 356 rooms. Standard rooms 309 (27m²; it includes 3 rooms for people with disabilities, max3pax); Family Room 41 (40m²; two bedrooms and one bathroom with dividing door, max4pax); 3 Pasha Suita (55m², one bedroom and one room of the day, bathroom with Jacuzzi, LCD TV and DVD player, max5pax); 3 Sultan Suite, 75m² (two bedrooms and one room of the day, two bathrooms, one with another Jacuzzi with bath / shower, LCD TV and DVD player). All rooms are equipped with private bath with bath / shower and hairdryer, central air conditioning system, direct dial telephone, mini bar (juices, refilled every day), crate, carpet on the floor, satellite TV with music channels, internet on request, balcony. WI-FI 56Kbps free internet.
Service: Ultimate All Inclusive - 24 hours food and drink, refreshing paloma on arrival and traditional Turkish drinks - "sherbet", morning, late morning, lunch and dinner, diet buffet, special children's buffet, light snack restaurant (babies under the age of 7 are not allowed to enter) and once during your stay, ice cream. Service at the Lagoon bar from 14:00 to 16:30, afternoon cakes, tea and coffee, mini bar (A'la Carte restaurants in the evening replenished every day with non alcoholic drinks and water). Free: Premium alcoholic drinks from import, special and international wines, room service, fresh juice, imported drinks from 01:00 to 10:00.
Contents: Panorama Main Restaurant, A'la Carte Restaurants - Mexican, Turkish and Italian are on prior reservation, 7 bars along the hotel complex, the Saphir disco bar. Free: Doctor, caretaker, clothes washing and dry cleaning, internet in rooms, hairdresser, shopping center, computer games, rent a car. 56Kbp WI-FI in the lobby and in the hotel's garden free of charge.
Beach: The hotel possesses private beach, pebble, beds, umbrellas, beach towels (with deposit), are free of charge (there is a partition between the hotel and the beach).
Sport and recreation: Outdoor and indoor pool for adults and children, Aqua Park, tennis court, volleyball, basketball, beach volleyball, ping-pong, gymnastics, fitness center, Turkish bath, sauna, steam room, Jacuzzi, free water sports are free of charge. Free of charge: Massage, SPA center, SPA swimming pools, motorized water sports, tennis lights, bowls, billiards. Entertainment programs with professional daytime and evening show programs. Mini-club for children from 04 to 12 years, with daily programs, races and evenings Mini Disco.