The Condor Short Sleeve Combat Shirt is an alternative to the traditional polo shirt which can be used as relaxed duty uniform or a hot weather range shirt. The short sleeve design made with moisture wicking, lightweight, and breathable material will keep you cool and dry in the hottest environments plus its modified raglan cut sleeves for improved range of motion.
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
Anti-static
Anti-microbial
Moisture wicking
Patent No.: US822347
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-101144') 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`
