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=4001 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 | |
---|---|---|---|---|---|---|---|---|---|---|
PG364 COOLING SYSTEM ADAPTER - 12028 | motorad | 83.83 | CAT4001XZ |
C$ 83.83
In Stock
| Yes | No | ||||
1 | PG364 COOLING SYSTEM ADAPTER - 12025 | motorad | 91.13 | CAT4001XZ |
C$ 91.13
In Stock
| Yes | No | |||
2 | PG364 THREADE CAP ADAPTER FOR MANY LATE MODEL GM CARS AND TRUCKS, ALSO FREIGHTLINER AND IHC TRUCKS | motorad | 50.45 | CAT4001XZ |
MotoRad
PG364 THREADE CAP ADAPTER FOR MANY LATE MODEL GM CARS AND TRUCKS, ALSO FREIGHTLINER AND IHC TRUCKSPart# STA-12033C$ 50.45
In Stock
| Yes | No | |||
3 | PG364 COOLING SYSTEM ADAPTER - 12015 | motorad | 148.27 | CAT4001XZ |
C$ 148.27
In Stock
| Yes | No | |||
4 | PG346 - HEAVY DUTY COOLING SYSTEM TEST KIT | hickok-waekon | 749.21 | CAT4001XZ |
C$ 749.21
In Stock
| Yes | No | |||
5 | PG346 - ENGINE COOLANT SYSTEM PRESSURE TESTER (FORMERLY STANT #12270) | motorad | 156.11 | CAT4001XZ |
C$ 156.11
In Stock
| Yes | No | |||
6 | PG346 - 4-PIECE SMARTFIT UNIVERSAL RADIATOR ADAPTOR SET | redline | 157.49 | CAT4001XZ |
C$ 157.49
In Stock
| Yes | No | |||
7 | PG346 - SMARTFIT UNIVERSAL COOLING SYSTEM TEST KIT | redline | 238.32 | CAT4001XZ |
C$ 238.32
In Stock
| Yes | No | |||
8 | VW/AUDI COOLING SYSTEM PRESSURE TEST KIT | performance-brand-tools | 147.74 | CAT4001XZ |
C$ 147.74
In Stock
| Yes | No | |||
9 | PG347 - HEAVY DUTY COOLING SYSTEM PRESSURE TEST & REFILL KIT | mastercool | 537.89 | CAT4001XZ |
C$ 537.89
In Stock
| Yes | No | |||
10 | PG347 - 27-PC MASTER RADIATOR PRESSURE TEST KIT | mastercool | 402.89 | CAT4001XZ |
C$ 402.89
In Stock
| Yes | No | |||
11 | PG346 - COOLING SYSTEM PRESSURE KIT | mityvac | 96.89 | CAT4001XZ |
C$ 96.89
In Stock
| Yes | No | |||
12 | PG346 - RADIATOR TEST KIT | mityvac | 193.91 | CAT4001XZ |
C$ 193.91
In Stock
| Yes | No | |||
13 | PG346 - RADIATOR PRESSURE TESTER | mityvac | 75.47 | CAT4001XZ |
C$ 75.47
In Stock
| Yes | No | |||
14 | PG347 - HD COOLING SYSTEM TEST & REFIL | atd | 594.67 | CAT4001XZ |
C$ 594.67
In Stock
| Yes | No | |||
15 | PG347 - 10-PC COOLING SYSTEM PRESSURE TEST ADAPTER UPDATE KIT | atd | 101.39 | CAT4001XZ |
C$ 101.39
In Stock
| Yes | No | |||
16 | PG347 - 25PC RADIATOR PRESSURE TEST KIT | atd | 352.93 | CAT4001XZ |
C$ 352.93
In Stock
| Yes | No | |||
17 | PG347 - 27PC COOLING SYSTEM PRESS. KIT | atd | 411.97 | CAT4001XZ |
C$ 411.97
In Stock
| Yes | No | |||
18 | PG347 - UNIVERSAL COOLING SYSTEM PRESSURE TEST KIT | atd | 242.05 | CAT4001XZ |
C$ 242.05
In Stock
| Yes | No | |||
19 | PG347 - UNIVERSAL RADIATOR PRESSURE TESTER & VACUUM TYPE COOLING SYSTEM KIT | astro-pneumatics | 449.87 | CAT4001XZ |
Astro Pneumatics
PG347 - UNIVERSAL RADIATOR PRESSURE TESTER & VACUUM TYPE COOLING SYSTEM KITPart# AST-78585C$ 449.87
In Stock
| Yes | No | |||
20 | PG347 - UNIVERSAL AIR POWERED COOLING SYSTEM PRESSURE TESTER | astro-pneumatics | 55.99 | CAT4001XZ |
C$ 55.99
In Stock
| Yes | No |