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	[empty string]	SEATTLE SPORTS	Seattle Sports	WATERSPORTS	Watersports>Accessories>Straps	[empty string]	0	9.99	0	9.99	[empty string]	9.99	[empty string]	BOW/STERN STRAP 6FT BLACK	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]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	6	5-to-10	0.00	[empty string]	Bow / Stern Straps - 8 Inches	<p>The Bow/Stern Straps are great to have for emergency situations; but essential for hauling a kayak or canoe.</p> <p> </p> <p>-Extra strength webbing for wind and twist protection<br /> -Coated G-hook prevents scratches and dings<br /> -Strap has 2 hooks and 1 cam buckle<br /> -Sold as singles</p>	[empty string]	N	9.99	9.99	[empty string]	[empty string]	[empty string]	1000	075100	62757	STRAPS	EMPTY	EMPTY	0	0	0	ACCESSORIES	[empty string]	seattle-sports/bow-stern-strap-6ft-black-62757	1
2	[empty string]	SEATTLE SPORTS	Seattle Sports	WATERSPORTS	Watersports>Accessories>Straps	[empty string]	0	19.99	0	19.99	[empty string]	19.99	[empty string]	V STYLE BOW/STERN STRAPS 18FT	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]	ACTIVE	[empty string]	[empty string]	[empty string]	3	15-to-20	0.00	[empty string]	V-style Bow / Stern Straps (pair) - 18 Feet	<p>These straps feature the same great benefits as Seattle Sport`s regular bow/stern straps, but at a more economical price and longer length.</p>	[empty string]	N	19.99	19.99	[empty string]	[empty string]	[empty string]	1000	075300	62759	STRAPS	EMPTY	EMPTY	0	0	0	ACCESSORIES	[empty string]	seattle-sports/v-style-bow-stern-straps-18ft-62759	1
3	[empty string]	SEATTLE SPORTS	Seattle Sports	WATERSPORTS	Watersports>Accessories>Straps	[empty string]	0	19.99	0	19.99	[empty string]	19.99	[empty string]	BOAT KEEPERZ STORAGE STRAPS BLK	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]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	3	15-to-20	0.00	[empty string]	Boat Keeperz	Boat Keeperz are a quick solution for mounting boats to the wall for easy, out-of-the-way storage.<br/> <br> <br> <br> <i><font size=1> Note: While every effort is made to include accurate and correct images, descriptions, specifications and pricing for each product, they are shown for example only and do not necessarily represent the product in its entirety. Inadvertent errors may occur. Jay`s Sporting Goods reserves the right to modify or change product information and pricing without notice. If you have a question about an item, please call or email us for more information before ordering.</font></i>	[empty string]	N	19.99	19.99	[empty string]	[empty string]	[empty string]	1000	025915	92048	STRAPS	EMPTY	EMPTY	0	0	0	ACCESSORIES	[empty string]	seattle-sports/boat-keeperz-storage-straps-blk-92048	1
4	[empty string]	SEATTLE SPORTS	Seattle Sports	WATERSPORTS	Watersports>Accessories>Straps	[empty string]	0	15.99	0	15.99	[empty string]	15.99	[empty string]	QUICK LOOPS PAIR BLACK	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]	ACTIVE	[empty string]	[empty string]	[empty string]	5	15-to-20	0.00	[empty string]	Quick Loops - Pair	<p>Simply open your hood or trunk, position the loop where you want it (so the web loop end emerges through the gaps) and close. The Quick Loop locks in place with the pressure, providing a quick, easy loop to lash your straps to.</p>	[empty string]	N	15.99	15.99	[empty string]	[empty string]	[empty string]	1000	078115	92065	STRAPS	EMPTY	EMPTY	0	0	0	ACCESSORIES	[empty string]	seattle-sports/quick-loops-pair-black-92065	1
5	[empty string]	SEATTLE SPORTS	Seattle Sports	WATERSPORTS	Watersports>Accessories>Straps	[empty string]	0	7.99	0	7.99	[empty string]	7.99	[empty string]	HOOD LOOPS PAIR	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]	ACTIVE	[empty string]	[empty string]	[empty string]	5	5-to-10	0.00	[empty string]	Hood Loops - Pair	<p>Ideal for vehicles with plastic bumpers that have no metal underneath, these innovative loops install on the quarter panel bolts under the hood to provide a tie-down attachment. </p>	[empty string]	N	7.99	7.99	[empty string]	[empty string]	[empty string]	1000	078000	92066	STRAPS	EMPTY	EMPTY	0	0	0	ACCESSORIES	[empty string]	seattle-sports/hood-loops-pair-92066	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts22 ORDER BY sortposition asc

Watersports

Sort By:

Items per page:

Close

Filter By

Filter