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 Colakli, 55km from Antalya airport.
Location: The hotel possesses a total of 509 rooms in the main building and in 4 blocks. Standard rooms 277, including 5 rooms for disabled persons (23-32m², one bedroom, one bathroom, max.2 or 3pax), Family room 170 (32-42m², two bedrooms with dividing door in the middle, one max.4pax bath), Junior Suita 50 (44m², one bedroom with partition, no partition door, one bathroom with Jacuzzi, max.2 + 1pax), Pasha Suita 6 (92-100m², two bedrooms separated, one sitting room, two bathrooms - one with Jacuzzi, mini kitchen, LCD TV, max.4pax). Honeymoon Suits 6 (39m², all rooms are overlooking the sea, a bedroom, a Jacuzzi bath and a part of the living room). All rooms feature private bath / shower bath, hairdryer, central air conditioning system, direct dial telephone, mini bar (non-alcoholic drinks refilled every day), carpet, floor rug, satellite TV and music channels, WI-FI internet with 56 Kbps, balcony.
Service: Ultimate All Inclusive - 24 hours food and drink, aromatic at arrival and traditional Turkish drinks - morning service, late breakfast, lunch and dinner, dietary buffet, special way for children, light snack restaurant during the day , ice cream from 16.00 to 18.00, afternoon cakes, tea and coffee, light snack during the evening, all local alcoholic and non-alcoholic drinks and standard of import, A'la Carte restaurant with prior reservation and once during stay (children under the age of 7 years are not allowed). Free of charge: premium alcoholic drinks from the import, international and special wines, room service, fresh fruit juice, energy drinks, alcoholic beverages imported from 01.00 to 10.00.
Contents: Main restaurant - Lalezar open buffet, A'la Carte restaurant - Tugra (Turkish cuisine), Mexico (Mexican cuisine), La Murano (Italian cuisine), Bonsai (Chinese cuisine), Caretta (fish restourant), bars along the complex catering, Pastries, Saphir Disco Club. Free of charge: doctor, baby caretaker, laundry and dry cleaning, hairdresser, shopping center, telephone, fax, internet, computer games, rent a car.
Beach: The hotel has private pebble beach, beds, sun umbrellas, towels (with deposit) are free of charge.
Sport and recreation: Outdoor and indoor pool for adults and children, Aqua Park, tennis court, volleyball, basketball, beach volleyball, mini football, mini golf, fitness center, Turkish bath, sauna, steam room, snow, salt rooms, Jacuzzi, are free of charge. Free of charge: Massage, SPA and beauty center, SPA pool, all water sports, lighting and equipment for tennis court, bowling, billiards. Entertainment programs with professional teams during the day as well as special evening show shows, cinemas. Mini-club for children aged 04 to 12 years, during the day as well as mini disco in the evening.