Welcome, | Logout
IMG
Loading..
Select a color
BDU Short Sleeve Shirt
Item: 8PR-F5456-38
Brand: Propper

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

QTY:
List Price:
Battle Rip fabric is comfortable and durable Fade, shrink and wrinkle resistant Felled seams throughout for enhanced durability Shoulder epaulets with buttons Two front cargo pockets with hidden button flaps Chest pen pocket Drain holes in bellowed pockets Fused pocket flaps and collar for clean, professional look Covered button front Extended length for tucking into pant
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` = '8PR-F5456-38') 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`