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]	FN	Fn	FIREARMS	Firearms>Magazines	[empty string]	1	48.99	0	53.99	69877-DEFAULT-l.jpg	48.99	69877-DEFAULT-m.jpg	FN HERSTAL PS90 50RD MAG	N	11 JJ	[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]	24	50-to-100	0.00	[empty string]	Fn Herstal Ps90 50rd Mag	Replacement or extra magazine for the PS90.	[empty string]	N	53.99	53.99	[empty string]	69877-DEFAULT-s.jpg	[empty string]	1000	3810110093	107738	EMPTY	EMPTY	EMPTY	0	0	0	MAGAZINES	[empty string]	fn/fn-herstal-ps90-50rd-mag-107738	1
2	[empty string]	FN	Fn	FIREARMS	Firearms>Magazines	[empty string]	1	58.99	1	55.99	69205-DEFAULT-l.jpg	58.99	69205-DEFAULT-m.jpg	308 20 RD BLK	N	11 JJ	308 WIN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2013	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	8	50-to-100	0.00	[empty string]	308 20 Rd Blk	This replacement magazine is for your Scar 17S firearm.	[empty string]	Y	55.99	55.99	[empty string]	69205-DEFAULT-s.jpg	[empty string]	1000	98892	164689	EMPTY	EMPTY	EMPTY	0	0	0	MAGAZINES	[empty string]	fn/308-20-rd-blk-164689	1
3	[empty string]	FN	Fn	FIREARMS	Firearms>Magazines	[empty string]	1	58.99	1	55.99	69204-DEFAULT-l.jpg	58.99	69204-DEFAULT-m.jpg	FN SCAR 17S 20 ROUND MAGAZINE 308WIN	N	11 JJ	308 WIN	[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]	8	50-to-100	0.00	[empty string]	Fn Scar 17s 20 Round Magazine 308win	This replacement magazine is for your Scar 17S firearm.	[empty string]	Y	55.99	55.99	[empty string]	69204-DEFAULT-s.jpg	[empty string]	1000	98890	170598	EMPTY	EMPTY	EMPTY	0	0	0	MAGAZINES	[empty string]	fn/fn-scar-17s-20-round-magazine-308win-170598	1
4	[empty string]	FN	Fn	FIREARMS	Firearms>Pistols	[empty string]	1	0	0	1285	69875-DEFAULT-l.jpg	0	69875-DEFAULT-m.jpg	FN FNX-45 TACTICAL 45ACP SEMI AUTO	N	11 JJ	45 ACP	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	NONE	FN	[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]	Fn Fnx-45 Tactical 45acp Semi Auto	The FNX-45 Tactical is the latest in technological advancements in handgun engineering, offering .45 ACP performance and a host of unique features that no other handgun can match. The checkered polymer frame is offered in Black and Flat Dark Earth and has a low-bore axis for reduced felt recoil and enhanced operator control. Two interchangeable backstraps come standard to quickly customize the grip feel. All operating controls are fully ambidextrous for ease of use. The 5.3` cold hammer-forged, stainless steel barrel has a threaded muzzle to accept sound suppressors, compensators and other accessories. The stainless steel slide has high-profile combat night sights and includes two mounting bases to accept multiple styles of optional red-dot electronic sights. Pistol ships with 3 magazines and a fitted Cordura nylon case.	[empty string]	N	1285	1285	[empty string]	69875-DEFAULT-s.jpg	[empty string]	1000	66968	170695	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	fn/fn-fnx-45-tactical-45acp-semi-auto-170695	1
5	[empty string]	FN	Fn	FIREARMS	Firearms>Rifles	[empty string]	1	1915	0	1915	68168-DEFAULT-l.jpg	1915	68168-DEFAULT-m.jpg	FN PS90 STD 5.7X28 S/A RIFLE	N	11 JJ	5.7X28	16IN	[empty string]	[empty string]	[empty string]	[empty string]	FN	FABRIQUE NATIONALE HERSTAL	[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]	Fn Ps90 Std 5.7x28 S/a Rifle	The PS90 provides a compact, lightweight and completely ambidextrous firearm capable of fulfilling numerous security, personal defense, competition and recreational shooting roles. Fired cases are ejected downward where they cannot interfere with the user. The extended 16.04` barrel and closed bolt operation give the PS90 outstanding accuracy, while the non magnifying optical sight makes it easy to locate and stay on a target. Recoil is reduced by the integral muzzle break.	[empty string]	N	1915	1915	[empty string]	68168-DEFAULT-s.jpg	[empty string]	1000	3848950460	253569	EMPTY	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	fn/fn-ps90-std-5-7x28-s-a-rifle-253569	1
6	[empty string]	FN	Fn	FIREARMS	Firearms>Magazines	[empty string]	1	49.99	0	55.99	70372-DEFAULT-l.jpg	49.99	70372-DEFAULT-m.jpg	FNX-45 15RD 45ACP MAG	N	11 JJ	45 AUTO	[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]	6	50-to-100	0.00	[empty string]	Fnx-45 15rd 45acp Mag	Replacement magazine for FNX-45.	[empty string]	N	55.99	55.99	[empty string]	70372-DEFAULT-s.jpg	[empty string]	1000	66322-5	284554	EMPTY	EMPTY	EMPTY	0	0	0	MAGAZINES	[empty string]	fn/fnx-45-15rd-45acp-mag-284554	1
7	[empty string]	FN	Fn	FIREARMS	Firearms>Magazines	[empty string]	1	39.99	0	44.99	67173-DEFAULT-l.jpg	39.99	67173-DEFAULT-m.jpg	FIVE SEVEN 57X28 20RD MAG	N	11 JJ	5.7X28	[empty string]	[empty string]	[empty string]	[empty string]	[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]	24	25-to-50	0.00	[empty string]	Five Seven 57x28 20rd Mag	[empty string]	[empty string]	N	44.99	44.99	[empty string]	67173-DEFAULT-s.jpg	[empty string]	1000	3866100030	311689	EMPTY	EMPTY	EMPTY	0	0	0	MAGAZINES	[empty string]	fn/five-seven-57x28-20rd-mag-311689	1
8	[empty string]	FN	Fn	FIREARMS	Firearms>Shotguns	[empty string]	1	595	0	645	83687-DEFAULT-l.jpg	595	83687-DEFAULT-m.jpg	FN FN 509M 9MM NMS 15 ROUNDS/A	N	11 JJ	9 X 19	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	NONE	FN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	SEMI AUTO	PISTOL	2	500-or-more	0.00	[empty string]	509 Mid Size - 9mm - Dao - 15+1 Rds - Black Polymer	<p> SPECIFICATIONS:</p> <p>-Model: FN 509 Mid-Size</p> <p>-Item Number: 66100463</p> <p>-Caliber: 9mm</p> <p>-Frame Finish: Black</p> <p>-Action: DAO</p> <p>-Slide Description: Black Steel</p> <p>-Capacity: 15+1</p> <p>-Frame Material: Polymer</p> <p>-Grips: black Interchangeable Backstrap</p> <p>-Hand: Right</p> <p>-Barrel Length: 4"</p> <p>-OAL: 7.40"</p> <p>-Safety: No Manual</p> <p>-Sight Configuration: 3 Dot Contrast</p> <p>-Twist: 1:10"</p> <p>-Weight: 26.50 oz</p> <p>-Barrel Description: Cold Hammer Forged</p> <p> </p> <p> </p> <p> </p>	[empty string]	N	645	645	[empty string]	83687-DEFAULT-s.jpg	[empty string]	1000	66-100463	334321	EMPTY	EMPTY	EMPTY	0	0	0	SHOTGUNS	[empty string]	fn/fn-fn-509m-9mm-nms-15-rounds-a-334321	1
9	[empty string]	FN	Fn	FIREARMS	Firearms>Pistols	[empty string]	1	699	0	750	87440-DEFAULT-l.jpg	699	87440-DEFAULT-m.jpg	FN 509C COMPACT 9MM NMS STRIKER S/A	N	11 JJ	9 X 19	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	NONE	FN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	SEMI AUTO	PISTOL	7	500-or-more	0.00	[empty string]	Fn 509c Compact 9mm Nms Striker S/a	[empty string]	[empty string]	N	750	750	[empty string]	87440-DEFAULT-s.jpg	[empty string]	1000	66-100571	335023	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	fn/fn-509c-compact-9mm-nms-striker-s-a-335023	1
10	[empty string]	FN	Fn	FIREARMS	Firearms>Pistols	[empty string]	1	699	0	750	88268-DEFAULT-l.jpg	699	88268-DEFAULT-m.jpg	FN 509C COMPACT FDE 9MM NMS STRIKER S/A	N	11 JJ	9 X 19	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	NONE	FN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	SEMI AUTO	PISTOL	5	500-or-more	0.00	[empty string]	Fn 509c Compact Fde 9mm Nms Striker S/a	[empty string]	[empty string]	N	750	750	[empty string]	88268-DEFAULT-s.jpg	[empty string]	1000	66-100574	335024	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	fn/fn-509c-compact-fde-9mm-nms-striker-s-a-335024	1
11	[empty string]	FN	Fn	FIREARMS	Firearms>Shotguns	[empty string]	1	579	0	645	87582-DEFAULT-l.jpg	579	87582-DEFAULT-m.jpg	FN FN 509 FDE 9MM NMS STRIKER S/A	N	11 JJ	9 X 19	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	NONE	FN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	NOT ONLINE	SEMI AUTO	PISTOL	2	500-or-more	0.00	[empty string]	Fn Fn 509 Fde 9mm Nms Striker S/a	[empty string]	[empty string]	N	645	645	[empty string]	87582-DEFAULT-s.jpg	[empty string]	1000	66-100489	335025	EMPTY	EMPTY	EMPTY	0	0	0	SHOTGUNS	[empty string]	fn/fn-fn-509-fde-9mm-nms-striker-s-a-335025	1
12	[empty string]	FN	Fn	FIREARMS	Firearms>Pistols	[empty string]	1	920	0	965	88117-DEFAULT-l.jpg	920	88117-DEFAULT-m.jpg	FN 509 TACT 9MM NMS NS STRIKER S/A	N	11 JJ	9 X 19	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	NONE	FN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	SEMI AUTO	PISTOL	3	500-or-more	0.00	[empty string]	Fn 509 Tact 9mm Nms Ns Striker S/a	[empty string]	[empty string]	N	965	965	[empty string]	88117-DEFAULT-s.jpg	[empty string]	1000	66-100375	335026	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	fn/fn-509-tact-9mm-nms-ns-striker-s-a-335026	1
13	[empty string]	FN	Fn	FIREARMS	Firearms>Pistols	[empty string]	1	920	0	965	88265-DEFAULT-l.jpg	920	88265-DEFAULT-m.jpg	FN 509 TACT FDE 9MM NMS NS STRIKER S/A	N	11 JJ	9 X 19	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	NONE	FN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	SEMI AUTO	PISTOL	2	500-or-more	0.00	[empty string]	Fn 509 Tact Fde 9mm Nms Ns Striker S/a	[empty string]	[empty string]	N	965	965	[empty string]	88265-DEFAULT-s.jpg	[empty string]	1000	66-100373	335027	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	fn/fn-509-tact-fde-9mm-nms-ns-striker-s-a-335027	1
14	[empty string]	FN	Fn	FIREARMS	Firearms>Pistols	[empty string]	0	480	0	525	[empty string]	480	[empty string]	FN 503 9MM STRIKER S/A	N	11 JJ	9 X 19	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	NONE	FN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	SEMI AUTO	PISTOL	5	500-or-more	0.00	[empty string]	Fn 503 9mm Striker S/a	[empty string]	[empty string]	N	525	525	[empty string]	[empty string]	[empty string]	1000	66-100098-1	340497	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	fn/fn-503-9mm-striker-s-a-340497	1
15	[empty string]	FN	Fn	FIREARMS	Firearms>Pistols	[empty string]	1	745	0	750	88768-DEFAULT-l.jpg	745	88768-DEFAULT-m.jpg	FN 509M FDE 9MM MRD 15 ROUNDS/A	N	11 JJ	9 X 19	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	NONE	FN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	SEMI AUTO	PISTOL	2	500-or-more	0.00	[empty string]	Fn 509m Fde 9mm Mrd 15 Rounds/a	[empty string]	[empty string]	N	750	750	[empty string]	88768-DEFAULT-s.jpg	[empty string]	1000	66-100741	345140	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	fn/fn-509m-fde-9mm-mrd-15-rounds-a-345140	1
16	[empty string]	FN	Fn	FIREARMS	Firearms>Pistols	[empty string]	0	1380	0	1445	[empty string]	1380	[empty string]	FN 509 LS EDGE 9MM NMS PISTOL SEMI	N	11 JJ	9 X 19	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	NONE	FN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	SEMI AUTO	PISTOL	7	500-or-more	0.00	[empty string]	Fn 509 Ls Edge 9mm Nms Pistol Semi	[empty string]	[empty string]	N	1445	1445	[empty string]	[empty string]	[empty string]	1000	66-100843	347372	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	fn/fn-509-ls-edge-9mm-nms-pistol-semi-347372	1
17	[empty string]	FN	Fn	FIREARMS	Firearms>Pistols	[empty string]	0	1080	0	1195	[empty string]	1080	[empty string]	FN 5.7X28 MODEL FIVE SEVEN FDE PISTOL	N	11 JJ	5.7X28	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FN	FN HERSTAL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	SEMI AUTO	PISTOL	4	500-or-more	0.00	[empty string]	Fn 5.7x28 Model Five Seven Fde Pistol	[empty string]	[empty string]	N	1195	1195	[empty string]	[empty string]	[empty string]	1000	3868900753	354746	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	fn/fn-5-7x28-model-five-seven-fde-pistol-354746	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Filter