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=4278 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 | |
|---|---|---|---|---|---|---|---|---|---|---|
| PG332 - 6-PC CONICAL ERASER FOR RIMS INCLUDING ADAPTER FOR DRILL-CHUCK | mueller-kueps | 120.19 | CAT4278XZ |
Mueller Kueps
PG332 - 6-PC CONICAL ERASER FOR RIMS INCLUDING ADAPTER FOR DRILL-CHUCKPart# MUK-282 260C$ 120.19
In Stock
| Yes | No | ||||
| 1 | PG332 - BRITEPREP HUB & STUD CLEANING DISCS, 1.5" X 5/8", PURPLE (EXTRA FAST CUTTING ACTION), BOX OF 10 | gemtex-abrasives | 34.25 | CAT4278XZ |
GEMTEX ABRASIVES
PG332 - BRITEPREP HUB & STUD CLEANING DISCS, 1.5" X 5/8", PURPLE (EXTRA FAST CUTTING ACTION), BOX OF 10Part# GLI-56018C$ 34.25
In Stock
| Yes | No | |||
| 2 | PG332 - BRITEPREP HUB & STUD CLEANING DISCS, 2" X 5/8", BLACK (GENERAL PURPOSE CUTTING ACTION), BOX OF 10 | gemtex-abrasives | 30.19 | CAT4278XZ |
GEMTEX ABRASIVES
PG332 - BRITEPREP HUB & STUD CLEANING DISCS, 2" X 5/8", BLACK (GENERAL PURPOSE CUTTING ACTION), BOX OF 10Part# GLI-53029C$ 30.19
In Stock
| Yes | No | |||
| 3 | PG332 - BRITEPREP HUB & STUD CLEANING DISCS, 1.5" X 5/8", BLACK (GENERAL PURPOSE CUTTING ACTION), BOX OF 10 | gemtex-abrasives | 28.75 | CAT4278XZ |
GEMTEX ABRASIVES
PG332 - BRITEPREP HUB & STUD CLEANING DISCS, 1.5" X 5/8", BLACK (GENERAL PURPOSE CUTTING ACTION), BOX OF 10Part# GLI-53018C$ 28.75
In Stock
| Yes | No | |||
| 4 | PG332 - 6-PC CONICAL ERASER FOR RIMS INCLUDING ADAPTER FOR DRILL-CHUCK | mueller-kueps | 120.19 | CAT4278XZ |
Mueller Kueps
PG332 - 6-PC CONICAL ERASER FOR RIMS INCLUDING ADAPTER FOR DRILL-CHUCKPart# MUK-282 260C$ 120.19
In Stock
| Yes | No | |||
| 5 | PG332 - BRITEPREP HUB & STUD CLEANING DISCS, 2" X 5/8", PURPLE (EXTRA FAST CUTTING ACTION), BOX OF 10 | gemtex-abrasives | 38.21 | CAT4278XZ |
GEMTEX ABRASIVES
PG332 - BRITEPREP HUB & STUD CLEANING DISCS, 2" X 5/8", PURPLE (EXTRA FAST CUTTING ACTION), BOX OF 10Part# GLI-56029C$ 38.21
In Stock
| Yes | No | |||
| 6 | PG332 - BRITEPREP HUB & STUD CLEANING DISCS, 1.5" X 5/8", PURPLE (EXTRA FAST CUTTING ACTION), BOX OF 10 | gemtex-abrasives | 34.25 | CAT4278XZ |
GEMTEX ABRASIVES
PG332 - BRITEPREP HUB & STUD CLEANING DISCS, 1.5" X 5/8", PURPLE (EXTRA FAST CUTTING ACTION), BOX OF 10Part# GLI-56018C$ 34.25
In Stock
| Yes | No | |||
| 7 | PG332 - BRITEPREP HUB & STUD CLEANING DISCS, 2" X 5/8", BLACK (GENERAL PURPOSE CUTTING ACTION), BOX OF 10 | gemtex-abrasives | 30.19 | CAT4278XZ |
GEMTEX ABRASIVES
PG332 - BRITEPREP HUB & STUD CLEANING DISCS, 2" X 5/8", BLACK (GENERAL PURPOSE CUTTING ACTION), BOX OF 10Part# GLI-53029C$ 30.19
In Stock
| Yes | No | |||
| 8 | PG332 - BRITEPREP HUB & STUD CLEANING DISCS, 1.5" X 5/8", BLACK (GENERAL PURPOSE CUTTING ACTION), BOX OF 10 | gemtex-abrasives | 28.75 | CAT4278XZ |
GEMTEX ABRASIVES
PG332 - BRITEPREP HUB & STUD CLEANING DISCS, 1.5" X 5/8", BLACK (GENERAL PURPOSE CUTTING ACTION), BOX OF 10Part# GLI-53018C$ 28.75
In Stock
| Yes | No | |||
| 9 | PG332 - BRAKE HUB RESURFACING KIT | otc-tools | 68.98 | CAT4278XZ |
C$ 68.98
In Stock
| Yes | No | |||
| 10 | PG332 - INNER RIM CLEANER | mueller-kueps | 95.99 | CAT4278XZ |
C$ 95.99
In Stock
| Yes | No | |||
| 11 | PG332 - WHEEL HUB GRINDER TYPE 1 HOLDE | mueller-kueps | 60.07 | CAT4278XZ |
C$ 60.07
In Stock
| Yes | No | |||
| 12 | PG332 - GRINDING DISC TYPE 1 / 1-1/2" | mueller-kueps | 96.97 | CAT4278XZ |
C$ 96.97
In Stock
| Yes | No | |||
| 13 | PG332 - WHEEL HUB GRINER, TYPE 1, 1/2 DRIVE, 75MM INTERNAL | mueller-kueps | 95.99 | CAT4278XZ |
C$ 95.99
In Stock
| Yes | No | |||
| 14 | PG332 - STUD KLEEN UNIVERSAL IMPACT DRIVEN HUB/STUD/WHEEL CLEANER | esco | 76.46 | CAT4278XZ |
C$ 76.46
In Stock
| Yes | No | |||
| 15 | PG332 - STUD CLEANER, M24 X 60L | chicago-pneumatic | 91.03 | CAT4278XZ |
C$ 91.03
In Stock
| Yes | No | |||
| 16 | PG332 - STUD CLEANER, M22 X 60L | chicago-pneumatic | 91.03 | CAT4278XZ |
C$ 91.03
In Stock
| Yes | No | |||
| 17 | PG332 - STUD CLEANER, M20 X 60L | chicago-pneumatic | 91.03 | CAT4278XZ |
C$ 91.03
In Stock
| Yes | No | |||
| 18 | PG332 - STUD CLEANER, M30 X 60L | chicago-pneumatic | 91.03 | CAT4278XZ |
C$ 91.03
In Stock
| Yes | No | |||
| 19 | PG332 - STUD CLEANER, M24 X 37L | chicago-pneumatic | 52.79 | CAT4278XZ |
C$ 52.79
In Stock
| Yes | No | |||
| 20 | Wheel Hub Resurfacing Kit | calvan-horizon-tools | 43.08 | CAT4278XZ |
C$ 43.08
In Stock
| Yes | No | |||
| 21 | PG332 - QUICK CHANGE WHEEL STUD CLEANER WITH 6 BRUSHES | calvan-horizon-tools | 89.51 | CAT4278XZ |
C$ 89.51
In Stock
| Yes | No | |||
| 22 | PG332 - 6PC HUB CLEANING/RESURF PADS | atd | 44.99 | CAT4278XZ |
C$ 44.99
In Stock
| Yes | No | |||
| 23 | PG332 - LARGE DIAMETER HUB BRO LUG BOLT HUB CLEANER, 160MM DIAM. | ame-intl | 100.85 | CAT4278XZ |
C$ 100.85
In Stock
| Yes | No | |||
| 24 | PG332 - HUB BUDDY REPLACEMENT PADS 2", 6 PACK | ame-intl | 37.2 | CAT4278XZ |
C$ 37.20
In Stock
| Yes | No | |||
| 25 | PG332 - HUB BUDDY IMPACT DRIVEN LUG/DISC SURFACE CLEANER | ame-intl | 26.26 | CAT4278XZ |
C$ 26.26
In Stock
| Yes | No | |||
| 26 | PG332 - SCOTCH-BRITE ROLOC BRAKE HUB CLEANING DISCS, PURPLE, 1.5" X 5/8" CENTER HOLE, BOX OF 10 | 3m-products | 49.55 | CAT4278XZ |
3M Products
PG332 - SCOTCH-BRITE ROLOC BRAKE HUB CLEANING DISCS, PURPLE, 1.5" X 5/8" CENTER HOLE, BOX OF 10Part# 3MM-7546C$ 49.55
In Stock
| Yes | No |