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 Steering Bearings from Delux Bearings Pvt. Ltd. in Mumbai, India
Delux Bearings Ltd., started operations in 1956 to manufacture automotive, industrial bearings, textile and precision components. We have a major presence with Indian Automotive OEMs and also cater to Indian Auto After market. We export to USA, Germany, Italy, Brazil, Korea, UK & 50 countries.
From inception, inspiration and determination has propelled us to excellence. We always strive to be a leader of our segment by continuously raising the bar of expectations, and design ground breaking innovations in every product we launch. Our advanced process engineering, manufacturing and testing facilities include a Research and Development setup, Quality Systems and well equipped CNC Turning, Heat Treatment, CNC Grinding, Ultrasonic Washing and Automatic Assembly.
