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=3999 and pa.subcategory_id=4002 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 | |
|---|---|---|---|---|---|---|---|---|---|---|
| PG348 - AIRLIFT II HD | uview | 220.01 | CAT4002XZ |
C$ 220.01
In Stock
| Yes | No | ||||
| 1 | PG348 - AIRLIFT II | uview | 175.63 | CAT4002XZ |
C$ 175.63
In Stock
| Yes | No | |||
| 2 | PG348 - AIRLIFT KIT | uview | 274.45 | CAT4002XZ |
C$ 274.45
In Stock
| Yes | No | |||
| 3 | PG348 - VACUUM TYPE COOLING SYSTEM FILLER KIT | mastercool | 117.41 | CAT4002XZ |
C$ 117.41
In Stock
| Yes | No | |||
| 4 | PG348 - SPRAY WASHER & COOLING SYSTEM FLUSHER | mityvac | 162.77 | CAT4002XZ |
C$ 162.77
In Stock
| Yes | No | |||
| 5 | PG348 - COOLING SYSTEM FLUSHER FOR VEHICLE SERVICE & HEAVY-DUTY APPLICATIONS, FITS 3/4" - 2" DIAM. HOSES | mityvac | 148.99 | CAT4002XZ |
Mityvac
PG348 - COOLING SYSTEM FLUSHER FOR VEHICLE SERVICE & HEAVY-DUTY APPLICATIONS, FITS 3/4" - 2" DIAM. HOSESPart# MIT-MV4570C$ 148.99
In Stock
| Yes | No | |||
| 6 | PG348 - COOLING SYSTEM AIREVAC | mityvac | 263.57 | CAT4002XZ |
C$ 263.57
In Stock
| Yes | No | |||
| 7 | PG348 - 18-PC SPILL-FREE COOLANT FUNNEL SET | lisle-corporation | 60.95 | CAT4002XZ |
C$ 60.95
In Stock
| Yes | No | |||
| 8 | PG348 - SPILL-FREE CLEAR COOLANT FUNNEL | lisle-corporation | 45.16 | CAT4002XZ |
C$ 45.16
In Stock
| Yes | No | |||
| 9 | PG348 - 4PC COOLNG SYS VAC PURGE/REFIL | atd | 137.39 | CAT4002XZ |
C$ 137.39
In Stock
| Yes | No | |||
| 10 | PG348 - VOLVO TRUCK COOLANT DRAIN HOSE AND FITTING | assenmacher | 92.36 | CAT4002XZ |
C$ 92.36
In Stock
| Yes | No | |||
| 11 | PG348 - COOLING SYSTEM VACUUM PURGE AND REFILL KIT | 9circle | 129.24 | CAT4002XZ |
C$ 129.24
In Stock
| Yes | No |