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=4770 and pa.subcategory_id=4912 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 | |
|---|---|---|---|---|---|---|---|---|---|---|
| EXTRA FLUSH GALLON | cooling-depot-chemicals | 249.25 | CAT4912XZ |
C$ 249.25
In Stock
| Yes | No | ||||
| 1 | EXTRA FLUSH QUART | cooling-depot-chemicals | 70.3 | CAT4912XZ |
C$ 70.30
In Stock
| Yes | No | |||
| 2 | AC SYNTHETIC OIL ESTER QT(SYNT.LUBRICANT) | cooling-depot-chemicals | 54.29 | CAT4912XZ |
C$ 54.29
In Stock
| Yes | No | |||
| 3 | AC SYNTHETIC OIL ESTER+UV DYE QUART | cooling-depot-chemicals | 61.24 | CAT4912XZ |
C$ 61.24
In Stock
| Yes | No | |||
| 4 | AC SYNTHETIC OIL ESTER 8OZ(SYNTH.LUBRICANT) | cooling-depot-chemicals | 17.36 | CAT4912XZ |
C$ 17.36
In Stock
| Yes | No | |||
| 5 | AC SYNTHETIC OIL ESTER+UV DYE 8OZ | cooling-depot-chemicals | 18.41 | CAT4912XZ |
C$ 18.41
In Stock
| Yes | No | |||
| 6 | AC SYNTHETIC OIL PAG46+UV DYE 8OZ | cooling-depot-chemicals | 20.5 | CAT4912XZ |
C$ 20.50
In Stock
| Yes | No | |||
| 7 | AC SYNTHETIC OIL PAG100 8OZ | cooling-depot-chemicals | 19.09 | CAT4912XZ |
C$ 19.09
In Stock
| Yes | No | |||
| 8 | AC SYNTHETIC OIL PAG100 QUART | cooling-depot-chemicals | 62.72 | CAT4912XZ |
C$ 62.72
In Stock
| Yes | No | |||
| 9 | AC SYNTHETIC OIL PAG100+UV DYE 8OZ | cooling-depot-chemicals | 20.5 | CAT4912XZ |
C$ 20.50
In Stock
| Yes | No | |||
| 10 | AC SYNTHETIC OIL PAG150 8OZ | cooling-depot-chemicals | 20.12 | CAT4912XZ |
C$ 20.12
In Stock
| Yes | No | |||
| 11 | AC SYNTHETIC OIL PAG150+UV DYE 8OZ | cooling-depot-chemicals | 21.5 | CAT4912XZ |
C$ 21.50
In Stock
| Yes | No | |||
| 12 | AC SYNTHETIC OIL HYBRID A/C COMP LUBRIC.7OZ | cooling-depot-chemicals | 35.04 | CAT4912XZ |
C$ 35.04
In Stock
| Yes | No | |||
| 13 | Industrial Strength Radiator & Engine Cleaner, 16 oz. | irontite | 25.74 | CAT4912XZ |
C$ 25.74
In Stock
| Yes | No | |||
| 14 | Head Gasket & Radiator Sealant, 16 oz. | irontite | 18.29 | CAT4912XZ |
C$ 18.29
In Stock
| Yes | No | |||
| 15 | Ceramic Cooling System Sealer, 16 oz. | irontite | 18 | CAT4912XZ |
C$ 18.00
Limited Stock
| Yes | No | |||
| 16 | AC SYNTHETIC OIL PAG46 8OZ | cooling-depot-chemicals | 19.09 | CAT4912XZ |
C$ 19.09
| No | No | |||
| 17 | A/C Cartridge Injector Gun | nls | 155.99 | CAT4912XZ |
C$ 155.99
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 18 | VPS ALL SEASON HEATER & A/C ODOR ELIMINATOR KIT | valvoline | 68.5 | CAT4912XZ |
C$ 68.50
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No |