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 the Belek region, 35km from Antalya airport and 40km from the center of Antalya.
Location: There are 552. Luxurious rooms (40m², main building and house section with terraces, max.2 + 2pax), superior luxury rooms (63m², located on the terraces of the terraces on the first and second floor, the rooms on the floor the first have a terrace with access to the garden, the rooms on the 2nd floor have access to the lake pool from the balcony stairs, the rooms are divided into two parts, a bathroom, max.4 + 1chd), the triplex family room (115m², located in the houses of the lake on the fourth floor (76m², is located in the main building or part of the house of the terrace, one bedroom, one living room (can also be bedroom), bedroom with balcony, three bedrooms with bathroom, max. 6 + 1chd, two bedrooms, max.4 + chd), Special rooms: Lake of Love Suit (80m², terrace room section, each floor one of two store blocks, one bedroom, one living room, one bathroom jacuzzi, max.3pax) Royal costume (206m², located in the main building, two bedrooms, a living room, bathroom with Jacuzzi, pool on the 60m² terrace, max.4 + 2chd), Junior royal suit (165m², located in the main building, two bedrooms, a living room and bathroom Jacuzzi, terrace, max4 + 2chd), and king suit (420m², located on the last floor of the main building with two bedrooms, Jacuzzi and pool on the terrace, max 4 + 2chd). VIP villa in hotel garden (750m², two storeys, first floor one large living room with dining table, kitchen, bar, utility room, indoor pool 29m³, fitness center, garden 90m² outdoor pool, second floor four bedroom with Jacuzzi and dressing room in master bedroom, max.8 + 2chd). All rooms have private bathrooms with bathtub or shower and hairdryer, central air-conditioning system, direct dial phone, safe box, mini bar (water, drinks and beer), tea, and music system, Wi- Fi, balcony or terrace. The rooms in the main building are overlooking the sea or the garden, but in the terraced houses only the garden sections.
Service: Ultra All Inclusive - open buffet breakfast service, late breakfast, lunch, afternoon light meals, cakes, coffee, tea, dinners, light meals in the late hours, all local alcoholic and non-alcoholic drinks and imported standard, fresh juice from 07: 00-19: 00, drinks in the vitamin bar, mini bar with light drinks and beer, and light meals in the evening are free of charge. Not included in the concept: Premium luxury drinks, special and imported wines, room service, all bottled drinks. A'la Carte restaurants with advance booking, with additional payment and can be used twice during a one week stay.
Contents: Turquoise - Main restaurant with open buffet service, A'la Carte restaurants - Takatuka (Turk), Paprica (Italian), Ada (Mexican), Cassia (Chinese and Japanese), Tumanna (Argentina), Alesta (Fish) Bakus (Wine House), bars along the hotel complex, The G - disco bar, and three times a week Club Mor Gogo Bar. Doctor, hairdresser, clothes washing and dry cleaning, internet café and computer games, rent a car, shopping center are at a charge.
Beach: The hotel has private sandy beach, beds, umbrellas, beach towels are free of charge.
Sports and entertainment: The outdoor and indoor pool for adults and children, aqua park, fitness center, Turkish bath, sauna, steam bath, tennis court, table tennis, mini football, squash, beach volleyball are free of charge. Tennis lighting and equipment, all water sports, SPA & wellness centers, billiards, bowls are at a charge. Animated program during the day and evening show program with professional team. Mini Club for children for 04-12 years.