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=3897 and pa.subcategory_id=3912 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 | |
|---|---|---|---|---|---|---|---|---|---|---|
| PG18 - PAG 150 OIL CARTRIDGE | uview | 20.47 | CAT3912XZ |
C$ 20.47
In Stock
| Yes | No | ||||
| 1 | PG18 - PAG 125 OIL CARTRIDGE | uview | 20.47 | CAT3912XZ |
C$ 20.47
In Stock
| Yes | No | |||
| 2 | PG18 - ESTER OIL CARTRIDGE (100 VISCOSITY) (8 OZ) | uview | 27.23 | CAT3912XZ |
C$ 27.23
In Stock
| Yes | No | |||
| 3 | PG18 - HYBRID ESTER A/C OIL CARTRIDGE (4OZ / 120ML) | uview | 42.79 | CAT3912XZ |
C$ 42.79
In Stock
| Yes | No | |||
| 4 | PG18 - PAG 100 OIL - 8 OZ. BOTTLE WITH A/C EXTENDYE | uview | 15.53 | CAT3912XZ |
C$ 15.53
In Stock
| Yes | No | |||
| 5 | PG18 - PAG 100 OIL CARTRIDGE (8 OZ) | uview | 20.47 | CAT3912XZ |
C$ 20.47
In Stock
| Yes | No | |||
| 6 | PG18 - PAG OIL CARTRIDGE 1234YF (46 VISCOSITY), 8 OZ/240 ML | uview | 28.85 | CAT3912XZ |
C$ 28.85
In Stock
| Yes | No | |||
| 7 | PG18 - PAG 46 OIL - 8 OZ. BOTTLE WITH A/C EXTENDYE | uview | 11.47 | CAT3912XZ |
C$ 11.47
In Stock
| Yes | No | |||
| 8 | PG18 - PAG OIL CARTRIDGE (46 VISCOSITY) | uview | 20.47 | CAT3912XZ |
C$ 20.47
In Stock
| Yes | No | |||
| 9 | PG18 - UNIVERSAL ESTER OIL WITH DYE AND EBOOST (16OZ / 480 ML) | uview | 32.99 | CAT3912XZ |
C$ 32.99
In Stock
| Yes | No | |||
| 10 | PG18 - SPOTGUN HFO OIL INJECTION KIT | uview | 118.39 | CAT3912XZ |
C$ 118.39
In Stock
| Yes | No | |||
| 11 | PG18 - SPOTGUN OIL INJECTION KIT | uview | 119.57 | CAT3912XZ |
C$ 119.57
In Stock
| Yes | No | |||
| 12 | DYE,A/C,POE,1X8OZ | tracerline | 82.81 | CAT3912XZ |
C$ 82.81
In Stock
| Yes | No | |||
| 13 | PG18 - SYRINGE-TYPE R134A OIL INJECTOR, POE-LABELED FOR HYBRID & ELECTRIC VEHICLES | robinair | 193.27 | CAT3912XZ |
Robinair
PG18 - SYRINGE-TYPE R134A OIL INJECTOR, POE-LABELED FOR HYBRID & ELECTRIC VEHICLESPart# ROB-18490C$ 193.27
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 14 | PG18 - SYRINGE-TYPE R134A OIL INJECTOR, PAG-LABELED FOR GAS & DIESEL VEHICLES | robinair | 193.27 | CAT3912XZ |
Robinair
PG18 - SYRINGE-TYPE R134A OIL INJECTOR, PAG-LABELED FOR GAS & DIESEL VEHICLESPart# ROB-18480C$ 193.27
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 15 | PG18 - SYRINGE-TYPE R1234YF OIL INJECTOR, POE-LABELED FOR HYBRID & ELECTRIC VEHICLES | robinair | 257.71 | CAT3912XZ |
Robinair
PG18 - SYRINGE-TYPE R1234YF OIL INJECTOR, POE-LABELED FOR HYBRID & ELECTRIC VEHICLESPart# ROB-18470C$ 257.71
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 16 | PG18 - SYRINGE-TYPE R1234YF OIL INJECTOR, PAG-LABELED FOR LOW VOLTAGE SYSTEMS IN GAS & DIESEL VEHICLES | robinair | 257.71 | CAT3912XZ |
Robinair
PG18 - SYRINGE-TYPE R1234YF OIL INJECTOR, PAG-LABELED FOR LOW VOLTAGE SYSTEMS IN GAS & DIESEL VEHICLESPart# ROB-18465C$ 257.71
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 17 | PG18 - SYRINGE-TYPE R1234YF OIL INJECTOR, UNLABELED | robinair | 257.71 | CAT3912XZ |
C$ 257.71
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No |