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	EARTH	OBOZ	Oboz	FOOTWEAR	Footwear>Hiking Boots	EARTH\|NULL\|NULL	1	144.99	0	144.99	100028-DEFAULT-l.jpg	144.99	100028-DEFAULT-m.jpg	MNS FIREBRAND II B-DRY HIKER	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]	2021	[empty string]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	20	100-to-150	0.00	[empty string]	FIREBRAND II - LOW - WATERPROOF - MEN'S	<p>The Firebrand II Low Waterproof has all the versatility of the Sawtooth, but in a lower-volume profile. Its leather and abrasion-resistant mesh upper and molded rubber toe cap provide superior protection, while the Sawtooth midsole and outsole provide unbeatable comfort. Add Oboz' B-DRY Waterproof technology and this boot is ready for all conditions and all occasions.</p> <p> </p> <ul> <li>O FIT Insole</li> <li>Sawtooth Midsole</li> <li>Sawtooth Outsole</li> <li>Oboz B-DRY Waterproof</li> </ul> <p> </p> <ul> <li>Upper Material:</li> <li>Waterproof Nubuck leather & highly abrasion-resistant textile</li> <li>Oboz B-DRY waterproof/breathable membrane</li> <li>Molded rubber toe cap</li> </ul> <p> </p> <ul> <li>Weight:18.3 oz</li> </ul>	[empty string]	N	144.99	144.99	9.5,10,10.5,11,11.5,12,13,9	100028-DEFAULT-s.jpg	[empty string]	1000	21301	313570	EMPTY	EMPTY	EMPTY	0	0	0	HIKING BOOTS	[empty string]	oboz/firebrand-ii-low-waterproof-men-s-313570	1
2	SUDAN	OBOZ	Oboz	FOOTWEAR	Footwear>Hiking Boots	SUDAN\|NULL\|NULL	1	189.99	0	189.99	100037-DEFAULT-l.jpg	189.99	100037-DEFAULT-m.jpg	MNS BRIDGER MID B-DRY HIKER	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]	2021	[empty string]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	28	150-to-200	0.00	[empty string]	BRIDGER - MID - WATERPROOF - MEN'S	<p>The Bridger Mid Waterproof has long been a serious hiker's favorite boot. They have a short break-in period, are amazingly comfortable in part thanks to its O-FIT insole, and are super durable. No matter the length of your planned journey, the Bridger Mid will keep your feet dry with Oboz' B-DRY waterproofing technology and the Granite Peak outsole with forefoot plate and rubber toe guard. You'll be able to tackle roots, rocks, and more with comfort and confidence.</p> <p> </p> <ul> <li>O FIT Insole</li> <li>Granite Peak Midsole</li> <li>Granite Peak Outsole</li> <li>Oboz B-DRY Waterproof</li> </ul> <p> </p> <ul> <li>Upper Material:</li> <li>Waterproof Nubuck leather</li> <li>Oboz B-DRY waterproof/breathable membrane</li> <li>Molded rubber toe cap & heel counter</li> </ul> <p> </p> <ul> <li>Weight: 19.0 oz</li> </ul>	[empty string]	N	189.99	189.99	9,9.5,10.5,11,11.5,12,10,8.5	100037-DEFAULT-s.jpg	[empty string]	1000	22101	313580	EMPTY	EMPTY	EMPTY	0	0	0	HIKING BOOTS	[empty string]	oboz/bridger-mid-waterproof-men-s-313580	1
3	DKSHADOW	OBOZ	Oboz	FOOTWEAR	Footwear>Hiking Boots	DKSHADOW\|NULL\|NULL	1	164.99	0	164.99	100034-DEFAULT-l.jpg	164.99	100034-DEFAULT-m.jpg	M SYPES MID B DRY	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]	2021	[empty string]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	7	150-to-200	0.00	[empty string]	SYPES - LEATHER - MID - WATERPROOF - MEN'S	<p>Tracking Sypes Canyon Trail dust back into town, the Sypes Mid Leather Waterproof delivers light-hiker performance with an ACT Intelligent PU midsole that belies its laid-back looks. Repreve materials and algae biomass lighten the environmental impact, while deep lugs tame trails both dirt and paved.</p> <p> </p> <ul> <li>O FIT Insole BLOOM</li> <li>Recycled Materials</li> <li>Long Lasting Materials</li> <li>Bend Midsole</li> <li>Bend Outsole</li> <li>Oboz B-DRY Waterproof</li> </ul> <p> </p> <ul> <li>Upper Material:</li> <li>Waterproof nubuck leather</li> <li>CORDURA AFT mesh fabric & TPU overlays</li> <li>100% rPET REPREVE laces</li> <li>rPET webbing and lining</li> </ul> <p> </p> <ul> <li>Weight: 16.6 oz</li> </ul>	[empty string]	N	164.99	164.99	10,10.5,11,11.5,12,9	100034-DEFAULT-s.jpg	[empty string]	1000	77101	350585	EMPTY	EMPTY	EMPTY	0	0	0	HIKING BOOTS	[empty string]	oboz/sypes-leather-mid-waterproof-men-s-350585	1
4	LILAC	OBOZ	Oboz	FOOTWEAR	Footwear>Hiking Boots	LILAC\|NULL\|NULL	1	144.99	0	144.99	100029-DEFAULT-l.jpg	144.99	100029-DEFAULT-m.jpg	WNS FIREBRAND II LOW B DRY	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]	2021	[empty string]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	10	100-to-150	0.00	[empty string]	FIREBRAND II - LOW - WATERPROOF - WOMEN'S	<p>The Firebrand II is built with the women’s specific Sawtooth midsole and outsole, and has the same unbeatable comfort as the Sawtooth II, but in a lower-volume profile. The upper features a mix of leather and air-mesh, and metal eyelets to provide superior fit. Add OBOZ' B-DRY Waterproof technology and this boot is ready for all conditions and all occasions.</p> <p> </p> <ul> <li>O FIT Insole</li> <li>Sawtooth Midsole</li> <li>Sawtooth Outsole</li> <li>Oboz B-DRY Waterproof</li> </ul> <p> </p> <ul> <li>Upper Material:</li> <li>Waterproof Nubuck leather & highly abrasion-resistant textile</li> <li>Oboz B-DRY waterproof/breathable membrane</li> <li>Molded rubber toe cap</li> </ul> <p> </p> <ul> <li>Weight: 13.8 oz</li> </ul>	[empty string]	N	144.99	144.99	7.5,8.5,9.5,10,9,8	100029-DEFAULT-s.jpg	[empty string]	1000	21302	350586	EMPTY	EMPTY	EMPTY	0	0	0	HIKING BOOTS	[empty string]	oboz/firebrand-ii-low-waterproof-women-s-350586	1
5	DARK/SAGE,PEPPERCORN,THYME	OBOZ	Oboz	FOOTWEAR	Footwear>Hiking Boots	DARK/SAGE\|NULL\|NULL,PEPPERCORN\|NULL\|NULL,THYME\|NULL\|NULL	1	164.99	0	164.99	100032-DEFAULT-l.jpg	164.99	100032-DEFAULT-m.jpg	WMS SYPES MID B DRY	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]	2021	[empty string]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	20	150-to-200	0.00	[empty string]	SYPES - LEATHER - MID - WATERPROOF - WOMEN'S	<p>A mid-height upper adds a boost in support to this understated all-day trail shoe. O FIT Insoles made with Bloom Algae technology pair function-specific design with cutting-edge sustainable material innovation and make the Sypes Mid Leather Waterproof a comfortable choice.</p> <p> </p> <ul> <li>O FIT Insole BLOOM</li> <li>Recycled Materials</li> <li>Long Lasting Materials</li> <li>Bend Midsole</li> <li>Bend Outsole</li> <li>Oboz B-DRY Waterproof</li> </ul> <p> </p> <ul> <li>Upper Material:</li> <li>Waterproof nubuck leather</li> <li>CORDURA AFT mesh fabric & TPU overlays</li> <li>100% rPET REPREVE laces</li> <li>rPET webbing and lining</li> </ul> <p> </p> <ul> <li>Weight: 13.83 oz</li> </ul>	[empty string]	N	164.99	164.99	8,8.5,9,9.5,7.5	100032-DEFAULT-s.jpg	[empty string]	1000	77102	350587	EMPTY	EMPTY	EMPTY	0	0	0	HIKING BOOTS	[empty string]	oboz/sypes-leather-mid-waterproof-women-s-350587	1
6	FROSTGREY	OBOZ	Oboz	FOOTWEAR	Footwear>Hiking Boots	FROSTGREY\|NULL\|NULL	1	189.99	0	189.99	100035-DEFAULT-l.jpg	189.99	100035-DEFAULT-m.jpg	W BRIDGER MID B DRY	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]	2021	[empty string]	WOMENS	ACTIVE	[empty string]	[empty string]	[empty string]	16	150-to-200	0.00	[empty string]	BRIDGER - MID - WATERPROOF - WOMEN'S	<p>The Bridger Mid has all the ingredients of a great hiker and it’s why hikers keep coming back to it like their favorite GORP mix. It provides excellent support, durability and trail performance thanks to its supportive heel cup and TPU Chassis which provides stability and helps prevent stone bruising. No matter the trail conditions, the Bridger Mid is ready to help you handle it with comfort and confidence with its B-DRY waterproof technology and aggressive Granite Peak outsole.</p> <p> </p> <ul> <li>O FIT Insole</li> <li>Granite Peak Midsole</li> <li>Granite Peak Outsole</li> <li>Oboz B-DRY Waterproof</li> </ul> <p> </p> <ul> <li>Upper Material:</li> <li>Waterproof Nubuck leather</li> <li>Oboz B-DRY waterproof/breathable membrane</li> <li>Molded rubber toe cap & heel counter</li> </ul> <p> </p> <ul> <li>Weight: 17.7 oz</li> </ul>	[empty string]	N	189.99	189.99	9.5,7.5,8,8.5,9	100035-DEFAULT-s.jpg	[empty string]	1000	22102	355922	EMPTY	EMPTY	EMPTY	0	0	0	HIKING BOOTS	[empty string]	oboz/bridger-mid-waterproof-women-s-355922	1
7	HAZY/GREY	OBOZ	Oboz	FOOTWEAR	Footwear>Hiking Boots	HAZY/GREY\|NULL\|NULL	1	134.99	0	134.99	100031-DEFAULT-l.jpg	134.99	100031-DEFAULT-m.jpg	MNS SAWTOOTH X LOW	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]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	15	100-to-150	0.00	[empty string]	SAWTOOTH X - LOW - MEN'S	<p>The Sawtooth X retains all the things that made the original so popular with the addition of aggressive styling and materials like Oboz' Adaptive Cushioning Technology midsole—all you need to map out your next adventure.</p> <p> </p> <ul> <li>O FIT Insole</li> <li>Sawtooth X ACT Impact Midsole</li> <li>Trail Tread</li> <li>Cordura</li> </ul> <p> </p> <ul> <li>Upper Material:</li> <li>Oiled nubuck</li> <li>Cordura Fabric mesh</li> <li>TPU heel counter</li> <li>100% RPET Repreve Laces</li> <li>100% RPET Repreve Webbing</li> <li>Micro-injected PU window</li> </ul> <p> </p> <ul> <li>Weight: 15.8 oz</li> </ul>	[empty string]	N	134.99	134.99	11,10,10.5,9,9.5,11.5,12	100031-DEFAULT-s.jpg	[empty string]	1000	23901	362941	EMPTY	EMPTY	EMPTY	0	0	0	HIKING BOOTS	[empty string]	oboz/sawtooth-x-low-men-s-362941	1
8	DRIZZLE	OBOZ	Oboz	FOOTWEAR	Footwear>Hiking Boots	DRIZZLE\|NULL\|NULL	1	134.99	0	134.99	100033-DEFAULT-l.jpg	134.99	100033-DEFAULT-m.jpg	WMS SAWTOOTH X LOW	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]	14	100-to-150	0.00	[empty string]	SAWTOOTH X - LOW - WOMEN'S	<p>The Sawtooth X retains all the things that made the original so popular, but now with styling and materials for improved comfort, traction, and durability. The Sawtooth X is sure to comfort your feet while it opens your eyes to new adventures.</p> <p> </p> <ul> <li>O FIT Insole</li> <li>Sawtooth X ACT Impact Midsole</li> <li>Trail Tread</li> <li>Cordura</li> </ul> <p> </p> <ul> <li>Upper Material:</li> <li>Oiled nubuck</li> <li>Cordura Fabric mesh</li> <li>TPU heel counter</li> <li>100% RPET Repreve Laces</li> <li>100% RPET Repreve Webbing</li> <li>Micro-injected PU window</li> </ul> <p> </p> <ul> <li>Weight: 13.6 oz</li> </ul>	[empty string]	N	134.99	134.99	7.5,8,8.5,9.5,9	100033-DEFAULT-s.jpg	[empty string]	1000	23902	362943	EMPTY	EMPTY	EMPTY	0	0	0	HIKING BOOTS	[empty string]	oboz/sawtooth-x-low-women-s-362943	1
9	CANTEEN	OBOZ	Oboz	FOOTWEAR	Footwear>Hiking Boots	CANTEEN\|NULL\|NULL	1	159.99	0	159.99	100036-DEFAULT-l.jpg	159.99	100036-DEFAULT-m.jpg	M SAWTOOTH X LOW B-DRY	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]	25	150-to-200	0.00	[empty string]	SAWTOOTH X - LOW - WATERPROOF - MEN'S	<p> </p> <p>The Sawtooth X Low Waterproof is even more capable than Oboz' beloved original. It has a new outsole for superior traction and a new Adaptive Cushioning Technology midsole for an even smoother ride. But among all this new-ness it retains the same great fit and feel and their B-DRY waterproof technology, so you can be confident taking on the trail, puddle filled or otherwise.</p> <p> </p> <ul> <li>O FIT Insole</li> <li>Sawtooth X ACT Impact Midsole</li> <li>Cordura</li> <li>Repreve</li> <li>Trail Tread</li> <li>Oboz B-DRY Waterproof</li> </ul> <p> </p> <ul> <li>Upper Material:</li> <li>Oiled nubuck</li> <li>Cordura Fabric mesh</li> <li>TPU heel counter</li> <li>B-DRY Waterproof Membrane</li> <li>100% RPET Repreve Laces</li> <li>100% RPET Repreve Webbing</li> <li>Micro-injected PU window</li> </ul> <p> </p> <ul> <li>Weight: 16.9 oz</li> </ul>	[empty string]	N	159.99	159.99	10.5,12,9.5,10,11.5,11,13	100036-DEFAULT-s.jpg	[empty string]	1000	23501	363399	EMPTY	EMPTY	EMPTY	0	0	0	HIKING BOOTS	[empty string]	oboz/sawtooth-x-low-waterproof-men-s-363399	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Filter