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=4526 and pa.subcategory_id=4658 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 | |
|---|---|---|---|---|---|---|---|---|---|---|
| 8 Ib. x 36" Sledge Hammer - Fibreglass Handle | itc | 114.67 | CAT4658XZ |
C$ 114.67
In Stock
| Yes | No | ||||
| 1 | 4 lb Sledge Hammer - Fibreglass Handle | surewerx-jet | 82.69 | CAT4658XZ |
C$ 82.69
In Stock
| Yes | No | |||
| 2 | 4 Ib. x 16" Sledge Hammer Fibreglass Handle | itc | 51.48 | CAT4658XZ |
C$ 51.48
Limited Stock
| Yes | No | |||
| 3 | 4 lb Sledge Hammer - Hickory Handle | surewerx-jet | 82.69 | CAT4658XZ |
C$ 82.69
Limited Stock
| Yes | No | |||
| 4 | 6 lb Sledge Hammer - Hickory Handle | surewerx-jet | 142.69 | CAT4658XZ |
C$ 142.69
Limited Stock
| Yes | No | |||
| 5 | 8 lb Sledge Hammer - Hickory Handle | surewerx-jet | 167.51 | CAT4658XZ |
C$ 167.51
Limited Stock
| Yes | No | |||
| 6 | 10 lb Sledge Hammer - Hickory Handle | surewerx-jet | 182.06 | CAT4658XZ |
C$ 182.06
Limited Stock
| Yes | No | |||
| 7 | 12 lb Sledge Hammer - Hickory Handle | surewerx-jet | 206.87 | CAT4658XZ |
C$ 206.87
Limited Stock
| Yes | No | |||
| 8 | 6 lb Sledge Hammer - Fibreglass Handle | surewerx-jet | 142.69 | CAT4658XZ |
C$ 142.69
Limited Stock
| Yes | No | |||
| 9 | 8 lb Sledge Hammer - Fibreglass Handle | surewerx-jet | 167.51 | CAT4658XZ |
C$ 167.51
Limited Stock
| Yes | No | |||
| 10 | 10 lb Sledge Hammer - Fibreglass Handle | surewerx-jet | 177.89 | CAT4658XZ |
C$ 177.89
Limited Stock
| Yes | No | |||
| 11 | 12 lb Sledge Hammer - Fibreglass Handle | surewerx-jet | 206.87 | CAT4658XZ |
C$ 206.87
Limited Stock
| Yes | No | |||
| 12 | 16 lb Sledge Hammer - Fibreglass Handle | surewerx-jet | 237.89 | CAT4658XZ |
C$ 237.89
Limited Stock
| Yes | No | |||
| 13 | 8 lb x 30" Indestructible Handle Sledge Hammer - Super Heavy Duty | surewerx-jet | 364.14 | CAT4658XZ |
C$ 364.14
Limited Stock
| Yes | No | |||
| 14 | 10 Ib. x 36" Sledge Hammer - Fibreglass Handle | itc | 119.63 | CAT4658XZ |
C$ 119.63
| No | No | |||
| 15 | 2.5 lb x 12" Indestructible Handle Sledge Hammer - Super Heavy Duty | surewerx-jet | 155.1 | CAT4658XZ |
C$ 155.10
| No | No | |||
| 16 | 4 lb x 12" Indestructible Handle Sledge Hammer - Super Heavy duty | surewerx-jet | 167.51 | CAT4658XZ |
C$ 167.51
| No | No | |||
| 17 | 4 lb x 16" Indestructible Handle Sledge Hammer - Super Heavy Duty | surewerx-jet | 200.64 | CAT4658XZ |
C$ 200.64
| No | No | |||
| 18 | 6 lb x 30" Indestructible Handle Sledge Hammer - Super Heavy Duty | surewerx-jet | 331.02 | CAT4658XZ |
C$ 331.02
| No | No | |||
| 19 | 14 lb x 30" Indestructible Handle Sledge Hammer - Super Heavy Duty | surewerx-jet | 475.91 | CAT4658XZ |
C$ 475.91
| No | No | |||
| 20 | 6 Ib. x 30" Sledge Hammer - Fibreglass Handle | itc | 96.36 | CAT4658XZ |
C$ 96.36
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 21 | 12 Ib. x 36" Sledge Hammer - Fibreglass Handle | itc | 142.92 | CAT4658XZ |
C$ 142.92
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 22 | 2-1/2 lb All Steel Club Hammer Super Heavy Duty | surewerx-jet | 105.42 | CAT4658XZ |
C$ 105.42
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 23 | 16 lb Sledge Hammer - Hickory Handle | surewerx-jet | 227.51 | CAT4658XZ |
C$ 227.51
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 24 | 6 lbs x 24" Indestructible Handle Sledge Hammer - Super Heavy Duty | surewerx-jet | 316.55 | CAT4658XZ |
C$ 316.55
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 25 | 8 lb x 24" Indestructible Handle Sledge Hammer - Super Heavy Duty | surewerx-jet | 341.42 | CAT4658XZ |
C$ 341.42
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 26 | 10 lb x 30" Indestructible Handle Sledge Hammer - Super Heavy Duty | surewerx-jet | 393.13 | CAT4658XZ |
C$ 393.13
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 27 | 12 lb x 30" Indestructible Handle Sledge Hammer - Super Heavy Duty | surewerx-jet | 446.93 | CAT4658XZ |
C$ 446.93
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 28 | 6 lbs x 16" Indestructible Handle Sledge Hammer - Super Heavy Duty | surewerx-jet | 254.46 | CAT4658XZ |
C$ 254.46
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 29 | 12 lbs x 36" Indestructible Handle Sledge Hammer - Super Heavy Duty | surewerx-jet | 527.65 | CAT4658XZ |
C$ 527.65
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No |