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 Azmeel General Trading W.l.l , Manama , Bahrain
Libya Yellow Pages Online
Video Gallery

View More

Our Activities

Complete solution for building & construction materials supply including Sand, Aggregate, paints, Blocks, Cement, Plumbing items, electrical items, plywood. white wood and other related items


View More

Product Categories

Catalogue

Our Management Team


Danish Danish

View More

Certificates

View More

Location
Manama

Year Established

Business Type

Turn over
US$ NA

Employees
NA

Main Markets
BAHRAIN