HILTON AL HABTOOR CITY DUBAI
Sheikh Zayed Rd - Dubai - United Arab EmiratesIdeally located on Sheikh Zayed Road, a few minutes drive away from the Burj Khalifa and the Dubai Mall (free shuttle from the hotel)
SELECT wp0l_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM wp0l_postmeta price_meta2 WHERE price_meta2.post_id=wpml_translations_default.element_id AND price_meta2.meta_key='_accommodation_min_price:2025-05-23:2027-05-23' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM wp0l_postmeta price_meta3 WHERE price_meta3.post_id=wpml_translations_default.element_id AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM wp0l_posts INNER JOIN wp0l_postmeta ON ( wp0l_posts.ID = wp0l_postmeta.post_id ) JOIN wp0l_icl_translations wpml_translations
ON wp0l_posts.ID = wpml_translations.element_id
AND wpml_translations.element_type = CONCAT('post_', wp0l_posts.post_type) LEFT JOIN wp0l_icl_translations wpml_translations_default ON wpml_translations_default.trid = wpml_translations.trid AND (wpml_translations_default.source_language_code IS NULL OR wpml_translations.source_language_code IS NULL)
WHERE 1=1 AND (
( wp0l_postmeta.meta_key = 'accommodation_location_post_id' AND wp0l_postmeta.meta_value IN ('1889') )
) AND wp0l_posts.post_type = 'accommodation' AND ((wp0l_posts.post_status = 'publish')) AND ( ( ( wpml_translations.language_code = 'en' OR (
wpml_translations.language_code = 'he'
AND wp0l_posts.post_type IN ( 'e-landing-page','e-floating-buttons','location','review','extra_item','room_type','accommodation','tour','car_rental','elementor_font','elementor_icons' )
AND ( (
( SELECT COUNT(element_id)
FROM wp0l_icl_translations
WHERE trid = wpml_translations.trid
AND language_code = 'en'
) = 0
) OR (
( SELECT COUNT(element_id)
FROM wp0l_icl_translations t2
JOIN wp0l_posts p ON p.id = t2.element_id
WHERE t2.trid = wpml_translations.trid
AND t2.language_code = 'en'
AND (
p.post_status = 'publish' OR p.post_status = 'private' OR
( p.post_type='attachment' AND p.post_status = 'inherit' )
)
) = 0 ) )
) ) AND wp0l_posts.post_type IN ('post','page','attachment','wp_template','wp_template_part','e-landing-page','e-floating-buttons','elementor_library','elementor_snippet','elementskit_content','elementskit_template','location','review','extra_item','room_type','accommodation','tour','car_rental','wpcf7_contact_form','elementor_font','elementor_icons' ) ) OR wp0l_posts.post_type NOT IN ('post','page','attachment','wp_template','wp_template_part','e-landing-page','e-floating-buttons','elementor_library','elementor_snippet','elementskit_content','elementskit_template','location','review','extra_item','room_type','accommodation','tour','car_rental','wpcf7_contact_form','elementor_font','elementor_icons' ) )
GROUP BY wp0l_posts.ID HAVING 1=1
ORDER BY wp0l_posts.post_title ASC
Hilton Dubai Al Habtoor City
Hilton Dubai Al Habtoor City - Sheikh Zayed Road - Dubai - United Arab Emirates
From
₪
We’re off Sheik Zayed Road and next door to La Perle by Franco Dragone. Downtown Dubai sights, shops, and restaurants are a 10-minute drive away from our family-friendly hotel.
Hilton Garden Inn Mall of the Emirates
Hilton Garden Inn Dubai Mall Of The Emirates - 22nd Street - Dubai - United Arab Emirates
From
₪
Off Sheikh Zayed Road, we're next to the Mall of the Emirates, and within a kilometer of two metro stations.
Waldorf Astoria Ras Al Khaimah
Waldorf Astoria Ras Al Khaimah, hotel, Ras Al Khaimah, United Arab Emirates
From
₪
A hidden haven in the peaceful Emirate of Ras Al Khaimah, Waldorf Astoria Ras Al Khaimah is an ideal destination for an unforgettable getaway.
5 לילות ב- Crowne Plaza Sheik Zayed Dubai + העברות
קראון פלאזה שייק זייד דובאי
From
₪
5 לילות בכביש קראון פלאזה שייק זייד
Abu Dhabi City tour
Abu Dhabi - United Arab Emirates
From
₪
A tour carefully crafted to give you significant sights of the city of Abu Dhabi, UAE's capital .
Dolphin encounter Atlantis Dubai
Atlantis, The Palm - Crescent Road - Dubai - United Arab Emirates
From
₪
A Dolphin Bay experience in Atlantis where you can meet and interact with the dolphins in the shallow water of the lagoon.
Hot Air Balloon Dubai
Dubai - United Arab Emirates
From
₪
Hot air balloon is a one-of-a kind adventure in the air where you share the skies with birds while afloat the Arabian sands.
La Perle by Dragone Dubai
La Perle DXB, Al Habtoor City - Sheikh Zayed Road - Dubai - United Arab Emirates
From
₪
Located in the heart of Dubai at Al Habtoor City, La Perle is a unique aqua-stage show where actors and acrobats perform in, on and above water.
Sky Dive in Dubai
Dubai - United Arab Emirates
From
₪
Dive of a lifetime! For thrill seekers and extreme adventure lovers, experience skydiving in Dubai. Jump for a breathtaking free fall experience and parachute gliding in the skies of Dubai.
Visit Dubai Garden Glow
Dubai Garden Glow - Dubai - United Arab Emirates
From
₪
The theme park is taglined "What a Wonderful World". What makes this glowing park impressive is that it is made of recycled items with the aim of reducing carbon footprint.
Visit Laguna Water Park Dubai
Laguna Waterpark by Meraas, La Mer - Dubai - United Arab Emirates
From
₪
Laguna Waterpark features four distinct zones with best rides and attractions, luxury cabanas on the waterfront, beautiful infinity pool, complete with a swim-up juice bar and rooftop dining with panoramic views over the Arabian Gulf.
