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`="atlants-the-palm"
Atlants - The Palm
This is one of dubai's luxurious hotel resort, situated on the heart of palm jumeriah and surrounded by many international hotel chains. palm jumeriah is one of the man made islands in dubai.
+971 52 221 4480
