Welcome, | Logout
IMG
Loading..
Select a color
Condor's Combat Shirt
Item: 8CD-101065
Brand: Condor

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

QTY:
List Price:
The Condor Combat Shirt is what everyone has been asking for. Fully functional and comfortably fit, our combat shirt is ready to go with you wherever you're needed. From Raglan cut sleeves for improved range of motion to anti-static and anti-microbial finishes on the chest, the Combat Shirt is ready to help you perform at your best.

Features:
  • Raglan cut sleeves for improved range of motion
  • Mesh underarm panel to increase ventilation
  • Mesh lined collar
  • Two bicep pockets with YKK zipper closures
  • Two upper arm patch panels
  • Elbow pad pockets
  • Reinforced elbow
  • Hook and loop cuff adjustment
  • Anti-static
  • Anti-microbial
  • Moisture wicking
  • Imported
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` = '8CD-101065') 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`