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]	BIG AND J INDUSTRIES	Big And J Industries	HUNTING	Hunting>Food Plots and Feeding>Attractants and Minerals	[empty string]	1	19.99	0	19.99	25039-DEFAULT-l.jpg	19.99	25039-DEFAULT-m.jpg	BB2 DEER ATTRACTANT 20LBS	N	9 BILL	[empty string]	[empty string]	[empty string]	V	INSTORE PICK UP ONLY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2011	[empty string]	BOTH	ACTIVE	NOT ONLINE	[empty string]	[empty string]	6	15-to-20	0.00	[empty string]	Bb2 Deer Attractant - 20 Pounds	<p>If you want to shoot a big buck, you need to get it onto your property. In this era of food plots and property management, deer will choose to go to the setup that’s best. BB<sup>2</sup> is your secret weapon. Its powerful aroma, the result of a proprietary refining process, draws deer from farther away. But BB<sup>2</sup> is not just an attractant. In fact, it has a TDN (total digestible nutrition) level that is higher than virtually all premium feeds. And a high level of protein. This brings the big bucks out and keeps deer coming back all season long. During pre-season, use BB<sup>2</sup> to establish travel patterns and acclimate deer to your property. By middle to late summer, use BB<sup>2</sup> to attract deer to your camera sites to inventory your bucks. In season, use BB<sup>2</sup> to bring the big bucks out during shooting hours and to keep all deer on your property.</p> <p> </p> <ul> <li>An intense, natural aroma created through a proprietary refining process</li> <li>Exceptionally high TDN</li> <li>Protein-based formula promotes antler growth</li> <li>Keeps deer on your property during the season and all year long</li> </ul>	[empty string]	N	19.99	19.99	20LBS	25039-DEFAULT-s.jpg	[empty string]	1000	BB2-20	130497	EMPTY	EMPTY	EMPTY	0	0	0	FOOD PLOTS AND FEEDING	[empty string]	big-and-j-industries/bb2-deer-attractant-20lbs-130497	1
2	[empty string]	BIG AND J INDUSTRIES	Big And J Industries	HUNTING	Hunting>Food Plots and Feeding>Attractants and Minerals	[empty string]	1	34.99	0	34.99	94336-DEFAULT-l.jpg	34.99	94336-DEFAULT-m.jpg	BB2 DEER ATTRACTANT 40LBS	N	9 BILL	[empty string]	[empty string]	[empty string]	V	INSTORE PICK UP ONLY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2011	[empty string]	BOTH	ACTIVE	NOT ONLINE	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	Bb2 Long Range Attractants - 40 Lbs	<p>If you want to shoot a big buck, you need to get it onto your property. In this era of food plots and property management, deer will choose to go to the setup that’s best. BB<sup>2</sup> is your secret weapon. Its powerful aroma, the result of a proprietary refining process, draws deer from farther away. But BB<sup>2</sup> is not just an attractant. In fact, it has a TDN (total digestible nutrition) level that is higher than virtually all premium feeds. And a high level of protein. This brings the big bucks out and keeps deer coming back all season long. During pre-season, use BB<sup>2</sup> to establish travel patterns and acclimate deer to your property. By middle to late summer, use BB<sup>2</sup> to attract deer to your camera sites to inventory your bucks. In season, use BB<sup>2</sup> to bring the big bucks out during shooting hours and to keep all deer on your property.</p> <p> </p> <ul> <li>An intense, natural aroma created through a proprietary refining process</li> <li>Exceptionally high TDN</li> <li>Protein-based formula promotes antler growth</li> <li>Keeps deer on your property during the season and all year long</li> </ul>	[empty string]	N	34.99	34.99	40LBS	94336-DEFAULT-s.jpg	[empty string]	1000	BB240	130500	EMPTY	EMPTY	EMPTY	0	0	0	FOOD PLOTS AND FEEDING	[empty string]	big-and-j-industries/bb2-deer-attractant-40lbs-130500	1
3	[empty string]	BIG AND J INDUSTRIES	Big And J Industries	HUNTING	Hunting>Food Plots and Feeding>Attractants and Minerals	[empty string]	1	14.99	0	14.99	49196-DEFAULT-l.jpg	14.99	49196-DEFAULT-m.jpg	DEADLY DUST 5LBS	N	9 BILL	[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]	BOTH	ACTIVE	NOT ONLINE	[empty string]	[empty string]	6	10-to-15	0.00	[empty string]	Deadly Dust - 5 Lb Bag	<p>There’s probably nothing in nature deer love more than sweet corn! This is because of sweet corn’s natural sweetness. Deadly Dust is a sweet corn powder that is derived from the sweetest sweet corn hybrid available – with over 5 times the sugar content of field corn! Deer love the smell of Deadly Dust and the taste will drive them wild. Pour it near your stand or in front of your cameras. Or, use it to supercharge your field corn. Deadly Dust, is better than bait!</p> <p> </p> <ul> <li>Made with a special hybrid sweet corn (real, not synthetic) that’s over 5 times sweeter than ordinary field corn</li> <li>Contains over 50% real sweet corn</li> <li>Deer can’t resist the smell and taste of sweet corn</li> <li>Pour Deadly Dust on the ground adjacent to your stand or in front of your cameras</li> <li>Supercharge your field corn by mixing in Deadly Dust</li> </ul>	[empty string]	N	14.99	14.99	5LBS	49196-DEFAULT-s.jpg	[empty string]	1000	BB2-DD-5	250630	EMPTY	EMPTY	EMPTY	0	0	0	FOOD PLOTS AND FEEDING	[empty string]	big-and-j-industries/deadly-dust-5lbs-250630	1
4	[empty string]	BIG AND J INDUSTRIES	Big And J Industries	HUNTING	Hunting>Food Plots and Feeding>Attractants and Minerals	[empty string]	1	12.99	0	12.99	94338-DEFAULT-l.jpg	12.99	94338-DEFAULT-m.jpg	LEGIT MINERAL MIX 5LBS	N	9 BILL	[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]	BOTH	ACTIVE	ONLINE	[empty string]	[empty string]	17	10-to-15	0.00	[empty string]	Legit - 5 Lb Bag	<p>There are many mineral products, but most are glorified salt. Of the few "true" minerals, only one is also a long-range attractant – Legit from BIG&J. The intense apple aroma and flavor will draw deer from far and wide. The high calcium/phosphorus content promotes antler growth and meet the deficiency in the natural habitat. Legit includes trace minerals that are essential to reproductive function and healthy bone growth/antler growth.</p> <p> </p> <ul> <li>A “true” mineral product, not just glorified salt</li> <li>Intense apple aroma and flavor attracts deer and keeps them coming back for more</li> <li>Give your deer all of the essential minerals they need for optimal health, including calcium and phosphorus for growing antlers</li> </ul>	[empty string]	N	12.99	12.99	5LBS	94338-DEFAULT-s.jpg	[empty string]	1000	BB2-LG5	250631	EMPTY	EMPTY	EMPTY	0	0	0	FOOD PLOTS AND FEEDING	[empty string]	big-and-j-industries/legit-mineral-mix-5lbs-250631	1
5	[empty string]	BIG AND J INDUSTRIES	Big And J Industries	HUNTING	Hunting>Food Plots and Feeding>Attractants and Minerals	[empty string]	1	24.99	0	24.99	94339-DEFAULT-l.jpg	24.99	94339-DEFAULT-m.jpg	BB2 HEADRUSH NMINERAL 20LB	N	9 BILL	[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]	2019	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	3	20-to-25	0.00	[empty string]	Bb2 Headrush Nmineral 20lb	<p>Headrush is a product that will not only aid in adding inches of bone, but the aroma and flavor will literally mess with their mind. Headrush is a salt-based formula with added Calcium and bioavailable trace mineral sources of Zinc, Manganese, Copper and Cobalt. We all know that deer love salt even when it is not fortified with other ingredients. Big and J has taken salt based supplements to the next level by adding an aroma that deer cannot resist,Calcium (a major component in bone and antler growth), and bioavailable trace elements that aid in cellular function and overall herd health. When to feed: Year round. </p>	[empty string]	N	24.99	24.99	20LB	94339-DEFAULT-s.jpg	[empty string]	1000	BB2-BKM20	316031	EMPTY	EMPTY	EMPTY	0	0	0	FOOD PLOTS AND FEEDING	[empty string]	big-and-j-industries/bb2-headrush-nmineral-20lb-316031	1
6	[empty string]	BIG AND J INDUSTRIES	Big And J Industries	HUNTING	Hunting>Food Plots and Feeding>Attractants and Minerals	[empty string]	1	10.99	0	10.99	89669-DEFAULT-l.jpg	10.99	89669-DEFAULT-m.jpg	BB2 LIQUID DEER ATTRACTANT 1 GALLON	N	9 BILL	[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]	2019	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	6	10-to-15	0.00	[empty string]	Bb2 Liquid Deer Attractant 1 Gallon	<p>Super charge the feed site with the attractant power of BB<sup>2</sup> liquid.  Pour it on the ground or blend in with other feeds to give the area the attracting aroma and taste that Big and J is known for.  Unlike other liquid attractants that are flavored sugar water, BB<sup>2</sup> liquid offers some nutritional value with a protein content of 8% and fat content of 2%.  In addition, BB<sup>2</sup> liquid provides salt that deer love and calcium and phosphorus they need to promote bone growth.</p> <p> </p> <ul> <li>Intense aroma attracts deer from far and wide</li> <li>Pour on ground or stump near stand to attract deer right away</li> <li>Specially formulated nutrients that deer crave</li> <li>Protein-based formula promotes antler growth</li> </ul>	[empty string]	N	10.99	10.99	GALLON	89669-DEFAULT-s.jpg	[empty string]	1000	BB2-LL1G	325378	EMPTY	EMPTY	EMPTY	0	0	0	FOOD PLOTS AND FEEDING	[empty string]	big-and-j-industries/bb2-liquid-deer-attractant-1-gallon-325378	1
7	[empty string]	BIG AND J INDUSTRIES	Big And J Industries	HUNTING	Hunting>Food Plots and Feeding>Attractants and Minerals	[empty string]	1	12.99	0	12.99	94341-DEFAULT-l.jpg	12.99	94341-DEFAULT-m.jpg	TO-DIE-FOR 5LB	N	9 BILL	[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]	5	10-to-15	0.00	[empty string]	To-die-for 5lb	<p>To-Die-For provides the amazing attraction power of real sweet corn, something all deer love thanks to its high sugar content. Made from a special hybrid sweet corn that’s over 5 times sweeter than field corn, To-Die-For gives deer what they want! To-Die-For also features BB<sup>2</sup> which has a TDN (total digestible nutrition) value that’s higher even than most premium feeds. In other words, it gives deer what their bodies need and crave. Combine the want with the need and, with To-Die-For, you get a whole attractant with attraction power that is second to none! And, like every BIG&J’s long-range attractant, the aroma is super strong.</p> <p> </p> <ul> <li>Made from a special hybrid sweet corn that's over 5 times sweeter than field corn</li> <li>To-Die-For also features BB2 which has a TDN (total digestible nutrition) value that's higher even than most premium feeds.</li> <li>With the want and need, To-Die-For, you get a whole attractant with attraction power that is second to none! And, like every BIG & J's long range attractant, the aroma is super strong!</li> </ul>	[empty string]	N	12.99	12.99	5LB	94341-DEFAULT-s.jpg	[empty string]	1000	BB2-TDF5	333103	EMPTY	EMPTY	EMPTY	0	0	0	FOOD PLOTS AND FEEDING	[empty string]	big-and-j-industries/to-die-for-5lb-333103	1
8	[empty string]	BIG AND J INDUSTRIES	Big And J Industries	HUNTING	Hunting>Food Plots and Feeding>Attractants and Minerals	[empty string]	1	24.99	0	24.99	94342-DEFAULT-l.jpg	24.99	94342-DEFAULT-m.jpg	TO-DIE-FOR 20LB	N	9 BILL	[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]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	2	20-to-25	0.00	[empty string]	To-die-for 20lb	<p>To-Die-For provides the amazing attraction power of real sweet corn, something all deer love thanks to its high sugar content. Made from a special hybrid sweet corn that’s over 5 times sweeter than field corn, To-Die-For gives deer what they want! To-Die-For also features BB<sup>2</sup> which has a TDN (total digestible nutrition) value that’s higher even than most premium feeds. In other words, it gives deer what their bodies need and crave. Combine the want with the need and, with To-Die-For, you get a whole attractant with attraction power that is second to none! And, like every BIG&J’s long-range attractant, the aroma is super strong.</p> <p> </p> <ul> <li>Made from a special hybrid sweet corn that's over 5 times sweeter than field corn</li> <li>To-Die-For also features BB2 which has a TDN (total digestible nutrition) value that's higher even than most premium feeds.</li> <li>With the want and need, To-Die-For, you get a whole attractant with attraction power that is second to none! And, like every BIG & J's long range attractant, the aroma is super strong!</li> </ul>	[empty string]	N	24.99	24.99	20LB	94342-DEFAULT-s.jpg	[empty string]	1000	BB2-TDF20	333105	EMPTY	EMPTY	EMPTY	0	0	0	FOOD PLOTS AND FEEDING	[empty string]	big-and-j-industries/to-die-for-20lb-333105	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Filter