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-25:2023-01-25' 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 Beldibi region 25km from Antalya, 17km from Kemer and 35km from Antalya Airport.
Location: The hotel possesses a total of 521 all in the 3rd floor bungalow. The standard room - including 6 rooms for disabled guests, (19m², one bedroom, one bathroom, max.2pax, no cot), large standard rooms (21-26m², one bedroom, one bathroom, max3pax) bunk bed 25 (26m², one bedroom with French bed + bunk beds, bathroom, max.2 + 2pax), family room (37m², two bedrooms with a door in the middle, one bathroom, max.4pax) (37m², two bedrooms, one with a French bed, the second with a bunk bed or a high-quality bed mattress, doors between the bedrooms, a bathroom, max.2 + 3pax). The rooms have private bathrooms with shower and hairdryer, separate air-conditioning system, direct dial telephone, mini bar (fresh refilled daily), safe box, LCD satellite TV and music channels, balcony or terrace, Internet FI is available in some rooms and up to 56Kbps is free of charge.
Service: Ultimate All Inclusive - 24 hour service with drinks and food, open buffet for breakfast, late breakfast, lunch, light meals in the morning and afternoon, dinners, light meals in the late hours, all alcoholic drinks and no - local and imported food, A'la Carte restaurants with pre-booking (children under 7 years are not allowed) and once a stay, a mini-bar with liquids and water replenished every day, ice cream from 16:00 to 18:00 . Free: Imported luxury drinks, bottled drinks, special wines, nargile, fresh fruit juice, energy drinks, cigars, alcoholic beverages from 01:00 to 10:00 and room service.
Contents: Aspendos - main restaurant, A'la Carte restaurants: Starfish, Azure (Mediterranean), La Fiesta (Mexican), Flora (Grill), Ottoman (Turkish), bars along the catering complex, Disco club. Free of charge: Doctor, baby caretaker, laundry and dry cleaning, telephone, fax, internet and computer games, hairdresser, shopping center, rent a car. WI-FI internet up to 56Kbps in Lobby free of charge.
Beach: The hotel possesses private beach, pebble, sand and two platforms, beds, sun umbrellas, towels are free of charge.
Sports and entertainment: Outdoor pool for adults and children, water slide, fitness center, Turkish bath, sauna, steam room, gymnastics, tennis court, volleyball, basketball, ping-pong, beach volleyball. Free of charge: water sports, massages, SPA centers, diving school, lighting and equipment for tennis courts, bowling and billiards. Entertainment programs during the day, racing, evening show programs. Mini-club for children with a daily program and animations.