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]	INTERNATIONAL LEISURE	International Leisure	WATERSPORTS	Watersports>Inflatables	[empty string]	0	29.99	0	29.99	[empty string]	29.99	[empty string]	SLING CHAIR	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]	3	25-to-50	0.00	[empty string]	Noodle Fun Seat	<p>Foam tubes and nylon mesh are the materials of choice for this fun and affordable floating chair.</p>	[empty string]	N	29.99	29.99	[empty string]	[empty string]	[empty string]	1000	9043	33043	EMPTY	EMPTY	EMPTY	0	0	0	INFLATABLES	[empty string]	international-leisure/sling-chair-33043	1
2	[empty string]	O BRIEN	O Brien	WATERSPORTS	Watersports>Inflatables	[empty string]	0	3.99	0	3.99	[empty string]	3.99	[empty string]	BOSTON VALVE	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]	7	5-AND-under	0.00	[empty string]	Boston Valve	<p>The boston valve is O`Brien`s standard one way valve that will fit any O’Brien tube manufactured prior to 2016.</p>	[empty string]	N	3.99	3.99	[empty string]	[empty string]	[empty string]	1000	84524	51784	EMPTY	EMPTY	EMPTY	0	0	0	INFLATABLES	[empty string]	o-brien/boston-valve-51784	1
3	[empty string]	O BRIEN	O Brien	WATERSPORTS	Watersports>Inflatables	[empty string]	0	249.99	0	249.99	[empty string]	249.99	[empty string]	ULTRA SCREAMER TUBE 80`	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	200-to-250	0.00	[empty string]	Ultra Screamer Tube 80`	[empty string]	[empty string]	N	249.99	249.99	[empty string]	[empty string]	[empty string]	1000	2211506	125792	EMPTY	EMPTY	EMPTY	0	0	0	INFLATABLES	[empty string]	o-brien/ultra-screamer-tube-80-125792	1
4	[empty string]	INTERNATIONAL LEISURE	International Leisure	WATERSPORTS	Watersports>Inflatables	[empty string]	0	9.99	0	9.99	[empty string]	9.99	[empty string]	AMERICAN FLAG MATTRESS	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]	3	5-to-10	0.00	[empty string]	Americana Series Mattress	<p>The Americana Series Mattress is an Americana graphic print in a full size 75". Show your true colors all season long!</p>	[empty string]	N	9.99	9.99	[empty string]	[empty string]	[empty string]	1000	90176	139192	EMPTY	EMPTY	EMPTY	0	0	0	INFLATABLES	[empty string]	international-leisure/american-flag-mattress-139192	1
5	[empty string]	O BRIEN	O Brien	WATERSPORTS	Watersports>Inflatables	[empty string]	0	79.99	0	79.99	[empty string]	79.99	[empty string]	TUBESTER 54 INCH TUBE BLUE	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	50-to-100	0.00	[empty string]	Tubester 54 Inch Tube Blue	[empty string]	[empty string]	N	79.99	79.99	[empty string]	[empty string]	[empty string]	1000	2201508	144415	EMPTY	EMPTY	EMPTY	0	0	0	INFLATABLES	[empty string]	o-brien/tubester-54-inch-tube-blue-144415	1
6	[empty string]	O BRIEN	O Brien	WATERSPORTS	Watersports>Inflatables	[empty string]	0	159.99	0	159.99	[empty string]	159.99	[empty string]	SCREAMER TUBE	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]	BOTH	ACTIVE	[empty string]	[empty string]	[empty string]	1	150-to-200	0.00	[empty string]	Screamer Tube	[empty string]	[empty string]	N	159.99	159.99	[empty string]	[empty string]	[empty string]	1000	2211504	175042	EMPTY	EMPTY	EMPTY	0	0	0	INFLATABLES	[empty string]	o-brien/screamer-tube-175042	1
7	[empty string]	KWIK TEK	Kwik Tek	WATERSPORTS	Watersports>Inflatables	[empty string]	1	39.99	0	39.99	102786-DEFAULT-l.jpg	39.99	102786-DEFAULT-m.jpg	SPORTSSTUFF JUSTA TUBE 40 INCH	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	MAP	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	22	25-to-50	0.00	[empty string]	JUSTA - INFLATABLE WATER & SNOW TUBE - 40 INCH	<p>Justa Tube is so much more than an ordinary tube. This black donut tube is hypoallergenic, meaning it's much safer for those prone to allergies and irritation. The Schrader valve stem is shorter than a standard auto valve and has a tapered cap, so there’s no discomfort or scratching legs. It’s made of isobutylene isoprene synthetic rubber, an upgrade from a standard tire tube. It’s more resistant to heat, abrasion, ozone and sunlight. Justa Tube provides year-round fun. In winter, use it to sled down hills of snow. In summer, you’ll enjoy this inflatable black tube at the river, lake, pool, or ocean.</p> <p> </p> <ul> <li>Hypoallergenic material</li> <li>Tapered valve cap</li> <li>Dual functionality for winter or summer</li> </ul> <p> </p> <ul> <li>Diameter: 40"</li> </ul>	[empty string]	N	39.99	39.99	[empty string]	102786-DEFAULT-s.jpg	[empty string]	1000	52-1140	268376	EMPTY	EMPTY	EMPTY	0	0	0	INFLATABLES	[empty string]	kwik-tek/justa-inflatable-water-snow-tube-40-inch-268376	1
8	[empty string]	KWIK TEK	Kwik Tek	WATERSPORTS	Watersports>Inflatables	[empty string]	1	29.99	0	29.99	102799-DEFAULT-l.jpg	29.99	102799-DEFAULT-m.jpg	SPORTSSTUFF JUST A TUBE 32INCH	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	MAP	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	15	25-to-50	0.00	[empty string]	JUSTA - INFLATABLE WATER & SNOW TUBE - 32 INCH	<p>Justa Tube is so much more than an ordinary tube. This black donut tube is hypoallergenic, meaning it's much safer for those prone to allergies and irritation. The Schrader valve stem is shorter than a standard auto valve and has a tapered cap, so there’s no discomfort or scratching legs. It’s made of isobutylene isoprene synthetic rubber, an upgrade from a standard tire tube. It’s more resistant to heat, abrasion, ozone and sunlight. Justa Tube provides year-round fun. In winter, use it to sled down hills of snow. In summer, you’ll enjoy this inflatable black tube at the river, lake, pool, or ocean.</p> <p> </p> <ul> <li>Hypoallergenic material</li> <li>Tapered valve cap</li> <li>Dual functionality for winter or summer</li> </ul> <p> </p> <ul> <li>Diameter: 32"</li> </ul>	[empty string]	N	29.99	29.99	[empty string]	102799-DEFAULT-s.jpg	[empty string]	1000	52-1132	277050	EMPTY	EMPTY	EMPTY	0	0	0	INFLATABLES	[empty string]	kwik-tek/justa-inflatable-water-snow-tube-32-inch-277050	1
9	[empty string]	INTERNATIONAL LEISURE	International Leisure	WATERSPORTS	Watersports>Inflatables	[empty string]	0	3.99	0	3.99	[empty string]	3.99	[empty string]	SUNTANNER WINDOW RIDER 36IN	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]	2022	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	7	5-AND-under	0.00	[empty string]	Suntanner Window Rider 36in	[empty string]	[empty string]	N	3.99	3.99	[empty string]	[empty string]	[empty string]	1000	9012	293787	EMPTY	EMPTY	EMPTY	0	0	0	INFLATABLES	[empty string]	international-leisure/suntanner-window-rider-36in-293787	1
10	[empty string]	INTERNATIONAL LEISURE	International Leisure	WATERSPORTS	Watersports>Inflatables	[empty string]	0	12.99	0	12.99	[empty string]	12.99	[empty string]	CANOE 48IN	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]	2022	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	2	10-to-15	0.00	[empty string]	Canoe	<p>This 48" Canoe is complete with stabilizing side pontoons.</p>	[empty string]	N	12.99	12.99	[empty string]	[empty string]	[empty string]	1000	9031	293798	EMPTY	EMPTY	EMPTY	0	0	0	INFLATABLES	[empty string]	international-leisure/canoe-48in-293798	1
11	[empty string]	INTERNATIONAL LEISURE	International Leisure	WATERSPORTS	Watersports>Inflatables	[empty string]	0	12.99	0	12.99	[empty string]	12.99	[empty string]	GOLDFISH ME YOU BABY SEAT	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]	2022	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	8	10-to-15	0.00	[empty string]	Me & You Baby Seat - Goldfish	<p>The Me & You Baby Seat is perfect for those fun summer days in the water with your little sweetheart! With play rings and the cute fishy design your baby will have fun for a long while.</p>	[empty string]	N	12.99	12.99	[empty string]	[empty string]	[empty string]	1000	90250	309692	EMPTY	EMPTY	EMPTY	0	0	0	INFLATABLES	[empty string]	international-leisure/goldfish-me-you-baby-seat-309692	1
12	[empty string]	INTERNATIONAL LEISURE	International Leisure	WATERSPORTS	Watersports>Inflatables	[empty string]	0	7.99	0	7.99	[empty string]	7.99	[empty string]	SUNTANNER MATT 72X30	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]	2022	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	2	5-to-10	0.00	[empty string]	Suntanner Matt 72x30	[empty string]	[empty string]	N	7.99	7.99	[empty string]	[empty string]	[empty string]	1000	9017	339782	EMPTY	EMPTY	EMPTY	0	0	0	INFLATABLES	[empty string]	international-leisure/suntanner-matt-72x30-339782	1
13	[empty string]	INTERNATIONAL LEISURE	International Leisure	WATERSPORTS	Watersports>Inflatables	[empty string]	0	12.99	0	12.99	[empty string]	12.99	[empty string]	AMERICANA GLITTER MATRESS	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]	2022	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	5	10-to-15	0.00	[empty string]	Americana Glitter Matress	[empty string]	[empty string]	N	12.99	12.99	[empty string]	[empty string]	[empty string]	1000	90179	339783	EMPTY	EMPTY	EMPTY	0	0	0	INFLATABLES	[empty string]	international-leisure/americana-glitter-matress-339783	1
14	[empty string]	INTERNATIONAL LEISURE	International Leisure	WATERSPORTS	Watersports>Inflatables	[empty string]	0	19.99	0	19.99	[empty string]	19.99	[empty string]	AMERICAN SURFER	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]	2022	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	7	15-to-20	0.00	[empty string]	American Surfer	[empty string]	[empty string]	N	19.99	19.99	[empty string]	[empty string]	[empty string]	1000	90696	357351	EMPTY	EMPTY	EMPTY	0	0	0	INFLATABLES	[empty string]	international-leisure/american-surfer-357351	1
15	[empty string]	KWIK TEK	Kwik Tek	WATERSPORTS	Watersports>Inflatables	[empty string]	1	7.99	0	7.99	102860-DEFAULT-l.jpg	7.99	102860-DEFAULT-m.jpg	GREEN BOX VINYL REPAIR ROLL	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	MAP	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	2	5-to-10	0.00	[empty string]	TEAR AID REPAIR KIT - TYPE B - VINYL	<p>Fix punctures and tears on a variety of items with the peerless AIRHEAD TEAR-AID Fabric & Vinyl Repair Patch Kit. Its unique airtight, watertight and elastic composition stretches and springs back to keep the patch in place for a very long time. TEAR-AID Type B stays put when ordinary repair products give out. The tear aid inflatable repair is UV-resistant and extremely handy for fixing towable and boat covers, tents, awnings, sleeping bags, cushions, fishing waders, bicycle tubes, towable tubes, pool liners, rafts, pool floats, kiteboard bladders and more. The see-through patch makes it suitable for fabrics and vinyl of any color. The Tear-Aid Vinyl Patch is an easy peel-and-stick application.</p> <p> </p> <ul> <li>Included:</li> <li>(1) 3” x12” patch</li> <li>(1) 7/8” x 7/8” patch</li> <li>(1) 1 3/8” x 1 3/8” patch</li> <li>(1) 12” reinforcement filament</li> <li>(2) Alcohol prep pads</li> </ul>	[empty string]	N	7.99	7.99	[empty string]	102860-DEFAULT-s.jpg	[empty string]	1000	TYPE B ROLL	367644	EMPTY	EMPTY	EMPTY	0	0	0	INFLATABLES	[empty string]	kwik-tek/tear-aid-repair-kit-type-b-vinyl-367644	1
16	[empty string]	KWIK TEK	Kwik Tek	WATERSPORTS	Watersports>Inflatables	[empty string]	1	14.99	0	14.99	102865-DEFAULT-l.jpg	14.99	102865-DEFAULT-m.jpg	AIRHEAD AQUA ZOOKA SINGLE SHOT 24IN	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	MAP	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	69	10-to-15	0.00	[empty string]	AQUA ZOOKA - 24"	<p>Soak your friends with Aqua Zooka! This easy to operate, quick filling water bazooka is constructed of high-impact thermoplastics, and will last for seasons of fun. Simply dip Aqua Zooka into the water and pull back on the handle to siphon water up into the barrel. You're ready to fire, with a range of up to 60 feet! Aqua Zooka's are equipped with comfortable EVA handles so that you won't lose your grip, even with wet hands in the heat of battle! The EVA handles also ensure that Aqua Zooka will float on top of the water. Doubles as a bilge pump or household siphon!</p> <p> </p> <ul> <li>Shoots up to 60 feet</li> <li>Comfortable EVA Handle</li> <li>Floats on the water</li> <li>Doubles as a bilge pump</li> <li>High Impact Thermoplastic construction</li> <li>Fills quickly</li> </ul> <p> </p> <ul> <li>Height: 2"</li> <li>Length: 24"</li> <li>Width: 5"</li> </ul>	[empty string]	N	14.99	14.99	[empty string]	102865-DEFAULT-s.jpg	[empty string]	1000	AZ-24	367645	EMPTY	EMPTY	EMPTY	0	0	0	INFLATABLES	[empty string]	kwik-tek/aqua-zooka-24-367645	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts15 ORDER BY sortposition asc

Watersports

Sort By:

Items per page:

Filter