Welcome, | Logout
IMG
Loading..
Select a color
Men's Textrop2 Long Sleeve Shirts
Item: 8EB-310N
Brand: ELBECO

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

QTY:
List Price:
An original best, the TexTrop2 Shirt offers enhanced flex underarm mesh vents providing body heat ventilation and increased range of motion with more storage and function options with dual access utility compartments and communication wire access openings in side seams that keep wires obscure. An original best, the TexTrop2 is professional, quality and durable.
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` = '8EB-310N') 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`