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	1	119.99	0	119.99	94796-DEFAULT-l.jpg	119.99	94796-DEFAULT-m.jpg	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	<ul> <li>A durable, solidly-built paddle for beginners or for the board at your cabin</li> <li>85 sq in blade profile is less fatiguing, ideal for high-cadence paddling</li> <li>Weighs only 28.5 ounces</li> </ul> <p> </p> <ul> <li>Shaft Material: Aluminum 10° bend </li> <li>Blade Material: epX Engineered Polymer, Fiberglass Reinforced</li> <li>Blade Size: 7.5" x 14.5" (85 sq in)</li> <li>Blade Surface Area: 85 sq in (548 sq cm)</li> <li>Weight: 28.5 oz (808 g)</li> </ul>	[empty string]	N	119.99	119.99	70/80,76/86	94796-DEFAULT-s.jpg	[empty string]	1000	SPARK	172400	EMPTY	EMPTY	EMPTY	0	0	0	PADDLES	[empty string]	aqua-bound/spark-85-172400	1
2	WHITE	AQUABOUND	Aqua Bound	WATERSPORTS	Watersports>Paddles	WHITE\|NULL\|NULL	1	174.99	0	174.99	94792-DEFAULT-l.jpg	174.99	94792-DEFAULT-m.jpg	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]	11	150-to-200	0.00	[empty string]	MANTA RAY HYBRID	<ul> <li>Built for high-angle paddlers, bigger boats, and paddlers looking for more power</li> <li>The 100% Carbon shaft is lightweight, durable and reduces fatigue and joint strain</li> <li>The abXII fiberglass-reinforced blades and all carbon shaft provide a low swing weight</li> <li>Posi-Lok ferrule system allows for infinite feather angles</li> </ul> <p> </p> <ul> <li>Shaft Material: 100% Carbon</li> <li>Blade Material: abXII Fiberglass Reinforced Nylon</li> <li>Blade Size: 7.25" x 18" (18 x 46 cm)</li> <li>Blade Surface Area: 105 sq in (677 sq cm)</li> <li>Weight: 31.75 oz (900 g)</li> <li>Ferrule Angles: Infinite</li> </ul>	[empty string]	N	174.99	174.99	230,240,250	94792-DEFAULT-s.jpg	[empty string]	1000	MANTA RAY HYBRID	172601	EMPTY	EMPTY	EMPTY	0	0	0	PADDLES	[empty string]	aqua-bound/manta-ray-hybrid-172601	1
3	BLACK	AQUABOUND	Aqua Bound	WATERSPORTS	Watersports>Paddles	BLACK\|NULL\|NULL	1	224.99	0	224.99	94789-DEFAULT-l.jpg	224.99	94789-DEFAULT-m.jpg	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]	6	200-to-250	0.00	[empty string]	STING RAY CARBON - SMALL SHAFT	<ul> <li>100% Carbon shaft delivers superior performance</li> <li>Mid-sized, carbon reinforced blades allow for a smooth, flutter free forward stroke</li> <li>Weighing 28.75 ounces, the Sting Ray Carbon is a light flatwater injected molded kayak paddle</li> <li>The Sting Ray Carbon offers the Posi-Lok ferrule system which clicks into position firmly and securely featuring strong, corrosion-free composite construction, convenient dual-button release, and infinite feathering angles</li> </ul> <p> </p> <ul> <li>Shaft Material: 100% Carbon</li> <li>Blade Material: abX Carbon Reinforced Nylon</li> <li>Blade Size: 6.25" x 18" (16 x 46 cm)</li> <li>Blade Surface Area: 91 sq in (587 sq cm) </li> <li>Weight: 28.75 oz (815 g)</li> <li>Ferrule Angles: Infinite</li> </ul>	[empty string]	N	224.99	224.99	220,230	94789-DEFAULT-s.jpg	[empty string]	1000	STING RAY CARBON SMALL SHAFT	180102	EMPTY	EMPTY	EMPTY	0	0	0	PADDLES	[empty string]	aqua-bound/sting-ray-carbon-small-shaft-180102	1
4	[empty string]	AQUABOUND	Aqua Bound	WATERSPORTS	Watersports>Paddles	[empty string]	1	224.99	0	224.99	94787-DEFAULT-l.jpg	224.99	94787-DEFAULT-m.jpg	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]	19	200-to-250	0.00	[empty string]	MANTA RAY CARBON	<ul> <li>At just 29.5 oz, the Manta Ray Carbon is a light high-angle injection molded paddle</li> <li>The abX blades are stiff and durable to help you move some serious water</li> <li>Big, beefy blades are ideal for high-angler paddlers needing more power to move more water and heavy boats</li> <li>Ovalized, 100% carbon shaft delivers superior performance</li> <li>The corrosion-free composite construction of the Posi-Lok ferrule system allows for infinite feather angles and features a convenient dual-button release</li> </ul> <p> </p> <ul> <li>Shaft Material: 100% Carbon</li> <li>Blade Material: abX Carbon Reinforced Nylon</li> <li>Blade Size: 7.25" x 18" (18 x 46 cm)</li> <li>Blade Surface Area: 105 sq in (677 sq cm)</li> <li>Weight: 29.5 oz (836 g)</li> <li>Ferrule Angles: Infinite</li> </ul>	[empty string]	N	224.99	224.99	240,230,220	94787-DEFAULT-s.jpg	[empty string]	1000	MANTA RAY CARBON	180103	EMPTY	EMPTY	EMPTY	0	0	0	PADDLES	[empty string]	aqua-bound/manta-ray-carbon-180103	1
5	BLACK/ORANGE	AQUABOUND	Aqua Bound	WATERSPORTS	Watersports>Paddles	BLACK/ORANGE\|NULL\|NULL	1	209.99	0	209.99	94794-DEFAULT-l.jpg	209.99	94794-DEFAULT-m.jpg	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]	6	200-to-250	0.00	[empty string]	CHALLENGE 85	<ul> <li>Ideal for SUP touring, an aggressive dihedral down the spine delivers a smooth, powerful forward stroke </li> <li>A lightweight, all-carbon shaft with a 10° bend  provides a low swing weight and a slight shaft flex for very comfortable performance</li> <li>The 85 sq in blade has enhanced stiffness and strength thanks to its carbon-fiber reinforcement</li> <li>Weighing 21 oz, the Challenge is easy on your joints and muscles</li> <li>A contoured palm grip made entirely out of carbon is comfortable in your hands</li> <li>The 100% carbon ferrule is light, strong and corrosion resistant</li> </ul> <p> </p> <ul> <li>Shaft Material: 100% Carbon with 10° bend</li> <li>Blade Material: epX Engineered Polymer, Carbon Reinforced</li> <li>Blade Size: 7.5" x 14.5" (19 x 37 cm)</li> <li>Blade Surface Area: 85 sq in (548 sq cm)</li> <li>Weight: 21 oz (595 g)</li> <li>Grip: Contoured Palm Grip</li> </ul>	[empty string]	N	209.99	209.99	76/86,70/80	94794-DEFAULT-s.jpg	[empty string]	1000	CHALLENGE	263377	EMPTY	EMPTY	EMPTY	0	0	0	PADDLES	[empty string]	aqua-bound/challenge-85-263377	1
6	WHITE	AQUABOUND	Aqua Bound	WATERSPORTS	Watersports>Paddles	WHITE\|NULL\|NULL	1	174.99	0	174.99	94790-DEFAULT-l.jpg	174.99	94790-DEFAULT-m.jpg	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	<ul> <li>100% Carbon shaft is lightweight to reduce fatigue and joint strain and very durable</li> <li>Mid-sized, fiberglass reinforced blades allow for a smooth, flutter free forward stroke</li> <li>The Sting Ray Hybrid offers the Posi-Lok ferrule system which clicks into position firmly and securely featuring strong, corrosion-free composite construction, convenient dual-button release, and infinite feathering angles</li> </ul> <p> </p> <ul> <li>Shaft Material: 100% Carbon</li> <li>Blade Material: abXII Fiberglass Reinforced Nylon</li> <li>Blade Size: 6.25" x 18" (16 x 46 cm)</li> <li>Blade Surface Area: 91 sq in (587 sq cm)</li> <li>Weight: 30.5 oz (865 g)</li> <li>Ferrule Angles: Infinite</li> </ul>	[empty string]	N	174.99	174.99	230,240,220,250	94790-DEFAULT-s.jpg	[empty string]	1000	STING RAY HYBRID	281598	EMPTY	EMPTY	EMPTY	0	0	0	PADDLES	[empty string]	aqua-bound/sting-ray-hybrid-281598	1
7	FUEGO,GRNTIDE,NLIGHTS	AQUABOUND	Aqua Bound	WATERSPORTS	Watersports>Paddles	FUEGO\|NULL\|NULL,GRNTIDE\|NULL\|NULL,NLIGHTS\|NULL\|NULL	1	324.99	0	324.99	94791-DEFAULT-l.jpg	324.99	94791-DEFAULT-m.jpg	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]	29	300-to-350	0.00	[empty string]	TANGO - FIBERGLASS	<ul> <li>Multi-laminate fiberglass blades are hand-crafted using high-pressure compression molding</li> <li>The T-700 carbon shaft is strong, durable and lightweight</li> <li>Ultra-light, low-angle paddle, for maximum results with minimal effort</li> <li>Effortless and smooth paddling stroke</li> <li>100% carbon Posi-Lok ferrule system</li> </ul> <p> </p> <ul> <li>Shaft Material: T-700 Carbon </li> <li>Blade Material: Compression Molded Fiberglass</li> <li>Blade Size: 6.6" x 17.9" (17 x 45 cm)</li> <li>Blade Surface Area: 96 sq in (619 sq cm)</li> <li>Weight: 26 oz (737 g)</li> <li>Ferrule Angles: Infinite</li> </ul>	[empty string]	N	324.99	324.99	235,240,230,220,250,245	94791-DEFAULT-s.jpg	[empty string]	1000	TANGO FIBERGLASS	300552	EMPTY	EMPTY	EMPTY	0	0	0	PADDLES	[empty string]	aqua-bound/tango-fiberglass-300552	1
8	BLUE	AQUABOUND	Aqua Bound	WATERSPORTS	Watersports>Paddles	BLUE\|NULL\|NULL	1	159.99	0	159.99	94793-DEFAULT-l.jpg	159.99	94793-DEFAULT-m.jpg	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	<ul> <li>epX engineered polymer blade delivers more power with every stroke</li> <li>Aggressive dihedral down the spine of blade makes for a forgiving and smooth pull through the water</li> <li>85 sq. in. blade provides a less fatiguing experience and is best for high-cadence paddling</li> <li>There is a slight flex in the 100% carbon shaft with a 10° bend for very comfortable performance</li> <li>Contoured palm grip</li> </ul> <p> </p> <ul> <li>Shaft Material: 100% Carbon with 10° bend </li> <li>Blade Material: epX Engineered Polymer, Fiberglass Reinforced</li> <li>Blade Size: 7.5" x 14.5" (19 x 37 cm)</li> <li>Blade Surface Area: 85 sq in (548 sq cm)</li> <li>Weight: 23.5 oz (666 g)</li> <li>Grip: Contoured Palm Grip</li> </ul>	[empty string]	N	159.99	159.99	70/80,76/86,64/74	94793-DEFAULT-s.jpg	[empty string]	1000	FREEDOM 85	311020	EMPTY	EMPTY	EMPTY	0	0	0	PADDLES	[empty string]	aqua-bound/freedom-85-311020	1
9	BLACK	AQUABOUND	Aqua Bound	WATERSPORTS	Watersports>Paddles	BLACK\|NULL\|NULL	1	224.99	0	224.99	94788-DEFAULT-l.jpg	224.99	94788-DEFAULT-m.jpg	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]	5	200-to-250	0.00	[empty string]	STING RAY CARBON	<ul> <li>100% Carbon shaft delivers superior performance</li> <li>Mid-sized, carbon reinforced blades allow for a smooth, flutter free forward stroke</li> <li>Weighing 28.75 ounces, the Sting Ray Carbon is a light flatwater injected molded kayak paddle</li> <li>The Sting Ray Carbon offers the Posi-Lok ferrule system which clicks into position firmly and securely featuring strong, corrosion-free composite construction, convenient dual-button release, and infinite feathering angles</li> </ul> <p> </p> <ul> <li>Shaft Material: 100% Carbon</li> <li>Blade Material: abX Carbon Reinforced Nylon</li> <li>Blade Size: 6.25" x 18" (16 x 46 cm)</li> <li>Blade Surface Area: 91 sq in (587 sq cm) </li> <li>Weight: 28.75 oz (815 g)</li> <li>Ferrule Angles: Infinite</li> </ul>	[empty string]	N	224.99	224.99	240,230	94788-DEFAULT-s.jpg	[empty string]	1000	STING RAY CARBON	350843	EMPTY	EMPTY	EMPTY	0	0	0	PADDLES	[empty string]	aqua-bound/sting-ray-carbon-350843	1
10	YELLOW	AQUABOUND	Aqua Bound	WATERSPORTS	Watersports>Paddles	YELLOW\|NULL\|NULL	1	129.99	0	129.99	94795-DEFAULT-l.jpg	129.99	94795-DEFAULT-m.jpg	PADDLE 2PC FIBERGLASS SNAP BUTTON	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	[empty string]	[empty string]	[empty string]	6	100-to-150	0.00	[empty string]	STING RAY - FIBERGLASS	<ul> <li>Fiberglass shaft is lightweight and warm on the hands</li> <li>Mid-sized, fiberglass-reinforced blades allow for a smooth, flutter free forward stroke</li> <li>Snug fitting, snap-button ferrule allows for multiple feather angles</li> </ul> <p> </p> <ul> <li>Shaft Material: Fiberglass</li> <li>Blade Material: abXII Fiberglass Reinforced Nylon</li> <li>Blade Size: 6.25" x 18" (16 x 46 cm)</li> <li>Blade Surface Area: 91 sq in (587 sq cm) </li> <li>Weight: 34 oz (964 g)</li> <li>Ferrule Angles: 0° & 60° (L or R)</li> </ul>	[empty string]	N	129.99	129.99	220,230,240	94795-DEFAULT-s.jpg	[empty string]	1000	STINGRAY FIBERGLASS	358191	EMPTY	EMPTY	EMPTY	0	0	0	PADDLES	[empty string]	aqua-bound/sting-ray-fiberglass-358191	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Filter