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	49.99	0	49.99	[empty string]	49.99	[empty string]	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	MAP ONLINE	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	Folding Anchor Kit	<p>Clothesline type anchor system allows the 1.5 lb anchor to be brought into the cockpit for stowage or sent out to the end of your boat and then lowered and raised. Ideal for fishing and recreational paddlers.<br /> <br /> NOTE: KAYAK IS NOT INCLUDED</p>	[empty string]	N	49.99	49.99	[empty string]	[empty string]	[empty string]	1000	01.1331.2709	12771	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	carlisle/kayak-folding-anchor-kit-12771	1
2	[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]	STACCATO	[empty string]	[empty string]	SPRING	[empty string]	2021	[empty string]	[empty string]	ACTIVE	PROP 65	[empty string]	[empty string]	1	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
3	[empty string]	CARLISLE	Carlisle	WATERSPORTS	Watersports>Accessories	[empty string]	0	24.99	0	24.99	[empty string]	24.99	[empty string]	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	DISC	PROP 65	[empty string]	[empty string]	4	20-to-25	0.00	[empty string]	Oar Socket Kit	<p>The Oar Socket Kit holds two heavy duty engineered plastic oar sockets to hold 1/2" oar locks.<br />  </p>	[empty string]	N	24.99	24.99	[empty string]	[empty string]	[empty string]	1000	01.1331.2322	117549	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	carlisle/oar-socket-kit-plastic-117549	1
4	BLACK/BLACK	CARLISLE	Carlisle	WATERSPORTS	Watersports>Paddles	BLACK/BLACK\|NULL\|NULL	0	29.99	0	29.99	[empty string]	29.99	[empty string]	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]	2	25-to-50	0.00	[empty string]	Economy T Grip - Black	<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>	[empty string]	N	29.99	29.99	54	[empty string]	[empty string]	1000	ECONOMY T GRIP	131839	EMPTY	EMPTY	EMPTY	0	0	0	PADDLES	[empty string]	carlisle/canoe-t-grip-paddle-131839	1
5	CLD/DISC,BLKCHRY,AHI,PHOTIC	CARLISLE	Carlisle	WATERSPORTS	Watersports>Paddles	CLD/DISC\|NULL\|NULL,BLKCHRY\|NULL\|NULL,AHI\|NULL\|NULL,PHOTIC\|NULL\|NULL	0	99.99	0	99.99	[empty string]	99.99	[empty string]	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	ONLINE	[empty string]	[empty string]	11	50-to-100	0.00	[empty string]	Magic Plus	<p>The efficient and powerful blade design makes this paddle ideal for touring. The 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>	[empty string]	N	99.99	99.99	220,240,230	[empty string]	[empty string]	1000	MAGIC PLUS	131856	EMPTY	EMPTY	EMPTY	0	0	0	PADDLES	[empty string]	carlisle/kayak-paddle-glass-shaft-131856	1
6	AHI,SUN,PHOTIC,SEAGLASS	CARLISLE	Carlisle	WATERSPORTS	Watersports>Paddles	AHI\|NULL\|NULL,SUN\|NULL\|NULL,PHOTIC\|NULL\|NULL,SEAGLASS\|NULL\|NULL	0	79.99	1	69.99	[empty string]	79.99	[empty string]	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]	17	50-to-100	0.00	[empty string]	Magic Mystic	<p>This recreational paddle is created with a durable aluminum shaft that makes the Magic Mystic Paddle a reliable introductory paddle. Fiberglass reinforced polypropylene blades are efficiently designed and offer impressive power when on the water.<br />  </p>	[empty string]	N	69.99	79.99	220,230,240	[empty string]	[empty string]	1000	MAGIC MYSTIC ALUMINUM	131857	EMPTY	EMPTY	EMPTY	0	0	0	PADDLES	[empty string]	carlisle/kayak-paddle-poly-aluminum-shaft-131857	1
7	NATURAL	CARLISLE	Carlisle	WATERSPORTS	Watersports>Paddles	NATURAL\|NULL\|NULL	0	32.99	1	29.99	[empty string]	32.99	[empty string]	CANOE PADDLE WOOD	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	25-to-50	0.00	[empty string]	Ausable	<p>This durable, laminated paddle is utility grade but inexpensive, making it an excellent beginner paddle or spare. The 36" and 42" are perfect for kids.</p>	[empty string]	N	29.99	32.99	42,60	[empty string]	[empty string]	1000	AUSABLE	131861	EMPTY	EMPTY	EMPTY	0	0	0	PADDLES	[empty string]	carlisle/canoe-paddle-wood-131861	1
8	SILVER	CARLISLE	Carlisle	WATERSPORTS	Watersports>Paddles	SILVER\|NULL\|NULL	0	49.99	0	49.99	[empty string]	49.99	[empty string]	BOAT OAR ALUMINUM	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	ONLINE	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	Economy Oar	<p>The Carlisle Economy Oar is a lightweight oar at an excellent price. Features a lightweight aluminum shaft that runs the full length of the blade to ensure maximum strength and durability. The 5.5" x 26" blade delivers superior power and a contoured handle makes maneuvering easy.<br />  </p>	[empty string]	N	49.99	49.99	6	[empty string]	[empty string]	1000	ECONOMY OAR	131889	EMPTY	EMPTY	EMPTY	0	0	0	PADDLES	[empty string]	carlisle/boat-oar-aluminum-131889	1
9	OLIVE/BLK,YELLOW	CARLISLE	Carlisle	WATERSPORTS	Watersports>Paddles	OLIVE/BLK\|NULL\|NULL,YELLOW\|NULL\|NULL	0	179.99	0	179.99	[empty string]	179.99	[empty string]	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]	DISC	NOT ONLINE	[empty string]	[empty string]	15	150-to-200	0.00	[empty string]	Expedition	Designed for day touring or for long distance paddling. Expedition`s fiberglass transparent paddle is the perfect partner on your next kayak expedition. Durable yet extremely lightweight, it is also easy on the arms. A push-button takedown allows blades to be feathered at 60-degrees or set inline.<br/> <br> <br> <br> <i><font size=1> Note: While every effort is made to include accurate and correct images, descriptions, specifications and pricing for each product, they are shown for example only and do not necessarily represent the product in its entirety. Inadvertent errors may occur. Jay`s Sporting Goods reserves the right to modify or change product information and pricing without notice. If you have a question about an item, please call or email us for more information before ordering.</font></i>	[empty string]	N	179.99	179.99	230,220,240	[empty string]	[empty string]	1000	EXPEDITION	137993	EMPTY	EMPTY	EMPTY	0	0	0	PADDLES	[empty string]	carlisle/expedition-fiberglass-paddle-137993	1
10	BLACK	CARLISLE	Carlisle	WATERSPORTS	Watersports>Paddles	BLACK\|NULL\|NULL	0	99.99	0	99.99	[empty string]	99.99	[empty string]	PADDLEBOARD/KAYAK 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	ONLINE	[empty string]	[empty string]	1	50-to-100	0.00	[empty string]	Taboo - Stand Up / Kayak Paddle	<p>Designed to be a versatile two in one paddle. The Taboo paddle lets you paddle your stand up board, but easily converts to a kayak paddle too. This versatile two-in-one paddle includes two T-grip handles which let you adjust the length based on your height. It also features a second blade which allows you to easily convert the stand up paddle into a 230 cm kayak paddle. Stand up or sit down and paddle, the Taboo SUP paddle helps you do both.</p>	[empty string]	N	99.99	99.99	[empty string]	[empty string]	[empty string]	1000	TABOO SUP	149044	EMPTY	EMPTY	EMPTY	0	0	0	PADDLES	[empty string]	carlisle/paddleboard-kayak-paddle-149044	1
11	LEMONGRASS,BLUE	CARLISLE	Carlisle	WATERSPORTS	Watersports>Paddles	LEMONGRASS\|NULL\|NULL,BLUE\|NULL\|NULL	0	109.99	0	109.99	[empty string]	109.99	[empty string]	KAYAK PADDLE FIBERGLASS	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]	DISC	ONLINE	[empty string]	[empty string]	3	100-to-150	0.00	[empty string]	Next Plus	<p>Fiberglass reinforced polypropylene blades of the Next paddle are lightweight and durable. The asymmetrical, slightly curved blade shape combined with a lightweight, flexible fiberglass shaft produces smooth yet powerful strokes.</p>	[empty string]	N	109.99	109.99	220,230	[empty string]	[empty string]	1000	NEXT PLUS	241885	EMPTY	EMPTY	EMPTY	0	0	0	PADDLES	[empty string]	carlisle/kayak-paddle-fiberglass-241885	1
12	PHOTIC,FIRSTLIGHT	CARLISLE	Carlisle	WATERSPORTS	Watersports>Paddles	PHOTIC\|NULL\|NULL,FIRSTLIGHT\|NULL\|NULL	0	119.99	0	119.99	[empty string]	119.99	[empty string]	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]	10	100-to-150	0.00	[empty string]	Kayak Paddle Angler Glass Shaft	[empty string]	[empty string]	N	119.99	119.99	240,260,230,250	[empty string]	[empty string]	1000	MAGIC ANGLER FG	331491	EMPTY	EMPTY	EMPTY	0	0	0	PADDLES	[empty string]	carlisle/kayak-paddle-angler-glass-shaft-331491	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Size

220
230
240
250
260
36
42
48
54
57
6
6.5
60
66
7
72

Filter