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	MANGO,BREEZE,GALAXY,MIDNIGHT	WILDERNESS SYSTEMS	Wilderness Systems	WATERSPORTS	Watersports>Kayaks	MANGO\|NULL\|NULL,BREEZE\|NULL\|NULL,GALAXY\|NULL\|NULL,MIDNIGHT\|NULL\|NULL	1	1059.99	0	1059.99	94769-DEFAULT-l.jpg	1059.99	94769-DEFAULT-m.jpg	KAYAK 10.5 48LB CAPACITY 400LBS	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	PROP 65	[empty string]	[empty string]	6	500-or-more	0.00	[empty string]	ASPIRE 105 - 10 FEET 6 INCH	<p>The Aspire is a high-performance sit-inside recreational kayak with endless possibilities. Designed for the beginner to intermediate paddler looking to expand beyond flat-water, the versatile Aspire combines easy handling and maneuverability with unsurpassed stability and features the TruTrak Adjustable Skeg System for straight tracking on longer pursuits. Industry-leading Phase 3® AirPro seat outfitting provides ultimate comfort, adjustability and breathability.</p> <p> </p> <ul> <li>Easily replaceable skid plate lets you drag without fear of damage</li> <li>TruTrak Skeg with cockpit control to stay on course in current and wind</li> <li>Stern bulkhead foam adds extra buoyancy on the water</li> <li>Dry storage hatch keeps your gear safe and dry</li> <li>Fully adjustable, mesh fabric covers honeycomb-vented kayak seat with ergonomic 3D foam allowing for greater airflow to keep you cool while supporting the lower back</li> <li>Thigh and knee padding for comfortable support and optimal boat control</li> <li>Molded-in dashboard keeps smaller gear close for easy access</li> <li>Large, padded foot rests for support and comfort. Easy to adjust locking lever to accommodate paddlers of different heights</li> <li>Bungee cord lashes in front and rear to secure gear of any shape or size</li> <li>Ergonomic handles make carrying more comfortable</li> </ul> <p> </p> <ul> <li>Length: 10' 6"</li> <li>Width: 29"</li> <li>Boat Weight: 48 lbs</li> <li>Deck Height: 15.5"</li> <li>Cockpit Length: 51.5"</li> <li>Cockpit Width: 23.5"</li> <li>Max Capacity: 400 lbs</li> </ul>	[empty string]	N	1059.99	1059.99	[empty string]	94769-DEFAULT-s.jpg	[empty string]	1000	ASPIRE 105	156104	EMPTY	EMPTY	EMPTY	0	0	0	KAYAKS	[empty string]	wilderness-systems/aspire-105-10-feet-6-inch-156104	1
2	MANGO,GALAXY	WILDERNESS SYSTEMS	Wilderness Systems	WATERSPORTS	Watersports>Kayaks	MANGO\|NULL\|NULL,GALAXY\|NULL\|NULL	1	1119.99	0	1119.99	94770-DEFAULT-l.jpg	1119.99	94770-DEFAULT-m.jpg	KAYAK 10.5 48LBS CAPACITY 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	PROP 65	[empty string]	[empty string]	3	500-or-more	0.00	[empty string]	PUNGO 105 - 10 FEET 6 INCH	<p>Blending celebrated legacy design elements with a re-imagined modern flair, the updated Pungo delivers a dynamic on-water performance with superior stability, unmatched speed, premium comfort and intelligent outfitting. The renowned Pungo hull<strong>, </strong>through rigorous engineering and testing, has reassuring stability without sacrificing performance. Best-in-class speed makes the Pungo the easiest to paddle and most efficient kayak in its class, taking you farther and faster than you ever thought you could.</p> <p> </p> <ul> <li>Rigid carry handles make carrying more comfortable</li> <li>Versatile bungee deck rigging can be adjusted by paddler to store gear of different sizes</li> <li>Removable drybox for storage</li> <li>2 cupholders for your favorite beverages</li> <li>Recess designed for the Wilderness Systems battery to keep electronics charged</li> <li>Customize and easily add accessories with Slidetrax TM and open mounting surfaces</li> <li>Easily adjustable footbrace system for all size of paddlers</li> <li>Durable padding provides a place to rest your legs for all-day comfort</li> <li>Fully adjustable seat means a comfortable fit for paddlers of different sizes</li> <li>Mesh fabric covers honeycomb-vented, ergonomic 3D foam allowing for greater airflow to keep you cool while supporting the lower back</li> <li>Store extra gear or your water bottle with the bungee cord rigging</li> <li>Room to keep plenty of gear and valuables safe and dry in the stern of your kayak</li> <li>Makes transport easy and protects the hull from wear and tear</li> </ul> <p> </p> <ul> <li>Length: 10' 6"</li> <li>Width: 30"</li> <li>Boat Weight: 47 lbs</li> <li>Cockpit Length: 56"</li> <li>Cockpit Width: 22"</li> <li>Max Capacity: 300 lbs</li> </ul>	[empty string]	N	1119.99	1119.99	[empty string]	94770-DEFAULT-s.jpg	[empty string]	1000	PUNGO 105	309618	EMPTY	EMPTY	EMPTY	0	0	0	KAYAKS	[empty string]	wilderness-systems/pungo-105-10-feet-6-inch-309618	1
3	MANGO	WILDERNESS SYSTEMS	Wilderness Systems	WATERSPORTS	Watersports>Kayaks	MANGO\|NULL\|NULL	1	1119.99	0	1119.99	94772-DEFAULT-l.jpg	1119.99	94772-DEFAULT-m.jpg	KAYAK SOT 10.5FT 55LBS CAPACITY 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]	2022	[empty string]	[empty string]	ACTIVE	PROP 65	[empty string]	[empty string]	4	500-or-more	0.00	[empty string]	TARPON 105 - 10 FEET 6 INCH	<p>The Tarpon retains everything paddlers love from the celebrated original with improved comfort, stability, speed and paddler interface, the Tarpon is easily the most versatile boat in the Wilderness Systems lineup that is equally at home on rivers, lakes or oceans. Every detail is carefully crafted and executed flawlessly to bring you boundless paddling perfection.</p> <p> </p> <ul> <li>Fast, efficient and straight tracking</li> <li>Excellent stability - great initial stability and solid secondary stability when the boat is leaned on edge</li> <li>Dog-friendly - bring Fido along for the ride</li> <li>Comfortable and adjustable Phase 3® AirPro seating system featurs CoolTouch so your seat stays cool</li> <li>Large rear storage well for crates, coolers, fishing equipment, scuba tanks & camping gear</li> <li>Front storage hatch offers dry storage</li> <li>Mesh cover for rear storage area to secure items - can be rolled back</li> <li>Sectioned storage tray to organize smaller items like sunscreen, fishing lures and snacks</li> <li>User-friendly paddler interface - new features including a water bottle strap and dry box are all within easy reach</li> <li>MagnaTec magnetic water bottle strap system</li> <li>DryTec removable dry box is perfect for storing wallets, phones, keys and other valuables</li> <li>SlideTrax accessory rails so you can customize your kayak for fishing, filming or adding other accessories</li> <li>Quick park paddle holder</li> <li>Rigid carry handles for easy transport</li> </ul> <p> </p> <ul> <li>Length: 10' 6"</li> <li>Width: 32"</li> <li>Boat Weight: 55 lbs</li> <li>Deck Height: 15.25"</li> <li>Max Capacity: 325 lbs</li> </ul>	[empty string]	N	1119.99	1119.99	[empty string]	94772-DEFAULT-s.jpg	[empty string]	1000	TARPON 105	331615	EMPTY	EMPTY	EMPTY	0	0	0	KAYAKS	[empty string]	wilderness-systems/tarpon-105-10-feet-6-inch-331615	1
4	GALAXY	WILDERNESS SYSTEMS	Wilderness Systems	WATERSPORTS	Watersports>Kayaks	GALAXY\|NULL\|NULL	1	1229.99	0	1229.99	94773-DEFAULT-l.jpg	1229.99	94773-DEFAULT-m.jpg	KAYAK TARPON 12FT	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]	2	500-or-more	0.00	[empty string]	TARPON 120 - 12 FEET 3 INCH	<p>The Tarpon retains everything paddlers love from the celebrated original with improved comfort, stability, speed and paddler interface, the Tarpon is easily the most versatile boat in the Wilderness Systems lineup that is equally at home on rivers, lakes or oceans. Every detail is carefully crafted and executed flawlessly to bring you boundless paddling perfection.</p> <p> </p> <ul> <li>Fast, efficient and straight tracking</li> <li>Excellent stability - great initial stability and solid secondary stability when the boat is leaned on edge</li> <li>Dog-friendly - bring Fido along for the ride</li> <li>Comfortable and adjustable Phase 3 AirPro seating system featurs CoolTouch so your seat stays cool</li> <li>Large rear storage well for crates, coolers, fishing equipment, scuba tanks & camping gear</li> <li>Front storage hatch offers dry storage</li> <li>Mesh cover for rear storage area to secure items - can be rolled back</li> <li>Sectioned storage tray to organize smaller items like sunscreen, fishing lures and snacks</li> <li>User-friendly paddler interface - new features including a water bottle strap and dry box are all within easy reach</li> <li>MagnaTec magnetic water bottle strap system</li> <li>DryTec removable dry box is perfect for storing wallets, phones, keys and other valuables</li> <li>SlideTrax accessory rails so you can customize your kayak for fishing, filming or adding other accessories</li> <li>Quick park paddle holder</li> <li>Rigid carry handles for easy transport</li> </ul> <p> </p> <ul> <li>Length: 12' 3"</li> <li>Width: 31"</li> <li>Boat Weight: 63 lbs</li> <li>Deck Height: 13.75"</li> <li>Max Capacity: 350 lbs</li> </ul>	[empty string]	N	1229.99	1229.99	[empty string]	94773-DEFAULT-s.jpg	[empty string]	1000	TARPON 120	343180	EMPTY	EMPTY	EMPTY	0	0	0	KAYAKS	[empty string]	wilderness-systems/tarpon-120-12-feet-3-inch-343180	1
5	BREEZE,FOSSIL,MANGO,GALAXY	WILDERNESS SYSTEMS	Wilderness Systems	WATERSPORTS	Watersports>Kayaks	BREEZE\|NULL\|NULL,FOSSIL\|NULL\|NULL,MANGO\|NULL\|NULL,GALAXY\|NULL\|NULL	1	1219.99	0	1219.99	94771-DEFAULT-l.jpg	1219.99	94771-DEFAULT-m.jpg	KAYAK PUNGO 12.5FT	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]	PUNGO 125 - 12 FEET 6 INCH	<p>Blending celebrated legacy design elements with a re-imagined modern flair, the updated Pungo delivers a dynamic on-water performance with superior stability, unmatched speed, premium comfort and intelligent outfitting. The renowned Pungo hull<strong>, </strong>through rigorous engineering and testing, has reassuring stability without sacrificing performance. Best-in-class speed makes the Pungo the easiest to paddle and most efficient kayak in its class, taking you farther and faster than you ever thought you could.</p> <p> </p> <ul> <li>Rigid carry handles make carrying more comfortable</li> <li>Versatile bungee deck rigging can be adjusted by paddler to store gear of different sizes</li> <li>Removable drybox for storage</li> <li>2 cupholders for your favorite beverages</li> <li>Recess designed for the Wilderness Systems battery to keep electronics charged</li> <li>Customize and easily add accessories with Slidetrax TM and open mounting surfaces</li> <li>Easily adjustable footbrace system for all size of paddlers</li> <li>Durable padding provides a place to rest your legs for all-day comfort</li> <li>Fully adjustable seat means a comfortable fit for paddlers of different sizes</li> <li>Mesh fabric covers honeycomb-vented, ergonomic 3D foam allowing for greater airflow to keep you cool while supporting the lower back</li> <li>Store extra gear or your water bottle with the bungee cord rigging</li> <li>Room to keep plenty of gear and valuables safe and dry in the stern of your kayak</li> <li>Makes transport easy and protects the hull from wear and tear</li> </ul> <p> </p> <ul> <li>Length: 12' 6"</li> <li>Width: 29.5"</li> <li>Boat Weight: 53 lbs</li> <li>Cockpit Length: 57.75"</li> <li>Cockpit Width: 22.5"</li> <li>Max Capacity: 375 lbs</li> </ul>	[empty string]	N	1219.99	1219.99	[empty string]	94771-DEFAULT-s.jpg	[empty string]	1000	PUNGO 125	343182	EMPTY	EMPTY	EMPTY	0	0	0	KAYAKS	[empty string]	wilderness-systems/pungo-125-12-feet-6-inch-343182	1
6	MESACAMO,MIDNIGHT,STEEL	WILDERNESS SYSTEMS	Wilderness Systems	WATERSPORTS	Watersports>Kayaks	MESACAMO\|NULL\|NULL,MIDNIGHT\|NULL\|NULL,STEEL\|NULL\|NULL	1	2819.99	0	2819.99	94774-DEFAULT-l.jpg	2819.99	94774-DEFAULT-m.jpg	KAYAK 12FT2IN 115LBS 450LB CAPACITY	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]	5	500-or-more	0.00	[empty string]	RECON 120 HD - 12 FEET 2 INCH	<p>A confidence-inspiring fishing machine for both the novice and expert, the Recon is a factory-loaded boat that you can rig your way. With a fully customizable open platform, a lineup of revolutionary features, and the freedom to choose the preferred mode of propulsion – paddle, pedal, or power – the Recon series of kayaks are the future of fishability.</p> <p> </p> <ul> <li>Fully customizable open platform, factory-loaded with room for personalized rigging</li> <li>Helix PD Pedal Drive system included</li> <li>Supremely wide-open deck affords the angler an abundance of space, freedom of motion, and provides a rock-solid platform from which to stand, cast, and hookset in confidence</li> <li>Tri-power optimized with the freedom to choose the preferred mode of propulsion – paddle, pedal, or power</li> <li>S.M.A.R.T. Hull Technology – Wilderness Systems' signature design approach that carefully and masterfully combines Stability, Maneuverability, Acceleration, Responsiveness, and Tracking to deliver the ultimate performance in all waters</li> <li>StowPro Storage System featuring an extra-large gasketed hatch and a thoughtfully configured bin to access, organize and defend gear</li> <li>AirPro ACE seat – embodying easy Adjustability, luxurious Comfort, and fine-tuned Ergonomics, featuring premium, breathable materials and a one-handed mechanical lever for quick adjusting the seat trim on-the-fly, allowing anglers to dial in their position for paddling, pedaling, motoring, or to make room for fishing</li> <li>Dual Rod Troughs – a unique horizontal rod storage solution to keep rods close-at-hand and away from wind and breakage; can hold up to three 7'6" rods on each side; secured with cross-lashing bungee; noise-dampened by Silent Traction pads</li> <li>Midship side pockets and tackle box recesses provide gear storage in all the right places</li> <li>Convenient cup holders to keep beverages close-at-and, yet out of the way</li> <li>Silent Traction pads throughout the footwell to keep anglers sure-footed and stealth</li> <li>Comfortable front and rear carry handles for easy transport</li> <li>Molded-in side handles to assist in managing the boat solo</li> <li>Expansive and notched tankwell provides a custom-crafted space for popular rear storage items</li> <li>Rear-mounted transducer area to ensure scanners are protected and in position for the fullest range of view</li> </ul> <p> </p> <ul> <li>Length: 12' 2"</li> <li>Width: 38"</li> <li>Boat Weight: 115 lbs</li> <li>Deck Height: 15"</li> <li>Max Capacity: 450 lbs</li> </ul>	[empty string]	N	2819.99	2819.99	[empty string]	94774-DEFAULT-s.jpg	[empty string]	1000	RECON 120HD	360613	EMPTY	EMPTY	EMPTY	0	0	0	KAYAKS	[empty string]	wilderness-systems/recon-120-hd-12-feet-2-inch-360613	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Filter