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-29:2022-10-29' 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 Lara region, 10 km from the city center, 8 km from Antalya airport.
SITUATION: The total number of rooms 837 in four blocks. Standard European Room Trendy 313 (35m ², one bedroom with French bed + sofa bed + sofa bed, bathroom, max.2 + 2pax), standard room EU Large 295 (42m², one bedroom with French bed + sofa bed + (32m², bedroom with a French bed, bathroom, max.2pax), Superior Room BE Delux Loft 13 (41m², max.2 pax) , BE Family One 110 (56m², two separate bedrooms, one with French bed one with two single beds, one bathroom, max.4 + 1pax), EU Family Loft 17 (70m², duplex, beds, one bed Family room B - 3 rooms (80m², two separate bedrooms, one with French bed, one bed and one sofa bed, one bathroom, max.3 + sofa bed, one or two single beds, two showers, max 4 + 1pax) 2pax), BE Suit - 12 rooms (123m², two bedrooms and one living room, one bathroom, max.4pax), BE Royal - 4 rooms (104m², duplex, two bedrooms, two bathr saunas, max.4pax) King - 1 dh oak (352m², duplex, two bedrooms only with French beds, two bathrooms, max.4pax). All rooms have a balcony, private bathroom with shower, hairdryer, central air-conditioning system, direct dial telephone, mini bar (water, mineral water, refreshing drinks and refilled beer every day), tea and tea, laminate flooring , Wi-Fi internet in rooms, LCD TV with satellite and music programs.
SERVICE: Ultra All inclusive - open buffet for breakfast, late breakfast, lunch, dinner, snacks during the day and late night snack, children's dresser, all imported local and standard alcoholic and soft drinks, fresh fruit juices, restaurants A'la Carte with advance reservation and once in a stand, the mini bar in the rooms is refilled daily with non-alcoholic drinks and beer. Not included: V.S.O.P. cognac, premium whiskey and special local and imported wines, energy drinks and imported beers, cigars, all bottled drinks, room service.
CONTENTS: The main Sunflower restaurant, open buffet service, A'la Carte restaurants - Sultan-Turkish cuisine, Sakura cuisine -Far East, Rugiano restaurant - Italian cuisine, Mermaid restaurant - Fish restaurant, Jaipo - Mexican cuisine, Atlantes - Greek cuisine , with earlier reservations, bars in various locations in the hotel complex, Ikat - Meat & Wine, the White Disco bar. Doctor, laundry and dry cleaning, listening to buffet, babysitting, telephone, fax, internet cafe and computer games, shopping centers are additional charge. The Wi-Fi internet in the Lobby area is free of charge.
PLAZA: Private hotel beach, send, with towels, sun beds and sun umbrellas are free. Pavilions at the beach and the pool are at extra charge.
SPORTS AND ENTERTAINMENT: Open-air swimming pools (one is Semi Olympic), indoor swimming pool, children's pool, 9 water slides, pool Jacuzzi, tennis courts, table tennis, mini football, beach volleyball, darts, fitness center, sauna, free of charge . At extra charge: water sports, floodlight for tennis courts, tennis lessons, beauty salon, SPA center, massage, bowling, billiards, game room, diving school. Entertainment every day with daily programs, competitions and show programs in the evenings. Mini children's club from 04-07, and Midi club from ages 08-12, special children's disco, cinema, animation show.