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-17:2023-01-17' 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 Kizilot, Side region, 80 km from Antalya airport ..
Location: The hotel possesses a total of 834 rooms. Standard rooms are 546 (8 rooms for disabled persons, 35m², one bedroom, bathroom, max.3 + 1pax), and some standard rooms (22.5m² with balcony for only 2 pax); Family Duplex Rooms are 213 (48m², two bedrooms, rooms do not have a door between two floors, a bathroom, max.3-4pax); Junior Suite 15 (50m², one bedroom and one living room, one max.3pax bathroom); Duplex Family Suite 5 (55m², two bedrooms, one living room, five of which are two bathrooms, max.4 + 1pax), Senior Suite 10 (95m², one bedroom, one room of the day, one bathroom with Jacuzzi, LCD TV and DVD, max.2 + 2pax). All rooms are with private baths with bath tub, shower, hairdryer, central air conditioning system, direct dial telephone, mini bar (non-alcoholic refresh every day), cash register, floor rug, satellite TV and music channels, WI-FI internet with 54Mpbs, balcony.
Service: Ultimate All Inclusive - 24 hours food and drink. The aromatic aromas at arrival as well as traditional Turkish drinks - "sherbet", breakfast, late morning, lunch and dinner, dietary buffet, special menu for children, light meals in the restaurant, ice cream from 16.30 - 18.00, afternoon cakes , tea and coffee, A'la Carte restaurants in the evening with prior reservation and once during stay (children under the age of 7 are not allowed to enter). Free of charge: premium alcoholic drinks from the import, international and special wines, fresh fruit juice, room service, alcoholic drinks from 23:00 to 10:00 Wine Wine, nargile, coffee.
Contents: Main restaurant - Admiral, open buffet, A'la Carte restaurants - Istanbul (Turkish cuisine), Mexican (Mexican cuisine), Venezia (Italian cuisine), Sailor (Fish Restourant), Turkish (grill-barbeque) along the catering complex. Free of charge: doctor, caretaker, clothes washing, hairdresser, shopping malls, telephones, fax, internet connection, computer games, rent a car.
Beach: The hotel has private pebble beach, beds, 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 golf, fitness center, Turkish bath, sauna, steam room, Jacuzzi, are free of charge. Free of charge: Massage, SPA and beauty center, SPA pool, all kinds of water sports, lighting and equipment for tennis court, bowling, billiards. Entertainment programs with professional teams during the day as well as special show programs in the evenings. Mini-club for children aged 04 to 12 years, during the day as well as mini disco in the evening.