IMG
Loading..
Select a color
Rothco Poly/Cotton Twill Solid BDU Shirts
Item: 1RT-7837
Brand: Rothco

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

QTY:
List Price:
Rothco's B.D.U. Shirts feature a Poly/Cotton twill material, four large button-down bellowed pockets, front button pocket with flap closure, reinforced elbows and adjustable button tab cuff at the end of the sleeve. Matching bdu pants and uniform accessories are also available. Rothco is your source for military and tactical uniforms; no one offers a wider selection of BDU Fatigue Shirts and BDU Pants than Rothco.
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` = '1RT-7837') 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`