Welcome, | Logout
IMG
Loading..
Select a color
Reebok Men's Athletic Astroride Work Shoe
Item: 6RB-RB2230
Brand: ReeBok

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

QTY:
List Price:
Take the next step in work footwear with the Reebok Astroride Work. This work shoe designed to take you the distance and propel you forward. The soft ASTROFOAM midsole cushions with a lightweight responsive feel.
 
ASTM F2892, Soft Toe, EH, SR, Metal Free
100% Non-Metallic, SplashZone
Moisture Wicking Ultrafine Nylon Fabric
 


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-RB2230') 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`