IMG
Loading..
Propper Men's Uniform Polo - Short Sleeve
Item: 8PR-F5355-4C
Brand: Propper

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

QTY:
List Price:
The best value in tactical performance polos, the Uniform Polo is the perfect shirt for an entire team. Performance polyester dries quickly and will stand up without fading, shrinking, or wrinkling.

Features:
  • Quick-dry performance fabric
  • Fade-, shrink-, and wrinkle-resistant
  • Ribbed cuffs and collar
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` = '8PR-F5355-4C') 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`