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,GALAXY	WILDERNESS SYSTEMS	Wilderness Systems	WATERSPORTS	Watersports>Kayaks	MANGO\|NULL\|NULL,GALAXY\|NULL\|NULL	1	899	0	899	94769-DEFAULT-l.jpg	899	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]	5	500-or-more	0.00	[empty string]	ASPIRE 105 - 10 FT 6 IN	<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" (320 cm)</li> <li>Width: 29" (74 cm)</li> <li>Boat Weight: 48 lbs (22 kg)</li> <li>Deck Height: 15.5" (39 cm)</li> <li>Cockpit Length: 51.5" (131 cm)</li> <li>Cockpit Width: 23.5" (60 cm)</li> <li>Max Capacity: 400 lbs (181 kg)</li> </ul>	[empty string]	N	899	899	[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-ft-6-in-156104	1
2	GALAXY,MANGO,BREEZE	WILDERNESS SYSTEMS	Wilderness Systems	WATERSPORTS	Watersports>Kayaks	GALAXY\|NULL\|NULL,MANGO\|NULL\|NULL,BREEZE\|NULL\|NULL	1	999	0	999	94770-DEFAULT-l.jpg	999	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]	4	500-or-more	0.00	[empty string]	PUNGO 105 - 10 FT 6 IN	<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" (320 cm)</li> <li>Width: 30" (76 cm)</li> <li>Boat Weight: 47 lbs (21 kg)</li> <li>Cockpit Length: 56" (142 cm)</li> <li>Cockpit Width: 22" (56 cm)</li> <li>Max Capacity: 300 lbs (136 kg)</li> </ul>	[empty string]	N	999	999	[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-ft-6-in-309618	1
3	GALAXY,BREEZE,MANGO	WILDERNESS SYSTEMS	Wilderness Systems	WATERSPORTS	Watersports>Kayaks	GALAXY\|NULL\|NULL,BREEZE\|NULL\|NULL,MANGO\|NULL\|NULL	1	1099	0	1099	94773-DEFAULT-l.jpg	1099	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]	9	500-or-more	0.00	[empty string]	TARPON 120 - 12 FT 3 IN	<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" (373 cm)</li> <li>Width: 31" (79 cm)</li> <li>Boat Weight: 63 lbs (29 kg)</li> <li>Deck Height: 13.75" (35 cm)</li> <li>Max Capacity: 350 lbs (159 kg)</li> </ul>	[empty string]	N	1099	1099	[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-ft-3-in-343180	1
4	MANGO	WILDERNESS SYSTEMS	Wilderness Systems	WATERSPORTS	Watersports>Kayaks	MANGO\|NULL\|NULL	1	1099	0	1099	94771-DEFAULT-l.jpg	1099	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]	1	500-or-more	0.00	[empty string]	PUNGO 125 - 12 FT 6 IN	<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" (381 cm)</li> <li>Width: 29" (75 cm)</li> <li>Boat Weight: 53 lbs (24 kg)</li> <li>Cockpit Length: 57.75" (147 cm)</li> <li>Cockpit Width: 22.5" (57 cm)</li> <li>Max Capacity: 425 lbs (193 kg)</li> </ul>	[empty string]	N	1099	1099	[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-ft-6-in-343182	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Filter