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]	NOSLER	NOSLER	FIREARMS	Firearms>Reloading>Brass	[empty string]	1	74.99	0	74.99	91417-DEFAULT-l.jpg	74.99	91417-DEFAULT-m.jpg	6.5-284 NORMA BRASS	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	[empty string]	[empty string]	[empty string]	2	50-to-100	0.00	[empty string]	6.5-284 Norma Brass	[empty string]	[empty string]	N	74.99	74.99	[empty string]	91417-DEFAULT-s.jpg	[empty string]	1000	10190	51417	EMPTY	EMPTY	EMPTY	0	0	0	RELOADING	[empty string]	nosler/6-5-284-norma-brass-51417	1
2	[empty string]	NOSLER	NOSLER	FIREARMS	Firearms>Reloading>Bullets	[empty string]	1	45.99	0	45.99	46920-DEFAULT-l.jpg	45.99	46920-DEFAULT-m.jpg	6.5MM BULLET 140GR SPITZER PARTITION	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]	1	25-to-50	0.00	[empty string]	Partition - 6.5mm -.264 - 140 Gr - Spitzer - 50 Ct	-Nosler Engineering: Nosler`s special lead-alloy, dual-core provides superior mushrooming characteristics at virtually all impact velocities.<BR/> -Fully Tapered Copper-Alloy Jacket: Ruptures instantly at the thin jacket mouth, yet the gradual thickening along the bullet`s axis controls expansion and curls the jacket uniformly outward at high and low velocities.<BR/> -Nosler`s Integral Partition: Supports the expanded mushroom and retains the rear lead-alloy core. The enclosed rear core retains more than two-thirds of the original bullet weight for deep penetration.<BR/> -Dual-Core Construction: Every Partition bullet in the Nosler line delivers optimum length, weight and ogive design for maximum in-flight and terminal performance.<BR/> -Special Crimp Locks: Adds strength to resist deformation under the pressure of heavy magnums.<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	45.99	45.99	[empty string]	46920-DEFAULT-s.jpg	[empty string]	1000	16321	51428	EMPTY	EMPTY	EMPTY	0	0	0	RELOADING	[empty string]	nosler/6-5mm-bullet-140gr-spitzer-partition-51428	1
3	[empty string]	NOSLER	NOSLER	FIREARMS	Firearms>Reloading>Bullets	[empty string]	1	49.99	0	49.99	47459-DEFAULT-l.jpg	49.99	47459-DEFAULT-m.jpg	30CAL BULLET 180GR SPITZER PARTITION	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	25-to-50	0.00	[empty string]	Partition - 30 Cal - .308 - 150 Gr - Spitzer - 50 Ct	-Nosler Engineering: Nosler`s special lead-alloy, dual-core provides superior mushrooming characteristics at virtually all impact velocities.<BR/> -Fully Tapered Copper-Alloy Jacket: Ruptures instantly at the thin jacket mouth, yet the gradual thickening along the bullet`s axis controls expansion and curls the jacket uniformly outward at high and low velocities.<BR/> -Nosler`s Integral Partition: Supports the expanded mushroom and retains the rear lead-alloy core. The enclosed rear core retains more than two-thirds of the original bullet weight for deep penetration.<BR/> -Dual-Core Construction: Every Partition bullet in the Nosler line delivers optimum length, weight and ogive design for maximum in-flight and terminal performance.<BR/> -Special Crimp Locks: Adds strength to resist deformation under the pressure of heavy magnums.<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	49.99	49.99	[empty string]	47459-DEFAULT-s.jpg	[empty string]	1000	16331	51437	EMPTY	EMPTY	EMPTY	0	0	0	RELOADING	[empty string]	nosler/30cal-bullet-180gr-spitzer-partition-51437	1
4	[empty string]	NOSLER	NOSLER	FIREARMS	Firearms>Reloading>Bullets	[empty string]	0	95.99	0	95.99	[empty string]	95.99	[empty string]	416CAL BULLET 400GR FP DANGEROUS GAME	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	NOT ONLINE	[empty string]	[empty string]	5	50-to-100	0.00	[empty string]	416cal Bullet 400gr Fp Dangerous Game	Nosler Solids features a flat nose design and homogeneous lead-free alloy core that reduces deflection off of bone and muscle, for lethal penetration and an impressively straight wound channel. Engineered with multiple seating grooves, it provides optimal load versatility. Nosler Solids are uniquely engineered to match the ballistic performance of the Nosler Partition bullets in the same caliber and weight.	[empty string]	N	95.99	95.99	[empty string]	[empty string]	[empty string]	1000	23654	51443	EMPTY	EMPTY	EMPTY	0	0	0	RELOADING	[empty string]	nosler/416cal-bullet-400gr-fp-dangerous-game-51443	1
5	[empty string]	NOSLER	NOSLER	FIREARMS	Firearms>Reloading>Bullets	[empty string]	1	31.99	0	31.99	47303-DEFAULT-l.jpg	31.99	47303-DEFAULT-m.jpg	7MM BULLET 120GR SPITZER BALLISTIC TIP	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]	4	25-to-50	0.00	[empty string]	Ballistic Tip - Hunting - 7mm Cal - .284 - 120 Gr - Spitzer - 50 Ct	These bullets deliver the accuracy, consistency and down-range punch required for clean kills in all situations. These flat-shooting, wind-defying bullets utilize ballistic-designed boat-tails and polymer tips to increase long-range efficiency and protect against tip damage in the magazine. Unique tapered jacket provides controlled expansion at all practical ranges and velocities.<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	31.99	31.99	[empty string]	47303-DEFAULT-s.jpg	[empty string]	1000	28120	51455	EMPTY	EMPTY	EMPTY	0	0	0	RELOADING	[empty string]	nosler/7mm-bullet-120gr-spitzer-ballistic-tip-51455	1
6	[empty string]	NOSLER	NOSLER	FIREARMS	Firearms>Reloading>Bullets	[empty string]	1	40.99	0	40.99	67160-DEFAULT-l.jpg	40.99	67160-DEFAULT-m.jpg	270CAL CT BULLET 130GR SPITZER BALLISTIC	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	NOT ONLINE	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	270cal Ct Bullet 130gr Spitzer Ballistic	Each Ballistic Silvertip Hunting bullet features a Lubalox (very thin black oxide) exterior coating which reduces fouling, pressure and friction between bullet and bore; provides longer barrel life, easier cleaning and enhanced accuracy. It has a fully tapered jacket and special lead-alloy core which allows controlled expansion and optimum weight retention at all practical velocity levels. The heavy jacketed base prevents bullet deformation during firing, and acts as a platform for large-diameter mushroom. The ballistically engineered solid base boat tail configuration combines with the streamlined polymer tip for extreme long-range performance and for easier loading. The polymer Silvertip prevents deformation in the magazine.	[empty string]	N	40.99	40.99	[empty string]	67160-DEFAULT-s.jpg	[empty string]	1000	51075	51498	EMPTY	EMPTY	EMPTY	0	0	0	RELOADING	[empty string]	nosler/270cal-ct-bullet-130gr-spitzer-ballistic-51498	1
7	[empty string]	NOSLER	NOSLER	FIREARMS	Firearms>Reloading>Bullets	[empty string]	1	44.99	0	44.99	67166-DEFAULT-l.jpg	44.99	67166-DEFAULT-m.jpg	30CAL BULLET 200GR SPITZER ACCUBOND	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	NOT ONLINE	[empty string]	[empty string]	6	25-to-50	0.00	[empty string]	30cal Bullet 200gr Spitzer Accubond	AccuBond is designed to be a highly-accurate big game hunting bullet suitable for use on a wide variety of game. Its bonding process eliminates voids in the bullet core, and AccuBond marries Nosler's traditional copper-alloy jacket with its special lead-alloy core. The result is a bullet that flies true, penetrates deep and retains its weight and won't cause extensive barrel fouling. The unique white polymer tip resists deforming and initiates expansion on impact. Nosler's Solid Base at the rear of the bullet acts as a platform for large diameter mushrooms. Boat tail configuration combines with the streamlined polymer tip for long-range performance and for easier loading. AccuBond is designed to reliably expand at a minimum impact velocity of 1800 fps.	[empty string]	N	44.99	44.99	[empty string]	67166-DEFAULT-s.jpg	[empty string]	1000	54618	51517	EMPTY	EMPTY	EMPTY	0	0	0	RELOADING	[empty string]	nosler/30cal-bullet-200gr-spitzer-accubond-51517	1
8	[empty string]	NOSLER	NOSLER	FIREARMS	Firearms>Reloading>Bullets	[empty string]	1	41.99	0	41.99	47200-DEFAULT-l.jpg	41.99	47200-DEFAULT-m.jpg	30CAL BULLET 180GR SPITZER ACCUBOND	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]	3	25-to-50	0.00	[empty string]	Accubond - 30 Cal - .308 - 180 Gr - Spitzer - 50 Ct	<p>Through an exclusive bonding process that eliminates voids in the bullet core, AccuBond couples Nosler`s proven copper-alloy jacket with its special lead-alloy core. The result is a bullet that flies true, penetrates deep and retains its weight, without causing extensive barrel fouling. The unique white polymer tip resists deforming and initiates expansion on impact. Nosler`s Solid Base at the rear of the bullet acts as a platform for large diameter mushrooms.</p>	[empty string]	N	41.99	41.99	[empty string]	47200-DEFAULT-s.jpg	[empty string]	1000	54825	51519	EMPTY	EMPTY	EMPTY	0	0	0	RELOADING	[empty string]	nosler/30cal-bullet-180gr-spitzer-accubond-51519	1
9	[empty string]	NOSLER	NOSLER	FIREARMS	Firearms>Reloading>Bullets	[empty string]	1	40.99	0	40.99	47242-DEFAULT-l.jpg	40.99	47242-DEFAULT-m.jpg	30CAL BULLET 165GR SPITZER ACCUBOND	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	25-to-50	0.00	[empty string]	Accubond - 30 Cal - .308 - 165 Gr - Spitzer - 50 Ct	<p>Through an exclusive bonding process that eliminates voids in the bullet core, AccuBond couples Nosler`s proven copper-alloy jacket with its special lead-alloy core. The result is a bullet that flies true, penetrates deep and retains its weight, without causing extensive barrel fouling. The unique white polymer tip resists deforming and initiates expansion on impact. Nosler`s Solid Base at the rear of the bullet acts as a platform for large diameter mushrooms.</p>	[empty string]	N	40.99	40.99	[empty string]	47242-DEFAULT-s.jpg	[empty string]	1000	55602	51522	EMPTY	EMPTY	EMPTY	0	0	0	RELOADING	[empty string]	nosler/30cal-bullet-165gr-spitzer-accubond-51522	1
10	[empty string]	NOSLER	NOSLER	FIREARMS	Firearms>Reloading>Bullets	[empty string]	0	29.99	0	29.99	[empty string]	29.99	[empty string]	20CAL BULLETS 32GR BT LEAD FREE	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]	13	25-to-50	0.00	[empty string]	Ballistic Tip Bullet - Lead Free - .204 - 32gr - Spitzer - 100 Ct	The Ballistic Tip Lead-Free (BTLF) is everything that varmint and predator hunters expect from a Ballistic Tip, in a lead-free design. The flat-based, leadless bullet features Nosler’s exclusive Fragmenting Copper Core Technology which exhibits immediate and rapid expansion, initiated by its metallic-colored polymer tip, at practical varmint shooting velocities of 1600 fps and above. The BTLF can safely be used in all lead-free zones or shooting ranges that require non-magnetic bullets. <br/> <br/> NOTE: BALLISTIC TIP COLOR VARIES ACCORDING TO BULLET CALIBUR - SEE ALTERNATE IMAGE ABOVE<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	29.99	29.99	[empty string]	[empty string]	[empty string]	1000	45140	113223	EMPTY	EMPTY	EMPTY	0	0	0	RELOADING	[empty string]	nosler/20cal-bullets-32gr-bt-lead-free-113223	1
11	[empty string]	NOSLER	NOSLER	FIREARMS	Firearms>Reloading>Bullets	[empty string]	1	21.99	0	21.99	38618-DEFAULT-l.jpg	21.99	38618-DEFAULT-m.jpg	22CAL BULLET 55GR VARMEGEDDON FB TIPPED	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]	2012	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	3	20-to-25	0.00	[empty string]	Varmageddon Bullet - 22 Cal - .224 - 55 Gr - Fb Tipped - 100 Count	Varmageddon bullets are manufactured using a highly efficient process, providing legendary Nosler quality and accuracy at an economical price. They are made with a lead-alloy core and feature a copper-alloy jacket designed to withstand high velocities yet expand immediately upon impact. <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	21.99	21.99	[empty string]	38618-DEFAULT-s.jpg	[empty string]	1000	17240	143830	EMPTY	EMPTY	EMPTY	0	0	0	RELOADING	[empty string]	nosler/22cal-bullet-55gr-varmegeddon-fb-tipped-143830	1
12	[empty string]	NOSLER	NOSLER	FIREARMS	Firearms>Reloading>Bullets	[empty string]	1	41.99	0	41.99	38606-DEFAULT-l.jpg	41.99	38606-DEFAULT-m.jpg	30CAL BULLET 110GR VARMAGEDDON FB TIPPED	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]	ACTIVE	ONLINE	[empty string]	[empty string]	73	25-to-50	0.00	[empty string]	Varmageddon Bullet - 30 Cal - .308 - 110 Gr - Fb Tipped	<p>Varmageddon bullets are manufactured using a highly efficient process, providing legendary Nosler quality and accuracy at an economical price. They are made with a lead-alloy core and feature a copper-alloy jacket designed to withstand high velocities yet expand immediately upon impact. </p>	[empty string]	N	41.99	41.99	[empty string]	38606-DEFAULT-s.jpg	[empty string]	1000	34057	159978	EMPTY	EMPTY	EMPTY	0	0	0	RELOADING	[empty string]	nosler/30cal-bullet-110gr-varmageddon-fb-tipped-159978	1
13	[empty string]	NOSLER	NOSLER	FIREARMS	Firearms>Rifles	[empty string]	0	1315	0	1635	[empty string]	1315	[empty string]	M48 PATRIOT RIFLE 26 NOSLER	N	11 JJ	26 NOSLER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	NONE	NOSLER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SO	ONLINE	BOLT	RIFLE	1	500-or-more	0.00	[empty string]	M48 Patriot Rifle 26 Nosler	[empty string]	[empty string]	N	1635	1635	[empty string]	[empty string]	[empty string]	1000	32948	178613	EMPTY	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	nosler/m48-patriot-rifle-26-nosler-178613	1
14	[empty string]	NOSLER	NOSLER	FIREARMS	Firearms>Reloading>Brass	[empty string]	0	79.99	0	79.99	[empty string]	79.99	[empty string]	30 NOSLER BULK BRASS	N	16 TOM	30 NOSLER	[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	[empty string]	[empty string]	[empty string]	5	50-to-100	0.00	[empty string]	30 Nosler Bulk Brass	Made in the USA, Nosler custom brass is weighed and sorted for maximum accuracy and consistency. The custom brass brings premium quality cartridge cases bearing the Nosler head stamp to the reloader. This model is 30 Nosler and comes packaged 25 per box.	[empty string]	N	79.99	79.99	[empty string]	[empty string]	[empty string]	1000	10221	265604	EMPTY	EMPTY	EMPTY	0	0	0	RELOADING	[empty string]	nosler/30-nosler-bulk-brass-265604	1
15	[empty string]	NOSLER	NOSLER	FIREARMS	Firearms>Reloading>Brass	[empty string]	0	68.99	0	68.99	[empty string]	68.99	[empty string]	223 REM BRASS 100CT	N	16 TOM	223 REM	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2016	[empty string]	[empty string]	SELL THRU	[empty string]	[empty string]	[empty string]	6	50-to-100	0.00	[empty string]	223 Rem Brass 100ct	[empty string]	[empty string]	N	68.99	68.99	[empty string]	[empty string]	[empty string]	1000	10098	277177	EMPTY	EMPTY	EMPTY	0	0	0	RELOADING	[empty string]	nosler/223-rem-brass-100ct-277177	1
16	[empty string]	NOSLER	NOSLER	FIREARMS	Firearms>Reloading>Bullets	[empty string]	1	49.99	0	49.99	85528-DEFAULT-l.jpg	49.99	85528-DEFAULT-m.jpg	22CAL BULLETS 77GR CUSTOM COMPETITION	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]	2021	[empty string]	[empty string]	SO	[empty string]	[empty string]	[empty string]	4	25-to-50	0.00	[empty string]	22cal Bullets 77gr Custom Competition	[empty string]	[empty string]	N	49.99	49.99	[empty string]	85528-DEFAULT-s.jpg	[empty string]	1000	22421	352784	EMPTY	EMPTY	EMPTY	0	0	0	RELOADING	[empty string]	nosler/22cal-bullets-77gr-custom-competition-352784	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Filter