IMG
Loading..
Select a color
Extended Pistol Taco - OD Green
Item: 9KR-HSG-11EX00OD

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

QTY:
List Price:
By Adding 2.25 In Length To The Original Pistol Taco, We Created The Extended Pistol Taco. Most High Capacity Pistol And Sub Gun Magazines Are Held Securely, Deployed Easily, And Silently On Demand. Also Fits Large Flashlights, Collapsible Batons, And Other Survival Equipment.
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` = '9KR-HSG-11EX00OD') 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`