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]	1	19.99	0	19.99	105780-DEFAULT-l.jpg	19.99	105780-DEFAULT-m.jpg	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]	2	15-to-20	0.00	[empty string]	V-STYLE STRAPS - PAIR - 18 INCH	<p>These straps feature the same great benefits as Seattle Sports' regular bow/stern straps, but at a more economical price and longer length.</p> <p> </p> <ul> <li>Extra strength webbing for wind and twist protection</li> <li>Coated G-hook prevents scratches and dings</li> <li>Strap has 2 hooks and 1 cam buckle</li> <li>Sold in pairs</li> </ul> <p> </p> <ul> <li>Length: 18ft</li> </ul>	[empty string]	N	19.99	19.99	[empty string]	105780-DEFAULT-s.jpg	[empty string]	1000	075300	62759	STRAPS	EMPTY	EMPTY	0	0	0	ACCESSORIES	[empty string]	seattle-sports/v-style-straps-pair-18-inch-62759	1
2	[empty string]	SEATTLE SPORTS	Seattle Sports	WATERSPORTS	Watersports>Accessories>Straps	[empty string]	1	14.99	0	14.99	105743-DEFAULT-l.jpg	14.99	105743-DEFAULT-m.jpg	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]	3	10-to-15	0.00	[empty string]	SHERPAK - QUICK LOOPS	<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> <p> </p> <ul> <li>Quick Loops anchor easily to your hood or trunk to provide a secure anchor for lashing straps</li> <li>Open your hood/ trunk, place loop end out, and close - pressure does the rest</li> <li>Sold in pairs</li> </ul> <p> </p> <ul> <li>Length: 8.5"</li> </ul>	[empty string]	N	14.99	14.99	[empty string]	105743-DEFAULT-s.jpg	[empty string]	1000	078115	92065	STRAPS	EMPTY	EMPTY	0	0	0	ACCESSORIES	[empty string]	seattle-sports/sherpak-quick-loops-92065	1
3	[empty string]	SEATTLE SPORTS	Seattle Sports	WATERSPORTS	Watersports>Accessories>Straps	[empty string]	1	7.99	0	7.99	105692-DEFAULT-l.jpg	7.99	105692-DEFAULT-m.jpg	HOOD LOOPS PAIR	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]	7	5-to-10	0.00	[empty string]	SHERPAK HOOD LOOPS	<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> <p> </p> <ul> <li>Length: 8" H x 1" W</li> </ul>	[empty string]	N	7.99	7.99	[empty string]	105692-DEFAULT-s.jpg	[empty string]	1000	078000	92066	STRAPS	EMPTY	EMPTY	0	0	0	ACCESSORIES	[empty string]	seattle-sports/sherpak-hood-loops-92066	1
4	[empty string]	NITE IZE	Nite Ize	WATERSPORTS	Watersports>Accessories>Straps	[empty string]	1	12.99	0	12.99	100574-DEFAULT-l.jpg	12.99	100574-DEFAULT-m.jpg	CAM JAM TIE DOWN STRAP 6FT	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]	4	10-to-15	0.00	[empty string]	CAMJAM TIE DOWN STRAPS - 6 FEET	<p> </p> <p>This high-quality 1" webbing tie down system is designed to make securing serious loads simple. Built for ease-of-use and functionality, these straps feature a proprietary zinc-alloy 1" cam buckle and a high-density webbing strap, resulting in the ability to confidently secure working loads up to 700lbs in either a looped or lockout configuration.</p> <p> </p> <ul> <li>Heavy duty tie down straps</li> <li>Die-cast zinc alloy CamJam tensioning mechanism with nickel plate finish and protective pad</li> <li>High strength 1" (2.54cm) wide waterproof, high density weave, polypropylene webbing</li> <li>Sewn-in, color coded & numerically labeled tags allows for easy identification of strap length</li> <li>Premium quality die-cast zinc alloy CamJam tensioning mechanism with nickel plate finish</li> <li>Die-cast zinc alloy housing + center pivot pin with stainless steel torsion spring that activates center hub with integrated webbing capture ring</li> <li>Webbing capture ring on cam mechanism enables controlled release of tension to any applied load</li> <li>Easy to achieve high tension, adjust and control the release without sudden, dangerous unloading</li> <li>Multiple Tie-Down configurations for versatility - Loop Configuration & Lockout Configuration</li> </ul> <p> </p> <ul> <li>Working Load Limit 700lb (318kg)</li> <li>Break Strength 2100lb (953kg)</li> </ul>	[empty string]	N	12.99	12.99	[empty string]	100574-DEFAULT-s.jpg	[empty string]	1000	CJWR6-09-R6	292913	STRAPS	EMPTY	EMPTY	0	0	0	ACCESSORIES	[empty string]	nite-ize/camjam-tie-down-straps-6-feet-292913	1
5	[empty string]	NITE IZE	Nite Ize	WATERSPORTS	Watersports>Accessories>Straps	[empty string]	1	12.99	0	12.99	100570-DEFAULT-l.jpg	12.99	100570-DEFAULT-m.jpg	CAM JAM TIE DOWN STRAP 12FT	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]	1	10-to-15	0.00	[empty string]	CAMJAM TIE DOWN STRAPS - 12 FEET	<p>This high-quality 1" webbing tie down system is designed to make securing serious loads simple. Built for ease-of-use and functionality, these straps feature a proprietary zinc-alloy 1" cam buckle and a high-density webbing strap, resulting in the ability to confidently secure working loads up to 700lbs in either a looped or lockout configuration.</p> <p> </p> <ul> <li>Heavy duty tie down straps</li> <li>Die-cast zinc alloy CamJam tensioning mechanism with nickel plate finish and protective pad</li> <li>High strength 1" (2.54cm) wide waterproof, high density weave, polypropylene webbing</li> <li>Sewn-in, color coded & numerically labeled tags allows for easy identification of strap length</li> <li>Premium quality die-cast zinc alloy CamJam tensioning mechanism with nickel plate finish</li> <li>Die-cast zinc alloy housing + center pivot pin with stainless steel torsion spring that activates center hub with integrated webbing capture ring</li> <li>Webbing capture ring on cam mechanism enables controlled release of tension to any applied load</li> <li>Easy to achieve high tension, adjust and control the release without sudden, dangerous unloading</li> <li>Multiple Tie-Down configurations for versatility - Loop Configuration & Lockout Configuration</li> </ul> <p> </p> <ul> <li>Working Load Limit 700lb (318kg)</li> <li>Break Strength 2100lb (953kg)</li> </ul>	[empty string]	N	12.99	12.99	[empty string]	100570-DEFAULT-s.jpg	[empty string]	1000	CJWR12-09-R6	292914	STRAPS	EMPTY	EMPTY	0	0	0	ACCESSORIES	[empty string]	nite-ize/camjam-tie-down-straps-12-feet-292914	1
6	[empty string]	NITE IZE	Nite Ize	WATERSPORTS	Watersports>Accessories>Straps	[empty string]	1	24.99	0	24.99	100575-DEFAULT-l.jpg	24.99	100575-DEFAULT-m.jpg	CAMJAM TIE DOWN STRAP 6FT - 2 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	20-to-25	0.00	[empty string]	CAMJAM TIE DOWN STRAPS - 6 FEET - 2 PACK	<p>This high-quality 1" webbing tie down system is designed to make securing serious loads simple. Built for ease-of-use and functionality, these straps feature a proprietary zinc-alloy 1" cam buckle and a high-density webbing strap, resulting in the ability to confidently secure working loads up to 700lbs in either a looped or lockout configuration.</p> <p> </p> <ul> <li>Heavy duty tie down straps</li> <li>Die-cast zinc alloy CamJam tensioning mechanism with nickel plate finish and protective pad</li> <li>High strength 1" (2.54cm) wide waterproof, high density weave, polypropylene webbing</li> <li>Sewn-in, color coded & numerically labeled tags allows for easy identification of strap length</li> <li>Premium quality die-cast zinc alloy CamJam tensioning mechanism with nickel plate finish</li> <li>Die-cast zinc alloy housing + center pivot pin with stainless steel torsion spring that activates center hub with integrated webbing capture ring</li> <li>Webbing capture ring on cam mechanism enables controlled release of tension to any applied load</li> <li>Easy to achieve high tension, adjust and control the release without sudden, dangerous unloading</li> <li>Multiple Tie-Down configurations for versatility - Loop Configuration & Lockout Configuration</li> </ul> <p> </p> <ul> <li>Working Load Limit 700lb (318kg)</li> <li>Break Strength 2100lb (953kg)</li> </ul>	[empty string]	N	24.99	24.99	[empty string]	100575-DEFAULT-s.jpg	[empty string]	1000	CJWR6-09-2R6	364663	STRAPS	EMPTY	EMPTY	0	0	0	ACCESSORIES	[empty string]	nite-ize/camjam-tie-down-straps-6-feet-2-pack-364663	1
7	[empty string]	NITE IZE	Nite Ize	WATERSPORTS	Watersports>Accessories>Straps	[empty string]	1	24.99	0	24.99	100571-DEFAULT-l.jpg	24.99	100571-DEFAULT-m.jpg	CAMJAM TIE DOWN STGRAP 12FT - 2 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]	1	20-to-25	0.00	[empty string]	CAMJAM TIE DOWN STRAPS - 12 FEET - 2 PACK	<p>This high-quality 1" webbing tie down system is designed to make securing serious loads simple. Built for ease-of-use and functionality, these straps feature a proprietary zinc-alloy 1" cam buckle and a high-density webbing strap, resulting in the ability to confidently secure working loads up to 700lbs in either a looped or lockout configuration.</p> <p> </p> <ul> <li>Heavy duty tie down straps</li> <li>Die-cast zinc alloy CamJam tensioning mechanism with nickel plate finish and protective pad</li> <li>High strength 1" (2.54cm) wide waterproof, high density weave, polypropylene webbing</li> <li>Sewn-in, color coded & numerically labeled tags allows for easy identification of strap length</li> <li>Premium quality die-cast zinc alloy CamJam tensioning mechanism with nickel plate finish</li> <li>Die-cast zinc alloy housing + center pivot pin with stainless steel torsion spring that activates center hub with integrated webbing capture ring</li> <li>Webbing capture ring on cam mechanism enables controlled release of tension to any applied load</li> <li>Easy to achieve high tension, adjust and control the release without sudden, dangerous unloading</li> <li>Multiple Tie-Down configurations for versatility - Loop Configuration & Lockout Configuration</li> </ul> <p> </p> <ul> <li>Working Load Limit 700lb (318kg)</li> <li>Break Strength 2100lb (953kg)</li> </ul>	[empty string]	N	24.99	24.99	[empty string]	100571-DEFAULT-s.jpg	[empty string]	1000	CJWR12-09-2R6	364664	STRAPS	EMPTY	EMPTY	0	0	0	ACCESSORIES	[empty string]	nite-ize/camjam-tie-down-straps-12-feet-2-pack-364664	1
8	[empty string]	NITE IZE	Nite Ize	WATERSPORTS	Watersports>Accessories>Straps	[empty string]	1	17.99	0	17.99	100572-DEFAULT-l.jpg	17.99	100572-DEFAULT-m.jpg	CAMJAM TIE DOWN STRAP 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]	2022	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	6	15-to-20	0.00	[empty string]	CAMJAM TIE DOWN STRAPS - 18 FEET	<p>This high-quality 1" webbing tie down system is designed to make securing serious loads simple. Built for ease-of-use and functionality, these straps feature a proprietary zinc-alloy 1" cam buckle and a high-density webbing strap, resulting in the ability to confidently secure working loads up to 700lbs in either a looped or lockout configuration.</p> <p> </p> <ul> <li>Heavy duty tie down straps</li> <li>Die-cast zinc alloy CamJam tensioning mechanism with nickel plate finish and protective pad</li> <li>High strength 1" (2.54cm) wide waterproof, high density weave, polypropylene webbing</li> <li>Sewn-in, color coded & numerically labeled tags allows for easy identification of strap length</li> <li>Premium quality die-cast zinc alloy CamJam tensioning mechanism with nickel plate finish</li> <li>Die-cast zinc alloy housing + center pivot pin with stainless steel torsion spring that activates center hub with integrated webbing capture ring</li> <li>Webbing capture ring on cam mechanism enables controlled release of tension to any applied load</li> <li>Easy to achieve high tension, adjust and control the release without sudden, dangerous unloading</li> <li>Multiple Tie-Down configurations for versatility - Loop Configuration & Lockout Configuration</li> </ul> <p> </p> <ul> <li>Working Load Limit 700lb (318kg)</li> <li>Break Strength 2100lb (953kg)</li> </ul>	[empty string]	N	17.99	17.99	[empty string]	100572-DEFAULT-s.jpg	[empty string]	1000	CJWR18-09-R6	364697	STRAPS	EMPTY	EMPTY	0	0	0	ACCESSORIES	[empty string]	nite-ize/camjam-tie-down-straps-18-feet-364697	1
9	[empty string]	NITE IZE	Nite Ize	WATERSPORTS	Watersports>Accessories>Straps	[empty string]	1	14.99	0	14.99	100568-DEFAULT-l.jpg	14.99	100568-DEFAULT-m.jpg	DUAL CAMJAM 1` WEBBING TENSIONER	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2022	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	3	10-to-15	0.00	[empty string]	DUAL CAMJAM TIE DOWN SYSTEM - TENSIONER ONLY	<p>The Dual CamJam 1" Webbing Tensioner is uniquely designed to allow you to create heavy-duty tie-down or connection systems. When paired with our high quality 1” polypropylene webbing in a variety of lengths, it creates a complete tie down system that can be easily positioned, secured, and released.</p> <p> </p> <ul> <li>Premium quality die-cast zinc alloy Dual CamJam tensioning mechanism with nickel plate finish</li> <li>Use tensioner with most 1" webbing (thickness .045"- .090" \|1.14mm - 2.28mm), no sewing required</li> <li>  Working load limit: 600 lbs</li> <li>  Break Strength: 1800 lbs</li> <li>Cam 1: Position + Lock \| Cam 2: Tighten + Secure</li> <li>Works two ways: Fixed End Configuration + Loop Configuration</li> </ul>	[empty string]	N	14.99	14.99	[empty string]	100568-DEFAULT-s.jpg	[empty string]	1000	CJD-11-R3	377367	STRAPS	EMPTY	EMPTY	0	0	0	ACCESSORIES	[empty string]	nite-ize/dual-camjam-tie-down-system-tensioner-only-377367	1
10	[empty string]	NITE IZE	Nite Ize	WATERSPORTS	Watersports>Accessories>Straps	[empty string]	1	17.99	0	17.99	100566-DEFAULT-l.jpg	17.99	100566-DEFAULT-m.jpg	DUAL CAMJAM TIE DOWN SYSTEM 8`	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2022	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	5	15-to-20	0.00	[empty string]	DUAL CAMJAM TIE DOWN SYSTEM - 8 FEET	<p>The Dual CamJam 1" Webbing Tensioner is uniquely designed to allow you to create heavy-duty tie-down or connection systems. When paired with our high quality 1” polypropylene webbing in a variety of lengths, it creates a complete tie down system that can be easily positioned, secured, and released.</p> <p> </p> <ul> <li>Premium quality die-cast zinc alloy Dual CamJam tensioning mechanism with nickel plate finish</li> <li>Use tensioner with most 1" webbing (thickness .045"- .090" \|1.14mm - 2.28mm), no sewing required</li> <li>  Working load limit: 600 lbs</li> <li>  Break Strength: 1800 lbs</li> <li>High strength, high density 1" polypropylene webbing with integrated bar tacked end loop</li> <li>Sewn-in, color-coded + numerically labeled strap tags allow for easy identification of strap length</li> <li>Working load limit - Fixed End Configuration: 400 lbs</li> <li>Working load limit - Loop Configuration: 530 lbs</li> <li>Cam 1: Position + Lock \| Cam 2: Tighten + Secure</li> <li>Works two ways: Fixed End Configuration + Loop Configuration</li> </ul>	[empty string]	N	17.99	17.99	[empty string]	100566-DEFAULT-s.jpg	[empty string]	1000	CJD8-09-R3	377369	STRAPS	EMPTY	EMPTY	0	0	0	ACCESSORIES	[empty string]	nite-ize/dual-camjam-tie-down-system-8-feet-377369	1
11	[empty string]	CONFLUENCE	Confluence	WATERSPORTS	Watersports>Accessories>Straps	[empty string]	1	29.99	0	29.99	104138-DEFAULT-l.jpg	29.99	104138-DEFAULT-m.jpg	DELUXE TIE DOWN STRAP 2PK	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]	2023	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	7	25-to-50	0.00	[empty string]	PERCEPTION - DELUXE TIE DOWN STRAPS - 9 FEET - 2 PACK	<ul> <li>Secure your kayaks, canoes and SUP boards with Perception Tie Down Straps</li> <li>Metal locking cam buckle system is resistant to salt corrosion</li> <li>Rubber buckle cover to prevent scratches and noise</li> <li>UV resistant material prevents fading and sun related damage</li> <li>Heavy-duty 1” wide webbing straps secure loads up to 800 lbs</li> <li>Pack of two (2)</li> <li>Designed to perform well with all Perception sit-inside and sit-on-top recreational kayaks</li> </ul>	[empty string]	N	29.99	29.99	12,15,9	104138-DEFAULT-s.jpg	[empty string]	1000	8080017-9	384222	STRAPS	EMPTY	EMPTY	0	0	0	ACCESSORIES	[empty string]	confluence/perception-deluxe-tie-down-straps-9-feet-2-pack-384222	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts22 ORDER BY sortposition asc

Watersports

Sort By:

Items per page:

Filter