FREE ground shipping on orders over $1,000
SELECT DISTINCT search_index1.Part_Number, MATCH (`full_vehicle` , `long_description`) AGAINST ('1930' IN BOOLEAN MODE ) AS rev FROM hotchkis406.search_index1 left join hotchkis406.item_segment itsg on search_index1.Part_Number=itsg.Part_Number and discontinueFlag!='D' WHERE (long_description LIKE '%1930%' OR full_vehicle LIKE '%1930%' OR search_index1.Part_Number LIKE '%1930%') OR ( MATCH ( `full_vehicle` , `long_description` ) AGAINST ( '1930' IN BOOLEAN MODE ) ) order by rev DESC LIMIT 0,12
Search Keyword: 1930
Found 2 item(s) matching your search.
Hotchkis Sport Suspension 1930 1964 1/2 - 1970 Ford Mustang Coupe Fastback and Convertible Small ...
$208.00
SKU: 1930F