Welcome, | Logout
IMG
Loading..
Select a color
MagLite 3-Cell LED Flashlight in Display Box, Grey
Item: 9ML-ST3D095
Brand: Mag-Lite

Oppps.. This color is currently out-of stock, Please contact us for availablitiy.

QTY:
List Price:
The Maglite flashlight, renowned for its quality, durability, and reliability, is now available with the new MAG-LED Technology. Designed for professional and consumer use, Maglite LED flashlights build on the experience in craftsmanship, engineering, and advanced technology evident in all Mag flashlights. The Maglite flashlight is internationally accepted as the Professional Flashlight. Built tough enough to last a lifetime, its durability and innovative features now combined with the new MAG-LED Technology make the Maglite LED flashlight a technologically advanced lighting instrument. Available in 2 and 3 Cell D size.
SELECT `I`.`ListID`, `I`.`ProductID`, `I`.`ItemGroup`, `I`.`ItemColorID`, `I`.`ItemColor`, `I`.`ItemSizeOnly` AS `ItemSize`, `I`.`ItemLength`, `I`.`RequiredAlterationID`, `I`.`ProspectItem`, MAX(`S`.CatID) AS CatID, `I`.`SalesPrice`,`I`.`SalesPrice` AS `WebPrice`, `I`.`AltShowListID`, `I`.`InventoryOnly` FROM `tbl_items` `I` LEFT JOIN `tbl_items_search` `S` ON (`I`.`ItemID`=`S`.`ItemID`) AND (`S`.`CatID` = '2076') WHERE (`I`.`ItemGroup` = '9ML-ST3D095') AND (`I`.`ShowOnlyLocal` = '1') AND (`I`.`IsActive` != '0') AND (`I`.`SpecialGroupID` Is Null OR `I`.`SpecialGroupID` = '0') GROUP BY `I`.`ListID` ORDER BY `I`.`ProspectItem`, IFNULL(`I`.`ItemColor`,'ZZZZZZ'),`I`.`SizeSort`,`I`.`ItemSize`, `I`.`ItemLength`