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=4150 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 - 300/1000 LUMENS WEDGE COMPACT, RECHARGEABLE, HIGH-PERFORMANCE EDC FLASHLIGHT COYOTE | streamlight | 161.15 | CAT4150XZ |
STREAMLIGHT
PG399 - 300/1000 LUMENS WEDGE COMPACT, RECHARGEABLE, HIGH-PERFORMANCE EDC FLASHLIGHT COYOTEPart# STM-88811C$ 161.15
In Stock
| Yes | No | ||||
| 1 | PG399 - 300/1000 LUMENS WEDGE COMPACT, RECHARGEABLE, HIGH-PERFORMANCE EDC FLASHLIGHT BLACK | streamlight | 161.15 | CAT4150XZ |
STREAMLIGHT
PG399 - 300/1000 LUMENS WEDGE COMPACT, RECHARGEABLE, HIGH-PERFORMANCE EDC FLASHLIGHT BLACKPart# STM-88810C$ 161.15
In Stock
| Yes | No | |||
| 2 | PG399 - PROTAC HL USB - BLACK | streamlight | 200.11 | CAT4150XZ |
C$ 200.11
In Stock
| Yes | No | |||
| 3 | PG399 - PROTAC 2AAA W/2 "AAA" ALKALINE BATTERIES - BLACK | streamlight | 57.55 | CAT4150XZ |
C$ 57.55
In Stock
| Yes | No | |||
| 4 | PG399 - PROTAC 2AA W/ 2 "AA" ALKALINE BATTERIES AND HOLSTER - BLACK | streamlight | 80.69 | CAT4150XZ |
C$ 80.69
In Stock
| Yes | No | |||
| 5 | PG399 - POCKET MATE USB COMPACT HANDS-FREE LIGHT WITH KEY RING AND CLIP, 325 LUMENS, INCLUDES USB CORD PINK | streamlight | 38.39 | CAT4150XZ |
STREAMLIGHT
PG399 - POCKET MATE USB COMPACT HANDS-FREE LIGHT WITH KEY RING AND CLIP, 325 LUMENS, INCLUDES USB CORD PINKPart# STM-73303C$ 38.39
In Stock
| Yes | No | |||
| 6 | PG399 - POCKET MATE USB COMPACT HANDS-FREE LIGHT WITH KEY RING AND CLIP, 325 LUMENS, INCLUDES USB CORD BLUE | streamlight | 38.39 | CAT4150XZ |
STREAMLIGHT
PG399 - POCKET MATE USB COMPACT HANDS-FREE LIGHT WITH KEY RING AND CLIP, 325 LUMENS, INCLUDES USB CORD BLUEPart# STM-73302C$ 38.39
In Stock
| Yes | No | |||
| 7 | PG399 - POCKET MATE USB COMPACT HANDS-FREE LIGHT WITH KEY RING AND CLIP, 325 LUMENS, INCLUDES USB CORD RED | streamlight | 38.39 | CAT4150XZ |
STREAMLIGHT
PG399 - POCKET MATE USB COMPACT HANDS-FREE LIGHT WITH KEY RING AND CLIP, 325 LUMENS, INCLUDES USB CORD REDPart# STM-73301C$ 38.39
In Stock
| Yes | No | |||
| 8 | PG399 - POCKET MATE USB COMPACT HANDS-FREE LIGHT WITH KEY RING AND CLIP, 325 LUMENS, INCLUDES USB CORD SILVER | streamlight | 38.39 | CAT4150XZ |
STREAMLIGHT
PG399 - POCKET MATE USB COMPACT HANDS-FREE LIGHT WITH KEY RING AND CLIP, 325 LUMENS, INCLUDES USB CORD SILVERPart# STM-73300C$ 38.39
In Stock
| Yes | No | |||
| 9 | PG399 - STREAMLIGHT JR. LED - WITH ALKALINE BATTERIES - BLACK | streamlight | 63.49 | CAT4150XZ |
C$ 63.49
In Stock
| Yes | No | |||
| 10 | PG398 - STYLUS PRO COB WITH 19" USB CORD - BLUE | streamlight | 74.93 | CAT4150XZ |
C$ 74.93
In Stock
| Yes | No | |||
| 11 | PG398 - STYLUS PRO COB WITH 19" USB CORD - RED | streamlight | 74.93 | CAT4150XZ |
C$ 74.93
In Stock
| Yes | No | |||
| 12 | PG398 - STYLUS PRO COB WITH 19" USB CORD - BLACK | streamlight | 74.93 | CAT4150XZ |
C$ 74.93
In Stock
| Yes | No | |||
| 13 | PG398 - MICROSTREAM USB WITH 5" USB CORD AND LANYARD - BLUE | streamlight | 57.55 | CAT4150XZ |
C$ 57.55
In Stock
| Yes | No | |||
| 14 | PG398 - MICROSTREAM USB WITH 5" USB CORD AND LANYARD - RED | streamlight | 57.55 | CAT4150XZ |
C$ 57.55
In Stock
| Yes | No | |||
| 15 | PG398 - MICROSTREAM USB WITH 5" USB CORD AND LANYARD - BLACK | streamlight | 57.55 | CAT4150XZ |
C$ 57.55
In Stock
| Yes | No | |||
| 16 | PG399 - STYLUS PRO USB RECHARGEABLE UV PENLIGHT, USB CORD, HOLSTER | streamlight | 103.19 | CAT4150XZ |
C$ 103.19
In Stock
| Yes | No | |||
| 17 | PG399 - STYLUS PRO USB RECHARGEABLE UV PENLIGHT, 120V AC ADAPTER, USB CORD, HOLSTER | streamlight | 114.89 | CAT4150XZ |
STREAMLIGHT
PG399 - STYLUS PRO USB RECHARGEABLE UV PENLIGHT, 120V AC ADAPTER, USB CORD, HOLSTERPart# STM-66148C$ 114.89
In Stock
| Yes | No | |||
| 18 | PG398 - 6" LONG STYLUS PRO USB RECHARGEABLE PENLIGHT, 350/90 LUMENS, USB CHARGE CORD, ORANGE | streamlight | 93.91 | CAT4150XZ |
STREAMLIGHT
PG398 - 6" LONG STYLUS PRO USB RECHARGEABLE PENLIGHT, 350/90 LUMENS, USB CHARGE CORD, ORANGEPart# STM-66146C$ 93.91
In Stock
| Yes | No | |||
| 19 | PG398 - 6" LONG STYLUS PRO USB RECHARGEABLE PENLIGHT, 350/90 LUMENS, 120V AC/USB CHARGE CORD, GREEN | streamlight | 105.61 | CAT4150XZ |
STREAMLIGHT
PG398 - 6" LONG STYLUS PRO USB RECHARGEABLE PENLIGHT, 350/90 LUMENS, 120V AC/USB CHARGE CORD, GREENPart# STM-66145C$ 105.61
In Stock
| Yes | No | |||
| 20 | PG398 - 6" LONG STYLUS PRO USB RECHARGEABLE PENLIGHT, 350/90 LUMENS, USB CHARGE CORD, GREEN | streamlight | 93.91 | CAT4150XZ |
STREAMLIGHT
PG398 - 6" LONG STYLUS PRO USB RECHARGEABLE PENLIGHT, 350/90 LUMENS, USB CHARGE CORD, GREENPart# STM-66144C$ 93.91
In Stock
| Yes | No | |||
| 21 | PG398 - 6" LONG STYLUS PRO USB RECHARGEABLE PENLIGHT, 350/90 LUMENS, USB CHARGE CORD, BLUE | streamlight | 93.91 | CAT4150XZ |
STREAMLIGHT
PG398 - 6" LONG STYLUS PRO USB RECHARGEABLE PENLIGHT, 350/90 LUMENS, USB CHARGE CORD, BLUEPart# STM-66140C$ 93.91
In Stock
| Yes | No | |||
| 22 | PG398 - 6" LONG STYLUS PRO USB RECHARGEABLE PENLIGHT, 350/90 LUMENS, 120V AC/USB CHARGE CORD, BLUE | streamlight | 105.61 | CAT4150XZ |
STREAMLIGHT
PG398 - 6" LONG STYLUS PRO USB RECHARGEABLE PENLIGHT, 350/90 LUMENS, 120V AC/USB CHARGE CORD, BLUEPart# STM-66139C$ 105.61
In Stock
| Yes | No | |||
| 23 | PG398 - STYLUS PRO USB-RED | streamlight | 93.91 | CAT4150XZ |
C$ 93.91
In Stock
| Yes | No | |||
| 24 | PG398 - 6" LONG STYLUS PRO USB RECHARGEABLE PENLIGHT, 350/90 LUMENS, 120V AC/USB CHARGE CORD, RED | streamlight | 105.61 | CAT4150XZ |
STREAMLIGHT
PG398 - 6" LONG STYLUS PRO USB RECHARGEABLE PENLIGHT, 350/90 LUMENS, 120V AC/USB CHARGE CORD, REDPart# STM-66136C$ 105.61
In Stock
| Yes | No | |||
| 25 | PG398 - STYLUS PRO USB - BLACK WITH WHITE LED | streamlight | 93.91 | CAT4150XZ |
C$ 93.91
In Stock
| Yes | No | |||
| 26 | PG398 - STYLUS PRO USB W/120V AC ADAPTER - BLACK W/WHITE LED | streamlight | 105.61 | CAT4150XZ |
C$ 105.61
In Stock
| Yes | No | |||
| 27 | PG398 - STYLUS PRO - LIME GREEN - WHITE LED | streamlight | 39.55 | CAT4150XZ |
C$ 39.55
In Stock
| Yes | No | |||
| 28 | PG398 - STYLUS PRO - ORANGE - WHITE LED | streamlight | 39.55 | CAT4150XZ |
C$ 39.55
In Stock
| Yes | No | |||
| 29 | PG398 - STYLUS PRO BLUE - WHITE LED | streamlight | 39.55 | CAT4150XZ |
C$ 39.55
In Stock
| Yes | No | |||
| 30 | PG398 - STYLUS PRO SILVER - WHITE LED | streamlight | 39.55 | CAT4150XZ |
C$ 39.55
In Stock
| Yes | No | |||
| 31 | PG398 - STYLUS PRO RED - WHITE LED | streamlight | 39.55 | CAT4150XZ |
C$ 39.55
In Stock
| Yes | No | |||
| 32 | PG398 - STYLUS PRO BLACK - WHITE LED | streamlight | 39.55 | CAT4150XZ |
C$ 39.55
In Stock
| Yes | No | |||
| 33 | PG398 - STYLUS REACH - BLACK - WHITE LED | streamlight | 37.39 | CAT4150XZ |
C$ 37.39
In Stock
| Yes | No | |||
| 34 | PG398 - STYLUS REACH - SILVER - WHITE LED | streamlight | 37.39 | CAT4150XZ |
C$ 37.39
In Stock
| Yes | No | |||
| 35 | PG398 - STYLUS REACH 18 - BLACK - 18" CABLE - WHITE LED | streamlight | 43.61 | CAT4150XZ |
C$ 43.61
In Stock
| Yes | No | |||
| 36 | PG398 - STYLUS BLACK - 365 NM UV LED | streamlight | 37.39 | CAT4150XZ |
C$ 37.39
In Stock
| Yes | No | |||
| 37 | PG398 - STYLUS - RED - WHITE LED | streamlight | 27.41 | CAT4150XZ |
C$ 27.41
In Stock
| Yes | No | |||
| 38 | PG398 - STYLUS - GOLD CLAM PACKAGED - WHITE LED | streamlight | 27.41 | CAT4150XZ |
C$ 27.41
In Stock
| Yes | No | |||
| 39 | PG398 - STYLUS BLACK. CLAM PACKAGED - WHITE LED | streamlight | 27.41 | CAT4150XZ |
C$ 27.41
In Stock
| Yes | No | |||
| 40 | PG399 - 24-INCH LED PRO ALUMINUM BEND-A-LIGHT | steelman | 46.16 | CAT4150XZ |
C$ 46.16
In Stock
| Yes | No | |||
| 41 | PG399 - 16-INCH BEND-A-LIGHT PRO | steelman | 43.73 | CAT4150XZ |
C$ 43.73
In Stock
| Yes | No | |||
| 42 | PG399 - 120 MAX LUMEN RECHARGEABLE LED PEN LIGHT | solar-clore-automotive | 44.59 | CAT4150XZ |
C$ 44.59
In Stock
| Yes | No | |||
| 43 | PG400 - USB RECHARGEABLE ROVER POCKET FLOOD LIGHT, 445 LUMENS, INCL. USB CHARGE CORD | milwaukee-electric | 101.98 | CAT4150XZ |
Milwaukee Electric
PG400 - USB RECHARGEABLE ROVER POCKET FLOOD LIGHT, 445 LUMENS, INCL. USB CHARGE CORDPart# MLW-2112-21C$ 101.98
In Stock
| Yes | No | |||
| 44 | PG400 - 175 LUMENS POCKET COB LED LIGHT STICK (ORANGE) | ez-red | 13.57 | CAT4150XZ |
C$ 13.57
In Stock
| Yes | No | |||
| 45 | PG400 - POCKET COB LIGHT STICK | ez-red | 13.57 | CAT4150XZ |
C$ 13.57
In Stock
| Yes | No | |||
| 46 | PG399 - 200 LUMENS HIGH-POWER LED TACTICAL LIGHT | ez-red | 24.16 | CAT4150XZ |
C$ 24.16
In Stock
| Yes | No | |||
| 47 | PG398 - ALUMINUM NON-RECHARGEABLE MINI-TAC FLASHLIGHT - RED - 2 AAA BATTERIES | bayco | 31.46 | CAT4150XZ |
Bayco
PG398 - ALUMINUM NON-RECHARGEABLE MINI-TAC FLASHLIGHT - RED - 2 AAA BATTERIESPart# BAY-MT-100RC$ 31.46
In Stock
| Yes | No | |||
| 48 | PG398 - ALUMINUM NON-RECHARGEABLE MINI-TAC FLASHLIGHT - BLUE - 2 AAA BATTERIES | bayco | 31.46 | CAT4150XZ |
Bayco
PG398 - ALUMINUM NON-RECHARGEABLE MINI-TAC FLASHLIGHT - BLUE - 2 AAA BATTERIESPart# BAY-MT-100BLC$ 31.46
In Stock
| Yes | No | |||
| 49 | PG398 - ALUMINUM NON-RECHARGEABLE MINI-TAC FLASHLIGHT - BLACK - 2 AAA BATTERIES | bayco | 31.46 | CAT4150XZ |
Bayco
PG398 - ALUMINUM NON-RECHARGEABLE MINI-TAC FLASHLIGHT - BLACK - 2 AAA BATTERIESPart# BAY-MT-100C$ 31.46
In Stock
| Yes | No | |||
| 50 | PG400 - WIRELESS CHARGING PAD | atd | 54.4 | CAT4150XZ |
C$ 54.40
In Stock
| Yes | No | |||
| 51 | PG400 - 500L WORK LIGHT-WIRELESS CHARGE | atd | 114.37 | CAT4150XZ |
C$ 114.37
In Stock
| Yes | No | |||
| 52 | PG400 - 500 LUMEN WIRELESS CHARGING LED POCKET LIGHT | atd | 89.93 | CAT4150XZ |
C$ 89.93
In Stock
| Yes | No | |||
| 53 | STYLUS PRO REACH, BLK/W | streamlight | 59.22 | CAT4150XZ |
C$ 59.22
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 54 | PG398 - MICROSTREAM WITH ALKALINE BATTERY - BLACK | streamlight | 33.89 | CAT4150XZ |
C$ 33.89
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 55 | PG399 - LED PEN LIGHT / 30 LUMENS / GREEN | bayco | 36.42 | CAT4150XZ |
C$ 36.42
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No |