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	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]	3	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	9,11.5,13	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
2	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]	2	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.5,12	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
3	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]	8	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,8.5,9,10	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
4	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]	MAP	[empty string]	[empty string]	[empty string]	[empty string]	SUMMER	[empty string]	2022	[empty string]	WOMENS	ACTIVE	[empty string]	[empty string]	[empty string]	10	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.5,9.5,10,9,7,7.5,8	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
5	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]	MAP	[empty string]	[empty string]	[empty string]	[empty string]	SUMMER	[empty string]	2022	[empty string]	WOMENS	ACTIVE	[empty string]	[empty string]	[empty string]	5	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	9.5,7.5,8,9	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
6	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]	MAP	[empty string]	[empty string]	[empty string]	[empty string]	SUMMER	[empty string]	2023	[empty string]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	3	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	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
7	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]	MAP	[empty string]	[empty string]	[empty string]	[empty string]	SUMMER	[empty string]	2023	[empty string]	WOMENS	ACTIVE	[empty string]	[empty string]	[empty string]	6	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	9.5,10,7.5,8,8.5	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
8	LANAI/BREEZE	OLUKAI	Olukai	FOOTWEAR	Footwear>Sandals	LANAI/BREEZE\|NULL\|NULL	1	74.99	0	74.99	103944-DEFAULT-l.jpg	74.99	103944-DEFAULT-m.jpg	W PI OE	N	5 EMILY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	MAP	[empty string]	[empty string]	[empty string]	[empty string]	SUMMER	[empty string]	2023	[empty string]	WOMENS	ACTIVE	[empty string]	[empty string]	[empty string]	3	50-to-100	0.00	[empty string]	PI'OE - WOMEN'S - LANAI/BREEZE	<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 designed to float</li> <li>Anatomically contoured footbeds deliver instant comfort and lasting support</li> <li>Non-marking Wet Grip Rubber delivers unmatched traction</li> </ul>	[empty string]	N	74.99	74.99	9,10	103944-DEFAULT-s.jpg	[empty string]	1000	20443-NBDW	373105	EMPTY	EMPTY	EMPTY	0	0	0	SANDALS	[empty string]	olukai/pi-oe-women-s-lanai-breeze-373105	1
9	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]	MAP	[empty string]	[empty string]	[empty string]	[empty string]	SUMMER	[empty string]	2023	[empty string]	WOMENS	ACTIVE	[empty string]	[empty string]	[empty string]	1	50-to-100	0.00	[empty string]	KULAPA KAI - WOMEN'S - 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	9	100039-DEFAULT-s.jpg	[empty string]	1000	20198-3P40	373106	EMPTY	EMPTY	EMPTY	0	0	0	SANDALS	[empty string]	olukai/kulapa-kai-women-s-petal-pink-black-373106	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Gender

MENS
WOMENS

Filter