Welcome, | Logout
IMG
Loading..
Select a color
1/2" X 2-3/8" METAL NAME TAG WITH CLUTCH - Satin Silver
Item: 9NP-MSS12C

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

QTY:
List Price:
Municipal employees, law enforcement officers, and firefighters will appreciate these top quality brass and nickel silver badges with .050" thickness. Works great with our brass oxidation solution! Available in bright gold, satin gold, bright silver, satin silver and chrome plated finishes.
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` = '9NP-MSS12C') 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`