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=4144 and pa.subcategory_id=4152 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 | |
---|---|---|---|---|---|---|---|---|---|---|
PG397 - UNDERHOOD LITHIUM LIGHT | schumacher | 219.5 | CAT4152XZ |
C$ 219.50
In Stock
| Yes | No | ||||
1 | PG397 - MAXXBAR HOOD & INTERIOR WORK LIGHT PLATFORM, EXTENDS FROM 47" TO 78" | maxxeon | 106.73 | CAT4152XZ |
Maxxeon
PG397 - MAXXBAR HOOD & INTERIOR WORK LIGHT PLATFORM, EXTENDS FROM 47" TO 78"Part# MXN-10183C$ 106.73
In Stock
| Yes | No | |||
2 | PG397 - M12 12V RECHARGEABLE UNDERHOOD LED LIGHT KIT, 1350/600 LUMENS, (1) 12V XC.4.0 BATTERY, (1) 12V CHARGER | milwaukee-electric | 391.22 | CAT4152XZ |
Milwaukee Electric
PG397 - M12 12V RECHARGEABLE UNDERHOOD LED LIGHT KIT, 1350/600 LUMENS, (1) 12V XC.4.0 BATTERY, (1) 12V CHARGERPart# MLW-2125-21XC$ 391.22
In Stock
| Yes | No | |||
3 | PG397 - M12 RECHARGEABLE UNDERHOOD LED LIGHT (BARE TOOL), 1350/600 LUMENS | milwaukee-electric | 273.41 | CAT4152XZ |
Milwaukee Electric
PG397 - M12 RECHARGEABLE UNDERHOOD LED LIGHT (BARE TOOL), 1350/600 LUMENSPart# MLW-2125-20C$ 273.41
In Stock
| Yes | No | |||
4 | PG397 - LED RECHARGEABLE UNDER HOOD WORKLIGHT | bayco | 208.28 | CAT4152XZ |
C$ 208.28
In Stock
| Yes | No | |||
5 | PG397 - 2000 LUMEN LED 2-IN-1 UNDERHOOD LIGHT | atd | 295.73 | CAT4152XZ |
C$ 295.73
In Stock
| Yes | No | |||
6 | PG397 - 30W UNDERHOOD LIGHT | atd | 219.79 | CAT4152XZ |
C$ 219.79
In Stock
| Yes | No | |||
7 | PG397 - 1510 LUMENS SLIM ALUMINUM RECHARGEABLE UNDERHOOD LIGHT | astro-pneumatics | 173.68 | CAT4152XZ |
C$ 173.68
In Stock
| Yes | No | |||
8 | 1540 LUMEN RECHARGEABLE UNDERHOOD LIGHT WITH DETACHEABLE HANDHELD LIGHT | astro-pneumatics | 185.1 | CAT4152XZ |
Astro Pneumatics
1540 LUMEN RECHARGEABLE UNDERHOOD LIGHT WITH DETACHEABLE HANDHELD LIGHTPart# AST-150SLC$ 185.10
In Stock
| Yes | No | |||
9 | PG397 - RECHARGEABLE UNDERHOOD LIGHT, 2400/1200 LUMENS, EXTENDS TO 78", USB POWER BANK, MAGNETIC BASE | alert | 189.41 | CAT4152XZ |
Alert
PG397 - RECHARGEABLE UNDERHOOD LIGHT, 2400/1200 LUMENS, EXTENDS TO 78", USB POWER BANK, MAGNETIC BASEPart# ALT-LHR5200C$ 189.41
In Stock
| Yes | No |