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=4764 and pa.subcategory_id=4904 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 | |
|---|---|---|---|---|---|---|---|---|---|---|
| TRIM CARE Plastic & Trim Restorer | auto-chem | 15.29 | CAT4904XZ |
C$ 15.29
In Stock
| Yes | No | ||||
| 1 | FREE SHINE Silicone Free Dressing | auto-chem | 12.5 | CAT4904XZ |
C$ 12.50
In Stock
| Yes | No | |||
| 2 | CRC Zinc Mate (F/E) 12X369G | crc | 19.5 | CAT4904XZ |
C$ 19.50
In Stock
| Yes | No | |||
| 3 | ARMASHINE PROTECTANT | kleen-flo | 12.3 | CAT4904XZ |
C$ 12.30
In Stock
| Yes | No | |||
| 4 | Slick Mist Speed Wax/12x1/24 Ounce/710 mL | lucas-oil | 12.72 | CAT4904XZ |
C$ 12.72
In Stock
| Yes | No | |||
| 5 | Slick Mist Tire & Trim Shine/6x1/24 Ounce/710 mL | lucas-oil | 13.48 | CAT4904XZ |
C$ 13.48
In Stock
| Yes | No | |||
| 6 | Slick Mist Interior Detailer/6x1/24 Ounce/710 mL | lucas-oil | 12.26 | CAT4904XZ |
C$ 12.26
In Stock
| Yes | No | |||
| 7 | Slick Mist Detail Kit/4x1 | lucas-oil | 40.79 | CAT4904XZ |
C$ 40.79
In Stock
| Yes | No | |||
| 8 | Meguiars PlastX Plastic Cleaner, G12310C, 10 fl. oz. (284 ml) | meguiars | 15.9 | CAT4904XZ |
C$ 15.90
In Stock
| Yes | No | |||
| 9 | Black Magic Multi-Surface Detailer, 473mL | permatex | 10.74 | CAT4904XZ |
C$ 10.74
In Stock
| Yes | No | |||
| 10 | COLD WAX Cold Spray Wax | auto-chem | 29.8 | CAT4904XZ |
C$ 29.80
| No | No | |||
| 11 | COLD WAX Cold Spray Wax | auto-chem | 13.1 | CAT4904XZ |
C$ 13.10
| No | No | |||
| 12 | COLD WAX Cold Spray Wax | auto-chem | 120.3 | CAT4904XZ |
C$ 120.30
| No | No | |||
| 13 | ECO WET SHINE Plastic & Rubber H2O Wet Shine | auto-chem | 40.82 | CAT4904XZ |
C$ 40.82
| No | No | |||
| 14 | ECO WET SHINE Plastic & Rubber H2O Wet Shine | auto-chem | 9.68 | CAT4904XZ |
C$ 9.68
| No | No | |||
| 15 | DETAIL Rubber Dressing | auto-chem | 12.8 | CAT4904XZ |
C$ 12.80
| No | No | |||
| 16 | AQUA FAB II Fabric treatment | auto-chem | 23.11 | CAT4904XZ |
C$ 23.11
| No | No | |||
| 17 | SLICK MIST CERAMIC WAX | lucas-oil | 18.29 | CAT4904XZ |
C$ 18.29
| No | No | |||
| 18 | PROTECTANT - RUBBERVINYLPLASTIC | mothers | 16.38 | CAT4904XZ |
C$ 16.38
| No | No | |||
| 19 | Black Magic Factory Black Trim & Plastic Restorer, 59mL | permatex | 16.5 | CAT4904XZ |
C$ 16.50
| No | No | |||
| 20 | FABRIC GUARD Fabric Protector | auto-chem | 249.49 | CAT4904XZ |
C$ 249.49
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 21 | ECO WET SHINE Plastic & Rubber H2O Wet Shine | auto-chem | 13.24 | CAT4904XZ |
C$ 13.24
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 22 | ECO WET SHINE Plastic & Rubber H2O Wet Shine | auto-chem | 160.33 | CAT4904XZ |
C$ 160.33
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 23 | CRC Zinc Mate (F/E) 12X368G | crc | 0 | CAT4904XZ |
C$ 0.00
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 24 | Slick Mist Tire & Trim Shine/20x1/2 Ounce/59 mL Display | lucas-oil | 3.12 | CAT4904XZ |
C$ 3.12
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 25 | Slick Mist Speed Wax/20x1/2 Ounce/59 mL | lucas-oil | 3.19 | CAT4904XZ |
C$ 3.19
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 26 | PROTECTANT - RUBBERVINYLPLASTIC | mothers | 0 | CAT4904XZ |
C$ 0.00
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No |