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 Lara - Kundu region, 15km from Antalya airport and 17km from the city center.
Location: The hotel possesses a total of 604 rooms. Superior standard room (46m², one bedroom, one bathroom, max.3 + 1pax), Luxury room (85m², two bedrooms and one bedroom, two bathrooms, one with shower / WC, max.4pax), Duplex family room (75m², two bunk beds + bathroom with shower, upstairs is a French bed with bathroom with bathtub, no doors, like gallery, max.4pax), suites room (60m², one bedroom and one bedroom, max. 2 + 1pax), Family room with connecting door (60m², two bedrooms with a door in the middle, a bathroom, max.4pax), Triplex suit (114m², three storeys and one room on each floor, downstairs one room bedroom and shower, and living room on the basement floor, max.4pax), the King sits (180m ², on the first floor the parents bedroom and the bathroom with Jacuzzi, the lower downstairs bedroom, the bathroom with shower, living room and small kitchen, max 4pax) and 6 rooms for guests with disabilities. All rooms have private bathroom with bathtub, shower and hairdryer, central air-conditioning system that works under atmospheric conditions, direct phone, sitting set, mini bar (water, refreshment and refilled beer every day), boiler, raised , safe box, satellite TV and music channels, WI-FI internet connection, balcony and all rooms are non-smokers.
Service: Ultra all inclusive - open buffet for breakfast, late breakfast, lunch, dinner, light meals in the evening, dietary buffet and children's cupboard, light lunch at the beachside restaurant all day, all alcoholic drinks and no - local and imported alcohol, pastry, ice cream during the day. Free: A'la Carte restaurant with pre-booking and once a stay, imported luxury drinks, imported champagne, fresh fruit juices and vegetables, special wines, room service, local and imported bottled wines.
Contents: The main restaurant with open buffet, snack bar on the beach and near the pool, bars along the hotel complex, A'la Carte restaurants - Vapiano (Italian cuisine), Hashi (Far East cuisine), El Torito (Mexican cuisine) Deep Blue (seafood) and Lal Restaurant (Turkish cuisine). Free of charge: doctor, caretaker, laundry and dry cleaning, hairdresser, telephone, fax, beauty center, rent a car, internet café, computer games, shopping center. The WI-FI internet at the Lobby Bar is free of charge.
Beach: The hotel has private sandy and pebble beach, beds, sun umbrellas and beach towels are free of charge.
Sports and recreation: Outdoor and indoor pool for adults and children, Aqua Park with 8 water slides, fitness center, Turkish bath, sauna, Jacuzzi, steam bath, tennis court, beach volleyball, basketball, ping-pong. Free of charge: water sports, tennis court, bowling, billiards, SPA center and beauty salon, massages. Entertainment programs during the day, swimming in the pool and on the beach with professional teams, evening show programs and live music several times a week. Mini-club for children with special entertainment teams, Luna Park.