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=4429 and pa.subcategory_id=4477 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 | |
|---|---|---|---|---|---|---|---|---|---|---|
| UNIVERSAL BLACK | sherwin-williams-dupli-color | 9.72 | CAT4477XZ |
C$ 9.72
In Stock
| Yes | No | ||||
| 1 | GM BLUE 283G | sherwin-williams-dupli-color | 9.72 | CAT4477XZ |
C$ 9.72
In Stock
| Yes | No | |||
| 2 | CHEVY ORANGE 283G | sherwin-williams-dupli-color | 9.72 | CAT4477XZ |
C$ 9.72
In Stock
| Yes | No | |||
| 3 | ENAMEL ENGINE FORD B | sherwin-williams-dupli-color | 14.98 | CAT4477XZ |
C$ 14.98
In Stock
| Yes | No | |||
| 4 | ENAMEL ENGINE UNIVER | sherwin-williams-dupli-color | 14.98 | CAT4477XZ |
C$ 14.98
In Stock
| Yes | No | |||
| 5 | ENAMEL ENGINE FORD R | sherwin-williams-dupli-color | 14.98 | CAT4477XZ |
C$ 14.98
In Stock
| Yes | No | |||
| 6 | ENAMEL ENGINE FORD G | sherwin-williams-dupli-color | 14.98 | CAT4477XZ |
C$ 14.98
In Stock
| Yes | No | |||
| 7 | ENAMEL ENGINE GLOSS | sherwin-williams-dupli-color | 14.98 | CAT4477XZ |
C$ 14.98
In Stock
| Yes | No | |||
| 8 | ENAMEL ENGINE ALUMIN | sherwin-williams-dupli-color | 14.98 | CAT4477XZ |
C$ 14.98
In Stock
| Yes | No | |||
| 9 | ENAMEL ENGINE CHEVRO | sherwin-williams-dupli-color | 14.98 | CAT4477XZ |
C$ 14.98
In Stock
| Yes | No | |||
| 10 | ENAMEL ENGINE OLD FO | sherwin-williams-dupli-color | 14.98 | CAT4477XZ |
C$ 14.98
In Stock
| Yes | No | |||
| 11 | ENAMEL ENGINE GM/CHR | sherwin-williams-dupli-color | 14.98 | CAT4477XZ |
C$ 14.98
In Stock
| Yes | No | |||
| 12 | SEMI-GLOSS BLK | sherwin-williams-dupli-color | 14.98 | CAT4477XZ |
C$ 14.98
In Stock
| Yes | No | |||
| 13 | ENAMEL ENGINE CUMMIN | sherwin-williams-dupli-color | 14.98 | CAT4477XZ |
C$ 14.98
In Stock
| Yes | No | |||
| 14 | ENAMEL ENGINE GRABBE | sherwin-williams-dupli-color | 14.98 | CAT4477XZ |
C$ 14.98
In Stock
| Yes | No | |||
| 15 | ENAMEL ENGINE DAYTON | sherwin-williams-dupli-color | 14.98 | CAT4477XZ |
C$ 14.98
In Stock
| Yes | No | |||
| 16 | ENAMEL ENGINE CAST C | sherwin-williams-dupli-color | 14.98 | CAT4477XZ |
C$ 14.98
In Stock
| Yes | No | |||
| 17 | ENAMEL ENGINE CAST C | sherwin-williams-dupli-color | 14.98 | CAT4477XZ |
C$ 14.98
In Stock
| Yes | No | |||
| 18 | CHRYSLER HEMI ORANGE 340G | sherwin-williams-dupli-color | 14.98 | CAT4477XZ |
C$ 14.98
In Stock
| Yes | No | |||
| 19 | ENAMEL ENGINE RED | sherwin-williams-dupli-color | 14.98 | CAT4477XZ |
C$ 14.98
In Stock
| Yes | No | |||
| 20 | FLAT BLACK ENGINE | sherwin-williams-dupli-color | 14.98 | CAT4477XZ |
C$ 14.98
In Stock
| Yes | No | |||
| 21 | GRAY PRIMER 312G | sherwin-williams-dupli-color | 20.36 | CAT4477XZ |
C$ 20.36
In Stock
| Yes | No | |||
| 22 | COATING HIGH TEMP.FLAT WHT | sherwin-williams-dupli-color | 20.36 | CAT4477XZ |
C$ 20.36
In Stock
| Yes | No | |||
| 23 | COATING HIGH TEMP.FLAT BLK | sherwin-williams-dupli-color | 20.36 | CAT4477XZ |
C$ 20.36
In Stock
| Yes | No | |||
| 24 | COATING HIGH TEMP.FLAT SILV | sherwin-williams-dupli-color | 20.36 | CAT4477XZ |
C$ 20.36
In Stock
| Yes | No | |||
| 25 | COATING HIGH TEMP.FLAT RED | sherwin-williams-dupli-color | 20.36 | CAT4477XZ |
C$ 20.36
In Stock
| Yes | No | |||
| 26 | COATING HIGH TEMP.FLAT ORAN | sherwin-williams-dupli-color | 20.36 | CAT4477XZ |
C$ 20.36
In Stock
| Yes | No | |||
| 27 | COATING HIGH TEMP.CLEAR | sherwin-williams-dupli-color | 20.36 | CAT4477XZ |
C$ 20.36
In Stock
| Yes | No | |||
| 28 | COATING HIGH TEMP.FLAT ALUM | sherwin-williams-dupli-color | 20.36 | CAT4477XZ |
C$ 20.36
In Stock
| Yes | No | |||
| 29 | COATING HIGH TEMP RED | sherwin-williams-dupli-color | 20 | CAT4477XZ |
C$ 20.00
In Stock
| Yes | No | |||
| 30 | ENGINE MET HIGHTEMP COPPER | sherwin-williams-dupli-color | 21.28 | CAT4477XZ |
C$ 21.28
In Stock
| Yes | No | |||
| 31 | ENGINE MET HIGHTEMP SILVER | sherwin-williams-dupli-color | 21.28 | CAT4477XZ |
C$ 21.28
In Stock
| Yes | No | |||
| 32 | ENGINE MET HIGHTEMP GOLD FK | sherwin-williams-dupli-color | 21.28 | CAT4477XZ |
C$ 21.28
In Stock
| Yes | No | |||
| 33 | COATING HIGH TEMP CAST IRON | sherwin-williams-dupli-color | 20.36 | CAT4477XZ |
C$ 20.36
In Stock
| Yes | No | |||
| 34 | ALUMINUM 283G | sherwin-williams-dupli-color | 9.72 | CAT4477XZ |
C$ 9.72
Limited Stock
| Yes | No | |||
| 35 | COATING HIGH TEMP.BLACK | sherwin-williams-dupli-color | 20 | CAT4477XZ |
C$ 20.00
Limited Stock
| Yes | No | |||
| 36 | FORD BLUE 283G | sherwin-williams-dupli-color | 9.72 | CAT4477XZ |
C$ 9.72
| No | No | |||
| 37 | FORD RED 283G | sherwin-williams-dupli-color | 9.72 | CAT4477XZ |
C$ 9.72
| No | No | |||
| 38 | ALPINE GREEN | sherwin-williams-dupli-color | 14.98 | CAT4477XZ |
C$ 14.98
| No | No | |||
| 39 | ENAMEL ENGINE CLEAR | sherwin-williams-dupli-color | 14.98 | CAT4477XZ |
C$ 14.98
| No | No | |||
| 40 | ENGINE MET HIGHTEMP RED FIR | sherwin-williams-dupli-color | 21.28 | CAT4477XZ |
C$ 21.28
| No | No | |||
| 41 | BLACK 312G | sherwin-williams-krylon | 21.53 | CAT4477XZ |
C$ 21.53
| No | No | |||
| 42 | UNIV WHITE | sherwin-williams-dupli-color | 14.98 | CAT4477XZ |
C$ 14.98
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 43 | ENAMEL ENGINE NEW FO | sherwin-williams-dupli-color | 14.98 | CAT4477XZ |
C$ 14.98
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 44 | ENAMEL ENGINE GM BLU | sherwin-williams-dupli-color | 14.98 | CAT4477XZ |
C$ 14.98
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 45 | ENGINE PRIMER | sherwin-williams-dupli-color | 14.98 | CAT4477XZ |
C$ 14.98
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 46 | ENAMEL ENGINE CHRYSL | sherwin-williams-dupli-color | 14.98 | CAT4477XZ |
C$ 14.98
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 47 | SILVER 340G | sherwin-williams-krylon | 17.1 | CAT4477XZ |
C$ 17.10
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 48 | BBQ & STOVE BLACK 340G | sherwin-williams-krylon | 17.06 | CAT4477XZ |
C$ 17.06
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No |