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]	8	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]	2	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>Pistols	[empty string]	1	465	0	465	107812-DEFAULT-l.jpg	465	107812-DEFAULT-m.jpg	KEL-TEC PMR-30 22MAG TAN	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	PISTOL	1	450-to-500	0.00	[empty string]	PMR30 - 22 WMR - SAO - 30 RDS - TAN	<ul> <li>Item: Kel-Tec PMR30 Pistol</li> <li>Item Number: PMR30BTAN</li> <li>Caliber: 22 WMR </li> <li> Action: SAO</li> <li>Capacity: 30</li> <li>Frame: Tan Aluminum</li> <li>Slide: Black and Tan Steel</li> <li>Fiber Optic Sight - HiViz Front and Rear</li> <li>Tan Textured Polymer Grip</li> <li>Barrel: 4.30" Fluted Steel</li> <li>Picatinny Rail</li> <li>Weight: 14 oz</li> </ul> <p> </p> <p> </p>	[empty string]	N	465	465	[empty string]	107812-DEFAULT-s.jpg	[empty string]	1000	PMR30BTAN	245335	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	kel-tec/pmr30-22-wmr-sao-30-rds-tan-245335	1
5	[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
6	[empty string]	KELTEC	Kel Tec	FIREARMS	Firearms>Pistols	[empty string]	1	495	0	495	83558-DEFAULT-l.jpg	495	83558-DEFAULT-m.jpg	CP-33 BLACK 22LR 33 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	450-to-500	0.00	[empty string]	Cp33 - 22 Lr - Sa - 33+1 Rds - Black Polymer	<p> SPECIFICATIONS:</p> <p>-Model: Kel-Tec</p> <p>-Item Number: CP33BLK</p> <p>-Caliber: 22 LR</p> <p>-Frame Finish: black</p> <p>-Action: Semi-Auto</p> <p>-Slide: Black</p> <p>-Capacity: 33+1</p> <p>-Frame Material: Polymer</p> <p>-Grips: Black Polymer</p> <p>-Hand: Right</p> <p>-Barrel Length: 5.50"</p> <p>-OAL; 10.60"</p> <p>-Safety: Ambidextrous Manual</p> <p>-Sight Configuration: Fiber Optic</p> <p>-Sight Style: Adjustable</p> <p>-Weight: 1.50 lbs</p> <p> </p>	[empty string]	N	495	495	[empty string]	83558-DEFAULT-s.jpg	[empty string]	1000	CP33BLK	325624	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	kel-tec/cp-33-black-22lr-33-round-mag-pistol-325624	1
7	[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	1	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

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Filter