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=4205 and pa.subcategory_id=4215 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 | |
|---|---|---|---|---|---|---|---|---|---|---|
| PG261 - HEAVY DUTY METAL-WORKING CLAMP, 20" (500MM) CLAMPING CAPACITY | eclipse | 95.56 | CAT4215XZ |
C$ 95.56
In Stock
| Yes | No | ||||
| 1 | PG261 - HEAVY DUTY METAL-WORKING CLAMP, 16" (400MM) CLAMPING CAPACITY | eclipse | 90.43 | CAT4215XZ |
C$ 90.43
In Stock
| Yes | No | |||
| 2 | PG261 - HEAVY DUTY METAL-WORKING CLAMP, 12" (300MM) CLAMPING CAPACITY | eclipse | 84.38 | CAT4215XZ |
C$ 84.38
In Stock
| Yes | No | |||
| 3 | PG261 - ONE-HANDED BAR CLAMP & SPREADER, 6" CLAMPING CAPACITY, 6-5/8" 13-3/8" SPREADING CAPACITY, 3-3/8" THROAT DEPTH | eclipse | 24.07 | CAT4215XZ |
Eclipse
PG261 - ONE-HANDED BAR CLAMP & SPREADER, 6" CLAMPING CAPACITY, 6-5/8" 13-3/8" SPREADING CAPACITY, 3-3/8" THROAT DEPTHPart# ECL-EOHBC6C$ 24.07
In Stock
| Yes | No | |||
| 4 | PG261 - ONE-HANDED BAR CLAMP & SPREADER, 36" CLAMPING CAPACITY, 6-5/8" 43-7/8" SPREADING CAPACITY, 3-3/8" THROAT DEPTH | eclipse | 37.51 | CAT4215XZ |
Eclipse
PG261 - ONE-HANDED BAR CLAMP & SPREADER, 36" CLAMPING CAPACITY, 6-5/8" 43-7/8" SPREADING CAPACITY, 3-3/8" THROAT DEPTHPart# ECL-EOHBC36C$ 37.51
In Stock
| Yes | No | |||
| 5 | PG261 - ONE-HANDED BAR CLAMP & SPREADER, 24" CLAMPING CAPACITY, 6-5/8" 31-1/2" SPREADING CAPACITY, 3-3/8" THROAT DEPTH | eclipse | 31.72 | CAT4215XZ |
Eclipse
PG261 - ONE-HANDED BAR CLAMP & SPREADER, 24" CLAMPING CAPACITY, 6-5/8" 31-1/2" SPREADING CAPACITY, 3-3/8" THROAT DEPTHPart# ECL-EOHBC24C$ 31.72
In Stock
| Yes | No | |||
| 6 | PG261 - ONE-HANDED BAR CLAMP & SPREADER, 18" CLAMPING CAPACITY, 6-5/8" 25-3/8" SPREADING CAPACITY, 3-3/8" THROAT DEPTH | eclipse | 30.71 | CAT4215XZ |
Eclipse
PG261 - ONE-HANDED BAR CLAMP & SPREADER, 18" CLAMPING CAPACITY, 6-5/8" 25-3/8" SPREADING CAPACITY, 3-3/8" THROAT DEPTHPart# ECL-EOHBC18C$ 30.71
In Stock
| Yes | No | |||
| 7 | PG261 - ONE-HANDED BAR CLAMP & SPREADER, 12" CLAMPING CAPACITY, 6-5/8" 19-1/2" SPREADING CAPACITY, 3-3/8" THROAT DEPTH | eclipse | 26.59 | CAT4215XZ |
Eclipse
PG261 - ONE-HANDED BAR CLAMP & SPREADER, 12" CLAMPING CAPACITY, 6-5/8" 19-1/2" SPREADING CAPACITY, 3-3/8" THROAT DEPTHPart# ECL-EOHBC12C$ 26.59
In Stock
| Yes | No | |||
| 8 | PG261 - HEAVY DUTY METAL-WORKING CLAMP, 20" (500MM) CLAMPING CAPACITY | eclipse | 95.56 | CAT4215XZ |
C$ 95.56
In Stock
| Yes | No | |||
| 9 | PG261 - HEAVY DUTY METAL-WORKING CLAMP, 16" (400MM) CLAMPING CAPACITY | eclipse | 90.43 | CAT4215XZ |
C$ 90.43
In Stock
| Yes | No | |||
| 10 | PG261 - HEAVY DUTY METAL-WORKING CLAMP, 12" (300MM) CLAMPING CAPACITY | eclipse | 84.38 | CAT4215XZ |
C$ 84.38
In Stock
| Yes | No | |||
| 11 | PG261 - SPARK-DUTY 400CS HI-VIS C-CLAMP KIT, 2", 4", 6", 8" CAPACITIES | wilton | 213.97 | CAT4215XZ |
C$ 213.97
In Stock
| Yes | No | |||
| 12 | PG261 - HEAVY DUTY METAL-WORKING CLAMP, 24" (600MM) CLAMPING CAPACITY | eclipse | 100.93 | CAT4215XZ |
C$ 100.93
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No |