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`="dubai-water-canal"

Dubai Water Canal

The canal is a 3.2 kilometers long that stretches from old arabian gulf, canal side walk comprises shopping malls, hotels, restaurants luxury housing, walk ways, cycle paths and many more .

© All rights reserved 2024 Leos yacht.