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 Belek region, 40km from Antalya city center and 30km from Antalya airport.
Location: The hotel possesses a total of 594. There are rooms in the main building and in the Villa part. In the garden. Standard room (34m², max.2 + 2pax, one bedroom and one bathroom, main building), superior room (39m², max.2 + 2pax, one bedroom and one bathroom, main building) (80m², max.3 + (80m², max.3 + 1pax, two bedrooms and two bathrooms, one with two bedrooms and two bathrooms, main building), Luxury room (70m², max 3 + 1pax, main building) direct access to the pool), indoor pool (80m², 3 + 1pax, two bedrooms and two bathrooms, balcony, on the ground floor, not directly at the pool). In all the rooms there is a bathroom with rain shower, central air-conditioning system that works under atmospheric conditions, direct telephone, mini bar (various choices and drinks, refilled every day), safe box, bathtub and slippers upon arrival, kettle in the room (coffee and tea assortments), satellite TV and music channels, internet connection WI-FI, balcony. Room and suites: Main floor (82m², with balcony in the main building, one bedroom), Corner (82m² with balcony in the main building, two bedrooms), Design Villa (338m², these villas have private garden with private pool, Exclusive Pool Villa (360m², private garden with private pool, two bedrooms, living room, living room with kitchen, large terrace), Superior Villa (610m², private garden with swimming pool (surface total of 2700 m², five bedrooms with own bathroom, living room with fully equipped kitchen, Turkish bath, sauna, gym, private beach cabins)
Service: High Class All Inclusive - open buffet, breakfast service, late breakfast, lunch, dinners, diet buffet, midnight coffee, A'la Carte restaurants, fixed hour ice cream, grass near the pool, . All local and standard alcoholic and non-alcoholic beverages, drinks at Disco Bar (from 23.00 to 02.00), room service between 24.00 and 07.00. Not included in the concept: premium drinks, specialty wines, French champagne, as well as A'la carte restaurants on the vessel and Privado.
Content: Main restaurant with open buffet, A'la Carte restaurants: Oceanos (Mediterranean), Hasir (Turkish), Barbeque (fish and meat), La Paglia (Italian), Restaurant in Ships, Privado (special menus), bars along hotel complexes. 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 1000 meters from the hotel and at all times there is organized beach transport. Beds, umbrellas, beach towels are free of charge.
Sports and entertainment: Outdoor and indoor swimming pool for adults and children, water slides, fitness center, Turkish bath, sauna, tennis court, basketball, beach volleyball, mini football, table tennis, water sports without water are free of charge. Wellness & SPA center, massage, tennis lighting, equipment, water sports motorbikes, billiards are at a charge. Amusing daytime program, racing near the pool and on the beach, evening show program and live music, cinema. Mini Club for Children 03 - 13 and Teenage Club for 14 - 17 years.