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=4521 and pa.subcategory_id=4640 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 | |
|---|---|---|---|---|---|---|---|---|---|---|
| 5 in. Curved Jaw Pliers w/Grip | milwaukee | 23.76 | CAT4640XZ |
C$ 23.76
In Stock
| Yes | No | ||||
| 1 | 7 in. Curved Jaw Pliers w/Grip | milwaukee | 24.96 | CAT4640XZ |
C$ 24.96
In Stock
| Yes | No | |||
| 2 | 9 in. Long Nose Pliers w/Grip | milwaukee | 33.25 | CAT4640XZ |
C$ 33.25
In Stock
| Yes | No | |||
| 3 | 10 in. Curved Jaw Pliers w/Grip | milwaukee | 25.62 | CAT4640XZ |
C$ 25.62
In Stock
| Yes | No | |||
| 4 | 10 in. Curved Jaw Pliers | milwaukee | 27.44 | CAT4640XZ |
C$ 27.44
In Stock
| Yes | No | |||
| 5 | 7 in. Curved Jaw Pliers | milwaukee | 22.61 | CAT4640XZ |
C$ 22.61
In Stock
| Yes | No | |||
| 6 | 5 in. Curved Pliers | milwaukee | 21.44 | CAT4640XZ |
C$ 21.44
In Stock
| Yes | No | |||
| 7 | 4 in. Long Nose Pliers | milwaukee | 22.13 | CAT4640XZ |
C$ 22.13
In Stock
| Yes | No | |||
| 8 | 7 in. Straight Jaw Pliers | milwaukee | 25.62 | CAT4640XZ |
C$ 25.62
In Stock
| Yes | No | |||
| 9 | 9 in. Long Nose Pliers | milwaukee | 29.87 | CAT4640XZ |
C$ 29.87
In Stock
| Yes | No | |||
| 10 | 10 in. Straight Jaw Pliers | milwaukee | 27.44 | CAT4640XZ |
C$ 27.44
In Stock
| Yes | No | |||
| 11 | 11 in. C-Clamp w/Swivel Jaws | milwaukee | 44.4 | CAT4640XZ |
C$ 44.40
In Stock
| Yes | No | |||
| 12 | 6 in. C-Clamp w/Regular Jaws | milwaukee | 27.3 | CAT4640XZ |
C$ 27.30
In Stock
| Yes | No | |||
| 13 | 9 in. Clamp w/Deep Jaws | milwaukee | 34.19 | CAT4640XZ |
C$ 34.19
In Stock
| Yes | No | |||
| 14 | 8 in. Seamer | milwaukee | 35.84 | CAT4640XZ |
C$ 35.84
In Stock
| Yes | No | |||
| 15 | 12 in. Curved Jaw Pliers w/Lg Jaw | milwaukee | 36.42 | CAT4640XZ |
C$ 36.42
In Stock
| Yes | No | |||
| 16 | 9 in. Welder'S Clamp | milwaukee | 43.18 | CAT4640XZ |
C$ 43.18
In Stock
| Yes | No | |||
| 17 | 2Pc Crvd Jaw & 6 in. Lng Nose Plier | milwaukee | 44.88 | CAT4640XZ |
C$ 44.88
In Stock
| Yes | No | |||
| 18 | 10Pc Pliers Kit | milwaukee | 257.26 | CAT4640XZ |
C$ 257.26
In Stock
| Yes | No | |||
| 19 | 7 in. Straight Jaw Pliers w/Grip | milwaukee | 28 | CAT4640XZ |
C$ 28.00
In Stock
| Yes | No | |||
| 20 | 10 in. Straight Jaw Pliers w/Grip | milwaukee | 30.83 | CAT4640XZ |
C$ 30.83
In Stock
| Yes | No | |||
| 21 | 10" Curved Jaw Locking Pliers with Cutter | surewerx-jet | 49.56 | CAT4640XZ |
C$ 49.56
In Stock
| Yes | No | |||
| 22 | 2Pc Curved Jaw Pliers Set w/Grip | milwaukee | 47.52 | CAT4640XZ |
C$ 47.52
Limited Stock
| Yes | No | |||
| 23 | 4 in. Curved Jaw Pliers | milwaukee | 20.34 | CAT4640XZ |
C$ 20.34
Limited Stock
| Yes | No | |||
| 24 | 6 Inch C-Clamp w/Swivel Jaws | milwaukee | 28.45 | CAT4640XZ |
C$ 28.45
Limited Stock
| Yes | No | |||
| 25 | 9 in. Clamp w/Swivel Jaws | milwaukee | 34.19 | CAT4640XZ |
C$ 34.19
Limited Stock
| Yes | No | |||
| 26 | 11 in. C-Clamp w/Regular Jaws | milwaukee | 41.81 | CAT4640XZ |
C$ 41.81
Limited Stock
| Yes | No | |||
| 27 | 9 in. Chain Wrench | milwaukee | 51.62 | CAT4640XZ |
C$ 51.62
Limited Stock
| Yes | No | |||
| 28 | 7 in. Curved Pliers | milwaukee | 24.61 | CAT4640XZ |
C$ 24.61
Limited Stock
| Yes | No | |||
| 29 | 10 in. Curved Pliers | milwaukee | 28.88 | CAT4640XZ |
C$ 28.88
Limited Stock
| Yes | No | |||
| 30 | 11 in. Clamp w/Reg Jaws and Grip | milwaukee | 45.41 | CAT4640XZ |
C$ 45.41
Limited Stock
| Yes | No | |||
| 31 | 6 in. Clamp w/Regular Jaws and Grip | milwaukee | 30.85 | CAT4640XZ |
C$ 30.85
Limited Stock
| Yes | No | |||
| 32 | 2 Pc 7 in. & 10 in. Pliers Set | milwaukee | 54.4 | CAT4640XZ |
C$ 54.40
Limited Stock
| Yes | No | |||
| 33 | 7 in. Curved Jaw Pliers w/Grip | milwaukee | 31.44 | CAT4640XZ |
C$ 31.44
Limited Stock
| Yes | No | |||
| 34 | 10 in. Curved Jaw Pliers w/Grip | milwaukee | 33.79 | CAT4640XZ |
C$ 33.79
Limited Stock
| Yes | No | |||
| 35 | 5 PC Locking Pliers Set - Super Heavy Duty | surewerx-jet | 275.16 | CAT4640XZ |
C$ 275.16
Limited Stock
| Yes | No | |||
| 36 | 5" Curved Jaw Locking Pliers with Cutter | surewerx-jet | 43.39 | CAT4640XZ |
C$ 43.39
Limited Stock
| Yes | No | |||
| 37 | 7" Curved Jaw Locking Pliers with Cutter - Cushion Grip | surewerx-jet | 53.71 | CAT4640XZ |
C$ 53.71
Limited Stock
| Yes | No | |||
| 38 | 6" Long Nose Locking Pliers with Cutter | surewerx-jet | 51.65 | CAT4640XZ |
C$ 51.65
Limited Stock
| Yes | No | |||
| 39 | 9" Long Nose Locking Pliers with Cutter | surewerx-jet | 55.82 | CAT4640XZ |
C$ 55.82
Limited Stock
| Yes | No | |||
| 40 | 3 PC Cushion Grip Locking Pliers Set | itc | 61.44 | CAT4640XZ |
C$ 61.44
| No | No | |||
| 41 | 5 PC Locking Pliers Set | itc | 99.73 | CAT4640XZ |
C$ 99.73
| No | No | |||
| 42 | 6 in. Long Nose Pliers w/Grip | milwaukee | 29.7 | CAT4640XZ |
C$ 29.70
| No | No | |||
| 43 | 6 in. Long Nose Pliers | milwaukee | 25.84 | CAT4640XZ |
C$ 25.84
| No | No | |||
| 44 | 7" Curved Jaw Locking Pliers with Cutter | surewerx-jet | 47.51 | CAT4640XZ |
C$ 47.51
| No | No | |||
| 45 | 4" Long Nose Locking Pliers with Cutter | surewerx-jet | 45.42 | CAT4640XZ |
C$ 45.42
| No | No | |||
| 46 | 18 in. Clamp w/Swivel Jaws | milwaukee | 62.82 | CAT4640XZ |
C$ 62.82
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 47 | 18 in. Clamp w/Deep Jaws | milwaukee | 67.62 | CAT4640XZ |
C$ 67.62
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 48 | 18 in. Clamp w/Regular Jaws | milwaukee | 55.6 | CAT4640XZ |
C$ 55.60
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 49 | 5Pc Pliers Kit | milwaukee | 82.22 | CAT4640XZ |
C$ 82.22
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 50 | 6-Piece Axial Grip Locking Pliers Set | surewerx-jet | 446.93 | CAT4640XZ |
C$ 446.93
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 51 | 10" Curved Jaw Locking Pliers with Cutter - Cushion Grip | surewerx-jet | 57.83 | CAT4640XZ |
C$ 57.83
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 52 | 8 Axial Grip Locking Pliers W Jaw | surewerx-jet | 82.69 | CAT4640XZ |
C$ 82.69
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 53 | 9 Axial Grip Locking Pliers JJ Jaw | surewerx-jet | 82.69 | CAT4640XZ |
C$ 82.69
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 54 | 8 Axial Grip Locking Pliers LL Jaw | surewerx-jet | 82.69 | CAT4640XZ |
C$ 82.69
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 55 | 8 Axial Grip Locking Pliers J Jaw | surewerx-jet | 82.69 | CAT4640XZ |
C$ 82.69
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 56 | 7 Axial Grip Locking Pliers L Jaw | surewerx-jet | 82.69 | CAT4640XZ |
C$ 82.69
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 57 | 7 Axial Grip Locking Pliers T Jaw | surewerx-jet | 82.69 | CAT4640XZ |
C$ 82.69
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No |