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]	BERSA GUNS	Bersa Guns	FIREARMS	Firearms>Pistols	[empty string]	1	0	0	295	64647-DEFAULT-l.jpg	0	64647-DEFAULT-m.jpg	RSA BERSA THUN380MLTCC 380ACP PISTOL	N	11 JJ	380 ACP	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	TALON DISTRIBUTING	BERSA S.A.	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	SEMI AUTO	PISTOL	3	250-to-300	0.00	[empty string]	Rsa Bersa Thun380mltcc 380acp Pistol	The ultimate compact .380 double action pistol, the Thunder Concealed Carry is slim, trim and always ready for immediate action. It out-performs, out-features and out-prices all others in its class. The Thunder 380 CC has become a leader among concealed carry handguns by earning a reputation of reliability, accuracy and durability. Extremely compact and strong, the 380 CC`s quality design and engineering provide the shooter enhanced balance during those critical seconds. Features like the loaded chamber indicator, extended capacity magazine and slide sights make the 380 CC a perfect CCW sidearm.	[empty string]	N	295	295	[empty string]	64647-DEFAULT-s.jpg	[empty string]	1000	THUN380MLTCC	21893	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	bersa-guns/rsa-bersa-thun380mltcc-380acp-pistol-21893	1
2	[empty string]	BERSA GUNS	Bersa Guns	FIREARMS	Firearms>Pistols	[empty string]	1	340	0	350	55696-DEFAULT-l.jpg	340	55696-DEFAULT-m.jpg	RSA BERSA THUNDER 380 PLUS 380ACP PISTOL	N	11 JJ	380 ACP	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	TALON DISTRIBUTING	BERSA S.A.	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	ONLINE	SEMI AUTO	PISTOL	8	300-to-350	0.00	[empty string]	Thunder Plus - 380 Acp - Dbl - 3.5`` Bbl -15 Rds	<p>SPECIFICATIONS:<br /> -Model: Thunder Plus<br /> -Item Number: THUN380PM15<br /> -Type: Semi-Auto Pistol<br /> -Action: Double / Single Action<br /> -Finish: Matte Blue<br /> -Frame: Alloy Frame<br /> -Grips: Black Plastic<br /> -Weight: 23 oz.<br /> -Caliber: 380 ACP<br /> -Capacity: 15+1<br /> -Rounds: 15<br /> -Barrel: 3.5``<br /> -Overall Length: 6.625``<br /> -Sights: Fixed<br /> -Safety: 2 Position Slide Mounted</p>	[empty string]	N	350	350	[empty string]	55696-DEFAULT-s.jpg	[empty string]	1000	THUN380PM15	21896	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	bersa-guns/rsa-bersa-thunder-380-plus-380acp-pistol-21896	1
3	[empty string]	BERSA GUNS	Bersa Guns	FIREARMS	Firearms>Magazines	[empty string]	0	0	0	49.99	[empty string]	0	[empty string]	FIRESTORM 95021 CLIP	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]	2	25-to-50	0.00	[empty string]	Firestorm 95021 Clip	[empty string]	[empty string]	N	49.99	49.99	[empty string]	[empty string]	[empty string]	1000	95021	24841	EMPTY	EMPTY	EMPTY	0	0	0	MAGAZINES	[empty string]	bersa-guns/firestorm-95021-clip-24841	1
4	[empty string]	BERSA GUNS	Bersa Guns	FIREARMS	Firearms>Magazines	[empty string]	0	0	0	49.99	[empty string]	0	[empty string]	FIRESTORM 95121 CLIP	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]	SO	[empty string]	[empty string]	[empty string]	17	25-to-50	0.00	[empty string]	Firestorm 95121 Clip	[empty string]	[empty string]	N	49.99	49.99	[empty string]	[empty string]	[empty string]	1000	95121	24844	EMPTY	EMPTY	EMPTY	0	0	0	MAGAZINES	[empty string]	bersa-guns/firestorm-95121-clip-24844	1
5	[empty string]	BERSA GUNS	Bersa Guns	FIREARMS	Firearms>Magazines	[empty string]	0	0	0	49.99	[empty string]	0	[empty string]	FIRESTORM FS4510M CLIP	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]	SO	[empty string]	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	Firestorm Fs4510m Clip	[empty string]	[empty string]	N	49.99	49.99	[empty string]	[empty string]	[empty string]	1000	FS4510M	24855	EMPTY	EMPTY	EMPTY	0	0	0	MAGAZINES	[empty string]	bersa-guns/firestorm-fs4510m-clip-24855	1
6	[empty string]	BERSA GUNS	Bersa Guns	FIREARMS	Firearms>Magazines	[empty string]	1	39.49	0	39.49	65535-DEFAULT-l.jpg	39.49	65535-DEFAULT-m.jpg	BERSA 9MM 13RD MAG	N	11 JJ	9MM LUGER	[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]	SO	[empty string]	[empty string]	[empty string]	7	25-to-50	0.00	[empty string]	Bersa 9mm 13rd Mag	Constructed of aluminum, this Bersa magazine is compatible with Thunder and holds up to 13-rounds.	[empty string]	N	39.49	39.49	[empty string]	65535-DEFAULT-s.jpg	[empty string]	1000	THUN9UCM13	139726	EMPTY	EMPTY	EMPTY	0	0	0	MAGAZINES	[empty string]	bersa-guns/bersa-9mm-13rd-mag-139726	1
7	[empty string]	BERSA GUNS	Bersa Guns	FIREARMS	Firearms>Pistols	[empty string]	0	295	0	305	[empty string]	295	[empty string]	BERSA 9MM COMPACT CARRY PISTOL	N	11 JJ	9 X 19MM	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	TALON DISTRIBUTING	BERSA S.A.	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SO	ONLINE	SEMI AUTO	PISTOL	5	300-to-350	0.00	[empty string]	Bp9 - Concealed Carry - 9mm - Semi Auto - 8 Rds	<p>SPECIFICATIONS:<br /> -Model: BP9 Concealed Carry<br /> -Item Number: BP9MCC<br /> -Type: Semi-Auto Pistol<br /> -Action: Semi-Auto<br /> -Finish: Matte Blue<br /> -Frame: Polymer Frame<br /> -Gauge: 9mm<br /> -Capacity: 8+1<br /> -Rounds: 8<br /> -Barrel Length: 3.5``<br /> -Sights: Adjustable</p>	[empty string]	N	305	305	[empty string]	[empty string]	[empty string]	1000	BP9MCC	150131	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	bersa-guns/bersa-9mm-compact-carry-pistol-150131	1
8	[empty string]	BERSA GUNS	Bersa Guns	FIREARMS	Firearms>Pistols	[empty string]	1	370	0	385	54246-DEFAULT-l.jpg	370	54246-DEFAULT-m.jpg	BERSA THUNDER PLUS 380 380ACP PISTOL	N	11 JJ	380 ACP	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	TALON DISTRIBUTING	BERSA S.A.	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	ONLINE	SEMI AUTO	PISTOL	6	350-to-400	0.00	[empty string]	Thunder Plus - 380 Acp - Dbl - 15 + 1 Rds - Nickel	<p>SPECIFICATIONS:<br /> -Model: Thunder 380 Plus<br /> -Caliber: .380 ACP<br /> -Action: DA/SA<br /> -Capacity: 15+1<br /> -Barrel Length: 3.5``<br /> -Front Sight: Dovetail<br /> -Rear Sight: Notched-Bar Dovetail<br /> -Finishes: Matte Black, Satin Nickel<br /> -Grips: Rubber<br /> -Construction: Alloy Frame / Steel Slide<br /> -Safety: Integral Locking System, Manual, Firing Pin<br /> -Weight: 20.5000<br /> -Length: 6.6``<br /> -Height: 4.9``<br /> -Width: 1.35``</p>	[empty string]	N	385	385	[empty string]	54246-DEFAULT-s.jpg	[empty string]	1000	THUN380PNKL15	169574	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	bersa-guns/bersa-thunder-plus-380-380acp-pistol-169574	1
9	[empty string]	BERSA GUNS	Bersa Guns	FIREARMS	Firearms>Magazines	[empty string]	0	49.99	0	49.99	[empty string]	49.99	[empty string]	BERSA CARRY 380 8RD MAG	N	11 JJ	380 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]	SO	[empty string]	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	Bersa Carry 380 8rd Mag	[empty string]	[empty string]	N	49.99	49.99	[empty string]	[empty string]	[empty string]	1000	BP380CC	261441	EMPTY	EMPTY	EMPTY	0	0	0	MAGAZINES	[empty string]	bersa-guns/bersa-carry-380-8rd-mag-261441	1
10	[empty string]	BERSA GUNS	Bersa Guns	FIREARMS	Firearms>Pistols	[empty string]	1	295	0	295	57415-DEFAULT-l.jpg	295	57415-DEFAULT-m.jpg	THUNDER 380 DUOTONE 380ACP 8RD	N	11 JJ	380 ACP	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	TALON DISTRIBUTING	BERSA S.A.	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	ONLINE	SEMI AUTO	PISTOL	9	250-to-300	0.00	[empty string]	Thunder 380 Duolite - 380 Acp - Dbl - 8 Rds	<p>SPECIFICATIONS:<br /> -Model: Thunder 380 Duolite<br /> -Item Number: T380DT8<br /> -Type: Semi-Auto Pistol<br /> -Action: Double / Single Action<br /> -Finish: Duo-Tone<br /> -Frame: Alloy Frame<br /> -Grips: Black Plastic<br /> -Weight: 23 oz.<br /> -Caliber: 380 ACP<br /> -Capacity: 8+1<br /> -Number of Magazines: 1<br /> -Barrel: 3.5``<br /> -Overall Length: 6.6<br /> -Sights: Fixed<br /> -Safety: 2 Position Slide Mounted, Blue Slide with Nickel Frame</p>	[empty string]	N	295	295	[empty string]	57415-DEFAULT-s.jpg	[empty string]	1000	T380DT8	270129	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	bersa-guns/thunder-380-duotone-380acp-8rd-270129	1
11	[empty string]	BERSA GUNS	Bersa Guns	FIREARMS	Firearms>Pistols	[empty string]	1	295	0	295	93282-DEFAULT-l.jpg	295	93282-DEFAULT-m.jpg	RSA THUNDER 380ACP PISTOL S/A	N	11 JJ	380 ACP	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	TALON DISTRIBUTING	BERSA S.A.	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	ONLINE	SEMI AUTO	PISTOL	8	250-to-300	0.00	[empty string]	Rsa Thunder 380acp Pistol S/a	[empty string]	[empty string]	N	295	295	[empty string]	93282-DEFAULT-s.jpg	[empty string]	1000	T380M8	273506	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	bersa-guns/rsa-thunder-380acp-pistol-s-a-273506	1
12	[empty string]	BERSA GUNS	Bersa Guns	FIREARMS	Firearms>Pistols	[empty string]	1	325	1	295	64803-DEFAULT-l.jpg	325	64803-DEFAULT-m.jpg	THUNDER 380 380ACP 8RD NICKEL SEMI PISTO	N	11 JJ	380 ACP	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	TALON DISTRIBUTING	BERSA S.A.	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	SEMI AUTO	PISTOL	4	250-to-300	0.00	[empty string]	Thunder 380 380acp 8rd Nickel Semi Pisto	The Thunder .380 has earned a worldwide reputation of quality and is truly one of the best performance-for-price buys on the market. It`s lightweight, small-frame and ideal capacity combines with Bersa`s time-tested reliability and accuracy to make the Thunder .380 an excellent choice for personal protection.	[empty string]	Y	295	295	[empty string]	64803-DEFAULT-s.jpg	[empty string]	1000	T380NKL8	274182	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	bersa-guns/thunder-380-380acp-8rd-nickel-semi-pisto-274182	1
13	[empty string]	BERSA GUNS	Bersa Guns	FIREARMS	Firearms>Pistols	[empty string]	0	1665	0	1770	[empty string]	1665	[empty string]	PANTERA 45ACP 12RND PISTOL	N	11 JJ	45 ACP	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	RSA ENT. INC.	METRO ARMS CORP.	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SO	[empty string]	SEMI AUTO	PISTOL	1	500-or-more	0.00	[empty string]	Pantera 45acp 12rnd Pistol	[empty string]	[empty string]	N	1770	1770	[empty string]	[empty string]	[empty string]	1000	SPP45BC	282916	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	bersa-guns/pantera-45acp-12rnd-pistol-282916	1
14	[empty string]	BERSA GUNS	Bersa Guns	FIREARMS	Firearms>Pistols	[empty string]	0	260	0	285	[empty string]	260	[empty string]	RSA THUNDER 380ACP PURPLE PISTOL S/A	N	11 JJ	380 ACP	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	TALON DISTRIBUTING	BERSA S.A.	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SO	[empty string]	SEMI AUTO	PISTOL	2	250-to-300	0.00	[empty string]	Rsa Thunder 380acp Purple Pistol S/a	[empty string]	[empty string]	N	285	285	[empty string]	[empty string]	[empty string]	1000	T380PRP8	314761	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	bersa-guns/rsa-thunder-380acp-purple-pistol-s-a-314761	1
15	[empty string]	BERSA GUNS	Bersa Guns	FIREARMS	Firearms>Pistols	[empty string]	0	440	0	455	[empty string]	440	[empty string]	BERSA TPRC 9MM COMPACT PISTOL	N	11 JJ	9 X 19MM	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	TALON DISTRIBUTING	BERSA S.A.	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	ONLINE	SEMI AUTO	PISTOL	7	450-to-500	0.00	[empty string]	Bersa Tprc 9mm Compact Pistol	[empty string]	[empty string]	N	455	455	[empty string]	[empty string]	[empty string]	1000	TPR9CM	314767	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	bersa-guns/bersa-tprc-9mm-compact-pistol-314767	1
16	[empty string]	BERSA GUNS	Bersa Guns	FIREARMS	Firearms>Magazines	[empty string]	1	49.99	0	49.99	88526-DEFAULT-l.jpg	49.99	88526-DEFAULT-m.jpg	BERSA 9MM CARRY MAG 8RD	N	11 JJ	9MM	[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]	2	25-to-50	0.00	[empty string]	Bersa 9mm Carry Mag 8rd	[empty string]	[empty string]	N	49.99	49.99	[empty string]	88526-DEFAULT-s.jpg	[empty string]	1000	BP9CCMAG	318139	EMPTY	EMPTY	EMPTY	0	0	0	MAGAZINES	[empty string]	bersa-guns/bersa-9mm-carry-mag-8rd-318139	1
17	[empty string]	BERSA GUNS	Bersa Guns	FIREARMS	Firearms>Pistols	[empty string]	1	315	0	315	85930-DEFAULT-l.jpg	315	85930-DEFAULT-m.jpg	BERSA 9MM COMPACT CARRY BB PISTOL	N	11 JJ	9 X 19MM	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	R.S.A.	BERSA S.A.	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SO	[empty string]	SEMI AUTO	PISTOL	2	300-to-350	0.00	[empty string]	Bersa 9mm Compact Carry Bb Pistol	[empty string]	[empty string]	N	315	315	[empty string]	85930-DEFAULT-s.jpg	[empty string]	1000	BP9BRZCC	349886	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	bersa-guns/bersa-9mm-compact-carry-bb-pistol-349886	1

CACHED

false

EXECUTIONTIME

1

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Filter