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 Vogue Hotel Supreme Bodrum
Located in the seafront in Torba Bay, surrounded by pine trees, Vogue Hotel Supreme Bodrum, has a total surface area of 400,000 m² and features outdoor pools with 25 water slides at Candyland area, spa facilities, a sand pit and an amusement park for kids. This 5-star property has two beaches that are 750 m long in total. The hotel offers ultra all-inclusive service.
Tastefully decorated, the rooms of Vogue Hotel include a flat-screen TV, air conditioning, free high-speed WiFi, safe and a minibar. All rooms have a balcony including a seating area. Some rooms also offer sea views. Complimentary tea&coffee setup is offered for each room.
The main restaurant serves breakfast, lunch and dinner in open buffet style. There are 4 à la carte restaurants on site, serving selected dishes from Italian, far east, Turkish and sea food cuisine. There is a patisserie at the property and guests can also enjoy a variety of cocktails and coffees from 11 bars on site.
Zumba dance and yoga classes are offered at the property. Football, basketball courts and tennis court are also available at Vogue Hotel Supreme Bodrum. Guests can also enjoy table tennis, archery, beach volley, water sports, bowling, scuba diving and game room for fun times. Vogue Bodrum also features 4 meeting and banquet facilities. Young guests can enjoy activities at Candytown. They can attend workshops about different occupational groups and receive a certificate.
A wide range of SPA facilities included in Vogue Bodrum are Turkish bath, far east massages, Ayurveda treatments, natural cures, aesthetic treatments and hairdressers.
Milas-Bodrum Airport is just a 25-minute drive from this hotel. Bodrum city centre is 8 km away.