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=4151 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 | |
|---|---|---|---|---|---|---|---|---|---|---|
| PG403 - BANDIT PRO BLACK | streamlight | 44.95 | CAT4151XZ |
C$ 44.95
In Stock
| Yes | No | ||||
| 1 | PG403 - BANDIT PRO YELLOW | streamlight | 44.95 | CAT4151XZ |
C$ 44.95
In Stock
| Yes | No | |||
| 2 | PG403 - BANDIT -INCLUDES HEADSTRAP AND USB CORD - YELLOW | streamlight | 41.09 | CAT4151XZ |
C$ 41.09
In Stock
| Yes | No | |||
| 3 | PG403 - QB ULTRA-COMPACT HEADLAMP, USB RECHARGEABLE, YELLOW, 200 LUMENS | streamlight | 44.95 | CAT4151XZ |
C$ 44.95
In Stock
| Yes | No | |||
| 4 | PG403 - ARGO DIV. 2 HEADLAMP WITH ALKALINE BATTERIES - YELLOW | streamlight | 57.55 | CAT4151XZ |
C$ 57.55
In Stock
| Yes | No | |||
| 5 | PG403 - SEPTOR DIV. 2 HEADLAMP WITH ALKALINE BATTERIES - YELLOW | streamlight | 58.73 | CAT4151XZ |
C$ 58.73
In Stock
| Yes | No | |||
| 6 | PG403 - TWIN-TASK USB HEADLAMP - BLACK/RED | streamlight | 112.81 | CAT4151XZ |
C$ 112.81
In Stock
| Yes | No | |||
| 7 | PG404 - SLIM PROFILE RECHARG. 250 LM MOTION ACTIVATED LED HEADLAMP | steelman | 61.62 | CAT4151XZ |
C$ 61.62
In Stock
| Yes | No | |||
| 8 | PG404 - 250LM VERSA ACTION LIGHT | solar-clore-automotive | 54.58 | CAT4151XZ |
C$ 54.58
In Stock
| Yes | No | |||
| 9 | PG404 - WORKSTAR 500 DROID TECHNICIANS RECHARGEABLE MINI HEADLAMP, 400/160 LUMENS | maxxeon | 44.99 | CAT4151XZ |
Maxxeon
PG404 - WORKSTAR 500 DROID TECHNICIANS RECHARGEABLE MINI HEADLAMP, 400/160 LUMENSPart# MXN-00500C$ 44.99
In Stock
| Yes | No | |||
| 10 | PG403 - USB RECHARGEABLE LOW-PROFILE HEADLAMP KIT, 600 LUMENS, INCL. HARDHAD CLIPS, BATTERY & USB CORD | milwaukee-electric | 101.98 | CAT4151XZ |
Milwaukee Electric
PG403 - USB RECHARGEABLE LOW-PROFILE HEADLAMP KIT, 600 LUMENS, INCL. HARDHAD CLIPS, BATTERY & USB CORDPart# MLW-2115-21C$ 101.98
In Stock
| Yes | No | |||
| 11 | PG403 - 800/400 LUMENS RECHARGEABLE FOCUSING LED HEADLAMP | ez-red | 84.55 | CAT4151XZ |
C$ 84.55
In Stock
| Yes | No | |||
| 12 | PG403 - 380 LUMEN RECHARGEABLE FOCUSING HEADLAMP | ez-red | 84.55 | CAT4151XZ |
C$ 84.55
In Stock
| Yes | No | |||
| 13 | PG403 - 220 LUMEN FOCUS BEAM HEADLAMP | ez-red | 42.3 | CAT4151XZ |
C$ 42.30
In Stock
| Yes | No | |||
| 14 | PG404 - DUAL LIGHT LED HEADLAMP - NON-RECHARGEABLE - BLACK - BAY-NSP-4604B | bayco | 36.42 | CAT4151XZ |
C$ 36.42
In Stock
| Yes | No | |||
| 15 | PG404 - DUAL LIGHT LED HEADLAMP - NON-RECHARGEABLE - BLACK - BAY-NSP-4602B | bayco | 25.75 | CAT4151XZ |
C$ 25.75
In Stock
| Yes | No | |||
| 16 | PG404 - 200 LUMENS COB LED USB-C RECHARGEABLE MOTION ACTIVATED HEADLAMP | atd | 56.5 | CAT4151XZ |
C$ 56.50
In Stock
| Yes | No | |||
| 17 | PG403 - REDLITHIUM USB RECHARGEABLE HARD HAT HEAD LAMP, 600 LUMENS | milwaukee-electric | 101.98 | CAT4151XZ |
Milwaukee Electric
PG403 - REDLITHIUM USB RECHARGEABLE HARD HAT HEAD LAMP, 600 LUMENSPart# MLW-2163-21C$ 101.98
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No |