A Canadian Company
filters
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=4772 and pa.subcategory_id=4919 order by pa.featured desc,pa.sort_order,FIELD(status,1,3,6,5,1,4,2)
Showing 1 to x of xx results
| # | name | brand | price | category | stock | sale | OilType | OilVol | OilGrade | |
|---|---|---|---|---|---|---|---|---|---|---|
| CRC Leak Detector (F/E) 12X510G | crc | 8.33 | CAT4919XZ |
C$ 8.33
In Stock
| Yes | No | ||||
| 1 | KLEEN-SLIP SILICONE LUBRICANT | kleen-flo | 9 | CAT4919XZ |
C$ 9.00
In Stock
| Yes | No | |||
| 2 | HOLISTIC RUBBER CARE | kleen-flo | 9 | CAT4919XZ |
C$ 9.00
In Stock
| Yes | No | |||
| 3 | GREASE & WAX REMOVER | sherwin-williams-dupli-color | 22.02 | CAT4919XZ |
C$ 22.02
In Stock
| Yes | No | |||
| 4 | SUPERIOR LUB- AEROSOL 340G | sherwin-williams-tri-flow | 34.15 | CAT4919XZ |
C$ 34.15
In Stock
| Yes | No | |||
| 5 | LU202L MOLY CHAINLUBE 340G | sherwin-williams-tri-flow | 16.57 | CAT4919XZ |
C$ 16.57
In Stock
| Yes | No | |||
| 6 | WL739 SILVGALV COM 397G | sherwin-williams-tri-flow | 30.19 | CAT4919XZ |
C$ 30.19
Limited Stock
| Yes | No | |||
| 7 | CRC Kool Tap Foamy Cutting Fluid 12X369G | crc | 18.92 | CAT4919XZ |
C$ 18.92
| No | No | |||
| 8 | ACE METHYL ALCOHOL 100% PURE | kleen-flo | 5.47 | CAT4919XZ |
C$ 5.47
| No | No | |||
| 9 | BATTERY PROTECTOR 311G | sherwin-williams-dupli-color | 13.24 | CAT4919XZ |
C$ 13.24
| No | No | |||
| 10 | LU204 DRYFILMGRPH LUB 284G | sherwin-williams-tri-flow | 19.14 | CAT4919XZ |
C$ 19.14
| No | No | |||
| 11 | SP603 BLUE LAYOUT DYE 340G | sherwin-williams-tri-flow | 16.73 | CAT4919XZ |
C$ 16.73
| No | No | |||
| 12 | LU710 WAXY FILM PROT 340G | sherwin-williams-tri-flow | 16.09 | CAT4919XZ |
C$ 16.09
| No | No | |||
| 13 | 20027 TRI-FLOW LUBE 340G | sherwin-williams-tri-flow | 28.22 | CAT4919XZ |
C$ 28.22
| No | No | |||
| 14 | SUPERIOR LUBRICANT 170G | sherwin-williams-tri-flow | 20.33 | CAT4919XZ |
C$ 20.33
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 15 | LU200DRY FILM MOLYLUB 312G | sherwin-williams-tri-flow | 19 | CAT4919XZ |
C$ 19.00
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 16 | LU201 OPENGEAR LUBE 340G | sherwin-williams-tri-flow | 20.46 | CAT4919XZ |
C$ 20.46
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 17 | SP405 PAINT&ADHE REMR 340G | sherwin-williams-tri-flow | 17.65 | CAT4919XZ |
C$ 17.65
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 18 | SP606 LAYOUT DYE REMO 363G | sherwin-williams-tri-flow | 15.76 | CAT4919XZ |
C$ 15.76
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 19 | 20025 TRI-FLOW LUBE 9.8OZ | sherwin-williams-tri-flow | 12.85 | CAT4919XZ |
C$ 12.85
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No |