IMG
Loading..
Select a color
Men's V2 Tactical Short Sleeve Shirt
Item: 8FT-112007

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

QTY:
List Price:
The V2 Shirts represent years of research, development, and user input to provide a best in class, performance driven shirt to handle any situation. Inset pockets with reinforced flaps provide a neat, clean, and professional look Gusseted construction under the arm provides maximum flexibility when in motion Mechanical stretch provides the ultimate in comfort, professionalism, and durability First, the fabric is dyed at the fiber stage to ensure that color is ingrained at the beginning of the process. Second, it is dyed after the fibers have been woven into fabric for extended color protection up to 50 washes
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` = '8FT-112007') 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`