Welcome, | Logout
IMG
Loading..
Select a color
Uzi PR24 Style Handcuff Key
Item: 9CC-UZI-KEY-PR24
Brand: Campco

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

QTY:
List Price:
UZI PR24 Style Handcuff Key, includes small and large key chains, works on most police quality handcuffs, UZI, Smith & Wesson, Peerless, Hiatt, American Handcuffs, ASP, Safariland, etc., 100% lifetime warranty

The UZI-KEY-PR24 Style Handcuff Key works for most professional handcuffs and includes a small and large keychain. Black finish. UZI combines advanced technical concepts with innovative designs to produce products used and trusted by the Army, Secret Service and Special Forces. Since its launch in the 1950s, UZI has become one of the world's most famous firearm brands and a 20th century icon.
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` = '9CC-UZI-KEY-PR24') 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`