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,BLUE/WHITE	HARMONY	Harmony	WATERSPORTS	Watersports>Paddles	TURQ/LIME\|NULL\|NULL,RED/YELLOW\|NULL\|NULL,BLUE/WHITE\|NULL\|NULL	0	76.99	0	76.99	[empty string]	76.99	[empty string]	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]	20	50-to-100	0.00	[empty string]	Sea Passage - Aluminum	<p>The Sea Passage Paddle works well in everything from placid lakes to rough seas with it`s moderate-sized asymmetrical blades. 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>	[empty string]	N	76.99	76.99	235	[empty string]	[empty string]	1000	SEA PASSAGE ALUMINUM	156121	EMPTY	EMPTY	EMPTY	0	0	0	PADDLES	[empty string]	harmony/kayak-paddle-aluminum-take-apart-shaft-156121	1
2	[empty string]	HARMONY	Harmony	WATERSPORTS	Watersports>Accessories	[empty string]	0	26.99	0	26.99	[empty string]	26.99	[empty string]	RAM TUBE ROD HOLDER	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]	DISC	[empty string]	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	Ram Tube Rod Holder	[empty string]	[empty string]	N	26.99	26.99	[empty string]	[empty string]	[empty string]	1000	8023517	156139	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	harmony/ram-tube-rod-holder-156139	1
3	[empty string]	HARMONY	Harmony	WATERSPORTS	Watersports>Accessories	[empty string]	0	25.99	0	25.99	[empty string]	25.99	[empty string]	TECHLIFT SEAT PAD	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	25-to-50	0.00	[empty string]	Advanced Techlift Seat Pad	<p>The Techlift Seatpad lets you adjust the fit of your seat. This seatpad is made of 1 inch (2.54 cm) thick minicell closed-cell foam, which increases comfort and position.</p>	[empty string]	N	25.99	25.99	[empty string]	[empty string]	[empty string]	1000	8023009	156162	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	harmony/techlift-seat-pad-156162	1
4	TURQ/LIME,RED/YEL,BLUE/WHITE	HARMONY	Harmony	WATERSPORTS	Watersports>Paddles	TURQ/LIME\|NULL\|NULL,RED/YEL\|NULL\|NULL,BLUE/WHITE\|NULL\|NULL	0	114.99	0	114.99	[empty string]	114.99	[empty string]	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]	12	100-to-150	0.00	[empty string]	Sea Passage - Fiberglass	<p>Explore your paddling abilities with the Sea Passage from Harmony. This paddle is suitable for any paddling style and produces smooth, responsive and flutter-free strokes. With the corrosion resistant aluminum alloy and fiberglass reinforced blades you can be sure that the Sea Passage will be durable for many years to come.</p>	[empty string]	N	114.99	114.99	235,215	[empty string]	[empty string]	1000	SEA PASSAGE FIBERGLASS	172198	EMPTY	EMPTY	EMPTY	0	0	0	PADDLES	[empty string]	harmony/kayak-paddle-fiberglass-take-apart-shaft-172198	1
5	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	ONLINE	[empty string]	[empty string]	31	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,MD/LG,XS/SM	[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
6	[empty string]	HARMONY	Harmony	WATERSPORTS	Watersports>Accessories	[empty string]	0	19.99	0	19.99	[empty string]	19.99	[empty string]	PADDLE LEASH	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]	DISC	NOT ONLINE	[empty string]	[empty string]	2	15-to-20	0.00	[empty string]	Paddle Leash	<p>The Harmony Paddle Leash will keep you from losing paddles during high winds, rough seas, or fast currents. A velcro paddle wrap and nylon hook allow you to secure your paddle to a deck loop or bungee and ensure your paddle remains within reach.</p>	[empty string]	N	19.99	19.99	[empty string]	[empty string]	[empty string]	1000	8023203	248434	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	harmony/paddle-leash-248434	1
7	[empty string]	HARMONY	Harmony	WATERSPORTS	Watersports>Accessories	[empty string]	0	32.99	0	32.99	[empty string]	32.99	[empty string]	BOW FLOTATION BAG 10-13FT KAYAK	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	NOT ONLINE	[empty string]	[empty string]	2	25-to-50	0.00	[empty string]	Bow Flotation Bag 10-13ft Kayak	[empty string]	[empty string]	N	32.99	32.99	[empty string]	[empty string]	[empty string]	1000	8023195	253441	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	harmony/bow-flotation-bag-10-13ft-kayak-253441	1
8	[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]	6	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
9	[empty string]	HARMONY	Harmony	WATERSPORTS	Watersports>Accessories	[empty string]	0	15.99	0	15.99	[empty string]	15.99	[empty string]	PERCEPTION BILGE SPONGE	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]	6	15-to-20	0.00	[empty string]	Perception Kayak Sponge	<p>The Perception sponge is ideal for removing unwanted water from white water, touring or recreational kayaks. This synthetic sponge features a handy tie-in tether and a durable cover that is mildew resistant and machine washable. The Perception sponge can absorb and holds up to 1 liter of water and crushes down for compact storage.</p>	[empty string]	N	15.99	15.99	[empty string]	[empty string]	[empty string]	1000	8080014	317417	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	harmony/perception-bilge-sponge-317417	1
10	BLACK	HARMONY	Harmony	WATERSPORTS	Watersports>Paddles	BLACK\|NULL\|NULL	0	109.99	0	109.99	[empty string]	109.99	[empty string]	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]	4	100-to-150	0.00	[empty string]	Paddle Outlaw Adjustable 230-250	[empty string]	[empty string]	N	109.99	109.99	230/250	[empty string]	[empty string]	1000	8080064	331677	EMPTY	EMPTY	EMPTY	0	0	0	PADDLES	[empty string]	harmony/paddle-outlaw-adjustable-230-250-331677	1
11	YEL/LIME	HARMONY	Harmony	WATERSPORTS	Watersports>Paddles	YEL/LIME\|NULL\|NULL	0	44.99	0	44.99	[empty string]	44.99	[empty string]	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]	2	25-to-50	0.00	[empty string]	Paddle Hi-five Kids Paddle 190 Sot	[empty string]	[empty string]	N	44.99	44.99	[empty string]	[empty string]	[empty string]	1000	8080066	331678	EMPTY	EMPTY	EMPTY	0	0	0	PADDLES	[empty string]	harmony/paddle-hi-five-kids-paddle-190-sot-331678	1
12	[empty string]	HARMONY	Harmony	WATERSPORTS	Watersports>Accessories	[empty string]	0	64.99	0	64.99	[empty string]	64.99	[empty string]	OUTLAW KAYAK SADDLEBAG	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	50-to-100	0.00	[empty string]	Outlaw Kayak Saddlebag	[empty string]	[empty string]	N	64.99	64.99	[empty string]	[empty string]	[empty string]	1000	8080068	331679	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	harmony/outlaw-kayak-saddlebag-331679	1
13	[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]	12	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
14	[empty string]	HARMONY	Harmony	WATERSPORTS	Watersports>Accessories	[empty string]	0	26.99	0	26.99	[empty string]	26.99	[empty string]	PADDLE AND ROD LEASH	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	25-to-50	0.00	[empty string]	Paddle And Rod Leash	[empty string]	[empty string]	N	26.99	26.99	[empty string]	[empty string]	[empty string]	1000	8080011	351133	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	harmony/paddle-and-rod-leash-351133	1
15	[empty string]	HARMONY	Harmony	WATERSPORTS	Watersports>Accessories	[empty string]	0	49.99	0	49.99	[empty string]	49.99	[empty string]	SIT ON TOP SECURITY CABLE 55 INCH	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	25-to-50	0.00	[empty string]	Sit On Top Security Cable 55 Inch	[empty string]	[empty string]	N	49.99	49.99	[empty string]	[empty string]	[empty string]	1000	8027092	351134	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	harmony/sit-on-top-security-cable-55-inch-351134	1
16	[empty string]	HARMONY	Harmony	WATERSPORTS	Watersports>Accessories	[empty string]	0	49.99	0	49.99	[empty string]	49.99	[empty string]	SIT INSIDE SECURITY CABLE 47 INCH	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]	DISC	[empty string]	[empty string]	[empty string]	4	25-to-50	0.00	[empty string]	Sit Inside Security Cable 47 Inch	[empty string]	[empty string]	N	49.99	49.99	[empty string]	[empty string]	[empty string]	1000	8027093	351135	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	harmony/sit-inside-security-cable-47-inch-351135	1
17	[empty string]	HARMONY	Harmony	WATERSPORTS	Watersports>Accessories	[empty string]	0	16.99	0	16.99	[empty string]	16.99	[empty string]	RAM TRACK BALL 1.5 INCH	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]	DISC	[empty string]	[empty string]	[empty string]	1	15-to-20	0.00	[empty string]	Ram Track Ball 1.5 Inch	[empty string]	[empty string]	N	16.99	16.99	[empty string]	[empty string]	[empty string]	1000	8027080	351136	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	harmony/ram-track-ball-1-5-inch-351136	1
18	[empty string]	HARMONY	Harmony	WATERSPORTS	Watersports>Accessories	[empty string]	0	42.99	0	42.99	[empty string]	42.99	[empty string]	KAYAK KIDS SEAT	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]	2	25-to-50	0.00	[empty string]	Kayak Kids Seat	[empty string]	[empty string]	N	42.99	42.99	[empty string]	[empty string]	[empty string]	1000	8023558	351137	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	harmony/kayak-kids-seat-351137	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Filter