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
Get the celebrity treatment with world-class service at Maxx Royal Belek Golf Resort - Kids Concept
Maxx Royal Belek Golf Resort offering extensive and unique facilities specifically-tailored for kids. Located on a 500 m² area, the mini club comes with a playground, mini disco, aquaparks, gymnastic areas and board games .Kids can have creative activities at the mini club. A number of games and a special sand area that is under shade can be found at the beach area for free.
Mini clubs are designated specially for kids between the age of 1-3, 4-7 and 13 -17. There is a camera system in the mini club for the kids between the ages of 1-3 which can be watched in the room as well. Kids younger than 1 year old can be guarded at the mini club. Sleeping room and playroom for babies are available free of charge.
Strollers can be provided upon your request at a surcharge for your convenience. Baby cots, baby pools, baby bathtub and high feeding chairs are offered upon availability. Other baby facilities include bottle warmer and blenders to facilitate your meal preparations. The restaurant comes with a designated area for kids.
The stylish suites are decorated in soothing tones and provide plenty of space. Each room is fitted with wooden floors, LCD TV and a well stocked minibar.
Restaurants at Maxx Royal Belek offer international cuisine including Japanese, Mediterranean, Greek and Turkish specialties. For a refreshing drink, guests can visit as many as 13 bars, each with a distinctive design. Azura Bar is open for 24/7. The Chocolatier offers delicious homemade chocolates, and the bakery Le Melange serves a variety of desserts and cakes.
With a Mediterranean beach setting, the luxurious Maxx Royal Belek Golf Resort offers 7 pools and 5 restaurants. It has an on-site fun fair and a world-class 18-hole golf course. Maxx Royal Spa Centre offers massage rooms, skin treatments and a traditional Turkish bath. Maxx Royal entertainment staff organises daily activities and water sports can be enjoyed on the hotel's private beach.
This 5-star complex is located 1 km from the shops, restaurants and nightclubs of Belek. Antalya Airport is 35 km from Maxx Royal Belek Golf Resort.