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]	BAD LANDS	BAD LANDS	HUNTING	Hunting>Hunting Packs	[empty string]	1	34.99	0	34.99	94999-DEFAULT-l.jpg	34.99	94999-DEFAULT-m.jpg	WATER BLADDER 3L	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	3	25-to-50	0.00	[empty string]	HYDRATION RESERVOIR - 3 LITER	<p>To give you the absolute best-designed hydration system possible, Badlands teamed up with Hydrapak, to create water reservoirs specifically for hunters.</p> <p> </p> <ul> <li>3 Liter</li> <li>36 IN Hydrafusion Tube Keeps Water Cold</li> <li>Elite Surge Valve With Cover</li> <li>Plug-N-Play Tube Connector</li> <li>Reversible for Easy Cleaning and Drying</li> <li>Slider Opening is Quick Filling and Leak-Proof</li> </ul>	[empty string]	N	34.99	34.99	[empty string]	94999-DEFAULT-s.jpg	[empty string]	1000	21-140556	161134	PACK AND BAG ACCESSORIES	EMPTY	EMPTY	0	0	0	PACKS AND BAGS	[empty string]	bad-lands/hydration-reservoir-3-liter-161134	1
2	APPFX	BAD LANDS	BAD LANDS	HUNTING	Hunting>Hunting Packs>Packs	APPFX\|NULL\|NULL	1	269.99	0	329.99	95000-DEFAULT-l.jpg	269.99	95000-DEFAULT-m.jpg	SACRIFICE LS BACKPACK APPROACH	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	BOTH	ACTIVE	ONLINE	[empty string]	[empty string]	4	300-to-350	0.00	[empty string]	SACRIFICE LS	<p>Technical terrain requires a technical pack, and the Sacrifice LS is a great dedicated mountaineering pack.</p> <p> </p> <ul> <li>NOTE: NOT AS IMAGE SHOWN - PACK IS ACTUALLY IN APPROACH FX</li> <li>Carries Rifle or Bow</li> <li>Hip-Belt Pistol Holster</li> <li>Easy-Access Hip-Belt Pouches</li> <li>Hypervent Suspension</li> <li>Reinforced Carrying Strap/Hanging Strap</li> <li>Aramid Bartacking on Stress Points</li> <li>Hydration Compatible (Up to 3L)</li> <li>Wrapped Frame</li> <li>Ultralight Ripstop Fabric</li> <li>Load-Distributing Flex Rods</li> <li>Multiple Lash Points</li> <li>Top Loader Design</li> <li>Floating Lid</li> <li>Built-in Rifle or Bow Boot for Easy Carry</li> <li>C6 DWR</li> </ul> <p> </p> <ul> <li>Total Volume: 3,400 ci</li> <li>Main Pocket Volume: 2,160 ci</li> <li>Total Weight: 3 lbs 13 oz</li> <li>Dimensions: 28" x 15" x 11"</li> <li>Pockets: Seven</li> </ul>	[empty string]	N	329.99	329.99	[empty string]	95000-DEFAULT-s.jpg	[empty string]	1000	21-35366	283051	PACKS	EMPTY	EMPTY	0	0	0	HUNTING PACKS	[empty string]	bad-lands/sacrifice-ls-283051	1
3	APPFX,BLAZE,SNOW	BAD LANDS	BAD LANDS	HUNTING	Hunting>Hunting Packs>Packs	APPFX\|NULL\|NULL,BLAZE\|NULL\|NULL,SNOW\|NULL\|NULL	1	39.99	0	39.99	94994-DEFAULT-l.jpg	39.99	94994-DEFAULT-m.jpg	RAINCOVER	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	BOTH	ACTIVE	ONLINE	[empty string]	[empty string]	26	25-to-50	0.00	[empty string]	RAIN COVER	<p>After a long day hunting in the rain, nothing is more refreshing than changing into more wet clothes...said nobody ever. Keep everything from your jockey shorts to your jerky dry with the compact, packable Badlands Rain Cover.</p> <p> </p> <ul> <li>100 Percent Waterproof</li> <li>Durable and Lightweight</li> <li>Stretchable Fit</li> <li>Stuff Sack Included</li> </ul> <p> </p> <ul> <li>Medium: Fits Packs Under 2200 CI</li> <li>Large: Fits 2200 CI Packs and Above</li> </ul>	[empty string]	N	39.99	39.99	LARGE,MEDIUM	94994-DEFAULT-s.jpg	[empty string]	1000	RAINCOVER	299904	PACKS	EMPTY	EMPTY	0	0	0	PACKS AND BAGS	[empty string]	bad-lands/rain-cover-299904	1
4	APPFX	BAD LANDS	BAD LANDS	HUNTING	Hunting>Hunting Packs	APPFX\|NULL\|NULL	1	39.99	0	39.99	94998-DEFAULT-l.jpg	39.99	94998-DEFAULT-m.jpg	BINO BASICS	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	BOTH	ACTIVE	ONLINE	[empty string]	[empty string]	27	25-to-50	0.00	[empty string]	BINO BASICS	<p>Badlands’ Bino Basics was made for moments when you need your binos fast. The harness lets you go hands-free when needed, but keeps your binos close at hand. They get the weight off your neck with wide, ergonomically-designed, fully-vented shoulder straps, so you can glass all day without a second thought. On the move, the sturdy elastic straps reduce bounce.</p> <p> </p> <ul> <li>Ergonomic, Slim-Fit Design</li> <li>Elastic Straps Reduce Bounce</li> <li>Ventilated Shoulder Straps</li> <li>Includes Sliding Bino Attachment Clips</li> </ul>	[empty string]	N	39.99	39.99	[empty string]	94998-DEFAULT-s.jpg	[empty string]	1000	21-36899	299909	PACK AND BAG ACCESSORIES	EMPTY	EMPTY	0	0	0	PACKS AND BAGS	[empty string]	bad-lands/bino-basics-299909	1
5	APPFX	BAD LANDS	BAD LANDS	HUNTING	Hunting>Hunting Packs>Packs	APPFX\|NULL\|NULL	1	259.99	0	259.99	94995-DEFAULT-l.jpg	259.99	94995-DEFAULT-m.jpg	DASH BACKPACK	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	BOTH	ACTIVE	ONLINE	[empty string]	[empty string]	11	250-to-300	0.00	[empty string]	DASH	<p>Not every hunt calls for thousands of cubic inches of pack space. But at Badlands, a smaller pack never means less performance. In the Dash, they've combined their Hypervent suspension with load-distributing flex rods, creating space for air to flow between you and the pack, because a cool body means more energy. Constructed from tough, weight-saving ultralight ripstop fabric, the Dash Pack is made for speed, movement, and mobility.</p> <p> </p> <ul> <li>Carries Rifle or Bow</li> <li>Hip-Belt Pistol Holster</li> <li>Easy-Access Hip-Belt Pouches</li> <li>Hypervent Suspension</li> <li>Aramid Bartacking on Stress Points</li> <li>Hydration Compatible (Up to 3L)</li> <li>Ultralight Ripstop Fabric</li> <li>Load-Distributing Flex Rods</li> <li>Detachable Rifle Boot</li> <li>C6 DWR</li> <li>Expandable Stretch Side Pockets</li> </ul> <p> </p> <ul> <li>Total Volume: 1,940 ci</li> <li>Main Pocket Volume: 1,260 ci</li> <li>Total Weight: 3 lbs 12 oz</li> <li>Dimensions: 22" x 15" x 10"</li> </ul>	[empty string]	N	259.99	259.99	[empty string]	94995-DEFAULT-s.jpg	[empty string]	1000	21-37216	299913	PACKS	EMPTY	EMPTY	0	0	0	PACKS AND BAGS	[empty string]	bad-lands/dash-299913	1
6	APP	BAD LANDS	BAD LANDS	HUNTING	Hunting>Hunting Packs>Packs	APP\|NULL\|NULL	1	269.99	0	269.99	95002-DEFAULT-l.jpg	269.99	95002-DEFAULT-m.jpg	DIABLO VT BACKPACK APROACH	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2022	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	4	250-to-300	0.00	[empty string]	DIABLO VT	<p>The Diablo Pack is full of details you can appreciate on the hunt. Redesigned with the Badlands Strata Suspension System, Bino Connect compatibility, and a Molle accessory attachment system, the Diablo VT lives up to the lofty expectations of Diablos past.</p> <p> </p> <ul> <li>Bino Connect Compatible</li> <li>New Hypervent Suspension with Strata Technology</li> <li>Molle Attachment System on Waistbelt</li> <li>Reverse Tightening Waistbelt</li> <li>Improved-Fit Shoulder Straps</li> </ul> <p> </p> <ul> <li>Dimensions: 24" x 15" x 11"</li> <li>Total Volume: 2100 ci</li> <li>Total Weight: 4 lbs 6 oz</li> </ul>	[empty string]	N	269.99	269.99	[empty string]	95002-DEFAULT-s.jpg	[empty string]	1000	21-41529	349183	PACKS	EMPTY	EMPTY	0	0	0	PACKS AND BAGS	[empty string]	bad-lands/diablo-vt-349183	1
7	APP	BAD LANDS	BAD LANDS	HUNTING	Hunting>Hunting Packs>Packs	APP\|NULL\|NULL	1	469.99	0	469.99	95006-DEFAULT-l.jpg	469.99	95006-DEFAULT-m.jpg	MRK 3 INTERNAL FRAMEPACK APROACH MEDIUM	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2022	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	3	450-to-500	0.00	[empty string]	MRK 3 - MEDIUM	<p>The MRK 3 is tough, functional, comfortable, and built to haul copious amounts of weight.</p> <p> </p> <ul> <li>Carries Rifle or Bow</li> <li>Hydration Compatible (Up to 3L)</li> <li>Split-Pontoon Design for Improved Meat Hauling</li> <li>Allite Super Magnesium Frame</li> <li>Strata Suspension System</li> <li>Bino Connect Compatible</li> </ul> <p> </p> <ul> <li>Dimensions: 27" x 12" x 12"</li> <li>Total Volume: 3,300 ci</li> <li>Total Weight: 6 lbs 8 oz</li> </ul>	[empty string]	N	469.99	469.99	MEDIUM	95006-DEFAULT-s.jpg	[empty string]	1000	21-41534	370122	PACKS	LUMBAR PACKS	EMPTY	0	0	0	PACKS AND BAGS	[empty string]	bad-lands/mrk-3-medium-370122	1
8	APP	BAD LANDS	BAD LANDS	HUNTING	Hunting>Hunting Packs>Packs	APP\|NULL\|NULL	1	469.99	0	469.99	95007-DEFAULT-l.jpg	469.99	95007-DEFAULT-m.jpg	MRK 3 INTERNAL FRAMEPACK APROACH LARGE	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2022	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	1	450-to-500	0.00	[empty string]	MRK 3 - LARGE	<p>The MRK 3 is tough, functional, comfortable, and built to haul copious amounts of weight.</p> <p> </p> <ul> <li>Carries Rifle or Bow</li> <li>Hydration Compatible (Up to 3L)</li> <li>Split-Pontoon Design for Improved Meat Hauling</li> <li>Allite Super Magnesium Frame</li> <li>Strata Suspension System</li> <li>Bino Connect Compatible</li> </ul> <p> </p> <ul> <li>Dimensions: 29" x 12" x 12"</li> <li>Total Volume: 3,300 ci</li> <li>Total Weight: 6 lbs 9 oz</li> </ul>	[empty string]	N	469.99	469.99	LARGE	95007-DEFAULT-s.jpg	[empty string]	1000	21-41533	370123	PACKS	LUMBAR PACKS	EMPTY	0	0	0	PACKS AND BAGS	[empty string]	bad-lands/mrk-3-large-370123	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Categories

Filter