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
Location: The hotel is located in the Beldibi region 25 km from Antalya, 17 km to Kemer and 35 km from Antalya Airport.
Accommodation: The total number of rooms 560 is located in the main building, in the garden area and in the villas. The privileged concept of life - according to the type of accommodation there are different concepts of service for guests.
Standard concept: Mini bar with alcohol and refreshing drinks daily, fruit basket and bottle of wine in each room, bathrobes and sticks, special room setting, tea with tea and coffee, internet WI-FI (100 Mbps). A'la Carte restaurants, beach pavilions and room service at extra charge. The guests of the following rooms are using this concept: Main Room and Standard Garden 215 (33m², one bedroom, one bathroom, max.3pax), Superior Room 45 (33m², one bedroom, bathroom and terrace overlooking the sea, garden or swimming pool, max.3pax), family room 94 (51m², two bedrooms, one bathroom, with sea view, garden or swimming pool, max.4pax).
VIP Concept: Create many mini bars, all local and foreign drinks, return to service, once a week free A'la Carte restaurants (except Steak House, Teppanyaki and Seafood, Crystal A'la Carte Restaurant ), room service from 11:00 to 18:00 free of charge, laundry service (up to 5 pieces a week per person), Bulgari bathroom, bathrobes and slippers, various types of fruits, flowers, biscuits, newspaper service, tea and coffee set up, espresso machine, WI-FI (100Mbps) internet. Visitors of the following rooms use this concept: Lagoon Beach Front Villas (8) - (42m², one bedroom, one bathroom, one sofa bed and double floor, max.3pax), Garden Villas (46) - Area of (42m², one bedroom, one bathroom, 2 sofa beds, terrace and garden or pool view, max.3pax), Family Lagoon Accommodates 18 - (65m², two bedrooms with terrace,, max.4pax), Laguna Luxury suits (56m², one bedroom with terrace, one living room with terrace, kitchen angle, bathroom, sea, pool or garden view, max.3pax).
VIP Concept: A rich assortment of mini bar, mini bar in VIP beach pavilion (09.00-18.00), all local and foreign drinks, return service, once a week free A'la Carte restaurants (Steakhouse and Teppenyaki) , room service from 11 am to 6 pm, laundry service (up to 5 times a week per person), exclusive Crystal VIP A'la Carte Restaurant and bar from 08.00 to 24.00, room set in Bulgaria, outfits and outfits and slippers various types of fruits, flowers, biscuits, newspaper service, tea, tea and coffee, espresso machine, CD & DVD collection from the hotel's library, WI-FI (100Mbps) internet. The guests of the following rooms use this concept: Lagoon Luxury Villas 11 - 86m², two bedrooms, two bathrooms, a living room, large terrace, pool or garden view, max.4pax), Laguna Deluxe Family 18 (90m² , bedroom with terrace, living room with terrace, two bathrooms, swimming pool or garden view, max.5 + 1pax).
Top VIP Concept: Private transfer from and to the airport (up to 6pax), c / in special, exclusive restaurant A'la Carte and bar in the pear for 24 hours, private pier and pavilions in it, from pavilions to private pier, mini fully stocked bar in the wardrobes, special places reservation at all restaurants in the hotel complex, kayak lounge cabin, private pool with Jacuzzi, various mini bar set up, various kind of fruit, nuts, chocolate, cookies and locum, all exclusive domestic and foreign drinks, free 24-hour room service, laundry and shoe service, Bulgari hall, bathrobes and slippers, newspaper service, tea, tea and coffee, car espresso, DVD and CD collection, internet WI-FI, surround sound system in Vila. The guests of the following rooms are using this concept: Grand Deluxe Beachfront Suits 2 - (129m², located on the beach, two bedrooms, living room, living room and dining room, kitchen corner, two bathrooms and two large terraces, or (152m², located on the beach, two storey two-bedroom villa, two bathrooms and two terraces on the second floor, one bedroom with bathroom, two terraces on the first floor, a separate vanity service, sea view or pool, max.5 + 1pax), Villa Nirvana 1 - (400m², located on the beach, two-bedroom villa, two bedrooms, lounge, two terraces and on the floor first two bedrooms, two bathrooms, wardrobe, living room and dining room, kitchen corner, terrace, valet service, private pool, steam room, bath and Turkish sauna Max.5 + 1pax).
Service: Privileged Life - 24 hour food and beverage service - open buffet service for breakfast, late morning, lunch, snacks in the morning and afternoon, dinner, late night dinner, all alcoholic drinks and non-alcoholic local and standard imported cream, fresh fruit juices at the Natural Bar, pastry shop. Excludes: exclusive imported drinks such as old whiskey and cognac, imported champagne, bottled drinks, specialty wines, water tubes, A'la Carte restaurants with advance reservations are covered with cover (children under 7 are not allowed to enter ), Cigars, room service from 07:00 to 00:00. Facilities: Open buffet restaurant, eight A'la carte restaurants: Mermaid, La Serenata (Mediterranean cuisine), Ginger (distant kitchen at birth ), El Parador (Mexican cuisine) Teppanyaki, Pravda (Russian cuisine), Welldone (Stake House), Exclusive A'la Card in the private area, bars around the hotel complex, Disco club. Doctor, baby sitting, laundry and dry cleaning, telephone, fax, internet corner and computer games, hair, shopping center, car hire are extra charge. Wi-Fi Internet up to 56Kbps is free of charge.
Beach: Hotel beach, pebble, sand and three pears, with sun beds, sun umbrellas, free beach towels. Private pavilions are additional charges.
Sports and Entertainment: There are 14 indoor and indoor pools for adults and children, (the main pool is with sea water), Aqua Park for adults and children, gym, Turkish bath, sauna, steam room, gymnastics, tennis, volleyball, basketball, table tennis, beach volleyball. At extra charge are: water sports, massage, SPA center, diving school, reflector for tennis courts and equipment, bowling and billiards. Entertainment programs during the day, races, evening show programs. Mini-club for children from 04 to 12 years old with programs and animations every day.