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=3974 and pa.subcategory_id=3981 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 | |
|---|---|---|---|---|---|---|---|---|---|---|
| PG289 - MBX VINYL ERASER | montipower | 38.75 | CAT3981XZ |
C$ 38.75
In Stock
| Yes | No | ||||
| 1 | PG289 - MBX STANDARD DUTY STARTER KIT - AUTO | montipower | 541.03 | CAT3981XZ |
C$ 541.03
In Stock
| Yes | No | |||
| 2 | PG289 - COARSE CARBON STEEL 23MM | montipower | 22.81 | CAT3981XZ |
C$ 22.81
In Stock
| Yes | No | |||
| 3 | PG289 - COARSE CARBON STEEL 11MM | montipower | 22.81 | CAT3981XZ |
C$ 22.81
In Stock
| Yes | No | |||
| 4 | PG289 - PINSTRIPE REMOVER WITH 12 4-INCH PADS | ingersoll-rand | 236.75 | CAT3981XZ |
C$ 236.75
In Stock
| Yes | No | |||
| 5 | PG289 - NITROZIP VERSATILITY KIT | dynabrade | 611.41 | CAT3981XZ |
C$ 611.41
In Stock
| Yes | No | |||
| 6 | PG289 - 4-1/4 X 1-1/4 WIDE RUBBER | dynabrade | 55.13 | CAT3981XZ |
C$ 55.13
In Stock
| Yes | No | |||
| 7 | PG289 - 4" (102 MM) DIA. X 3/4" (19 MM) W BENT COARSE WIRE WHEEL | dynabrade | 54.31 | CAT3981XZ |
C$ 54.31
In Stock
| Yes | No | |||
| 8 | PG289 - MBX PANEL VAN DECAL ERASER | dentfix | 49.97 | CAT3981XZ |
C$ 49.97
In Stock
| Yes | No | |||
| 9 | PG289 - ELIMINATOR INLINE UNDERCOAT & DECAL REMOVER KIT | dentfix | 905.71 | CAT3981XZ |
C$ 905.71
In Stock
| Yes | No | |||
| 10 | PG410 - 4" RAPID ERASER PAD FOR USE WITH ASTRO #500ET ADHESIVE REMOVAL TOOL | astro-pneumatics | 10.15 | CAT3981XZ |
Astro Pneumatics
PG410 - 4" RAPID ERASER PAD FOR USE WITH ASTRO #500ET ADHESIVE REMOVAL TOOLPart# AST-500EC$ 10.15
In Stock
| Yes | No | |||
| 11 | PG289 - ARBOR FOR SMART ERASER PAD | astro-pneumatics | 2.48 | CAT3981XZ |
C$ 2.48
In Stock
| Yes | No | |||
| 12 | PG289 - SMART ERASER PAD FOR PINSTRIPE REMOVAL TOOL | astro-pneumatics | 14.75 | CAT3981XZ |
C$ 14.75
In Stock
| Yes | No | |||
| 13 | PG289 - PINSTRIPE REMOVAL KIT - #533ET AND #400E | astro-pneumatics | 249.89 | CAT3981XZ |
C$ 249.89
In Stock
| Yes | No | |||
| 14 | PG289 - MBX DIE BLASTER SURFACE PREPARATION KIT | montipower | 979.69 | CAT3981XZ |
C$ 979.69
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 15 | PG289 - NITROZIP ERASER TOOL | dynabrade | 546.97 | CAT3981XZ |
C$ 546.97
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No |