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 Lara region, 10km from Antalya's epoch and 15km from the city center. The hotel is directly on the beach.
Location: The hotel has a total of 650 rooms. Superior rooms 474 (35m², by the garden or sea side, two beds and a single bed and a sofa, 2 + 2pax), 38 family rooms (56m², two bedrooms with two separate doors, a balcony, max 4 (45m², one bedroom with French bed + sofa bed + balconies, max.3 + 1pax), room Laguna (36m², max 3pax, those rooms have their own pool, for reasons of security for children under 7 years old not allowed in this room, a French bed + one bedroom and one bedroom, a bathroom, a large terrace with Jacuzzi, max 2 pax), and 8 handicapped rooms (all of them are sea view) 56m², two separate bedrooms, one bathroom, Jacuzzi on the terrace, all rooms are sea view, max.4pax), King Room Family (110m², three bedrooms with connecting doors, a bathroom, Jacuzzi on the terrace, sea view, max.5 + 1pax). All rooms have a balcony, private bathroom with shower, hairdryer, central air-conditioning system that works under weather conditions, direct dial telephone, enclosed floor, safe box, mini bar (water, refreshment, kettle, coffee and high tea, wireless internet, 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) . Vegetarian meals and a children's buffet are available at the main restaurant. Not included in the ultra-inclusive concept: Imported luxury drinks, VSOP cognac, cigars, special wines, imported drinks at restaurants A'la Carte. Children under 15 are only allowed in the Turkish restaurant.
Contents: Gusto's main open-air restaurant, A'la Carte restaurants: Lalezar (Turkish cuisine and grill), Zuma (Far East cuisine), Mia Mensa (Italian Cuisine), Museum (French Cuisine), DaVinci Restaurant (Meat and wine), Helen (Greek cuisine), Tequila (Mexican cuisine), Pescador (fish restaurant). Bare in various locations in the hotel complex serving as local and imported drinks, disco clubs, and cinemas. Doctor and nurse, laundry, shopping center, internet and computer games, hair chair, car hire, babysitting are due to charge. Wi-Fi internet throughout the hotel is free of charge.
Beach: The hotel has private sandy and pebble beach, beds, umbrellas, towels and mattresses are free of charge.
Sports and recreation: Pool and swimming pool, children's pool, swimming pool for adults only, water park, indoor slide, fitness center, sauna, Turkish bath, steam room, tennis courts, beach volleyball, ) are free of charge. Tennis and instructional equipment, massage, pilling, SPA center and beauty salon, water sports, bowling and computer games, diving school are at extra charge. Daytime entertainment programs, evening shows and live shows, live music, movies, events nights and Gala nights. Mini-club for children between 04-12 years with programs during the day, mini disco in the evening, playground, children's cinema.