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=4666 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 | |
|---|---|---|---|---|---|---|---|---|---|---|
| 7 Pc Wrench Set - SAE | milwaukee | 172.28 | CAT4666XZ |
C$ 172.28
In Stock
| Yes | No | ||||
| 1 | Wrench Set | milwaukee | 170.39 | CAT4666XZ |
C$ 170.39
In Stock
| Yes | No | |||
| 2 | Wrench Set | milwaukee | 170.39 | CAT4666XZ |
C$ 170.39
In Stock
| Yes | No | |||
| 3 | 16 PC SAE Raised Panel Combination Wrench Set | surewerx-jet | 434.52 | CAT4666XZ |
C$ 434.52
In Stock
| Yes | No | |||
| 4 | 22 PC Metric Raised Panel Combination Wrench Set | surewerx-jet | 496.61 | CAT4666XZ |
C$ 496.61
In Stock
| Yes | No | |||
| 5 | 8 PC Long SAE Ratcheting Combination Wrench Set | surewerx-jet | 289.62 | CAT4666XZ |
C$ 289.62
In Stock
| Yes | No | |||
| 6 | Flare Nut Wrench Set - SAE - 4 pc | surewerx-jet | 134.41 | CAT4666XZ |
C$ 134.41
In Stock
| Yes | No | |||
| 7 | Flare Nut Wrench Set - Metric - 6 pc | surewerx-jet | 186.18 | CAT4666XZ |
C$ 186.18
In Stock
| Yes | No | |||
| 8 | Flare Nut Crowfoot Set - SAE - 7PC - 6P | surewerx-jet | 134.41 | CAT4666XZ |
C$ 134.41
In Stock
| Yes | No | |||
| 9 | Flare Nut Crowfoot Wrench Set - Metric - 10 PC - 6P | surewerx-jet | 175.82 | CAT4666XZ |
C$ 175.82
In Stock
| Yes | No | |||
| 10 | 14 PC SAE Polished Combination Wrench Set | itc | 109.68 | CAT4666XZ |
C$ 109.68
Limited Stock
| Yes | No | |||
| 11 | 14 PC Metric Polished Combination Wrench Set | itc | 109.68 | CAT4666XZ |
C$ 109.68
Limited Stock
| Yes | No | |||
| 12 | Wrench Set | milwaukee | 88.04 | CAT4666XZ |
C$ 88.04
Limited Stock
| Yes | No | |||
| 13 | 15 Pc Wrench Set - SAE | milwaukee | 344.58 | CAT4666XZ |
C$ 344.58
Limited Stock
| Yes | No | |||
| 14 | 7 Pc Wrench Set - Metric | milwaukee | 172.28 | CAT4666XZ |
C$ 172.28
Limited Stock
| Yes | No | |||
| 15 | Wrench Set | milwaukee | 88.04 | CAT4666XZ |
C$ 88.04
Limited Stock
| Yes | No | |||
| 16 | 15 Pc Wrench Set - Metric | milwaukee | 340.74 | CAT4666XZ |
C$ 340.74
Limited Stock
| Yes | No | |||
| 17 | Long Pattern Wrench Set - SAE - 16 pc | surewerx-jet | 682.84 | CAT4666XZ |
C$ 682.84
Limited Stock
| Yes | No | |||
| 18 | 16 PC Metric Raised Panel Combination Wrench Set | surewerx-jet | 308.29 | CAT4666XZ |
C$ 308.29
Limited Stock
| Yes | No | |||
| 19 | 13 PC Long SAE Ratcheting Combination Wrench Set | surewerx-jet | 620.78 | CAT4666XZ |
C$ 620.78
Limited Stock
| Yes | No | |||
| 20 | 13 PC Long SAE Reversible Ratcheting Combination Wrench Set | surewerx-jet | 765.65 | CAT4666XZ |
C$ 765.65
Limited Stock
| Yes | No | |||
| 21 | 11 PC SAE Flex Head Ratchet Combination Wrench Set | surewerx-jet | 715.97 | CAT4666XZ |
C$ 715.97
Limited Stock
| Yes | No | |||
| 22 | 11 PC Metric Flex Head Ratchet Combination Wrench Set | surewerx-jet | 637.33 | CAT4666XZ |
C$ 637.33
Limited Stock
| Yes | No | |||
| 23 | 3 PC Adjustable Wrench Set | surewerx-jet | 117.83 | CAT4666XZ |
C$ 117.83
Limited Stock
| Yes | No | |||
| 24 | 22 PC Fully Polished SAE / Metric Combination Wrench Set | itc | 126.29 | CAT4666XZ |
C$ 126.29
| No | No | |||
| 25 | 14 PC SAE Angle Wrench Set - 60 & 15 | itc | 239.4 | CAT4666XZ |
C$ 239.40
| No | No | |||
| 26 | 11 PC SAE Raised Panel Combination Wrench Set | surewerx-jet | 279.3 | CAT4666XZ |
C$ 279.30
| No | No | |||
| 27 | 10 PC SAE Jumbo Raised Panel Combination Wrench Set | surewerx-jet | 1531.39 | CAT4666XZ |
C$ 1,531.39
| No | No | |||
| 28 | 11 PC Long SAE Fully Polished Combination Wrench Set | surewerx-jet | 268.93 | CAT4666XZ |
C$ 268.93
| No | No | |||
| 29 | Stubby Wrench Set - SAE - 10 pc | surewerx-jet | 283.45 | CAT4666XZ |
C$ 283.45
| No | No | |||
| 30 | 7 PC Long Metric Ratcheting Combination Wrench Set | surewerx-jet | 260.64 | CAT4666XZ |
C$ 260.64
| No | No | |||
| 31 | 11 PC Metric Raised Panel Combination Wrench Set | surewerx-jet | 175.82 | CAT4666XZ |
C$ 175.82
| No | No | |||
| 32 | 11 PC Long Metric Fully Polished Combination Wrench Set | surewerx-jet | 248.21 | CAT4666XZ |
C$ 248.21
| No | No | |||
| 33 | 16 PC Long Metric Fully Polished Combination Wrench Set | surewerx-jet | 455.22 | CAT4666XZ |
C$ 455.22
| No | No | |||
| 34 | Stubby Wrench Set - Metric - 10 pc | surewerx-jet | 223.39 | CAT4666XZ |
C$ 223.39
| No | No | |||
| 35 | 32 PC SAE/Metric Raised Panel Combination Wrench Set | surewerx-jet | 620.78 | CAT4666XZ |
C$ 620.78
| No | No | |||
| 36 | 8 PC Long SAE Reversible Ratcheting Combination Wrench Set | surewerx-jet | 380.7 | CAT4666XZ |
C$ 380.70
| No | No | |||
| 37 | 12 PC Metric Ratcheting Combination Wrench Set | surewerx-jet | 393.13 | CAT4666XZ |
C$ 393.13
| No | No | |||
| 38 | 7 PC Long Metric Reversible Ratcheting Combination Wrench Set | surewerx-jet | 372.43 | CAT4666XZ |
C$ 372.43
| No | No | |||
| 39 | 12 PC Long Metric Reversible Ratcheting Combination Wrench Set | surewerx-jet | 558.67 | CAT4666XZ |
C$ 558.67
| No | No | |||
| 40 | 10 PC Jumbo SAE Combination Wrench Set | surewerx-jet | 0 | CAT4666XZ |
C$ 0.00
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 41 | 10 PC Jumbo Metric Combination Wrench Set | surewerx-jet | 0 | CAT4666XZ |
C$ 0.00
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 42 | 3 PC Adjustable Wrench Set | surewerx-jet | 0 | CAT4666XZ |
C$ 0.00
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 43 | 6 PC SAE Jumbo Raised Panel Combination Wrench Set | surewerx-jet | 1096.81 | CAT4666XZ |
C$ 1,096.81
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 44 | Ratcheting Stubby Wrench Set - SAE - 8 pc | surewerx-jet | 248.21 | CAT4666XZ |
C$ 248.21
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 45 | Ratcheting Stubby Wrench Set - Metric - 10 pc | surewerx-jet | 372.43 | CAT4666XZ |
C$ 372.43
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 46 | Ratcheting Double Box Wrench Set - SAE - 4 pc | surewerx-jet | 235.82 | CAT4666XZ |
C$ 235.82
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 47 | Ratcheting Wrench Set - Metric - 18 pc | surewerx-jet | 1034.7 | CAT4666XZ |
C$ 1,034.70
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 48 | Reversible Ratcheting Wrench Set - Metric - 18 pc | surewerx-jet | 1034.7 | CAT4666XZ |
C$ 1,034.70
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 49 | Ratcheting Double Box Wrench Set - Metric - 6 pc | surewerx-jet | 372.43 | CAT4666XZ |
C$ 372.43
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 50 | Flare Nut Crowfoot Set - SAE - 7PC - 12P | surewerx-jet | 289.62 | CAT4666XZ |
C$ 289.62
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 51 | Flare Nut Crowfoot Set - Metric - 10PC - 12P | surewerx-jet | 372.43 | CAT4666XZ |
C$ 372.43
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No |