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 Privé Club from Rixox is located among the pines near the Mediterranean Sea in Belek, 50 km from Antalya and 40 km from Antalya International Airport.
Placement: There are three different types. Club Villa - 164m², with 3 bedrooms each with bathroom with shower, hairdryer and special equipment for the bathroom, a living room, large terrace and private sunny area, fridge with soft drinks, individual air system, safe, marble and carpet floors, kitchen, in every mini-bar room, also satellite television in every room, direct access to the large pool shared with all Club Villa guests. and music. Villa Privé - 264m², private garden and private pool, 4 bedrooms with bathroom with shower, hairdryer and special equipment, a living room, private pool with sunny private area, mini bat in every room, fridge with soft drinks, kitchen, marble and carpeted floors, individual air system, safe box, satellite TV in every room. Paris Residence - 615m² offers a spacious and comfortable living space and makes you feel privileged. The villa has private pool with sunshine, private pavilion on the beach, 4 bedrooms with bathroom with bathtub, Jacuzzi in a bathroom and shower, hairdryer and separate bathroom amenities, mini bar in each room, living room, fridge with drinks soft, individual air-conditioned system, safe box, marble floor and carpet, fireplace, private and indoor heated pools, private pavilion in the garden and on the beach, private pier, satellite TV with every room, theater. Pryamus Residence - is located in a private area of 2000m², with 4 bedrooms with own bathroom, Jacuzzi, living room, dining room, serviced and waiting room, private dock and parking for 3 cars, BBQ in garden, fridge with refreshing, fireplace, marble and carpeted floors, private SPA center, private outdoor pool, private pavilion in the garden and on the beach, private pier.
Ultra All Inclusive - Organic Breakfast at the Club House or Villa Guest, at Lunch or Dinner at the Club House or Beach Lounge - Menu A'la Carte is available with light snacks, lounges and salads, seafood and sweet deserts , various cocktails, good selection of wines. A Private Pavilion, Return Airport Transfer (Antalya), Daily Fruit Refreshment, Mini Bar with Soft Drinks, Sitting Service, High Speed Wi-Fi in the Cottage and Public Areas, Bathrobe and Slippers, Beach Towel, Pillow Menu , 24 hours, entry and transfer to the Theme Park of Legends Land (swimming with Dolphins, Coaster Typhoon, all water slides, snorkeling, diving, free entrance to conceres). Not included: room service, private dining or event options, guest choice shopping, laundry and dry cleaning, babysitting, private fitness trainer, SPA, in-room massage, home cook, jet charter, helicopter and yacht charter.
Sports and Entertainment: Two Tennis Courts, Yoga, Pilates, Fitness Center, Sauna, Steam Room, Massage and SPA.
Club Privé P.S from Rixox guests can use the territory and facilities of Rixos Premium Hotel Belek throughout the stay period.