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	305	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	2	300-to-350	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	305	305	[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	355	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	7	350-to-400	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	355	355	[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>Pistols	[empty string]	1	295	0	295	69130-DEFAULT-l.jpg	295	69130-DEFAULT-m.jpg	RSA BERSA THUNDER 22 MATTE 22LR 10RD	N	11 JJ	22 LR	[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	1	250-to-300	0.00	[empty string]	Rsa Bersa Thunder 22 Matte 22lr 10rd	The Thunder .22 is Bersa`s smallest caliber semi-automatic handgun. Chambered in .22LR, this handgun has important features like comfort, accuracy, durability and reliability. The Thunder 22 features a front blade sight with integral slide and a notched bar dovetail rear, combat-style trigger guard, extended slide release, extended finger rest magazine bottom. For anyone needing practice to maintain proficiency or simply to have fun plinking, the Thunder .22 is economical to shoot - an important consideration with high ammunition prices. This lightweight, low recoil shooter is an asset to anyone`s gun collection.	[empty string]	N	295	295	[empty string]	69130-DEFAULT-s.jpg	[empty string]	1000	T22M	141350	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	bersa-guns/rsa-bersa-thunder-22-matte-22lr-10rd-141350	1
5	[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	4	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
6	[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	4	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
7	[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	3	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
8	[empty string]	BERSA GUNS	Bersa Guns	FIREARMS	Firearms>Pistols	[empty string]	1	325	1	310	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	2	300-to-350	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	310	310	[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
9	[empty string]	BERSA GUNS	Bersa Guns	FIREARMS	Firearms>Pistols	[empty string]	1	260	0	295	56106-DEFAULT-l.jpg	260	56106-DEFAULT-m.jpg	RSA THUNDER 380ACP R BLUE 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	[empty string]	SEMI AUTO	PISTOL	6	250-to-300	0.00	[empty string]	Rsa Thunder 380acp R Blue Pistol S/a	[empty string]	[empty string]	N	295	295	[empty string]	56106-DEFAULT-s.jpg	[empty string]	1000	T380BLM8	314764	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	bersa-guns/rsa-thunder-380acp-r-blue-pistol-s-a-314764	1
10	[empty string]	BERSA GUNS	Bersa Guns	FIREARMS	Firearms>Pistols	[empty string]	1	285	0	310	56106-DEFAULT-l.jpg	285	56106-DEFAULT-m.jpg	FIRESTORM 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	[empty string]	SEMI AUTO	PISTOL	3	300-to-350	0.00	[empty string]	Firestorm 380acp Pistol S/a	[empty string]	[empty string]	N	310	310	[empty string]	56106-DEFAULT-s.jpg	[empty string]	1000	FS380M	314769	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	bersa-guns/firestorm-380acp-pistol-s-a-314769	1
11	[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]	4	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

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Filter