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	JK3	NORTH FACE	NORTH FACE	CLOTHING	Clothing>Women>Bottoms>Pants	JK3\|NULL\|NULL	1	60	0	60	100659-DEFAULT-l.jpg	60	100659-DEFAULT-m.jpg	W APHRODIDTE CAPRI	N	6.1 AMBER	[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]	17	50-to-100	0.00	[empty string]	APHRODIDTE CAPRI	<p>Stay comfortable wherever you explore in the Aphrodite 2.0 Capris—durable, water-repelling, quick-drying pants that are perfect for quality time in the outdoors.</p> <p> </p> <ul> <li>Standard fit; straight leg</li> <li>17'' leg opening</li> <li>Ultra-comfortable herringbone fabric with four-way stretch for mobility</li> <li>FlashDry materials offer enhanced moisture management to help keep you comfortable</li> <li>Non-PFC DWR finish for added water repellency</li> <li>Triple needle stitching for durability</li> <li>2x2 rib-knit waistband with a tonal, heather, stretch drawcord for adjustability</li> <li>Drop-in, slant hand pockets with an invisible-zip pocket inside the right hand pocket</li> <li>Shirring on legs for style and comfort</li> <li>Ultraviolet Protection Factor (UPF) 40+</li> <li>Embroidered logo on back-right yoke</li> </ul>	[empty string]	N	60	60	L,XL,M,S,2X	100659-DEFAULT-s.jpg	[empty string]	1000	NF0A2UO6	278250	EMPTY	PANTS	EMPTY	0	0	0	WOMEN	[empty string]	north-face/aphrodidte-capri-278250	1
2	LK5	NORTH FACE	NORTH FACE	CLOTHING	Clothing>Mens>Bottoms>Shorts	LK5\|NULL\|NULL	0	60	0	60	[empty string]	60	[empty string]	MNS ROLLING SUN SHORT	N	6.1 AMBER	[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]	11	50-to-100	0.00	[empty string]	MEN'S ROLLING SUN PACKABLE SHORTS	<p>The light, versatile Men’s Rolling Sun Packable Shorts have the performance features—such as moisture-wicking FlashDry and water-repellency—you need for those long, warm days that you wish would never end.</p> <p> </p> <ul> <li>Standard fit</li> <li>Dobby fabric raises the face fabric from your skin for quicker drying</li> <li>FlashDry materials offer enhanced moisture management to help keep you comfortable</li> <li>Non-PFC DWR finish for added water repellency</li> <li>Internal, flat drawcord at waist for adjustability</li> <li>Zip-fly with a button closure</li> <li>Slash hand pockets</li> <li>Two hook-and-loop-closure back pockets</li> <li>Packs into the secure-zip stowpocket on left thigh</li> <li>Heat transfer logo on left thigh</li> </ul>	[empty string]	N	60	60	34,30,32,38,36	[empty string]	[empty string]	1000	NF0A3T2Q	315266	EMPTY	SHORTS	EMPTY	0	0	0	MENS	[empty string]	north-face/men-s-rolling-sun-packable-shorts-315266	1
3	21L,0C5	NORTH FACE	NORTH FACE	CLOTHING	Clothing>Women>Bottoms>Shorts	21L\|NULL\|NULL,0C5\|NULL\|NULL	0	45	0	45	[empty string]	45	[empty string]	W APHRODITE MOTN SHO LONG	N	6.1 AMBER	[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]	30	25-to-50	0.00	[empty string]	WOMEN'S APHRODITE MOTION SHORTS	<p>The Women’s Aphrodite Motion Shorts, featuring a soft, comfortable herringbone fabric and four-way stretch, are the water-repelling, sweat-wicking, sun-protecting shorts you’ve been waiting for.</p> <p> </p> <ul> <li>Standard fit</li> <li>Ultra-comfortable herringbone fabric with four-way stretch for mobility</li> <li>FlashDry materials offer enhanced moisture management to help keep you comfortable</li> <li>Non-PFC DWR finish for added water repellency</li> <li>2x2 rib-knit waistband with a tonal, heather, stretch drawcord for adjustability</li> <li>Drop-in hand pockets</li> <li>Packs into the secure-zip welt back pocket</li> <li>Embroidered logo on left thigh</li> </ul>	[empty string]	N	45	45	L,M,XL,2X,S	[empty string]	[empty string]	1000	NF0A4AQF	327120	EMPTY	SHORTS	EMPTY	0	0	0	WOMEN	[empty string]	north-face/women-s-aphrodite-motion-shorts-327120	1
4	8K2,JK3,A9L	NORTH FACE	NORTH FACE	CLOTHING	Clothing>Mens>Bottoms>Shorts	8K2\|NULL\|NULL,JK3\|NULL\|NULL,A9L\|NULL\|NULL	0	50	0	50	[empty string]	50	[empty string]	M WANDER SHORT	N	6.1 AMBER	[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]	15	25-to-50	0.00	[empty string]	MEN'S WANDER SHORT	<p>The Men’s Wander Shorts are stretch-woven and featured for performance. When you’re looking for mobility and comfort on the trail, these sweat-wicking and water-repellent shorts should be one of your first choices.</p> <p> </p> <ul> <li>Standard fit</li> <li>Stretch-woven fabric for increased mobility and durability</li> <li>FlashDry-XD materials offer enhanced moisture management to help keep you comfortable and increased abrasion resistance for extra durability</li> <li>Non-PFC DWR finish for added water repellency</li> <li>Elastic waistband with an internal drawcord makes shorts easy to pull on</li> <li>Concealed-zip pocket at left side seam</li> <li>Drop-in hand pockets</li> <li>Heat transfer logo on left hem</li> </ul>	[empty string]	N	50	50	M,XL,L,2X	[empty string]	[empty string]	1000	NF0A535Q	348248	EMPTY	SHORTS	EMPTY	0	0	0	MENS	[empty string]	north-face/men-s-wander-short-348248	1
5	N11	NORTH FACE	NORTH FACE	CLOTHING	Clothing>Mens>Tops>Long Sleeve	N11\|NULL\|NULL	1	55	0	55	101238-DEFAULT-l.jpg	55	101238-DEFAULT-m.jpg	M WANDER HOODIE	N	6.1 AMBER	[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]	4	50-to-100	0.00	[empty string]	MEN'S WANDER HOODIE	<p>The Men’s Wander Sun Hoodie is a versatile layer made with a soft double-knit fabric. Featuring FlashDry materials and UPF 40+ protection, you’ll stay comfortable well beyond your comfort zone.</p> <p> </p> <ul> <li>Standard fit</li> <li>Soft double-knit fabric</li> <li>FlashDry materials offer enhanced moisture management to help keep you comfortable</li> <li>Three-piece hood for added protection from the elements</li> <li>Raglan sleeves for mobility</li> <li>Shaped hem for extra coverage in back</li> <li>Ultraviolet Protection Factor (UPF) 40+</li> <li>Heat transfer logo on left chest</li> </ul>	[empty string]	N	55	55	L	101238-DEFAULT-s.jpg	[empty string]	1000	NF0A53BS	350106	TOPS	LONG SLEEVE	EMPTY	0	0	0	MENS	[empty string]	north-face/men-s-wander-hoodie-350106	1
6	JK3,173,ZDL	NORTH FACE	NORTH FACE	CLOTHING	Clothing>Mens>Bottoms>Shorts	JK3\|NULL\|NULL,173\|NULL\|NULL,ZDL\|NULL\|NULL	0	65	0	65	[empty string]	65	[empty string]	M CLASS V BLETED SHORT	N	6.1 AMBER	[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]	19	50-to-100	0.00	[empty string]	MEN'S CLASS V BELTED SHORT	<p>The relaxed-fit Men’s Class V Belted Shorts are made for those bright summer days that never fade. With added stretch and FlashDry-XD technology, the fun is just one ''cannonball!'' away.</p> <p> </p> <ul> <li>Relaxed fit</li> <li>Fabric made with 68% recycled nylon</li> <li>FlashDry-XD materials offer enhanced moisture management to help keep you comfortable and increased abrasion resistance for extra durability</li> <li>Non-PFC DWR finish for added water repellency</li> <li>Woven webbing belt at waist for adjustability with a logo label at one end</li> <li>Faux fly</li> <li>Single-welt, reverse-coil-zip hand pockets</li> <li>Embroidered logo on left hem</li> </ul>	[empty string]	N	65	65	L,XL,2X,M	[empty string]	[empty string]	1000	NF0A55V8	350112	EMPTY	SHORTS	EMPTY	0	0	0	MENS	[empty string]	north-face/men-s-class-v-belted-short-350112	1
7	N77	NORTH FACE	NORTH FACE	CLOTHING	Clothing>Women>Tops>Long Sleeve	N77\|NULL\|NULL	0	100	1	89	[empty string]	100	[empty string]	W CANYONLANDS HOODIE	N	6.1 AMBER	[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]	WOMEN'S CANYONLANDS HOODIE	<p>The slim-fit Women’s Canyonlands Hoodie features a smooth 200-weight fleece that is stretchable and comfortable. With an attached hood and set-in sleeves, this is a layer you’ll reach for all year long.</p> <p> </p> <ul> <li>Slim fit</li> <li>200-weight, stretch smooth-face fleece with a brushed back for comfort</li> <li>Attached, three-piece hood</li> <li>Set-in sleeves</li> <li>Exposed, reverse-coil center front zip with a zipper garage at upper neck</li> <li>Secure-zip hand pockets</li> <li>Binding on hood, cuffs and hem</li> <li>Heat transfer logo on left chest and back-right shoulder</li> </ul>	[empty string]	N	89	100	L,XL,M,S,2X	[empty string]	[empty string]	1000	NF0A5GBC	364761	TOPS	LONG SLEEVE	EMPTY	0	0	0	WOMEN	[empty string]	north-face/women-s-canyonlands-hoodie-364761	1
8	N96,R8R	NORTH FACE	NORTH FACE	CLOTHING	Clothing>Women>Tops>Long Sleeve	N96\|NULL\|NULL,R8R\|NULL\|NULL	1	90	1	79	101324-DEFAULT-l.jpg	90	101324-DEFAULT-m.jpg	W CANYONLANDS FULL ZIP	N	6.1 AMBER	[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]	34	50-to-100	0.00	[empty string]	WOMEN'S CANYONLANDS FULL ZIP	<p>The slim-fit Women’s Canyonlands Full-Zip Hoodie features a smooth 200-weight fleece that is stretchable and comfortable. With secure-zip hand pockets and set-in sleeves, this is a layer you’ll reach for all year long.</p> <p> </p> <ul> <li>Slim fit</li> <li>200-weight, stretch smooth-face fleece with a brushed back for comfort</li> <li>Set-in sleeves</li> <li>Exposed, reverse-coil center front zip with a zipper garage at upper neck</li> <li>Secure-zip hand pockets</li> <li>Binding on collar, cuffs and hem</li> <li>Heat transfer logo on left chest and back-right shoulder</li> </ul>	[empty string]	N	79	90	L,XL,M,2X,S	101324-DEFAULT-s.jpg	[empty string]	1000	NF0A5GBD	364764	TOPS	LONG SLEEVE	EMPTY	0	0	0	WOMEN	[empty string]	north-face/women-s-canyonlands-full-zip-364764	1
9	N11	NORTH FACE	NORTH FACE	CLOTHING	Clothing>Mens>Outerwear>Tops	N11\|NULL\|NULL	1	140	1	129	101359-DEFAULT-l.jpg	140	101359-DEFAULT-m.jpg	M ALTA VISTA JACKET	N	6.1 AMBER	[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]	8	100-to-150	0.00	[empty string]	MEN'S ALTA VISTA JACKET	<p>The Men’s Alta Vista Jacket, made with 100% recycled fabrics, will quickly become your go-to hike shell. With a water-repellent finish and technical features like an adjustable hood, pit-zip venting, and a secure-zip pocket, it’ll take your trail exploration to the next level.</p> <p> </p> <ul> <li>Standard fit</li> <li>Waterproof, breathable, seam-sealed DryVent 2.5L shell with a non-PFC DWR finish helps keep you dry</li> <li>Attached, three-piece hood with a drawcord and cord locks for adjustability</li> <li>Exposed, water-repellent center front zip</li> <li>Vertical secure-zip chest pocket</li> <li>Stows in chest pocket</li> <li>Exposed-zip hand pockets</li> <li>Internal drop-in pocket behind hand pocket</li> <li>Elastic drawcord with a cord lock at hem for adjustability</li> <li>Adjustable hook-and-loop cuff tabs</li> <li>Printed lining</li> <li>Heat transfer logo on left chest and back-right shoulder</li> </ul>	[empty string]	N	129	140	L,2X,M,XL	101359-DEFAULT-s.jpg	[empty string]	1000	NF0A7QAW	364769	OUTERWEAR	TOPS	EMPTY	0	0	0	MENS	[empty string]	north-face/men-s-alta-vista-jacket-364769	1
10	HKW,7D0	NORTH FACE	NORTH FACE	CLOTHING	Clothing>Mens>Tops>Long Sleeve	HKW\|NULL\|NULL,7D0\|NULL\|NULL	1	90	1	79	101360-DEFAULT-l.jpg	90	101360-DEFAULT-m.jpg	M CANYONLANDS FULL ZIP	N	6.1 AMBER	[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]	22	50-to-100	0.00	[empty string]	MEN'S CANYONLANDS FULL ZIP	<p>The Men’s Canyonlands Full-Zip features a smooth 200-weight fleece that is stretchable and comfortable. With secure-zip hand pockets and raglan sleeves for mobility, this is a versatile layer you’ll reach for all year long.</p> <p> </p> <ul> <li>Standard fit</li> <li>200-weight, stretch smooth-face fleece with a brushed back for comfort</li> <li>Raglan sleeves for increased mobility and comfort with a pack</li> <li>Exposed, reverse-coil center front zip with a zipper garage at upper neck</li> <li>Secure-zip chest pocket and hand pockets</li> <li>Elastic binding on collar, cuffs and hem</li> <li>Internal locker loop at back of neckline</li> <li>Heat transfer logo on left chest and back-right shoulder</li> </ul>	[empty string]	N	79	90	XL,L,M,2X,3X	101360-DEFAULT-s.jpg	[empty string]	1000	NF0A5G9V	364784	TOPS	LONG SLEEVE	EMPTY	0	0	0	MENS	[empty string]	north-face/men-s-canyonlands-full-zip-364784	1
11	N89,DYY	NORTH FACE	NORTH FACE	CLOTHING	Clothing>Mens>Tops>Long Sleeve	N89\|NULL\|NULL,DYY\|NULL\|NULL	1	80	1	69	101412-DEFAULT-l.jpg	80	101412-DEFAULT-m.jpg	M CANYONLAND HALF ZIP	N	6.1 AMBER	[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]	11	50-to-100	0.00	[empty string]	MEN'S CANYONLANDS HALF-ZIP	<p>The Men’s Canyonlands ½-Zip features a smooth 200-weight fleece that is stretchable and comfortable. With secure-zip hand pockets and raglan sleeves for mobility, this is a versatile layer you’ll reach for all year long.</p> <p> </p> <ul> <li>Standard fit</li> <li>200-weight, stretch smooth-face fleece with a brushed back for comfort</li> <li>Raglan sleeves for increased mobility and comfort with a pack</li> <li>Exposed, reverse-coil center front half zip with a zipper garage at upper neck</li> <li>Secure-zip chest pocket</li> <li>Elastic binding on collar, cuffs and hem</li> <li>Internal locker loop at back of neckline</li> <li>Heat transfer logo on left chest and back-right shoulder</li> </ul>	[empty string]	N	69	80	XL,L,2X,M	101412-DEFAULT-s.jpg	[empty string]	1000	NF0A5G9W	364786	TOPS	LONG SLEEVE	EMPTY	0	0	0	MENS	[empty string]	north-face/men-s-canyonlands-half-zip-364786	1
12	A91,HDC,37U,OC5	NORTH FACE	NORTH FACE	CLOTHING	Clothing>Mens>Accessories>Hats	A91\|NULL\|NULL,HDC\|NULL\|NULL,37U\|NULL\|NULL,OC5\|NULL\|NULL	0	45	0	45	[empty string]	45	[empty string]	HORIZON BREEZE BRIMMER HAT	N	6.1 AMBER	[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]	30	25-to-50	0.00	[empty string]	HORIZON BREEZE BRIMMER HAT	<p>The Horizon Breeze Brimmer Hat is an airy full-brim hat, with sweat-wicking FlashDry, and UPF 40+ protection. It’s perfect for long, memorable days in the summer sun. It’s proudly recommended by The Skin Cancer Foundation, earning their Seal of Recommendation for safe and effective UV protection.</p> <p> </p> <ul> <li>Body made with recycled nylon and lining made with recycled polyester</li> <li>Sweatband features FlashDry-Pro materials that actively pull moisture away from the body to keep you feeling dry and comfortable during activity</li> <li>Adjustable chin strap with a cord lock made with recycled plastic</li> <li>Ultraviolet Protection Factor (UPF) 40+</li> <li>Proudly recommended by The Skin Cancer Foundation, earning their Seal of Recommendation for safe and effective UV protection</li> <li>Heat transfer logo</li> </ul>	[empty string]	N	45	45	S/M,L/XL	[empty string]	[empty string]	1000	NF0A5FX6	364789	EMPTY	HATS	EMPTY	0	0	0	MENS	[empty string]	north-face/horizon-breeze-brimmer-hat-364789	1
13	KY4,LK3	NORTH FACE	NORTH FACE	CAMPING	Camping>Packs and Bags>Bags	KY4\|NULL\|NULL,LK3\|NULL\|NULL	1	89.99	0	89.99	101514-DEFAULT-l.jpg	89.99	101514-DEFAULT-m.jpg	BASE CAMP VOYAGER 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]	4	50-to-100	0.00	[empty string]	BASE CAMP VOYAGER TOTE	<p>The versatile Base Camp Voyager Tote uses highly-durable, fully recycled fabrics. With multiple storage compartments including a 16'' laptop sleeve, removable shoulder strap and a luggage pass-through, this bag is an ideal all-purpose choice.</p> <p> </p> <ul> <li>Base Camp Voyager material is recycled, durable and lightweight</li> <li>Can be carried at your side, over the shoulder or cross body</li> <li>Central zippered main compartment holds larger items</li> <li>Removable shoulder strap</li> <li>Can pack into its own pocket for storage and portability</li> <li>Luggage pass-through for attaching tote to rolling luggage</li> <li>Two external, zippered pockets</li> <li>Padded 16'' laptop sleeve with a clip for added security</li> <li>Internal mesh zippered pocket</li> <li>Daisy chain where you can clip on items</li> </ul> <p> </p> <ul> <li>One size</li> <li>Body: Recycled 300D polyester with durable TPU coating</li> <li>Avg Weight: 1 lb 10.3 oz</li> <li>Boot: Recycled 840D ballistic nylon with non-PFC durable water-repellent (non-PFC DWR) finish</li> <li>Dimensions: 14.3'' x 15'' x 5.9''</li> <li>Volume: 1465 in³ (24 liters)</li> </ul>	[empty string]	N	89.99	89.99	[empty string]	101514-DEFAULT-s.jpg	[empty string]	1000	NF0A81BM	373035	EMPTY	EMPTY	EMPTY	0	0	0	PACKS AND BAGS	[empty string]	north-face/base-camp-voyager-tote-373035	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Categories

Size

2X
30
32
34
36
38
3X
40
L
L/XL
M
S
S/M
XL

Filter