IMG
Loading..
Select a color
Rothco Zipper Fly Bdu Combat Shorts
Item: 3RT-5903
Brand: Rothco

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

QTY:
List Price:
Rothco’s Zipper Fly BDU Combat Shorts feature all the essential elements of our classic military BDU Shorts but with a zipper fly, which makes it ideal for the public safety and uniform market. The cargo style shorts feature six utility pockets including two front slash pockets, two rear button down pockets and two large cargo pockets. For extra comfort and breathability, the shorts are constructed with a durable yet comfortable cotton/polyester material and feature adjustable waist tabs, for the perfect fit.
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` = '3RT-5903') 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`