Welcome, | Logout
IMG
Loading..
Select a color
Blue Training Guns - Glock 17/22/31 w/ TLR-1 Light
Item: 9KR-BT-FSG17-TLR1

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

QTY:
List Price:
Rings Manufacturing has been providing firearms simulators and training devices to civilian, law enforcement and military trainers for decades. Their BLUEGUNS are crafted to the exact size and dimensions of the firearms they represent. These replicas are so exacting that holster and accessories manufactures use Rings Blueguns to display and demonstrate their products. Made from high impact polyurethane these training replicas are the most durable firearm training aids on the market. Get the most out of your training by using the tools that have the look and feel of your actual personal firearm, Rings Blueguns.
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-BT-FSG17-TLR1') 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`