UAE

Post an Ad

2017-08-18 08:53:59

Array ( [sub_category_2] => 29 ) -----SELECT a1.ad_id, `ad_title`, `ad_price`, `ad_main_photo`, `category_id`, `ad_date`, `main_photo_status`, `ad_photo_1`, `photo_1_status`, `ad_photo_2`, `photo_2_status`, `user_id`, `city`, `land_mark`, `ad_photo_3`, `photo_3_status`, `ad_photo_4`, `photo_4_status`, `ad_photo_5`, `photo_5_status`, `ad_photo_6`, `photo_6_status`, `ad_photo_7`, `photo_7_status`, `ad_photo_8`, `photo_8_status`, `ad_photo_9`, `photo_9_status`,`bedroom`,`bathroom`,`area`,`seller_type` FROM `tbl_ad` a1, tbl_ad_field a2 WHERE a1.city='Ras Al Khaimah' AND a1.ad_featured=0 AND a1.ad_status=1 AND a1.category_id in (29,1642,1643,1644,1645,1646,1647,1648,1649,1650,1651,1652,1653,1654,1655,1656,1657,1658,1659,1660,1661,1662,1663,1664,1665,1666,1667,1668,1669,1670,1671,1672,1673,1674,1675,1676,1677,1678,1679,1680,1681,1682,1683,1684,1685,1686,1687,1688,1689,1690,1691,1692,1693,1694,1695,1696,1697,1698,1699,1700,1701,1702,1703,1704,1705,1706,1707,1708,1709,1710,1711) AND a1.ad_id = a2.ad_id group by a1.ad_id ORDER BY a1.ad_id DESC limit 0, 20

0 ads for Sports Equipments in Ras Al Khaimah

Featured Ad not Available.

No Ads Found

60