Welcome, | Logout
IMG
Loading..
Select a color
Nylon Handcuff Case Single
Item: 9NY-NP-HCS
Brand: Urban Patrol

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

QTY:
List Price:
Made of lightweight ballistic nylon, our Molded Nylon Duty Gear is durable yet comfortable. You can be sure that your gear is protected. Molded foam interiors ensure that your gear fits and is easy to remove in a hurry. Hidden metal snap closures to ensure your gear will not fall or slip out. (Keepers and radio holder have visible black metal snaps.)
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` = '9NY-NP-HCS') 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`