Welcome, | Logout
IMG
Loading..
Select a color
Reflective Duty Vests, Security
Item: 4FC-SV12

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

QTY:
List Price:
The Reflective Duty Vests have a durable mesh construction to provide high durability for extensive use. Its fluorescent trim and reflective stripes ensure high visibility in all conditions. The vests come in dark navy and can either come in a plain design or read Police, Security, Sheriff, or Traffic Control in black letters. Durable mesh construction with fluorescent trim and reflective silver stripes. Includes mic clip, pen pocket, and inside pocket
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` = '4FC-SV12') 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`