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=4519 and pa.subcategory_id=4631 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 | |
|---|---|---|---|---|---|---|---|---|---|---|
| 2 Ton Bottle Jack - Heavy Duty | surewerx-strongarm | 83.04 | CAT4631XZ |
C$ 83.04
In Stock
| Yes | No | ||||
| 1 | 4 Ton Bottle Jack - Heavy Duty | surewerx-strongarm | 99.73 | CAT4631XZ |
C$ 99.73
In Stock
| Yes | No | |||
| 2 | 12 Ton Bottle Jack - Heavy Duty | surewerx-strongarm | 209.46 | CAT4631XZ |
C$ 209.46
In Stock
| Yes | No | |||
| 3 | 12 Ton Bottle Jack - Heavy Duty | surewerx-strongarm | 216.13 | CAT4631XZ |
C$ 216.13
In Stock
| Yes | No | |||
| 4 | 20 Ton Bottle Jack - Heavy Duty | surewerx-strongarm | 290.96 | CAT4631XZ |
C$ 290.96
In Stock
| Yes | No | |||
| 5 | 20 Ton Bottle Jack - Heavy Duty | surewerx-strongarm | 290.96 | CAT4631XZ |
C$ 290.96
In Stock
| Yes | No | |||
| 6 | 6 Ton Bottle Jack - Heavy Duty | surewerx-strongarm | 118.02 | CAT4631XZ |
C$ 118.02
Limited Stock
| Yes | No | |||
| 7 | 8 Ton Bottle Jack - Heavy Duty | surewerx-strongarm | 166.21 | CAT4631XZ |
C$ 166.21
Limited Stock
| Yes | No | |||
| 8 | 30 Ton Bottle Jack - Heavy Duty | surewerx-strongarm | 733.63 | CAT4631XZ |
C$ 733.63
Limited Stock
| Yes | No | |||
| 9 | 20 Ton Air/Hydraulic Bottle Jack - Super Heavy Duty | surewerx-strongarm | 719.63 | CAT4631XZ |
C$ 719.63
Limited Stock
| Yes | No | |||
| 10 | 10 Ton Push Ram | surewerx-strongarm | 334.87 | CAT4631XZ |
C$ 334.87
Limited Stock
| Yes | No | |||
| 11 | 12 Ton Air/Hydraulic Bottle Jack - Heavy Duty | surewerx-strongarm | 681.19 | CAT4631XZ |
C$ 681.19
| No | No | |||
| 12 | 50 Ton Bottle Jack - Heavy Duty | surewerx-strongarm | 1079.46 | CAT4631XZ |
C$ 1,079.46
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 13 | 50 Ton Bottle Jack - Heavy Duty | surewerx-strongarm | 1367.77 | CAT4631XZ |
C$ 1,367.77
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 14 | 20 Ton Air/Hydraulic Bottle Jack - Super Heavy Duty | surewerx-strongarm | 856.4 | CAT4631XZ |
C$ 856.40
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 15 | 20 Ton Low Profile Air/Hydraulic Bottle Jack - Super Heavy Duty | surewerx-strongarm | 806.53 | CAT4631XZ |
C$ 806.53
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 16 | 30 Ton Air/Hydraulic Bottle Jack - Super Heavy Duty | surewerx-strongarm | 1164.06 | CAT4631XZ |
C$ 1,164.06
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 17 | 5 Ton Mechanical Screw Jack - Heavy Duty | surewerx-strongarm | 224.4 | CAT4631XZ |
C$ 224.40
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 18 | Handle For 5 Ton Mechanical Screw Jack | surewerx-strongarm | 23.22 | CAT4631XZ |
C$ 23.22
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 19 | 10 Ton Mechanical Screw Jack - Heavy Duty | surewerx-strongarm | 377.59 | CAT4631XZ |
C$ 377.59
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 20 | Handle For 10 Ton Mechanical Screw Jack | surewerx-strongarm | 37.08 | CAT4631XZ |
C$ 37.08
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 21 | 15 Ton Mechanical Screw Jack - Heavy Duty | surewerx-strongarm | 435.67 | CAT4631XZ |
C$ 435.67
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 22 | Handle For 15 Ton Mechanical Screw Jack | surewerx-strongarm | 55.86 | CAT4631XZ |
C$ 55.86
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 23 | 20 Ton Mechanical Screw Jack - Heavy Duty | surewerx-strongarm | 471.96 | CAT4631XZ |
C$ 471.96
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 24 | Handle For 20/25 Ton Mechanical Bottle Jack | surewerx-strongarm | 109.33 | CAT4631XZ |
C$ 109.33
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 25 | 25 Ton Mechanical Screw Jack - Heavy Duty | surewerx-strongarm | 580.92 | CAT4631XZ |
C$ 580.92
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 26 | 2 Ton Push Ram | surewerx-strongarm | 255.56 | CAT4631XZ |
C$ 255.56
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 27 | 4 Ton Push Ram | surewerx-strongarm | 273.19 | CAT4631XZ |
C$ 273.19
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 28 | 10 Ton Push Ram | surewerx-strongarm | 387.72 | CAT4631XZ |
C$ 387.72
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 29 | 4 Ton Push Ram | surewerx-strongarm | 193.86 | CAT4631XZ |
C$ 193.86
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 30 | 4 Ton Push Ram | surewerx-strongarm | 281.95 | CAT4631XZ |
C$ 281.95
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 31 | 10 Ton Push Ram | surewerx-strongarm | 405.37 | CAT4631XZ |
C$ 405.37
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 32 | 20 Ton Hydraulic Ram | surewerx-strongarm | 498.84 | CAT4631XZ |
C$ 498.84
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No |