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]	OCEAN KAYAK	Ocean Kayak	WATERSPORTS	Watersports>Accessories	[empty string]	0	4.99	0	4.99	[empty string]	4.99	[empty string]	SCUPPER STOPPER XSM 2PK	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]	5	5-AND-under	0.00	[empty string]	Scupper Stoppers - X Small - 2 Pack	<p>Scupper Stoppers can be used to plug the scupper holes in the cockpit of your Ocean Kayak. This will help you stay dry while you are paddling.</p> <p> </p> <p>NOTE: Scupper Stoppers are completely round in shape and will not fit oval-shaped scupper holes.</p>	[empty string]	N	4.99	4.99	[empty string]	[empty string]	[empty string]	1000	07.1966.0000	51963	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	ocean-kayak/scupper-stopper-xsm-2pk-51963	1
2	[empty string]	OCEAN KAYAK	Ocean Kayak	WATERSPORTS	Watersports>Accessories	[empty string]	0	4.99	0	4.99	[empty string]	4.99	[empty string]	SCUPPER STOPPER MD 2PK	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	5-AND-under	0.00	[empty string]	Scupper Stoppers - Medium - 2 Pack	<p>Scupper Stoppers can be used to plug the scupper holes in the cockpit of your Ocean Kayak. This will help you stay dry while you are paddling.</p> <p> </p> <p>NOTE: Scupper Stoppers are completely round in shape and will not fit oval-shaped scupper holes.</p>	[empty string]	N	4.99	4.99	[empty string]	[empty string]	[empty string]	1000	07.1962.0000	51992	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	ocean-kayak/scupper-stopper-md-2pk-51992	1
3	[empty string]	OCEAN KAYAK	Ocean Kayak	WATERSPORTS	Watersports>Accessories	[empty string]	0	4.99	0	4.99	[empty string]	4.99	[empty string]	SCUPPER STOPPERS LG 2PK	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]	4	5-AND-under	0.00	[empty string]	Scupper Stoppers - Large - 2 Pack	<p>Scupper Stoppers can be used to plug the scupper holes in the cockpit of your Ocean Kayak. This will help you stay dry while you are paddling.</p> <p> </p> <p>NOTE: Scupper Stoppers are completely round in shape and will not fit oval-shaped scupper holes.</p>	[empty string]	N	4.99	4.99	[empty string]	[empty string]	[empty string]	1000	07.1964.0000	51993	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	ocean-kayak/scupper-stoppers-lg-2pk-51993	1
4	[empty string]	OCEAN KAYAK	Ocean Kayak	WATERSPORTS	Watersports>Accessories	[empty string]	0	49.99	0	49.99	[empty string]	49.99	[empty string]	COMFORT PLUS BACKREST	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	ACTIVE	[empty string]	[empty string]	[empty string]	2	25-to-50	0.00	[empty string]	Comfort Plus Seat Back	<p>Extra foam padding provides the comfort and support, while the four-way adjustability provides a custom fit for almost any body type. It is made of durable, UV resistant nylon pack cloth with reinforced stays for durable seat construction. It has reflective logos that illuminate in the dark after exposure to sunlight and solid brass clips with stainless steel springs&sbquo; easy to clip on your kayak.</p> <p> </p> <p>NOTE: KAYAK NOT INCLUDED</p>	[empty string]	N	49.99	49.99	[empty string]	[empty string]	[empty string]	1000	07.2000.0238	110031	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	ocean-kayak/comfort-plus-backrest-110031	1
5	SEAGLASS,SUNRISE,LMNGRSCAMO	OCEAN KAYAK	Ocean Kayak	WATERSPORTS	Watersports>Kayaks	SEAGLASS\|NULL\|NULL,SUNRISE\|NULL\|NULL,LMNGRSCAMO\|NULL\|NULL	1	949.99	0	949.99	94751-DEFAULT-l.jpg	949.99	94751-DEFAULT-m.jpg	KAYAK TANDUM 13.4FT 68LBS CAP 500LBS	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]	6	500-or-more	0.00	[empty string]	MALIBU TWO XL - 13 FT 4 IN	<p>The stability and versatility of this all-around family fun boat in a longer craft perfect for paddlers of all sizes and abilities. The Malibu Two XL can be paddled solo or tandem, and fits two adults plus a small child or pet.</p> <p> </p> <ul> <li>Can be paddled solo or tandem</li> <li>Two Comfort Plus seat backs</li> <li>Molded-in seat wells</li> <li>Deck bungee</li> <li>Patented overlapping foot wells allow for a center seated paddler to have comfortable foot bracing</li> <li>Molded-in side carrying handles and bow/stern toggle handles</li> <li>Paddle holders located on the bow left hand side and stern right hand side of the kayak and include a pull tab for ease in releasing and attaching the bungee to the bungee button</li> <li>Screw-in drain plug</li> <li>Skid plate</li> </ul> <p> </p> <ul> <li>Material: Single Layer Polyethylene</li> <li>Length: 13 ft 3.96 in (4.1 m)</li> <li>Width: 34 in (86.4 cm)</li> <li>Total Weight Capacity: 500 lb (226.8 kg)</li> <li>Usable Weight Capacity: 430 lb (195.05 kg)</li> <li>Assembled Boat Weight: 70 lb (31.752 kg)</li> <li>Removable Seat Weight: 2 lb (0.91 kg)</li> <li>Bow Seat Width: 24 in (61 cm)</li> <li>Stern Seat Width: 24 in (61 cm)</li> <li>Center Seat Width: 18.5 in (47 cm)</li> <li>Bow Leg Length: 46 in (116.8 cm)</li> <li>Stern Leg Length: 44 in (111.8 cm)</li> </ul>	[empty string]	N	949.99	949.99	[empty string]	94751-DEFAULT-s.jpg	[empty string]	1000	MALIBU TWO XL	154645	EMPTY	EMPTY	EMPTY	0	0	0	KAYAKS	[empty string]	ocean-kayak/malibu-two-xl-13-ft-4-in-154645	1
6	LEMONCAMO	OCEAN KAYAK	Ocean Kayak	WATERSPORTS	Watersports>Kayaks	LEMONCAMO\|NULL\|NULL	0	399.99	0	399.99	[empty string]	399.99	[empty string]	KAYAK SUP 9.5FT WT 33LB CAPACITY 230LBS	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]	FALL	[empty string]	2021	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	1	350-to-400	0.00	[empty string]	Banzai - Youth - 9 Feet 6 Inches	<p><strong><span style=`font-size: medium;`>IN STORE PICK-UP ONLY</span></strong></p> <p>Designed especially for kids, the Banzai has low-profile, kid friendly features like the seat, which allows for easy movement and more mobility for small bodies. The Banzai’s innovative Tag Along Tow System lets you tow your kids when they`re too tired to paddle (though probably not too tired to splash). This playful and maneuverable kayak is perfect for kids who are just learning to paddle.</p>	[empty string]	N	399.99	399.99	[empty string]	[empty string]	[empty string]	1000	BANZAI	241916	EMPTY	EMPTY	EMPTY	0	0	0	KAYAKS	[empty string]	ocean-kayak/kayak-sup-9-5ft-wt-33lb-capacity-230lbs-241916	1
7	LMONGRASSCAMO,FUSHIA,SURF	OCEAN KAYAK	Ocean Kayak	WATERSPORTS	Watersports>Kayaks	LMONGRASSCAMO\|NULL\|NULL,FUSHIA\|NULL\|NULL,SURF\|NULL\|NULL	1	799.99	0	799.99	94754-DEFAULT-l.jpg	799.99	94754-DEFAULT-m.jpg	KAYAK 10.8FT 44LBS CAP 225LBS	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]	5	500-or-more	0.00	[empty string]	VENUS 11 - 10 FT 8 IN	<p>For every woman who doesn’t like “one size fits all,” the Venus is stable, easy-to-transport and paddles like a dream. It’s stable and suited for flat water, moderate ocean swells and waves or slow-moving rivers.</p> <p> </p> <ul> <li>Comfort Hybrid seat featuring a comfortable seat back height for additional lumbar support</li> <li>6" Cam Lock Hatch with storage bucket</li> <li>Tank well with bungee</li> <li>Molded-in cup holder and deck area mount for MP3 player</li> <li>Paddle holder located on right side of the kayak and includes a pull tab for ease in releasing and attaching the bungee to the bungee button</li> <li>Rigid center handle as part of unique car-topping handle system for easy car-topping</li> <li>Seat well designed to accommodate  female center of gravity</li> <li>Low deck profile perfect for women</li> <li>Molded-in side carrying handles and bow/stern toggle handles</li> <li>Quick seal hatch</li> </ul> <p> </p> <ul> <li>Material: Single Layer Polyethylene</li> <li>Specialty: Women's</li> <li>Length: 10 ft 8.04 in (3.3 m)</li> <li>Width: 28.5 in (72.4 cm)</li> <li>Total Weight Capacity: 225 lb (102.06 kg)</li> <li>Usable Weight Capacity: 178 lb (80.74 kg)</li> <li>Assembled Boat Weight: 47 lb (21.3192 kg)</li> <li>Removable Seat Weight: 2 lb (0.91 kg)</li> <li>Seat Width: 20 in (50.8 cm)</li> <li>Hatches: Bow, Center</li> <li>Number of Paddlers: Solo</li> <li>Propulsion: Paddle</li> </ul>	[empty string]	N	799.99	799.99	[empty string]	94754-DEFAULT-s.jpg	[empty string]	1000	VENUS 11	254201	EMPTY	EMPTY	EMPTY	0	0	0	KAYAKS	[empty string]	ocean-kayak/venus-11-10-ft-8-in-254201	1
8	BROWNCAMO	OCEAN KAYAK	Ocean Kayak	WATERSPORTS	Watersports>Kayaks	BROWNCAMO\|NULL\|NULL	1	949.99	0	949.99	92881-DEFAULT-l.jpg	949.99	92881-DEFAULT-m.jpg	KAYAK ANGLER 13.4FT 56LBS CAP 325LBS	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	500-or-more	0.00	[empty string]	PROWLER 13 ANGLER - 13 FT 4 IN	<p>This popular angler kayak combines performance with all of the features every angler needs.</p> <p> </p> <ul> <li>Comfort Plus seat</li> <li>Molded-in seat well and molded-in cup holder</li> <li>Two flush mount rod holders</li> <li>Easy to open Quick Seal bow hatch</li> <li>6" Cam Lock Hatch with storage bucket</li> <li>Oversized tank well with bungee</li> <li>Molded-in side carrying handles and bow/stern toggle handles</li> <li>Paddle holders located on both sides of the kayak and include a pull tab for ease in releasing and attaching the bungee to the bungee button</li> <li>Transducer compatible scupper</li> <li>Deck bungee and screw-in drain plug</li> <li>Skid Plate</li> </ul> <p> </p> <ul> <li>Material: Single Layer Polyethylene</li> <li>Length: 13 ft 3.96 in (4.1 m)</li> <li>Width: 28 in (71.1 cm)</li> <li>Total Weight Capacity: 325 lb (147.42 kg)</li> <li>Usable Weight Capacity: 263 lb (119.3 kg)</li> <li>Assembled Boat Weight: 62 lb (28.1232 kg)</li> <li>Removable Seat Weight: 1 lb (0.45 kg)</li> <li>Seat Width: 28 in (71.1 cm)</li> <li>Leg Length: 52 in (132.1 cm)</li> <li>Hatches: Bow, Center</li> <li>Bow Hatch: 16.5 in x 10 in (41.9 cm x 25.4 cm)</li> <li>Number of Paddlers: Solo</li> </ul>	[empty string]	N	949.99	949.99	[empty string]	92881-DEFAULT-s.jpg	[empty string]	1000	PROWLER 13 ANGLER	260352	EMPTY	EMPTY	EMPTY	0	0	0	KAYAKS	[empty string]	ocean-kayak/prowler-13-angler-13-ft-4-in-260352	1
9	LEMCAMO	OCEAN KAYAK	Ocean Kayak	WATERSPORTS	Watersports>Kayaks	LEMCAMO\|NULL\|NULL	1	599.99	0	599.99	92903-DEFAULT-l.jpg	599.99	92903-DEFAULT-m.jpg	KAYAK 9.5FT 54LBS CAP 325LBS	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	500-or-more	0.00	[empty string]	MALIBU 9.5 - 9 FT 5 IN	<p>These compact, stackable, easy-to-paddle, agile solo kayaks will turn heads as you master the waves with ease on Ocean's super-stable 9.5’ sit-on-top hull design. Comfort comes easy on the Malibu, thanks to a newly designed AirGo molded-in seat and seat pad with an adjustable AirComfort backrest. Enjoy comfortable leg room with calf rests and molded-on foot wells. And don’t forget your beverages! The Malibu 9.5 comes equipped with three cup holders.</p> <p> </p> <ul> <li>AirGo molded-in seat</li> <li>Comfortable AirGo seat pad with adjustable AirComfort backrest</li> <li>Splash-resistant QuickStash dry hatch conveniently placed between your legs</li> <li>Hull designed for stability in surf</li> <li>YakLock locking bar at the stern for secure storage</li> <li>Brightly colored tank well retention bungees</li> <li>Stackable design</li> <li>Molded-in foot wells with calf rests for added leg support</li> <li>Three molded-in cup holders</li> <li>Molded-in paddle rests</li> <li>Bow/Stern toggle handle grips and molded-in side handles</li> </ul> <p> </p> <ul> <li>Material: Single Layer Polyethylene</li> <li>Length: 9 ft 5.04 in (2.8 m)</li> <li>Width: 33 in (83.8 cm)</li> <li>Total Weight Capacity: 325 lb (147.42 kg)</li> <li>Usable Weight Capacity: 271 lb (122.93 kg)</li> <li>Assembled Boat Weight: 54 lb (24.4944 kg)</li> <li>Seat Width: 22.5 in (57.2 cm)</li> <li>Leg Length: 52 in (132.1 cm)</li> <li>Hatches: Center</li> <li>Number of Paddlers: Solo</li> <li>Propulsion: Paddle</li> </ul>	[empty string]	N	599.99	599.99	[empty string]	92903-DEFAULT-s.jpg	[empty string]	1000	MALIBU 9.5	307113	EMPTY	EMPTY	EMPTY	0	0	0	KAYAKS	[empty string]	ocean-kayak/malibu-9-5-9-ft-5-in-307113	1
10	SEAGLASS,AHI	OCEAN KAYAK	Ocean Kayak	WATERSPORTS	Watersports>Kayaks	SEAGLASS\|NULL\|NULL,AHI\|NULL\|NULL	1	699.99	0	699.99	94759-DEFAULT-l.jpg	699.99	94759-DEFAULT-m.jpg	KAYAK 11.5FT 59LBS CAP 360LBS	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]	5	500-or-more	0.00	[empty string]	MALIBU 11.5 - 11 FT 5 IN	<p>These compact, stackable, easy-to-paddle, agile solo kayaks will turn heads as you master the waves with ease on Ocean's super-stable 11.5’ sit-on-top hull design. Comfort comes easy on the Malibu, thanks to a newly designed AirGo molded-in seat and seat pad with an adjustable AirComfort backrest. Enjoy comfortable leg room with calf rests and molded-on foot wells. And don’t forget your beverages! The Malibu 9.5 comes equipped with three cup holders.</p> <p> </p> <ul> <li>AirGo molded-in seat</li> <li>Comfortable AirGo seat pad with adjustable AirComfort backrest</li> <li>Splash-resistant QuickStash dry hatch conveniently placed between your legs</li> <li>Hull designed for stability in surf</li> <li>YakLock locking bar at the stern for secure storage</li> <li>Brightly colored tank well retention bungees</li> <li>Stackable design</li> <li>Molded-in foot wells with calf rests for added leg support</li> <li>Three molded-in cup holders</li> <li>Molded-in paddle rests</li> <li>Bow/Stern toggle handle grips and molded-in side handles</li> </ul> <p> </p> <ul> <li>Material: Single Layer Polyethylene</li> <li>Length: 11 ft 5.04 in (3.5 m)</li> <li>Width: 31 in (78.7 cm)</li> <li>Total Weight Capacity: 360 lb (163.3 kg)</li> <li>Usable Weight Capacity: 299 lb (135.63 kg)</li> <li>Assembled Boat Weight: 61 lb (27.6696 kg)</li> <li>Seat Width: 22.5 in (57.2 cm)</li> <li>Leg Length: 52 in (132.1 cm)</li> <li>Hatches: Center</li> <li>Number of Paddlers: Solo</li> <li>Propulsion: Paddle</li> </ul>	[empty string]	N	699.99	699.99	[empty string]	94759-DEFAULT-s.jpg	[empty string]	1000	MALIBU 11.5	318048	EMPTY	EMPTY	EMPTY	0	0	0	KAYAKS	[empty string]	ocean-kayak/malibu-11-5-11-ft-5-in-318048	1
11	[empty string]	OCEAN KAYAK	Ocean Kayak	WATERSPORTS	Watersports>Accessories	[empty string]	0	4.99	0	4.99	[empty string]	4.99	[empty string]	SCUPPER VALVES SHORT 2 PACK	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	[empty string]	[empty string]	[empty string]	4	5-AND-under	0.00	[empty string]	Scupper Valves Short 2 Pack	[empty string]	[empty string]	N	4.99	4.99	[empty string]	[empty string]	[empty string]	1000	07.2000.0782	336569	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	ocean-kayak/scupper-valves-short-2-pack-336569	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Filter