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=4766 and pa.subcategory_id=4897 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 | |
|---|---|---|---|---|---|---|---|---|---|---|
| PVA Synthetic Chamy | auto-chem | 10.73 | CAT4897XZ |
C$ 10.73
In Stock
| Yes | No | ||||
| 1 | MICRO FIBRE CLOTH KIT(4PC) | ilink | 9.92 | CAT4897XZ |
C$ 9.92
In Stock
| Yes | No | |||
| 2 | EVAPORTOR DRYING TOWEL | mallory | 17.03 | CAT4897XZ |
C$ 17.03
In Stock
| Yes | No | |||
| 3 | Meguiars Water Magnet Drying Towel | meguiars | 24.49 | CAT4897XZ |
C$ 24.49
In Stock
| Yes | No | |||
| 4 | Rags | nls | 22.31 | CAT4897XZ |
| Yes | No | |||
| 5 | Dry Blade | auto-chem | 29.09 | CAT4897XZ |
| Yes | No | |||
| 6 | Synthetic Chamy Britmen | auto-chem | 26 | CAT4897XZ |
C$ 26.00
Limited Stock
| Yes | No | |||
| 7 | GENUINE CHAMOIS 4 SQ FT | ilink | 24.42 | CAT4897XZ |
C$ 24.42
Limited Stock
| Yes | No | |||
| 8 | DRYING CLOTH 3SQ FT W/TUBE | ilink | 10.88 | CAT4897XZ |
C$ 10.88
| No | No | |||
| 9 | TERRY TOWELS 6 PCS FLAT | ilink | 13.27 | CAT4897XZ |
C$ 13.27
| No | No | |||
| 10 | POLISHING CLOTH 6 PC ROLL | ilink | 11.08 | CAT4897XZ |
C$ 11.08
| No | No | |||
| 11 | MICROFIBRE DASH TOWEL GRN | ilink | 3.82 | CAT4897XZ |
C$ 3.82
| No | No | |||
| 12 | MICROFIBRE GLASS TOWEL BLU | ilink | 4.94 | CAT4897XZ |
C$ 4.94
| No | No | |||
| 13 | MICROFIBRE POLISH.CLOTH YL | ilink | 4.94 | CAT4897XZ |
C$ 4.94
| No | No | |||
| 14 | Double Mega chamy Microfiber | auto-chem | 10.91 | CAT4897XZ |
C$ 10.91
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 15 | Chamy Wringer | auto-chem | 269.17 | CAT4897XZ |
C$ 269.17
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 16 | SYNTHETIC CHAMOIS 432 SQ IN | ilink | 5.62 | CAT4897XZ |
C$ 5.62
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 17 | LINT FREE UNBLEACH. 3SQ YD | ilink | 2.56 | CAT4897XZ |
C$ 2.56
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 18 | LINT FREE UNBLEACH.5 SQ YD | ilink | 3.25 | CAT4897XZ |
C$ 3.25
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 19 | 3 pk Microfiber Towel 16x16 (80/20 Blend) | mallory | 9.16 | CAT4897XZ |
C$ 9.16
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 20 | 3 SQ FT CHAMOIS | mallory | 45.19 | CAT4897XZ |
C$ 45.19
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 21 | Synthetic Chamois 3.5sqft (20 x 25) | mallory | 17.16 | CAT4897XZ |
C$ 17.16
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 22 | MICROFIBER MAX DRYING TOWEL | mallory | 16.79 | CAT4897XZ |
C$ 16.79
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 23 | "Microfiber MAX" Total Clean All Over Body Mitt - 4 in 1, 7" x 10" | mallory | 13.26 | CAT4897XZ |
C$ 13.26
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 24 | "Microfiber MAX" - Premium Body Sponge - Soft Fleece Design, 8" x 5" x 2" | mallory | 12.24 | CAT4897XZ |
C$ 12.24
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 25 | "Microfiber MAX" Soft Touch Detailing Towel - Soft Fleece Design, 16" x 18" | mallory | 17.51 | CAT4897XZ |
Mallory
"Microfiber MAX" Soft Touch Detailing Towel - Soft Fleece Design, 16" x 18"Part# 45606ASCBLC$ 17.51
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 26 | Car Wash Mitt | nls | 17.77 | CAT4897XZ |
C$ 17.77
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 27 | Chamois | nls | 26.39 | CAT4897XZ |
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No |