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]	PLANO	Plano	FISHING	Fishing>Gear Storage>Rod Tubes and Cases	[empty string]	1	89.99	0	89.99	47412-DEFAULT-l.jpg	89.99	47412-DEFAULT-m.jpg	PLANO AIRLINE ROD CASE 4588-00	N	7 BRYAN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	9	50-to-100	0.00	[empty string]	GUIDE SERIES - AIRLINER ROD TUBE	<p>If your next fishing adventure involves air travel, make sure your treasured rods have adequate protection from drops and rough handling. Plano's Guide Series Airliner Telescoping Rod Tube extends from 47 inches to 88 inches, and can secure up to eight seven-foot rods. Plus, a convenient and comfortable handle makes carrying it a breeze.</p> <h3> </h3> <ul> <li>Collapses to 47 inches in length for easy storage</li> <li>Holds up to eight 7-foot rods</li> <li>Three-tier design</li> <li>Convenient carry handle</li> </ul> <p> </p> <ul> <li>Dimensions: 47”-88” L x 9.75” W x 5.5” H</li> <li>Diameter: 4.5" tube</li> <li>Extends to 88" long</li> </ul>	[empty string]	N	89.99	89.99	[empty string]	47412-DEFAULT-s.jpg	[empty string]	1000	4588-00	55195	ROD TUBES AND CASES	EMPTY	EMPTY	0	0	0	GEAR STORAGE	[empty string]	plano/guide-series-airliner-rod-tube-55195	1
2	[empty string]	PLANO	Plano	FISHING	Fishing>Gear Storage>Rod Tubes and Cases	[empty string]	1	89.99	0	89.99	107017-DEFAULT-l.jpg	89.99	107017-DEFAULT-m.jpg	PLANO GUIDE SERIES ROD CASE	N	7 BRYAN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	50-to-100	0.00	[empty string]	GUIDE SERIES - ADJUSTABLE ROD TUBE - LARGE	<p>Synthetic baits have quickly become a favorite lure among many anglers. However, oily liquids and strong odors can create a mess inside your tackle box or bag. The Liqua-Bait Locker System provides three leak-proof containers that give you easy access without the traditional hassles associated with these baits. The LBL Bottle allows you to easily store liquid baits and remove them just as easily with the provided bait grabber. The screw-top lid ensures a tight fit that keeps the mess in the bottle and nowhere else.</p> <p> </p> <ul> <li>4.25" diameter giving enough room and protection to safely transport your fishing rods</li> <li>Case adjusts to hold rods up to 8.5 feet in length</li> <li>Foam padding protects rod tips from damage</li> <li>Improved locking system for added security during travel - Convenient carry handle</li> </ul> <p> </p> <ul> <li>Dimensions: 63.625”-106” L x 4.25” W x 4.25” H</li> </ul>	[empty string]	N	89.99	89.99	[empty string]	107017-DEFAULT-s.jpg	[empty string]	1000	46102-0	150899	ROD TUBES AND CASES	EMPTY	EMPTY	0	0	0	GEAR STORAGE	[empty string]	plano/guide-series-adjustable-rod-tube-large-150899	1
3	TAN	REDINGTON	Redington	FISHING	Fishing>Gear Storage>Rod Tubes and Cases	TAN\|NULL\|NULL	1	49.99	1	39.99	109537-DEFAULT-l.jpg	49.99	109537-DEFAULT-m.jpg	ROD TRAVEL CASE WITH REEL	N	7 BRYAN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	33	25-to-50	0.00	[empty string]	ROD TRAVEL CASE WITH REEL	<p>Protect your gear with these durable tubes designed to hold 2-piece or 4-piece rods and reels. These tubes accommodate 9', 10', 11'6", and 13'6" rod lengths. This case features an adjustable shoulder strap with a D-ring for convenient hanging, and plastic reinforced caps at the ends ensure your travel case will last through many fishing adventures.</p> <p> </p> <ul> <li>YKK Zipper</li> <li>Plastic reinforced caps</li> <li>Adjustable shoulder strap</li> <li>D-ring for convenient hanging</li> </ul> <p> </p> <ul> <li>90-2: 9' 2-Piece case actual length: 58"</li> <li>90-4: 9' 4-Piece case actual length: 31"</li> <li>100-4: 10' 4-Piece case actual length: 34"</li> <li>116-4: 11' 6" 4-Piece case actual length: 38.5" - Rods with downlocking reel seats only, <strong>DUALLY Switch Rods</strong> will not work with this case.</li> <li>136-4: 13' 6" 4-Piece case actual length: 45"</li> </ul>	[empty string]	N	39.99	49.99	90-4,90-2,90-2D,100-4,100-4D	109537-DEFAULT-s.jpg	[empty string]	1000	5-RTC	310437	ROD TUBES AND CASES	EMPTY	EMPTY	0	0	0	GEAR STORAGE	[empty string]	redington/rod-travel-case-with-reel-310437	1
4	[empty string]	NEW PHASE FLY FISHING	New Phase Fly Fishing	FISHING	Fishing>Gear Storage>Rod Tubes and Cases	[empty string]	1	24.99	0	24.99	109361-DEFAULT-l.jpg	24.99	109361-DEFAULT-m.jpg	ROD TUBE	N	7 BRYAN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	4	20-to-25	0.00	[empty string]	ROD TUBE	<p>This 30” rod tube is made with ABS and nylon, zip closure. Includes foam ends to protect rod tips. Inside length of 30” fits a 4 piece 9 foot rod.</p>	[empty string]	N	24.99	24.99	[empty string]	109361-DEFAULT-s.jpg	[empty string]	1000	1813	310639	ROD TUBES AND CASES	EMPTY	EMPTY	0	0	0	GEAR STORAGE	[empty string]	new-phase-fly-fishing/rod-tube-310639	1
5	TAN	REDINGTON	Redington	FISHING	Fishing>Gear Storage>Rod Tubes and Cases	TAN\|NULL\|NULL	1	29.99	0	29.99	109536-DEFAULT-l.jpg	29.99	109536-DEFAULT-m.jpg	ROD TRAVEL ROD TUBE	N	7 BRYAN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	11	25-to-50	0.00	[empty string]	ROD TUBE	<p>Looking for something durable to keep your favorite fly rod in? Maybe the one you have has seen better days?</p> <p> </p> <ul> <li>Holds up to 10' length rods</li> <li>YKK Zipper</li> <li>Plastic reinforced caps</li> <li>Adjustable shoulder strap</li> <li>D-ring for convenient hanging</li> </ul> <p> </p> <ul> <li>90-2: 9' 2-Piece case actual length: 58"</li> <li>90-4: 9' 4-Piece case actual length: 31"</li> <li>100-4: 10' 4-Piece case actual length: 34"</li> </ul>	[empty string]	N	29.99	29.99	90-2,100-4	109536-DEFAULT-s.jpg	[empty string]	1000	5-RT	310926	ROD TUBES AND CASES	EMPTY	EMPTY	0	0	0	GEAR STORAGE	[empty string]	redington/rod-tube-310926	1
6	O03	SIMMS	Simms	FISHING	Fishing>Gear Storage>Rod Tubes and Cases	O03\|NULL\|NULL	1	99.99	0	99.99	106729-DEFAULT-l.jpg	99.99	106729-DEFAULT-m.jpg	GTS DOUBLE ROD/REEL VAULT	N	7 BRYAN	[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	50-to-100	0.00	[empty string]	GTS DOUBLE ROD REEL CASE	<p>Crush and weather-resistant rod case for two singlehand 9-foot, 4-piece rods, plus reels.</p> <p> </p> <ul> <li>Highly durable and crush-resistant compression molded ballistic nylon with 200D polyester lining</li> <li>Carries two singlehand 4-piece rods, plus reels up to size 12</li> <li>Padded, removable shoulder strap and reinforced grab handle for comfortable, easy carry</li> <li>Loop velcro field inside for the last fly of the day</li> </ul> <p> </p> <ul> <li>Fabric Tech: Outer Shell: 1680D Polyester Ballistic & 420/660D CORDURA ripstop</li> <li>Dimensions: 34" L x 5" W x 6" H</li> </ul> <p> </p>	[empty string]	N	99.99	99.99	[empty string]	106729-DEFAULT-s.jpg	[empty string]	1000	13080	340049	ROD TUBES AND CASES	EMPTY	EMPTY	0	0	0	GEAR STORAGE	[empty string]	simms/gts-double-rod-reel-case-340049	1
7	003	SIMMS	Simms	FISHING	Fishing>Gear Storage>Rod Tubes and Cases	003\|NULL\|NULL	1	199.99	0	199.99	106728-DEFAULT-l.jpg	199.99	106728-DEFAULT-m.jpg	GTS ROD AND REEL VAULT	N	7 BRYAN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	4	150-to-200	0.00	[empty string]	GTS ROD AND REEL VAULT	<p>Crush and weather-resistant molded case for collecting and protecting rods, reels and other tackle while on the move.</p> <p> </p> <ul> <li>Highly durable and crush-resistant compression molded ballistic nylon with 200D polyester lining</li> <li>Clamshell zippered opening to main compartment, zippered face pocket, mesh pockets in lid</li> <li>Holds up to six 9'6" 4-piece rods and eight reels/spools with internal straps and dividers</li> <li>Reinforced daisy chains for lashing to GTS Roller 110L and webbing loop for attachment to other luggage</li> </ul> <p> </p> <ul> <li>Fabric Tech: Outer shell: 1680D Polyester Ballistic; Face Pocket: 420/660D CORDURA ripstop with double-sided PU coating; Lining: 200D polyester w/ foam padding</li> <li>Dimensions: 32.5” L x 9” W x 6” H</li> </ul>	[empty string]	N	199.99	199.99	[empty string]	106728-DEFAULT-s.jpg	[empty string]	1000	13076	341944	ROD TUBES AND CASES	EMPTY	EMPTY	0	0	0	GEAR STORAGE	[empty string]	simms/gts-rod-and-reel-vault-341944	1
8	[empty string]	STRIKEMASTER	Strikemaster	FISHING	Fishing>Gear Storage>Rod Tubes and Cases	[empty string]	1	10.99	0	10.99	99906-DEFAULT-l.jpg	10.99	99906-DEFAULT-m.jpg	SMART HUB ROD STORAGE	N	7.1 RANDY	[empty string]	[empty string]	[empty string]	ICE	[empty string]	[empty string]	[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	10-to-15	0.00	[empty string]	SMARTHUB - ROD STORAGE	<p>The Rapala SmartHub is the ultimate, versatile system that gives you endless options to interchange and adjust for your needs. A single SmartHub can be used independently or choose the Track to easily expand your accessory options.</p> <p> </p> <ul> <li>Stores most rod & reel combos</li> <li>Tool only - attaches to a SmartHub mount (sold separately)</li> </ul>	[empty string]	N	10.99	10.99	[empty string]	99906-DEFAULT-s.jpg	[empty string]	1000	RSHROD	368925	ROD TUBES AND CASES	EMPTY	EMPTY	0	0	0	GEAR STORAGE	[empty string]	strikemaster/smarthub-rod-storage-368925	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts525 ORDER BY sortposition asc

Fishing

Sort By:

Items per page:

Filter