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 the Kestelit region 6 km from Alanya city center and 140 km from Antalya airport.
PLACEMENT: The hotel possesses a total of 350 rooms in a main building and bungalows. (28m², one bedroom, one bathroom, max2 + 1pax) two bedrooms (34m², located in the main building, two separate bedrooms with sliding doors, one bathroom, max.4pax), Bungalow Family 2 bedrooms (56m² , two bedrooms, one bathroom, max2 + 1pax) Bedroom (56m², located in the bungalow, one bedroom and one living room with connecting door, one bathroom, max3pax). All rooms are with private bathroom with shower or bathtub, hairdryer, central air-conditioning system, direct dial telephone, mini bar (water only), tea, tea and coffee, safe box, satellite TV and music channels, ceramic floors balcony or terrace.
SERVICE: All Inclusive - Main restaurant with open buffet, lunch, dinner, afternoon snacks, coffee time, late night dinner, all local alcoholic and soft drinks 10.00 - 24.00hours, Snack restaurant on the beach. Not included: Imported drinks, special wines, fresh fruit juices, ice cream, A'la Carte restaurant with advance reservation and with additional tariffs, drinks at the Infinity bar, all drinks after 24.00.
CONTENTS : Main restaurant with open buffet, A'la Carte restaurant - Italian, Fish and BBQ Restaurants, beach snack, pool bar, lobby bar. Doctor, laundry and dry cleaning, telephone, fax, internet, hairdresser, bargaining, rent a car are extra charge. Wi-Fi internet in Lobit area and in the rooms is free of charge.
BEACH: Private hotel beach, with sand and pebble, with sun beds and sun umbrellas free of charge. Beach and pool towels are with deposit.
SPORTS AND ENTERTAINMENT: Indoor and indoor pools for adults and children, water slides, fitness center, tennis courts, table tennis, volleyball, basketball, mini golf, Turkish bath, sauna, steam room. At extra charge: water sports, massage, SPA and wellness center, billiards, floodlight for tennis courts and equipment. Entertainment programs with the professional team during the day by the pools and the beach, various competitions for adults and children, in the evening special show programs. Mini-club for children from 04 to 12 years old, children's playground, mini disco in the evening.