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=4544 and pa.subcategory_id=4717 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 | |
|---|---|---|---|---|---|---|---|---|---|---|
| GEASE GUN HOSE 12IN | maktig | 13.2 | CAT4717XZ |
C$ 13.20
In Stock
| Yes | No | ||||
| 1 | GREASE GUN HOSE 18IN | maktig | 16.8 | CAT4717XZ |
C$ 16.80
In Stock
| Yes | No | |||
| 2 | PROF.4JAW GUN COUPLER | maktig | 7.5 | CAT4717XZ |
C$ 7.50
In Stock
| Yes | No | |||
| 3 | 4JAW GREASE GUN COUPLER | maktig | 10.8 | CAT4717XZ |
C$ 10.80
In Stock
| Yes | No | |||
| 4 | GREASE COUPLER 7500PSI | maktig | 17.7 | CAT4717XZ |
C$ 17.70
In Stock
| Yes | No | |||
| 5 | RIGHT ANGLE GREASE GUN COUP | maktig | 19.5 | CAT4717XZ |
C$ 19.50
In Stock
| Yes | No | |||
| 6 | DISTRIBUTR BEC EFFILE11/2 | maktig | 17.7 | CAT4717XZ |
C$ 17.70
In Stock
| Yes | No | |||
| 7 | 90 DEGREES ANGLE LUBE ADAPT | maktig | 34.5 | CAT4717XZ |
C$ 34.50
In Stock
| Yes | No | |||
| 8 | RECESSED LUBE ADAPTOR | maktig | 34.5 | CAT4717XZ |
C$ 34.50
In Stock
| Yes | No | |||
| 9 | NARROW NEEDLE NOSE ADAPTOR | maktig | 29.1 | CAT4717XZ |
C$ 29.10
In Stock
| Yes | No | |||
| 10 | GREASE INJECTOR NEEDLE 18G | maktig | 11.1 | CAT4717XZ |
C$ 11.10
In Stock
| Yes | No | |||
| 11 | H/PRES. Q/C GREASE COUPLER | maktig | 80.7 | CAT4717XZ |
C$ 80.70
In Stock
| Yes | No | |||
| 12 | GREASE GUN HOSE 12IN | maktig | 21.6 | CAT4717XZ |
C$ 21.60
Limited Stock
| Yes | No | |||
| 13 | GREASE GUN HOSE 18IN | maktig | 24.3 | CAT4717XZ |
C$ 24.30
Limited Stock
| Yes | No | |||
| 14 | NARROW NEEDLE NOSE DISP.6IN | maktig | 34.5 | CAT4717XZ |
C$ 34.50
Limited Stock
| Yes | No | |||
| 15 | Needle Nose Dispenser | jet | 24.83 | CAT4717XZ |
C$ 24.83
| No | No | |||
| 16 | NEEDLE NOSE ADAPTOR 4IN | maktig | 31.2 | CAT4717XZ |
C$ 31.20
| No | No | |||
| 17 | Grease Gun Holder | jet | 24.83 | CAT4717XZ |
C$ 24.83
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 18 | Grease Injector Needle | jet | 16.56 | CAT4717XZ |
C$ 16.56
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 19 | Quick Change Recessed Adaptor | jet | 58.16 | CAT4717XZ |
C$ 58.16
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 20 | Quick Change Needle Nose Adaptor | jet | 58.16 | CAT4717XZ |
C$ 58.16
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 21 | 7 PC Quick Change Coupler Set | jet | 265.99 | CAT4717XZ |
C$ 265.99
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 22 | Button Head Grease Coupler for 5/8" Fittings - Heavy Duty | jet | 43.16 | CAT4717XZ |
C$ 43.16
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 23 | Button Head Grease Coupler for 7/8" Fittings - Heavy Duty | jet | 57.06 | CAT4717XZ |
C$ 57.06
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 24 | 1/4" - 28" Straight Fittings | jet | 16.86 | CAT4717XZ |
C$ 16.86
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 25 | 1/4" - 28" 45 Fittings | jet | 27.46 | CAT4717XZ |
C$ 27.46
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 26 | 1/4" - 28" 90 Fittings | jet | 27.46 | CAT4717XZ |
C$ 27.46
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 27 | 1/8" - 27" Straight Fittings | jet | 23.27 | CAT4717XZ |
C$ 23.27
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 28 | 1/8" - 27" 45 Fittings | jet | 31.68 | CAT4717XZ |
C$ 31.68
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 29 | 1/8" - 27" 90 Fittings | jet | 31.68 | CAT4717XZ |
C$ 31.68
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 30 | 8 Piece SAE Fittings Set | jet | 21.13 | CAT4717XZ |
C$ 21.13
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 31 | 8 Piece Metric Fittings Set | jet | 21.13 | CAT4717XZ |
C$ 21.13
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 32 | 80 PC SAE Fitting Set | jet | 174.55 | CAT4717XZ |
C$ 174.55
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 33 | 80 PC Metric Fitting Set | jet | 174.55 | CAT4717XZ |
C$ 174.55
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 34 | 1/4" 4 Way Fitting Tool | jet | 52.92 | CAT4717XZ |
C$ 52.92
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 35 | 1/8" 4 Way Fitting Tool | jet | 59.23 | CAT4717XZ |
C$ 59.23
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 36 | 101 PC SAE Grease Fitting and Tool Set Heavy Duty | jet | 323.22 | CAT4717XZ |
C$ 323.22
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 37 | Grease Fitting Unblocker | jet | 216.13 | CAT4717XZ |
C$ 216.13
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 38 | Grease Control Valve | jet | 282.67 | CAT4717XZ |
C$ 282.67
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 39 | Booster Grease Control Valve | jet | 315.91 | CAT4717XZ |
C$ 315.91
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 40 | 360 Swivel | jet | 197.82 | CAT4717XZ |
C$ 197.82
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No |