Welcome, | Logout
IMG
Loading..
Select a color
Cargo Shorts 100% Cotton
Item: 3RK-PC86
Brand: Red Kap

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

QTY:
List Price:
Features:
  • Blend: 100% Cotton
  • Care: Industrial Wash, Light Soil or Home Wash
  • Closure: Heavy-duty brass ratcheting zipper, button closures
  • Fabric: 8.5 oz. Twill
  • Finish: Durable press
  • Pocket: Two superstitch slack-style front pockets, two back patch pockets with spade flaps and snap closures, two patch leg pockets with inverted center pleat, one piece pocket flap with mitered corners, two snap closures
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` = '3RK-PC86') 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`