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-21:2023-01-21' 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 Bogazkent region, 40km from Antalya airport and 50km from Antalya city center.
Location: The hotel possesses a total of 372 rooms in four five-story buildings. Standard rooms are 278, (27m², 78 rooms are connecting and 3 for disabled people, max.3pax); Family Room 90, (40m², two rooms with dividing door, max.4pax); Junior Suita 4 (58m², one living room, one bedroom, one bathroom with Jacuzzi, LCD TV and DVD player), Sultan Suite 4 (80m², two rooms and one room of the day, two bathrooms one with Jacuzzi, LCD TV and DVD player). All rooms are equipped with private bath with shower / bath and hairdryer, air conditioning system, direct dial telephone, mini bar (daily refilled daily), checkout, floor rug, satellite TV with music channels, 56Kbps WI- balcony.
Services: Ultimate All Inclusive - 24 hours food and drink. Turkish refreshments and traditional drinks - "sherbet" on arrival, breakfast, late morning, lunch and dinner, diet buffet, special children's buffet, light snack restaurant, A'la Carte restaurant in the evening with Pre-booking (children under the age of 7 are not allowed) and can be used once during the stay. The ice cream is served at the Lagoon bar from 17:00 to 19:00, afternoon dessert, tea and coffee, 7 bars throughout the hotel complex. Free of charge: premium alcoholic drinks, international wines and room service, fresh fruit juices and all alcoholic beverages imported from 01:00 until 10:00.
Content: Main restaurant Lalezar, A'la Carte restaurants - Mexican, Turkish, Italian with advance reservation and can be used once during your stay. Free of charge: doctor, caretaker, clothes washing and dry cleaning, internet connection in the room, hairdresser, shopping center, computer games and Rent a Car.
Beach: The hotel has private sandy beach, beds, umbrellas are free of charge. Towels on the beach with deposit.
Sports 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, Jacuzzi, are free of charge. Free: Massage, SPA center, water sports motorbikes, tennis equipment, lighting for the tennis court, bowling, billiards, professional soccer fields. Entertainment programs with professional teams during the day and "show" special evening programs. Mini-club for children aged 04 to 12 years, and Junior Club for 13-16 years during the day and Mini Disco in the evening.