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-18:2023-01-18' 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 Kizilot region, 80km from Antalya airport and 15km from Side and Manavgat.
Location: The hotel possesses a total of 479 in the main building. Family Room type A with beds with icon bed (36-39m², one bedroom, one bathroom, max.2x), standard rooms (36m², one bedroom, one bathroom, max.2 + 1pax) Family Room Type B (43m² , two bedrooms with a door in the middle, a bathroom, max.4pax), Family Room Type C with two bedrooms (one bedroom with French bed and bunk beds, one bathroom, max.2 + 2pax) 72m², two bedroom with separate door, two bathrooms, max.5pax). All rooms have private bathroom with shower, hairdryer, central air conditioning system that works under atmospheric conditions, direct telephone, minibar (refreshment, water filled daily), safe box (extra charge), satellite TV and music channels, balcony.
Service: All Inclusive - open buffet, breakfast service, late breakfast, lunch, afternoon cakes, tea, coffee, supper and midnight soup, A'la Carte restaurants upon prior reservation and once during stay, ice cream in hours of plaintiff , local alcoholic and non-alcoholic drinks until 24.00. Not included: import drinks, drinks after 24.00, fresh juice, all bottled drinks, drinks at Disco Club.
Content: Main restaurant with open buffet, service, A'la Carte restaurants with prior reservation: Tulip - Turk, Olive - Italian and Bonsai - Chinese, as well as the fish restaurant with prior reservation, lobby bar, snack bar, pool bar and beach, Disco Club. Doctor, laundry, hairdresser, telephone, fax, internet café, computer games, shopping center, rent a car are free of charge.
Beach: The hotel has beach across the road with crossing (tunnel), sandy, pebble, beds, umbrellas and beach towels are free of charge.
Sports and entertainment: The outdoor and indoor pool for adults and children, water slides, Turkish bath, sauna, fitness center, table tennis, beach volleyball are free of charge. Massage, water sports are at a charge. Animated program during the day and evening. Mini Club for children.