The Professional Zipper Front Shirt is a versatile item, perfect to use in a variety of settings. Fit for both men and women, the shirt contains two lower front patch, left breast, and an electronics pocket. It can be worn with or without an undergarment and has a color matched nylon zipper. Stands up to industrial wash
FEATURES:
4.25 oz. poplin, 65% polyester/35% cotton
Pre-cured durable press
Color matched nylon zipper
2 piece collar with notched lapel
2 lower front patch pockets, right has an electronics pocket, one left breast pocket
Short sleeve, Unisex sizing
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` = '8PN-SHHZDC') 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`
