IMG
Loading..
Select a color
First Class Security Windbreakers - Yellow/black
Item: 1FC-WB17SB

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

QTY:
List Price:
The First Class Security Windbreakers have an outer shell made from 100% nylon to ensure the jackets have high durability and longevity for extensive use. The jackets have 100% cotton lining, have reinforced slash pockets, and are water repellent. The windbreakers come in black, navy blue, and green with Security ID in white or gold letters, back and front. It also comes in orange and yellow with Security ID in black letters, back and front.
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` = '1FC-WB17SB') 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`