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=4279 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 | |
|---|---|---|---|---|---|---|---|---|---|---|
| PG330 - 7-PC DAMAGED LUG NUT FLIP SOCKET SET WITH HALF METRIC SIZES, 17MM TO 27.5MM | cta | 126.72 | CAT4279XZ |
CTA
PG330 - 7-PC DAMAGED LUG NUT FLIP SOCKET SET WITH HALF METRIC SIZES, 17MM TO 27.5MMPart# CTA-7307C$ 126.72
In Stock
| Yes | No | ||||
| 1 | PG330 - 17MM X 17.5MM DAMAGED LUG NUT FLIP SOCKET | cta | 18.95 | CAT4279XZ |
C$ 18.95
In Stock
| Yes | No | |||
| 2 | 4 PC. LUG NUT REMOVER SOCKET SET | cta | 56.83 | CAT4279XZ |
C$ 56.83
In Stock
| Yes | No | |||
| 3 | PG330 - 9-PC 1/2" DR. EXTRA THIN WALL WHEEL PROTECTOR IMPACT SOCKET | sunex | 135.88 | CAT4279XZ |
C$ 135.88
In Stock
| Yes | No | |||
| 4 | PG330 - 16-PIECE LOCKING LUG NUT MASTER KEY SET | steelman | 167.54 | CAT4279XZ |
C$ 167.54
In Stock
| Yes | No | |||
| 5 | PG330 - DUAL SIDED TWIST SOCKET LUGNUT REMOVER | lti-tools-lock-technology | 45.91 | CAT4279XZ |
C$ 45.91
In Stock
| Yes | No | |||
| 6 | PG330 - DELUXE HUBCAP & WHEEL LOCK REMOVAL KIT | lti-tools-lock-technology | 136.63 | CAT4279XZ |
C$ 136.63
In Stock
| Yes | No | |||
| 7 | PG330 - LOOSE WHEEL NUT INDICATOR REMOVAL TOOL FOUND ON HEAVY-DUTY FLEET VEHICLES | cta | 95.05 | CAT4279XZ |
CTA
PG330 - LOOSE WHEEL NUT INDICATOR REMOVAL TOOL FOUND ON HEAVY-DUTY FLEET VEHICLESPart# CTA-5415C$ 95.05
In Stock
| Yes | No | |||
| 8 | PG330 - MERCEDES LUG BOLT SOCKET, 2009+ | cta | 26.42 | CAT4279XZ |
C$ 26.42
In Stock
| Yes | No | |||
| 9 | PG330 - 5-PC LUG NUT REMOVER SET | cta | 73.8 | CAT4279XZ |
C$ 73.80
In Stock
| Yes | No | |||
| 10 | PG330 - 5PC FLIP SOCKET SET | cta | 80.27 | CAT4279XZ |
C$ 80.27
In Stock
| Yes | No | |||
| 11 | PG330 - 16PC LOCKING LUG NUT MASTER KEY SET | atd | 182.58 | CAT4279XZ |
C$ 182.58
In Stock
| Yes | No | |||
| 12 | PG330 - FLANK BITE DAMAGED LUG NUT SKT SET W/ SPINNING PROTECTIVE SL | astro-pneumatics | 52.13 | CAT4279XZ |
Astro Pneumatics
PG330 - FLANK BITE DAMAGED LUG NUT SKT SET W/ SPINNING PROTECTIVE SLPart# AST-7404C$ 52.13
In Stock
| Yes | No | |||
| 13 | PG330 - 2PC. 1/2" DRIVE DOUBLE ENDED TWIST SOCKET SET | astro-pneumatics | 62.04 | CAT4279XZ |
C$ 62.04
In Stock
| Yes | No | |||
| 14 | 3-PC 1/2" DR. SPLINE PLUS LUG NUT REMOVAL SOCKET SET FOR SUV/LIGHT TRUCKS, 22MM, 7/8", 15/16" | ame-intl | 60.54 | CAT4279XZ |
AME Intl
3-PC 1/2" DR. SPLINE PLUS LUG NUT REMOVAL SOCKET SET FOR SUV/LIGHT TRUCKS, 22MM, 7/8", 15/16"Part# AME-68025C$ 60.54
In Stock
| Yes | No | |||
| 15 | Socket Bro 4 Pc Set Includes 17mm, 19mm, 21mm Sockets and Disc | ame-intl | 165.77 | CAT4279XZ |
C$ 165.77
In Stock
| Yes | No | |||
| 16 | PG330 - NUT BUDDY | ame-intl | 158.26 | CAT4279XZ |
C$ 158.26
In Stock
| Yes | No | |||
| 17 | PG330 - EASY OFF TWIST SOCKET SET | access-tools | 106.48 | CAT4279XZ |
C$ 106.48
In Stock
| Yes | No |