IMG
Loading..
Select a color
Performance Tactical Polo
Item: 8CD-101060
Brand: Condor

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

QTY:
List Price:
The Condor Performance Tactical Polo is our re-vamped on duty essential. The fabric is now knitted polyester that is treated to help wick more moisture and constructed to allow for better ventilation. The PTP holds true to its signature features such as the dual pen pockets, and microphone and sunglass clips.

Features:
  • Three Button placket front with melamine buttons
  • Moisture wicking knitted polyester fabric
  • Dual pen pockets
  • Gusseted underarms for freedom of movement
  • Sunglasses clip under buttons
  • Microphone clip on shoulders
  • Import
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-101060') 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`