Jay's Sporting Goods

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	FAMLIST	HASIMAGE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SOLD	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	UPC	URL	VENDOR_INTEGRATE_ID
1	[empty string]	KELTEC	Kel Tec	FIREARMS	Firearms>Pistols	[empty string]	1	425	0	425	68366-DEFAULT-l.jpg	425	68366-DEFAULT-m.jpg	KEL-TEC PMR-30 22MAG BLUE	N	11 JJ	22 WMR	[empty string]	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[empty string]	NONE	KEL-TEC CNC INC	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	ONLINE	SEMI AUTO	PISTOL	1	400-to-450	0.00	[empty string]	Pmr-30 - 22 Mag - Dao - 30 + 1 Rds - Black Polymer	<p>The PMR-30 is a lightweight, full size pistol (.22WMR). The PMR-30 operates on a unique hybrid blow back/locked-breech system, allowing for the use of a wide variety of ammunition as it seamlessly adjusts depending on the pressure of the cartridge. It uses a flush fit, 30-round double stack Zytel nylon magazine with round count ports. The trigger is a crisp single action with an over travel stop. It has a thumb-activated ambidextrous safety lever. The slide locks back after the last shot and a manual slide lock lever is also provided. The slide and barrel are 4140 steel, the frame is 7075 aluminum. The grip, slide cover, trigger, mag release, and safety levers are glass reinforced nylon (Zytel). Other features include: dual opposing extractors for reliability, heel magazine release to aid in magazine retention, dovetailed aluminum front sight, Picatinny accessory rail under the barrel, urethane recoil buffer, and captive coaxial recoil springs. It has a fluted barrel for light weight and effective heat dissipation. PMR30 disassembles for cleaning by removal of a single pin.</p>	[empty string]	N	425	425	[empty string]	68366-DEFAULT-s.jpg	[empty string]	1000	PMR30BBLK	124876	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	kel-tec/kel-tec-pmr-30-22mag-blue-124876	1
2	[empty string]	KELTEC	Kel Tec	FIREARMS	Firearms>Magazines	[empty string]	1	28.99	0	28.99	85846-DEFAULT-l.jpg	28.99	85846-DEFAULT-m.jpg	PMR30 22MG 30 ROUND MAG	N	11 JJ	22 MAG	[empty string]	[empty string]	[empty string]	ADULT SIGNATURE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	10	25-to-50	0.00	[empty string]	Pmr30 22mg 30 Round Mag	[empty string]	[empty string]	N	28.99	28.99	[empty string]	85846-DEFAULT-s.jpg	[empty string]	1000	PMR30-36	134453	EMPTY	EMPTY	EMPTY	0	0	0	MAGAZINES	[empty string]	kel-tec/pmr30-22mg-30-round-mag-134453	1
3	[empty string]	KELTEC	Kel Tec	FIREARMS	Firearms>Magazines	[empty string]	1	27.99	0	27.99	89928-DEFAULT-l.jpg	27.99	89928-DEFAULT-m.jpg	KEL-TEC P11-36 MAGAZINE	N	11 JJ	[empty string]	[empty string]	[empty string]	[empty string]	ADULT SIGNATURE	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	3	25-to-50	0.00	[empty string]	Kel-tec P11-36 Magazine	[empty string]	[empty string]	N	27.99	27.99	[empty string]	89928-DEFAULT-s.jpg	[empty string]	1000	P11-36LE	152902	EMPTY	EMPTY	EMPTY	0	0	0	MAGAZINES	[empty string]	kel-tec/kel-tec-p11-36-magazine-152902	1
4	[empty string]	KELTEC	Kel Tec	FIREARMS	Firearms>Shotguns	[empty string]	1	910	0	910	70225-DEFAULT-l.jpg	910	70225-DEFAULT-m.jpg	KEL TEC KSG 12GA 18.5IN 14 ROUND TAN	N	11 JJ	12 GA	18-1/2IN	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[empty string]	NONE	KEL-TEC CNC INC	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	PUMP	SHOTGUN	1	500-or-more	0.00	[empty string]	Kel Tec Ksg 12ga 18.5in 14 Round Tan	Kel-Tec`s KSG is a simple and reliable pump action shotgun able to feed from either the left or right tube, with a manual feed side selector lever located behind the trigger guard. Each tube holds up to 6 shells for a total 12+1 capacity. The pump includes top and bottom Picatinny rails to mount accessories and optics. The soft rubber butt pad helps to tame recoil. The KSG receiver is made from hardened steel and the magazine tubes have been welded in place. The grip and stock assembly is made of glass reinforced nylon (Zytel) and is easily disassembled by pushing out two pins, which store in two holes in the grip when removed. It has built-in forward and rear sling loops, and includes a basic sling.	[empty string]	N	910	910	[empty string]	70225-DEFAULT-s.jpg	[empty string]	1000	KSGTAN	245227	EMPTY	EMPTY	EMPTY	0	0	0	SHOTGUNS	[empty string]	kel-tec/kel-tec-ksg-12ga-18-5in-14-round-tan-245227	1
5	[empty string]	KELTEC	Kel Tec	FIREARMS	Firearms>Pistols	[empty string]	0	545	0	545	[empty string]	545	[empty string]	KEL-TEC PMR-30 22MAG CHARCOAL	N	11 JJ	22 WMR	[empty string]	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[empty string]	NONE	KEL-TEC CNC INC	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	NOT ONLINE	SEMI AUTO	PISTOL	1	500-or-more	0.00	[empty string]	Kel-tec Pmr-30 22mag Charcoal	The PMR-30 is a lightweight, full size pistol (.22WMR). The PMR-30 operates on a unique hybrid blow back/locked-breech system, allowing for the use of a wide variety of ammunition as it seamlessly adjusts depending on the pressure of the cartridge. It uses a flush fit, double stack Zytel nylon magazine with round count ports. The trigger is a crisp single action with an over travel stop. It has a thumb-activated ambidextrous safety lever. The slide locks back after the last shot and a manual slide lock lever is also provided. The slide and barrel are 4140 steel, the frame is 7075 aluminum. The grip, slide cover, trigger, mag release, and safety levers are glass reinforced nylon (Zytel). Other features include: dual opposing extractors for reliability, heel magazine release to aid in magazine retention, dovetailed aluminum front sight, Picatinny accessory rail under the barrel, urethane recoil buffer, and captive coaxial recoil springs. It has a fluted barrel for light weight and effective heat dissipation. PMR30 disassembles for cleaning by removal of a single pin. This model has a Tactical Gray grip, frame, and slide cover finish with a black slide.	[empty string]	N	545	545	[empty string]	[empty string]	[empty string]	1000	PMR30 CHARCOAL	249955	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	kel-tec/kel-tec-pmr-30-22mag-charcoal-249955	1
6	[empty string]	KELTEC	Kel Tec	FIREARMS	Firearms>Shotguns	[empty string]	1	1145	0	1145	66257-DEFAULT-l.jpg	1145	66257-DEFAULT-m.jpg	KEL TEC KSG 12GA 30.5IN 14 ROUND	N	11 JJ	12 GA	30 IN	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[empty string]	NONE	KEL-TEC CNC INC	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	PUMP	SHOTGUN	2	500-or-more	0.00	[empty string]	Kel Tec Ksg 12ga 30.5in 14 Round	The KSG-25 is no ordinary tactical shotgun. Its dual tube magazines hold a dozen 3 inch, 12 gauge shells (plus one in the chamber), with the flexibility of switching between various projectiles. A patented downward ejection system makes it truly ambidextrous.	[empty string]	N	1145	1145	[empty string]	66257-DEFAULT-s.jpg	[empty string]	1000	KSG25BLK	299541	EMPTY	EMPTY	EMPTY	0	0	0	SHOTGUNS	[empty string]	kel-tec/kel-tec-ksg-12ga-30-5in-14-round-299541	1
7	[empty string]	KELTEC	Kel Tec	FIREARMS	Firearms>Rifles	[empty string]	1	650	0	650	82411-DEFAULT-l.jpg	650	82411-DEFAULT-m.jpg	CMR 22 WIN MAG CARBINE BLACK	N	11 JJ	22 WMR	[empty string]	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[empty string]	NONE	KEL-TEC CNC INC	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	SEMI AUTO	RIFLE	3	500-or-more	0.00	[empty string]	Cmr 30 - 22 Mag - 30 + 1 Rds - Black - Collapsible Stock	<p> SPECIFICATIONS: </p> <p>-Model: Kel-Tec CMR 30</p> <p>-Item Number: CMR-30 </p> <p>-Caliber: 22 MAG</p> <p>-Stock Finish: Black</p> <p>-Action: Semi-Auto</p> <p>-Sights: None, Optic Ready</p> <p>-Capacity: 30+1</p> <p>-Grips: Black Polymer</p> <p>-Hand: Right</p> <p>-Barrel Length: 16.10"</p> <p>-OAL: 29.90"</p> <p>-Receiver Finish: Black</p> <p>-Receiver Material: Aluminum</p> <p>-Safety: Lever</p> <p>-Stock Description: Collapsible</p> <p>-Stock Finish: Black</p> <p>-Stock Material: Sunthetic</p> <p>-Trigger: Standard</p> <p>-Weight: 4.20 lbs</p> <p>-Barrel Finish: Black</p>	[empty string]	N	650	650	[empty string]	82411-DEFAULT-s.jpg	[empty string]	1000	CMR30	309419	EMPTY	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	kel-tec/cmr-22-win-mag-carbine-black-309419	1
8	[empty string]	KELTEC	Kel Tec	FIREARMS	Firearms>Rifles	[empty string]	1	1075	0	1075	86786-DEFAULT-l.jpg	1075	86786-DEFAULT-m.jpg	KEL-TEC RDB BULLPUP 17IN 5.56NATO SA RIFLE	N	11 JJ	5.56 NATO	[empty string]	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[empty string]	NONE	KEL-TEC CNC INC	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	SEMI AUTO	RIFLE	1	500-or-more	0.00	[empty string]	Kel-tec Rdb Bullpup 17in 5.56nato Sa Rifle	[empty string]	[empty string]	N	1075	1075	[empty string]	86786-DEFAULT-s.jpg	[empty string]	1000	RDB-17	309420	EMPTY	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	kel-tec/kel-tec-rdb-bullpup-17in-5-56nato-sa-rifle-309420	1
9	[empty string]	KELTEC	Kel Tec	FIREARMS	Firearms>Rifles	[empty string]	1	575	0	575	86418-DEFAULT-l.jpg	575	86418-DEFAULT-m.jpg	KEL-TEC SUB-2000 G2 9MM RIFLE B/GRN	N	11 JJ	9MM	16IN	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[empty string]	NONE	KEL-TEC CNC INC	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	SEMI AUTO	RIFLE	1	500-or-more	0.00	[empty string]	Kel-tec Sub-2000 G2 9mm Rifle B/grn	[empty string]	[empty string]	N	575	575	[empty string]	86418-DEFAULT-s.jpg	[empty string]	1000	SUB-2K9 GLK17	312931	EMPTY	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	kel-tec/kel-tec-sub-2000-g2-9mm-rifle-b-grn-312931	1
10	[empty string]	KELTEC	Kel Tec	FIREARMS	Firearms>Shotguns	[empty string]	1	635	0	635	85746-DEFAULT-l.jpg	635	85746-DEFAULT-m.jpg	KEL TEC KS7 12GA 18.5IN BLACK PUMP	N	11 JJ	12 GA	18-1/2IN	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[empty string]	NONE	KEL-TEC CNC INC	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	PUMP	SHOTGUN	3	500-or-more	0.00	[empty string]	Kel Tec Ks7 12ga 18.5in Black Pump	[empty string]	[empty string]	N	635	635	[empty string]	85746-DEFAULT-s.jpg	[empty string]	1000	KS7BLK	327002	EMPTY	EMPTY	EMPTY	0	0	0	SHOTGUNS	[empty string]	kel-tec/kel-tec-ks7-12ga-18-5in-black-pump-327002	1
11	[empty string]	KELTEC	Kel Tec	FIREARMS	Firearms>Pistols>Semi Auto Pistols	[empty string]	1	225	0	225	92551-DEFAULT-l.jpg	225	92551-DEFAULT-m.jpg	P17 BLACK 22LR 16 ROUND MAG PISTOL	N	11 JJ	22 LR	[empty string]	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[empty string]	NONE	KEL-TEC CNC INC	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	SEMI AUTO	PISTOL	2	200-to-250	0.00	[empty string]	P17 - 22 LR - DAO - 16 RDS - BLACK - THREADED BBL	<ul> <li>Item: Kel-Tec P17</li> <li>Item Number: P17BLK</li> <li>Caliber: 22 LR</li> <li>Action: DAO</li> <li>Capacity: 16</li> <li>Barrel Length: 3.80"</li> <li>OAL: 6.70"</li> <li>Sights: Fiber Optic Frant and Adjustable Read</li> <li>Grips: Black Polymer</li> <li>Safety: Ambidextrous Safety Lever</li> <li>Frame: Black Polymer</li> <li>Barrel Description: Steel Threaded</li> </ul> <p> </p>	[empty string]	N	225	225	[empty string]	92551-DEFAULT-s.jpg	[empty string]	1000	P17BLK	358479	SEMI AUTO PISTOLS	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	kel-tec/p17-22-lr-dao-16-rds-black-threaded-bbl-358479	1
12	[empty string]	KELTEC	Kel Tec	FIREARMS	Firearms>Pistols>Semi Auto Pistols	[empty string]	1	245	0	245	102397-DEFAULT-l.jpg	245	102397-DEFAULT-m.jpg	P17 TAN 22LR 16 ROUND MAG PISTOL	N	11 JJ	22 LR	[empty string]	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[empty string]	NONE	KEL-TEC CNC INC	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	SEMI AUTO	PISTOL	1	200-to-250	0.00	[empty string]	P17 - 22 LR - STRIKER FIRED - 16 RDS - TAN	<ul> <li>Item: Keltec P17</li> <li>Item Number: P17TAN</li> <li>Caliber: 22 LR</li> <li>Action: Striker Fired</li> <li>Capacity: 16</li> <li>Barrel Length: 3.93"</li> <li>OAL: 6.65"</li> <li>Frame Material: Polymer</li> <li>Frame Finish: Tan</li> <li>Sights: Fixed Rear and Fiber Optic Front</li> <li>Threaded Barrel, 1/2X28</li> <li>External Safety</li> </ul> <p> </p>	[empty string]	N	245	245	[empty string]	102397-DEFAULT-s.jpg	[empty string]	1000	P17TAN	362110	SEMI AUTO PISTOLS	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	kel-tec/p17-22-lr-striker-fired-16-rds-tan-362110	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Filter