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]	FRIGID FORAGE	Frigid Forage	HUNTING	Hunting>Food Plots and Feeding>Seed	[empty string]	0	39.99	0	39.99	[empty string]	39.99	[empty string]	WILDGAME BUFFET 4.25LBS PERENNIAL SEED	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]	SPRING	[empty string]	2009	[empty string]	BOTH	ACTIVE	ONLINE	[empty string]	[empty string]	30	25-to-50	0.00	[empty string]	Wild Game Buffet - 4 Lbs - 1/2 Acre	<p>Wild Game Buffet can be planted in the Spring or late summer/early fall and can be planted in most areas from full sun to shade. It works great on trails and small plots or openings in the woods but does not like sandy or very dry soils.</p> <p> </p> <p><strong>Please call 989-386-1534 for orders of multiple items</strong></p>	[empty string]	N	39.99	39.99	[empty string]	[empty string]	[empty string]	1000	WLDGMB4	96906	SEED	EMPTY	EMPTY	0	0	0	FOOD PLOTS AND FEEDING	[empty string]	frigid-forage/wildgame-buffet-4-25lbs-perennial-seed-96906	1
2	[empty string]	FRIGID FORAGE	Frigid Forage	HUNTING	Hunting>Food Plots and Feeding>Seed	[empty string]	0	64.99	0	64.99	[empty string]	64.99	[empty string]	WILDGAME BUFFET PER 8.5LB PERENNIAL SEED	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]	SPRING	[empty string]	2009	[empty string]	BOTH	ACTIVE	ONLINE	[empty string]	[empty string]	10	50-to-100	0.00	[empty string]	Wild Game Buffet - 8.5 Lbs - 1 Acre	<p>Wild Game Buffet can be planted in the Spring or late summer/early fall and can be planted in most areas from full sun to shade. It works great on trails and small plots or openings in the woods but does not like sandy or very dry soils.</p> <p> </p> <p><strong>Please call 989-386-1534 for orders of multiple items</strong></p>	[empty string]	N	64.99	64.99	[empty string]	[empty string]	[empty string]	1000	WLDGM8.5	96907	SEED	EMPTY	EMPTY	0	0	0	FOOD PLOTS AND FEEDING	[empty string]	frigid-forage/wildgame-buffet-per-8-5lb-perennial-seed-96907	1
3	[empty string]	FRIGID FORAGE	Frigid Forage	HUNTING	Hunting>Food Plots and Feeding>Seed	[empty string]	0	64.99	0	64.99	[empty string]	64.99	[empty string]	THE WALL HANGER 8.5 PERENNIAL SEED	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	INSTORE PICK UP ONLY	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	SPRING	[empty string]	2009	[empty string]	BOTH	ACTIVE	ONLINE	[empty string]	[empty string]	8	50-to-100	0.00	[empty string]	Wall Hanger - 8.5 Lbs - 1 Acre	<p>Wild Game Buffet can be planted in the Spring or late summer/early fall and can be planted in a variety of conditions but does best in lighter soils in full sun. Can handle sandy soils and extended dry periods once established.</p> <p> </p> <p><strong>Please call 989-386-1534 for orders of multiple items</strong></p>	[empty string]	N	64.99	64.99	[empty string]	[empty string]	[empty string]	1000	WALLHNG8.5	96910	SEED	EMPTY	EMPTY	0	0	0	FOOD PLOTS AND FEEDING	[empty string]	frigid-forage/the-wall-hanger-8-5-perennial-seed-96910	1
4	[empty string]	FRIGID FORAGE	Frigid Forage	HUNTING	Hunting>Food Plots and Feeding>Seed	[empty string]	0	49.99	0	49.99	[empty string]	49.99	[empty string]	MONSTER MAGNET 8.5LBS ANNUAL SEED	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]	SPRING	[empty string]	2009	[empty string]	BOTH	ACTIVE	NOT ONLINE	[empty string]	[empty string]	17	25-to-50	0.00	[empty string]	Monster Magnet - 8.5 Lbs - 1/3 Acre	FEATURES:<BR/> -Monster Magnet is an all-around mix that is high in nutrition. -An all-around mix of annuals and biennials that is a high nutrition smorgasbord for your deer. -Offers protein levels up to 40% for building a larger bodied and larger antlered deer herd. -Monster Magnet is unique in that it is one planting that will benefit growing bucks and nursing does throughout the summer, yet still provide critical nutrition during the late season and cold winter months. -Deer will seek out the forage beans and peas early on and then come back for the rape and turnips late into the year. -A great way to provide both nutrition and attraction throughout the entire season. -Plate late Spring or early Summer. -Does best in full sun -Seeding rate is 25 lbs/acre. -8.5 lb. bag will plant up to 1/3 acre.<br/> 8.5lb Bag Contains: Spring forage peas, soybeans, sunflowers, rye grain, crimson clover, common vetch, forage turnips, sugar beets, and Daikon forage radish.<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]	[empty string]	[empty string]	1000	MONSM8.5	96911	SEED	EMPTY	EMPTY	0	0	0	FOOD PLOTS AND FEEDING	[empty string]	frigid-forage/monster-magnet-8-5lbs-annual-seed-96911	1
5	[empty string]	FRIGID FORAGE	Frigid Forage	HUNTING	Hunting>Food Plots and Feeding>Seed	[empty string]	0	74.99	0	74.99	[empty string]	74.99	[empty string]	BIG-N-BEASTY 8.5LBS ANNUAL SEED	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]	SPRING	[empty string]	2009	[empty string]	BOTH	ACTIVE	ONLINE	[empty string]	[empty string]	5	50-to-100	0.00	[empty string]	Big-n-beasty - 8.5 Lb - 2 Acres	<p>Big-n-Beasty is typically planted late July to early August depending on your local.  Needs approximately 45-60 day growing season. Best if planted just before a rain.</p> <p> </p> <p><strong>Please call 989-386-1534 for orders of multiple items</strong></p>	[empty string]	N	74.99	74.99	[empty string]	[empty string]	[empty string]	1000	BNBB8.5	96916	SEED	EMPTY	EMPTY	0	0	0	FOOD PLOTS AND FEEDING	[empty string]	frigid-forage/big-n-beasty-8-5lbs-annual-seed-96916	1
6	[empty string]	FRIGID FORAGE	Frigid Forage	HUNTING	Hunting>Food Plots and Feeding>Seed	[empty string]	0	39.99	0	39.99	[empty string]	39.99	[empty string]	AUTUMN QUICK PLOT 8.5 LBS ANNUAL SEED	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	INSTORE PICK UP ONLY	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	FALL	[empty string]	2009	[empty string]	BOTH	ACTIVE	ONLINE	[empty string]	[empty string]	10	25-to-50	0.00	[empty string]	Autumn Quick Plot - 8.5 Lbs - 1/3 Acre	<p>Autumn Quick Plot is a fast growing blend of annuals and biennials formulated to be planted fom late Summer to early Fall.  Planting Fall food plots provides a fresh green option for your deer when most natural and agricultural sources are maturing and drying up.  The fresh green growth of AQP will help draw deer into huntable locations while providing a good high-energy food source prior to winter.  The winter peas, winter wheat, and forage brassicas in AQP will stay green long after a hard frost, providing a great draw late into the season.</p> <p> </p> <p><strong>Please call 989-386-1534 for orders of multiple items</strong></p>	[empty string]	N	39.99	39.99	[empty string]	[empty string]	[empty string]	1000	AQP8.5	104454	SEED	EMPTY	EMPTY	0	0	0	FOOD PLOTS AND FEEDING	[empty string]	frigid-forage/autumn-quick-plot-8-5-lbs-annual-seed-104454	1
7	[empty string]	FRIGID FORAGE	Frigid Forage	HUNTING	Hunting>Food Plots and Feeding>Seed	[empty string]	0	39.99	0	39.99	[empty string]	39.99	[empty string]	THE WALL HANGER 4.25 PERENNIAL SEED	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]	SPRING	[empty string]	2009	[empty string]	BOTH	ACTIVE	ONLINE	[empty string]	[empty string]	37	25-to-50	0.00	[empty string]	Wall Hanger - 4 Lbs - 1/2 Acre	<p>Since Wall Hanger contains alfalfa, chicory and clover, it can be planted in a variety of conditions but does best in lighter soils in full sun. Can handle sandy soils and extended dry periods once established.</p>	[empty string]	N	39.99	39.99	[empty string]	[empty string]	[empty string]	1000	WALLHNG4	111931	SEED	EMPTY	EMPTY	0	0	0	FOOD PLOTS AND FEEDING	[empty string]	frigid-forage/the-wall-hanger-4-25-perennial-seed-111931	1
8	[empty string]	FRIGID FORAGE	Frigid Forage	HUNTING	Hunting>Food Plots and Feeding>Seed	[empty string]	0	99.99	0	99.99	[empty string]	99.99	[empty string]	AUTUMN QUICK PLOT 25 LBS ANNUAL SEED	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	INSTORE PICK UP ONLY	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	FALL	[empty string]	2009	[empty string]	BOTH	ACTIVE	ONLINE	[empty string]	[empty string]	3	50-to-100	0.00	[empty string]	Autumn Quick Plot - 25 Lbs - 1 Acre	<p>Autumn Quick Plot is a fast growing blend of annuals and biennials formulated to be planted fom late Summer to early Fall.  Planting Fall food plots provides a fresh green option for your deer when most natural and agricultural sources are maturing and drying up.  The fresh green growth of AQP will help draw deer into huntable locations while providing a good high-energy food source prior to winter.  The winter peas, winter wheat, and forage brassicas in AQP will stay green long after a hard frost, providing a great draw late into the season.</p>	[empty string]	N	99.99	99.99	25LBS	[empty string]	[empty string]	1000	AQP25	111933	SEED	EMPTY	EMPTY	0	0	0	FOOD PLOTS AND FEEDING	[empty string]	frigid-forage/autumn-quick-plot-25-lbs-annual-seed-111933	1
9	ANNUAL	FRIGID FORAGE	Frigid Forage	HUNTING	Hunting>Food Plots and Feeding>Seed	ANNUAL\|NULL\|NULL	0	44.99	0	44.99	[empty string]	44.99	[empty string]	BIG-N-BEASTY 4.25LBS ANNUAL SEED	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	INSTORE PICK UP ONLY	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	SPRING	[empty string]	2011	[empty string]	BOTH	ACTIVE	ONLINE	[empty string]	[empty string]	30	25-to-50	0.00	[empty string]	Big-n-beasty - 4 Lbs - 1 Acre	<p>Big-n-Beasty is typically planted late July to early August depending on your local.  Needs approximately 45-60 day growing season. Best if planted just before a rain.</p> <p> </p> <p><strong>Please call 989-386-1534 for orders of multiple items</strong></p>	[empty string]	N	44.99	44.99	4LBS	[empty string]	[empty string]	1000	BNB4	131697	SEED	EMPTY	EMPTY	0	0	0	FOOD PLOTS AND FEEDING	[empty string]	frigid-forage/big-n-beasty-4-25lbs-annual-seed-131697	1
10	ANNUAL	FRIGID FORAGE	Frigid Forage	HUNTING	Hunting>Food Plots and Feeding>Seed	ANNUAL\|NULL\|NULL	0	49.99	0	49.99	[empty string]	49.99	[empty string]	PLOT SCREEN ANNUAL 8.5LB PLANTS 1/2 ACRE	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]	SPRING	[empty string]	2012	[empty string]	BOTH	ACTIVE	ONLINE	[empty string]	[empty string]	2	25-to-50	0.00	[empty string]	Plot Screen - 8.5 Lbs - 1/2 Acre	<p>Plot Screen grows in most any soil given proper sunlight, nutrients, and moisture but it prefers a moist but well drained heavier soil. Before planting, condition the soil with a roto-tiller, plow, disc, or similar equipment to a depth of about 6".</p> <p> </p> <p><strong>Please call 989-386-1534 for orders of multiple items</strong></p>	[empty string]	N	49.99	49.99	8.5LB	[empty string]	[empty string]	1000	PLOT8.5	150292	SEED	EMPTY	EMPTY	0	0	0	FOOD PLOTS AND FEEDING	[empty string]	frigid-forage/plot-screen-annual-8-5lb-plants-1-2-acre-150292	1
11	ANNUAL	FRIGID FORAGE	Frigid Forage	HUNTING	Hunting>Food Plots and Feeding>Seed	ANNUAL\|NULL\|NULL	0	119.99	0	119.99	[empty string]	119.99	[empty string]	PLOT SCREEN ANNUAL 25LB PLANTS 1.5 ACRE	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]	SPRING	[empty string]	2012	[empty string]	BOTH	ACTIVE	ONLINE	[empty string]	[empty string]	8	100-to-150	0.00	[empty string]	Plot Screen - 25 Lbs - 1.5 Acre	<p>Plot Screen grows in most any soil given proper sunlight, nutrients, and moisture but it prefers a moist but well drained heavier soil. Before planting, condition the soil with a roto-tiller, plow, disc, or similar equipment to a depth of about 6".</p>	[empty string]	N	119.99	119.99	25LB	[empty string]	[empty string]	1000	PLOT 25	150293	SEED	EMPTY	EMPTY	0	0	0	FOOD PLOTS AND FEEDING	[empty string]	frigid-forage/plot-screen-annual-25lb-plants-1-5-acre-150293	1
12	PERRENNIAL	FRIGID FORAGE	Frigid Forage	HUNTING	Hunting>Food Plots and Feeding>Seed	PERRENNIAL\|NULL\|NULL	0	64.99	0	64.99	[empty string]	64.99	[empty string]	PURE TROPHY CLOVER PERRENNIAL 1 ACRE	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]	SPRING	[empty string]	2013	[empty string]	BOTH	ACTIVE	ONLINE	[empty string]	[empty string]	23	50-to-100	0.00	[empty string]	Pure Trophy Clover - Perennial Blend - 8.5 Lbs - 1 Acre	<p>The Frigid Forage Pure Trophy Clover is exactly what the name implies, 100% clover. Pure Trophy Clover is a blend of five different clovers and will provide a high protein food source for deer and other wildlife from early Spring all the way to hunting season! The advantage of planting blends, is that they are more versatile and will thrive in a wider range of conditions making them an ideal choice for most any situation from open fields all the way to shaded areas and woodland trails.</p> <p> </p> <p><strong>Please call 989-386-1534 for orders of multiple items</strong></p>	[empty string]	N	64.99	64.99	8.5LBS	[empty string]	[empty string]	1000	PRCLVR8.5	162082	SEED	EMPTY	EMPTY	0	0	0	FOOD PLOTS AND FEEDING	[empty string]	frigid-forage/pure-trophy-clover-perrennial-1-acre-162082	1
13	[empty string]	FRIGID FORAGE	Frigid Forage	HUNTING	Hunting>Food Plots and Feeding>Seed	[empty string]	0	129.99	1	49.99	[empty string]	129.99	[empty string]	PLOW-DOWN-CLOVER	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	INSTORE PICK UP ONLY	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	SPRING	[empty string]	2015	[empty string]	BOTH	ACTIVE	ONLINE	[empty string]	[empty string]	13	25-to-50	0.00	[empty string]	Plow Down Clover Blend	<p>Plow Down Clover is a blend of fast growing annual and bi-annual clovers formulated to provide a cover crop for any plot that you intend to plant a late season annual such as Big n Beasty. As the name implies, Plow-Down is planted in the Spring and then plowed under when you are ready to re-plant the field.</p> <p> </p> <p><strong>Please call 989-386-1534 for orders of multiple items</strong></p>	[empty string]	N	49.99	129.99	8.5,25L	[empty string]	[empty string]	1000	PDC	249928	SEED	EMPTY	EMPTY	0	0	0	FOOD PLOTS AND FEEDING	[empty string]	frigid-forage/plow-down-clover-249928	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Filter