Reebok Work RB6750 Trainex - 6" Sport Boot with a Composite Toe, Electrical Hazard Protection, Aircom Heel Airbag and Security Friendly Features. Extra Large Sizes & Widths Available.
Features:
ASTM F2413, AircomTM Air Comfort Technology, Extra Large Sizes, Extra Wide Widths, Electrical Hazard, Security Friendly
6" Sport Boot
Toe Composite Toe
Upper Leather
Color Black
Lining Nylon Mesh
Insole Removable EVA Cushion Insert with Sponge Rubber Heel Wedge
Outsole Dual Density; Direct Attached Durable Rubber Bottom with 90 Degree Heel and PU Cushion Midsole
Special Feature
Metal Free, Heel Airbag
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` = '6RE-RB6750') 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`
