Select CompanyProdID,producttitle,productdesc,productimagefilepath,ProductName,a.productid,b.groupid,maingroupnameurl,a.companyid from trncompanyprod_forsearch a inner JOIN mstproduct b
on a.ProductID=b.ProductId inner 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 limit 0, 3000 Sanitary Ware from Obaid Masood Building Materials Trading LLC in Dubai, United Arab Emirates
Obaid Masood Building Materials Trading LLC - | E-Showroom
Obaid Masood Building Materials Trading LLC
Ground Floor, Easa Saleh Al Gurg Complex, Office # 1, Street # 7, Ras Al,Khor, Dubai Near Oman Transport P.O.Box: 44033, Dubai Dubai
United Arab Emirates
Obaid Masood Building Materials Trading LLC was established in 1995 with registered activity being Building & Construction Materials Trading. Our Registered Office & Logistics Center is currently located at convenient location in Ras Al Khor, Aweer, Dubai – UAE.
Our Prime Business is distribution & supply to Construction Companies, MEP Contractors, Prefabricated House Manufacturers, Hotels & Hospitality Industry, Institutional Clients & Fabrication Companies in the Emirates & GCC.
PLUMBING PRODUCTS
ANCILLARY PRODUCTS
