Welcome, | Logout
IMG
Loading..
Select a color
MLK IV Mace Holder
Item: 9TS-9031

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

QTY:
List Price:
This high-quality, professional gear for your duty belt will ensure that you have your mace secured but readily available when you need it most. High density foam center and soft lining protects your gear.;

Features:
  • Full flap with hidden single snap closure on each pocket to secure canisters
  • High quality, high density foam center
  • Soft lining to protect gear
  • For use with 2" duty belts
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` = '9TS-9031') 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`