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]	ATN	Atn	OPTICS	Optics>Night Vision	[empty string]	1	699.99	0	699.99	67968-DEFAULT-l.jpg	699.99	67968-DEFAULT-m.jpg	X-SIGHT-4K SMART HD DAY NIGHT 3-14X	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]	2018	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	3	500-or-more	0.00	[empty string]	X-sight-4k Smart Hd Day Night 3-14x	<p>The X-Sight 4K Pro is an Ultra HD Optic with ATN's revolutionary Ultra HD Day/Night Sensor that gives you an incredibly crisp picture from a distance. It can record video in 1080p resolution at 120 FPS and stream at 720p, so you don't miss another opportunity to capture that once in a lifetime moment. This scope is easy to mount with 30mm standard rings and it's easy to use with the zoom wheel and classical ergonomic buttons. Sighting in your 4K Pro with One Shot Zero easy; take a shot to adjust your reticle and you are ready to hunt. It also features a smart range finder that is fast and easy to make a good distance estimate to your target. This model has a 3-14x magnification. It comes with some accessories including an eyecup, sunshade, standard rings (2pcs), L-Shape ring, Ring with picatinny rail, UBS-C cable, scope cover and a lens tissue.</p>	[empty string]	N	699.99	699.99	[empty string]	67968-DEFAULT-s.jpg	[empty string]	1000	DGWSXS3144KP	299809	EMPTY	EMPTY	EMPTY	0	0	0	NIGHT VISION	[empty string]	atn/x-sight-4k-smart-hd-day-night-3-14x-299809	1
2	[empty string]	ATN	Atn	OPTICS	Optics>Night Vision	[empty string]	1	799.99	0	799.99	67193-DEFAULT-l.jpg	799.99	67193-DEFAULT-m.jpg	X-SIGHT-4K SMART HD DAY NIGHT 5-20X	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]	2018	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	2	500-or-more	0.00	[empty string]	X-sight-4k Smart Hd Day Night 5-20x	<p>The X-Sight 4K Pro is an Ultra HD Optic with ATN's revolutionary Ultra HD Day/Night Sensor that gives you an incredibly crisp picture from a distance. It can record video in 1080p resolution at 120 FPS and stream at 720p, so you don't miss another opportunity to capture that once in a lifetime moment. This scope is easy to mount with 30mm standard rings and it's easy to use with the zoom wheel and classical ergonomic buttons. Sighting in your 4K Pro with One Shot Zero easy; take a shot to adjust your reticle and you are ready to hunt. It also features a smart range finder that is fast and easy to make a good distance estimate to your target. This model has a 5-20x magnification. It comes with some accessories including an eyecup, sunshade, standard rings (2pcs), L-Shape ring, Ring with picatinny rail, UBS-C cable, scope cover and a lens tissue.</p>	[empty string]	N	799.99	799.99	[empty string]	67193-DEFAULT-s.jpg	[empty string]	1000	DGWSXS5204KP	299810	EMPTY	EMPTY	EMPTY	0	0	0	NIGHT VISION	[empty string]	atn/x-sight-4k-smart-hd-day-night-5-20x-299810	1
3	[empty string]	ATN	Atn	OPTICS	Optics>Night Vision	[empty string]	0	1199	0	1199	[empty string]	1199	[empty string]	THOR-LT 3-6 THERMAL RIFLE SCOPE	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]	3	500-or-more	0.00	[empty string]	Thor-lt 3-6 Thermal Rifle Scope	[empty string]	[empty string]	N	1199	1199	[empty string]	[empty string]	[empty string]	1000	TIWSTLT136X	315590	EMPTY	EMPTY	EMPTY	0	0	0	NIGHT VISION	[empty string]	atn/thor-lt-3-6-thermal-rifle-scope-315590	1
4	[empty string]	ATN	Atn	OPTICS	Optics>Night Vision	[empty string]	0	1399	0	1399	[empty string]	1399	[empty string]	THOR-LT 4-8 THERMAL RIFLE SCOPE	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]	3	500-or-more	0.00	[empty string]	Thor-lt 4-8 Thermal Rifle Scope	[empty string]	[empty string]	N	1399	1399	[empty string]	[empty string]	[empty string]	1000	TIWSTLT148X	315591	EMPTY	EMPTY	EMPTY	0	0	0	NIGHT VISION	[empty string]	atn/thor-lt-4-8-thermal-rifle-scope-315591	1
5	[empty string]	ATN	Atn	OPTICS	Optics>Night Vision	[empty string]	1	1999	0	1999	87880-DEFAULT-l.jpg	1999	87880-DEFAULT-m.jpg	THOR 4 1.25-5X THERMAL SCOPE 384X288 HD	N	8 DEVON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	MAP	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2019	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	2	500-or-more	0.00	[empty string]	Thor 4 1.25-5x Thermal Scope 384x288 Hd	[empty string]	[empty string]	N	1999	1999	[empty string]	87880-DEFAULT-s.jpg	[empty string]	1000	TIWST4381A	315592	EMPTY	EMPTY	EMPTY	0	0	0	NIGHT VISION	[empty string]	atn/thor-4-1-25-5x-thermal-scope-384x288-hd-315592	1
6	[empty string]	ATN	Atn	OPTICS	Optics>Range Finders	[empty string]	1	379	0	379	86885-DEFAULT-l.jpg	379	86885-DEFAULT-m.jpg	ABL SMART RANGEFINDER 1500YRD BLUE TOOTH	N	8 DEVON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	MAP	[empty string]	[empty string]	HUNTING	[empty string]	[empty string]	[empty string]	2019	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	2	350-to-400	0.00	[empty string]	Abl Smart Rangefinder 1500yrd Blue Tooth	[empty string]	[empty string]	N	379	379	[empty string]	86885-DEFAULT-s.jpg	[empty string]	1000	ACMUABL1500	315599	EMPTY	EMPTY	EMPTY	0	0	0	RANGE FINDERS	[empty string]	atn/abl-smart-rangefinder-1500yrd-blue-tooth-315599	1
7	[empty string]	ATN	Atn	OPTICS	Optics>Night Vision	[empty string]	1	899	0	899	87881-DEFAULT-l.jpg	899	87881-DEFAULT-m.jpg	X-4K DAY/NIGHT BINOCULAR 4-16 W/LASER RANGEFINDER	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]	1	500-or-more	0.00	[empty string]	X-4k Day/night Binocular 4-16 W/laser Rangefinder	[empty string]	[empty string]	N	899	899	[empty string]	87881-DEFAULT-s.jpg	[empty string]	1000	DGBNBN4KLRF	315605	EMPTY	EMPTY	EMPTY	0	0	0	NIGHT VISION	[empty string]	atn/x-4k-day-night-binocular-4-16-w-laser-rangefinder-315605	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Filter