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

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. Clutch pins are longer than the standard clutch back to accommodate service bars. 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-MSG12CS') 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`