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=4639 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 | |
|---|---|---|---|---|---|---|---|---|---|---|
| 6" C-Clamp | itc | 38.17 | CAT4639XZ |
C$ 38.17
Limited Stock
| Yes | No | ||||
| 1 | 4" CSG Series C-Clamp | surewerx-jet | 51.13 | CAT4639XZ |
C$ 51.13
Limited Stock
| Yes | No | |||
| 2 | 11" Locking C-Clamp | surewerx-jet | 78.53 | CAT4639XZ |
C$ 78.53
Limited Stock
| Yes | No | |||
| 3 | 11" Locking C-Clamp with Swivel Pads | surewerx-jet | 86.84 | CAT4639XZ |
C$ 86.84
Limited Stock
| Yes | No | |||
| 4 | 8" Locking Sheet Metal Clamp | surewerx-jet | 76.49 | CAT4639XZ |
C$ 76.49
Limited Stock
| Yes | No | |||
| 5 | 3" C-Clamp | itc | 24.83 | CAT4639XZ |
C$ 24.83
| No | No | |||
| 6 | 4" C-Clamp | itc | 31.49 | CAT4639XZ |
C$ 31.49
| No | No | |||
| 7 | 8" C-Clamp | itc | 51.48 | CAT4639XZ |
C$ 51.48
| No | No | |||
| 8 | 12" L-Clamp | surewerx-jet | 175.33 | CAT4639XZ |
C$ 175.33
| No | No | |||
| 9 | 12" L-Clamp Heavy Duty | surewerx-jet | 252.89 | CAT4639XZ |
C$ 252.89
| No | No | |||
| 10 | 16" L-Clamp Heavy Duty | surewerx-jet | 270 | CAT4639XZ |
C$ 270.00
| No | No | |||
| 11 | 4" Steel Spring Clamp | surewerx-jet | 6.61 | CAT4639XZ |
C$ 6.61
| No | No | |||
| 12 | 6" Locking C-Clamp | surewerx-jet | 51.65 | CAT4639XZ |
C$ 51.65
| No | No | |||
| 13 | 6" Locking C-Clamp with Swivel Pads | surewerx-jet | 55.82 | CAT4639XZ |
C$ 55.82
| No | No | |||
| 14 | 9" Locking Welder's Clamp | surewerx-jet | 80.58 | CAT4639XZ |
C$ 80.58
| No | No | |||
| 15 | 2" C-Clamp | itc | 18.24 | CAT4639XZ |
C$ 18.24
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 16 | 2" C-Clamp Heavy Duty | surewerx-jet | 48.06 | CAT4639XZ |
C$ 48.06
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 17 | 3" C-Clamp Heavy Duty | surewerx-jet | 72.89 | CAT4639XZ |
C$ 72.89
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 18 | 4" C-Clamp Heavy Duty | surewerx-jet | 93.06 | CAT4639XZ |
C$ 93.06
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 19 | 5" C-Clamp Heavy Duty | surewerx-jet | 134.94 | CAT4639XZ |
C$ 134.94
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 20 | 6" C-Clamp Heavy Duty | surewerx-jet | 138.06 | CAT4639XZ |
C$ 138.06
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 21 | 8" C-Clamp Heavy Duty | surewerx-jet | 193.91 | CAT4639XZ |
C$ 193.91
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 22 | 10" C-Clamp Heavy Duty | surewerx-jet | 377.11 | CAT4639XZ |
C$ 377.11
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 23 | 12" C-Clamp Heavy Duty | surewerx-jet | 512.15 | CAT4639XZ |
C$ 512.15
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 24 | 6" CSG Series C-Clamp | surewerx-jet | 65.11 | CAT4639XZ |
C$ 65.11
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 25 | 8" CSG Series C-Clamp | surewerx-jet | 83.76 | CAT4639XZ |
C$ 83.76
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 26 | 10" CSG Series C-Clamp | surewerx-jet | 108.61 | CAT4639XZ |
C$ 108.61
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 27 | 12" CSG Series C-Clamp | surewerx-jet | 139.63 | CAT4639XZ |
C$ 139.63
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 28 | 6" L-Clamp | surewerx-jet | 111.65 | CAT4639XZ |
C$ 111.65
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 29 | 8" L-Clamp | surewerx-jet | 155.15 | CAT4639XZ |
C$ 155.15
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 30 | 10" L-Clamp | surewerx-jet | 159.78 | CAT4639XZ |
C$ 159.78
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 31 | 16" L-Clamp | surewerx-jet | 206.35 | CAT4639XZ |
C$ 206.35
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 32 | 20" L-Clamp | surewerx-jet | 238.98 | CAT4639XZ |
C$ 238.98
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 33 | 8" L-Clamp Heavy Duty | surewerx-jet | 175.33 | CAT4639XZ |
C$ 175.33
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 34 | 10" L-Clamp Heavy Duty | surewerx-jet | 206.35 | CAT4639XZ |
C$ 206.35
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 35 | 20" L-Clamp Heavy Duty | surewerx-jet | 310.37 | CAT4639XZ |
C$ 310.37
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 36 | 24" L-Clamp Heavy Duty | surewerx-jet | 339.13 | CAT4639XZ |
C$ 339.13
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 37 | 12" L-Clamp - Super Heavy Duty | surewerx-jet | 496.63 | CAT4639XZ |
C$ 496.63
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 38 | 16" L-Clamp - Super Heavy Duty | surewerx-jet | 574.2 | CAT4639XZ |
C$ 574.20
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 39 | 20" L-Clamp - Super Heavy Duty | surewerx-jet | 586.63 | CAT4639XZ |
C$ 586.63
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 40 | 24" L-Clamp - Super Heavy Duty | surewerx-jet | 603.72 | CAT4639XZ |
C$ 603.72
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 41 | 6" Steel Spring Clamp | surewerx-jet | 11.63 | CAT4639XZ |
C$ 11.63
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No |