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	BLK,STONE,PACIFIC	HYDRO FLASK	Hydro Flask	CAMPING	Camping>Camp Essentials>Drinkware	BLK\|NULL\|NULL,STONE\|NULL\|NULL,PACIFIC\|NULL\|NULL	1	34.99	0	34.99	93778-DEFAULT-l.jpg	34.99	93778-DEFAULT-m.jpg	COFFEE WIDE MOUTH 20OZ FLEX SIP LID	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2022	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	5	25-to-50	0.00	[empty string]	Insulated Water Bottle - 21 Ounces - Green Zen	For a drinking bottle as versatile as you, the Insulated Water Bottle is great for not only water or your favorite sports drink; but also thicker liquids and nearly any sized ice cubes.<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	34.99	34.99	[empty string]	93778-DEFAULT-s.jpg	[empty string]	1000	W20BCX	306806	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	hydro-flask/coffee-wide-mouth-20oz-flex-sip-lid-306806	1
2	BLACK,STONE,PAC,CARNATION,LAGUNA,SNAPPER,INDIGO,ALPINE,WHITE,FOG,COBALT,RAIN	HYDRO FLASK	Hydro Flask	CAMPING	Camping>Camp Essentials>Drinkware	BLACK\|NULL\|NULL,STONE\|NULL\|NULL,PAC\|NULL\|NULL,CARNATION\|NULL\|NULL,LAGUNA\|NULL\|NULL,SNAPPER\|NULL\|NULL,INDIGO\|NULL\|NULL,ALPINE\|NULL\|NULL,WHITE\|NULL\|NULL,FOG\|NULL\|NULL,COBALT\|NULL\|NULL,RAIN\|NULL\|NULL	1	32.99	0	32.99	93783-DEFAULT-l.jpg	32.99	93783-DEFAULT-m.jpg	WIDE MOUTH 16OZ W/FLEX SIP LID	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2022	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	22	25-to-50	0.00	[empty string]	Coffee With Sip Lid - 16 Oz	Whether your first sip is in the kitchen, car, or campsite, the 16 oz Coffee with Flex Sip Lid lets you enjoy your favorite brew leak-free. So go ahead, start your day with confidence and know that your favorite beverage will be by your side.	[empty string]	N	32.99	32.99	[empty string]	93783-DEFAULT-s.jpg	[empty string]	1000	W16BCX	328524	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	hydro-flask/wide-mouth-16oz-w-flex-sip-lid-328524	1
3	BLACK,GOJO,LAGUNA,SEAGR,PAC,RAIN,ALPINE,CARNATION,STONE,WHT,OLIVE,SNAP,STAR,INDIGO	HYDRO FLASK	Hydro Flask	CAMPING	Camping>Camp Essentials>Drinkware	BLACK\|NULL\|NULL,GOJO\|NULL\|NULL,LAGUNA\|NULL\|NULL,SEAGR\|NULL\|NULL,PAC\|NULL\|NULL,RAIN\|NULL\|NULL,ALPINE\|NULL\|NULL,CARNATION\|NULL\|NULL,STONE\|NULL\|NULL,WHT\|NULL\|NULL,OLIVE\|NULL\|NULL,SNAP\|NULL\|NULL,STAR\|NULL\|NULL,INDIGO\|NULL\|NULL	1	34.99	0	34.99	93776-DEFAULT-l.jpg	34.99	93776-DEFAULT-m.jpg	20OZ WIDE MOUTH	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2022	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	21	25-to-50	0.00	[empty string]	Wide Mouth - 20 Oz	Perfect for morning hikes, afternoon ski lessons, or evenings by the campfire, the 20 oz Wide Mouth bottle is made with professional-grade stainless steel and a wider opening for faster fill. Also, the Color Last powder coat is dishwasher safe for even more convenience. Cold stays ice cold for 24 hours, and hot stays wickedly hot for 12 — just like always.	[empty string]	N	34.99	34.99	[empty string]	93776-DEFAULT-s.jpg	[empty string]	1000	W20BTS	328526	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	hydro-flask/20oz-wide-mouth-328526	1
4	GOJO,LAGUNA,STONE,PACIF,RAIN,SNAP	HYDRO FLASK	Hydro Flask	CAMPING	Camping>Camp Essentials>Drinkware	GOJO\|NULL\|NULL,LAGUNA\|NULL\|NULL,STONE\|NULL\|NULL,PACIF\|NULL\|NULL,RAIN\|NULL\|NULL,SNAP\|NULL\|NULL	1	34.99	0	34.99	93769-DEFAULT-l.jpg	34.99	93769-DEFAULT-m.jpg	21OZ STANDARD MOUTH	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2022	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	12	25-to-50	0.00	[empty string]	Standard Mouth - 21 Oz	Keep life moving with the 21 oz bottle and Standard Flex Cap. It stashes easily into a small shoulder bag, your pack’s side pocket, or your car cup holder, and holds enough ice cold goodness to keep you going for hours without weighing you down.	[empty string]	N	34.99	34.99	[empty string]	93769-DEFAULT-s.jpg	[empty string]	1000	S21SX	343704	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	hydro-flask/21oz-standard-mouth-343704	1
5	PEONY	HYDRO FLASK	Hydro Flask	CAMPING	Camping>Camp Essentials>Drinkware	PEONY\|NULL\|NULL	1	32.99	0	32.99	93770-DEFAULT-l.jpg	32.99	93770-DEFAULT-m.jpg	KIDS 12OZ WIDE MOUTH STRAW LID BOOT	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2022	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	Kid`s Wide Mouth With Straw Lid - 12 Oz	Every sip stays icy cold for up to 24 hours. When playtime wraps up, the perfect refreshment is waiting on the sidelines. With a colorful, easy-to-clean Straw Cap and a durable perforated Flex Boot, the Wide Mouth Kids Bottle is the perfect companion for any adventure.	[empty string]	N	32.99	32.99	[empty string]	93770-DEFAULT-s.jpg	[empty string]	1000	W12BSW	343708	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	hydro-flask/kids-12oz-wide-mouth-straw-lid-boot-343708	1
6	LAGUNA,INDIGO,STARFISH	HYDRO FLASK	Hydro Flask	CAMPING	Camping>Camp Essentials>Drinkware	LAGUNA\|NULL\|NULL,INDIGO\|NULL\|NULL,STARFISH\|NULL\|NULL	1	32.99	0	32.99	93775-DEFAULT-l.jpg	32.99	93775-DEFAULT-m.jpg	28OZ TUMBLER	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2022	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	3	25-to-50	0.00	[empty string]	All Around Tumbler - 28 Oz	Go big with the 28 oz All Around Tumbler, keeping beverages cold for up to 24 hours and hot up to 6 hours. The Closeable Press-In Lid slides snugly shut to keep splashes at bay. The All Around Tumbler is incredibly comfy to hold and is easy to fill, sip and savor.	[empty string]	N	32.99	32.99	[empty string]	93775-DEFAULT-s.jpg	[empty string]	1000	T28CP	357669	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	hydro-flask/28oz-tumbler-357669	1
7	STARFISH,BLACK	HYDRO FLASK	Hydro Flask	CAMPING	Camping>Camp Essentials>Drinkware	STARFISH\|NULL\|NULL,BLACK\|NULL\|NULL	1	27.99	0	27.99	93774-DEFAULT-l.jpg	27.99	93774-DEFAULT-m.jpg	20OZ TUMBLER	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2022	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	2	25-to-50	0.00	[empty string]	All Around Tumbler - 20 Oz	Ready for power smoothies or lemon-ginger tea, the 20 oz All Around Tumbler keeps beverages cold for up to 24 hours and hot up to 6 hours. The Closeable Press-In Lid slides snugly shut to keep splashes at bay. The All Around Tumbler is incredibly comfy to hold and is easy to fill, sip and savor.	[empty string]	N	27.99	27.99	[empty string]	93774-DEFAULT-s.jpg	[empty string]	1000	T20CP	357670	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	hydro-flask/20oz-tumbler-357670	1
8	STARFISH,SNAPPER,LAGUNA	HYDRO FLASK	Hydro Flask	CAMPING	Camping>Camp Essentials>Drinkware	STARFISH\|NULL\|NULL,SNAPPER\|NULL\|NULL,LAGUNA\|NULL\|NULL	1	24.99	0	24.99	93773-DEFAULT-l.jpg	24.99	93773-DEFAULT-m.jpg	120Z SLIM COOLER CUP	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2022	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	6	20-to-25	0.00	[empty string]	Slim Cooler Cup - 12 Oz	Simply slim. Keep your slim can or 12 oz of your favorite beverage hot or cold. The flexible collar locks in the cold with a snug fit. Swap the collar to the bottom, and you’re rocking a stabilizing boot. Easy grip, sweat-free and multi-use—way cooler than a cup.	[empty string]	N	24.99	24.99	[empty string]	93773-DEFAULT-s.jpg	[empty string]	1000	KS12	357671	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	hydro-flask/120z-slim-cooler-cup-357671	1
9	BLACKBERRY,PEPPERCORN	HYDRO FLASK	Hydro Flask	CAMPING	Camping>Coolers	BLACKBERRY\|NULL\|NULL,PEPPERCORN\|NULL\|NULL	1	44.99	0	44.99	101915-DEFAULT-l.jpg	44.99	101915-DEFAULT-m.jpg	5L INSULATED LUNCH BAG	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	2	25-to-50	0.00	[empty string]	INSULATED LUNCH BAG - 5 L	<p>It’s reusable, it’s cool. HydroFlask's 5L insulated lunch bag keeps sandwiches, snacks and fruit chilled. It’s the perfect small cooler for your office lunch, school lunch and picnic lunch. It’s easy to clean, and sized for your Hydro Flask bottles and food jars.</p> <p> </p> <ul> <li>Lightweight insulation keeps contents fresh for hours when used with an ice pack</li> <li>Fully-lined interior with welded seams for easy cleaning</li> <li>Exterior fabric is abrasion- and water-resistant</li> <li>Quick grab handles for easy carry</li> <li>Large exterior pocket and zippered interior pocket for stashing napkins and flatware</li> <li>BPA-Free</li> <li>FDA food grade interior lining</li> </ul> <p> </p> <ul> <li>Height: 8.70"</li> <li>Weight: 0.59 lb</li> </ul>	[empty string]	N	44.99	44.99	5L	101915-DEFAULT-s.jpg	[empty string]	1000	SL5	369250	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	hydro-flask/insulated-lunch-bag-5-l-369250	1
10	BLACKBERRY,PEPPERCORN	HYDRO FLASK	Hydro Flask	CAMPING	Camping>Coolers	BLACKBERRY\|NULL\|NULL,PEPPERCORN\|NULL\|NULL	1	49.99	0	49.99	101916-DEFAULT-l.jpg	49.99	101916-DEFAULT-m.jpg	8L INSULATED LUNCH BAG	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	2	25-to-50	0.00	[empty string]	INSULATED LUNCH BAG - 8 L	<p>Made for big lunches, our 8L insulated lunch bag keeps sandwiches, snacks and fruit chilled. It’s the perfect cooler for your office lunch, school lunch and picnic lunch. It’s easy to clean, and sized for your Hydro Flask bottles and food jars.</p> <p> </p> <ul> <li>Lightweight insulation keeps contents fresh for hours when used with an ice pack</li> <li>Fully-lined interior with welded seams for easy cleaning</li> <li>Exterior fabric is abrasion- and water-resistant</li> <li>Quick grab handles for easy carry</li> <li>Large exterior pocket and zippered interior pocket for stashing napkins and flatware</li> <li>BPA-Free</li> <li>FDA food grade interior lining</li> </ul> <p> </p> <ul> <li>Height: 9.50"</li> <li>Weight: 0.69 lb</li> </ul>	[empty string]	N	49.99	49.99	8L	101916-DEFAULT-s.jpg	[empty string]	1000	SL8	369251	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	hydro-flask/insulated-lunch-bag-8-l-369251	1
11	BLACKBERRY	HYDRO FLASK	Hydro Flask	CAMPING	Camping>Coolers	BLACKBERRY\|NULL\|NULL	1	44.99	0	44.99	101917-DEFAULT-l.jpg	44.99	101917-DEFAULT-m.jpg	8L LUNCH TOTE	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	LUNCH TOTE - 8 L	<p>Insulated lunch tote, insulated lunch bag, insulated lunch box—this one’s all of the above. It keeps food fresh for hours, is the perfect size for salads and sandwiches, wipes clean, and is a go-to for work, play and school.</p> <p> </p> <ul> <li>Coated fabric is waterproof and durable</li> <li>Fully-lined interior for easy cleaning</li> <li>Collapsible design for quick storage and travel</li> <li>Robust base for unsupported self-standing</li> <li>Water-resistant zippers keep moisture out</li> <li>Welded outer pocket for quick access to extras</li> <li>BPA-Free</li> </ul> <p> </p> <ul> <li>Height: 14"</li> <li>Weight: 0.75 lb</li> </ul>	[empty string]	N	44.99	44.99	8L	101917-DEFAULT-s.jpg	[empty string]	1000	LT8	369252	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	hydro-flask/lunch-tote-8-l-369252	1
12	PEPPERCORN,TALIUS	HYDRO FLASK	Hydro Flask	FISHING	Fishing>Coolers	PEPPERCORN\|NULL\|NULL,TALIUS\|NULL\|NULL	1	199.99	0	199.99	101918-DEFAULT-l.jpg	199.99	101918-DEFAULT-m.jpg	DAY ESCAPE SOFT COOLER TOTE 20L	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SUMMER	[empty string]	2022	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	4	150-to-200	0.00	[empty string]	DAY ESCAPE PACK - 20 L	<p>This soft-sided backpack cooler keeps things cold for 36 hours, holds 36 cans without ice, and is your beach cooler, hiking cooler, picnic cooler—everything cooler. The padded back and straps are comfortable and the materials outdoor durable, so load up and go.</p> <p> </p> <ul> <li>36 hours cold</li> <li>Watertight zipper and welded seams ensure leakproof transport</li> <li>Lightweight cold-retaining technology</li> <li>600D polyester shell is durable, lightweight and waterproof</li> <li>Padded mesh back panel</li> <li>Padded shoulder straps</li> <li>Compression molded base for unsupported self-standing</li> <li>Woven sternum strap and carry handles</li> <li>Laser cut welded loops easily attach Hydro Flask Dry Storage accessories</li> <li>BPA-Free</li> </ul> <p> </p> <ul> <li>Outside Dimensions: 8.47" L x 18.52" W x 18.12" H</li> <li>Weight: 2.63 lb</li> </ul>	[empty string]	N	199.99	199.99	[empty string]	101918-DEFAULT-s.jpg	[empty string]	1000	SCPB	374399	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	hydro-flask/day-escape-pack-20-l-374399	1
13	TALIUS	HYDRO FLASK	Hydro Flask	FISHING	Fishing>Coolers	TALIUS\|NULL\|NULL	1	179.99	0	179.99	101919-DEFAULT-l.jpg	179.99	101919-DEFAULT-m.jpg	DAY ESCAPE SOFT COOLER PACK 26L	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SUMMER	[empty string]	2022	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	1	150-to-200	0.00	[empty string]	DAY ESCAPE TOTE - 26 L	<p>A large portable soft cooler that keeps food and drinks cold for 36 hours—perfect for camping and trailgating. The 26 L capacity holds 42 cans without ice, is leakproof, durable, insulated for long trips and carries across the body or slings over the shoulder.</p> <p> </p> <ul> <li>36 hours cold</li> <li>Watertight zipper and welded seams ensure leakproof transport</li> <li>Lightweight cold-retaining technology</li> <li>600D polyester shell is durable, lightweight and waterproof</li> <li>Shoulder straps and removable cross-body strap for ease of carrying</li> <li>Woven loops easily attach Hydro Flask Dry Storage accessories</li> <li>Laser cut welded gear attachment loops</li> <li>BPA-Free</li> <li>Smart Insulation</li> </ul> <p> </p> <ul> <li>Outside Dimensions: 10.4" L x 23.9" W x 14.97" H</li> <li>Weight: 2.92 lbs</li> </ul>	[empty string]	N	179.99	179.99	[empty string]	101919-DEFAULT-s.jpg	[empty string]	1000	SCTB	374400	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	hydro-flask/day-escape-tote-26-l-374400	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Categories

Size

5L
8L

Filter