Warning: mysqli_connect(): Headers and client library minor version mismatch. Headers:30316 Library:30206 in /home/leosyaqwe/domains/leosyacht.com/public_html/netfox/connection.php on line 14
Leo's Yacht select `post`.*,`medias`.`m_img`,`categories`.`cat_name`,`cat_b`.`m_img` as `cat_banner` from `post` left join `medias` on `medias`.`i_id`=`post`.`t_img`left join `categories` on `categories`.`id`=`post`.`cat_id` left join `medias` cat_b on `cat_b`.`i_id`=`categories`.`b_img` WHERE `post`.`post_type`="destination" and `post`.`hide_pro`=0 and `post`.`url_name`="ain-dubai"
Ain Dubai

Ain Dubai

The worlds tallest ferris wheel situated on blue waters island at dubai marina, the wheel will be able to carry up to 1400 passengers, in it's 48 capsules and provide views of dubai marina, burj al arab, palm jumeriah & burj khalifa.

Back

© All rights reserved 2026 Leos yacht.