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/CHARCOAL	STOHLQUIST	Stohlquist	WATERSPORTS	Watersports>Accessories	BLACK/CHARCOAL\|NULL\|NULL	0	22.99	0	22.99	[empty string]	22.99	[empty string]	CONTACT PADDLE GLOVE	N	4 JENNIFER	[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]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	4	20-to-25	0.00	[empty string]	Contact Paddle Glove	[empty string]	[empty string]	N	22.99	22.99	M,S	[empty string]	[empty string]	1000	GL1431001	140658	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	stohlquist/contact-paddle-glove-140658	1
2	BLACK/CHARCOAL	STOHLQUIST	Stohlquist	FOOTWEAR	Footwear>Leisure and Casual	BLACK/CHARCOAL\|NULL\|NULL	0	15.99	0	15.99	[empty string]	15.99	[empty string]	MENS SEABOARD WATERSHOE	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]	5	15-to-20	0.00	[empty string]	Seaboard Watershoe - Men`s	<p>FEATURES:<br /> -2mm upper<br /> -High grip PVC-free, Octo-Sole provides excellent traction on wet surfaces<br /> -Super soft 5mm EVA insole for lasting comfort<br /> -Nylon mesh panels for ventilation and drainage<br /> -Toe and heel bumpers for added protection on rocky shores<br /> -Pull loop at heel allows for quick and easy entry<br /> -Lightweight and compressible for easy packing<br /> -Breathable and fast drying toe-zone<br /> -Non-markign outsoles</p>	[empty string]	N	15.99	15.99	9,5,6	[empty string]	[empty string]	1000	FM113010	155013	EMPTY	EMPTY	EMPTY	0	0	0	LEISURE AND CASUAL	[empty string]	stohlquist/mens-seaboard-watershoe-155013	1
3	BLACK/BLUE	STOHLQUIST	Stohlquist	FOOTWEAR	Footwear>Leisure and Casual	BLACK/BLUE\|NULL\|NULL	0	15.99	0	15.99	[empty string]	15.99	[empty string]	WMS SEABOARD WATERSHOE	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]	WOMENS	ACTIVE	NOT ONLINE	[empty string]	[empty string]	14	15-to-20	0.00	[empty string]	Seaboard Watershoe - Women`s	<p>FEATURES:<br /> -2mm upper<br /> -High grip PVC-free, Octo-Sole provides excellent traction on wet surfaces<br /> -Super soft 5mm EVA insole for lasting comfort<br /> -Nylon mesh panels for ventilation and drainage<br /> -Toe and heel bumpers for added protection on rocky shores<br /> -Pull loop at heel allows for quick and easy entry<br /> -Lightweight and compressible for easy packing<br /> -Breathable and fast drying toe-zone<br /> -Non-markign outsoles</p>	[empty string]	N	15.99	15.99	5,6,7	[empty string]	[empty string]	1000	FW0260101	155014	EMPTY	EMPTY	EMPTY	0	0	0	LEISURE AND CASUAL	[empty string]	stohlquist/wms-seaboard-watershoe-155014	1
4	PURPLE	STOHLQUIST	Stohlquist	WATERSPORTS	Watersports>Flotation Devices (PFDs)	PURPLE\|NULL\|NULL	0	99.99	0	99.99	[empty string]	99.99	[empty string]	WMS FLO PURPLE PFD PADDLERS	N	4 JENNIFER	[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]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	5	50-to-100	0.00	[empty string]	Flo	<p>The EBB is one of Stohlquist`s most popular women’s specific PFDs, now offered in Graded Sizing for the ultimate fit. The higher mesh back design fits more comfortably above the taller seat backs found in today’s rec/touring kayaks. A revised women’s specific cup design also provides a more appropriate fit for a wider range of sizes; from teens and petites, to plus size paddlers.</p> <p> </p> <p>-Supportive inner cup design<br /> -Graded Sizing provides a more appropriate fit for all body types<br /> -Ergonomic WRAPTURE shaped torso<br /> -Cross-chest cinch harness for zero ride-up<br /> -Mesh shoulders & back for maximum ventilation<br /> -Two large, front bellows pockets <br /> -Adjustable shoulder and side pulls<br /> -Lightweight (PVC Free) PE Foam<br /> -Higher, mesh back design for tall seats<br /> -Open sides for maximum ventilation<br /> -Entry grip tab at zipper base<br /> -Sea level buoyancy of 16 lbs 4 oz<br /> -US Coast Guard Approved</p>	[empty string]	N	99.99	99.99	XS/SM,MED/LG	[empty string]	[empty string]	1000	FLO	249573	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	stohlquist/wms-flo-purple-pfd-paddlers-249573	1
5	SUN/GRAY	STOHLQUIST	Stohlquist	WATERSPORTS	Watersports>Flotation Devices (PFDs)	SUN/GRAY\|NULL\|NULL	0	89.99	0	89.99	[empty string]	89.99	[empty string]	WMS MISTY PFD SUN/GRAY	N	4 JENNIFER	[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]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	12	50-to-100	0.00	[empty string]	Misty	<p>Along with Stohlquist`s Graded Sizing, the Misty features a Thin Back Design offering more coverage and ensuring compatibility with any seat back style. The Misty is great for use with boats that feature a higher seat back, but are right at home in a touring boat with sprayskirt.</p>	[empty string]	N	89.99	89.99	S,M,L	[empty string]	[empty string]	1000	MISTY	260163	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	stohlquist/wms-misty-pfd-sun-gray-260163	1
6	BLUE/BLACK	STOHLQUIST	Stohlquist	WATERSPORTS	Watersports>Flotation Devices (PFDs)	BLUE/BLACK\|NULL\|NULL	0	89.99	0	89.99	[empty string]	89.99	[empty string]	MNS COASTER PFD ROYAL BLUE/ BLACK	N	4 JENNIFER	[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]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	5	50-to-100	0.00	[empty string]	Coaster	<p>Along with Stohlquist`s Graded Sizing, the Coaster features a Thin Back Design offering more coverage and ensuring compatibility with any seat back style. The Coaster is perfect for use with boats that feature a higher seat back, but are right at home in a touring boat with sprayskirt.</p>	[empty string]	N	89.99	89.99	L,M	[empty string]	[empty string]	1000	COASTER	260164	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	stohlquist/mns-coaster-pfd-royal-blue-black-260164	1
7	PACIFICBLUE	STOHLQUIST	Stohlquist	WATERSPORTS	Watersports>Flotation Devices (PFDs)	PACIFICBLUE\|NULL\|NULL	0	69.99	0	69.99	[empty string]	69.99	[empty string]	MNS OSFA PFD VEST	N	4 JENNIFER	[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]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	1	50-to-100	0.00	[empty string]	Osfa	<p>The OSFA (One Size Fits All) is a terrific jacket for those looking for a simple, great fitting jacket for recreational paddling. Highly adjustable, it’s a perfect vest to share with family and friends.</p>	[empty string]	N	69.99	69.99	OSFA	[empty string]	[empty string]	1000	QF134310UN	292716	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	stohlquist/mns-osfa-pfd-vest-292716	1
8	SAILBLUE	STOHLQUIST	Stohlquist	WATERSPORTS	Watersports>Flotation Devices (PFDs)	SAILBLUE\|NULL\|NULL	0	69.99	0	69.99	[empty string]	69.99	[empty string]	WMS MELODY OSFA PFD VEST	N	4 JENNIFER	[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]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	6	50-to-100	0.00	[empty string]	Melody	<p>FEATURES:<br /> -Multi-Fit design fits chest ranges 28"-46"<br /> -Women`s specific design with supportive inner cups<br /> -High back flotation rides above the seat back of sit-on-top kayaks<br /> -Front buckle entry<br /> -Highly adjustable 1 1/2” webbing shoulder and side pulls<br /> -Cross-chest cinch harness for zero ride-up<br /> -Convenient webbing strap pockets to eliminate the “danglies”<br /> -Type III PFD with sea level buoyancy of 16 lbs 4 oz<br /> -USCG approved</p>	[empty string]	N	69.99	69.99	OSFA	[empty string]	[empty string]	1000	MELODY	292717	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	stohlquist/wms-melody-osfa-pfd-vest-292717	1
9	KHAKI	STOHLQUIST	Stohlquist	WATERSPORTS	Watersports>Flotation Devices (PFDs)	KHAKI\|NULL\|NULL	0	99.99	0	99.99	[empty string]	99.99	[empty string]	PISEAS FISHING VEST	N	4 JENNIFER	[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]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	2	50-to-100	0.00	[empty string]	Piseas	<p>Now offered in Stohlquist`s exclusive Graded Sizing, which offers a better fitting, lower profile vest for anglers of every size. The new, higher mesh-back design fits comfortably above the tallest seat backs found in today’s fishing boats.</p>	[empty string]	N	99.99	99.99	S/M	[empty string]	[empty string]	1000	PISEAS	292718	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	stohlquist/piseas-fishing-vest-292718	1
10	STEELGREEN	STOHLQUIST	Stohlquist	WATERSPORTS	Watersports>Flotation Devices (PFDs)	STEELGREEN\|NULL\|NULL	0	109.99	0	109.99	[empty string]	109.99	[empty string]	MNS CANDENCE PFD	N	4 JENNIFER	[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]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	2	100-to-150	0.00	[empty string]	Mns Candence Pfd	[empty string]	[empty string]	N	109.99	109.99	S/M,L/XL	[empty string]	[empty string]	1000	CADENCE	342146	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	stohlquist/mns-candence-pfd-342146	1
11	TURQUOISE	STOHLQUIST	Stohlquist	WATERSPORTS	Watersports>Flotation Devices (PFDs)	TURQUOISE\|NULL\|NULL	0	109.99	0	109.99	[empty string]	109.99	[empty string]	WMS GLIDE PFD	N	4 JENNIFER	[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]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	12	100-to-150	0.00	[empty string]	Wms Glide Pfd	[empty string]	[empty string]	N	109.99	109.99	PLUS,XS/SM	[empty string]	[empty string]	1000	GLIDE	342147	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	stohlquist/wms-glide-pfd-342147	1
12	BLK/GRY	STOHLQUIST	Stohlquist	WATERSPORTS	Watersports>Flotation Devices (PFDs)	BLK/GRY\|NULL\|NULL	0	39.99	0	39.99	[empty string]	39.99	[empty string]	WMS BROOK PFD	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	SPRING	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	4	25-to-50	0.00	[empty string]	Wms Brook Pfd	[empty string]	[empty string]	N	39.99	39.99	XS/SM,PLUS	[empty string]	[empty string]	1000	BROOK	342148	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	stohlquist/wms-brook-pfd-342148	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Filter