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]	EOTECH	Eotech	OPTICS	Optics>Scopes	[empty string]	1	475	0	475	64911-DEFAULT-l.jpg	475	64911-DEFAULT-m.jpg	WEAPONS SIGHT 512.A65 HWS SIGHT	N	8 TOM	[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	[empty string]	[empty string]	[empty string]	5	450-to-500	0.00	[empty string]	Weapons Sight 512.a65 Hws Sight	EOTech`s Model 512 is the most popular holographic weapon sight. This tactical optic is perfect for agencies that want the best in CQB speed and versatility without the need for night vision compatibility. This model requires two AA batteries (lithium, alkaline, or rechargeable) and features a 68 MOA circular reticle with a 1 MOA aiming dot. The rugged aluminum hood assembly and knobbed, tool-less mounting bolt easily interface with a 1` Picatinny (MIL-STD 1913) or Weaver rail. This model is submersible to 3 meters.	[empty string]	N	475	475	[empty string]	64911-DEFAULT-s.jpg	[empty string]	1000	512.A65	23251	EMPTY	EMPTY	EMPTY	0	0	0	SCOPES	[empty string]	eotech/weapons-sight-512-a65-hws-sight-23251	1
2	[empty string]	EOTECH	Eotech	OPTICS	Optics>Scopes	[empty string]	1	575	0	575	64916-DEFAULT-l.jpg	575	64916-DEFAULT-m.jpg	WEAPONS SIGHT 552.A65/1 MIL HWS	N	8 TOM	[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	[empty string]	[empty string]	[empty string]	3	500-or-more	0.00	[empty string]	Weapons Sight 552.a65/1 Mil Hws	The HWS excels in superior speed, extra wide field of view, the dual use reticle and rugged design. The HWS provides incredibly fast and accurate target acquisition under any lighting conditions, offers outstanding night vision compatibility with 10 settings for NV use, utilizes standard AA batteries, and is submersible in water to a depth of 33-feet.	[empty string]	N	575	575	[empty string]	64916-DEFAULT-s.jpg	[empty string]	1000	552.A65	23254	EMPTY	EMPTY	EMPTY	0	0	0	SCOPES	[empty string]	eotech/weapons-sight-552-a65-1-mil-hws-23254	1
3	[empty string]	EOTECH	Eotech	OPTICS	Optics>Scopes	[empty string]	1	545	0	545	67670-DEFAULT-l.jpg	545	67670-DEFAULT-m.jpg	WEAPONS SIGHT CR123 BATTERY 65/1 MOA	N	8 TOM	[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	[empty string]	[empty string]	[empty string]	7	500-or-more	0.00	[empty string]	Weapons Sight Cr123 Battery 65/1 Moa	The XPS2 is the shortest, smallest and lightest EOTech model holographic weapon sight available without night vision. It also has a longer battery life than the N-cell style sights. The single battery configuration allows more rail space than ever, leaving more room for rear iron sights or magnification. It has 20 brightness settings and a scrolling feature, and it is submersible to 3 meters. XPS has a locking quick detach lever and a 65 MOA circle with 1 MOA dots, a 7mm raised base, and easily adjustable side buttons.	[empty string]	N	545	545	[empty string]	67670-DEFAULT-s.jpg	[empty string]	1000	XPS2-0	103493	EMPTY	EMPTY	EMPTY	0	0	0	SCOPES	[empty string]	eotech/weapons-sight-cr123-battery-65-1-moa-103493	1
4	[empty string]	EOTECH	Eotech	OPTICS	Optics>Scopes	[empty string]	1	589	0	589	69304-DEFAULT-l.jpg	589	69304-DEFAULT-m.jpg	WEAPONS SIGHT 1 MOA SIDE BUTTONS CR123	N	8 TOM	[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	NOT ONLINE	[empty string]	[empty string]	3	500-or-more	0.00	[empty string]	Weapons Sight 1 Moa Side Buttons Cr123	The EXPS2 offers true 2-eyes-open shooting and provides an unparalleled targeting experience. The increased height of the EXPS provides iron sight co-witness access in the lower third of the viewing window. The all-purpose EXPS2 features easily adjustable side buttons and a quick-detach lever (fits both 1" Weaver and MIL-STD-1913 rail). It has a transversely-mounted lithium 123 battery which operates for 600 continuous hours at nominal setting 12 at room temp. It has 20 brightness settings and a scrolling feature, and it is submersible to 3 meters. The EXPS reticle has a 68 MOA circle with a (2)MOA dots.	[empty string]	N	589	589	[empty string]	69304-DEFAULT-s.jpg	[empty string]	1000	EXPS2-2	126535	EMPTY	EMPTY	EMPTY	0	0	0	SCOPES	[empty string]	eotech/weapons-sight-1-moa-side-buttons-cr123-126535	1
5	[empty string]	EOTECH	Eotech	OPTICS	Optics>Scopes	[empty string]	1	589	0	589	69302-DEFAULT-l.jpg	589	69302-DEFAULT-m.jpg	WEAPONS SIGHT	N	8 TOM	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	3	500-or-more	0.00	[empty string]	Weapons Sight	The EXPS2 offers true 2-eyes-open shooting and provides an unparalleled targeting experience. The increased height of the EXPS provides iron sight co-witness access in the lower third of the viewing window. The all-purpose EXPS2 features easily adjustable side buttons and a quick-detach lever (fits both 1` Weaver and MIL-STD-1913 rail). It has a transversely-mounted lithium 123 battery which operates for 600 continuous hours at nominal setting 12 at room temp. It has 20 brightness settings and a scrolling feature, and it is submersible to 3 meters. The EXPS reticle has a 68 MOA circle with a 1 MOA dot.	[empty string]	N	589	589	[empty string]	69302-DEFAULT-s.jpg	[empty string]	1000	EXPS2-0	148567	EMPTY	EMPTY	EMPTY	0	0	0	SCOPES	[empty string]	eotech/weapons-sight-148567	1
6	[empty string]	EOTECH	Eotech	OPTICS	Optics>Scopes	[empty string]	1	1109	0	1109	69306-DEFAULT-l.jpg	1109	69306-DEFAULT-m.jpg	HOLOGRAPHIC HYBRID SIGHT	N	8 TOM	[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	[empty string]	[empty string]	[empty string]	1	500-or-more	0.00	[empty string]	Holographic Hybrid Sight	The Holographic Hybrid Sight II (HHS II) has an EXPS2-2 with a G33.STS magnifier. Offering true 2 eyes open shooting, a transversely mounted lithium 123 battery, and 7 mm raised base offering iron sight access, the EXPS2 features easy to adjust side buttons and a single, quick release throw lever for easy attachment and removal. Regardless of the scenario, it provides an unparalleled advantage when transitioning from short-range to long-range shooting. The quick switch-to-side (STS) mount offers a simple, instant disengagement of the magnifier. The G33.STS magnifier is shorter and lighter than previous models, with an improved mount for faster transitioning from 3x to 1x. The G33 offers tool free azimuth adjustment, a larger field-of-view and an adjustable diopter for improved, precise focusing. The HHS II combination is the perfect setup for hunting when your target is on the move.	[empty string]	N	1109	1109	[empty string]	69306-DEFAULT-s.jpg	[empty string]	1000	HHS2	149063	EMPTY	EMPTY	EMPTY	0	0	0	SCOPES	[empty string]	eotech/holographic-hybrid-sight-149063	1
7	[empty string]	EOTECH	Eotech	OPTICS	Optics>Red Dot	[empty string]	1	545	0	545	72194-DEFAULT-l.jpg	545	72194-DEFAULT-m.jpg	WEAPONS SIGHT 518.A65	N	8 TOM	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2016	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	3	500-or-more	0.00	[empty string]	Weapons Sight 518.a65	EOTech's highly functional and easy-to-use 518 Holographic Weapon Sight features the quick-release base and side-button functionality of the EXPS series, but runs on AA batteries (lithium or alkaline). Side-button functionality reduces rail space when partnering this HWS with a magnifier, and the 518 is compatible with the G33 Magnifier and Laser Battery Cap (not included). This 518 model reticle pattern is a 68 MOA ring with 1 MOA dot. Ideal for fast target acquisition, it provides three usable aiming points (based on .223 Cal. 62 GR 2,900 Vel.)	[empty string]	N	545	545	[empty string]	72194-DEFAULT-s.jpg	[empty string]	1000	518.A65	265878	EMPTY	EMPTY	EMPTY	0	0	0	RED DOT	[empty string]	eotech/weapons-sight-518-a65-265878	1
8	[empty string]	EOTECH	Eotech	OPTICS	Optics>Scopes	[empty string]	1	689	0	689	87913-DEFAULT-l.jpg	689	87913-DEFAULT-m.jpg	WEAPONS SIGHT CR123 BATTERY 68 MOA GREEN	N	8 TOM	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2020	[empty string]	[empty string]	SO	[empty string]	[empty string]	[empty string]	3	500-or-more	0.00	[empty string]	Weapons Sight Cr123 Battery 68 Moa Green	[empty string]	[empty string]	N	689	689	[empty string]	87913-DEFAULT-s.jpg	[empty string]	1000	EXPS2-0GRN	311528	EMPTY	EMPTY	EMPTY	0	0	0	SCOPES	[empty string]	eotech/weapons-sight-cr123-battery-68-moa-green-311528	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Filter