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:2020-10-20:2022-10-20' 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','wpforms_log','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','wpforms_log','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 center of Kemer, 55km from Antalya airport.
Setting: Total number of rooms 332 rooms in the main building and in the garden area. Standard Room The main building (26-31m², one bedroom, one bathroom, max.2 + 1pax), Family Room (42-51m², is located in the main building on the front, two bedrooms with connecting door, one bathroom, max .4 + inf), Standard Garden Room (20-23m², located in garden, one bedroom, one bathroom, max.2pax), large garden (32 - 33m², located in the garden, a larger room with French bed and two couches (34 - 39m², one bedroom with French bed, one living room with two sofa beds in the middle, one bathroom, max.4pax) All rooms have private bath with bath or shower, hairdryer, central air-conditioning system in the main building and divided into garden blocks, direct dial telephone, mini bar (fresh water refreshed daily), coffee and tea, safe box, carpet flooring, bathrobe and slippers and scale, satellite LCD TV and balcony.
Service: Ultra all inclusive - open buffet breakfast, late morning, 24 hours food and drink service, lunch, afternoon snack, dinner, late night snack. All local and imported alcoholic and soft drinks, fresh fruit juice in the morning, diet and corner of healthy food at the main restaurant, baby sitter, ice cream during the day, freshly squeezed juices at the Vital bar, A'la Carte Restaurants are pre-booked and once in a stand. Not included: Imported premium drinks, VSOP cognac, special imported and local wines, all bottled drinks.
Contents: Main restaurant with buffet and open service, restaurants A'la Carte - Chianti (Italian cuisine), sea food (seafood restaurant), Barbeque (Grill restaurant), Sini (Turkish cuisine), Sushi Lounge, bars around the hotel complex. Medical service, babysitting, laundry, telephone, fax, internet, computer games, hairdryers, car hire, shops are charged with charge.
Beach: Private hotel beach - pebble and sand, sun beds, sun umbrellas, beach towels are free of charge.
Sports and recreation: Outdoor and indoor pool for adults and children, water slide, fitness center, sauna, Turkish bath, steam room, Jacuzzi, tennis court, beach volleyball, basketball, table tennis. Free: Lighting for tennis courts, equipment, bowling, billiards, massages, SPA & wellness centers, water sports, diving lessons, computer games. Fun during the day, racing games at the pool and on the beach, sports activities, movies, evening shows. Mini club for age group of children from 04-17 years.