647-330-5754

A Canadian Company

0
Close
filters

Showing 1 to x of xx results
#namebrandpricecategorystocksaleOilTypeOilVolOilGrade
PG365 - ADJUSTABLE FUEL LINE PLIERS calvan-horizon-tools 52.88 CAT4119XZ Yes No
1 PG365 - BMW INJECTOR LINE SOCKETS 14MM & 17MM 12 POINT, 3/8" DR. sp-tools-schley-products 61.2 CAT4119XZ Yes No
2 PG365 - 19MM & 22MM FUEL LINE SOCKETS FOR CUMMINS ISB AND ISX ENGINES lisle-corporation 64.14 CAT4119XZ Yes No
3 PG365 - 5-PC FUEL LINE FLEX SOCKETS, SIZES: 11, 13, 14, 15, 17MM cta 207.11 CAT4119XZ Yes No
4 PG365 - DETROIT DIESEL INJECTOR LINE SOCKET assenmacher 66.32 CAT4119XZ Yes No
5 PG365 - HYDROCARBON INJECTION QUICK CONNECTOR RELEASE TOOL, 4.MM (3/16"), WORKS ON 2010+ GM 2.8L & 6.6L DIESEL ENGINES otc-tools 96.53 CAT4119XZ No No
Select pa.*, b.title bnm, b.title_seo bnmseo, b.discount bdiscount, c.title cnm, c.title_seo cnmseo, c.discount cdiscount, c1.title scnm, c1.title_seo scnmseo, c1.discount scdiscount from pa LEFT JOIN brands b ON pa.brand_id = b.id and b.visible=0 LEFT JOIN categories c ON pa.category_id = c.id and c.visible=0 LEFT JOIN categories c1 ON pa.subcategory_id = c1.id and c1.visible=0 where pa.visible=0 and pa.delflag=0 and pa.category_id=4117 and pa.subcategory_id=4119 order by pa.featured desc,pa.sort_order,FIELD(status,1,3,6,5,1,4,2)
Close Filters
Brands
Price
C$ 52 C$ 218