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 = 'Shifter Accessories' AND SubCat1 = 'Switches & Electrical' ORDER BY m.Rank ASC,m.PartNumber ASC LIMIT 0,15
This universal remote button and spiral cord is a great all-around unit and is ideal for bracket racing. They are designed for use with trans-brake, launch control, and n...more details
Part #: 46003
Price: $67.30
Qty: