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]	1	49.99	0	49.99	104088-DEFAULT-l.jpg	49.99	104088-DEFAULT-m.jpg	KAYAK FOLDING ANCHOR KIT	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]	3	25-to-50	0.00	[empty string]	FOLDING ANCHOR KIT	<p>Clothesline type anchor trolley system for your canoe or kayak. Allows the 1.5 lb anchor to be brought into the cockpit for easy stowage or sent out to the end of your boat and then lowered and raised. Perfect for fishing and recreational paddlers!</p>	[empty string]	N	49.99	49.99	[empty string]	104088-DEFAULT-s.jpg	[empty string]	1000	01.1331.2709	12771	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	carlisle/folding-anchor-kit-12771	1
2	[empty string]	CARLISLE	Carlisle	WATERSPORTS	Watersports>Accessories	[empty string]	1	39.99	0	39.99	104096-DEFAULT-l.jpg	39.99	104096-DEFAULT-m.jpg	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]	34	25-to-50	0.00	[empty string]	OAR LOCKS - CLAMP-ON	<p>Carlisle Clamp-On Oar Locks are an inexpensive, easy way to secure oars to your boat. The perfect oar lock for the Carlisle aluminum Economy boat oars. Molded of stainless steel-reinforced super tough black synthetic plastic - rustproof, rattle and squeak free.</p> <p> </p> <ul> <li>Sleeved to fit either 1/2" or 5/8" sockets</li> <li>2 pack</li> </ul>	[empty string]	N	39.99	39.99	[empty string]	104096-DEFAULT-s.jpg	[empty string]	1000	01.2510.0000	12864	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	carlisle/oar-locks-clamp-on-12864	1
3	[empty string]	CARLISLE	Carlisle	WATERSPORTS	Watersports>Accessories	[empty string]	1	24.99	0	24.99	104086-DEFAULT-l.jpg	24.99	104086-DEFAULT-m.jpg	OAR SOCKET KIT PLASTIC	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]	BOTH	ONLINE CLOSEOUT	PROP 65	[empty string]	[empty string]	4	20-to-25	0.00	[empty string]	OAR SOCKET KIT	<p>Two black heavy-duty engineered plastic oar sockets to hold 1/2" oar locks. Includes all hardware and easy to follow instructions.</p>	[empty string]	N	24.99	24.99	[empty string]	104086-DEFAULT-s.jpg	[empty string]	1000	01.1331.2322	117549	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	carlisle/oar-socket-kit-117549	1
4	BLACK/BLACK	CARLISLE	Carlisle	WATERSPORTS	Watersports>Paddles	BLACK/BLACK\|NULL\|NULL	1	39.99	0	39.99	94827-DEFAULT-l.jpg	39.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]	68	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	39.99	39.99	57,60,54,66,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
5	Photic,SUN,BLKCHRY,AHI,SEAGLASS,CLD/DISC	CARLISLE	Carlisle	WATERSPORTS	Watersports>Paddles	Photic\|NULL\|NULL,SUN\|NULL\|NULL,BLKCHRY\|NULL\|NULL,AHI\|NULL\|NULL,SEAGLASS\|NULL\|NULL,CLD/DISC\|NULL\|NULL	1	119.99	0	119.99	94828-DEFAULT-l.jpg	119.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]	52	100-to-150	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	119.99	119.99	230,240,220,250	94828-DEFAULT-s.jpg	[empty string]	1000	MAGIC PLUS	131856	EMPTY	EMPTY	EMPTY	0	0	0	PADDLES	[empty string]	carlisle/magic-plus-131856	1
6	SURF,Photic,DRKCHRY,AHI,SEAGLASS,SUN	CARLISLE	Carlisle	WATERSPORTS	Watersports>Paddles	SURF\|NULL\|NULL,Photic\|NULL\|NULL,DRKCHRY\|NULL\|NULL,AHI\|NULL\|NULL,SEAGLASS\|NULL\|NULL,SUN\|NULL\|NULL	1	99.99	0	99.99	94829-DEFAULT-l.jpg	99.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]	49	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	99.99	99.99	230,220,240	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
7	YELLOW	CARLISLE	Carlisle	WATERSPORTS	Watersports>Paddles	YELLOW\|NULL\|NULL	1	59.99	0	59.99	94830-DEFAULT-l.jpg	59.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]	1	50-to-100	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	59.99	59.99	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
8	OLIVE/BLK,YELLOW	CARLISLE	Carlisle	WATERSPORTS	Watersports>Paddles	OLIVE/BLK\|NULL\|NULL,YELLOW\|NULL\|NULL	1	179.99	0	179.99	104101-DEFAULT-l.jpg	179.99	104101-DEFAULT-m.jpg	EXPEDITION FIBERGLASS 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]	ONLINE CLOSEOUT	NOT ONLINE	[empty string]	[empty string]	6	150-to-200	0.00	[empty string]	EXPEDITION - FIBERGLASS	<p>You’ll always find performance and durability In this lightweight, reinforced Expedition paddle.</p>	[empty string]	N	179.99	179.99	230,220	104101-DEFAULT-s.jpg	[empty string]	1000	EXPEDITION	137993	EMPTY	EMPTY	EMPTY	0	0	0	PADDLES	[empty string]	carlisle/expedition-fiberglass-137993	1
9	[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]	4	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
10	YEL/RED,WHI/RED,GREEN/GREEN,YEL/BLU	CARLISLE	Carlisle	WATERSPORTS	Watersports>Paddles	YEL/RED\|NULL\|NULL,WHI/RED\|NULL\|NULL,GREEN/GREEN\|NULL\|NULL,YEL/BLU\|NULL\|NULL	1	39.99	0	39.99	94833-DEFAULT-l.jpg	39.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]	16	25-to-50	0.00	[empty string]	STANDARD T-GRIP CANOE PADDLE	<p>This 8" x 20" blade and fully clad aluminum shaft provide power and reduces maintenance.</p> <p> </p> <ul> <li>Activity: Recreation, Touring</li> <li>Shaft Material: Aluminum</li> <li>Blade Material: High Impact Polypropylene</li> <li>Shaft Diameter: 1.11" (2.8 cm)</li> <li>Blade Size: 20.7" x 7.75" (52.6 cm x 19.7 cm)</li> <li>Grip: T-Grip</li> <li>Length: 57"</li> <li>Weight: 29 oz (822 g)</li> </ul>	[empty string]	N	39.99	39.99	60,54,57	94833-DEFAULT-s.jpg	[empty string]	1000	STD T GRIP	307146	EMPTY	EMPTY	EMPTY	0	0	0	PADDLES	[empty string]	carlisle/standard-t-grip-canoe-paddle-307146	1
11	SUNRISE,AHI	CARLISLE	Carlisle	WATERSPORTS	Watersports>Paddles	SUNRISE\|NULL\|NULL,AHI\|NULL\|NULL	1	59.99	0	59.99	94835-DEFAULT-l.jpg	59.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]	2	50-to-100	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	59.99	59.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
12	CAMO,FIRSTLIGHT,Photic	CARLISLE	Carlisle	WATERSPORTS	Watersports>Paddles	CAMO\|NULL\|NULL,FIRSTLIGHT\|NULL\|NULL,Photic\|NULL\|NULL	1	139.99	0	139.99	94836-DEFAULT-l.jpg	139.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]	26	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	139.99	139.99	260,230,240,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

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Filter