Select CompanyProdID,producttitle,productimagefilepath,ProductName,a.productid,b.groupid,maingroupnameurl from trncompanyprod_forsearch a left JOIN mstproduct b on a.ProductID=b.ProductId left join mstmaingroup c on b.maingroupid=c.maingroupid where a.CompanyID= ? and a.isproductapproved=1 ORDER by ProductOrderNo=0, ProductOrderNo ASC,productimagefilepath desc, a.productlastmodifieddate desc,companyprodid desc Get Classed , Dubai , United Arab Emirates
Nigeria Yellow Pages Online
Video Gallery

View More

Our Activities

Get classed is one of the top UAE classified ad company. Offering some top advertising patterns, indulged with modern trends to create an impact to distract your viewers from your competitors. As being a Dubai classified company, we will keep your ads on the top to increase their availability and enhance your sales. Get classed is the top classified in UAE company you get opt-in the cheapest prices ever, our dedicated will make sure your ads are classified in Dubai, you will not regret our services ever!


View More

Product Categories

Catalogue

Our Management Team


Get Classed

View More

Certificates

View More

Location
Dubai

Year Established

Business Type

Turn over
US$ NA

Employees
NA

Main Markets
United Arab Emirates