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=4411 and pa.subcategory_id=4442 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 | |
|---|---|---|---|---|---|---|---|---|---|---|
| 3M Dry Guide Coat Cartridge, 05860, grey, 1.76 oz. (50 g) | 3m | 97.94 | CAT4442XZ |
C$ 97.94
In Stock
| Yes | No | ||||
| 1 | 3M Dry Guide Coat and Applicator Kit, 05861, grey, 1.76 oz. (50 g) | 3m | 141.36 | CAT4442XZ |
C$ 141.36
In Stock
| Yes | No | |||
| 2 | 3M Microfibre Detail Cloth Clip Strip, 39016, 12 x 14 in | 3m | 21.68 | CAT4442XZ |
C$ 21.68
In Stock
| Yes | No | |||
| 3 | PREMIUM RUBBERIZED UNDERC | norton | 26.89 | CAT4442XZ |
C$ 26.89
In Stock
| Yes | No | |||
| 4 | 3M Inspection Spray 06082, 1 gal (6.09 lb), 4.Case | 3m | 177.73 | CAT4442XZ |
C$ 177.73
| No | No | |||
| 5 | 3M Leather and Vinyl Repair Kit, 8579C | 3m | 28.32 | CAT4442XZ |
C$ 28.32
| No | No | |||
| 6 | CRYSTAL CLEAR 2K CHIP GUARD- 946 ml | dominion-sure-seal | 111.44 | CAT4442XZ |
C$ 111.44
| No | No | |||
| 7 | 3M Professional Headlight Restoration System | 3m | 1328.63 | CAT4442XZ |
C$ 1,328.63
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 8 | 3M Dust Control Spray, 06837, 1 gallon (3.8 L) | 3m | 166 | CAT4442XZ |
C$ 166.00
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 9 | 3M Dry Guide Coat Cartridge, 50416, orange, 1.76 oz. (50 g) | 3m | 97.94 | CAT4442XZ |
C$ 97.94
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 10 | CRYSTAL CLEAR 2K CHIP GUARD- 7.56 L | dominion-sure-seal | 579.19 | CAT4442XZ |
C$ 579.19
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No |