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-17:2023-01-17' 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 Lara region, 10km away from Antalya airport and 15km from the city center. The hotel is directly on the beach.
Location: The hotel possesses a total of 557 rooms. The standard rooms are 485 (32m² rooms overlooking the 28m² land, 32m² partly sea view, rooms with direct sea view, 2 + 2pax), 42 family rooms (45m², two separate rooms with the door in the middle, two mini bars, two TVs and a bathroom, max.4 + 1pax), 24 Junior suites (36m², a large room with Jacuzzi in the bathroom and a large terrace, max.3pax), 6 rooms for disabled people. All rooms are with balcony or terrace, direct view from the sea, partly by the sea and garden view, private bath with bath / shower, hairdryer, central air conditioning system which works according to climatic conditions, direct telephone, carpeted floor , cash register, mini bar (water, juices, beer, nuts and chocolate, refilled every day), LCD satellite TV and music channels.
Service: Ultra All Inclusive - welcome champagne, open buffet for breakfast, late breakfast, lunch, dinner, champagne branch on Sunday, late meals, all meals and snacks in the snack bars, fresh fruit juices during the morning and in the Vitamin Bar. All local and standard imported soft and alcoholic drinks, ice cream, coffee, tea from the pools and beach bars, A'la Carte restaurants with advance reservation (only one A'la Crte restaurant in one week, the second is a charge) . Food buffets and children's cupboards are available at the main restaurant. Not included in the ultra-inclusive concept: Imported luxury drinks, VSOP konveks, cigars, special wines, imported drinks at A'la Carte's restaurants, room service. Children under the age of 15 are allowed only in Ottoman and blue restaurants.
Contents: Main restaurant - with open buffet for services, A'la Carte restaurants: Blue Fish (fish restaurant), Osman (Turkish cuisine and barbeque), Beijing (Chinese cuisine), Dolce Vita (Italian cuisine), Margarita (Mexican cuisine ) Japanese cuisine, Helen (Greek cuisine). There are nine bars in various locations in the hotel complex serving as local and imported drinks, the Disco club, the cinema. The doctor and nurse, laundry, shopping center, internet (in the lobby area is free of charge, in the rooms due to loading) and computer games, hair-chair, car hire, babysitting are due to charge. Wi-Fi internet is free of charge throughout the hotel.
Beach: The hotel possesses private beach, pebble, beds, mattresses, sun umbrellas and towels are free of charge.
Sports and Recreation: Indoor and outdoor pool, children's pool, Aqua park, fitness center, indoor swimming pool, Sauna, Turkish bath, steam room, tennis court, beach volleyball, ping-pong, motorcycle, Luna Park for children (at fixed time) are free of charge. Free: Equipment as well as tennis, massage, SPA center and beauty salon, water sports motorbike and diving school. Daytime entertainment programs, competing shows and evening show programs, live music, Evening Gala. Mini club and Luna Park for children between the ages of 04-12, playground, children's cinema, mini disco.