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=4149 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 | |
---|---|---|---|---|---|---|---|---|---|---|
360 COB LED MAGNETIC TORCH LIGHT 400 LUMENS THREE MODES | grip-on-tools | 15.17 | CAT4149XZ |
C$ 15.17
In Stock
| Yes | No | ||||
1 | PG396 - SIEGE X USB, 325 LUMENS RECHARGEABLE COMPACT HAND LANTERN/FLASHLIGHT COMBO, COYOTE | streamlight | 82.31 | CAT4149XZ |
STREAMLIGHT
PG396 - SIEGE X USB, 325 LUMENS RECHARGEABLE COMPACT HAND LANTERN/FLASHLIGHT COMBO, COYOTEPart# STM-44956C$ 82.31
In Stock
| Yes | No | |||
2 | PG396 - THE SIEGE - COYOTE | streamlight | 74.83 | CAT4149XZ |
C$ 74.83
In Stock
| Yes | No | |||
3 | PG396 - WAYPOINT LANTERN, 12V DC POWER CORD - YELLOW | streamlight | 115.07 | CAT4149XZ |
C$ 115.07
In Stock
| Yes | No | |||
4 | FIRE VULCAN LED 120V OR | streamlight | 357.73 | CAT4149XZ |
C$ 357.73
In Stock
| Yes | No | |||
5 | PG396 - VULCAN 180 MULTI-FUNCT., RECHARGEABLE C4 LED LANTERN, YELLOW BODY, 1200/350 LUMENS, AC/DC CHARGERS & RACK | streamlight | 362.47 | CAT4149XZ |
STREAMLIGHT
PG396 - VULCAN 180 MULTI-FUNCT., RECHARGEABLE C4 LED LANTERN, YELLOW BODY, 1200/350 LUMENS, AC/DC CHARGERS & RACKPart# STM-44301C$ 362.47
In Stock
| Yes | No | |||
6 | PG396 - M18 SEARCH LIGHT (BARE TOOL), 1250 LUMENS | milwaukee-electric | 152.03 | CAT4149XZ |
C$ 152.03
In Stock
| Yes | No | |||
7 | PG396 - 4.5" DUAL FUNCTION USB RECHARGEABLE UTILITY LIGHT WITH MAGNETIC BASE, 225/115 LUMENS | ez-red | 59.18 | CAT4149XZ |
EZ Red
PG396 - 4.5" DUAL FUNCTION USB RECHARGEABLE UTILITY LIGHT WITH MAGNETIC BASE, 225/115 LUMENSPart# EZR-CT6515C$ 59.18
In Stock
| Yes | No | |||
8 | SUPER SIEGE YEL | streamlight | 228.95 | CAT4149XZ |
C$ 228.95
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
9 | PG396 - THE SIEGE AA - COYOTE | streamlight | 55.31 | CAT4149XZ |
C$ 55.31
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
10 | PG396 - 200 LM/100LM RECHARGEABLE MICRO UTILITY WORK LIGHT | ez-red | 36.25 | CAT4149XZ |
C$ 36.25
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No |