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 = 'Unimatic' ORDER BY m.Rank ASC,m.PartNumber ASC LIMIT 0,15
The B&M Unimatic is an ideal replacement for column shift vehicles, includes neutral safety switch, 5 foot cable and a boot and plate....more details
Part #: 80775
Price: $182.19