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=4147 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 | |
|---|---|---|---|---|---|---|---|---|---|---|
| PG399 - 600 LUMENS SCOUT SWIVEL HEAD RECHARGEABLE POCKET FLASHLIGHT | maxxeon | 43.64 | CAT4147XZ |
C$ 43.64
In Stock
| Yes | No | ||||
| 1 | PG401 - 1200 LUMENS SEARCHPOINT RECHARGEABLE FLASHLIGHT WITH LIGHT DIFFUSER, WHITE, GREEN, RED & FLASHING MODES | maxxeon | 146.04 | CAT4147XZ |
Maxxeon
PG401 - 1200 LUMENS SEARCHPOINT RECHARGEABLE FLASHLIGHT WITH LIGHT DIFFUSER, WHITE, GREEN, RED & FLASHING MODESPart# MXN-04010C$ 146.04
In Stock
| Yes | No | |||
| 2 | PG401 - PROTAC 90 X 1,000 LUMENS USB-RECHARGEABLE RIGHT ANGLE MULTI-FUEL TACTICAL FLASHLIGHT | streamlight | 123.53 | CAT4147XZ |
STREAMLIGHT
PG401 - PROTAC 90 X 1,000 LUMENS USB-RECHARGEABLE RIGHT ANGLE MULTI-FUEL TACTICAL FLASHLIGHTPart# STM-88095C$ 123.53
In Stock
| Yes | No | |||
| 3 | PG401 - 5" PROTAC 2L-X USB | streamlight | 112.81 | CAT4147XZ |
C$ 112.81
In Stock
| Yes | No | |||
| 4 | PG401 - PROTAC HL5-X USB | streamlight | 194.63 | CAT4147XZ |
C$ 194.63
In Stock
| Yes | No | |||
| 5 | PG401 - PROTAC HPL USB RECHARGEABLE TACTICAL LIGHT, 1000/400/65 LUMENS, 120VAC/12VDC, HOLSTER | streamlight | 222.43 | CAT4147XZ |
STREAMLIGHT
PG401 - PROTAC HPL USB RECHARGEABLE TACTICAL LIGHT, 1000/400/65 LUMENS, 120VAC/12VDC, HOLSTERPart# STM-88078C$ 222.43
In Stock
| Yes | No | |||
| 6 | PG401 - STINGER 2020 RECHARGEABLE LED FLASHLIGHT, 2000/850/100 LUMENS, 120VAC/12VDC, 1 HOLDER | streamlight | 280.67 | CAT4147XZ |
STREAMLIGHT
PG401 - STINGER 2020 RECHARGEABLE LED FLASHLIGHT, 2000/850/100 LUMENS, 120VAC/12VDC, 1 HOLDERPart# STM-78101C$ 280.67
In Stock
| Yes | No | |||
| 7 | PG401 - STRION LED -120V/100V AC AC/DC - 1 HOLDER | streamlight | 210.91 | CAT4147XZ |
C$ 210.91
In Stock
| Yes | No | |||
| 8 | PG401 - 7" DUALIE INTRINSICALLY SAFE RECHARGEABLE MULTI-FUNCTION FLASHLIGHT W/ MAGNETIC CLIP, 275 LUMENS, AC CHARING BASE,BLACK | streamlight | 140.99 | CAT4147XZ | Yes | No | ||||
| 9 | PG401 - 7" DUALIE INTRINSICALLY SAFE RECHARGEABLE MULTI-FUNCTION FLASHLIGHT W/ MAGNETIC CLIP, 275 LUMENS, AC CHARING BASE, YELLOW | streamlight | 140.99 | CAT4147XZ | Yes | No | ||||
| 10 | PG401 - (MODEL #DC1) 12V DC CIGARETTE LIGHTER CHARGE CORD, FITS MOST STREAMLIGHT RECHARGEABLE BASES, HOLDERS AND SLEEVES | streamlight | 18.85 | CAT4147XZ | Yes | No | ||||
| 11 | PG401 - 750 MAX LUMEN RECHARGEABLE LED TORCH LIGHT | solar-clore-automotive | 85.58 | CAT4147XZ |
C$ 85.58
In Stock
| Yes | No | |||
| 12 | PG401 - 400 MAX LUMEN RECHARGEABLE LED WORK/TORCH LIGHT | solar-clore-automotive | 66.86 | CAT4147XZ |
C$ 66.86
In Stock
| Yes | No | |||
| 13 | PG400 - USB RECHARGEABLE PIVOTING FLASHLIGHT, 500 LUMENS, INCL. BATTERY & USB CORD | milwaukee-electric | 112.18 | CAT4147XZ |
Milwaukee Electric
PG400 - USB RECHARGEABLE PIVOTING FLASHLIGHT, 500 LUMENS, INCL. BATTERY & USB CORDPart# MLW-2113-21C$ 112.18
In Stock
| Yes | No | |||
| 14 | PG400 - 1200/100 LUMENS RECHARGEABLE COB LED FLASHLIGHT, FLOOD & SPOT FUNCTIONS | ez-red | 96.65 | CAT4147XZ |
EZ Red
PG400 - 1200/100 LUMENS RECHARGEABLE COB LED FLASHLIGHT, FLOOD & SPOT FUNCTIONSPart# EZR-CT6315C$ 96.65
In Stock
| Yes | No | |||
| 15 | PG400 - 550 LUMENS RECHARGEABLE FOCUSING TACTICAL LIGHT | ez-red | 60.36 | CAT4147XZ |
C$ 60.36
In Stock
| Yes | No | |||
| 16 | PG400 - 420 LUMEN RECHARGEABLE FOCUS BEAM TACTICAL LED FLASHLIGHT | ez-red | 54.31 | CAT4147XZ |
C$ 54.31
In Stock
| Yes | No | |||
| 17 | PG400 - 200 LUMENS DIMMABLE RECHARGEABLE FOCUSING TACTICAL FLASHLIGHT | ez-red | 48.35 | CAT4147XZ |
C$ 48.35
In Stock
| Yes | No | |||
| 18 | PG400 - 900 LUMENS USB RECHARGEABLE DUAL-LIGHT TACTICAL FLASHLIGHT, BLACK BODY | bayco | 218.11 | CAT4147XZ |
Bayco
PG400 - 900 LUMENS USB RECHARGEABLE DUAL-LIGHT TACTICAL FLASHLIGHT, BLACK BODYPart# BAY-USB-578XLC$ 218.11
In Stock
| Yes | No | |||
| 19 | PG399 - 600 LUMENS SCOUT SWIVEL HEAD RECHARGEABLE POCKET FLASHLIGHT | maxxeon | 43.64 | CAT4147XZ |
C$ 43.64
In Stock
| Yes | No | |||
| 20 | PG401 - 1200 LUMENS SEARCHPOINT RECHARGEABLE FLASHLIGHT WITH LIGHT DIFFUSER, WHITE, GREEN, RED & FLASHING MODES | maxxeon | 146.04 | CAT4147XZ |
Maxxeon
PG401 - 1200 LUMENS SEARCHPOINT RECHARGEABLE FLASHLIGHT WITH LIGHT DIFFUSER, WHITE, GREEN, RED & FLASHING MODESPart# MXN-04010C$ 146.04
In Stock
| Yes | No | |||
| 21 | PG401 - PROTAC 90 X 1,000 LUMENS USB-RECHARGEABLE RIGHT ANGLE MULTI-FUEL TACTICAL FLASHLIGHT | streamlight | 123.53 | CAT4147XZ |
STREAMLIGHT
PG401 - PROTAC 90 X 1,000 LUMENS USB-RECHARGEABLE RIGHT ANGLE MULTI-FUEL TACTICAL FLASHLIGHTPart# STM-88095C$ 123.53
In Stock
| Yes | No | |||
| 22 | PG401 - STINGER LED - 120V/100V AC/12V DC SMART CHARGE - 2 HOLDERS | streamlight | 233.59 | CAT4147XZ |
C$ 233.59
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 23 | PG400 - 700/1000 LUMENS RECHARGEABLE FLOOD AND SPOT LIGHT | ez-red | 72.46 | CAT4147XZ |
C$ 72.46
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 24 | PG400 - 900 LUMENS USB RECHARGEABLE DUAL-LIGHT TACTICAL FLASHLIGHT WITH HOLSTER, RED/BLACK BODY | bayco | 156.2 | CAT4147XZ |
Bayco
PG400 - 900 LUMENS USB RECHARGEABLE DUAL-LIGHT TACTICAL FLASHLIGHT WITH HOLSTER, RED/BLACK BODYPart# BAY-USB-578XL-RC$ 156.20
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No |