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]	CRIMSON TRACE LASERS	Crimson Trace Lasers	OPTICS	Optics>Sights	[empty string]	1	349.99	0	349.99	24867-DEFAULT-l.jpg	349.99	24867-DEFAULT-m.jpg	LASER GRIP GOVT/COMMANDER 1911/1991A	N	16 DEVON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	4	300-to-350	0.00	[empty string]	Laser Grip - Govt/commander - 1911/1991a	<p>The flagship LG-401 is our most popular 1911 laser sight model for Government and Commander variants. Featuring a rugged polymer side panels and a rubber overmold activation button, these are the recommended Lasergrips for most 1911 shooters.Standard to Crimson Trace Lasergrips, the LG-401 features instinctive activation. This means that the laser sight automatically springs to life when the weapon is held in a natural firing grip.<br /> <br /> NOTE: Gun not included!</p>	[empty string]	N	349.99	349.99	[empty string]	24867-DEFAULT-s.jpg	[empty string]	1000	LG-401	17416	EMPTY	EMPTY	EMPTY	0	0	0	SIGHTS	[empty string]	crimson-trace-lasers/laser-grip-govt-commander-1911-1991a-17416	1
2	[empty string]	CRIMSON TRACE LASERS	Crimson Trace Lasers	OPTICS	Optics>Sights	[empty string]	1	239.99	0	239.99	24906-DEFAULT-l.jpg	239.99	24906-DEFAULT-m.jpg	LASER GRIP RUGER LCP	N	16 DEVON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	9	200-to-250	0.00	[empty string]	Laser Grip - Ruger Lcp	<p>The LG-431 is a no-brainer when it comes to bolstering the defensive capabilities of your Ruger LCP. The LG-431 laser sight seamlessly attaches to the trigger guard and features instinctive front activation: the laser immediately springs to life as you hold the pistol naturally. The beam is projected from just underneath the muzzle, immediately increasing your accuracy with the LCP. Don’t forget a custom holster - available exclusively for your Ruger LCP with Crimson Trace Laserguard.<br /> <br /> NOTE: Gun not included!</p>	[empty string]	N	239.99	239.99	[empty string]	24906-DEFAULT-s.jpg	[empty string]	1000	LG-431	89107	EMPTY	EMPTY	EMPTY	0	0	0	SIGHTS	[empty string]	crimson-trace-lasers/laser-grip-ruger-lcp-89107	1
3	[empty string]	CRIMSON TRACE LASERS	Crimson Trace Lasers	OPTICS	Optics>Sights	[empty string]	1	209	0	209	24998-DEFAULT-l.jpg	209	24998-DEFAULT-m.jpg	LASER GRIP RUGER LCP W/ HOLSTER	N	16 DEVON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	1	200-to-250	0.00	[empty string]	Laser Grip - Ruger Lcp - Holster	<p>The revolutionary LG-431 is a no-brainer when it comes to bolstering the defensive capabilities of your Ruger LCP. The LG-431 laser sight seamlessly attaches to the trigger guard and features instinctive front activation: the laser immediately springs to life as you hold the pistol naturally. The beam is projected from just underneath the muzzle, immediately increasing your accuracy with the LCP.<br /> <br /> NOTE: Gun not included!</p>	[empty string]	N	209	209	[empty string]	24998-DEFAULT-s.jpg	[empty string]	1000	LG-431H	128873	EMPTY	EMPTY	EMPTY	0	0	0	SIGHTS	[empty string]	crimson-trace-lasers/laser-grip-ruger-lcp-w-holster-128873	1
4	[empty string]	CRIMSON TRACE LASERS	Crimson Trace Lasers	OPTICS	Optics>Sights	[empty string]	1	239.99	0	239.99	71628-DEFAULT-l.jpg	239.99	71628-DEFAULT-m.jpg	LASER GRIP GLOCK 42	N	16 DEVON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2014	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	3	200-to-250	0.00	[empty string]	Laser Grip Kel Tec P3at	The groundbreaking LG-430 laser sight for Kel-Tec P-3AT and P-32 pistols was the first laser sight application Crimson Trace developed. This unique design mounts seamlessly onto the trigger guard, placing the laser diode directly under the muzzle. A front-located pressure switch activates the Laserguard with instinctive activation as the weapon is held in a natural firing grip. Fully adjustable for windage and elevation, the sleek LG-430 is the most fully-featured laser sighting system available for Kel-Tec pistols.<br/> <br/> NOTE: Gun not included!<br/>	[empty string]	N	239.99	239.99	[empty string]	71628-DEFAULT-s.jpg	[empty string]	1000	LG-443	178928	EMPTY	EMPTY	EMPTY	0	0	0	SIGHTS	[empty string]	crimson-trace-lasers/laser-grip-glock-42-178928	1
5	[empty string]	CRIMSON TRACE LASERS	Crimson Trace Lasers	OPTICS	Optics>Red Dot	[empty string]	1	239.99	0	239.99	62557-DEFAULT-l.jpg	239.99	62557-DEFAULT-m.jpg	RAIL MASTER UNIVERSAL LASER SIGHT GREEN	N	16 DEVON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	MAP	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2016	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	1	200-to-250	0.00	[empty string]	Cmr-206 Rail Master - Universal Green Laser Sight	<p>The CMR-206 Rail Master is compact, yet powerful, universal green laser sight designed to fit rail-equipped pistols, rifles and shotguns. The laser sight fits onto virtually any firearm with a modern (M1913 Picatinny or Weaver-style) accessory rail. Ambidextrous control tabs allow the user to instantly activate or deactivate the laser.</p> <p>The human eye processes the color green more effectively than any other color, and Crimson Trace offers the brightest green laser allowed by law, (5mW peak, 515nm, Class 3R). The CMR-206 Rail Master boasts 2 hours of (constant) run time on a single 1/3N Lithium battery, and features a 5 minute auto shut-off for power conservation.</p> <p> </p> <p>-Offers 3 modes of operation: Momentary, Strobe, and Constant-On<br /> -Allows the user to easily set their mode based on personal need or preference<br /> -Quickly and easily user-installed in moments<br /> -Can be painlessly transferred from firearm to firearm<br /> -Securely fastened using Crimson Trace's Secure Lock Technology</p>	[empty string]	N	239.99	239.99	[empty string]	62557-DEFAULT-s.jpg	[empty string]	1000	CMR-206	262695	EMPTY	EMPTY	EMPTY	0	0	0	RED DOT	[empty string]	crimson-trace-lasers/rail-master-universal-laser-sight-green-262695	1
6	[empty string]	CRIMSON TRACE LASERS	Crimson Trace Lasers	OPTICS	Optics>Sights	[empty string]	0	199	0	199	[empty string]	199	[empty string]	LASERGUARD SW SHIELD 45	N	16 DEVON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2017	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	1	150-to-200	0.00	[empty string]	Laserguard Sw Shield 45	[empty string]	[empty string]	N	199	199	[empty string]	[empty string]	[empty string]	1000	LL-485	281783	EMPTY	EMPTY	EMPTY	0	0	0	SIGHTS	[empty string]	crimson-trace-lasers/laserguard-sw-shield-45-281783	1
7	[empty string]	CRIMSON TRACE LASERS	Crimson Trace Lasers	OPTICS	Optics>Sights	[empty string]	1	239.99	0	239.99	66672-DEFAULT-l.jpg	239.99	66672-DEFAULT-m.jpg	RUGER LCPII LASERGUARD	N	16 DEVON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2018	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	3	200-to-250	0.00	[empty string]	Ruger Lcpii Laserguard	The Laserguard for Ruger LCP II fits seamlessly to the trigger guard of Ruger's polymer-framed carry gun and features the classic Crimson Trace instinctive activation system. Factory sighted at 50', the laser is also fully user-adjustable for windage and elevation using the provided tool. The laser is activated when the firearm is held in a normal firing grip via a front activation button. This Laserguard has a red laser.	[empty string]	N	239.99	239.99	[empty string]	66672-DEFAULT-s.jpg	[empty string]	1000	LG-497	299513	EMPTY	EMPTY	EMPTY	0	0	0	SIGHTS	[empty string]	crimson-trace-lasers/ruger-lcpii-laserguard-299513	1
8	[empty string]	CRIMSON TRACE LASERS	Crimson Trace Lasers	OPTICS	Optics>Sights	[empty string]	1	319.99	0	319.99	86741-DEFAULT-l.jpg	319.99	86741-DEFAULT-m.jpg	RUGER LC9 LASERGUARD GREEN	N	16 DEVON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2018	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	1	300-to-350	0.00	[empty string]	Ruger Lc9 Laserguard Green	The Crimson Trace Laserguard is a compact laser sight. The laser sight attaches firmly around the trigger guard, and features Crimson Trace's famed Instinctive Activation, which allows the laser to be activated by simply gripping the pistol in a normal firing grip. It provides two (2) hours of run time on a single 1/3N battery (provided). Easily user-installed in moments with no alterations to the firearm, the Laserguard is fully adjustable for windage and elevation. This green model is compatible with Ruger LC9/9S, LC380, EC9s.	[empty string]	N	319.99	319.99	[empty string]	86741-DEFAULT-s.jpg	[empty string]	1000	LG-416G	303137	EMPTY	EMPTY	EMPTY	0	0	0	SIGHTS	[empty string]	crimson-trace-lasers/ruger-lc9-laserguard-green-303137	1
9	[empty string]	CRIMSON TRACE LASERS	Crimson Trace Lasers	OPTICS	Optics>Sights	[empty string]	1	319.99	0	319.99	85692-DEFAULT-l.jpg	319.99	85692-DEFAULT-m.jpg	RUGER LCP II LASERGUARD GREEN	N	16 DEVON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2018	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	2	300-to-350	0.00	[empty string]	Ruger Lcp Ii Laserguard Green	[empty string]	[empty string]	N	319.99	319.99	[empty string]	85692-DEFAULT-s.jpg	[empty string]	1000	LG-497G	304808	EMPTY	EMPTY	EMPTY	0	0	0	SIGHTS	[empty string]	crimson-trace-lasers/ruger-lcp-ii-laserguard-green-304808	1
10	[empty string]	CRIMSON TRACE LASERS	Crimson Trace Lasers	OPTICS	Optics>Red Dot	[empty string]	1	449.99	0	449.99	88273-DEFAULT-l.jpg	449.99	88273-DEFAULT-m.jpg	ELECTRONIC SIGHT 3.25 MOA DOT	N	8 DEVON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	MAP	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2019	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	13	400-to-450	0.00	[empty string]	Electronic Sight 3.25 Moa Dot	[empty string]	[empty string]	N	449.99	449.99	[empty string]	88273-DEFAULT-s.jpg	[empty string]	1000	CTS-1400	310271	EMPTY	EMPTY	EMPTY	0	0	0	RED DOT	[empty string]	crimson-trace-lasers/electronic-sight-3-25-moa-dot-310271	1
11	[empty string]	CRIMSON TRACE LASERS	Crimson Trace Lasers	OPTICS	Optics>Sights	[empty string]	1	239.99	0	239.99	88128-DEFAULT-l.jpg	239.99	88128-DEFAULT-m.jpg	LASERGUARD SIG SAUER P365 RED LASER	N	16 DEVON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2019	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	3	200-to-250	0.00	[empty string]	Laserguard Sig Sauer P365 Red Laser	[empty string]	[empty string]	N	239.99	239.99	[empty string]	88128-DEFAULT-s.jpg	[empty string]	1000	LG-422	314052	EMPTY	EMPTY	EMPTY	0	0	0	SIGHTS	[empty string]	crimson-trace-lasers/laserguard-sig-sauer-p365-red-laser-314052	1
12	[empty string]	CRIMSON TRACE LASERS	Crimson Trace Lasers	OPTICS	Optics>Sights	[empty string]	1	179.99	0	179.99	88274-DEFAULT-l.jpg	179.99	88274-DEFAULT-m.jpg	LASERSADDLE MOSSBERG 500 12GA 590 59A1	N	16 DEVON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2019	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	2	150-to-200	0.00	[empty string]	Lasersaddle Mossberg 500 12ga 590 59a1	[empty string]	[empty string]	N	179.99	179.99	[empty string]	88274-DEFAULT-s.jpg	[empty string]	1000	LS-250	314054	EMPTY	EMPTY	EMPTY	0	0	0	SIGHTS	[empty string]	crimson-trace-lasers/lasersaddle-mossberg-500-12ga-590-59a1-314054	1
13	[empty string]	CRIMSON TRACE LASERS	Crimson Trace Lasers	OPTICS	Optics>Sights	[empty string]	0	349.99	0	349.99	[empty string]	349.99	[empty string]	LASERGUARD RED RUGER EC9S/LC9/LC9S/LC380	N	16 DEVON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2019	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	3	300-to-350	0.00	[empty string]	Laserguard Red Ruger Ec9s/lc9/lc9s/lc380	[empty string]	[empty string]	N	349.99	349.99	[empty string]	[empty string]	[empty string]	1000	LG-417	317197	EMPTY	EMPTY	EMPTY	0	0	0	SIGHTS	[empty string]	crimson-trace-lasers/laserguard-red-ruger-ec9s-lc9-lc9s-lc380-317197	1
14	[empty string]	CRIMSON TRACE LASERS	Crimson Trace Lasers	OPTICS	Optics>Red Dot	[empty string]	0	199.99	0	199.99	[empty string]	199.99	[empty string]	RAIL MASTER UNIVERSAL MOUNT	N	8 DEVON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	MAP	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	2	150-to-200	0.00	[empty string]	Rail Master Universal Mount	[empty string]	[empty string]	N	199.99	199.99	[empty string]	[empty string]	[empty string]	1000	CMR-207	344611	EMPTY	EMPTY	EMPTY	0	0	0	RED DOT	[empty string]	crimson-trace-lasers/rail-master-universal-mount-344611	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Filter