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 = 'Automatic Shifters' AND SubCat1 = 'StarShifter' ORDER BY m.Rank ASC,m.PartNumber ASC LIMIT 0,15
Features include NHRA/ IHRA reverse lockout, backup light switch, neutral safety switch, polished T-handle. Cable operated for quick installation and accurate shifting. F...more details
Part #: 80675
Price: $210.99