Welcome, | Logout
IMG
Loading..
Select a color
1 ¾ Inch Top Grain Heavy Leather w/ Snap-on Garrison Buckle
Item: 7AC-2900-1S
Brand: artcraft belt

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

QTY:
List Price:
Heavyweight Leather Garrison Belt
Heavyweight Duty Belt
1 3/4  inches Wide
Silver Finished Removable Buckle
Quality that is used by Police Officers
Perfect for Security Uniform
Edges creased for True Uniform Look
Postal Approved
For pant size 34 buy size 36 belt
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` = '7AC-2900-1S') 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`