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	BLUE,AQUA,GREEN	HURRICANE KAYAKS	Hurricane Kayaks	WATERSPORTS	Watersports>Kayaks	BLUE\|NULL\|NULL,AQUA\|NULL\|NULL,GREEN\|NULL\|NULL	1	1299	0	1299	104972-DEFAULT-l.jpg	1299	104972-DEFAULT-m.jpg	KAYAK 11.5FT 42LBS CAP 300#	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]	2023	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	4	500-or-more	0.00	[empty string]	SKIMMER 116 - 11 FEET 6 INCH	<p>The Skimmer 116 is 11-feet 6-inches of paddling perfection. Super stable, super sleek and super easy on the eyes, the Skimmer 116 is just the right combination of length, width, and weight (42 lbs) for a nice and easy day on the water.</p> <p> </p> <ul> <li>Scuppers: 1 5/8-inch scuppers drain footwell & rear wells</li> <li>Hatches, 5.5” center & 8″ bow: storage compartment access</li> <li>Rear well bungee: deck storage for dry bag & gear</li> <li>Paddle holder secures paddle to deck</li> <li>Console provides ample space for geartrack mounting</li> <li>Outfitting: airestream seatback and skimmer cushpad</li> <li>Sealect designs footbrace system for easy adjust pinch & pull</li> <li>Molded grab handles on bow, stern and sides for comfortable grip when carrying kayak during portage</li> </ul> <p> </p> <ul> <li>Weight: 42 lbs</li> <li>Length: 11' 6"</li> <li>Width: 30.5"</li> <li>Capacity: 300 lbs</li> </ul>	[empty string]	N	1299	1299	[empty string]	104972-DEFAULT-s.jpg	[empty string]	1000	SKIMMER 116	172378	EMPTY	EMPTY	EMPTY	0	0	0	KAYAKS	[empty string]	hurricane-kayaks/skimmer-116-11-feet-6-inch-172378	1
2	MANGO,GREEN,BLUE	HURRICANE KAYAKS	Hurricane Kayaks	WATERSPORTS	Watersports>Kayaks	MANGO\|NULL\|NULL,GREEN\|NULL\|NULL,BLUE\|NULL\|NULL	1	1249.99	0	1249.99	104964-DEFAULT-l.jpg	1249.99	104964-DEFAULT-m.jpg	KAYAK 11.6FT 36.5LBS CAP 300LBS	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]	3	500-or-more	0.00	[empty string]	SANTEE 116 SPORT - 11 FEET 6 INCH	<p>Ever wonder why the Santee 116 Sport is Hurricane's best selling kayak? It probably has something to do with its super-stable, excellent tracking Swede form hull. Or maybe it's the oversized Sport cockpit and comfy Airestream seat.</p> <p> </p> <ul> <li><span style="font-size:11pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Times New Roman",serif">Bow and stern bulkheads, abs plastic for flotation & storage</span></span></span></span></li> <li><span style="font-size:11pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Times New Roman",serif">10” hinge hatch for storage compartment access</span></span></span></span></li> <li><span style="font-size:11pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Times New Roman",serif">Stern deck bungee for dry bag & gear</span></span></span></span></li> <li><span style="font-size:11pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Times New Roman",serif">Paddle holder secures paddle to deck</span></span></span></span></li> <li><span style="font-size:11pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Times New Roman",serif">Security bar cable lock your boat to the car or in storage</span></span></span></span></li> <li><span style="font-size:11pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Times New Roman",serif">Outfitting: Airestream seat and foam thigh pads</span></span></span></span></li> <li><span style="font-size:11pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Times New Roman",serif">Footbrace system with sealect designs pinch & pull</span></span></span></span></li> <li><span style="font-size:11pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Times New Roman",serif">Molded grab handles, bow & stern for comfortable grip when carrying kayak during portage</span></span></span></span></li> <li><span style="font-size:11pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Times New Roman",serif">55” xl cockpit for easy entry & exit, accommodates small child or pet</span></span></span></span></li> <li><span style="font-size:11pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Times New Roman",serif">Optional: Sport console</span></span></span></span></li> </ul> <p> </p> <ul> <li>Weight: 36.5 lbs</li> <li>Length: 11' 6"</li> <li>Width: 28"</li> <li>Cockpit: 55" x 24"</li> <li>Capacity: 300 lbs</li> </ul>	[empty string]	N	1249.99	1249.99	[empty string]	104964-DEFAULT-s.jpg	[empty string]	1000	SANTEE 116 SPORT	262838	EMPTY	EMPTY	EMPTY	0	0	0	KAYAKS	[empty string]	hurricane-kayaks/santee-116-sport-11-feet-6-inch-262838	1
3	MANGO,BLUE,AQUA,GREEN	HURRICANE KAYAKS	Hurricane Kayaks	WATERSPORTS	Watersports>Kayaks	MANGO\|NULL\|NULL,BLUE\|NULL\|NULL,AQUA\|NULL\|NULL,GREEN\|NULL\|NULL	1	1349.99	0	1349.99	104966-DEFAULT-l.jpg	1349.99	104966-DEFAULT-m.jpg	KAYAK 12.5FT 39LBS CAPACITY 350LBS	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]	4	500-or-more	0.00	[empty string]	SANTEE 126 SPORT - 12 FEET 6 INCH	<p>So you want a lightweight kayak that holds course when you're in the straightaway but will carve and edge when you throw it a little lean? Then the multi-chined hull on the Santee 126 is the boat for you.</p> <p> </p> <ul> <li>Bulkheads, abs plastic, bow & stern provides positive flotation</li> <li>Hatches: 10” stern provides storage compartment access</li> <li>Deck bungee rigging, bow & stern provides storage for dry bag & gear</li> <li>Paddle holder secures paddle to deck</li> <li>Security bar to cable lock your boat to the car or in storage</li> <li>Outfitting: airestream seat and foam thigh pads</li> <li>Footbrace system: sealect designs pinch & pull</li> <li>Luggage grab handle, bow & stern for comfortable grip when carrying kayak during portage</li> </ul> <p> </p> <ul> <li>Weight: 40 lbs</li> <li>Length: 12' 6"</li> <li>Width: 28"</li> <li>Cockpit: 43" x 20.5"</li> <li>Capacity: 350 lbs</li> </ul>	[empty string]	N	1349.99	1349.99	[empty string]	104966-DEFAULT-s.jpg	[empty string]	1000	SANTEE 126 SPORT	262839	EMPTY	EMPTY	EMPTY	0	0	0	KAYAKS	[empty string]	hurricane-kayaks/santee-126-sport-12-feet-6-inch-262839	1
4	MANGO,WASABI,BLUE	HURRICANE KAYAKS	Hurricane Kayaks	WATERSPORTS	Watersports>Kayaks	MANGO\|NULL\|NULL,WASABI\|NULL\|NULL,BLUE\|NULL\|NULL	1	1249	0	1249	104967-DEFAULT-l.jpg	1249	104967-DEFAULT-m.jpg	KAYAK 10.6FT 39LBS CAP 315LBS	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]	2022	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	3	500-or-more	0.00	[empty string]	SKIMMER 106 - 10 FEET 6 INCH	<p>The newest member of Hurricane's Skimmer family, the Skimmer 106 is a wide, stable, and easy to load kayak on your vehicle. Coming in at a mere 39 lbs, this 10-foot 6-inch craft is easy to love, easy to paddle, and even easier to tote around.</p> <p> </p> <ul> <li>Scuppers: 1 5/8-inch scuppers drain footwell & rear wells</li> <li>Hatches, 5.5” center & 10" bow hinge hatch for storage compartment access</li> <li>Rear well bungee for deck storage for dry bag & gear</li> <li>Paddle holder secures paddle to deck</li> <li>Outfitting: skimmer cushpad and airestream seat back</li> <li>Sealect designs footbrace system for easy adjust pinch & pull</li> <li>Molded grab handles on bow, stern and sides for comfortable grip when carrying kayak during portage</li> <li>Stern drain plug for simple hull drainage</li> </ul> <p> </p> <ul> <li>Weight: 39 lbs</li> <li>Length: 10' 6"</li> <li>Width: 32"</li> <li>Capacity: 315 lbs</li> </ul>	[empty string]	N	1249	1249	[empty string]	104967-DEFAULT-s.jpg	[empty string]	1000	SKIMMER 106	327451	EMPTY	EMPTY	EMPTY	0	0	0	KAYAKS	[empty string]	hurricane-kayaks/skimmer-106-10-feet-6-inch-327451	1
5	AQUA,WASABI,BLUE	HURRICANE KAYAKS	Hurricane Kayaks	WATERSPORTS	Watersports>Kayaks	AQUA\|NULL\|NULL,WASABI\|NULL\|NULL,BLUE\|NULL\|NULL	1	1499	0	1499	104959-DEFAULT-l.jpg	1499	104959-DEFAULT-m.jpg	KAYAK 12.6FT 45LBS CAP 375LBS	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]	2022	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	4	500-or-more	0.00	[empty string]	PRIMA 125 SPORT - 12 FEET 5 INCH	<p>The Prima 125 Sport is the head of the 12-foot recreational class. It features a multi-chined hull, roomy Sport cockpit, fore and aft ABS bulkheads, removable frame seat, and large versatile stern hatch. Best of all, at only 45 lbs (40 with the seat removed), the Prima 125 Sport is easy to carry and easy to load.</p> <p> </p> <ul> <li><span style="font-size:11pt"><span style="font-family:Calibri,sans-serif">Bulkheads, abs plastic, bow & stern provide positive flotation</span></span></li> <li><span style="font-size:11pt"><span style="font-family:Calibri,sans-serif">Large versatile stern hatch provides storage</span></span></li> <li><span style="font-size:11pt"><span style="font-family:Calibri,sans-serif">Deck bungee rigging, bow & stern provides storage for dry bag & gear track to quickly add accessories</span></span></li> <li><span style="font-size:11pt"><span style="font-family:Calibri,sans-serif">1st class frame seat and foam thigh pads</span></span></li> <li><span style="font-size:11pt"><span style="font-family:Calibri,sans-serif">Footbrace system molded grab handles, bow & stern makes comfortable grip when carrying kayak during portage</span></span></li> <li><span style="font-size:11pt"><span style="font-family:Calibri,sans-serif">Prima 125 seat features a removable frame seat with fore/aft adjustment</span></span></li> <li><span style="font-size:11pt"><span style="font-family:Calibri,sans-serif">Seat removed reduces the weight by 4 lbs</span></span></li> </ul> <p> </p> <ul> <li>Weight: 40 lbs</li> <li>Length: 12' 5"</li> <li>Width: 29"</li> <li>Cockpit: 55" x 24"</li> <li>Capacity: 375 lbs</li> </ul>	[empty string]	N	1499	1499	[empty string]	104959-DEFAULT-s.jpg	[empty string]	1000	PRIMA 125 SPORT	343717	EMPTY	EMPTY	EMPTY	0	0	0	KAYAKS	[empty string]	hurricane-kayaks/prima-125-sport-12-feet-5-inch-343717	1
6	MANGO,WASABI	HURRICANE KAYAKS	Hurricane Kayaks	WATERSPORTS	Watersports>Kayaks	MANGO\|NULL\|NULL,WASABI\|NULL\|NULL	1	1499.99	0	1499.99	104955-DEFAULT-l.jpg	1499.99	104955-DEFAULT-m.jpg	KAYAK 12.2FT 43LBS CAP 325LBS	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]	2023	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	2	500-or-more	0.00	[empty string]	OSPREY 120 - 12 FEET 2 INCH	<p>The Hurricane Osprey 120 has an innovative hull shape that offers excellent efficiency along with superior tracking and stability. This "Relax" hull is tuned to maximize your day on the water no matter whether it's your first kayak outing or you're practically a pro. With a premium open floor plan that features a large rear well and bow deck K-9 Comfort Pad, the Osprey 120 has space for all your gear and your dog too. It also features an elevated seat system with CamLock Security knobs that keeps the seat firmly in place for extended paddling comfort. Hurricane's First Class Seat seamlessly integrates with this system, placing you at a higher paddling point that allows you to stalk your prey (be it fish or just a fun day on the water) with confidence and security.</p> <p> </p> <ul> <li><span style="font-size:11pt"><span style="font-family:Calibri,sans-serif">"Relax" hull design</span></span></li> <li><span style="font-size:11pt"><span style="font-family:Calibri,sans-serif">Elevated frame seat system with camlock security knobs</span></span></li> <li><span style="font-size:11pt"><span style="font-family:Calibri,sans-serif">K-9 bow pad</span></span></li> <li><span style="font-size:11pt"><span style="font-family:Calibri,sans-serif">Premium open floor plan with footwell pads</span></span></li> <li><span style="font-size:11pt"><span style="font-family:Calibri,sans-serif">Reinforced center scuppers</span></span></li> <li><span style="font-size:11pt"><span style="font-family:Calibri,sans-serif">Gasketed h-pod</span></span></li> <li><span style="font-size:11pt"><span style="font-family:Calibri,sans-serif">4" gear track for go-pro or other accessories</span></span></li> <li><span style="font-size:11pt"><span style="font-family:Calibri,sans-serif">Large stern tankwell with bungee</span></span></li> </ul> <p> </p> <ul> <li><span style="font-size:11pt"><span style="font-family:Calibri,sans-serif">Weight: 43 lbs</span></span></li> <li><span style="font-size:11pt"><span style="font-family:Calibri,sans-serif">Length: 12' 2"</span></span></li> <li><span style="font-size:11pt"><span style="font-family:Calibri,sans-serif">Width: 31.5"</span></span></li> <li><span style="font-size:11pt"><span style="font-family:Calibri,sans-serif">Capacity: 325 lbs</span></span></li> <li><span style="font-size:11pt"><span style="font-family:Calibri,sans-serif">Outfitting: 1st Class Frame</span></span></li> </ul>	[empty string]	N	1499.99	1499.99	[empty string]	104955-DEFAULT-s.jpg	[empty string]	1000	OSPREY 120	380566	EMPTY	EMPTY	EMPTY	0	0	0	KAYAKS	[empty string]	hurricane-kayaks/osprey-120-12-feet-2-inch-380566	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Filter