IMG
Loading..
Select a color
Beamer - Men's Waterproof Athletic Work Boot with CushGuard Internal Met Guard - Black with Grey Trim
Item: 6RB-RB1067
Brand: ReeBok

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

QTY:
List Price:
Men's Waterproof Athletic Work Boot with CushGuard Internal Met Guard
ASTM F2413, XTR Brand Composite Toe Cap, Metatarsal Guard, CushGuard Internal Metatarsal Guard, Metal Free, Waterproof, Electrical Hazard Protection, Composite Toe, FootFuel Footbed, 30 Day Comfort Guarantee, Slip Resistant (ASTM F3445)
 
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` = '6RB-RB1067') 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`