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	[empty string]	[empty string]	[empty string]	12	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-40556	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	329.99	0	329.99	95000-DEFAULT-l.jpg	329.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	[empty string]	[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	BLAZE,APPFX,SNOW	BAD LANDS	BAD LANDS	HUNTING	Hunting>Hunting Packs>Packs	BLAZE\|NULL\|NULL,APPFX\|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]	32	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	MEDIUM,LARGE	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>Packs	APPFX\|NULL\|NULL	1	139.99	0	139.99	94996-DEFAULT-l.jpg	139.99	94996-DEFAULT-m.jpg	MAG BINO CASE	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]	12	100-to-150	0.00	[empty string]	MAG BINO CASE	<p>Badland's has packed so many features into the Mag Bino Case’s 270 cubic inches, it probably shouldn’t be legal. Badlands’ Zip-No magnetic closure system opens silently and protects your optics from dust, water, and more. Rest your bow on the bow hook, and sip from the one-liter hydration reservoir while you glass. The sleek, unobtrusive case features a breathable harness that makes it incredibly comfortable.</p> <p> </p> <ul> <li>Zip-No Magnetic Technology</li> <li>KXO-32 Fabric</li> <li>Hypalon Reinforcements</li> <li>Aramid Bartacking</li> <li>Backpack-Friendly Harness</li> <li>Bow Hook</li> <li>Ventilated Shoulder Straps</li> <li>Hydration Compatible (Up to 1L)</li> <li>Holds Up to 12 x 50 Binoculars</li> <li>C6 DWR</li> <li>External Lash Points</li> <li>Bino Connect Compatible (requires optional Bino Connect Kit)</li> </ul> <p> </p> <ul> <li>Total Volume: 270 ci</li> <li>Total Weight: 1 lb 1 oz</li> <li>Inside Dimensions: 8 1/2" H x 6" W x 2" D</li> <li>Outside Dimensions: 9" H x 6.5" W x 3" D</li> </ul>	[empty string]	N	139.99	139.99	[empty string]	94996-DEFAULT-s.jpg	[empty string]	1000	21-36896	299908	PACKS	EMPTY	EMPTY	0	0	0	PACKS AND BAGS	[empty string]	bad-lands/mag-bino-case-299908	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]	9	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	APRFX	BAD LANDS	BAD LANDS	HUNTING	Hunting>Hunting Packs>Packs	APRFX\|NULL\|NULL	1	289.99	0	289.99	95001-DEFAULT-l.jpg	289.99	95001-DEFAULT-m.jpg	SUPERDAY 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]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	6	250-to-300	0.00	[empty string]	SUPERDAY	<p>The Superday Pack performs like a frame pack, thanks to the contoured waist belt that hugs your hips to carry weight more effectively.</p> <p> </p> <ul> <li>Carries Rifle or Bow</li> <li>Hip-Belt Pistol Holster</li> <li>Easy-Access Hip-Belt Pouches</li> <li>Reinforced Carrying Strap/Hanging Strap</li> <li>Aramid Bartacking on Stress Points</li> <li>Hydration Compatible (Up to 3L)</li> <li>Bino Connect Compatible (requires optional Bino Connect Kit)</li> <li>Molded Foam Suspension</li> <li>Bedroll Straps</li> <li>Badlands' New KXO-50 Fabric</li> <li>Detachable Rifle/Bow Boot</li> <li>C6 DWR</li> <li>Adjustable Waist Belt with Reverse Tightening</li> </ul> <p> </p> <ul> <li>Total Volume: 1,950 ci</li> <li>Main Pocket Volume: 1,440 ci</li> <li>Total Weight: 3 lbs 15 oz</li> <li>Dimensions: 25" x 16" x 12"</li> <li>Pockets: Seven</li> </ul>	[empty string]	N	289.99	289.99	[empty string]	95001-DEFAULT-s.jpg	[empty string]	1000	21-39455	334166	PACKS	EMPTY	EMPTY	0	0	0	PACKS AND BAGS	[empty string]	bad-lands/superday-334166	1
7	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]	3	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
8	APPROACHFX	BAD LANDS	BAD LANDS	HUNTING	Hunting>Hunting Packs	APPROACHFX\|NULL\|NULL	1	189.99	0	189.99	95003-DEFAULT-l.jpg	189.99	95003-DEFAULT-m.jpg	MONSTER FANNY PACK APPROACH FX	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]	2022	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	2	150-to-200	0.00	[empty string]	MONSTER - APPROACH FX	<p>Unlike fanny packs that suffer from the droops, the Monster's adjustable suspension keeps everything in place. With 1,100 cubic inches of storage, seven pockets, and a Delron Flex Frame, the Monster’s got as much built-in engineering as Badland's biggest packs.</p> <p> </p> <ul> <li>Badlands' KXO-32 Fabric</li> <li>Aramid Bartacking on Stress Points</li> <li>Hydration Compatible (Up to 1L)</li> <li>Molded Foam Suspension</li> <li>Delron Flex Frame Adds Support</li> <li>Bedroll Straps</li> <li>3-Point Adjustable/Removable Shoulder Straps</li> <li>Two Integrated Fold-Down Workstation Pockets</li> <li>C6 DWR</li> </ul> <p> </p> <ul> <li>Total Volume: 1,100 ci</li> <li>Main Pocket Volume: 425 ci</li> <li>Total Weight: 2 lbs 10 oz</li> <li>Dimensions: 11" x 20" x 8"</li> <li>Pockets: Seven</li> </ul>	[empty string]	N	189.99	189.99	[empty string]	95003-DEFAULT-s.jpg	[empty string]	1000	21-40315	366572	PACKS	EMPTY	EMPTY	0	0	0	PACKS AND BAGS	[empty string]	bad-lands/monster-approach-fx-366572	1
9	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
10	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:

Filter