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	[empty string]	OCEAN KAYAK	Ocean Kayak	WATERSPORTS	Watersports>Accessories	[empty string]	0	4.99	0	4.99	[empty string]	4.99	[empty string]	SCUPPER STOPPER XSM 2PK	N	4 MAIDA	[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	PROP 65	[empty string]	[empty string]	5	5-AND-under	0.00	[empty string]	Scupper Stoppers - X Small - 2 Pack	<p>Scupper Stoppers can be used to plug the scupper holes in the cockpit of your Ocean Kayak. This will help you stay dry while you are paddling.</p> <p> </p> <p>NOTE: Scupper Stoppers are completely round in shape and will not fit oval-shaped scupper holes.</p>	[empty string]	N	4.99	4.99	[empty string]	[empty string]	[empty string]	1000	07.1966.0000	51963	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	ocean-kayak/scupper-stopper-xsm-2pk-51963	1
2	[empty string]	OCEAN KAYAK	Ocean Kayak	WATERSPORTS	Watersports>Accessories	[empty string]	0	4.99	0	4.99	[empty string]	4.99	[empty string]	SCUPPER STOPPERS SM 2PK	N	4 MAIDA	[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	PROP 65	[empty string]	[empty string]	3	5-AND-under	0.00	[empty string]	Scupper Stoppers - Small - 2 Pack	<p>Scupper Stoppers can be used to plug the scupper holes in the cockpit of your Ocean Kayak. This will help you stay dry while you are paddling.</p> <p> </p> <p>NOTE: Scupper Stoppers are completely round in shape and will not fit oval-shaped scupper holes.</p>	[empty string]	N	4.99	4.99	[empty string]	[empty string]	[empty string]	1000	07.1960.0000	51991	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	ocean-kayak/scupper-stoppers-sm-2pk-51991	1
3	[empty string]	OCEAN KAYAK	Ocean Kayak	WATERSPORTS	Watersports>Accessories	[empty string]	0	4.99	0	4.99	[empty string]	4.99	[empty string]	SCUPPER STOPPERS LG 2PK	N	4 MAIDA	[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	PROP 65	[empty string]	[empty string]	1	5-AND-under	0.00	[empty string]	Scupper Stoppers - Large - 2 Pack	<p>Scupper Stoppers can be used to plug the scupper holes in the cockpit of your Ocean Kayak. This will help you stay dry while you are paddling.</p> <p> </p> <p>NOTE: Scupper Stoppers are completely round in shape and will not fit oval-shaped scupper holes.</p>	[empty string]	N	4.99	4.99	[empty string]	[empty string]	[empty string]	1000	07.1964.0000	51993	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	ocean-kayak/scupper-stoppers-lg-2pk-51993	1
4	YELLOW	OCEAN KAYAK	Ocean Kayak	WATERSPORTS	Watersports>Kayaks	YELLOW\|NULL\|NULL	0	1099.99	0	1099.99	[empty string]	1099.99	[empty string]	KAYAK ANGLER 13.4FT 68LBS 500LBS	N	4 MAIDA	[empty string]	[empty string]	[empty string]	[empty string]	ADULT SIGNATURE	[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	500-or-more	0.00	[empty string]	Malibu Two Xl	The stability and versatility of the world`s most popular all-around family fun boat in a longer craft perfect for larger paddlers. Can be paddled solo or tandem. Fits two adults plus a small child or pet.<br/> <br/> FEATURES:<br/> -Two Comfort Tech seat backs <br/> -Patented overlapping foot wells <br/> -Side-mounted carrying handles <br/> -Deck bungee <br/> -Paddle keepers <br/> SEATING <br/> -Seats two adults, plus a small child or pet. Can also be paddled solo from center seat. <br/>	[empty string]	N	1099.99	1099.99	[empty string]	[empty string]	[empty string]	1000	MALIBU TWO XL ANGLER	91326	EMPTY	EMPTY	EMPTY	0	0	0	KAYAKS	[empty string]	ocean-kayak/kayak-angler-13-4ft-68lbs-500lbs-91326	1
5	[empty string]	OCEAN KAYAK	Ocean Kayak	WATERSPORTS	Watersports>Accessories	[empty string]	0	109.99	0	109.99	[empty string]	109.99	[empty string]	COMFORT ZONE BACKREST	N	4 MAIDA	[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]	BOTH	ACTIVE	PROP 65	[empty string]	[empty string]	1	100-to-150	0.00	[empty string]	Comfort Zone Seat Back	<p>A nice comfortable way to spend a day on the water. The Comfort Zone Seat Back is taller for additional back support and the seat padding has more cushion making it a softer ride.<br />  </p>	[empty string]	N	109.99	109.99	[empty string]	[empty string]	[empty string]	1000	07.2000.0577	146313	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	ocean-kayak/comfort-zone-backrest-146313	1
6	SEAGLASS	OCEAN KAYAK	Ocean Kayak	WATERSPORTS	Watersports>Kayaks	SEAGLASS\|NULL\|NULL	0	599.99	0	599.99	[empty string]	599.99	[empty string]	KAYAK 9.5FT 54LBS CAP 325LBS	N	4 MAIDA	[empty string]	[empty string]	[empty string]	[empty string]	ADULT SIGNATURE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2021	[empty string]	[empty string]	ACTIVE	PROP 65	[empty string]	[empty string]	1	500-or-more	0.00	[empty string]	Malibu 9.5 - 9 Feet 6 Inches	<p><span style=`font-family: ` gt=``>Have a blast atop Ocean`s Malibu series! It’s all about fun and comfort—and if you like to control your own destiny, we’ve got options. These compact, stackable, easy-to-paddle, straight-tracking solo kayaks will turn heads as you master the waves with ease on their super-stable 9.5’ sit-on-top hull designs. Comfort comes easy on the Malibu, thanks to a newly designed AirGo molded-in seat and seat pad with an adjustable AirComfort backrest. No matter your size enjoy comfortable leg room with calf rests and molded-on foot wells. And don’t forget your beverages! The Malibu 9.5 comes equipped with three cup holders.</span></p>	[empty string]	N	599.99	599.99	[empty string]	[empty string]	[empty string]	1000	MALIBU 9.5	307113	EMPTY	EMPTY	EMPTY	0	0	0	KAYAKS	[empty string]	ocean-kayak/kayak-9-5ft-54lbs-cap-325lbs-307113	1
7	[empty string]	OCEAN KAYAK	Ocean Kayak	WATERSPORTS	Watersports>Accessories	[empty string]	0	4.99	0	4.99	[empty string]	4.99	[empty string]	SCUPPER VALVES SHORT 2 PACK	N	4 MAIDA	[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	5-AND-under	0.00	[empty string]	Scupper Valves Short 2 Pack	[empty string]	[empty string]	N	4.99	4.99	[empty string]	[empty string]	[empty string]	1000	07.2000.0782	336569	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	ocean-kayak/scupper-valves-short-2-pack-336569	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Filter