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	DKWOOD/DKWOOD	OLUKAI	Olukai	FOOTWEAR	Footwear>Slippers	DKWOOD/DKWOOD\|NULL\|NULL	1	119.99	0	119.99	93011-DEFAULT-l.jpg	119.99	93011-DEFAULT-m.jpg	M MOLOA SLIPPER	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]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	3	100-to-150	0.00	[empty string]	MOLOA SLIPPER - DARK WOOD - MEN'S	<p>Your go-to slipper, no matter the season. Made with premium leather and the softest genuine shearling.</p> <p> </p> <ul> <li>Heavily waxed nubuck leather, warm shearling and collapsible Drop-In Heel</li> <li>Anatomically contoured footbeds deliver instant comfort and lasting support</li> <li>Footbeds aer removable & washable</li> <li>Non-Marking gum rubber outsole with a buffed finish offers a durable surface and modern feel</li> </ul>	[empty string]	N	119.99	119.99	9,10,13	93011-DEFAULT-s.jpg	[empty string]	1000	10252-6363	356334	EMPTY	EMPTY	EMPTY	0	0	0	SLIPPERS	[empty string]	olukai/moloa-slipper-dark-wood-men-s-356334	1
2	BRIGHTWHITE/HUA	OLUKAI	Olukai	FOOTWEAR	Footwear>Sandals	BRIGHTWHITE/HUA\|NULL\|NULL	1	74.99	0	74.99	100051-DEFAULT-l.jpg	74.99	100051-DEFAULT-m.jpg	W OHANA BEACH SANDAL	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]	9	50-to-100	0.00	[empty string]	OHANA - BRIGHT WHITE / HUA - WOMEN'S	<p>An essential beach sandal made with cushioned, water-resistant sandal materials that will make your feet feel at home.</p> <p> </p> <ul> <li>Classic sandal with water-resistant straps, quick-drying lining and a soft nylon toe post for absolute comfort</li> <li>Anatomically contoured footbeds deliver instant comfort and lasting support</li> <li>Non-marking rubber outsole with coral reef lug design enhances traction on wet surfaces</li> </ul>	[empty string]	N	74.99	74.99	8,9,7,6	100051-DEFAULT-s.jpg	[empty string]	1000	20110-WBHQ	362769	EMPTY	EMPTY	EMPTY	0	0	0	SANDALS	[empty string]	olukai/ohana-bright-white-hua-women-s-362769	1
3	TOFFEE	OLUKAI	Olukai	FOOTWEAR	Footwear>Leisure and Casual	TOFFEE\|NULL\|NULL	1	129.99	0	129.99	100050-DEFAULT-l.jpg	129.99	100050-DEFAULT-m.jpg	M MOLOA	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]	8	100-to-150	0.00	[empty string]	MOLOA - RAY / TOFFEE - MEN'S	<p>A high-character leather shoe that can handle a serious meeting or a spontaneous night out.</p> <p> </p> <ul> <li>Crafted with waxed or antiqued leathers, hand-sewn whipstitching and moisturing wicking lining</li> <li>Anatomically contoured footbeds deliver instant comfort and lasting support</li> <li>Footbeds aer removable & washable</li> <li>Extra grip for the adventure ahead</li> <li>All-weather, non-marking outsole features traction pods for flexability and traction</li> </ul>	[empty string]	N	129.99	129.99	11.5,13,9,9.5,10,11	100050-DEFAULT-s.jpg	[empty string]	1000	10128-2733	363452	EMPTY	EMPTY	EMPTY	0	0	0	LEISURE AND CASUAL	[empty string]	olukai/moloa-ray-toffee-men-s-363452	1
4	BLACK/TOFFEE	OLUKAI	Olukai	FOOTWEAR	Footwear>Leisure and Casual	BLACK/TOFFEE\|NULL\|NULL	1	129.99	0	129.99	100049-DEFAULT-l.jpg	129.99	100049-DEFAULT-m.jpg	M MOLOA	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]	7	100-to-150	0.00	[empty string]	MOLOA - BLACK / TOFFEE - MEN'S	<p>A high-character leather shoe that can handle a serious meeting or a spontaneous night out.</p> <p> </p> <ul> <li>Crafted with waxed or antiqued leathers, hand-sewn whipstitching and moisturing wicking lining</li> <li>Anatomically contoured footbeds deliver instant comfort and lasting support</li> <li>Footbeds aer removable & washable</li> <li>Extra grip for the adventure ahead</li> <li>All-weather, non-marking outsole features traction pods for flexability and traction</li> </ul>	[empty string]	N	129.99	129.99	9,12,13,9.5,10.5	100049-DEFAULT-s.jpg	[empty string]	1000	10128-4033	363453	EMPTY	EMPTY	EMPTY	0	0	0	LEISURE AND CASUAL	[empty string]	olukai/moloa-black-toffee-men-s-363453	1
5	DUSTYOLIVE	OLUKAI	Olukai	FOOTWEAR	Footwear>Leisure and Casual	DUSTYOLIVE\|NULL\|NULL	1	149.99	0	149.99	100048-DEFAULT-l.jpg	149.99	100048-DEFAULT-m.jpg	W HAWAIILOA MANU HOPE	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]	WOMENS	ACTIVE	[empty string]	[empty string]	[empty string]	9	100-to-150	0.00	[empty string]	HAWAI'ILOA MANU HOPE - DUSTY OLIVE / CLOUD - WOMEN'S	<p>A well-crafted boot made with waterproof leather to keep you comfortable and inspired on the journey ahead.</p> <p> </p> <ul> <li>Waterproof nubuck leather boot with crafted details inspired by the Hawai'iloa voyaging canoe</li> <li>Anatomically contoured footbeds deliver instant comfort and lasting support</li> <li>Designed for sure-footed exploration, Olukai's non-marking Wet Grip Rubber delivers, unmatched traction</li> </ul>	[empty string]	N	149.99	149.99	8,7.5,10,8.5,9	100048-DEFAULT-s.jpg	[empty string]	1000	20397-TZ3D	363454	EMPTY	EMPTY	EMPTY	0	0	0	LEISURE AND CASUAL	[empty string]	olukai/hawai-iloa-manu-hope-dusty-olive-cloud-women-s-363454	1
6	TAPA	OLUKAI	Olukai	FOOTWEAR	Footwear>Leisure and Casual	TAPA\|NULL\|NULL	1	99.99	0	99.99	100046-DEFAULT-l.jpg	99.99	100046-DEFAULT-m.jpg	W PEHUEA	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]	WOMENS	ACTIVE	[empty string]	[empty string]	[empty string]	11	50-to-100	0.00	[empty string]	PEHUEA - TAPA - WOMEN'S	<p>Olukai's classic slip-on sneaker, made with lightweight, breezy mesh and soft cushioned midsole.</p> <p> </p> <ul> <li>Crafted with lightweight materials and collapsible Drop-In Heel</li> <li>Anatomically contoured footbeds deliver instant comfort and lasting support</li> <li>Footbeds aer removable & washable</li> <li>Designed for sure-footed exploration, Olukai's non-marking Wet Grip Rubber delivers, unmatched traction</li> </ul>	[empty string]	N	99.99	99.99	8,8.5,9.5,10,9,7,7.5	100046-DEFAULT-s.jpg	[empty string]	1000	20271-2020	363456	EMPTY	EMPTY	EMPTY	0	0	0	LEISURE AND CASUAL	[empty string]	olukai/pehuea-tapa-women-s-363456	1
7	PAVEMENT	OLUKAI	Olukai	FOOTWEAR	Footwear>Leisure and Casual	PAVEMENT\|NULL\|NULL	1	99.99	0	99.99	100047-DEFAULT-l.jpg	99.99	100047-DEFAULT-m.jpg	W PEHUEA	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]	WOMENS	ACTIVE	[empty string]	[empty string]	[empty string]	11	50-to-100	0.00	[empty string]	PEHUEA - PAVEMENT - WOMEN'S	<p>Olukai's classic slip-on sneaker, made with lightweight, breezy mesh and soft cushioned midsole.</p> <p> </p> <ul> <li>Crafted with lightweight materials and collapsible Drop-In Heel</li> <li>Anatomically contoured footbeds deliver instant comfort and lasting support</li> <li>Footbeds aer removable & washable</li> <li>Designed for sure-footed exploration, Olukai's non-marking Wet Grip Rubber delivers, unmatched traction</li> </ul>	[empty string]	N	99.99	99.99	7.5,8,9,9.5,10,8.5,7	100047-DEFAULT-s.jpg	[empty string]	1000	20271-PVPV	363457	EMPTY	EMPTY	EMPTY	0	0	0	LEISURE AND CASUAL	[empty string]	olukai/pehuea-pavement-women-s-363457	1
8	PAVEMENT	OLUKAI	Olukai	FOOTWEAR	Footwear>Leisure and Casual	PAVEMENT\|NULL\|NULL	1	99.99	0	99.99	100045-DEFAULT-l.jpg	99.99	100045-DEFAULT-m.jpg	M LAE`AHI	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]	12	50-to-100	0.00	[empty string]	LAE'AHI - PAVEMENT	<p>Olukai's classic slip-on sneaker, made with lightweight, breezy mesh and soft cushioned midsole.</p> <p> </p> <ul> <li>The ideal shoe for barefoot wear with airy mesh and a soft microfiber lining</li> <li>Wear it as a sneaker or slide with Olukai's Drop-In Heel</li> <li>Anatomically contoured footbeds deliver instant comfort and lasting support</li> <li>Footbeds aer removable & washable</li> <li>Designed for sure-footed exploration, Olukai's non-marking Wet Grip Rubber delivers, unmatched traction</li> </ul>	[empty string]	N	99.99	99.99	10,9.5,10.5,9	100045-DEFAULT-s.jpg	[empty string]	1000	10443-PVPV	373096	EMPTY	EMPTY	EMPTY	0	0	0	LEISURE AND CASUAL	[empty string]	olukai/lae-ahi-pavement-373096	1
9	BLUEDEPTH/CHAR	OLUKAI	Olukai	FOOTWEAR	Footwear>Sandals	BLUEDEPTH/CHAR\|NULL\|NULL	1	79.99	0	79.99	100043-DEFAULT-l.jpg	79.99	100043-DEFAULT-m.jpg	M ULELE	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]	9	50-to-100	0.00	[empty string]	ULELE - BLUE DEPTH / CHARCOAL	<p>The ultimate beach sandal built with water-resistant materials, extra grip, and the support of a sneaker.</p> <p> </p> <ul> <li>Delivers as much support as a pair of sneakers</li> <li>Sleek, water-resistant and digned to float</li> <li>Anatomically contoured footbeds deliver instant comfort and lasting support</li> <li>Designed for sure-footed exploration, Olukai's non-marking Wet Grip Rubber delivers, unmatched traction</li> </ul>	[empty string]	N	79.99	79.99	9,11,12,13,10	100043-DEFAULT-s.jpg	[empty string]	1000	10435-TF26	373100	EMPTY	EMPTY	EMPTY	0	0	0	SANDALS	[empty string]	olukai/ulele-blue-depth-charcoal-373100	1
10	DKWOOD	OLUKAI	Olukai	FOOTWEAR	Footwear>Sandals	DKWOOD\|NULL\|NULL	1	74.99	0	74.99	100042-DEFAULT-l.jpg	74.99	100042-DEFAULT-m.jpg	M HOKUA	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]	12	50-to-100	0.00	[empty string]	HOKUA - DARK WOOD	<p>A quick-drying beach sandal inspired by the kaula (rope) used on voyaging canoes.</p> <p> </p> <ul> <li>Water-resistant straps</li> <li>Quick-dry lining</li> <li>Raised rope strap design</li> <li>Anatomically contoured footbeds deliver instant comfort and lasting support</li> <li>Non-marking rubber outsole features a sea urchin lug design and razor siping for added traction</li> </ul>	[empty string]	N	74.99	74.99	10,11,12,9	100042-DEFAULT-s.jpg	[empty string]	1000	10161-6363	373102	EMPTY	EMPTY	EMPTY	0	0	0	SANDALS	[empty string]	olukai/hokua-dark-wood-373102	1
11	TAPA	OLUKAI	Olukai	FOOTWEAR	Footwear>Leisure and Casual	TAPA\|NULL\|NULL	1	99.99	0	99.99	100041-DEFAULT-l.jpg	99.99	100041-DEFAULT-m.jpg	W PEHUEA LI	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]	12	50-to-100	0.00	[empty string]	PEHUEA LI - TAPA	<p>An unbelievably comfortable sneaker designed to be as easygoing as a day in the Islands.</p> <p> </p> <ul> <li>The ideal shoe for barefoot wear with airy mesh and a soft microfiber lining</li> <li>Wear it as a sneaker or slide with Olukai's Drop-In Heel</li> <li>Anatomically contoured footbeds deliver instant comfort and lasting support</li> <li>Footbeds aer removable & washable</li> <li>Designed for sure-footed exploration, Olukai's non-marking Wet Grip Rubber delivers, unmatched traction</li> </ul>	[empty string]	N	99.99	99.99	7.5,8,8.5,9,9.5,10,7	100041-DEFAULT-s.jpg	[empty string]	1000	20379-2020	373103	EMPTY	EMPTY	EMPTY	0	0	0	LEISURE AND CASUAL	[empty string]	olukai/pehuea-li-tapa-373103	1
12	COPPER	OLUKAI	Olukai	FOOTWEAR	Footwear>Sandals	COPPER\|NULL\|NULL	1	89.99	0	89.99	100040-DEFAULT-l.jpg	89.99	100040-DEFAULT-m.jpg	W AUKAI	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]	12	50-to-100	0.00	[empty string]	AUKAI - COPPER / DARK JAVA	<p>Aukai everyday sandal built with velvety soft leather and a comfortable footbed for all-day wear.</p> <p> </p> <ul> <li>Designed for daily wear, the velvety soft nubuck leather and soft strap lining on Aukai make it a closet essential</li> <li>Insipred by the feeling of bare feet in wet sand, the anatomically contoured footbeds deliver instant comfort and lasting support</li> <li>Designed for sure-footed exploration, Olukai's non-marking Wet Grip Rubber delivers, unmatched traction</li> </ul>	[empty string]	N	89.99	89.99	8,9,7,10	100040-DEFAULT-s.jpg	[empty string]	1000	20442-CO48	373104	EMPTY	EMPTY	EMPTY	0	0	0	SANDALS	[empty string]	olukai/aukai-copper-dark-java-373104	1
13	PETAL/BLK	OLUKAI	Olukai	FOOTWEAR	Footwear>Sandals	PETAL/BLK\|NULL\|NULL	1	74.99	0	74.99	100039-DEFAULT-l.jpg	74.99	100039-DEFAULT-m.jpg	W KULAPA KAI	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]	12	50-to-100	0.00	[empty string]	KULAPA KAI - PETAL PINK / BLACK	<p>A sporty sandal made with water-resistant materials and a pebbled strap design.</p> <p> </p> <ul> <li>Water-resistant synthetic straps featuring a shiny or matte finish with quick-drying jersey knit lining and a soft nylon toe post</li> <li>A compression molded EVA midsole with a smooth dropin ICEVA footbed provides an anatomical fit for sustained comfort over time</li> <li>Non-marking rubber outsole with molded siping and traction pod design detail inspired by ocean currents</li> </ul>	[empty string]	N	74.99	74.99	8,9,10,7	100039-DEFAULT-s.jpg	[empty string]	1000	20198-3P40	373106	EMPTY	EMPTY	EMPTY	0	0	0	SANDALS	[empty string]	olukai/kulapa-kai-petal-pink-black-373106	1
14	BLACK/BLACK	OLUKAI	Olukai	FOOTWEAR	Footwear>Sandals	BLACK/BLACK\|NULL\|NULL	1	74.99	0	74.99	100038-DEFAULT-l.jpg	74.99	100038-DEFAULT-m.jpg	W KULAPA KAI	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]	12	50-to-100	0.00	[empty string]	KULAPA KAI - BLACK	<p>A sporty sandal made with water-resistant materials and a pebbled strap design.</p> <p> </p> <ul> <li>Water-resistant synthetic straps featuring a shiny or matte finish with quick-drying jersey knit lining and a soft nylon toe post</li> <li>A compression molded EVA midsole with a smooth dropin ICEVA footbed provides an anatomical fit for sustained comfort over time</li> <li>Non-marking rubber outsole with molded siping and traction pod design detail inspired by ocean currents</li> </ul>	[empty string]	N	74.99	74.99	8,9,10,6,7	100038-DEFAULT-s.jpg	[empty string]	1000	20198-4040	373107	EMPTY	EMPTY	EMPTY	0	0	0	SANDALS	[empty string]	olukai/kulapa-kai-black-373107	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Filter