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 Göynuk region, 2 km to Kemer city center and 46 km from Antalya airport.
SITUATION: Total number of rooms 348. Standard room (26m², one bedroom with a French bed + sofa + sofa bed, bathroom, max.2 + 1pax), Standard room with bunk bed (26m², one bedroom with French bed + Family rooms (38m², two bedrooms, two bathrooms, max.4 + 1pax), and 4 rooms for disabled guests All rooms have private bathroom with shower and bathtub, hairdryer, central air-conditioning system which works under atmospheric conditions, direct telephone, mini bar (fresh water and refreshment after arrival, then just reused water every day), boiler, tea and coffee raised, safe box, carpet floors, satellite TV and music channels, balcony .
SERVICE: Ultra All inclusive -: Main restaurant with open buffet, lunch and dinner, afternoon snacks, tea, coffee, biscuits, midnight snacks. All alcoholic alcoholic and standard import (Scotch, vodka, Martini only in Lobby bar) and soft drinks, ice cream during certain hours, restaurants A'la Carte with advance reservation and once in a stand. Not Included: All other imported drinks that are not on the menu list, bottled drinks, fresh fruit juices, energy drinks, room service, water pipe.
CONTENTS: Main restaurant with open buffet, A'la Carte - Turkish, Italian and fish cuisine, snack on the beach, vitamin bar and lobby, Disco club. Medical service, babysitting, laundry and dry cleaning, shopping areas, telephone, fax, computer games and internet cafes, hairdressers are an additional charge. Wi-Fi internet connection (low speed) is free of charge throughout the hotel.
PLAZA: The hotel has private, pebble beach and sends, with sun beds, sun umbrellas and beach towels free of charge. Private beach pavilions are available with extra charge.
SPORTS AND ENTERTAINMENT: Outdoor and indoor swimming pools for adults and children, water slides, fitness center, Turkish bath, sauna, steam room, tennis courts, table tennis, basketball, mini football, beach volleyball. At extra charge: water sports, massage, Thalasso & SPA center, reflective spotlight for the tennis court, diving school. Daytime entertainment programs, pool and beach races, show the evening programs, the Beach Party. Mini club for children aged from 04 to 15 years in different age groups, daytime programs and mini disco in the evening.