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-22:2023-01-22' 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 Bogazkent region, 25km from Belek and 40km from Antalya airport.
Location: The hotel possesses a total of 670 rooms in 8 blocks of 2 or 5 storeys. Standard room 470 (26m², max.2 + 1pax, 6 rooms for disabled persons), Family room 148 (42m² with two bedrooms with partition door, 2 + 2pax), Family room with double bed 50 ( as standard rooms 26m², but with double bed, max.3 + 1pax), 2 suites rooms (44m², one room of the day, one bedroom, bathroom with Jacuzzi and sea view). All rooms have private baths with bathtub, shower and hairdryer, air conditioning system, direct dial telephone, mini bar (water and juices at arrival), cash box, satellite TV with music channels, WI-FI internet, balcony. The rooms can be overlooking the sea or the garden.
Service: Ultimate All Inclusive - open buffet for breakfast, late breakfast, light meals in the morning, lunch, light meals on the beach, tea, coffee, afternoon cakes and biscuits, ice cream from 16.00 to 18.00, dinners, light meals At midnight, A'la Carte restaurants with advance reservation, all local and non-alcoholic alcoholic beverages and standard drinks, mini-bar with juices and water, refilled every day. Free of charge: luxurious import drinks, bottled drinks, specialty wines, energy drinks, fresh juice, exotic luxury drinks, room service, imported drinks at 01.00 - 10.00.
Contents: Main restaurant with terrace, A'la Carte restaurants: Turk and Fish, Italian and Mexican, bars along the hotel complex. Free of charge: doctor, caretaker, clothes washing, hairdresser, telephone, fax, internet connection in the room, shopping center, rent a car, internet café and computer games.
Beach: The hotel possesses a private beach, 400m from the hotel, guests can use the road to go or the shuttle service offered all day from the hotel to the beach, free of charge. Beds, sun umbrellas, beach towels are free of charge.
Sport and recreation: indoor and outdoor pool, water slides, fitness center, Turkish bath, sauna, tennis court, mini football, beach volleyball, basketball, ping-pong, motorized water sports. Free of charge: tennis court lighting, motorized water sports, beauty center, massage, bowling alley, billiards. Entertainment programs during the day near the pool and evening show programs. Mini-club for children from 04 to 12 years.