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]	SIERRA BULLETS	Sierra Bullets	FIREARMS	Firearms>Reloading>Bullets	[empty string]	1	32.99	0	32.99	65400-DEFAULT-l.jpg	32.99	65400-DEFAULT-m.jpg	22CAL BULLET 55GR SBT	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	[empty string]	[empty string]	[empty string]	11	25-to-50	0.00	[empty string]	22cal Bullet 55gr Sbt	The Sierra GameKing bullets are designed for hunting at long ranges. GameKing bullets feature a boat tail design to bring hunters the ballistic advantage of match bullets. The streamlined tapered base of the boat tail bullet greatly reduces drag, which results in higher retained velocity, greater striking energy, a flatter trajectory, and less wind drift.	[empty string]	N	32.99	32.99	[empty string]	65400-DEFAULT-s.jpg	[empty string]	1000	1365	63725	EMPTY	EMPTY	EMPTY	0	0	0	RELOADING	[empty string]	sierra-bullets/22cal-bullet-55gr-sbt-63725	1
2	[empty string]	SIERRA BULLETS	Sierra Bullets	FIREARMS	Firearms>Reloading>Bullets	[empty string]	1	23.99	0	23.99	65402-DEFAULT-l.jpg	23.99	65402-DEFAULT-m.jpg	22CAL BULLET 60GR HP	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	[empty string]	[empty string]	[empty string]	15	20-to-25	0.00	[empty string]	22cal Bullet 60gr Hp	Varminter Bullets are designed specifically for rapid expansion and instant kills on larger varmints and small game. Varminter bullets have thin jackets to enhance expansion but with sufficient strength to be fired at the highest muzzle velocities in the cartridges for which they are intended. The shapes of bullets in this classification include hollow point (HP), spitzer pointed flat base (SPT), and semi-pointed (SMP). Bullets labeled as Blitz are designed for medium velocity (under 3600 fps). Hornet bullets are designed to expand reliably in the 2500 to 2800 fps velocity range, although they can be loaded in cartridges generating up to 3500 fps muzzle velocity. At 223 Remington velocities, the Hornet will be an explosive "Blitz" style Varminter.	[empty string]	N	23.99	23.99	[empty string]	65402-DEFAULT-s.jpg	[empty string]	1000	1375	63726	EMPTY	EMPTY	EMPTY	0	0	0	RELOADING	[empty string]	sierra-bullets/22cal-bullet-60gr-hp-63726	1
3	[empty string]	SIERRA BULLETS	Sierra Bullets	FIREARMS	Firearms>Reloading>Bullets	[empty string]	1	27.99	0	27.99	65404-DEFAULT-l.jpg	27.99	65404-DEFAULT-m.jpg	22CAL BULLET 69GR HPBT MATCH	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	[empty string]	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	22cal Bullet 69gr Hpbt Match	MatchKing Bullets are Sierra`s pre-eminent target bullets. The driving motivation for the design of each MatchKing bullet is accuracy. These bullets have very thin jackets drawn to an exacting concentricity standard of 0.0003 in maximum variation, and their weight is held to within -+0.3 grain. All MatchKing have a hollow point design with a very small meplat for high ballistic coefficient. The majority of these bullets have a boat tail shape to further minimize drag and improve ballistic coefficient. Although some of these bullets have been used for hunting, Sierra recommends them only for target shooting.	[empty string]	N	27.99	27.99	[empty string]	65404-DEFAULT-s.jpg	[empty string]	1000	1380	63727	EMPTY	EMPTY	EMPTY	0	0	0	RELOADING	[empty string]	sierra-bullets/22cal-bullet-69gr-hpbt-match-63727	1
4	[empty string]	SIERRA BULLETS	Sierra Bullets	FIREARMS	Firearms>Reloading>Bullets	[empty string]	1	28.99	0	28.99	65508-DEFAULT-l.jpg	28.99	65508-DEFAULT-m.jpg	22CAL BULLET 55GR BLITZKING	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	[empty string]	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	22cal Bullet 55gr Blitzking	BlitzKing Bullets are designed for explosive expansion in varmints and small game and with accuracy characteristic of the MatchKing bullets. The tips of these bullets are made of a proprietary compound, and the jackets are thin for enhanced accuracy and explosive expansion. The lighter bullets in 20 and 22 calibers are designed to be fired at muzzle velocities up to 4400 fps. The lightest 6mm BlitzKing bullet can be fired at muzzle velocities up to 4000 fps.	[empty string]	N	28.99	28.99	[empty string]	65508-DEFAULT-s.jpg	[empty string]	1000	1455	63733	EMPTY	EMPTY	EMPTY	0	0	0	RELOADING	[empty string]	sierra-bullets/22cal-bullet-55gr-blitzking-63733	1
5	[empty string]	SIERRA BULLETS	Sierra Bullets	FIREARMS	Firearms>Reloading>Bullets	[empty string]	1	34.99	0	34.99	65423-DEFAULT-l.jpg	34.99	65423-DEFAULT-m.jpg	6.5MM/264 BULLET 120GR SPT	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	[empty string]	[empty string]	[empty string]	2	25-to-50	0.00	[empty string]	6.5mm/264 Bullet 120gr Spt	Sierra Pro-Hunter bullets have a traditional, flat base design. All these bullets have medium to heavy weights in each caliber, and they are designed for a combination of penetration and expansion in medium and heavy game animals for their calibers.	[empty string]	N	34.99	34.99	[empty string]	65423-DEFAULT-s.jpg	[empty string]	1000	1720	63754	EMPTY	EMPTY	EMPTY	0	0	0	RELOADING	[empty string]	sierra-bullets/6-5mm-264-bullet-120gr-spt-63754	1
6	[empty string]	SIERRA BULLETS	Sierra Bullets	FIREARMS	Firearms>Reloading>Bullets	[empty string]	1	37.99	0	37.99	65428-DEFAULT-l.jpg	37.99	65428-DEFAULT-m.jpg	270CAL BULLET 130GR SPT	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	[empty string]	[empty string]	[empty string]	2	25-to-50	0.00	[empty string]	270cal Bullet 130gr Spt	The Sierra GameKing bullets are designed for hunting at long ranges. GameKing bullets feature a boat tail design to bring hunters the ballistic advantage of match bullets. The streamlined tapered base of the boat tail bullet greatly reduces drag, which results in higher retained velocity, greater striking energy, a flatter trajectory, and less wind drift.	[empty string]	N	37.99	37.99	[empty string]	65428-DEFAULT-s.jpg	[empty string]	1000	1820	63758	EMPTY	EMPTY	EMPTY	0	0	0	RELOADING	[empty string]	sierra-bullets/270cal-bullet-130gr-spt-63758	1
7	[empty string]	SIERRA BULLETS	Sierra Bullets	FIREARMS	Firearms>Reloading>Bullets	[empty string]	1	39.99	0	39.99	65446-DEFAULT-l.jpg	39.99	65446-DEFAULT-m.jpg	30CAL BULLET 110GR HP	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	[empty string]	[empty string]	[empty string]	2	25-to-50	0.00	[empty string]	30cal Bullet 110gr Hp	Varminter Bullets are designed specifically for rapid expansion and instant kills on larger varmints and small game. Varminter bullets have thin jackets to enhance expansion but with sufficient strength to be fired at the highest muzzle velocities in the cartridges for which they are intended. The shapes of bullets in this classification include hollow point (HP), spitzer pointed flat base (SPT), and semi-pointed (SMP). Bullets labeled as Blitz are designed for medium velocity (under 3600 fps). Hornet bullets are designed to expand reliably in the 2500 to 2800 fps velocity range, although they can be loaded in cartridges generating up to 3500 fps muzzle velocity. At 223 Remington velocities, the Hornet will be an explosive "Blitz" style Varminter.	[empty string]	N	39.99	39.99	[empty string]	65446-DEFAULT-s.jpg	[empty string]	1000	2110	63775	EMPTY	EMPTY	EMPTY	0	0	0	RELOADING	[empty string]	sierra-bullets/30cal-bullet-110gr-hp-63775	1
8	[empty string]	SIERRA BULLETS	Sierra Bullets	FIREARMS	Firearms>Reloading>Bullets	[empty string]	1	36.99	0	36.99	65453-DEFAULT-l.jpg	36.99	65453-DEFAULT-m.jpg	30CAL BULLET 165GR SBT	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	[empty string]	[empty string]	[empty string]	7	25-to-50	0.00	[empty string]	30cal Bullet 165gr Sbt	The Sierra GameKing bullets are designed for hunting at long ranges. GameKing bullets feature a boat tail design to bring hunters the ballistic advantage of match bullets. The streamlined tapered base of the boat tail bullet greatly reduces drag, which results in higher retained velocity, greater striking energy, a flatter trajectory, and less wind drift.	[empty string]	N	36.99	36.99	[empty string]	65453-DEFAULT-s.jpg	[empty string]	1000	2145	63781	EMPTY	EMPTY	EMPTY	0	0	0	RELOADING	[empty string]	sierra-bullets/30cal-bullet-165gr-sbt-63781	1
9	[empty string]	SIERRA BULLETS	Sierra Bullets	FIREARMS	Firearms>Reloading>Bullets	[empty string]	1	53.99	0	53.99	65455-DEFAULT-l.jpg	53.99	65455-DEFAULT-m.jpg	30CAL BULLET 168GR HPBT MATCH	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	[empty string]	[empty string]	[empty string]	2	50-to-100	0.00	[empty string]	30cal Bullet 168gr Hpbt Match	MatchKing Bullets are Sierra's pre-eminent target bullets. The driving motivation for the design of each MatchKing bullet is accuracy. These bullets have very thin jackets drawn to an exacting concentricity standard of 0.0003 in maximum variation, and their weight is held to within -+0.3 grain. All MatchKing have a hollow point design with a very small meplat for high ballistic coefficient. The majority of these bullets have a boat tail shape to further minimize drag and improve ballistic coefficient. Although some of these bullets have been used for hunting, Sierra recommends them only for target shooting.	[empty string]	N	53.99	53.99	[empty string]	65455-DEFAULT-s.jpg	[empty string]	1000	2200	63786	EMPTY	EMPTY	EMPTY	0	0	0	RELOADING	[empty string]	sierra-bullets/30cal-bullet-168gr-hpbt-match-63786	1
10	[empty string]	SIERRA BULLETS	Sierra Bullets	FIREARMS	Firearms>Reloading>Bullets	[empty string]	1	42.99	0	42.99	65466-DEFAULT-l.jpg	42.99	65466-DEFAULT-m.jpg	338CAL BULLET 250GR SBT	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	[empty string]	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	338cal Bullet 250gr Sbt	The Sierra GameKing bullets are designed for hunting at long ranges. GameKing bullets feature a boat tail design to bring hunters the ballistic advantage of match bullets. The streamlined tapered base of the boat tail bullet greatly reduces drag, which results in higher retained velocity, greater striking energy, a flatter trajectory, and less wind drift.	[empty string]	N	42.99	42.99	[empty string]	65466-DEFAULT-s.jpg	[empty string]	1000	2600	63793	EMPTY	EMPTY	EMPTY	0	0	0	RELOADING	[empty string]	sierra-bullets/338cal-bullet-250gr-sbt-63793	1
11	[empty string]	SIERRA BULLETS	Sierra Bullets	FIREARMS	Firearms>Reloading>Bullets	[empty string]	1	34.99	0	34.99	65476-DEFAULT-l.jpg	34.99	65476-DEFAULT-m.jpg	9MM PISTOL BULLET 115GR JHP	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	[empty string]	[empty string]	[empty string]	2	25-to-50	0.00	[empty string]	9mm Pistol Bullet 115gr Jhp	Sports Master bullets are primarily for hunting. Bullets intended for use in revolvers and rifles with tubular magazines have a cannelure to facilitate roll crimping. Sports Master bullets are available in JHP, JHC, or JSP styles.	[empty string]	N	34.99	34.99	[empty string]	65476-DEFAULT-s.jpg	[empty string]	1000	8110	63802	EMPTY	EMPTY	EMPTY	0	0	0	RELOADING	[empty string]	sierra-bullets/9mm-pistol-bullet-115gr-jhp-63802	1
12	[empty string]	SIERRA BULLETS	Sierra Bullets	FIREARMS	Firearms>Reloading>Bullets	[empty string]	1	30.99	0	30.99	65505-DEFAULT-l.jpg	30.99	65505-DEFAULT-m.jpg	9MM PISTOL BULLET 125GR JHP	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	[empty string]	[empty string]	[empty string]	2	25-to-50	0.00	[empty string]	9mm Pistol Bullet 125gr Jhp	Sports Master bullets are primarily for hunting. Bullets intended for use in revolvers and rifles with tubular magazines have a cannelure to facilitate roll crimping. Sports Master bullets are available in JHP, JHC, or JSP styles.	[empty string]	N	30.99	30.99	[empty string]	65505-DEFAULT-s.jpg	[empty string]	1000	8125	63804	EMPTY	EMPTY	EMPTY	0	0	0	RELOADING	[empty string]	sierra-bullets/9mm-pistol-bullet-125gr-jhp-63804	1
13	[empty string]	SIERRA BULLETS	Sierra Bullets	FIREARMS	Firearms>Reloading>Bullets	[empty string]	1	27.99	0	27.99	65480-DEFAULT-l.jpg	27.99	65480-DEFAULT-m.jpg	38CAL PISTOL BULLET 125GR JHC	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	[empty string]	[empty string]	[empty string]	5	25-to-50	0.00	[empty string]	38cal Pistol Bullet 125gr Jhc	Sports Master bullets are primarily for hunting. Bullets intended for use in revolvers and rifles with tubular magazines have a cannelure to facilitate roll crimping. Sports Master bullets are available in JHP, JHC, or JSP styles.	[empty string]	N	27.99	27.99	[empty string]	65480-DEFAULT-s.jpg	[empty string]	1000	8320	63806	EMPTY	EMPTY	EMPTY	0	0	0	RELOADING	[empty string]	sierra-bullets/38cal-pistol-bullet-125gr-jhc-63806	1
14	[empty string]	SIERRA BULLETS	Sierra Bullets	FIREARMS	Firearms>Reloading>Bullets	[empty string]	0	33.99	0	33.99	[empty string]	33.99	[empty string]	10MM PISTOL BULLET 180GR JHP	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	[empty string]	[empty string]	[empty string]	8	25-to-50	0.00	[empty string]	10mm Pistol Bullet 180gr Jhp	[empty string]	[empty string]	N	33.99	33.99	[empty string]	[empty string]	[empty string]	1000	8460	63814	EMPTY	EMPTY	EMPTY	0	0	0	RELOADING	[empty string]	sierra-bullets/10mm-pistol-bullet-180gr-jhp-63814	1
15	[empty string]	SIERRA BULLETS	Sierra Bullets	FIREARMS	Firearms>Reloading>Bullets	[empty string]	1	45.99	0	45.99	65493-DEFAULT-l.jpg	45.99	65493-DEFAULT-m.jpg	45CAL PISTOL BULLET 185GR JHP	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	[empty string]	[empty string]	[empty string]	21	25-to-50	0.00	[empty string]	45cal Pistol Bullet 185gr Jhp	Sports Master bullets are primarily for hunting. Bullets intended for use in revolvers and rifles with tubular magazines have a cannelure to facilitate roll crimping. Sports Master bullets are available in JHP, JHC, or JSP styles.	[empty string]	N	45.99	45.99	[empty string]	65493-DEFAULT-s.jpg	[empty string]	1000	8800	63820	EMPTY	EMPTY	EMPTY	0	0	0	RELOADING	[empty string]	sierra-bullets/45cal-pistol-bullet-185gr-jhp-63820	1
16	[empty string]	SIERRA BULLETS	Sierra Bullets	FIREARMS	Firearms>Reloading>Bullets	[empty string]	1	24.99	0	24.99	65395-DEFAULT-l.jpg	24.99	65395-DEFAULT-m.jpg	22CAL BULLET 52GR HPBTM	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	[empty string]	[empty string]	[empty string]	1	20-to-25	0.00	[empty string]	22cal Bullet 52gr Hpbtm	MatchKing Bullets are Sierra's pre-eminent target bullets. The driving motivation for the design of each MatchKing bullet is accuracy. These bullets have very thin jackets drawn to an exacting concentricity standard of 0.0003 in maximum variation, and their weight is held to within -+0.3 grain. All MatchKing have a hollow point design with a very small meplat for high ballistic coefficient. The majority of these bullets have a boat tail shape to further minimize drag and improve ballistic coefficient. Although some of these bullets have been used for hunting, Sierra recommends them only for target shooting.	[empty string]	N	24.99	24.99	[empty string]	65395-DEFAULT-s.jpg	[empty string]	1000	1410	66075	EMPTY	EMPTY	EMPTY	0	0	0	RELOADING	[empty string]	sierra-bullets/22cal-bullet-52gr-hpbtm-66075	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Filter