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=4276 and pa.subcategory_id=4295 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 | |
|---|---|---|---|---|---|---|---|---|---|---|
| PG322 - PLASTIC HIGH SPOKE DUCKHEAD MOUNT/DEMOUNT TOOL | hennessy-industries-coats | 86.45 | CAT4295XZ |
Hennessy Industries - Coats
PG322 - PLASTIC HIGH SPOKE DUCKHEAD MOUNT/DEMOUNT TOOLPart# HEN-8184432C$ 86.45
In Stock
| Yes | No | ||||
| 1 | PG322 - PASTE TIRE LUBE, BUCKET - 7.7 LBS | hennessy-industries-coats | 58.19 | CAT4295XZ |
C$ 58.19
In Stock
| Yes | No | |||
| 2 | PG322 - NYLON DUCKHEAD MOUNT/DEMOUNT TOOL | hennessy-industries-coats | 47.48 | CAT4295XZ |
C$ 47.48
In Stock
| Yes | No | |||
| 3 | PG322 - RC-55E RIM CLAMP TIRE CHANGER WITH ELECTRIC MOTOR | hennessy-industries-coats | 10879.68 | CAT4295XZ |
Hennessy Industries - Coats
PG322 - RC-55E RIM CLAMP TIRE CHANGER WITH ELECTRIC MOTORPart# HEN-85609950C$ 10,879.68
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 4 | 80X-SERIES ELECTRIC MODEL TIRE CHANGER FOR HIGH-VOLUME SHOPS EQUIPPED WITH ROBOROLLER POWERED ASSIST | hennessy-industries-coats | 13971 | CAT4295XZ |
Hennessy Industries - Coats
80X-SERIES ELECTRIC MODEL TIRE CHANGER FOR HIGH-VOLUME SHOPS EQUIPPED WITH ROBOROLLER POWERED ASSISTPart# HEN-80080XEHC$ 13,971.00
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 5 | PG322 - 60X-SERIES ELECTRIC MODEL TIRE CHANGER FOR HIGH-VOLUME SHOPS EQUIPPED WITH HAND-ACTUATED BEAD LOOSENER | hennessy-industries-coats | 12223.68 | CAT4295XZ |
Hennessy Industries - Coats
PG322 - 60X-SERIES ELECTRIC MODEL TIRE CHANGER FOR HIGH-VOLUME SHOPS EQUIPPED WITH HAND-ACTUATED BEAD LOOSENERPart# HEN-80060XEHC$ 12,223.68
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No |