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=4716 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 | |
|---|---|---|---|---|---|---|---|---|---|---|
| ANTI SPLASH FUNNEL 2PC | ilink | 4.38 | CAT4716XZ |
C$ 4.38
In Stock
| Yes | No | ||||
| 1 | SUPER MULTI-PURPOSE FUNNEL | mallory | 6.1 | CAT4716XZ |
C$ 6.10
In Stock
| Yes | No | |||
| 2 | BIG MOUTH FUNNEL CUT CASE | mallory | 1.57 | CAT4716XZ |
C$ 1.57
In Stock
| Yes | No | |||
| 3 | TIGHT SPOT FUNNEL | mallory | 6.52 | CAT4716XZ |
C$ 6.52
In Stock
| Yes | No | |||
| 4 | QUICKFILL FUNNEL CUT CASE | mallory | 4.22 | CAT4716XZ |
C$ 4.22
In Stock
| Yes | No | |||
| 5 | LARGE FUEL FILTER FUNNEL | mallory | 82.62 | CAT4716XZ |
C$ 82.62
In Stock
| Yes | No | |||
| 6 | MULTI-PURPOSE FUNNEL | mallory | 3.32 | CAT4716XZ |
C$ 3.32
Limited Stock
| Yes | No | |||
| 7 | MEDIUM FUEL FILTER FUNNEL | mallory | 52.62 | CAT4716XZ |
C$ 52.62
Limited Stock
| Yes | No | |||
| 8 | ANTI SPLASH FUNNEL 4 | ilink | 2.11 | CAT4716XZ |
C$ 2.11
| No | No | |||
| 9 | ANTI SPLASH FUNNEL 6 | ilink | 2.54 | CAT4716XZ |
C$ 2.54
| No | No | |||
| 10 | FLEX FUNNEL CUT CASE | mallory | 5.7 | CAT4716XZ |
C$ 5.70
| No | No | |||
| 11 | LARGE FUNNEL 2 QT (BLACK) | mallory | 2.58 | CAT4716XZ |
C$ 2.58
| No | No | |||
| 12 | FUNNEL SET 3 SMALL MED&LRG | mallory | 5.94 | CAT4716XZ |
C$ 5.94
| No | No | |||
| 13 | TRANSMISSION FUNNEL | mallory | 3.8 | CAT4716XZ |
C$ 3.80
| No | No | |||
| 14 | QUICKFILL FUNNEL CUT CASE | mallory | 13.26 | CAT4716XZ |
C$ 13.26
| No | No | |||
| 15 | 9.4 LITRE OIL DRAIN CONTAINER | mallory | 26.18 | CAT4716XZ |
C$ 26.18
| No | No | |||
| 16 | 15 LITRE OIL DRAIN CONTAINER | mallory | 35.51 | CAT4716XZ |
C$ 35.51
| No | No | |||
| 17 | SMALL FUNNEL1/2 PINT(GRAY) | mallory | 1.01 | CAT4716XZ |
C$ 1.01
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 18 | MED FUNNEL1 PINT(CHARCOAL) | mallory | 1.57 | CAT4716XZ |
C$ 1.57
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 19 | EXTRA LRG FUNNEL CUT CASE | mallory | 3.04 | CAT4716XZ |
C$ 3.04
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 20 | SUPER QUICK FILL FUNNEL | mallory | 4.26 | CAT4716XZ |
C$ 4.26
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 21 | LESS MESS DRAIN PAN | mallory | 18.26 | CAT4716XZ |
C$ 18.26
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 22 | TRANS FLUID/GEAR OIL SPOUT | mallory | 8.28 | CAT4716XZ |
C$ 8.28
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 23 | SUPER FLEXI-SPOUT | mallory | 2.56 | CAT4716XZ |
C$ 2.56
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 24 | RADIATOR FUNNEL | mallory | 1.62 | CAT4716XZ |
C$ 1.62
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 25 | MEASU FUNNEL | mallory | 12.3 | CAT4716XZ |
C$ 12.30
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 26 | LOCKING OIL FUNNEL | mallory | 3.78 | CAT4716XZ |
C$ 3.78
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 27 | MULTI-TASK 5-IN-1 FUNNEL | mallory | 10.49 | CAT4716XZ |
C$ 10.49
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 28 | GAS GAUGE FUNNEL | mallory | 7.74 | CAT4716XZ |
C$ 7.74
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 29 | 3 PIECE FUNNEL SET | mallory | 12.41 | CAT4716XZ |
C$ 12.41
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 30 | CAPLESS GAS TANK FUNNEL | mallory | 2.4 | CAT4716XZ |
C$ 2.40
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 31 | 22.7 LITRE OIL DRAIN CONTAINER | mallory | 71.62 | CAT4716XZ |
C$ 71.62
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 32 | 54.8 LITRE OIL DRAIN CONTAINER | mallory | 223.12 | CAT4716XZ |
C$ 223.12
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 33 | SMALL FUEL FILTER FUNNEL | mallory | 32.74 | CAT4716XZ |
C$ 32.74
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 34 | SMALL NON CONDUCTIVE FUEL FILTER FUNNEL | mallory | 22.55 | CAT4716XZ |
C$ 22.55
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 35 | MEDIUM NON CONDUCTIVE FUEL FILTER FUNNEL | mallory | 33 | CAT4716XZ |
C$ 33.00
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No |