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]	DAISY MFG	DAISY MFG	FIREARMS	Firearms>Airguns>Pellets and BBs	[empty string]	1	9.99	0	9.99	36450-DEFAULT-l.jpg	9.99	36450-DEFAULT-m.jpg	BBS 4000CT BOTTLE	N	16 TOM	[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	ONLINE	[empty string]	[empty string]	38	5-to-10	0.00	[empty string]	Model 40 - Precision Max Bb Bottle - 4000 Ct	<p>This sturdy plastic bottle holds 4,000 zinc-plated steel .177 caliber, 4.5 mm BBs – and features a flip top with one large and one small opening.</p>	[empty string]	N	9.99	9.99	[empty string]	36450-DEFAULT-s.jpg	[empty string]	1000	40	18016	PELLETS AND BBS	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	daisy-mfg/bbs-4000ct-bottle-18016	1
2	[empty string]	DAISY MFG	DAISY MFG	FIREARMS	Firearms>Airguns>Pellets and BBs	[empty string]	1	4.99	0	4.99	36453-DEFAULT-l.jpg	4.99	36453-DEFAULT-m.jpg	177CAL PELLET FLATHEAD 500CT	N	16 TOM	[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	ONLINE	[empty string]	[empty string]	59	5-AND-under	0.00	[empty string]	Model 557 - Precision Max - .177 Cal - Flat Nosed Pellets - 500 Ct	<p><strong>PRODUCT FEATURES:</strong></p> <p>-.177 caliber flat-nosed lead pellets in a flip-top box with belt clip.</p> <p> </p> <p>-500 count</p>	[empty string]	N	4.99	4.99	[empty string]	36453-DEFAULT-s.jpg	[empty string]	1000	990557-512	18018	PELLETS AND BBS	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	daisy-mfg/177cal-pellet-flathead-500ct-18018	1
3	[empty string]	DAISY MFG	DAISY MFG	FIREARMS	Firearms>Airguns>Rifles	[empty string]	1	43.99	0	43.99	52009-DEFAULT-l.jpg	43.99	52009-DEFAULT-m.jpg	RED RYDER AIR RIFLE	N	16 TOM	[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	ONLINE	[empty string]	[empty string]	22	25-to-50	0.00	[empty string]	Red Ryder - .177 Cal - 350 Fps	<p>The most popular Daisy BB gun in the world remains faithful to it`s original design. From the pages of comic books to the famous holiday motion picture, a Daisy Red Ryder has been the dream of youths since it`s introduction in 1940. Over the years the Daisy Red Ryder has achieved a legendary status. With its solid wood stock and forearm, lariat ring with a leather saddle thong, today`s Daisy Red Ryder is the spittin` image of the one you cherished growing up! The Daisy Red Ryder is recommended for ages 10 and older with adult supervision.</p>	[empty string]	N	43.99	43.99	[empty string]	52009-DEFAULT-s.jpg	[empty string]	1000	991938-803	18021	RIFLES	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	daisy-mfg/red-ryder-air-rifle-18021	1
4	[empty string]	DAISY MFG	DAISY MFG	FIREARMS	Firearms>Airguns>Pellets and BBs	[empty string]	0	4.49	0	4.49	[empty string]	4.49	[empty string]	CO2 CYLINDERS PACK OF POWER 5CT	N	16 TOM	[empty string]	[empty string]	[empty string]	[empty string]	INSTORE PICK UP ONLY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	24	5-AND-under	0.00	[empty string]	Model 7580 - Powerline Co2 - 5 Pack	<p><strong>PRODUCT FEATURES:</strong></p> <p>-Twelve-gram CO2 cylinders</p> <p> </p> <p>-Box of 5</p> <p> </p> <p>-Must be at least 16 years of age to purchase.</p>	[empty string]	N	4.49	4.49	[empty string]	[empty string]	[empty string]	1000	997580-611	18023	PELLETS AND BBS	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	daisy-mfg/co2-cylinders-pack-of-power-5ct-18023	1
5	[empty string]	DAISY MFG	DAISY MFG	FIREARMS	Firearms>Airguns>Accessories	[empty string]	0	13.49	0	13.49	[empty string]	13.49	[empty string]	AIR GUN SCOPE 4X15	N	16 TOM	[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	ONLINE	[empty string]	[empty string]	2	10-to-15	0.00	[empty string]	Model 808 - Powerline - 4x15 Air Gun Scope	<p><strong>PRODUCT FEATURES:</strong></p> <p>-Adjustable for windage and elevation.</p> <p><br /> -Features include: cross-hair reticle, fog and shockproof and color corrected.</p> <p><br /> -Fits standard 3/8 inch dovetail mount.</p> <p><br /> <strong>NOTE: NOT RECOMMENDED FOR USE WITH BREAK-ACTION (BREAK-BARREL)RIFLES</strong></p>	[empty string]	N	13.49	13.49	[empty string]	[empty string]	[empty string]	1000	980808-444	18027	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	daisy-mfg/air-gun-scope-4x15-18027	1
6	[empty string]	DAISY MFG	DAISY MFG	FIREARMS	Firearms>Airguns>Accessories	[empty string]	1	4.49	0	4.49	36454-DEFAULT-l.jpg	4.49	36454-DEFAULT-m.jpg	SLING SHOT AMMO 1/4 INCH STEEL	N	16 TOM	[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	ONLINE	[empty string]	[empty string]	33	5-AND-under	0.00	[empty string]	Powerline - 1/4` Steel Slingshot Ammo - 250 Ct	<p><strong>PRODUCT FEATURES:</strong></p> <p>-1/4" diameter zinc-plated solid steel shot in a convenient box with belt clip.</p> <p><br /> -250 count</p>	[empty string]	N	4.49	4.49	[empty string]	36454-DEFAULT-s.jpg	[empty string]	1000	988114-446	18028	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	daisy-mfg/sling-shot-ammo-1-4-inch-steel-18028	1
7	[empty string]	DAISY MFG	DAISY MFG	FIREARMS	Firearms>Airguns>Accessories	[empty string]	0	4.49	0	4.49	[empty string]	4.49	[empty string]	REPLACEMENT BANDS FOR SLINGSHOT	N	16 TOM	[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	ONLINE	[empty string]	[empty string]	14	5-AND-under	0.00	[empty string]	Powerline Slingshot Replacement Band	<div class=``col-bg-7` col-sm-7=`` id=``ContentPlaceHolder1_divOverviewContainer``> <p>Replacement band with pouch.  Fits PowerLine Slingshot Models F16, B52 and P51.</p> </div>	[empty string]	N	4.49	4.49	[empty string]	[empty string]	[empty string]	1000	988172-446	18029	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	daisy-mfg/replacement-bands-for-slingshot-18029	1
8	[empty string]	DAISY MFG	DAISY MFG	FIREARMS	Firearms>Airguns>Accessories	[empty string]	1	4.49	0	4.49	36457-DEFAULT-l.jpg	4.49	36457-DEFAULT-m.jpg	SLINGSHOT AMMO 3/8 INCH STEEL	N	16 TOM	[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	ONLINE	[empty string]	[empty string]	8	5-AND-under	0.00	[empty string]	Powerline - 3/8` - Steel Slingshot Ammo - 70 Ct	<p>75 count 3/8" diameter zinc-plated solid steel shot in a convenient box with belt clip.</p>	[empty string]	N	4.49	4.49	[empty string]	36457-DEFAULT-s.jpg	[empty string]	1000	988183-446	18030	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	daisy-mfg/slingshot-ammo-3-8-inch-steel-18030	1
9	[empty string]	DAISY MFG	DAISY MFG	FIREARMS	Firearms>Airguns>Accessories	[empty string]	1	8.99	0	8.99	36464-DEFAULT-l.jpg	8.99	36464-DEFAULT-m.jpg	F16 SLINGSHOT	N	16 TOM	[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	ONLINE	[empty string]	[empty string]	22	5-to-10	0.00	[empty string]	Powerline F16 - Slingshot	<p>Features a molded sure-grip handle and a solid steel frame with extra-wide fork. Strong and sturdy. Surgical-grade tubing and durable release pouch provides all the power you need. Shoots 1/4", 3/8" and 1/2" steel or glass shot.</p> <p> </p> <p><strong>NOTE</strong><strong>: Daisy’s PowerLine Slingshot Model F16 is appropriate for adults and those over 16 years of age under adult supervision.</strong></p>	[empty string]	N	8.99	8.99	[empty string]	36464-DEFAULT-s.jpg	[empty string]	1000	988116-442	18037	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	daisy-mfg/f16-slingshot-18037	1
10	[empty string]	DAISY MFG	DAISY MFG	FIREARMS	Firearms>Airguns>Rifles	[empty string]	1	43.99	0	43.99	36486-DEFAULT-l.jpg	43.99	36486-DEFAULT-m.jpg	25 177CAL AIR RIFLE	N	16 TOM	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2018	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	11	25-to-50	0.00	[empty string]	Model 25 - 177 Cal - 350 Fps	Of all of the old Daisy BB guns Daisy has had requests to bring back, the Model 25 would have to be at the top of that list. The Model 25 Pump Gun had been in Daisy`s product line from 1914 until 1978. In 1986 it was made only as a centennial commemorative edition. In 2007, Daisy brought this classic airgun back. It`s a pump action spring air 50-shot capacity BB gun with a maximum velocity of 350 feet per second. The Model 25 features a stained solid wood pistol grip stock and foregrip, steel construction and a removable screw-in shot tube. The rear sight is adjustable for windage and elevation and it can be flipped from open/iron sights to peep sights. The gun loads via a screw-out shot tube – just like the classic models. In fact the new shot tube fits most of the vintage models. The Daisy Model 25 is recommended for ages 10 and older with adult supervision.<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	43.99	43.99	[empty string]	36486-DEFAULT-s.jpg	[empty string]	1000	990025-603	137869	RIFLES	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	daisy-mfg/25-177cal-air-rifle-137869	1
11	[empty string]	DAISY MFG	DAISY MFG	FIREARMS	Firearms>Airguns>Pellets and BBs	[empty string]	0	2.99	0	2.99	[empty string]	2.99	[empty string]	177CAL PELLETS POINTED 250CT	N	16 TOM	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2021	[empty string]	[empty string]	SO	ONLINE	[empty string]	[empty string]	1	5-AND-under	0.00	[empty string]	Precision Max - 177 Cal - Pointed Field Pellets - 250 Ct	<p>.177 caliber pointed field lead pellets in a tin. Recommended for small game hunting.</p> <p> </p> <p> </p> <p><strong>PRODUCT FEATURES:</strong></p> <p>-.177</p> <p> </p> <p>-250 ct.</p>	[empty string]	N	2.99	2.99	[empty string]	[empty string]	[empty string]	1000	7777	178566	PELLETS AND BBS	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	daisy-mfg/177cal-pellets-pointed-250ct-178566	1
12	[empty string]	DAISY MFG	DAISY MFG	FIREARMS	Firearms>Airguns>Rifles	[empty string]	1	49.99	0	49.99	66714-DEFAULT-l.jpg	49.99	66714-DEFAULT-m.jpg	BOY SCOUT AIR RIFLE 177CAL	N	16 TOM	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2018	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	6	25-to-50	0.00	[empty string]	Boy Scout Air Rifle 177cal	Given the vital role Scouting plays in developing the next generation of shooters, Daisy has partnered with the Boy Scouts of America (BSA) and offers this air rifle the official BSA edition airgun. Daisy`s BSA Model 1910 kit includes a single-pump pneumatic dual-ammo youth airgun. With velocity under 350 fps, it`s packed with features. The blade and ramp front sight and notched adjustable rear sight are ideal for teaching the basics of building a proper sight picture. The molded stock and forearm are checkered to ensure steady grip. The crossbolt trigger block safety teaches proper gun safety and handling. The kit includes a tin of BBs, a tin of pellets, official Daisy/Boy Scouts of America target, and shooting glasses.	[empty string]	N	49.99	49.99	[empty string]	66714-DEFAULT-s.jpg	[empty string]	1000	991910-603	298907	RIFLES	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	daisy-mfg/boy-scout-air-rifle-177cal-298907	1
13	[empty string]	DAISY MFG	DAISY MFG	FIREARMS	Firearms>Targets and Throwers	[empty string]	0	27.99	0	27.99	[empty string]	27.99	[empty string]	ROCKET SHOT REACTIVE AIRGUN TARGET	N	16 TOM	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2020	CLOSEOUT	[empty string]	SELL THRU	[empty string]	[empty string]	[empty string]	16	25-to-50	0.00	[empty string]	Rocket Shot Reactive Airgun Target	[empty string]	[empty string]	N	27.99	27.99	[empty string]	[empty string]	[empty string]	1000	990870-402	299949	EMPTY	EMPTY	EMPTY	0	0	0	TARGETS AND THROWERS	[empty string]	daisy-mfg/rocket-shot-reactive-airgun-target-299949	1
14	[empty string]	DAISY MFG	DAISY MFG	FIREARMS	Firearms>Airguns>Pistols	[empty string]	1	59.99	0	59.99	90468-DEFAULT-l.jpg	59.99	90468-DEFAULT-m.jpg	1911 AIR PISTOL KIT 177CAL CO2	N	16 TOM	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2019	PROMO	[empty string]	SELL THRU	[empty string]	[empty string]	[empty string]	9	50-to-100	0.00	[empty string]	1911 Air Pistol Kit 177cal Co2	[empty string]	[empty string]	N	59.99	59.99	[empty string]	90468-DEFAULT-s.jpg	[empty string]	1000	981111-444	315563	PISTOLS	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	daisy-mfg/1911-air-pistol-kit-177cal-co2-315563	1
15	[empty string]	DAISY MFG	DAISY MFG	FIREARMS	Firearms>Airguns>Pistols	[empty string]	1	21.99	0	21.99	85145-DEFAULT-l.jpg	21.99	85145-DEFAULT-m.jpg	340 AIR PISTOL 177CAL SPRING GUN	N	16 TOM	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2019	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	2	20-to-25	0.00	[empty string]	340 Air Pistol 177cal Spring Gun	[empty string]	[empty string]	N	21.99	21.99	[empty string]	85145-DEFAULT-s.jpg	[empty string]	1000	980340-342	315565	PISTOLS	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	daisy-mfg/340-air-pistol-177cal-spring-gun-315565	1
16	[empty string]	DAISY MFG	DAISY MFG	FIREARMS	Firearms>Airguns>Rifles	[empty string]	1	54.99	0	54.99	85281-DEFAULT-l.jpg	54.99	85281-DEFAULT-m.jpg	ADULT RED RYDER AIR RIFLE	N	16 TOM	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	18	50-to-100	0.00	[empty string]	Red Ryder - .177 Cal - 350 Fps	<p>The most popular Daisy BB gun in the world remains faithful to it`s original design. From the pages of comic books to the famous holiday motion picture, a Daisy Red Ryder has been the dream of youths since it`s introduction in 1940. Over the years the Daisy Red Ryder has achieved a legendary status. With its solid wood stock and forearm, lariat ring with a leather saddle thong, today`s Daisy Red Ryder is the spittin` image of the one you cherished growing up! The Daisy Red Ryder is recommended for ages 10 and older with adult supervision.</p>	[empty string]	N	54.99	54.99	[empty string]	85281-DEFAULT-s.jpg	[empty string]	1000	991938-116	333423	RIFLES	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	daisy-mfg/adult-red-ryder-air-rifle-333423	1
17	[empty string]	DAISY MFG	DAISY MFG	FIREARMS	Firearms>Airguns>Rifles	[empty string]	1	89.99	0	89.99	85282-DEFAULT-l.jpg	89.99	85282-DEFAULT-m.jpg	RED RYDER HERITAGE KIT	N	16 TOM	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	9	50-to-100	0.00	[empty string]	Red Ryder Heritage Kit	[empty string]	[empty string]	N	89.99	89.99	[empty string]	85282-DEFAULT-s.jpg	[empty string]	1000	ARR-KIT3	337403	RIFLES	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	daisy-mfg/red-ryder-heritage-kit-337403	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Filter