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=4281 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 | |
|---|---|---|---|---|---|---|---|---|---|---|
| PG331 - 3/8 IN. STUD EXTRACTOR | titan-tools | 28.52 | CAT4281XZ |
C$ 28.52
In Stock
| Yes | No | ||||
| 1 | PG331 - WHEEL STUD SERVICE SET | otc-tools | 595.25 | CAT4281XZ |
C$ 595.25
In Stock
| Yes | No | |||
| 2 | PG331 - WHEEL STUD INSTALLER | lisle-corporation | 38.86 | CAT4281XZ |
C$ 38.86
In Stock
| Yes | No | |||
| 3 | PG331 - 8-PC WHEEL STUD PILOT PIN MASTER SET, INCL. 2 EACH OF: 12MM X 1.25, 12MM X 1.5, 14MM X 1.25, 14MM X 1.5 | lisle-corporation | 91.61 | CAT4281XZ | Yes | No | ||||
| 4 | PG331 - 12-PC BUTTON HEAD WHEEL STUD INSTALLER KIT | lang-tools | 133.61 | CAT4281XZ |
C$ 133.61
In Stock
| Yes | No | |||
| 5 | PG331 - STUD EXTRACTOR | gearwrench | 48.18 | CAT4281XZ |
C$ 48.18
In Stock
| Yes | No | |||
| 6 | PG331 - 6 PK WHEEL BULLETS | access-tools | 48.85 | CAT4281XZ |
C$ 48.85
In Stock
| Yes | No | |||
| 7 | PG331 - WHEEL STUD ALIGNMENT GUIDE TOOL, M16 X 1.5 MALE THREADS, FOR DODGE/RAM PROMASTER 2014-2020 | 9circle | 22.31 | CAT4281XZ |
9Circle
PG331 - WHEEL STUD ALIGNMENT GUIDE TOOL, M16 X 1.5 MALE THREADS, FOR DODGE/RAM PROMASTER 2014-2020Part# 9CL-96061C$ 22.31
In Stock
| Yes | No | |||
| 8 | PG331 - WHEEL STUD ALIGNMENT TOOL, M14 X 1.25 MALE THREADS | 9circle | 19.96 | CAT4281XZ |
C$ 19.96
In Stock
| Yes | No | |||
| 9 | PG331 - WHEEL STUD ALIGNMENT TOOL, M14 X 1.5 MALE THREADS | 9circle | 19.96 | CAT4281XZ |
C$ 19.96
In Stock
| Yes | No | |||
| 10 | Wheel Hanger - M12 x P1.5 (F) | 9circle | 19.36 | CAT4281XZ |
C$ 19.36
In Stock
| Yes | No | |||
| 11 | PG331 - WHEEL STUD ALIGNMENT TOOL, M12 X 1.5 MALE THREADS | 9circle | 18.53 | CAT4281XZ |
C$ 18.53
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No |