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-19:2023-04-19' 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 Belek region, 30km from Antalya airport.
Location: The hotel has a total of 174 rooms. The standard rooms are 86 (30-35m², max2 + 1pax), suite suites are 71 (35-40 m², max2 + 1pax), junior suites are 7 (50-80 m², max3pax), suites with jacuzzi are 4 (65- 70m², max3pax), suite rooms are 4 (55-60 m², bedroom and dayroom, max3pax), 2 king suites (95 m²). All rooms are with private bath with shower / tub, hairdryer, central air conditioning, direct telephone, mini bar (with extra charge), cash register, satellite TV with music channels, balcony.
Service: Ultra All Inclusive - open buffet, breakfast service, late breakfast, lunch, dinner, dietary buffet, midday snack, ice cream at a certain hour, grass near the pool, children's dresser. All local alcoholic and non-alcoholic beverages and standard imports. They are not included in the concept: premium drinks, specialty wines, French champagne, and A'la carte restaurants.
Content: Main restaurant with open buffet, A'la Carte restaurants: French, Japanese, Thai, Mexican, Italian, and fish, bars along the hotel complex. Doctor, child carer, clothes washing and dry cleaning, shopping center, internet and computer games, hairdresser, rent a car are at a charge.
Beach: The hotel has a private sandy beach and is located 400 meters from the hotel. Beds, umbrellas, beach towels are free of charge. There is free transportation to the beach.
Sports and entertainment: The outdoor and indoor swimming pool for adults and children, fitness center, Turkish bath, sauna, tennis court, basketball, beach volleyball, table tennis, water sports are free of charge. Wellness & SPA center, massage, tennis lighting, equipment, water sports, billiards, golf club and golf course are at a charge. Amusing daytime program, racing near the pool and on the beach, evening show program and live music, cinema. Children's Mini Club 04 - 12 years old.