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=4148 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 | |
|---|---|---|---|---|---|---|---|---|---|---|
| TASK-LIGHT 3AA WITH ALKALINE BATTERIES - TITANIUM | streamlight | 64.64 | CAT4148XZ |
C$ 64.64
In Stock
| Yes | No | ||||
| 1 | PG402 - POLYTAC WITH LITHIUM BATTERIES - BLACK | streamlight | 84.65 | CAT4148XZ |
C$ 84.65
In Stock
| Yes | No | |||
| 2 | PG402 - PROTAC 2L W/2 CR123A LITHIUM BATTERIES AND HOLSTER - BLACK | streamlight | 95.89 | CAT4148XZ |
C$ 95.89
In Stock
| Yes | No | |||
| 3 | PG402 - SCORPION HL WITH LITHIUM BATTERIES | streamlight | 135.41 | CAT4148XZ |
C$ 135.41
In Stock
| Yes | No | |||
| 4 | PG402 - 4AA LUX DIV 2 WITH WHITE LED AND ALKALINE BATTERIES - BLACK | streamlight | 70.51 | CAT4148XZ |
C$ 70.51
In Stock
| Yes | No | |||
| 5 | PG402 - 4AA LUX DIV 2 WITH WHITE LED AND ALKALINE BATTERIES - YELLOW | streamlight | 70.51 | CAT4148XZ |
C$ 70.51
In Stock
| Yes | No | |||
| 6 | PG402 - 3N PROPOLYMER LED FLASHLIGHT, ALKALINE BATTERIES - YELLOW | streamlight | 33.89 | CAT4148XZ |
C$ 33.89
In Stock
| Yes | No | |||
| 7 | PG402 - 325/25 LUMENS FOCUSING FLASHLIGHT WITH HOLSTER, INCLUDES (3) AAA BATTERIES | milwaukee-electric | 61.18 | CAT4148XZ |
Milwaukee Electric
PG402 - 325/25 LUMENS FOCUSING FLASHLIGHT WITH HOLSTER, INCLUDES (3) AAA BATTERIESPart# MLW-2107SC$ 61.18
In Stock
| Yes | No | |||
| 8 | PG402 - SAFETY RATED LED FLASHLIGHT-FLOODLIGHT-DUAL-LIGHT | bayco | 62.96 | CAT4148XZ |
C$ 62.96
In Stock
| Yes | No | |||
| 9 | PG402 - ADJUSTABLE BEAM FLASHLIGHT 3 AAA | bayco | 36.42 | CAT4148XZ |
C$ 36.42
In Stock
| Yes | No | |||
| 10 | PG402 - ADJUSTABLE BEAM FLASHLIGHT 1 AA | bayco | 31.21 | CAT4148XZ |
C$ 31.21
In Stock
| Yes | No | |||
| 11 | PG402 - MULTI-PURPOSE DUAL-LIGHT WITH MAGNET - RED - 3 AA BATTERIES | bayco | 47.93 | CAT4148XZ |
C$ 47.93
In Stock
| Yes | No | |||
| 12 | PG402 - MULTI-PURPOSE DUAL-LIGHT WITH MAGNET - BLACK - 3 AA BATTERIES | bayco | 47.93 | CAT4148XZ |
C$ 47.93
In Stock
| Yes | No | |||
| 13 | PG402 - 325/25 LUMENS FOCUSING FLASHLIGHT WITH HOLSTER, INCLUDES (3) AAA BATTERIES | milwaukee-electric | 61.18 | CAT4148XZ |
Milwaukee Electric
PG402 - 325/25 LUMENS FOCUSING FLASHLIGHT WITH HOLSTER, INCLUDES (3) AAA BATTERIESPart# MLW-2107SC$ 61.18
In Stock
| Yes | No | |||
| 14 | PROTAC HL-X BLK CLAM | streamlight | 156.78 | CAT4148XZ |
C$ 156.78
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 15 | PG402 - PROTAC HL 3 W/3 CR123A LITHIUM BATTERIES - BLACK | streamlight | 172.39 | CAT4148XZ |
C$ 172.39
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No |