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=4133 and pa.subcategory_id=4178 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 | |
|---|---|---|---|---|---|---|---|---|---|---|
| PG247 - 5:1 OIL PUMP KIT WITH CART, 50 FT. HOSE REEL & DIGITAL OIL NOZZLE, 205L CAPACITY, 40L/MIN (10.5 GPM) | turbo-xl | 1868.69 | CAT4178XZ |
Turbo XL
PG247 - 5:1 OIL PUMP KIT WITH CART, 50 FT. HOSE REEL & DIGITAL OIL NOZZLE, 205L CAPACITY, 40L/MIN (10.5 GPM)Part# TXL-PU05205KDR-HDC$ 1,868.69
In Stock
| Yes | No | ||||
| 1 | PG247 - 5:1 OIL PUMP KIT WITH CART, 25 FT. HOSE & DIGITAL OIL NOZZLE, 205L CAPACITY, 40L/MIN (10.5 GPM) | turbo-xl | 1382.26 | CAT4178XZ |
Turbo XL
PG247 - 5:1 OIL PUMP KIT WITH CART, 25 FT. HOSE & DIGITAL OIL NOZZLE, 205L CAPACITY, 40L/MIN (10.5 GPM)Part# TXL-PU05205KD-HDC$ 1,382.26
In Stock
| Yes | No | |||
| 2 | PG247 - 5:1 OIL PUMP, 37" LONG, 205L CAPACITY, 14L/MIN (3.6 GPM) | turbo-xl | 585.17 | CAT4178XZ |
C$ 585.17
In Stock
| Yes | No | |||
| 3 | PG247 - 5:1 OIL PUMP KIT WITH CART, 25 FT. HOSE, DRUM COVER & DIGITAL OIL NOZZLE, 60L CAPACITY, 40L/MIN (10.5 GPM) | turbo-xl | 1259.38 | CAT4178XZ |
Turbo XL
PG247 - 5:1 OIL PUMP KIT WITH CART, 25 FT. HOSE, DRUM COVER & DIGITAL OIL NOZZLE, 60L CAPACITY, 40L/MIN (10.5 GPM)Part# TXL-PU05060KC$ 1,259.38
In Stock
| Yes | No | |||
| 4 | PG247 - LEVER ACTION BUCKET PUMP | otc-tools | 97.78 | CAT4178XZ |
C$ 97.78
In Stock
| Yes | No | |||
| 5 | BOP20 18V BATTERY OPERATED 1 GPM PUMP STEM FOR OILS UP TO 90W/ISO220, FITS 5-GAL DRUMS | 315.59 | CAT4178XZ |
BOP20 18V BATTERY OPERATED 1 GPM PUMP STEM FOR OILS UP TO 90W/ISO220, FITS 5-GAL DRUMSPart# MCN-BP20X-OLC$ 315.59
In Stock
| Yes | No | ||||
| 6 | BOP20 18V BATTERY OPERATED 1 GPM PUMP KIT FOR OILS UP TO 90W/ISO220, FITS 5-GAL DRUMS, (1) BATTERY, (1) CHARGER | 479.65 | CAT4178XZ |
BOP20 18V BATTERY OPERATED 1 GPM PUMP KIT FOR OILS UP TO 90W/ISO220, FITS 5-GAL DRUMS, (1) BATTERY, (1) CHARGERPart# MCN-BP20S-OLC$ 479.65
In Stock
| Yes | No | ||||
| 7 | PG247 - LEVER ACTION BUCKET PUMP, FOR 5 GALLON BUCKETS | lumax | 62.38 | CAT4178XZ |
C$ 62.38
In Stock
| Yes | No | |||
| 8 | PG247 - 3.5:1 OIL PUMP (250-275 GAL) | lincoln-industrial | 787.82 | CAT4178XZ |
C$ 787.82
In Stock
| Yes | No | |||
| 9 | PG247 - PERFORMANCE 3:1 PISTON TYPE OIL PUMP | legacy-manufacturing-flexzilla | 824.63 | CAT4178XZ |
C$ 824.63
In Stock
| Yes | No | |||
| 10 | PG247 - LEVER ACTION DISPENSER | atd | 89.93 | CAT4178XZ |
C$ 89.93
In Stock
| Yes | No | |||
| 11 | PG247 - TROLLEY MOUNTED 3:1 AIR-OPERATED OIL PUMP KIT, DESIGNED FOR 55 GALLON DRUMS (DRUM NOT INCLUDED) | atd | 2336.59 | CAT4178XZ |
ATD
PG247 - TROLLEY MOUNTED 3:1 AIR-OPERATED OIL PUMP KIT, DESIGNED FOR 55 GALLON DRUMS (DRUM NOT INCLUDED)Part# ATD-5226C$ 2,336.59
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 12 | PG247 - 5:1 HIGH FLOW OIL PUMP, 29" LONG, 60L CAPACITY, 40L/MIN (10.5 GPM) | turbo-xl | 989.42 | CAT4178XZ |
Turbo XL
PG247 - 5:1 HIGH FLOW OIL PUMP, 29" LONG, 60L CAPACITY, 40L/MIN (10.5 GPM)Part# TXL-PU05060HC$ 989.42
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 13 | PG247 - 5:1 OIL PUMP, 29" LONG, 60L CAPACITY, 14L/MIN (3.6 GPM) | turbo-xl | 582.19 | CAT4178XZ |
C$ 582.19
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 14 | PG247 - OIL TROLLEY KIT | lincoln-industrial | 3105.02 | CAT4178XZ |
C$ 3,105.02
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No |