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=4427 and pa.subcategory_id=4474 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 | |
|---|---|---|---|---|---|---|---|---|---|---|
| Auto Resin - Gal. | evercoat | 142.33 | CAT4474XZ |
C$ 142.33
In Stock
| Yes | No | ||||
| 1 | Auto Resin - Qt. | evercoat | 51.43 | CAT4474XZ |
C$ 51.43
In Stock
| Yes | No | |||
| 2 | FG Cloth - Pkgd - 44 x 1 Yd. | evercoat | 36.42 | CAT4474XZ |
C$ 36.42
In Stock
| Yes | No | |||
| 3 | FG Cloth - Pkgd - 44 x 3 Yd. | evercoat | 86.17 | CAT4474XZ |
C$ 86.17
In Stock
| Yes | No | |||
| 4 | FG Cloth - Pkgd - 38 x 1 Yd. | evercoat | 31.51 | CAT4474XZ |
C$ 31.51
In Stock
| Yes | No | |||
| 5 | FG Mat - Pkgd - 1 Sq. Yd. - 1-1/2 oz. | evercoat | 35.29 | CAT4474XZ |
C$ 35.29
In Stock
| Yes | No | |||
| 6 | FG Mat - Pkgd - 3 Sq. Yd. - 1-1/2 oz. | evercoat | 91.68 | CAT4474XZ |
C$ 91.68
In Stock
| Yes | No | |||
| 7 | FG Mat - Pkgd - 8 Sq. Ft. - 3/4 oz. | evercoat | 23.09 | CAT4474XZ |
C$ 23.09
In Stock
| Yes | No | |||
| 8 | Automotive Resin Quart | evercoat | 34.51 | CAT4474XZ |
C$ 34.51
In Stock
| Yes | No | |||
| 9 | Automotive Resin Gallon | evercoat | 107.09 | CAT4474XZ |
C$ 107.09
In Stock
| Yes | No | |||
| 10 | Automotive Resin Kit Quart | evercoat | 58.1 | CAT4474XZ |
C$ 58.10
In Stock
| Yes | No | |||
| 11 | Automotive Resin Kit Gallon | evercoat | 154.96 | CAT4474XZ |
C$ 154.96
In Stock
| Yes | No | |||
| 12 | SMC Resin - Gal. | evercoat | 268.04 | CAT4474XZ |
C$ 268.04
Limited Stock
| Yes | No | |||
| 13 | Auto Resin - Pt. | evercoat | 33.64 | CAT4474XZ |
C$ 33.64
| No | No | |||
| 14 | FG Cloth - Pkgd - 38 x 3 Yd. | evercoat | 76.12 | CAT4474XZ |
C$ 76.12
| No | No | |||
| 15 | SMC Resin - Qt. | evercoat | 87.64 | CAT4474XZ |
C$ 87.64
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No |