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	AQUABOUND	Aqua Bound	WATERSPORTS	Watersports>Paddles	BLACK\|NULL\|NULL	0	119.99	0	119.99	[empty string]	119.99	[empty string]	SUP PADDLE 2PC ALUMINUM SHAFT	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	INSTORE PICK UP ONLY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2022	[empty string]	[empty string]	ACTIVE	PROP 65	[empty string]	[empty string]	11	100-to-150	0.00	[empty string]	Spark 85	<p>This entry-level paddle has a strong, epX engineered polymer blade and an aluminum shaft to help beginners get a feel for this sport. The Spark 85 weighs just 28.5 oz and it is the most value-conscious SUP paddle in the Aqua-Bound lineup.</p>	[empty string]	N	119.99	119.99	70/80,76/86	[empty string]	[empty string]	1000	SPARK	172400	EMPTY	EMPTY	EMPTY	0	0	0	PADDLES	[empty string]	aqua-bound/sup-paddle-2pc-aluminum-shaft-172400	1
2	WHITE	AQUABOUND	Aqua Bound	WATERSPORTS	Watersports>Paddles	WHITE\|NULL\|NULL	0	174.99	0	174.99	[empty string]	174.99	[empty string]	PADDLE 2PC CARBON/GLASS POSI-LOK WHITE	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	INSTORE PICK UP ONLY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2022	[empty string]	[empty string]	ACTIVE	PROP 65	[empty string]	[empty string]	16	150-to-200	0.00	[empty string]	Manta Ray Hybrid	<p>The Manta Ray Hybrid is built for high-angle paddlers, bigger boats, and paddlers looking for more power. With its all-carbon shaft and large, abXII fiberglass-reinforced blades, the Manta Ray Hybrid has a low swing weight and provides both comfort and power at a great price point. The Manta Ray Hybrid offers the Posi-Lok ferrule system which clicks into position firmly and securely. The Posi-Lok features strong, corrosion-free composite construction, convenient dual-button release, and infinite feathering angles.</p>	[empty string]	N	174.99	174.99	230,240,250	[empty string]	[empty string]	1000	MANTA RAY HYBRID	172601	EMPTY	EMPTY	EMPTY	0	0	0	PADDLES	[empty string]	aqua-bound/paddle-2pc-carbon-glass-posi-lok-white-172601	1
3	BLACK	AQUABOUND	Aqua Bound	WATERSPORTS	Watersports>Paddles	BLACK\|NULL\|NULL	0	224.99	0	224.99	[empty string]	224.99	[empty string]	PADDLE 2PC SMALL SHAFT POS-LOCK	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	INSTORE PICK UP ONLY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2022	[empty string]	[empty string]	ACTIVE	PROP 65	[empty string]	[empty string]	7	200-to-250	0.00	[empty string]	Sting Ray Carbon	<p>The Sting Ray Carbon has mid-sized blades (91 square inches) made of abX resin reinforced with carbon fibers. Couple that with its all-carbon shaft, and this paddle weighs in at just 28.75 ounces. This gives the Sting Ray Carbon a low swing weight and makes for a more comfortable journey.</p> <p> </p> <p>The Sting Ray Carbon offers the Posi-Lok ferrule system which clicks into position firmly and securely. The Posi-Lok features strong, corrosion-free composite construction, convenient dual-button release, and infinite feathering angles.</p>	[empty string]	N	224.99	224.99	230,220	[empty string]	[empty string]	1000	STING RAY CARBON SMALL SHAFT	180102	EMPTY	EMPTY	EMPTY	0	0	0	PADDLES	[empty string]	aqua-bound/paddle-2pc-small-shaft-pos-lock-180102	1
4	[empty string]	AQUABOUND	Aqua Bound	WATERSPORTS	Watersports>Paddles	[empty string]	0	224.99	0	224.99	[empty string]	224.99	[empty string]	PADDLE 2PC CARBON POSI LOCK BLACK	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	INSTORE PICK UP ONLY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2022	[empty string]	[empty string]	ACTIVE	PROP 65	[empty string]	[empty string]	22	200-to-250	0.00	[empty string]	Manta Ray Carbon	<p>With its beefy blade, the Manta Ray Carbon is a great choice for high-angle paddlers, those looking for more power, bigger boats, and moving water. At just 29.5 ounces, the Manta Ray Carbon is a light high-angle injection molded paddle, and its stiff, durable abX blades will help you move some serious water. All this power is balanced out with an ovalized, 100% carbon composite shaft, which means less fatigue and joint strain.</p> <p> </p> <p>The Manta Ray Carbon offers the Posi-Lok ferrule system which clicks into position firmly and securely. The Posi-Lok features strong, corrosion-free composite construction, convenient dual-button release, and infinite feathering angles.</p>	[empty string]	N	224.99	224.99	240,230,220	[empty string]	[empty string]	1000	MANTA RAY CARBON	180103	EMPTY	EMPTY	EMPTY	0	0	0	PADDLES	[empty string]	aqua-bound/paddle-2pc-carbon-posi-lock-black-180103	1
5	BLACK/ORANGE	AQUABOUND	Aqua Bound	WATERSPORTS	Watersports>Paddles	BLACK/ORANGE\|NULL\|NULL	0	209.99	0	209.99	[empty string]	209.99	[empty string]	SUP PADDLE CARBON SHAFT 2PC	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	INSTORE PICK UP ONLY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2022	[empty string]	[empty string]	ACTIVE	PROP 65	[empty string]	[empty string]	8	200-to-250	0.00	[empty string]	Challenge 85	<p>The Challenge 85 has a lightweight, all-carbon shaft with a 10° bend to provide low swing weight and a slight shaft flex for very comfortable performance. Its epX engineered polymer blade has enhanced stiffness and strength thanks to its carbon-fiber reinforcement. The blade has an aggressive dihedral down its spine for a smooth, forgiving forward stroke. And the Challenge’s eye-popping Polynesian graphics speak to the origin of paddleboarding – an offshoot of the 1960’s surfing culture of Hawaii. The Challenge’s overall black color makes it an ideal color match for virtually every SUP board.</p> <p> </p> <p>At just 21 oz, the Challenge 85 stand-up paddle – with its all-carbon shaft, grip, and ferrule, and its carbon-reinforced epX engineered polymer blade – is ideal for SUP touring. It’s easy on your joints and muscles whatever your adventure.</p>	[empty string]	N	209.99	209.99	70/80,76/86	[empty string]	[empty string]	1000	CHALLENGE	263377	EMPTY	EMPTY	EMPTY	0	0	0	PADDLES	[empty string]	aqua-bound/sup-paddle-carbon-shaft-2pc-263377	1
6	WHITE	AQUABOUND	Aqua Bound	WATERSPORTS	Watersports>Paddles	WHITE\|NULL\|NULL	0	174.99	0	174.99	[empty string]	174.99	[empty string]	PADDLE 2PC FIBERGLASS POSI LOCK	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	INSTORE PICK UP ONLY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2022	[empty string]	[empty string]	ACTIVE	PROP 65	[empty string]	[empty string]	20	150-to-200	0.00	[empty string]	Sting Ray Hybrid	<p>The Sting Ray Hybrid is a light injection molded kayak paddle. With its mid-sized blades built of exclusive Aqua-Bound abXII resin reinforced with fiberglass and its all-carbon shaft, this paddle reduces fatigue and joint strain for flat-water paddlers.</p> <p> </p> <p>The Sting Ray Hybrid offers the Posi-Lok ferrule system which clicks into position firmly and securely. The Posi-Lok features strong, corrosion-free composite construction, convenient dual-button release, and infinite feathering angles.</p>	[empty string]	N	174.99	174.99	230,240,220,250	[empty string]	[empty string]	1000	STING RAY HYBRID	281598	EMPTY	EMPTY	EMPTY	0	0	0	PADDLES	[empty string]	aqua-bound/paddle-2pc-fiberglass-posi-lock-281598	1
7	FUEGO,GRNTIDE	AQUABOUND	Aqua Bound	WATERSPORTS	Watersports>Paddles	FUEGO\|NULL\|NULL,GRNTIDE\|NULL\|NULL	0	324.99	0	324.99	[empty string]	324.99	[empty string]	TANGO KAYAK PADDLE 2PC POSI-LOK 26OZ	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	INSTORE PICK UP ONLY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2022	[empty string]	[empty string]	ACTIVE	PROP 65	[empty string]	[empty string]	14	300-to-350	0.00	[empty string]	Tango Fiberglass	<p>The Tango Fiberglass’ multi-laminate fiberglass blades are truly hand-crafted using high-pressure compression molding, and they come in three hi-vis color options: Agua, Fuego, and Sunwave. Along with its all-carbon T-700 shaft, the Tango Fiberglass paddle has a super light swing weight yet is strong and very durable.</p> <p> </p> <p>The Tango Fiberglass is available in a 100% Carbon Posi-Lok ferrule system which clicks into position firmly and securely. The Posi-Lok features strong, corrosion-free  construction, convenient dual-button release, and infinite feathering angles.</p>	[empty string]	N	324.99	324.99	235,240,230,245	[empty string]	[empty string]	1000	TANGO FIBERGLASS	300552	EMPTY	EMPTY	EMPTY	0	0	0	PADDLES	[empty string]	aqua-bound/tango-kayak-paddle-2pc-posi-lok-26oz-300552	1
8	BLUE	AQUABOUND	Aqua Bound	WATERSPORTS	Watersports>Paddles	BLUE\|NULL\|NULL	0	159.99	0	159.99	[empty string]	159.99	[empty string]	SUP PADDLE 2PC CARBON SHAFT	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	INSTORE PICK UP ONLY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2022	[empty string]	[empty string]	ACTIVE	PROP 65	[empty string]	[empty string]	13	150-to-200	0.00	[empty string]	Freedom 85	<p>The Freedom 85 paddle has a cool Polynesian look along with an ocean-blue color that complements most boards. This blade is made of Aqua-Bound’s strong epX engineered polymer – no whimpy, whippy blade here. With an aggressive dihedral down its spine, the blade makes for a forgiving and smooth pull through the water. The Freedom 85 has a smaller, 85 square inches blade for smaller paddlers or those who prefer high-cadence paddling for faster speed.</p>	[empty string]	N	159.99	159.99	70/80,76/86,64/74	[empty string]	[empty string]	1000	FREEDOM 85	311020	EMPTY	EMPTY	EMPTY	0	0	0	PADDLES	[empty string]	aqua-bound/sup-paddle-2pc-carbon-shaft-311020	1
9	BLACK	AQUABOUND	Aqua Bound	WATERSPORTS	Watersports>Paddles	BLACK\|NULL\|NULL	0	224.99	0	224.99	[empty string]	224.99	[empty string]	PADDLE 2PC POS-LOCK	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	INSTORE PICK UP ONLY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2022	[empty string]	[empty string]	ACTIVE	PROP 65	[empty string]	[empty string]	6	200-to-250	0.00	[empty string]	Paddle 2pc Pos-lock	[empty string]	[empty string]	N	224.99	224.99	230,240	[empty string]	[empty string]	1000	STING RAY CARBON	350843	EMPTY	EMPTY	EMPTY	0	0	0	PADDLES	[empty string]	aqua-bound/paddle-2pc-pos-lock-350843	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Filter