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-27:2023-01-27' 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, 11km from Antalya airport and 15km from the center of Antalya.
Location: The hotel possesses a total of 462 rooms. Standard room 385 (26-30 m², one bedroom with French bed + one single bed + sofa bed, one bathroom, max.2 + 2pax), Duplex 75 family room (47m ², one bedroom upstairs with French bed, + one single bed, one bathroom with shower, on the lower floor two single beds, one bathroom with bathtub, two balconies, max.4 + 1pax), and four rooms for the disabled. All rooms are with private bathroom with shower, hairdryer, central air condition system works under atmospheric conditions, direct dial telephone, safe box, mini bar (refilled daily with soft drinks, water and beer), kettle , coffee and tea facilities, laminate flooring, LCD TV with satellite programs and music channels, balcony or terrace. WI-FI connection to the Internet is free of charge. Separate rooms: A Pink Moon tree for moonlight couples (80m², all round pink room, bedroom with double bed, living room, dining area, relaxation area, separate Jacuzzi and toilet, (85m² + 60m² terrace, two bedrooms, one bathroom, Jacuzzi on the terrace, VIP service, max.5 + 1pax), a presidential suit (108m² + 60m² living room with sofa, dining area with sea view and sun terrace on the terrace, VIP service, max.2 + 1pax), one K1 Suit (80m², round room, two double beds, bathroom with Jacuzzi, living room, sea view and sun beds on the terrace, VIP service, max.2pax, no balcony), a K2 Suit (80m², round room, two double beds, bathroom, lively, sea view and sun beds on the terrace, VIP service, max.2pax, no balcony), Black Suit (80m ², the whole room is decorated in black color, with two French beds, sofa, bathroom with Jacuzzi, sea view and VIP service, no balcony). Special rooms: A Rose Suite for newlyweds (100m², everywhere in the room is everything in pink, double bed room with double bed, dayroom, eating area, relaxation part, shared Jacuzzi, bath, panoramic view from the sea, VIP service provided), a presidential suite (108m², corridor, bedroom with King Size bed, Jacuzzi bath, dayroom with sofa, dining area, sea view and deck beds, VIP service (max. 4 pax), a King Suite (85m², corridor, bedroom, Jacuzzi bath, dayroom with sofa, sea view and deck beds, secure VIP service, max.2 pax), a K1 Suite (80m², the whole room is decorated in black, with two French round beds, sofa, Jacuzzi bath and panoramic sea view, VIP service), K2 Suite (80m², round room, two double beds, sofa, Jacuzzi bath with views from the sea and VIP service), Black suite (80m², all rooms are black in color, with two double beds, sofa, Jacuzzi bath, sea view and VIP service).
Service: Ultra all inclusive - welcome on-arrival champagne, fruit and wine in the room one day after arrival, open buffet breakfast service, late breakfast, lunch, snack afternoon, cakes, tea, coffee, dinner and snack late at night. All local alcoholic and soft drinks, standard imported drinks, A'la Carte restaurants are pre-booked (only one A'la Crte restaurant in one week stay, the second is a charge). Diet buffets and children's buffet are available at the main restaurant. Not included in the ultra-inclusive concepts: Premium Imported Drinks, Special Drinks and Bottled Wine, Room Service, Further Use of A'la Carte Restaurants.
Content: Main restaurant - open buffet for lunch, lunch and dinner, restaurants A'la Carte: Le Kebab -Turkish cuisine, Blue Fish - Fish restaurant, Beijing restaurant - Chinese cuisine, Margarita - Mexican cuisine, Dolce Vita - Italian cuisine , Teppenyaki - Japanese cuisine, Dragon - Sushi and Tai cuisine. Many bars around the hotel complex, Disco club. Medical service at the hotel is available, babysitting service, laundry service, telephone, fax, internet cafe and computer games, car rental, hairdresser, beauty salon, shopping center with extra charge. WI-FI internet connection on the Lob is free of chargePlay: The hotel possesses private beach - sand and pebble, beds, sun umbrellas at the pool and the beach are free of charge.
Sports and recreation: Open and closed pools for adults and children, a swimming pool for adults only (Relax pool is for adults only, children under 15 years old are not allowed), swimming pools, gym, Turkish bath, sauna, tennis courts, basketball, volleyball, volleyball beach boll are free of charge. Reflection tennis courts, water sports, wellness and spa centers, diving school, bowling, billiards, computer games are additional charges. Entertainment programs for adults during the day and evening show. Fun and Mini Club for children from 04 to 12 years old, with various activities and programs all day long.