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=4205 and pa.subcategory_id=4206 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 | |
|---|---|---|---|---|---|---|---|---|---|---|
| PG262 - 50-TON HYDRAULIC SHOP PRESS WITH PROTECTION GUARD | tobeq | 3794.48 | CAT4206XZ |
C$ 3,794.48
In Stock
| Yes | No | ||||
| 1 | PG262 - 30-TON HYDRAULIC SHOP PRESS WITH PROTECTION GUARD | tobeq | 2477.14 | CAT4206XZ |
C$ 2,477.14
In Stock
| Yes | No | |||
| 2 | PG262 - 20-TON HYDRAULIC SHOP PRESS WITH PROTECTION GUARD | tobeq | 1424.04 | CAT4206XZ |
C$ 1,424.04
In Stock
| Yes | No | |||
| 3 | PG262 - 15-TON COMPACT HYDRAULIC BENCH PRESS WITH PROTECTION GUARD | tobeq | 1113.31 | CAT4206XZ |
C$ 1,113.31
In Stock
| Yes | No | |||
| 4 | PG262 - 50-TON HYDRAULIC SHOP PRESS WITH PROTECTION GUARD | tobeq | 3794.48 | CAT4206XZ |
C$ 3,794.48
In Stock
| Yes | No | |||
| 5 | PG262 - 30-TON HYDRAULIC SHOP PRESS WITH PROTECTION GUARD | tobeq | 2477.14 | CAT4206XZ |
C$ 2,477.14
In Stock
| Yes | No | |||
| 6 | PG262 - 20-TON HYDRAULIC SHOP PRESS WITH PROTECTION GUARD | tobeq | 1424.04 | CAT4206XZ |
C$ 1,424.04
In Stock
| Yes | No | |||
| 7 | PG262 - 15-TON COMPACT HYDRAULIC BENCH PRESS WITH PROTECTION GUARD | tobeq | 1113.31 | CAT4206XZ |
C$ 1,113.31
In Stock
| Yes | No | |||
| 8 | PG262 - 100-TON AIR/HYDRAULIC SHOP PRESS WITH PROTECTION GUARD | tobeq | 7974.96 | CAT4206XZ |
C$ 7,974.96
In Stock
| Yes | No | |||
| 9 | 20 TON AIR/HYDRAULIC SHOP PRESS | sunex | 1784.02 | CAT4206XZ |
C$ 1,784.02
In Stock
| Yes | No | |||
| 10 | PG262 - UNI-PRESS-SUPPORT UP-07 | mueller-kueps | 699.97 | CAT4206XZ |
C$ 699.97
In Stock
| Yes | No | |||
| 11 | PG262 - 75T WORKSHOP PRESS | chicago-pneumatic | 7334.51 | CAT4206XZ |
C$ 7,334.51
In Stock
| Yes | No | |||
| 12 | PG262 - 50T WORKSHOP PRESS | chicago-pneumatic | 4842.7 | CAT4206XZ |
C$ 4,842.70
In Stock
| Yes | No | |||
| 13 | PG262 - 30T WORKSHOP PRESS | chicago-pneumatic | 3307.28 | CAT4206XZ |
C$ 3,307.28
In Stock
| Yes | No | |||
| 14 | PG262 - 20T WORKSHOP PRESS | chicago-pneumatic | 1890.84 | CAT4206XZ |
C$ 1,890.84
In Stock
| Yes | No | |||
| 15 | PG262 - 75-TON AIR/HYDRAULIC SHOP PRESS WITH PROTECTION GUARD | tobeq | 5726.54 | CAT4206XZ |
C$ 5,726.54
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 16 | PG262 - 15T COMPACT BENCH WORKSHOP PRESS | chicago-pneumatic | 1509.2 | CAT4206XZ |
C$ 1,509.20
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 17 | PG262 - 100T WORKSHOP PRESS | chicago-pneumatic | 10138.93 | CAT4206XZ |
C$ 10,138.93
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No |