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	58.99	0	58.99	69877-DEFAULT-l.jpg	58.99	69877-DEFAULT-m.jpg	FN HERSTAL PS90 50RD MAG	N	11 JJ	[empty string]	[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]	4	50-to-100	0.00	[empty string]	Fn Herstal Ps90 50rd Mag	Replacement or extra magazine for the PS90.	[empty string]	N	58.99	58.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	61.99	0	61.99	69205-DEFAULT-l.jpg	61.99	69205-DEFAULT-m.jpg	308 20 RD BLK	N	11 JJ	308 WIN	[empty string]	[empty string]	[empty string]	ADULT SIGNATURE	[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]	N	61.99	61.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	61.99	0	61.99	69204-DEFAULT-l.jpg	61.99	69204-DEFAULT-m.jpg	FN SCAR 17S 20 ROUND MAGAZINE 308WIN	N	11 JJ	308 WIN	[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]	11	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]	N	61.99	61.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	1280	0	1280	69875-DEFAULT-l.jpg	1280	69875-DEFAULT-m.jpg	FN FNX-45 TACTICAL 45ACP SEMI AUTO	N	11 JJ	45 ACP	[empty string]	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[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 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	1280	1280	[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>Magazines	[empty string]	1	59.99	0	59.99	70372-DEFAULT-l.jpg	59.99	70372-DEFAULT-m.jpg	FNX-45 15RD 45ACP MAG	N	11 JJ	45 AUTO	[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]	5	50-to-100	0.00	[empty string]	Fnx-45 15rd 45acp Mag	Replacement magazine for FNX-45.	[empty string]	N	59.99	59.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
6	[empty string]	FN	Fn	FIREARMS	Firearms>Magazines	[empty string]	1	49.99	0	49.99	67173-DEFAULT-l.jpg	49.99	67173-DEFAULT-m.jpg	FIVE SEVEN 57X28 20RD MAG	N	11 JJ	5.7X28	[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]	9	25-to-50	0.00	[empty string]	Five Seven 57x28 20rd Mag	[empty string]	[empty string]	N	49.99	49.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
7	[empty string]	FN	Fn	FIREARMS	Firearms>Pistols	[empty string]	1	675	0	675	83687-DEFAULT-l.jpg	675	83687-DEFAULT-m.jpg	FN FN 509M 9MM NMS 15 ROUNDS/A	N	11 JJ	9 X 19	[empty string]	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[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	675	675	[empty string]	83687-DEFAULT-s.jpg	[empty string]	1000	66-100463	334321	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	fn/fn-fn-509m-9mm-nms-15-rounds-a-334321	1
8	[empty string]	FN	Fn	FIREARMS	Firearms>Pistols	[empty string]	1	780	0	780	88268-DEFAULT-l.jpg	780	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]	FIREARM SHIP CHARGE FOR WEB	[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 509c Compact Fde 9mm Nms Striker S/a	[empty string]	[empty string]	N	780	780	[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
9	[empty string]	FN	Fn	FIREARMS	Firearms>Pistols>Semi Auto Pistols	[empty string]	1	675	0	675	87582-DEFAULT-l.jpg	675	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]	FIREARM SHIP CHARGE FOR WEB	[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	675	675	[empty string]	87582-DEFAULT-s.jpg	[empty string]	1000	66-100489	335025	SEMI AUTO PISTOLS	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	fn/fn-fn-509-fde-9mm-nms-striker-s-a-335025	1
10	[empty string]	FN	Fn	FIREARMS	Firearms>Pistols	[empty string]	1	995	0	995	88117-DEFAULT-l.jpg	995	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]	FIREARM SHIP CHARGE FOR WEB	[empty string]	NONE	FN	[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 509 Tact 9mm Nms Ns Striker S/a	[empty string]	[empty string]	N	995	995	[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
11	[empty string]	FN	Fn	FIREARMS	Firearms>Pistols	[empty string]	1	995	0	995	88265-DEFAULT-l.jpg	995	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]	FIREARM SHIP CHARGE FOR WEB	[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	995	995	[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
12	[empty string]	FN	Fn	FIREARMS	Firearms>Pistols	[empty string]	1	495	0	495	99878-DEFAULT-l.jpg	495	99878-DEFAULT-m.jpg	FN 503 9MM STRIKER S/A	N	11 JJ	9 X 19	[empty string]	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[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	450-to-500	0.00	[empty string]	503 - 9MM - STRIKER FIRE - 6 RDS - MATTE BLACK	<ul> <li>Item: FN 503</li> <li>Item Number: 66-100098-1</li> <li>Caliber: 9mm Luger</li> <li>Capacity: 6</li> <li>Action: Striker Fire</li> <li>Barrel Length: 3.10"</li> <li>OAL: 5.90"</li> <li>Sights: Contrast</li> <li>Finish: Matte Black</li> <li>Grips: Black Textured Polymer</li> <li>Safety: Loaded Chamber Indicator</li> </ul>	[empty string]	N	495	495	[empty string]	99878-DEFAULT-s.jpg	[empty string]	1000	66-100098-1	340497	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	fn/503-9mm-striker-fire-6-rds-matte-black-340497	1
13	[empty string]	FN	Fn	FIREARMS	Firearms>Pistols	[empty string]	1	780	0	780	88768-DEFAULT-l.jpg	780	88768-DEFAULT-m.jpg	FN 509M FDE 9MM MRD 15 ROUNDS/A	N	11 JJ	9 X 19	[empty string]	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[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	780	780	[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
14	[empty string]	FN	Fn	FIREARMS	Firearms>Pistols	[empty string]	1	1399	0	1399	100065-DEFAULT-l.jpg	1399	100065-DEFAULT-m.jpg	FN 509 LS EDGE 9MM NMS PISTOL SEMI	N	11 JJ	9 X 19	[empty string]	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[empty string]	NONE	FN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	SEMI AUTO	PISTOL	6	500-or-more	0.00	[empty string]	509 LS EDGE - 9MM - DAO - 17 RDS - GRAPHITE PVD - OPTIC READY	<ul> <li>Item: FN 509 LS EDGE - Optic Ready</li> <li>Item Number: 66-100843</li> <li>Caliber: 9mm Luger</li> <li>Action: DAO </li> <li>Rounds: 17</li> <li>Barrel Length: 5"</li> <li>OAL: 8.2"</li> <li>Frame: Matte Black Polymer</li> <li>Slide: Graphite PVD Steel</li> <li>Sights: Fiber Optic Front and blackout Notch Rear</li> <li>Safety: No safety</li> <li>Features: Picatinny Rail</li> </ul>	[empty string]	N	1399	1399	[empty string]	100065-DEFAULT-s.jpg	[empty string]	1000	66-100843	347372	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	fn/509-ls-edge-9mm-dao-17-rds-graphite-pvd-optic-ready-347372	1
15	[empty string]	FN	Fn	FIREARMS	Firearms>Pistols	[empty string]	1	1235	0	1235	100685-DEFAULT-l.jpg	1235	100685-DEFAULT-m.jpg	FN 5.7X28 MODEL FIVE SEVEN FDE PISTOL	N	11 JJ	5.7X28	[empty string]	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[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	3	500-or-more	0.00	[empty string]	FIVE-SEVEN - 5.7X28MM - SAO - 20 RDS - FLAT DARK EARTH	<ul> <li>Item: FN Five-Seven</li> <li>Item Number: 3868900753</li> <li>Caliber: 5.7 x 28mm</li> <li>Rounds: 20</li> <li>BarreLength: 4.75"</li> <li>OAL: 8.2"</li> <li>Finish: Flat Dark Earth</li> <li>Textured Flat Dark Earth Polymer</li> <li>Sights: 3 Dot Adjustable</li> <li>Features: Picatinny Rail, Serrated Trigger Guard, and Ambidextrous Thumb Safety</li> </ul> <p> </p> <p> </p>	[empty string]	N	1235	1235	[empty string]	100685-DEFAULT-s.jpg	[empty string]	1000	3868900753	354746	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	fn/five-seven-5-7x28mm-sao-20-rds-flat-dark-earth-354746	1
16	[empty string]	FN	Fn	FIREARMS	Firearms>Pistols>Semi Auto Pistols	[empty string]	1	575	0	575	103313-DEFAULT-l.jpg	575	103313-DEFAULT-m.jpg	FN 502 TACTICAL 22LR BLACK	N	11 JJ	22 LR	[empty string]	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[empty string]	FN	UMAREX	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	SEMI AUTO	PISTOL	8	500-or-more	0.00	[empty string]	502 TACTICAL - 22 LR - SAO - 10 RDS - MATTE BLACK POLYMER	<ul> <li>Item: FN 502 Tactical</li> <li>Item Number: 66101010</li> <li>Caliber: 22 LR</li> <li>Action: SAO</li> <li>Capacity: 10</li> <li>Barrel Length: 4.60" - Steel Threaded</li> <li>OAL: 7.60"</li> <li>Grips: Black Textured Polymer</li> <li>Fixed Sights</li> <li>Safety: Manual Thumb</li> <li>Optic Ready</li> </ul> <p> </p>	[empty string]	N	575	575	[empty string]	103313-DEFAULT-s.jpg	[empty string]	1000	66-101010	358458	SEMI AUTO PISTOLS	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	fn/502-tactical-22-lr-sao-10-rds-matte-black-polymer-358458	1
17	[empty string]	FN	Fn	FIREARMS	Firearms>Pistols>Semi Auto Pistols	[empty string]	1	995	0	995	102418-DEFAULT-l.jpg	995	102418-DEFAULT-m.jpg	FN 509T 9MM BUNDLE FDE/FDE 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	2	500-or-more	0.00	[empty string]	509 TACTICAL BUNDLE - 9MM - DBL - 24 RDS - FLAT DARK EARTH	<ul> <li>Item: FN 509 Tactical Bundle</li> <li>Item Number: 66-101651</li> <li>Caliber: 9mm Luger</li> <li>Action: DA / SA</li> <li>Capacity: 24</li> <li>Frame Finish: Flat Dark Earth</li> <li>Frame Material: Polymer</li> <li>Barrel Length: 4.50"</li> <li>OAL: 7.90"</li> <li>Sights: Fixed 3-Dot Night</li> <li>Steel Threaded Barrel, 1/2"-28tpi</li> <li>Trigger: Flat Face</li> <li>Picatinny Rail</li> <li>Includes: Ballistic Case, 5 Magazines, Mounting System and Backstraps</li> </ul> <p> </p>	[empty string]	N	995	995	[empty string]	102418-DEFAULT-s.jpg	[empty string]	1000	66-101651	384611	SEMI AUTO PISTOLS	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	fn/509-tactical-bundle-9mm-dbl-24-rds-flat-dark-earth-384611	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Filter