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>Rifles	[empty string]	1	32.99	0	32.99	36434-DEFAULT-l.jpg	32.99	36434-DEFAULT-m.jpg	BUCK AIR RIFLE 177CAL LEVER ACTION	N	16 DEVON	[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	25-to-50	0.00	[empty string]	Model 105 Buck - 177 Cal - 350 Fps	<p>The Daisy Model Buck 105 is an ideal gun for instructing young, first-time shooters. The shorter length enables the shooter to properly mount the stock to their shoulder. Easy-to-use lever action with stained solid wood stock, engraved with the image of a buck. The Daisy Buck is recommended for ages 10 and older with adult supervision.</p>	[empty string]	N	32.99	32.99	[empty string]	36434-DEFAULT-s.jpg	[empty string]	1000	992105-633	18010	RIFLES	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	daisy-mfg/buck-air-rifle-177cal-lever-action-18010	1
2	[empty string]	DAISY MFG	DAISY MFG	FIREARMS	Firearms>Airguns>Pellets and BBs	[empty string]	1	2.99	0	2.99	36448-DEFAULT-l.jpg	2.99	36448-DEFAULT-m.jpg	177CAL PELLET FLATHEAD 250CT	N	16 DEVON	[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]	7	5-AND-under	0.00	[empty string]	Model 257 - Precision Max - 177 Cal - Flat Nosed Pellets - 250 Ct	<p>250 count .177 caliber flat nosed lead pellets in a convenient flip-top box with belt clip. Excellent for target practice.</p>	[empty string]	N	2.99	2.99	[empty string]	36448-DEFAULT-s.jpg	[empty string]	1000	990257-512	18014	PELLETS AND BBS	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	daisy-mfg/177cal-pellet-flathead-250ct-18014	1
3	[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 DEVON	[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]	4	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
4	[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 DEVON	[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]	11	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
5	[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 DEVON	[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]	7	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
6	[empty string]	DAISY MFG	DAISY MFG	FIREARMS	Firearms>Airguns>Accessories	[empty string]	1	11.49	0	11.49	47960-DEFAULT-l.jpg	11.49	47960-DEFAULT-m.jpg	ELECTRONIC POINT SIGHT	N	16 DEVON	[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 7809 Powerline Electronic Point Sight	<p><strong>PRODUCT FEATURES:</strong></p> <p>-Just sight-in your rifle using the lighted red dot aiming point by centering the red dot.</p> <p><br /> -Mounts on any rifle with standard 3/8" dovetail.</p> <p><br /> -Adjustable for windage and elevation.</p>	[empty string]	N	11.49	11.49	[empty string]	47960-DEFAULT-s.jpg	[empty string]	1000	987809-444	18024	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	daisy-mfg/electronic-point-sight-18024	1
7	[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 DEVON	[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]	4	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
8	[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 DEVON	[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]	20	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
9	[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 DEVON	[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]	15	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
10	[empty string]	DAISY MFG	DAISY MFG	FIREARMS	Firearms>Airguns>Accessories	[empty string]	1	4.49	0	4.49	47957-DEFAULT-l.jpg	4.49	47957-DEFAULT-m.jpg	SLINGSHOT AMMO 1/2 INCH GLASS	N	16 DEVON	[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	5-AND-under	0.00	[empty string]	Powerline - 1/2 Inch Glass Slingshot Ammo	<p>FEATURES:<br /> -1/2`` diameter white glass shot for slingshots.<br /> -75 count bag</p>	[empty string]	N	4.49	4.49	[empty string]	47957-DEFAULT-s.jpg	[empty string]	1000	998383-506	18031	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	daisy-mfg/slingshot-ammo-1-2-inch-glass-18031	1
11	[empty string]	DAISY MFG	DAISY MFG	FIREARMS	Firearms>Airguns>Accessories	[empty string]	1	16.99	0	16.99	36466-DEFAULT-l.jpg	16.99	36466-DEFAULT-m.jpg	P51 SLINGSHOT	N	16 DEVON	[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	15-to-20	0.00	[empty string]	Powerline P51 - Slingshot	<p>The B52 provides all the support you need for extra power and accuracy. Features molded sure-grip handle and solid steel frame with extra-wide fork. Flexible wrist support provides steady, stable support then folds away for compact storage. Surgical-grade tubing and rugged release pouch. Shoots 1/4", 3/8", and 1/2" steel or glass shot. Daisy’s PowerLine Slingshot Model B52 is appropriate for adults and those over 16 years of age under adult supervision.</p>	[empty string]	N	16.99	16.99	[empty string]	36466-DEFAULT-s.jpg	[empty string]	1000	998151-506	18038	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	daisy-mfg/p51-slingshot-18038	1
12	[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 DEVON	[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]	3	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
13	[empty string]	DAISY MFG	DAISY MFG	FIREARMS	Firearms>Airguns>Accessories	[empty string]	1	11.49	0	11.49	47953-DEFAULT-l.jpg	11.49	47953-DEFAULT-m.jpg	SLINGSHOT B52	N	16 DEVON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2015	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	10	10-to-15	0.00	[empty string]	Powerline B52 - Slingshot	<p>The B52 provides all the support you need for extra power and accuracy. Features molded sure-grip handle and solid steel frame with extra-wide fork. Flexible wrist support provides steady, stable support then folds away for compact storage. Surgical-grade tubing and rugged release pouch. Shoots 1/4", 3/8", and 1/2" steel or glass shot.</p> <p> </p> <p> </p> <p><strong>NOTE: Daisy’s PowerLine Slingshot Model B52 is appropriate for adults and those over 16 years of age under adult supervision.</strong></p>	[empty string]	N	11.49	11.49	[empty string]	47953-DEFAULT-s.jpg	[empty string]	1000	988152-442	251312	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	daisy-mfg/slingshot-b52-251312	1
14	[empty string]	DAISY MFG	DAISY MFG	FIREARMS	Firearms>Airguns>Rifles	[empty string]	1	54.99	0	54.99	47952-DEFAULT-l.jpg	54.99	47952-DEFAULT-m.jpg	880 AIR RIFLE 177 CAL	N	16 DEVON	[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]	2	50-to-100	0.00	[empty string]	880 Air Rifle 177 Cal	The PowerLine Model 880 is Daisy`s best-selling multi-pump pneumatic rifle with good reason. It features a Monte Carlo-styled, molded woodgrain stock and forearm with a rifled steel barrel, fiber optic front sight, adjustable rear sight, and a crossbolt trigger block safety. The receiver is made of engineering resin with a dovetail scope mount. The PowerLine 880 will shoot .177 BBs and pellets with a velocity up to 800 fps (665 fps for pellet). It has a capacity of 50 BBs or single shot pellet.	[empty string]	N	54.99	54.99	[empty string]	47952-DEFAULT-s.jpg	[empty string]	1000	990880-603	299859	RIFLES	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	daisy-mfg/880-air-rifle-177-cal-299859	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 DEVON	[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]	9	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>Pistols	[empty string]	0	38.49	0	38.49	[empty string]	38.49	[empty string]	415 CO2 PISTOL	N	16 DEVON	[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	NOT ONLINE	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	415 Co2 Pistol	[empty string]	[empty string]	N	38.49	38.49	[empty string]	[empty string]	[empty string]	1000	980415-222	333420	PISTOLS	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	daisy-mfg/415-co2-pistol-333420	1
17	[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 DEVON	[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]	7	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

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Filter