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]	CARLISLE	Carlisle	WATERSPORTS	Watersports>Accessories	[empty string]	0	36.99	0	36.99	[empty string]	36.99	[empty string]	CLAMP ON OAR LOCKS 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	PROP 65	[empty string]	[empty string]	42	25-to-50	0.00	[empty string]	Clamp On Oar Locks - Pair Of 2	<p>If your looking for an easy way to secure oars to your boat, look to the Clamp On Oar Locks from Carlisle. They`re perfect for the Carlisle aluminum Economy boat oars.</p>	[empty string]	N	36.99	36.99	[empty string]	[empty string]	[empty string]	1000	01.2510.0000	12864	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	carlisle/clamp-on-oar-locks-black-12864	1
2	BLACK/BLACK	CARLISLE	Carlisle	WATERSPORTS	Watersports>Paddles	BLACK/BLACK\|NULL\|NULL	1	29.99	0	29.99	94827-DEFAULT-l.jpg	29.99	94827-DEFAULT-m.jpg	CANOE T GRIP PADDLE	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]	2021	[empty string]	[empty string]	ACTIVE	PROP 65	[empty string]	[empty string]	98	25-to-50	0.00	[empty string]	ECONOMY T GRIP	<p>Lightweight and durable, this is the perfect all-purpose paddle. An 8" X 20" blade adds power to your stroke. The tempered-aluminum shaft has a 13" plastic grip for sure handling. Blade and T-grip are molded of high impact polypropylene.</p> <p> </p> <ul> <li>Blade Color: Black</li> <li>Shaft Color: Black</li> <li>Activity: Recreation, Hunting, Fishing</li> <li>Shaft Material: Aluminum</li> <li>Blade Material: High Impact Polypropylene</li> <li>Shaft Diameter: 1.12 in (2.8 cm)</li> <li>Blade Size: 20.75 in x 7.75 in (52.7 cm x 19.7 cm)</li> <li>Grip: T-Grip</li> <li>Length: 48 in</li> <li>Weight: 26 oz (737.1 g)</li> </ul>	[empty string]	N	29.99	29.99	57,54,48,60,63	94827-DEFAULT-s.jpg	[empty string]	1000	ECONOMY T GRIP	131839	EMPTY	EMPTY	EMPTY	0	0	0	PADDLES	[empty string]	carlisle/economy-t-grip-131839	1
3	SUN,PHOTIC,AHI,BLKCHRY,SEAGLASS,CLD/DISC	CARLISLE	Carlisle	WATERSPORTS	Watersports>Paddles	SUN\|NULL\|NULL,PHOTIC\|NULL\|NULL,AHI\|NULL\|NULL,BLKCHRY\|NULL\|NULL,SEAGLASS\|NULL\|NULL,CLD/DISC\|NULL\|NULL	1	99.99	0	99.99	94828-DEFAULT-l.jpg	99.99	94828-DEFAULT-m.jpg	KAYAK PADDLE GLASS 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]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	62	50-to-100	0.00	[empty string]	MAGIC PLUS	<p>Efficient and powerful blade design for touring. Fiberglass reinforced polypropylene blades in bright colors are lightweight and durable. The asymmetrical, slightly curved blade shape combined with a lightweight, flexible fiberglass shaft produces smooth yet powerful strokes.</p> <p> </p> <ul> <li>Glass-filled polypropylene blades are both lightweight and durable</li> <li>Asymmetrical, slightly curved blade shape produces smooth, efficient strokes</li> <li>Lightweight, yet strong, the wrapped fiberglass shaft has an ovalized grip</li> <li>Rubber drip rings help to keep hands and legs dry while paddling</li> <li>No-fail push-button take down allow blades to be feathered at 60-degrees or set inline, for right or left-handed control</li> </ul> <p> </p> <ul> <li>Shaft Color: Black</li> <li>Activity: Touring, Recreation</li> <li>Shaft Material: Wrapped Fiberglass</li> <li>Blade Material: Fiberglass Reinforced Polypropylene</li> <li>Shaft Shape: Straight</li> <li>Shaft Size: Standard</li> <li>Blade Shape: Asymmetrical</li> <li>Blade Size: 18 in x 7.25 in (45.72 cm x 18.41 cm)</li> <li>Hand Control: Right or Left</li> <li>Feather Angle: 0° and 60°</li> <li>Ferrule: Push-button</li> <li>Weight: 2.56 lb (1.162 kg)</li> </ul>	[empty string]	N	99.99	99.99	230,240,220	94828-DEFAULT-s.jpg	[empty string]	1000	MAGIC PLUS	131856	EMPTY	EMPTY	EMPTY	0	0	0	PADDLES	[empty string]	carlisle/magic-plus-131856	1
4	SURF,PHOTIC,SUN,SEAGLASS,AHI,DRKCHRY	CARLISLE	Carlisle	WATERSPORTS	Watersports>Paddles	SURF\|NULL\|NULL,PHOTIC\|NULL\|NULL,SUN\|NULL\|NULL,SEAGLASS\|NULL\|NULL,AHI\|NULL\|NULL,DRKCHRY\|NULL\|NULL	1	79.99	1	69.99	94829-DEFAULT-l.jpg	79.99	94829-DEFAULT-m.jpg	KAYAK PADDLE POLY/ 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]	2021	[empty string]	[empty string]	ACTIVE	PROP 65	[empty string]	[empty string]	51	50-to-100	0.00	[empty string]	MAGIC MYSTIC - ALUMINUM	<p>The Carlisle Magic Mystic is a durable and efficient introductory kayak paddle. The two-piece aluminum shaft and fiberglass-reinforced polypropylene blades provide a durable, reliable option.</p> <p> </p> <ul> <li>Asymmetrical, slightly curved blade shape produces smooth, efficient strokes</li> <li>Anodized aluminum shaft for corrosion-resistance</li> <li>No-fail push-button ferrule allows blades to be set inline, or feathered at 60-degrees for right or left-handed control</li> <li>Two-piece design for compact transport and storage</li> <li>Rubber drip rings keep excess water from running down the paddle shaft and into your lap</li> </ul> <p> </p> <ul> <li>Shaft Color: Blue</li> <li>Activity: Touring, Recreation</li> <li>Shaft Material: Aluminum</li> <li>Blade Material: Fiberglass Reinforced Polypropylene</li> <li>Shaft Shape: Straight</li> <li>Shaft Size: Standard</li> <li>Blade Shape: Asymmetrical</li> <li>Hand Control: Right or Left</li> <li>Feather Angle: 0° and 60°</li> <li>Ferrule: Push-button</li> <li>Weight: 2.59 lb (1.174 kg)</li> </ul>	[empty string]	N	69.99	79.99	230,240,220	94829-DEFAULT-s.jpg	[empty string]	1000	MAGIC MYSTIC ALUMINUM	131857	EMPTY	EMPTY	EMPTY	0	0	0	PADDLES	[empty string]	carlisle/magic-mystic-aluminum-131857	1
5	BLACK,YELLOW	CARLISLE	Carlisle	WATERSPORTS	Watersports>Paddles	BLACK\|NULL\|NULL,YELLOW\|NULL\|NULL	1	49.99	0	49.99	94830-DEFAULT-l.jpg	49.99	94830-DEFAULT-m.jpg	KAYAK 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]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	9	25-to-50	0.00	[empty string]	DAY TRIPPER	<p>Entry level recreational kayak paddle. Asymmetric blades of polypropylene shaped for smooth, efficient strokes. A lightweight anodized aluminum shaft is ovalized for easy gripping. This is the paddle of choice for beginners - or for use as a backup. A push-button takedown allows blades to be feathered at 60-degrees or inline, for right- and left-hand control.</p> <p> </p> <ul> <li>Shaft Color: Silver</li> <li>Activity: Touring, Recreation</li> <li>Shaft Material: Aluminum</li> <li>Blade Material: High Impact Polypropylene</li> <li>Shaft Shape: Straight</li> <li>Shaft Size: Standard</li> <li>Blade Shape: Asymmetrical</li> <li>Hand Control: Right or Left</li> <li>Feather Angle: 0° and 60°</li> <li>Ferrule: Push-button</li> <li>Weight: 2.31 lb (1.049 kg)</li> </ul>	[empty string]	N	49.99	49.99	240,230	94830-DEFAULT-s.jpg	[empty string]	1000	DAY TRIPPER	131859	EMPTY	EMPTY	EMPTY	0	0	0	PADDLES	[empty string]	carlisle/day-tripper-131859	1
6	[empty string]	CARLISLE	Carlisle	WATERSPORTS	Watersports>Paddles	[empty string]	1	14.99	0	14.99	94832-DEFAULT-l.jpg	14.99	94832-DEFAULT-m.jpg	CANOE PADDLE 1PC 54INCH BLACK	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2018	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	10	10-to-15	0.00	[empty string]	VALUE CANOE PADDLE - 54 IN	<p>Great paddle for beginners or for use as a back-up paddle. The Value canoe paddle has a durable aluminum shaft and a polyethylene blade and T-grip. Features a plastic grip on the shaft for sure handling.</p> <p> </p> <ul> <li>Blade Color: Black</li> <li>Shaft Color: Black</li> <li>Activity: Recreation</li> <li>Shaft Material: Aluminum</li> <li>Blade Material: High Impact Polypropylene</li> <li>Grip: T-Grip</li> <li>Length: 54 in</li> <li>Weight: 28 oz (794 g)</li> </ul>	[empty string]	N	14.99	14.99	[empty string]	94832-DEFAULT-s.jpg	[empty string]	1000	VALUE CANOE	307143	EMPTY	EMPTY	EMPTY	0	0	0	PADDLES	[empty string]	carlisle/value-canoe-paddle-54-in-307143	1
7	GREEN/GREEN,YEL/BLU,YEL/RED	CARLISLE	Carlisle	WATERSPORTS	Watersports>Paddles	GREEN/GREEN\|NULL\|NULL,YEL/BLU\|NULL\|NULL,YEL/RED\|NULL\|NULL	1	29.99	0	29.99	94833-DEFAULT-l.jpg	29.99	94833-DEFAULT-m.jpg	STANDARD T GRIP PADDLE	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2018	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	35	25-to-50	0.00	[empty string]	STANDARD T-GRIP	<p>The industry standard for strength and durability. An 8" x 20" blade and fully clad aluminum shaft provides power and reduces maintenance. A comfortable T-Grip handle let's you paddles for hours on end without discomfort.</p> <p> </p> <ul> <li>Blade Color: Olive</li> <li>Shaft Color: Olive</li> <li>Activity: Recreation, Touring</li> <li>Shaft Material: Aluminum</li> <li>Blade Material: High Impact Polypropylene</li> <li>Shaft Diameter: 1.12 in (2.8 cm)</li> <li>Blade Size: 20.75 in x 7.75 in (52.7 cm x 19.7 cm)</li> <li>Grip: T-Grip</li> <li>Weight: 30 oz (850 g)</li> </ul>	[empty string]	N	29.99	29.99	54,57,60	94833-DEFAULT-s.jpg	[empty string]	1000	STD T GRIP	307146	EMPTY	EMPTY	EMPTY	0	0	0	PADDLES	[empty string]	carlisle/standard-t-grip-307146	1
8	SUNRISE,AHI	CARLISLE	Carlisle	WATERSPORTS	Watersports>Paddles	SUNRISE\|NULL\|NULL,AHI\|NULL\|NULL	1	49.99	0	49.99	94835-DEFAULT-l.jpg	49.99	94835-DEFAULT-m.jpg	SABER KIDS 190CM PADDLE	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]	2021	[empty string]	[empty string]	ACTIVE	PROP 65	[empty string]	[empty string]	4	25-to-50	0.00	[empty string]	SABER KID'S PADDLE	<p>The Carlisle Saber is a short, sweet kayak paddle for kids! Lightweight and kid-proof, the paddle is scaled for small hands to grip and maneuver.</p> <p> </p> <ul> <li>Scaled for your child to grip and control with ease</li> <li>Smaller shaft diameter: 1.125 in (2.9 cm)</li> <li>Durable design combines polypropylene blades with an aluminum shaft</li> <li>No-fail push-button ferrule allows blades to be set inline, or feathered at 60-degrees</li> <li>Two-piece design for compact transport and storage</li> <li>Rubber drip rings keep excess water from running down the paddle shaft and into their lap</li> </ul> <p> </p> <ul> <li>Shaft Color: Black</li> <li>Activity: Recreation</li> <li>Shaft Material: Aluminum</li> <li>Blade Material: High Impact Polypropylene</li> <li>Shaft Shape: Straight</li> <li>Shaft Size: Small</li> <li>Blade Shape: Asymmetrical</li> <li>Hand Control: Right or Left</li> <li>Feather Angle: 0° and 60°</li> <li>Ferrule: Push-button</li> <li>Weight: 1.94 lb (0.879 kg)</li> </ul>	[empty string]	N	49.99	49.99	[empty string]	94835-DEFAULT-s.jpg	[empty string]	1000	SABER KIDS	318057	EMPTY	EMPTY	EMPTY	0	0	0	PADDLES	[empty string]	carlisle/saber-kid-s-paddle-318057	1
9	FIRSTLIGHT,CAMO,PHOTIC	CARLISLE	Carlisle	WATERSPORTS	Watersports>Paddles	FIRSTLIGHT\|NULL\|NULL,CAMO\|NULL\|NULL,PHOTIC\|NULL\|NULL	1	119.99	0	119.99	94836-DEFAULT-l.jpg	119.99	94836-DEFAULT-m.jpg	KAYAK PADDLE ANGLER GLASS 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]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	28	100-to-150	0.00	[empty string]	MAGIC ANGLER	<p>Designed for kayak anglers, the Carlisle Magic Angler is a lightweight, efficient and powerful paddle, with angler specific features. The asymmetrical, slightly curved blade shape, combined with a lightweight, flexible fiberglass shaft produces smooth yet powerful strokes. A cutout in the blade is used to free snagged hooks and the ruler on the shaft can be used to measure your catch!</p> <p> </p> <ul> <li>Anglers will appreciate the J-notch cutout in the blade to free snagged lines and hooks</li> <li>Ensure bragging rights when you measure your fish on the imperial/metric rule printed on the shaft</li> <li>Glass-filled polypropylene blades are both lightweight and durable</li> <li>Asymmetrical, slightly curved blade shape produces smooth, efficient strokes</li> <li>Wrapped fiberglass shaft is lightweight yet strong; and more comfortable to hold in hot or cold temperatures</li> <li>Ovalized shaft indexes the proper grip area</li> <li>No-fail push-button take down allow blades to be feathered at 60-degrees or set inline, for right or left-handed control</li> <li>Two-piece design for compact transport and storage</li> <li>Rubber drip rings help to keep hands and legs dry while paddling</li> </ul> <p> </p> <ul> <li>Shaft Color: Black</li> <li>Activity: Fishing</li> <li>Shaft Material: Wrapped Fiberglass</li> <li>Blade Material: Fiberglass Reinforced Polypropylene</li> <li>Shaft Shape: Straight</li> <li>Shaft Size: Standard</li> <li>Blade Shape: Asymmetrical</li> <li>Hand Control: Right or Left</li> <li>Feather Angle: 0° and 60°</li> <li>Ferrule: Push-button</li> <li>Weight: 2.61 lb (1.185 kg)</li> </ul>	[empty string]	N	119.99	119.99	230,240,260,250	94836-DEFAULT-s.jpg	[empty string]	1000	MAGIC ANGLER FG	331491	EMPTY	EMPTY	EMPTY	0	0	0	PADDLES	[empty string]	carlisle/magic-angler-331491	1
10	[empty string]	CARLISLE	Carlisle	WATERSPORTS	Watersports>Paddles	[empty string]	1	19.99	0	19.99	94831-DEFAULT-l.jpg	19.99	94831-DEFAULT-m.jpg	VALUE CANOE PADDLE 60	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	4	15-to-20	0.00	[empty string]	VALUE PADDLE	<p>Great paddle for beginners or for use as a backup. The Value kayak paddle has symmetric polyethylene blades and a durable aluminum shaft. Ergonomic foam grips are included. The push-button take down allows blades to be feathered at 60-degrees or inline, for right- and left-hand control.</p> <p> </p> <ul> <li>Shaft Color: Black</li> <li>Activity: Recreation</li> <li>Shaft Material: Aluminum</li> <li>Blade Material: High Impact Polypropylene</li> <li>Shaft Shape: Straight</li> <li>Shaft Size: Standard</li> <li>Blade Shape: Symmetrical</li> <li>Hand Control: Right or Left</li> <li>Feather Angle: 0°</li> <li>Ferrule: Push-button</li> <li>Weight: 2.63 lb (1.191 kg)</li> </ul>	[empty string]	N	19.99	19.99	[empty string]	94831-DEFAULT-s.jpg	[empty string]	1000	VALUE PADDLE 60	368134	EMPTY	EMPTY	EMPTY	0	0	0	PADDLES	[empty string]	carlisle/value-paddle-368134	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Filter