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	BLACK	BOGS FOOTWEAR	Bogs Footwear	FOOTWEAR	Footwear>Rubber Boots	BLACK\|NULL\|NULL	1	149.99	0	149.99	96382-DEFAULT-l.jpg	149.99	96382-DEFAULT-m.jpg	MNS CLASSIC ULTRA PULLON BOOT	N	5 EMILY	[empty string]	[empty string]	[empty string]	B	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2022	[empty string]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	50	100-to-150	0.00	[empty string]	CLASSIC ULTRA HIGH - BLACK - MEN'S	<p>If you spend a lot of time on your feet outdoors, you better be comfortable.</p> <p> </p> <ul> <li>100% Waterproof</li> <li>Durable hand-lasted rubber and a four way stretch inner bootie</li> <li>Constructed with 7mm waterproof Neo-Tech</li> <li>Easy-on pull handles</li> <li>Internal midsole with rubber sponge delivers extra cushion and warmth</li> <li>Non-slip outsole</li> <li>DuraFresh bio-technology that activates to fight unwanted odors</li> </ul> <p> </p> <ul> <li>Weight: 5.03 lbs</li> <li>Height: 15''</li> <li>Temp Rating: -40°F/-40°C</li> <li>Calf Circumference: 17"</li> </ul>	[empty string]	N	149.99	149.99	7,11,13,9,8,14,12,15,10	96382-DEFAULT-s.jpg	[empty string]	1000	51377-001	101726	EMPTY	EMPTY	EMPTY	0	0	0	RUBBER BOOTS	[empty string]	bogs-footwear/classic-ultra-high-black-men-s-101726	1
2	BLACK	BOGS FOOTWEAR	Bogs Footwear	FOOTWEAR	Footwear>Rubber Boots	BLACK\|NULL\|NULL	1	179.99	0	179.99	96604-DEFAULT-l.jpg	179.99	96604-DEFAULT-m.jpg	M WORKMAN 17 IN 5MM/2MM SOFT TOE	N	5 EMILY	[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]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	10	150-to-200	0.00	[empty string]	WORKMAN - TALL - 17" - BLACK - MEN'S	<p>Seamless Technology: 30% lighter & 100% tougher. All the other technology keeps you safe and comfortable.</p> <p> </p> <ul> <li>Made with Seamless Construction to prevent cracking and reduce the boots’ weight by 30%</li> <li>Constructed with 5MM Neo-Tech waterproof insulation + 2MM air mesh for temperature regulation</li> <li>BioGrip slip resistant outsole</li> <li>Rebound cushioning bounces back to return energy to your foot</li> <li>Flex Width insole system adapts to wider feet</li> <li>Eco-friendly, algae-based EVA footbed that helps clean polluted water habitats</li> <li>DuraFresh bio-technology activates to fight odors</li> <li>Bogs Max-Wick moves sweat away from your foot to keep you dry</li> <li>Heel lock provide support and optimal ankle fit</li> <li>Meets ASTM F1677, F2413-11, M I/75, C/75</li> <li>EH Rated</li> </ul> <p> </p> <ul> <li>Weight: 4.53 lbs</li> <li>Height: 17"</li> <li>Temp Rating: -72°F/-60°C</li> <li>Calf Circumference: 18"</li> </ul>	[empty string]	N	179.99	179.99	8,10,11,13,12,9	96604-DEFAULT-s.jpg	[empty string]	1000	72625-001	353448	EMPTY	EMPTY	EMPTY	0	0	0	RUBBER BOOTS	[empty string]	bogs-footwear/workman-tall-17-black-men-s-353448	1
3	BRNMULTI	BOGS FOOTWEAR	Bogs Footwear	FOOTWEAR	Footwear>Rubber Boots	BRNMULTI\|NULL\|NULL	1	94.99	0	94.99	96634-DEFAULT-l.jpg	94.99	96634-DEFAULT-m.jpg	SAUVIE SLIP ON	N	5 EMILY	[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]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	12	50-to-100	0.00	[empty string]	SUAVIE SLIP ON - BROWN MULTI - MEN'S	<p>These Bogs are perfect for doing stuff. Wet stuff. Cold stuff. Hard stuff. They’re 100% waterproof, 100% comfortable, 100% stable, and slip-resistant. 100% DIY.</p> <p> </p> <ul> <li>100% Waterproof</li> <li>Rebound cushioning provides lasting comfort</li> <li>Constructed with 3mm Neo-Tech waterproof insulation</li> <li>DuraFresh organic bio-technology activates to fight odors</li> <li>BioGrip slip resistant outsole</li> <li>Bogs MaxWick moves sweat away to keep your feet dry</li> <li>Shank in outsole for support and stability</li> </ul> <p> </p> <ul> <li>Weight: 2.77 lbs</li> <li>Height: 5"</li> </ul>	[empty string]	N	94.99	94.99	9,10,11,13,8,12	96634-DEFAULT-s.jpg	[empty string]	1000	72207-249	362975	EMPTY	EMPTY	EMPTY	0	0	0	RUBBER BOOTS	[empty string]	bogs-footwear/suavie-slip-on-brown-multi-men-s-362975	1
4	EMBER	BOGS FOOTWEAR	Bogs Footwear	FOOTWEAR	Footwear>Rubber Boots	EMBER\|NULL\|NULL	1	94.99	0	94.99	96641-DEFAULT-l.jpg	94.99	96641-DEFAULT-m.jpg	WMS AMANDA II TALL	N	5 EMILY	[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]	WOMENS	ACTIVE	[empty string]	[empty string]	[empty string]	25	50-to-100	0.00	[empty string]	AMANDA II - TALL - ADJUSTABLE CALF - EMBER - WOMEN'S	<p>You might not wear these down a Paris runway, unless it’s windy and raining.</p> <p> </p> <ul> <li>100% Waterproof</li> <li>Bloom eco-friendly, algae-based EVA footbed that helps clean polluted water habitats</li> <li>DuraFresh natural bio-technology activates to fight odors</li> </ul> <p> </p> <ul> <li>Weight: 2.71 lbs</li> <li>Height: 13.19"</li> <li>Calf Circumference: 15.47"</li> </ul>	[empty string]	N	94.99	94.99	9,10,7,8,11	96641-DEFAULT-s.jpg	[empty string]	1000	72786-217	363267	EMPTY	EMPTY	EMPTY	0	0	0	RUBBER BOOTS	[empty string]	bogs-footwear/amanda-ii-tall-adjustable-calf-ember-women-s-363267	1
5	020/GRAY	BOGS FOOTWEAR	Bogs Footwear	FOOTWEAR	Footwear>Rubber Boots	020/GRAY\|NULL\|NULL	1	54.99	0	54.99	96691-DEFAULT-l.jpg	54.99	96691-DEFAULT-m.jpg	Y SOLID RAINBOOT	N	5 EMILY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2023	[empty string]	YOUTH	ACTIVE	[empty string]	[empty string]	[empty string]	20	50-to-100	0.00	[empty string]	RAINBOOT SLIP ON SOLID - GREY - KID'S	<p>As your kids develop advanced puddle-jumping techniques, they should have state-of- the-art equipment. The technical term is “Rain Boot.”</p> <p> </p> <ul> <li>100% Waterproof</li> <li>Lightweight puddle jumper for spring</li> <li>Soft and flexible, natural rubber upper</li> <li>Easy pull-on handles</li> <li>DuraFresh odor protection insole</li> <li>Non-slip outsole</li> </ul> <p> </p> <ul> <li>Height: 9"</li> <li>Circumference: 9"</li> </ul>	[empty string]	N	54.99	54.99	3,4,5,6	96691-DEFAULT-s.jpg	[empty string]	1000	72377	371218	EMPTY	EMPTY	EMPTY	0	0	0	RUBBER BOOTS	[empty string]	bogs-footwear/rainboot-slip-on-solid-grey-kid-s-371218	1
6	009/BLK	BOGS FOOTWEAR	Bogs Footwear	FOOTWEAR	Footwear>Rubber Boots	009/BLK\|NULL\|NULL	1	84.99	0	84.99	96646-DEFAULT-l.jpg	84.99	96646-DEFAULT-m.jpg	W KICKER RAIN CHELSEA	N	5 EMILY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2023	[empty string]	WOMENS	ACTIVE	[empty string]	[empty string]	[empty string]	16	50-to-100	0.00	[empty string]	KICKER RAIN CHELSEA - BLACK MULTI - WOMEN'S	<p>Granted, there’s no such thing as an instant classic. But once in a while, a boot comes along that is so simple, so functional, so perfect, that it never goes out of style.</p> <p> </p> <ul> <li>100% Waterproof</li> <li>Crafted with ultra-soft and flexible rubber</li> <li>Elastic gore for easy on</li> <li>Bloom eco-friendly, algae based EVA footbed that helps clean polluted water habitats</li> <li>Nylon shank in footbed for stability and support</li> </ul> <p> </p> <ul> <li>Weight: 1.61 lbs</li> <li>Height: 4"</li> </ul>	[empty string]	N	84.99	84.99	7,8,9,10	96646-DEFAULT-s.jpg	[empty string]	1000	72509-009	371250	EMPTY	EMPTY	EMPTY	0	0	0	RUBBER BOOTS	[empty string]	bogs-footwear/kicker-rain-chelsea-black-multi-women-s-371250	1
7	001/BLK	BOGS FOOTWEAR	Bogs Footwear	FOOTWEAR	Footwear>Rubber Boots	001/BLK\|NULL\|NULL	1	89.99	0	89.99	96692-DEFAULT-l.jpg	89.99	96692-DEFAULT-m.jpg	M DIGGER MID	N	5 EMILY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2023	[empty string]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	14	50-to-100	0.00	[empty string]	DIGGER MID - BLACK - MEN'S	<p>This boot is built for the everyman. If that everyman had a great sense of style. And an amazing garden. And he just wanted to step into his boots and then step outside. It’s for every man like that.</p> <p> </p> <ul> <li>100% Waterproof</li> <li>Hands free entry with wider opening</li> <li>Heel kick for hands free removal </li> <li>Bloom eco-friendly, algae-based EVA footbed that helps clean polluted water habitats</li> <li>BOGS Max-Wick evaporates sweat to keep feet dry</li> <li>Self cleaning rubber outsole</li> <li>DuraFresh natural bio-technology activates to fight odors</li> </ul>	[empty string]	N	89.99	89.99	11,12,9,10	96692-DEFAULT-s.jpg	[empty string]	1000	72668-001	371258	EMPTY	EMPTY	EMPTY	0	0	0	RUBBER BOOTS	[empty string]	bogs-footwear/digger-mid-black-men-s-371258	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Size

10
11
12
13
14
15
16
17
3
4
5
6
7
8
9

Filter