SELECT DISTINCT m.PartNumber FROM bmnew.mapping m INNER JOIN dpbrands.partslifecycle pl ON m.partNumber = pl.PartNumber and (pl.Status<>'8') WHERE m.PartNumber != '' AND MainCat = 'Manual Shifters' AND SubCat1 = 'Honda' ORDER BY m.Rank ASC,m.PartNumber ASC LIMIT 0,15
B&M Precision aftermarket shifters; put one in your Honda Civic and find out what 50 plus years worth of engineering know-how can do for you. It features a 303 stainless...more details
Part #: 45047
Price: $64.24
Qty:
B&M Precision aftermarket shifters; put one in your Honda/Acura and find out what 50 plus years worth of engineering know-how can do for you. It features a 303 stainless...more details
Part #: 45075
Price: $64.24
Qty: