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
Related Items..
Please Wait...
verifying & adding to your items to your shopping cart...
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`
