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	TURQ/LIME,RED/YELLOW	HARMONY	Harmony	WATERSPORTS	Watersports>Paddles	TURQ/LIME\|NULL\|NULL,RED/YELLOW\|NULL\|NULL	1	76.99	0	76.99	94837-DEFAULT-l.jpg	76.99	94837-DEFAULT-m.jpg	KAYAK PADDLE ALUMINUM TAKE APART 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]	2022	[empty string]	[empty string]	ACTIVE	PROP 65	[empty string]	[empty string]	9	50-to-100	0.00	[empty string]	SEA PASSAGE - ALUMINUM	<p>The Harmony Sea Passage Aluminum Shaft Take-A-Part Paddle offers moderate-sized asymmetrical blades that work well in everything from placid lakes to rough seas. It is suitable for both high and low angle paddling styles. The Sea Passage is one of Harmony Gear's most popular touring paddles and for good reason.</p> <p> </p> <ul> <li>Works well for high or low angle paddling</li> <li>Versatile recreational and touring design for a wide range of paddling styles</li> <li>2-piece take-apart construction for easy transport and storage</li> <li>Simple push-button ferrule allows for offset adjustment from 0 to 60 degrees</li> <li>Dihedral blade design reduces flutter for smoother and more efficient strokes</li> <li>Aluminum shaft with fiberglass-reinforced “polypro” blades for durability</li> </ul> <p> </p> <ul> <li>Shaft Type: Aluminum</li> <li>Shaft Color: Black</li> <li>Blade Shape: Asymetrical</li> <li>Blade Material: Nylon</li> <li>Weight: 33 oz (935.53 g)</li> </ul>	[empty string]	N	76.99	76.99	235	94837-DEFAULT-s.jpg	[empty string]	1000	SEA PASSAGE ALUMINUM	156121	EMPTY	EMPTY	EMPTY	0	0	0	PADDLES	[empty string]	harmony/sea-passage-aluminum-156121	1
2	TURQ/LIME,RED/YEL,BLUE/WHITE	HARMONY	Harmony	WATERSPORTS	Watersports>Paddles	TURQ/LIME\|NULL\|NULL,RED/YEL\|NULL\|NULL,BLUE/WHITE\|NULL\|NULL	1	114.99	0	114.99	94838-DEFAULT-l.jpg	114.99	94838-DEFAULT-m.jpg	KAYAK PADDLE FIBERGLASS TAKE APART 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]	2022	[empty string]	[empty string]	ACTIVE	PROP 65	[empty string]	[empty string]	10	100-to-150	0.00	[empty string]	SEA PASSAGE - FIBERGLASS	<p>The Harmony Sea Passage Fiberglass Shaft Take-A-Part Paddle offers moderate-sized asymmetrical blades that work well in everything from placid lakes to rough seas. It is suitable for both high and low angle paddling styles. The Sea Passage is one of Harmony Gear's most popular touring paddles.</p> <p> </p> <ul> <li>Works well for high or low angle paddling</li> <li>Versatile recreational and touring design for a wide range of paddling styles</li> <li>2-piece take-apart construction for easy transport and storage</li> <li>Simple push-button ferrule allows for offset adjustment from 0 to 60 degrees</li> <li>Dihedral blade design reduces flutter for smoother and more efficient strokes</li> <li>Fiberglass shaft with fiberglass-reinforced “polypro” blades for durability</li> <li>Moderate-size asymmetrical blades suitable for placid or rough waters</li> <li>Ferrule made of injection molded plastic</li> <li>2-piece take-apart paddle</li> </ul> <p> </p> <ul> <li>Shaft Type: Fiberglass</li> <li>Shaft Color: Black</li> <li>Blade Color: Varies </li> <li>Blade Shape: Asymetrical</li> <li>Blade Material: Fiberglass/Polypropylene</li> <li>Weight: 35 oz (992.23 g)</li> </ul>	[empty string]	N	114.99	114.99	235,215	94838-DEFAULT-s.jpg	[empty string]	1000	SEA PASSAGE FIBERGLASS	172198	EMPTY	EMPTY	EMPTY	0	0	0	PADDLES	[empty string]	harmony/sea-passage-fiberglass-172198	1
3	ORANGE	HARMONY	Harmony	WATERSPORTS	Watersports>Flotation Devices (PFDs)	ORANGE\|NULL\|NULL	0	79.99	0	79.99	[empty string]	79.99	[empty string]	HIGHBACK TYPE III PFD TWO TONE	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]	6	50-to-100	0.00	[empty string]	Kickback Ii Life Jacket	<p>The Harmony Kickback Life Jacket - PFD is a high back personal flotation device with a nylon shell that combines performance with unique design. Its high back design and ergonomic cut allow for maximum ventilation and comfort without limiting your range of motion. The Kickback features a design that is perfect for recreational kayaks with high seat backs, yet comfortable enough for touring or canoeing.</p>	[empty string]	N	79.99	79.99	XL/XXL,XS/SM,MD/LG	[empty string]	[empty string]	1000	KICKBACK II	243397	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	harmony/highback-type-iii-pfd-two-tone-243397	1
4	[empty string]	HARMONY	Harmony	WATERSPORTS	Watersports>Racks and Carriers	[empty string]	0	136.99	0	136.99	[empty string]	136.99	[empty string]	LARGE KAYAK CART FOAM WHEELS 6.5LBS	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	ONLINE	[empty string]	[empty string]	4	100-to-150	0.00	[empty string]	Perception Large Cart With Foam Wheels	<p>The Perception Large Cart with Foam Wheels makes transporting your boat easy! The compact folding design makes for convenient storage and its anodized coating on the aluminum frame is strong and corrosion resistant. Flat-free tires are foam filled with all-terrain tread making transport a breeze in any condition.</p>	[empty string]	N	136.99	136.99	[empty string]	[empty string]	[empty string]	1000	8080012	317416	EMPTY	EMPTY	EMPTY	0	0	0	RACKS AND CARRIERS	[empty string]	harmony/large-kayak-cart-foam-wheels-6-5lbs-317416	1
5	BLACK	HARMONY	Harmony	WATERSPORTS	Watersports>Paddles	BLACK\|NULL\|NULL	1	109.99	0	109.99	94839-DEFAULT-l.jpg	109.99	94839-DEFAULT-m.jpg	PADDLE OUTLAW ADJUSTABLE 230-250	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	100-to-150	0.00	[empty string]	OUTLAW PADDLE	<p>Designed to perform well with the Perception Outlaw kayak, this paddle is also compatible with other fishing kayaks that anglers feel comfortable standing on.</p> <p> </p> <ul> <li>Three-piece design allows paddler to easily convert from kayak to SUP paddle - so that Outlaw owners can more easily paddle their boat from a standing position - comes with grip/shaft that can be exchanged with one of the blades for the standup paddling mode</li> <li>230cm base paddle with up to 20cm of additional length adjustment <ul> <li>Kayak assembly has an adjustable length range from 230cm to 250cm</li> <li>SUP assembly has an adjustable length range from 188cm to 208cm</li> </ul> </li> <li>Durable injection-molded blades and anodized aluminum shaft</li> <li>Mid-sized asymmetric blade with dihedral for improved boat control without blade flutter</li> <li>Infinite feathering options</li> <li>Aluminum shaft with fiberglass-reinforced polypro blades minimize weight without compromising durability</li> <li>Approximate Weights: Kayak Paddle with 2 Blades (2.9 lbs), SUP Paddle with 1 Blade and Grip (2.2 lbs), Total Weight of 3 Pieces (3.6 lbs)</li> </ul>	[empty string]	N	109.99	109.99	230/250	94839-DEFAULT-s.jpg	[empty string]	1000	8080064	331677	EMPTY	EMPTY	EMPTY	0	0	0	PADDLES	[empty string]	harmony/outlaw-paddle-331677	1
6	YEL/LIME	HARMONY	Harmony	WATERSPORTS	Watersports>Paddles	YEL/LIME\|NULL\|NULL	1	44.99	0	44.99	94840-DEFAULT-l.jpg	44.99	94840-DEFAULT-m.jpg	PADDLE HI-FIVE KIDS PADDLE 190 SOT	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	25-to-50	0.00	[empty string]	HI FIVE KAYAK PADDLE - KIDS'	<p>Featuring a shorter paddle shaft and smaller blades, the Hi Five paddle is sized specifically for younger paddlers. The smaller diameter shaft accommodates smaller hands and offers a more comfortable fit for kids than a standard adult paddle. Generally well-suited to paddlers under 5 feet tall. This paddle works perfectly with the Hi Five kids' kayak but will also allow your children to more comfortably paddle other smaller kayaks. Additionally, kids can change the angle of their blade just like the grown-ups do.</p> <p> </p> <ul> <li>Optimized for the Perception Hi Five kayak</li> <li>Compatible with any kids’ kayak</li> <li>190cm long (vs. 230cm for average adult paddle)</li> <li>Smaller (425cm2) blade for easy strokes</li> <li>Small diameter shaft sized for smaller hands</li> <li>3-position push-button ferrule connection (60/0/60) in center of paddle shaft - enables adjustment of the blade angle known as feathering</li> <li>Paddle Weight: 1.67 lbs</li> </ul>	[empty string]	N	44.99	44.99	[empty string]	94840-DEFAULT-s.jpg	[empty string]	1000	8080066	331678	EMPTY	EMPTY	EMPTY	0	0	0	PADDLES	[empty string]	harmony/hi-five-kayak-paddle-kids-331678	1
7	[empty string]	HARMONY	Harmony	WATERSPORTS	Watersports>Accessories	[empty string]	0	18.99	0	18.99	[empty string]	18.99	[empty string]	SCUPPER HOLE PLUGS 4 PACK	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]	5	15-to-20	0.00	[empty string]	Scupper Hole Plugs 4 Pack	[empty string]	[empty string]	N	18.99	18.99	[empty string]	[empty string]	[empty string]	1000	8080013	351132	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	harmony/scupper-hole-plugs-4-pack-351132	1
8	LIME	HARMONY	Harmony	WATERSPORTS	Watersports>Paddles	LIME\|NULL\|NULL	1	89.99	0	89.99	94841-DEFAULT-l.jpg	89.99	94841-DEFAULT-m.jpg	PADDLE 3PC HI-LIFE SUP 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]	2022	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	1	50-to-100	0.00	[empty string]	HI LIFE PADDLE	<ul> <li>Designed to perform will with the Perception Hi Life kayak</li> <li>Three-piece design allows paddler to easily convert from kayak to SUP paddle</li> <li>Simple push-button ferrule for quick length adjustments while standing or sitting</li> <li>Kayak assembly has an adjustable range from 215 cm to 230 cm</li> <li>SUP assembly has an adjustable range from 74” to 80”</li> <li>Aluminum shaft with fiberglass-reinforced polypro blades for improved durability and reduced weight</li> <li>Approximate Weight: Kayak (2.9 lbs), SUP (2.2 lbs), Total (3.6 lbs)</li> <li>Color: Lime</li> </ul>	[empty string]	N	89.99	89.99	[empty string]	94841-DEFAULT-s.jpg	[empty string]	1000	8080026	360656	EMPTY	EMPTY	EMPTY	0	0	0	PADDLES	[empty string]	harmony/hi-life-paddle-360656	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Filter