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-19:2023-04-19' 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, 17 km from Antalya city center and 15 km from the airport.
Location: The hotel possesses a total of 793. Superior standard room (64m², one bedroom, one bathroom, max.3 + 1pax), Luxury room (170m², entrance hall, one bedroom and one living room). shower / WC, max.2 + 1pax), Duplex family room (120m ², double floor floor + bathroom with shower, upper floor is French bed with bathroom with tub, shower door, max.2 + 2pax) (140m² , one bedroom and one bedroom, two bathrooms, max.3 + 1pax), family room with connecting door (80m², entrance, two bedrooms with doors in the middle, one bathroom, max.2 + 2pax) rooms for guests with disability. All rooms have private bathrooms with shower and hairdryer, central air-conditioning system that works under atmospheric conditions, direct dial telephone, mini bar (water, refreshment and refilled beer every day), tea, safe box, satellite TV and music channels, WI-FI internet connection, carpet on the floor, balcony, and in all rooms quit smoking.
Service: Ultra All Inclusive - open buffet for breakfast, late breakfast, lunch, dinners, baby food, dietary food, light meals, dinners, light meals in the late hours, all local alcoholic and non-alcoholic drinks and by import, ice cream during the day. A'la Carte restaurants with advance reservation, imported luxury drinks, all bottled wine from import, fresh fruit juice, imported champagne, room service are at extra charge.
Contents Main restaurant with open buffet, snack bar across the pool and beach, bars around the hotel complex, restaurants A'la Carte - Gusto (Italian cuisine), Shin (Far East cuisine), Tortilla (Mexican cuisine), Grand Fish (seafood restaurant), Ottoman (Turkish cuisine), Sushi Restaurant, Tapas Restaurant (Spanish cuisine), bars around hotel concept, Patisserie. Doctor, babysitting, laundry and dry cleaning, façade, telephone, fax, internet corner and computer games, rent a car, shopping center are extra charge. The low-speed Wi-Fi internet in the lobby area and the rooms is free of charge.
Beach: Hotel beach, 200 meters from the hotel, with sand and pebble, with sun beds, sun umbrellas, beach towels free of charge. Beach pavilions are pre-booked and with extra charge.
Sport and recreation: Sports and recreation: Outdoor and indoor pool, adults and children, 8 swimming pool Aqua Park, fitness center, sauna, steam bath, tennis courts, beach volleyball, basketball, table tennis. At extra charge: water sports, floodlighting for tennis courts, bowling, billiards, SPA, Beauty and Wellness Center, massage. Daytime entertainment programs, pool and beach competitions with professional team, evening shows, live music a few days a week. Mini club for children from 04 - 12 years old, special entertaining team, fun fair.