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=4660 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" Adjustable Wrench | surewerx-jet | 30.96 | CAT4660XZ |
C$ 30.96
In Stock
| Yes | No | ||||
| 1 | 8" Adjustable Wrench | surewerx-jet | 41.28 | CAT4660XZ |
C$ 41.28
In Stock
| Yes | No | |||
| 2 | 10" Adjustable Wrench | surewerx-jet | 51.65 | CAT4660XZ |
C$ 51.65
In Stock
| Yes | No | |||
| 3 | 12" Adjustable Wrench | surewerx-jet | 74.41 | CAT4660XZ |
C$ 74.41
In Stock
| Yes | No | |||
| 4 | 15" Adjustable Wrench | surewerx-jet | 109.56 | CAT4660XZ |
C$ 109.56
In Stock
| Yes | No | |||
| 5 | 18" Adjustable Wrench | surewerx-jet | 200.64 | CAT4660XZ |
C$ 200.64
In Stock
| Yes | No | |||
| 6 | 8" Professional Adjustable Wrench - Super Heavy Duty | surewerx-jet | 72.37 | CAT4660XZ |
C$ 72.37
In Stock
| Yes | No | |||
| 7 | 10" Professional Adjustable Wrench - Super Heavy Duty | surewerx-jet | 86.84 | CAT4660XZ |
C$ 86.84
In Stock
| Yes | No | |||
| 8 | 12" Professional Adjustable Wrench - Super Heavy Duty | surewerx-jet | 113.71 | CAT4660XZ |
C$ 113.71
In Stock
| Yes | No | |||
| 9 | 15" Professional Adjustable Wrench - Super Heavy Duty | surewerx-jet | 202.75 | CAT4660XZ |
C$ 202.75
In Stock
| Yes | No | |||
| 10 | 18" Professional Adjustable Wrench - Super Heavy Duty | surewerx-jet | 345.54 | CAT4660XZ |
C$ 345.54
In Stock
| Yes | No | |||
| 11 | 10" Adjustable Wrench | itc | 31.49 | CAT4660XZ |
C$ 31.49
Limited Stock
| Yes | No | |||
| 12 | 12" Adjustable Wrench | itc | 31.49 | CAT4660XZ |
C$ 31.49
Limited Stock
| Yes | No | |||
| 13 | 15" Adjustable Wrench | itc | 61.44 | CAT4660XZ |
C$ 61.44
Limited Stock
| Yes | No | |||
| 14 | Adjustable Wrenches | milwaukee | 50.26 | CAT4660XZ |
C$ 50.26
Limited Stock
| Yes | No | |||
| 15 | 24" Adjustable Wrench | surewerx-jet | 289.62 | CAT4660XZ |
C$ 289.62
Limited Stock
| Yes | No | |||
| 16 | 6" Professional Adjustable Wrench - Super Heavy Duty | surewerx-jet | 57.83 | CAT4660XZ |
C$ 57.83
Limited Stock
| Yes | No | |||
| 17 | 6" Adjustable Wrench | itc | 18.24 | CAT4660XZ |
C$ 18.24
| No | No | |||
| 18 | 8" Adjustable Wrench | itc | 21.56 | CAT4660XZ |
C$ 21.56
| No | No | |||
| 19 | Adjustable Wrench | milwaukee | 26.64 | CAT4660XZ |
C$ 26.64
| No | No | |||
| 20 | Adjustable Wrench | milwaukee | 33.18 | CAT4660XZ |
C$ 33.18
| No | No | |||
| 21 | Adjustable Wrench | milwaukee | 46.25 | CAT4660XZ |
C$ 46.25
| No | No | |||
| 22 | Adjustable Wrench | milwaukee | 51.26 | CAT4660XZ |
C$ 51.26
| No | No | |||
| 23 | Adjustable Wrench | milwaukee | 78.41 | CAT4660XZ |
C$ 78.41
| No | No | |||
| 24 | Adjustable Wrench | milwaukee | 46.25 | CAT4660XZ |
C$ 46.25
| No | No | |||
| 25 | 24" Professional Adjustable Wrench - Super Heavy Duty | surewerx-jet | 620.78 | CAT4660XZ |
C$ 620.78
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 26 | 15" Adjustable Construction Wrench | surewerx-jet | 165.5 | CAT4660XZ |
C$ 165.50
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No |