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=4133 and pa.subcategory_id=4180 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 | |
|---|---|---|---|---|---|---|---|---|---|---|
| PG127 - 11-PC 3/8"DR. PIPE PLUG SOCKET SET | sunex | 104.21 | CAT4180XZ |
C$ 104.21
In Stock
| Yes | No | ||||
| 1 | PG127 - 8-PC 1/2" DR. PIPE PLUG SOCKET SET | sunex | 98.92 | CAT4180XZ |
C$ 98.92
In Stock
| Yes | No | |||
| 2 | PG245 - DRAIN PLUG PRO | otc-tools | 30 | CAT4180XZ |
C$ 30.00
In Stock
| Yes | No | |||
| 3 | PG245 - OIL PAN RETHREADING KIT | lisle-corporation | 189.05 | CAT4180XZ |
C$ 189.05
In Stock
| Yes | No | |||
| 4 | PG245 - PLUGS & GASKETS (SET OF 5) FOR LISLE KIT #58850 | lisle-corporation | 36.76 | CAT4180XZ |
C$ 36.76
In Stock
| Yes | No | |||
| 5 | AUDI/VW OIL DRAIN PLUG SOCKET WRENCH WITH BALL HEAD 8MM XZN | cta | 39.02 | CAT4180XZ |
C$ 39.02
In Stock
| Yes | No | |||
| 6 | PG245 - 8-1 MULTI-WRENCH - 12-19MM HEX - BOX | cta | 65.48 | CAT4180XZ |
C$ 65.48
In Stock
| Yes | No | |||
| 7 | PG245 - 8-PC. DRAIN PLUG KIT | cta | 109.84 | CAT4180XZ |
C$ 109.84
In Stock
| Yes | No | |||
| 8 | PG246 - AUDI/VW/VOLVO OIL DRAIN PLUG TOOL | cta | 11.56 | CAT4180XZ |
C$ 11.56
In Stock
| Yes | No | |||
| 9 | 4-PC OIL PAN PLUG REMOVER | calvan-horizon-tools | 62.12 | CAT4180XZ |
C$ 62.12
In Stock
| Yes | No | |||
| 10 | PG245 - VW NYLON DRAIN PLUG AND TOOL SET | 9circle | 36.34 | CAT4180XZ |
C$ 36.34
In Stock
| Yes | No | |||
| 11 | PG245 - OIL DRAIN PLUG REPAIR/REPLACEMENT KIT M15 1.5P | 9circle | 38.94 | CAT4180XZ |
C$ 38.94
In Stock
| Yes | No | |||
| 12 | DRAIN PLUG WRENCH, XL, OFFSET BOX HEADS 14MM X 17MM | vim-tools | 36.34 | CAT4180XZ |
C$ 36.34
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 13 | 3-PC PLASTIC OIL PAN DRAIN PLUG SET, FOR LATE MODEL AUDI, BMW, FORD & VW | lisle-corporation | 40.01 | CAT4180XZ |
Lisle Corporation
3-PC PLASTIC OIL PAN DRAIN PLUG SET, FOR LATE MODEL AUDI, BMW, FORD & VWPart# LIS-51150C$ 40.01
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 14 | 8-1 Multi-Wrench - Square/Hex -Box | cta | 57.68 | CAT4180XZ |
C$ 57.68
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No |