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=4245 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 | |
|---|---|---|---|---|---|---|---|---|---|---|
| PG261 - 8" MECHANIC'S VISE | record | 342.77 | CAT4245XZ |
C$ 342.77
In Stock
| Yes | No | ||||
| 1 | PG261 - 6" MECHANIC'S VISE | record | 282.91 | CAT4245XZ |
C$ 282.91
In Stock
| Yes | No | |||
| 2 | PG261 - 5" MECHANIC'S VISE | record | 234.13 | CAT4245XZ |
C$ 234.13
In Stock
| Yes | No | |||
| 3 | PG261 - 4" MECHANIC'S VISE | record | 93.47 | CAT4245XZ |
C$ 93.47
In Stock
| Yes | No | |||
| 4 | PG261 - 6" ATV ALL-TERRAIN VISE | wilton | 530.95 | CAT4245XZ |
C$ 530.95
In Stock
| Yes | No | |||
| 5 | PG261 - 5 GENERAL DUTY SHOP VISE WITH SWIVEL LOCKING BASE | wilton | 376.79 | CAT4245XZ |
C$ 376.79
In Stock
| Yes | No | |||
| 6 | PG261 - 8 GENERAL DUTY SHOP VISE WITH SWIVEL LOCKING BASE | wilton | 685.21 | CAT4245XZ |
C$ 685.21
In Stock
| Yes | No | |||
| 7 | PG261 - 6 GENERAL DUTY SHOP VISE WITH SWIVEL LOCKING BASE | wilton | 513.31 | CAT4245XZ |
C$ 513.31
In Stock
| Yes | No | |||
| 8 | PG261 - SWIVEL BASE - 8" VISE | eclipse | 52.97 | CAT4245XZ |
C$ 52.97
In Stock
| Yes | No | |||
| 9 | PG261 - SWIVEL BASE - 6" VISE | eclipse | 43.9 | CAT4245XZ |
C$ 43.90
In Stock
| Yes | No | |||
| 10 | PG261 - SWIVEL BASE - 5" VISE | eclipse | 30.2 | CAT4245XZ |
C$ 30.20
In Stock
| Yes | No | |||
| 11 | PG261 - SWIVEL BASE - 4" VISE | eclipse | 22.39 | CAT4245XZ |
C$ 22.39
In Stock
| Yes | No | |||
| 12 | PG261 - EMV-8 MECHANICS VISE, 8" JAW | eclipse | 292.37 | CAT4245XZ |
C$ 292.37
In Stock
| Yes | No | |||
| 13 | PG261 - EMV-6 MECHANICS VISE, 6" JAW | eclipse | 220.01 | CAT4245XZ |
C$ 220.01
In Stock
| Yes | No | |||
| 14 | PG261 - EMV-5 MECHANICS VISE, 5" JAW | eclipse | 145.49 | CAT4245XZ |
C$ 145.49
In Stock
| Yes | No | |||
| 15 | PG261 - EMV-3 MECHANICS VISE, 4" JAW | eclipse | 93.47 | CAT4245XZ |
C$ 93.47
In Stock
| Yes | No | |||
| 16 | PG261 - 5" MULTI-PURPOSE VICE W/ ANGLE AND PIPE JAWS | eclipse | 172.13 | CAT4245XZ |
C$ 172.13
In Stock
| Yes | No | |||
| 17 | PG261 - 6 PROFESSIONAL SHOP VISE WITH SWIVEL LOCKING BASE | atd | 393.25 | CAT4245XZ |
C$ 393.25
In Stock
| Yes | No | |||
| 18 | PG261 - 5 PROFESSIONAL SHOP VISE WITH SWIVEL LOCKING BASE | atd | 300.19 | CAT4245XZ |
C$ 300.19
In Stock
| Yes | No | |||
| 19 | PG261 - ATV ALL-TERRAIN VISE 10" RISER BLOCK | wilton | 168.07 | CAT4245XZ |
C$ 168.07
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 20 | PG261 - B.A.S.H. 6.5" UTILITY VISE AND 4 LB. HAMMER COMBO | wilton | 396.59 | CAT4245XZ |
C$ 396.59
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 21 | PG261 - 6" CAST IRON SWIVEL BENCH VISE WITH 1/4"-3" PIPE CAPACITY | atd | 204.35 | CAT4245XZ |
C$ 204.35
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No |