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.
Related Items..
Please Wait...
verifying & adding to your items to your shopping cart...
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`
