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=4775 and pa.subcategory_id=5000 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 | |
|---|---|---|---|---|---|---|---|---|---|---|
| BLOCK HEAT EXT CORD 2M 16/3 | maktig | 12.66 | CAT5000XZ |
C$ 12.66
In Stock
| Yes | No | ||||
| 1 | BLOCK HEAT EXT CORD 3M 16/3 | maktig | 15.92 | CAT5000XZ |
C$ 15.92
In Stock
| Yes | No | |||
| 2 | BLOCK HEAT EXT CORD 5M 16/3 | maktig | 22.69 | CAT5000XZ |
C$ 22.69
In Stock
| Yes | No | |||
| 3 | EXTENSION CORD LIGHT 25FT SJTOW 16/3 | maktig | 32.51 | CAT5000XZ |
C$ 32.51
In Stock
| Yes | No | |||
| 4 | EXTENSION CORD LIGHT 25FT SJTOW 14/3 | maktig | 45.6 | CAT5000XZ |
C$ 45.60
In Stock
| Yes | No | |||
| 5 | EXTENSION CORD LIGHT 100FT SJTOW 14/3 | maktig | 143.78 | CAT5000XZ |
C$ 143.78
In Stock
| Yes | No | |||
| 6 | EXTENSION CORD LIGHT 25FT SJTOW 12/3 | maktig | 63.06 | CAT5000XZ |
C$ 63.06
In Stock
| Yes | No | |||
| 7 | EXTENSION CORD LIGHT 100FT SJTOW 12/3 | maktig | 200.51 | CAT5000XZ |
C$ 200.51
In Stock
| Yes | No | |||
| 8 | EXTENSION CORD LIGHT 50F TRIPLE TAP 14/3 | maktig | 69.6 | CAT5000XZ |
C$ 69.60
In Stock
| Yes | No | |||
| 9 | EXTENSION CORD LIGHT 100F TRIPLE TAP 14/3 | maktig | 143.78 | CAT5000XZ |
C$ 143.78
In Stock
| Yes | No | |||
| 10 | EXTENSION CORD LIGHT 25FT TRIPLE TAP 12/3 | maktig | 65.23 | CAT5000XZ |
C$ 65.23
In Stock
| Yes | No | |||
| 11 | EXTENSION CORD LIGHT 100FT SJEOW BLUE 14/3 | maktig | 143.78 | CAT5000XZ |
C$ 143.78
In Stock
| Yes | No | |||
| 12 | 3-In-1 Power Cord Set, 15', Black | grote | 332.4 | CAT5000XZ |
C$ 332.40
Limited Stock
| Yes | No | |||
| 13 | 3-In-1 Power Cord Set, 12', Red & Blue | grote | 312 | CAT5000XZ |
C$ 312.00
Limited Stock
| Yes | No | |||
| 14 | EXTENSION CORD LIGHT 100FT SJEOW BLUE 16/3 | maktig | 108.88 | CAT5000XZ |
C$ 108.88
Limited Stock
| Yes | No | |||
| 15 | 12V EXTENSION CORD (10') | ilink | 6.91 | CAT5000XZ |
C$ 6.91
| No | No | |||
| 16 | EXTENSION CORD LIGHT 50FT SJTOW 16/3 | maktig | 58.69 | CAT5000XZ |
C$ 58.69
| No | No | |||
| 17 | EXTENSION CORD LIGHT 50FT SJTOW 14/3 | maktig | 80.51 | CAT5000XZ |
C$ 80.51
| No | No | |||
| 18 | EXTENSION CORD LIGHT 50FT SJTOW 12/3 | maktig | 108.88 | CAT5000XZ |
C$ 108.88
| No | No | |||
| 19 | Tri-Tap Extension Cord | dynaline | 23.26 | CAT5000XZ |
C$ 23.26
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 20 | Rv Power Cord, 10Ft., 4/14 Gauge W 12" Leads | grote | 68.4 | CAT5000XZ |
C$ 68.40
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 21 | Rv Power Cord, 12Ft., 4/14 Gauge W 12" Leads | grote | 74.64 | CAT5000XZ |
C$ 74.64
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 22 | 3-In-1 Power Cord Set, 12', Black | grote | 306 | CAT5000XZ |
C$ 306.00
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 23 | 3-In-1 Power Cord Set, 15', Red & Blue | grote | 345.7 | CAT5000XZ |
C$ 345.70
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 24 | Emergency Lighting, Cigarette Lighter Power Cord | grote | 62.4 | CAT5000XZ |
C$ 62.40
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 25 | EXTENSION CORD LIGHT 50FT TRIPLE TAP 12/3 | maktig | 119.78 | CAT5000XZ |
C$ 119.78
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No |