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	305	0	305	64647-DEFAULT-l.jpg	305	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]	THUNDER - 380 ACP - SA/DA - 7 + 1 RDS - MATTE BLACK	<p>SPECIFICATIONS:</p> <ul> <li>Item: Bersa Thunder Pistol</li> <li>Item Number: THUN380MLTCC</li> <li>Caliber: 380 acp</li> <li>Action: SA / DA</li> <li>Rounds: 7+1</li> <li>Finish: Matte Black</li> <li>Barrel Length: 3.50"</li> <li>Sights: Contrast</li> </ul>	[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/thunder-380-acp-sa-da-7-1-rds-matte-black-21893	1
2	[empty string]	BERSA GUNS	Bersa Guns	FIREARMS	Firearms>Pistols	[empty string]	1	355	0	355	55696-DEFAULT-l.jpg	355	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 - Matte Black	<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	49.99	0	49.99	[empty string]	49.99	[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	385	0	385	54246-DEFAULT-l.jpg	385	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
5	[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
6	[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	2	250-to-300	0.00	[empty string]	THUNDER - 380 ACP - DAO - 8 + 1 RDS - MATTE BLACK	<p>SPECIFICATIONS:</p> <ul> <li>Item: Bersa Thunder Pistol</li> <li>Item Number: T380M8</li> <li>Caliber: 380 ACP</li> <li>Capacity: 8 + 1 Rds</li> <li>Action: DAO</li> <li>Sight: Contrast</li> <li>Barrel Length: 3.5"</li> </ul>	[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/thunder-380-acp-dao-8-1-rds-matte-black-273506	1
7	[empty string]	BERSA GUNS	Bersa Guns	FIREARMS	Firearms>Pistols	[empty string]	1	310	0	310	64803-DEFAULT-l.jpg	310	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 ACP - DAO - 8 + 1 RDS - NICKEL	<p>SPECIFICATIONS:</p> <ul> <li>Item: Bersa Thunder Pistol</li> <li>Item Number: T380NKL8</li> <li>Caliber: 380 ACP</li> <li>Roundss; 8 + 1</li> <li>Action: DAO</li> <li>Finish: Satin Nickel</li> <li>Barrel Length: 3.50"</li> </ul>	[empty string]	N	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-acp-dao-8-1-rds-nickel-274182	1
8	[empty string]	BERSA GUNS	Bersa Guns	FIREARMS	Firearms>Pistols	[empty string]	1	295	0	295	56106-DEFAULT-l.jpg	295	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	5	250-to-300	0.00	[empty string]	THUNDER - 380 ACP - SA/DA - 8 +1 RDS - MATTE BLACK - ROBIN EGG BLUE	<p>SPECIFICATIONS: </p> <ul> <li>Item: Bersa Thunder Pistol</li> <li>Item Number: T380BLM8</li> <li>Caliber: 380 ACP</li> <li>Capacity: 8 + 1</li> <li>Action: SA/DA</li> <li>Frame Finish: Robin Egg Blue Cerakote</li> <li>Finish: Matte Black</li> <li>Barrel Length: 3.5"</li> <li>Sights: 3-Dot</li> </ul>	[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/thunder-380-acp-sa-da-8-1-rds-matte-black-robin-egg-blue-314764	1
9	[empty string]	BERSA GUNS	Bersa Guns	FIREARMS	Firearms>Pistols	[empty string]	1	310	0	310	97946-DEFAULT-l.jpg	310	97946-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	2	300-to-350	0.00	[empty string]	FIRESTORM - 380 ACP - 7 + 1 RDS - BLACK	<p>SPECIFICATIONS:</p> <ul> <li>Item: Bersa Firestorm</li> <li>Item Number: FS380M</li> <li>Caliber: 380 ACP</li> <li>Rounds: 7 + 1</li> <li>Finish: Black</li> </ul>	[empty string]	N	310	310	[empty string]	97946-DEFAULT-s.jpg	[empty string]	1000	FS380M	314769	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	bersa-guns/firestorm-380-acp-7-1-rds-black-314769	1
10	[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

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Filter By

Filter

Bersa Guns
Thunder - 380 Acp - Sa/Da - 7 + 1 Rds - Matte Black
Item # THUN380MLTCC $305.00
Bersa Guns
Thunder Plus - 380 Acp - Dbl - 3.5 `` Bbl - 15 Rds - Matte Black
Item # THUN380PM15 $355.00
Bersa Guns
Firestorm 95021 Clip
Item # 95021 $49.99
Bersa Guns
Thunder Plus - 380 Acp - Dbl - 15 + 1 Rds - Nickel
Item # THUN380PNKL15 $385.00
Bersa Guns
Thunder 380 Duolite - 380 Acp - Dbl - 8 Rds
Item # T380DT8 $295.00
Bersa Guns
Thunder - 380 Acp - Dao - 8 + 1 Rds - Matte Black
Item # T380M8 $295.00
Bersa Guns
Thunder - 380 Acp - Dao - 8 + 1 Rds - Nickel
Item # T380NKL8 $310.00
Bersa Guns
Thunder - 380 Acp - Sa/Da - 8 + 1 Rds - Matte Black - Robin Egg Blue
Item # T380BLM8 $295.00
Bersa Guns
Firestorm - 380 Acp - 7 + 1 Rds - Black
Item # FS380M $310.00
Bersa Guns
Bersa 9mm Carry Mag 8rd
Item # BP9CCMAG $49.99

Filter By

Price

Categories

Brand

Thunder - 380 Acp - Sa/Da - 7 + 1 Rds - Matte Black

Thunder Plus - 380 Acp - Dbl - 3.5 `` Bbl - 15 Rds - Matte Black

Firestorm 95021 Clip

Thunder Plus - 380 Acp - Dbl - 15 + 1 Rds - Nickel

Thunder 380 Duolite - 380 Acp - Dbl - 8 Rds

Thunder - 380 Acp - Dao - 8 + 1 Rds - Matte Black

Thunder - 380 Acp - Dao - 8 + 1 Rds - Nickel

Thunder - 380 Acp - Sa/Da - 8 + 1 Rds - Matte Black - Robin Egg Blue

Firestorm - 380 Acp - 7 + 1 Rds - Black

Bersa 9mm Carry Mag 8rd