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]	BENELLI	Benelli	FIREARMS	Firearms>Shotguns	[empty string]	0	420	0	420	[empty string]	420	[empty string]	LLI NOVA 12GA SHOTGUN PUMP	N	11 JJ	12 GA	26IN	[empty string]	[empty string]	[empty string]	[empty string]	BENELLI USA	BENELLI ARMI S.P.A.	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	ONLINE	PUMP	SHOTGUN	1	400-to-450	0.00	[empty string]	Nova Pump Field - 12 Ga - 3.5 In - 26`` Bbl - Black Synthetic	<p>FEATURES:<br /> -The Nova Pump field shotgun offers unsurpassed strength and weather resistance.<br /> -This lightweight Nova Pump is offered in 12-gauge, 3-1/2-inch magnum.<br /> -Steel skeletal framework over-molded with high-tech polymer<br /> -Forend shell stop button<br /> -Stock and receiver are formed as one solid unit</p>	[empty string]	N	420	420	[empty string]	[empty string]	[empty string]	1000	20003	5155	EMPTY	EMPTY	EMPTY	0	0	0	SHOTGUNS	[empty string]	benelli/lli-nova-12ga-shotgun-pump-5155	1
2	[empty string]	BENELLI	Benelli	FIREARMS	Firearms>Shotguns	[empty string]	0	425	0	425	[empty string]	425	[empty string]	LLI NOVA TACT 12 GA PUMP SHOTGUN	N	11 JJ	12 GA	18-1/2IN	[empty string]	[empty string]	[empty string]	[empty string]	BENELLI USA	BENELLI ARMI	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	ONLINE	PUMP	SHOTGUN	2	400-to-450	0.00	[empty string]	Nova Tactical Pump - 12 Ga - 3.5 In - 18.5`` Bbl- Black Synthetic	<p>FEATURES:<br /> -The Nova Tactical shotgun is an all-business defense tool you can depend on.<br /> -The lightweight Nova Tactical features a strong, corrosion-resistant, 1-piece synthetic stock and receiver design.<br /> -Pump-action reliability<br /> -Ghost-ring rifle sights<br /> -Steel skeletal framework over-molded with high-tech polymer<br /> -Dual-action bars<br /> -Forend shell-stop button</p>	[empty string]	N	425	425	[empty string]	[empty string]	[empty string]	1000	20051	5163	EMPTY	EMPTY	EMPTY	0	0	0	SHOTGUNS	[empty string]	benelli/lli-nova-tact-12-ga-pump-shotgun-5163	1
3	[empty string]	BENELLI	Benelli	FIREARMS	Firearms>Shotguns	[empty string]	0	525	0	525	[empty string]	525	[empty string]	LLI SUPER NOVA 12GA/28 COMF PUMP SHOT	N	11 JJ	12 GA	28 IN	[empty string]	[empty string]	[empty string]	[empty string]	BENELLI USA	BENELLI ARMI	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	NOT ONLINE	PUMP	SHOTGUN	1	500-or-more	0.00	[empty string]	Supernova Pump - 12 Ga - 3.5 In - 28`` Bbl - Black Synthetic - Comfortech	FEATURES:<br/> -The SuperNova Pump Shotgun is a strong, lightweight 12-gauge, chambered for 3-1/2-inch magnum—impervious to all weather conditions.<br/> -ComforTech recoil reduction system<br/> -Steel skeletal framework over-molded with high-tech polymer<br/> -Forend shell-stop button<br/> -Enlarged trigger guard for gloved hands<br/> <br> <br> <br> <i><font size=1> Note: While every effort is made to include accurate and correct images, descriptions, specifications and pricing for each product, they are shown for example only and do not necessarily represent the product in its entirety. Inadvertent errors may occur. Jay`s Sporting Goods reserves the right to modify or change product information and pricing without notice. If you have a question about an item, please call or email us for more information before ordering.</font></i>	[empty string]	N	525	525	[empty string]	[empty string]	[empty string]	1000	20100	5169	EMPTY	EMPTY	EMPTY	0	0	0	SHOTGUNS	[empty string]	benelli/lli-super-nova-12ga-28-comf-pump-shot-5169	1
4	[empty string]	BENELLI	Benelli	FIREARMS	Firearms>Shotguns	[empty string]	0	1465	0	1465	[empty string]	1465	[empty string]	M2 SLUG 12GA BLACK SA SHOTGUN	N	11 JJ	12 GA	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	BENELLI	BENELLI	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SO	[empty string]	SEMI AUTO	SHOTGUN	1	500-or-more	0.00	[empty string]	M2 Slug 12ga Black Sa Shotgun	[empty string]	[empty string]	N	1465	1465	[empty string]	[empty string]	[empty string]	1000	11061	142667	EMPTY	EMPTY	EMPTY	0	0	0	SHOTGUNS	[empty string]	benelli/m2-slug-12ga-black-sa-shotgun-142667	1
5	[empty string]	BENELLI	Benelli	FIREARMS	Firearms>Shotguns	[empty string]	0	1065	0	1065	[empty string]	1065	[empty string]	LLI MONTRO 12 GA 28IN LH SA SHOTGUN	N	11 JJ	12 GA	28 IN	[empty string]	[empty string]	[empty string]	[empty string]	BENELLI USA	BENELLI	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	ONLINE	SEMI AUTO	SHOTGUN	1	500-or-more	0.00	[empty string]	Montefeltro - 12 Ga - 3 In - 28`` Bbl - Walnut - Left	<p>FEATURES:<br /> -Benelli`s Montefeltro shotgun features a slim, graceful forend, which, combined with an anodized, lightweight receiver, keeps the weight minimal and the swing quick. -Ultra-reliable Inertia Driven system<br /> -This model is offered in 12 gauge<br /> -Low-profile rib<br /> -Left hand configuration<br /> -NOTE: IMAGE SHOWN IN RIGHT HAND CONFIGURATION.</p>	[empty string]	N	1065	1065	[empty string]	[empty string]	[empty string]	1000	10864	156229	EMPTY	EMPTY	EMPTY	0	0	0	SHOTGUNS	[empty string]	benelli/lli-montro-12-ga-28in-lh-sa-shotgun-156229	1
6	[empty string]	BENELLI	Benelli	FIREARMS	Firearms>Shotguns	[empty string]	0	1065	0	1065	[empty string]	1065	[empty string]	LLI MONTRO 20 GA COMP 26IN SA SHOTGUN	N	11 JJ	20 GA	26IN	[empty string]	[empty string]	[empty string]	[empty string]	BENELLI USA	BENELLI ARMI S.P.A.	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	ONLINE	SEMI AUTO	SHOTGUN	1	500-or-more	0.00	[empty string]	Montefeltro - Compact - 20 Ga - 3 In - 26`` Bbl - Walnut	<p>SPECIFICATIONS:<br /> -Model: Montefeltro Shotgun - Compact 20-Gauge<br /> -Item Number: 10866<br /> -Barrel Length: 26``<br /> -Finish/Stock: Satin Walnut, Compact<br /> -Overall Length: 45.6``<br /> -Average Weight: 5.4 lbs.<br /> -Magazine Capacity: 4+1<br /> -Chokes: Crio IC, Crio M, Crio F<br /> -Type of Sights: Red-Bar Front<br /> -Length of Pull: 12-1/2``<br /> -Drop at Heel: 2``<br /> -Drop at Comb: 1-1/2``<br /> -Minimum Recommended Load: 2-1/2 dram, 7/8 oz. loads</p>	[empty string]	N	1065	1065	[empty string]	[empty string]	[empty string]	1000	10866	167619	EMPTY	EMPTY	EMPTY	0	0	0	SHOTGUNS	[empty string]	benelli/lli-montro-20-ga-comp-26in-sa-shotgun-167619	1
7	[empty string]	BENELLI	Benelli	FIREARMS	Firearms>Shotguns	[empty string]	0	1790	0	1790	[empty string]	1790	[empty string]	SBEIII 12GA 28IN BLK	N	11 JJ	12 GA	28 IN	[empty string]	[empty string]	[empty string]	[empty string]	BENELLI USA	BENELLI	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	ONLINE	SEMI AUTO	SHOTGUN	3	500-or-more	0.00	[empty string]	Super Black Eagle 3 -12 Ga - 3.5 In - 28`` Bbl - Black	<p>SPECIFICATIONS:<br /> -Model: Benelli Super Black Eagle 3<br /> -Item Number: 10316<br /> -Barrel Length: 28``<br /> -Stock: Black Synthetic, ComforTech -Overall Length: 49.6``<br /> -Avg. Weight: 7.0 lbs<br /> -Magazine Capacity: 3+1<br /> -Chokes: Crio C, Crio M, Crio F, Extended Crio IC, Extended Crio M<br /> -Type of Sights: Red-Bar Front and Metal Bead Mid-Sight<br /> -Length of Pull: 14-3/8``<br /> -Drop at Heel: 2-1/8``<br /> -Drop at Comb: 1-3/8``<br /> -Minimum Recommended Load: 3-dram, 1-1/8 oz. loads</p>	[empty string]	N	1790	1790	[empty string]	[empty string]	[empty string]	1000	10316	280088	EMPTY	EMPTY	EMPTY	0	0	0	SHOTGUNS	[empty string]	benelli/sbeiii-12ga-28in-blk-280088	1
8	[empty string]	BENELLI	Benelli	FIREARMS	Firearms>Storage>Cases	[empty string]	0	69.99	0	69.99	[empty string]	69.99	[empty string]	ZIPPERED GUN CASE MAX5	N	11 JJ	[empty string]	[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]	1	50-to-100	0.00	[empty string]	Zippered Gun Case Max5	[empty string]	[empty string]	N	69.99	69.99	[empty string]	[empty string]	[empty string]	1000	94000	288101	EMPTY	EMPTY	EMPTY	0	0	0	STORAGE	[empty string]	benelli/zippered-gun-case-max5-288101	1
9	[empty string]	BENELLI	Benelli	FIREARMS	Firearms>Shotguns	[empty string]	0	1790	0	1790	[empty string]	1790	[empty string]	SBEIII 12GA 28IN BLK LEFT HAND	N	11 JJ	12 GA	28 IN	[empty string]	[empty string]	[empty string]	[empty string]	BENELLI USA	BENELLI	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	SEMI AUTO	SHOTGUN	2	500-or-more	0.00	[empty string]	Super Black Eagle 3 - 12 Ga - 3.5 In - 28" Bbl - Matte Blk - Blk Synthetic - Left Hand	<p> SPECIFICATIONS:</p> <p>-Model: Benelli SBE III - Left Hand</p> <p>-Item Number: 10371</p> <p>-Gauge: 12</p> <p>-Stock: Black Synthetic</p> <p>-Receiver Finish: anodized, Black</p> <p>-Barrel Finish: Matte Black</p> <p>-Barrel Length: 28"</p> <p>-OAL: 49.6"</p> <p>-Grip: Standard</p> <p>-Stock Configuration: Standard</p> <p>-Hand: Left</p> <p>-Chokes: Crio IC, M, F</p> <p>-Extended Chock: Crio IC and M</p> <p>-Chamber: 3.5"</p> <p>-Sight: Red-Bar Front</p> <p>-Action: Semi-Auto</p> <p>-Drilled and Tapped</p> <p>-Capacity: 3+1</p> <p>-Weight: 7 lbs</p> <p> </p> <p> </p>	[empty string]	N	1790	1790	[empty string]	[empty string]	[empty string]	1000	10371	299213	EMPTY	EMPTY	EMPTY	0	0	0	SHOTGUNS	[empty string]	benelli/sbeiii-12ga-28in-blk-left-hand-299213	1
10	[empty string]	BENELLI	Benelli	FIREARMS	Firearms>Storage>Cases	[empty string]	0	54.99	0	54.99	[empty string]	54.99	[empty string]	BENELLI LOGO GUN CASE	N	11 JJ	[empty string]	[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]	7	50-to-100	0.00	[empty string]	Benelli Logo Gun Case	[empty string]	[empty string]	N	54.99	54.99	[empty string]	[empty string]	[empty string]	1000	94020	303193	EMPTY	EMPTY	EMPTY	0	0	0	STORAGE	[empty string]	benelli/benelli-logo-gun-case-303193	1
11	[empty string]	BENELLI	Benelli	FIREARMS	Firearms>Shotguns	[empty string]	0	1875	0	1875	[empty string]	1875	[empty string]	SBEIII 12GA 24IN SLUG BLACK	N	11 JJ	12 GA	24IN	[empty string]	[empty string]	[empty string]	[empty string]	BENELLI USA	BENELLI	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SO	[empty string]	SEMI AUTO	SHOTGUN	1	500-or-more	0.00	[empty string]	Sbeiii 12ga 24in Slug Black	[empty string]	[empty string]	N	1875	1875	[empty string]	[empty string]	[empty string]	1000	10379	307894	EMPTY	EMPTY	EMPTY	0	0	0	SHOTGUNS	[empty string]	benelli/sbeiii-12ga-24in-slug-black-307894	1
12	[empty string]	BENELLI	Benelli	FIREARMS	Firearms>Shotguns	[empty string]	0	1875	0	1875	[empty string]	1875	[empty string]	MONTEFELTRO SILVER FTWT 12GA 26IN SA SHOTGUN	N	11 JJ	12 GA	26IN	[empty string]	[empty string]	[empty string]	[empty string]	BENELLI USA	BENELLI	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	SEMI AUTO	SHOTGUN	1	500-or-more	0.00	[empty string]	Montefeltro Silver Ftwt 12ga 26in Sa Shotgun	[empty string]	[empty string]	N	1875	1875	[empty string]	[empty string]	[empty string]	1000	10818	324296	EMPTY	EMPTY	EMPTY	0	0	0	SHOTGUNS	[empty string]	benelli/montefeltro-silver-ftwt-12ga-26in-sa-shotgun-324296	1
13	[empty string]	BENELLI	Benelli	FIREARMS	Firearms>Shotguns	[empty string]	0	1895	0	1895	[empty string]	1895	[empty string]	SBEIII 12GA 28IN MOBL	N	11 JJ	12 GA	28 IN	[empty string]	[empty string]	[empty string]	[empty string]	BENELLI USA	BENELLI	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	SEMI AUTO	SHOTGUN	1	500-or-more	0.00	[empty string]	Sbeiii 12ga 28in Mobl	[empty string]	[empty string]	N	1895	1895	[empty string]	[empty string]	[empty string]	1000	10351	334325	EMPTY	EMPTY	EMPTY	0	0	0	SHOTGUNS	[empty string]	benelli/sbeiii-12ga-28in-mobl-334325	1
14	[empty string]	BENELLI	Benelli	FIREARMS	Firearms>Shotguns	[empty string]	0	2940	0	2940	[empty string]	2940	[empty string]	828U FIELD NICKLE 20GA 28IN O/U	N	11 JJ	20 GA	28 IN	[empty string]	[empty string]	[empty string]	[empty string]	BENELLI USA	BENELLI ARMI	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	OVER/UNDER	SHOTGUN	2	500-or-more	0.00	[empty string]	828u Field Nickle 20ga 28in O/u	[empty string]	[empty string]	N	2940	2940	[empty string]	[empty string]	[empty string]	1000	10741	334332	EMPTY	EMPTY	EMPTY	0	0	0	SHOTGUNS	[empty string]	benelli/828u-field-nickle-20ga-28in-o-u-334332	1
15	[empty string]	BENELLI	Benelli	FIREARMS	Firearms>Shotguns	[empty string]	0	1360	0	1360	[empty string]	1360	[empty string]	LLI M2 20GA LH 28IN SA SHOTGUN	N	11 JJ	20 GA	28 IN	[empty string]	[empty string]	[empty string]	[empty string]	BENELLI USA	BENELLI	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	SEMI AUTO	SHOTGUN	1	500-or-more	0.00	[empty string]	Lli M2 20ga Lh 28in Sa Shotgun	[empty string]	[empty string]	N	1360	1360	[empty string]	[empty string]	[empty string]	1000	11196	340841	EMPTY	EMPTY	EMPTY	0	0	0	SHOTGUNS	[empty string]	benelli/lli-m2-20ga-lh-28in-sa-shotgun-340841	1
16	[empty string]	BENELLI	Benelli	FIREARMS	Firearms>Shotguns	[empty string]	0	3250	0	3250	[empty string]	3250	[empty string]	828U UPLAND BLUE 12GA 24IN PS O/U	N	11 JJ	12 GA	24IN	[empty string]	[empty string]	[empty string]	[empty string]	BENELLI USA	BENELLI ARMI	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	OVER/UNDER	SHOTGUN	2	500-or-more	0.00	[empty string]	828u Upland Blue 12ga 24in Ps O/u	[empty string]	[empty string]	N	3250	3250	[empty string]	[empty string]	[empty string]	1000	10700	343448	EMPTY	EMPTY	EMPTY	0	0	0	SHOTGUNS	[empty string]	benelli/828u-upland-blue-12ga-24in-ps-o-u-343448	1
17	[empty string]	BENELLI	Benelli	FIREARMS	Firearms>Shotguns	[empty string]	0	1690	0	1690	[empty string]	1690	[empty string]	SBEIII 20GA 28IN 3 INCH TIMBER	N	11 JJ	20 GA	28 IN	[empty string]	[empty string]	[empty string]	[empty string]	BENELLI USA	BENELLI	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	SEMI AUTO	SHOTGUN	1	500-or-more	0.00	[empty string]	Sbeiii 20ga 28in 3 Inch Timber	[empty string]	[empty string]	N	1690	1690	[empty string]	[empty string]	[empty string]	1000	10343	346918	EMPTY	EMPTY	EMPTY	0	0	0	SHOTGUNS	[empty string]	benelli/sbeiii-20ga-28in-3-inch-timber-346918	1
18	[empty string]	BENELLI	Benelli	FIREARMS	Firearms>Shotguns	[empty string]	0	2495	0	2495	[empty string]	2495	[empty string]	BENELLI M2 WATERFOWL PS 20GA 28IN SEM	N	11 JJ	20 GA	28 IN	[empty string]	[empty string]	[empty string]	[empty string]	BENELLI USA	BENELLI	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	SEMI AUTO	SHOTGUN	1	500-or-more	0.00	[empty string]	Benelli M2 Waterfowl Ps 20ga 28in Sem	[empty string]	[empty string]	N	2495	2495	[empty string]	[empty string]	[empty string]	1000	11198	346934	EMPTY	EMPTY	EMPTY	0	0	0	SHOTGUNS	[empty string]	benelli/benelli-m2-waterfowl-ps-20ga-28in-sem-346934	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Filter