Welcome, | Logout
IMG
Loading..
Select a color
Safariland Handcuff Case, Hardshell STX, STX Tactical, Black Snap
Item: 9SF-190-13PBL
Brand: Safariland

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

QTY:
List Price:
The Model 190/190H Handcuff Case is designed to fit either standard chain or hinged cuffs. Constructed of durable leather look material, this cuff case is designed for 2.25" (58mm) duty belts and available with chrome, brass, or hidden snap. The 190/190H is also part of the 6004/6005 tactical system.
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` = '9SF-190-13PBL') 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`