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]	BEAR ARCHERY	Bear Archery	ARCHERY	Archery>Traditional Bows and Accessories>Bows	[empty string]	0	549.99	0	549.99	[empty string]	549.99	[empty string]	SUPER KODIAK 45# RH RECURVE	N	2 BOB	[empty string]	[empty string]	[empty string]	A	[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]	1	500-or-more	0.00	[empty string]	Super Kodiak - 45 Lbs - Right - Black	<p>Super Kodiak is one of the smoothest, finest shooting bows available, this model of bow was used by Fred Bear in his African quests for Lion, Cape Buffalo, Alaskan Polar Bear and British Columbia Grizzly Bear.<br /> <br /> <br /> <br />  </p>	[empty string]	N	549.99	549.99	[empty string]	[empty string]	[empty string]	1000	AFT2020145	123709	EMPTY	EMPTY	EMPTY	0	0	0	TRADITIONAL BOWS AND ACCESSORIES	[empty string]	bear-archery/super-kodiak-45-rh-recurve-123709	1
2	[empty string]	BEAR ARCHERY	Bear Archery	ARCHERY	Archery>Traditional Bows and Accessories>Bows>Long Bows	[empty string]	0	579.99	0	579.99	[empty string]	579.99	[empty string]	AUSABLE LONGBOW 64 - 50# RH	N	2 BOB	[empty string]	[empty string]	[empty string]	A	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2018	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	1	500-or-more	0.00	[empty string]	Ausable 64 In - 50 Lbs - Right Hand	<p>The Au Sable longbow, aptly named after Michigan`s famous Au Sable River, was introduced in 2011. It’s been well received by longbow enthusiasts due to its reflex/deflex design, larger sight window, full-radiused grip, and crowned, and cut-on center arrow shelf. Maple and Bamboo-core limbs make this bow smooth, quiet, and fast.</p>	[empty string]	N	579.99	579.99	[empty string]	[empty string]	[empty string]	1000	AALB1150R	123717	EMPTY	LONG BOWS	EMPTY	0	0	0	TRADITIONAL BOWS AND ACCESSORIES	[empty string]	bear-archery/ausable-longbow-64-50-rh-123717	1
3	[empty string]	BEAR ARCHERY	Bear Archery	ARCHERY	Archery>Traditional Bows and Accessories>Bows>Long Bows	[empty string]	0	579.99	0	579.99	[empty string]	579.99	[empty string]	AUSABLE LONGBOW 64 - 55# RH	N	2 BOB	[empty string]	[empty string]	[empty string]	A	[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]	1	500-or-more	0.00	[empty string]	Ausable - 55 Lbs - Right Hand	<p>The Au Sable longbow, aptly named after Michigan`s famous Au Sable River, was introduced in 2011. It’s been well received by longbow enthusiasts due to its reflex/deflex design, larger sight window, full-radiused grip, and crowned, and cut-on center arrow shelf. Maple and Bamboo-core limbs make this bow smooth, quiet, and fast.</p>	[empty string]	N	579.99	579.99	[empty string]	[empty string]	[empty string]	1000	AALB1155R	123718	EMPTY	LONG BOWS	EMPTY	0	0	0	TRADITIONAL BOWS AND ACCESSORIES	[empty string]	bear-archery/ausable-longbow-64-55-rh-123718	1
4	[empty string]	BEAR ARCHERY	Bear Archery	ARCHERY	Archery>Traditional Bows and Accessories>Bows	[empty string]	0	889.99	0	889.99	[empty string]	889.99	[empty string]	RECURVE TD B RISER #1 LIMB 50# RH BLK MAPLE	N	2 BOB	[empty string]	[empty string]	[empty string]	A	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2019	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	1	500-or-more	0.00	[empty string]	Recurve Td B Riser #1 Limb 50# Rh Blk Maple	[empty string]	[empty string]	N	889.99	889.99	[empty string]	[empty string]	[empty string]	1000	ATDB1150R	133670	EMPTY	EMPTY	EMPTY	0	0	0	TRADITIONAL BOWS AND ACCESSORIES	[empty string]	bear-archery/recurve-td-b-riser-1-limb-50-rh-blk-maple-133670	1
5	[empty string]	BEAR ARCHERY	Bear Archery	ARCHERY	Archery>Traditional Bows and Accessories>Bows>Long Bows	[empty string]	0	579.99	0	579.99	[empty string]	579.99	[empty string]	AUSABLE LONGBOW 64 - 40# RH	N	2 BOB	[empty string]	[empty string]	[empty string]	A	[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]	1	500-or-more	0.00	[empty string]	Ausable - 40 Lbs - Right Hand	<p>The Au Sable longbow, aptly named after Michigan`s famous Au Sable River, was introduced in 2011. It’s been well received by longbow enthusiasts due to its reflex/deflex design, larger sight window, full-radiused grip, and crowned, and cut-on center arrow shelf. Maple and Bamboo-core limbs make this bow smooth, quiet, and fast.</p>	[empty string]	N	579.99	579.99	[empty string]	[empty string]	[empty string]	1000	AALB1140R	164436	EMPTY	LONG BOWS	EMPTY	0	0	0	TRADITIONAL BOWS AND ACCESSORIES	[empty string]	bear-archery/ausable-longbow-64-40-rh-164436	1
6	[empty string]	BEAR ARCHERY	Bear Archery	ARCHERY	Archery>Traditional Bows and Accessories>Bows	[empty string]	0	699.99	0	699.99	[empty string]	699.99	[empty string]	KODIAK 50# LH SATIN RECURVE	N	2 BOB	[empty string]	[empty string]	[empty string]	A	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2018	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	1	500-or-more	0.00	[empty string]	Kodiak 50# Lh Satin Recurve	[empty string]	[empty string]	N	699.99	699.99	[empty string]	[empty string]	[empty string]	1000	AK1450SL	244461	EMPTY	EMPTY	EMPTY	0	0	0	TRADITIONAL BOWS AND ACCESSORIES	[empty string]	bear-archery/kodiak-50-lh-satin-recurve-244461	1
7	[empty string]	BEAR ARCHERY	Bear Archery	ARCHERY	Archery>Traditional Bows and Accessories>Bows>Long Bows	[empty string]	0	419.99	0	419.99	[empty string]	419.99	[empty string]	MONTANA LONGBOW RH 30#	N	2 BOB	[empty string]	[empty string]	[empty string]	A	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2018	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	2	400-to-450	0.00	[empty string]	Montana Longbow - 30 Lb - Right Hand	<p>The Montana longbow was first introduced in the late 90s and has become a very popular addition to an already proven lineup. The bow`s slightly reflexed design, tapered limb lamination, and new slimmer tips make this longbow big on performance and value. </p>	[empty string]	N	419.99	419.99	[empty string]	[empty string]	[empty string]	1000	AFT2040130	258913	EMPTY	LONG BOWS	EMPTY	0	0	0	TRADITIONAL BOWS AND ACCESSORIES	[empty string]	bear-archery/montana-longbow-rh-30-258913	1
8	[empty string]	BEAR ARCHERY	Bear Archery	ARCHERY	Archery>Compound Bows and Accessories>Bows	[empty string]	0	54.99	0	54.99	[empty string]	54.99	[empty string]	FLASH BOW SET RED	N	2 BOB	[empty string]	[empty string]	[empty string]	V	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2018	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	25	50-to-100	0.00	[empty string]	Flash Bow Set - Red	<p>FEATURES:<br /> -Suggested age range: 5 - 10<br /> -47`` overall length<br /> -16``-24`` draw length<br /> -5-18 lb draw weight<br /> -7`` brace height<br /> -Ambidexterous riser design<br /> <br /> SET INCLUDES:<br /> -2 Safetyglass arrows<br /> -Armguard<br /> -2-piece arrow quiver<br /> -Sight pin<br /> -Finger rollers<br />  </p>	[empty string]	N	54.99	54.99	[empty string]	[empty string]	[empty string]	1000	AYS500RD	263224	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	bear-archery/flash-bow-set-red-263224	1
9	[empty string]	BEAR ARCHERY	Bear Archery	ARCHERY	Archery>Compound Bows and Accessories>Bows	[empty string]	0	54.99	0	54.99	[empty string]	54.99	[empty string]	FLASH BOW SET YELLOW	N	2 BOB	[empty string]	[empty string]	[empty string]	V	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2018	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	18	50-to-100	0.00	[empty string]	Flash Bow Set - Yellow	<p>Suggested age range: 5 - 10<br /> -47`` overall length<br /> -16``-24`` draw length<br /> -5-18 lb draw weight<br /> -7`` brace height<br /> -Ambidexterous riser design</p>	[empty string]	N	54.99	54.99	[empty string]	[empty string]	[empty string]	1000	AYS500YW	281195	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	bear-archery/flash-bow-set-yellow-281195	1
10	[empty string]	BEAR ARCHERY	Bear Archery	ARCHERY	Archery>Compound Bows and Accessories>Bows	[empty string]	0	29.99	0	29.99	[empty string]	29.99	[empty string]	APPRENTICE BOW SET RH FLO GREEN	N	2 BOB	[empty string]	[empty string]	[empty string]	V	[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]	9	25-to-50	0.00	[empty string]	Apprentice Bow Set Rh Flo Green	[empty string]	[empty string]	N	29.99	29.99	[empty string]	[empty string]	[empty string]	1000	AYS6001GR	328051	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	bear-archery/apprentice-bow-set-rh-flo-green-328051	1
11	[empty string]	BEAR ARCHERY	Bear Archery	ARCHERY	Archery>Compound Bows and Accessories>Bows	[empty string]	0	29.99	0	29.99	[empty string]	29.99	[empty string]	APPRENTICE BOW SET RH ORANGE	N	2 BOB	[empty string]	[empty string]	[empty string]	V	[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]	12	25-to-50	0.00	[empty string]	Apprentice Bow Set Rh Orange	[empty string]	[empty string]	N	29.99	29.99	[empty string]	[empty string]	[empty string]	1000	AYS6001TR	328052	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	bear-archery/apprentice-bow-set-rh-orange-328052	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Filter