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=4527 and pa.subcategory_id=4662 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 | |
|---|---|---|---|---|---|---|---|---|---|---|
| 18" Steel Pipe Wrench - Super Heavy Duty | surewerx-jet | 108.61 | CAT4662XZ |
C$ 108.61
Limited Stock
| Yes | No | ||||
| 1 | 24" Steel Pipe Wrench - Heavy Duty | surewerx-jet | 131.87 | CAT4662XZ |
C$ 131.87
Limited Stock
| Yes | No | |||
| 2 | 24" Aluminum Pipe Wrench - Super Heavy Duty | surewerx-jet | 217.2 | CAT4662XZ |
C$ 217.20
Limited Stock
| Yes | No | |||
| 3 | Basin Wrench | milwaukee | 84.41 | CAT4662XZ |
C$ 84.41
| No | No | |||
| 4 | Steel Pipe Wrench | milwaukee | 58.08 | CAT4662XZ |
C$ 58.08
| No | No | |||
| 5 | Pipe Wrench | milwaukee | 88.87 | CAT4662XZ |
C$ 88.87
| No | No | |||
| 6 | 24 in. Pipe Wrench | milwaukee | 131.14 | CAT4662XZ |
C$ 131.14
| No | No | |||
| 7 | Aluminum Pipe Wrench | milwaukee | 85.06 | CAT4662XZ |
C$ 85.06
| No | No | |||
| 8 | Aluminum Pipe Wrench | milwaukee | 111.18 | CAT4662XZ |
C$ 111.18
| No | No | |||
| 9 | Aluminum Pipe Wrench | milwaukee | 172.21 | CAT4662XZ |
C$ 172.21
| No | No | |||
| 10 | Pipe Wrench | milwaukee | 168.78 | CAT4662XZ |
C$ 168.78
| No | No | |||
| 11 | 8" Steel Pipe Wrench - Super Heavy Duty | surewerx-jet | 46.5 | CAT4662XZ |
C$ 46.50
| No | No | |||
| 12 | 10" Steel Pipe Wrench - Super Heavy Duty | surewerx-jet | 58.91 | CAT4662XZ |
C$ 58.91
| No | No | |||
| 13 | 12" Steel Pipe Wrench - Super Heavy Duty | surewerx-jet | 61.98 | CAT4662XZ |
C$ 61.98
| No | No | |||
| 14 | 14" Steel Pipe Wrench - Super Heavy Duty | surewerx-jet | 71.35 | CAT4662XZ |
C$ 71.35
| No | No | |||
| 15 | 24" Steel Pipe Wrench - Super Heavy Duty | surewerx-jet | 170.63 | CAT4662XZ |
C$ 170.63
| No | No | |||
| 16 | 36" Steel Pipe Wrench - Super Heavy Duty | surewerx-jet | 372.41 | CAT4662XZ |
C$ 372.41
| No | No | |||
| 17 | 8" Steel Pipe Wrench - Heavy Duty | surewerx-jet | 34.09 | CAT4662XZ |
C$ 34.09
| No | No | |||
| 18 | 12" Steel Pipe Wrench - Heavy Duty | surewerx-jet | 51.13 | CAT4662XZ |
C$ 51.13
| No | No | |||
| 19 | 14" Steel Pipe Wrench - Heavy Duty | surewerx-jet | 58.91 | CAT4662XZ |
C$ 58.91
| No | No | |||
| 20 | 18" Steel Pipe Wrench - Heavy Duty | surewerx-jet | 83.76 | CAT4662XZ |
C$ 83.76
| No | No | |||
| 21 | 36" Steel Pipe Wrench - Heavy Duty | surewerx-jet | 243.61 | CAT4662XZ |
C$ 243.61
| No | No | |||
| 22 | 14" Aluminum Pipe Wrench - Super Heavy Duty | surewerx-jet | 116.35 | CAT4662XZ |
C$ 116.35
| No | No | |||
| 23 | 18" Aluminum Pipe Wrench - Super Heavy Duty | surewerx-jet | 155.15 | CAT4662XZ |
C$ 155.15
| No | No | |||
| 24 | 36" Aluminum Pipe Wrench - Super Heavy Duty | surewerx-jet | 403.5 | CAT4662XZ |
C$ 403.50
| No | No | |||
| 25 | 14" Aluminum Pipe Wrench - Heavy Duty | surewerx-jet | 85.33 | CAT4662XZ |
C$ 85.33
| No | No | |||
| 26 | 18" Aluminum Pipe Wrench - Heavy Duty | surewerx-jet | 124.09 | CAT4662XZ |
C$ 124.09
| No | No | |||
| 27 | 24" Aluminum Pipe Wrench - Heavy Duty | surewerx-jet | 193.91 | CAT4662XZ |
C$ 193.91
| No | No | |||
| 28 | 36" Aluminum Pipe Wrench - Heavy Duty | surewerx-jet | 339.85 | CAT4662XZ |
C$ 339.85
| No | No | |||
| 29 | Basin Wrench | milwaukee | 70.36 | CAT4662XZ |
C$ 70.36
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 30 | 6 in. Pipe Wrench | milwaukee | 37.33 | CAT4662XZ |
C$ 37.33
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 31 | 8 in. Pipe Wrench | milwaukee | 46.32 | CAT4662XZ |
C$ 46.32
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 32 | Steel Pipe Wrench | milwaukee | 49.96 | CAT4662XZ |
C$ 49.96
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 33 | Pipe Wrench | milwaukee | 66.23 | CAT4662XZ |
C$ 66.23
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 34 | 36 in. Pipe Wrench | milwaukee | 287.18 | CAT4662XZ |
C$ 287.18
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 35 | 48 in. Pipe Wrench | milwaukee | 465.53 | CAT4662XZ |
C$ 465.53
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 36 | 60 in. Pipe Wrench | milwaukee | 694.7 | CAT4662XZ |
C$ 694.70
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 37 | Offset Hex Pipe Wrench | milwaukee | 63.47 | CAT4662XZ |
C$ 63.47
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 38 | 24 in. Offset Pipe Wrench | milwaukee | 257.35 | CAT4662XZ |
C$ 257.35
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 39 | 14 in. Offset Pipe Wrench | milwaukee | 120.96 | CAT4662XZ |
C$ 120.96
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 40 | 18 in. Offset Pipe Wrench | milwaukee | 167.32 | CAT4662XZ |
C$ 167.32
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 41 | 12 in. Pipe Wrench | milwaukee | 77.21 | CAT4662XZ |
C$ 77.21
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 42 | Aluminum Pipe Wrench | milwaukee | 68.82 | CAT4662XZ |
C$ 68.82
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 43 | Aluminum Pipe Wrench | milwaukee | 76.66 | CAT4662XZ |
C$ 76.66
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 44 | 10L Pipe Wrench | milwaukee | 95.22 | CAT4662XZ |
C$ 95.22
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 45 | 36 in. Pipe Wrench | milwaukee | 338.44 | CAT4662XZ |
C$ 338.44
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 46 | 48 in. Pipe Wrench | milwaukee | 678.72 | CAT4662XZ |
C$ 678.72
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 47 | 10" Steel Pipe Wrench | surewerx-jet | 0 | CAT4662XZ |
C$ 0.00
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 48 | 14" Steel Pipe Wrench | surewerx-jet | 0 | CAT4662XZ |
C$ 0.00
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 49 | 18" Steel Pipe Wrench | surewerx-jet | 0 | CAT4662XZ |
C$ 0.00
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 50 | 24" Steel Pipe Wrench | surewerx-jet | 0 | CAT4662XZ |
C$ 0.00
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 51 | 36" Steel Pipe Wrench | surewerx-jet | 0 | CAT4662XZ |
C$ 0.00
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 52 | 18" Aluminum Pipe Wrench | surewerx-jet | 0 | CAT4662XZ |
C$ 0.00
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 53 | 24" Aluminum Pipe Wrench | surewerx-jet | 0 | CAT4662XZ |
C$ 0.00
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 54 | 36" Aluminum Pipe Wrench | surewerx-jet | 0 | CAT4662XZ |
C$ 0.00
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 55 | 10" Steel Pipe Wrench - Heavy Duty | surewerx-jet | 40.26 | CAT4662XZ |
C$ 40.26
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 56 | 48" Steel Pipe Wrench - Heavy Duty | surewerx-jet | 372.41 | CAT4662XZ |
C$ 372.41
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 57 | 48" Aluminum Pipe Wrench - Super Heavy Duty | surewerx-jet | 775.98 | CAT4662XZ |
C$ 775.98
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No |