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 SORTPOSITION STYLE STYLE_ID SUBTYP1 SUBTYP2 SUBTYP3 TERMSALE TERMSALELISTPRICE TERMSALEPRICE TYP URL WEBSTYLE WEIGHTED_SEARCH
1 [empty string] BRAGG Bragg HUNTING Hunting [empty string] 1 69.99 0 69.99 16167-DEFAULT-l.jpg 69.99 16167-DEFAULT-m.jpg BRAGGIN RIGHTS BAR BREAKER N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 6087 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 2 50-to-100 0.00 [empty string] Braggin Rights Bar Breaker Speck Call <p>Here's a little about me and Bragging Rights Cut Down Calls.. I began chasing ducks at an early age with my dad and uncle in the famous Boeuf River Swamp near Columbia, La. Ever since killing my first mallard at the age of 8 years old, I've been hooked on duck hunting. As most hunters chase ducks to find the hot spot, I progressed into hunting the rice fields of North Louisiana and South Arkansas. I upped my game and started guiding in 1995. I've guided many hunters all around Louisiana and Arkansas for 26 years, and I currently guide for Arkansas County Guide Service . I have a passion for &quot;cutting&quot; down old &quot;Olt duck calls as well as other calls.. after many years I finally took my love for duck hunting and cutting &quot;Olts&quot; to a new level when I started Bragging Rights Cutdown Calls. During the off season, you can find me cutting calls at my home in Calhoun, Louisiana. </p><p> </p> [empty string] N 69.99 69.99 [empty string] 16167-DEFAULT-s.jpg [empty string] 1000 1000 BB 91664 EMPTY EMPTY EMPTY 0 0 0 EMPTY bragg/braggin-rights-bar-breaker-speck-call-91664 BB 0
2 [empty string] AIR BOSS Air Boss HUNTING Hunting [empty string] 1 134.99 1 89.99 9591-DEFAULT-l.jpg 134.99 9591-DEFAULT-m.jpg AIR BOSS BUTT KIKKER DECOY-SALE N AMAZON,EBAY [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 5809 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 11 50-to-100 0.00 [empty string] Air Boss Butt Kikker Feeding Mallard Drake Motion Decoy <p><strong>DESCRIPTION:</strong></p><p>100% Made in America!</p><p>Made in the U.S.A.</p><p>Best Motion Decoy for flooded timber.</p><p>When mallard ducks are feeding in a shallow body of water, they tip their butts up and kick their feet to reach the bottom and feed. The Air Boss Butt Kikker is patent pending and the only feeding mallard decoy on the water with moving feet for the most realistic motion. </p><p>Feet can be bent and adjusted to suit the water and amount of movement you want for your spread. The kicking motion mixed with the wobble of a realistic duck attracts overhead ducks right to your spread.</p><p>Tipped up feeding duck decoy</p><p> </p> [empty string] Y 89.99 89.99 [empty string] 9591-DEFAULT-s.jpg [empty string] 1000 1000 BUTTKICKER 115941 EMPTY EMPTY EMPTY 0 0 0 EMPTY air-boss/air-boss-butt-kikker-feeding-mallard-drake-motion-decoy-115941 BUTTKICKER 0
3 [empty string] AIR BOSS Air Boss HUNTING Hunting [empty string] 1 134.99 1 89.99 9592-DEFAULT-l.jpg 134.99 9592-DEFAULT-m.jpg AIR BOSS BUTT KIKKER DECOY-SALE N AMAZON,EBAY [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 5809 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 8 50-to-100 0.00 [empty string] Air Boss Butt Kikker Feeding Mallard Hen Motion Decoy <p><strong>DESCRIPTION:</strong></p><p>100% Made in America!</p><p>Made in the U.S.A.</p><p>Best Motion Decoy for flooded timber.</p><p>When mallard ducks are feeding in a shallow body of water, they tip their butts up and kick their feet to reach the bottom and feed. The Air Boss Butt Kikker is patent pending and the only feeding mallard decoy on the water with moving feet for the most realistic motion. </p><p>Feet can be bent and adjusted to suit the water and amount of movement you want for your spread. The kicking motion mixed with the wobble of a realistic duck attracts overhead ducks right to your spread.</p><p>Tipped up feeding duck decoy</p><p> </p> [empty string] Y 89.99 89.99 [empty string] 9592-DEFAULT-s.jpg [empty string] 1000 1000 BUTTKICKERHEN 115942 EMPTY EMPTY EMPTY 0 0 0 EMPTY air-boss/air-boss-butt-kikker-feeding-mallard-hen-motion-decoy-115942 BUTTKICKERHEN 0
4 [empty string] AIR BOSS Air Boss HUNTING Hunting [empty string] 1 139.99 1 89.99 9588-DEFAULT-l.jpg 139.99 9588-DEFAULT-m.jpg AIR BOSS WADDER DECOY-SALE N AMAZON,EBAY [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 5809 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 14 50-to-100 0.00 [empty string] Air Boss The Wadder Mallard Drake <p>Made in the U.S.A.<br />Add realistic swimming motion to your spread. The Wadder duck creates ripples in the water that attracts more ducks on an otherwise calm water day. Swimming motion Decoys.<br />Paddling Duck Feet add unbelievable realism to your decoy spread.<br />1 C-cell battery is needed to power the decoy (not included). Available in hen, drake</p> [empty string] Y 89.99 89.99 [empty string] 9588-DEFAULT-s.jpg [empty string] 1000 1000 WADDER 115943 EMPTY EMPTY EMPTY 0 0 0 EMPTY air-boss/air-boss-the-wadder-mallard-drake-115943 WADDER 0
5 [empty string] AIR BOSS Air Boss HUNTING Hunting [empty string] 1 139.99 1 89.99 9589-DEFAULT-l.jpg 139.99 9589-DEFAULT-m.jpg AIR BOSS WADDER DECOY-SALE N AMAZON,EBAY [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 5809 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1 50-to-100 0.00 [empty string] Air Boss The Wadder Hen Decoy <p><strong>DESCRIPTION:</strong></p><p>Made in America<br />Made in the U.S.A.<br />Add realistic swimming motion to your spread. The Wadder duck creates ripples in the water that attracts more ducks on an otherwise calm water day. Swimming motion Decoys.<br />Paddling Duck Feet add unbelievable realism to your decoy spread.<br />1 C-cell battery is needed to power the decoy (not included). Available in hen, drake</p> [empty string] Y 89.99 89.99 [empty string] 9589-DEFAULT-s.jpg [empty string] 1000 1000 WADDERHEN 115944 EMPTY EMPTY EMPTY 0 0 0 EMPTY air-boss/air-boss-the-wadder-hen-decoy-115944 WADDERHEN 0
6 [empty string] AIR BOSS Air Boss HUNTING Hunting [empty string] 1 134.99 1 89.99 9593-DEFAULT-l.jpg 134.99 9593-DEFAULT-m.jpg AIR BOSS WAGGER DECOY-SALE N AMAZON,EBAY [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 5809 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1 50-to-100 0.00 [empty string] Air Boss Wagger Drake Decoy <p><strong>DESCRIPTION:</strong></p><p>Add some motion to your spread! The Wagger duck creates vibrations &amp; ripples in the water that attract more ducks to the water on an otherwise calm water day. 1 C-cell battery is needed to power the decoy (not included). Available in hen, drake or a combination of both! </p><p> </p> [empty string] Y 89.99 89.99 [empty string] 9593-DEFAULT-s.jpg [empty string] 1000 1000 WAGGER 115945 EMPTY EMPTY EMPTY 0 0 0 EMPTY air-boss/air-boss-wagger-drake-decoy-115945 WAGGER 0
7 [empty string] AIR BOSS Air Boss HUNTING Hunting [empty string] 1 109.99 1 69.99 9590-DEFAULT-l.jpg 109.99 9590-DEFAULT-m.jpg AIR BOSS WOBBLER DECOY-SALE N AMAZON,EBAY [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 5809 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 4 50-to-100 0.00 [empty string] Air Boss The Wobbler Motion Drake Decoy <p><strong>DESCRIPTION:</strong></p><p>Add some motion to your spread! The Wobbler duck creates ripples in the water that attracts more ducks to the water on an otherwise calm water day. 1 C-cell battery is needed to power the decoy (not included). Available in hen, drake</p> [empty string] Y 69.99 69.99 [empty string] 9590-DEFAULT-s.jpg [empty string] 1000 1000 WOBBLER 115947 EMPTY EMPTY EMPTY 0 0 0 EMPTY air-boss/air-boss-the-wobbler-motion-drake-decoy-115947 WOBBLER 0
8 MAX_7 BANDED Banded HUNTING Hunting MAX_7|NULL|NULL 1 74.99 0 74.99 21268-DEFAULT-l.jpg 74.99 21268-DEFAULT-m.jpg BANDED NANO SLING BACK PACK N AMAZON,EBAY [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 3934 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 6 50-to-100 0.00 [empty string] Banded Nano Sling Back Pack (Multiple Camo Options) <p>The best bag you'll never know you're wearing. So light, so comfortable and so accessible. Often times while waterfowl hunting, we find ourselves in situations that require us to place our bags in undesirable locations, due to the presence of water. The Banded Nano Sling Pack solves for that. Designed to be used with waders, your necessities will be within arms reach, all throughout the hunt. And, with its ergonomic design, you'll hardly even notice its there, until you need it. <br />Ideal for hunters who walk-in, and stand/sit in the water throughout the hunt. Hunting Examples: Timber, pothole &amp; marshes where water runs up to the edge of surrounding vegetation, boat hunters with limited storage space.<br /> <br /><strong>Features</strong>:</p><ul><li>Bandolier style pack slides around to the front for easy compartment access</li><li>Adjustable shoulder and waist strap accommodates layering</li><li>Shoulder strap shell loops</li><li>Large zippered main storage compartment with technical storage management</li><li>6 Dedicated Storage compartments</li><li>Integrated zip-locked dry bag</li><li>Zippered accessory pouch</li><li>Zippered hard case sunglass pouch</li><li>Elastic water bottle pouch</li></ul> [empty string] N 74.99 74.99 [empty string] 21268-DEFAULT-s.jpg [empty string] 1000 1000 B08652 121283 EMPTY EMPTY EMPTY 0 0 0 EMPTY banded/banded-nano-sling-back-pack-multiple-camo-options-121283 B08652 0
9 [empty string] BANDED Banded HUNTING Hunting [empty string] 1 429.99 0 429.99 5897-DEFAULT-l.jpg 429.99 5897-DEFAULT-m.jpg BANDED AXE COMBO BOAT BL XL N AMAZON,EBAY [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 3934 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1 400-to-450 0.00 [empty string] Banded Axe Combo Boat Blind XL <p>Superior as a boat blind. Unparalleled portability and convenience as a shore blind. Revolutionary as a combo! The Axe Combo Boat/Shore Blind is constructed of a heavy duty square-tubed steel frame and features an easy up and down leg system for 10 second set-up and take-downs. The leg system's &quot;pop-up&quot; design allows for a quick set-up into a roomy, well concealed, weather protected blind or folds down compact in seconds for boating, trailering, or hauling to the spot. Hunters and retriever handlers will also enjoy the convenient in-and-out door that allows easy entry and exit access without having to drop the blind down. The Axe Combo Boat/Shore Blind exterior is fabricated with a heavy-duty 600D cover to block out the elements along with integrated concealment straps to add natural vegetation. We also suggest adding the Axe Blind Camo Skin (sold separately in Timber and Cattail colors) for an amazing 3-D leaf-like foliage and ultimate camouflaging.</p><p><strong>Axe Blind Combo Boat/Shore Blind</strong></p><ul><li>Easy up and down leg system for 10 seconds set up and takedowns</li><li>Quick slide top cover for optimal overhead concealment and easy shooting</li><li>Heavy-duty 600D weather and wind resistant cover</li><li>Adjustable shooting and viewing area</li><li>In-and-out door provides easy entry and exit for dogs and hunters</li><li>Concealment straps for adding natural vegetation</li><li>Available in regular and extra-long models</li><li>Regular size: 44&quot;&quot; x 9' Weight: 62 lbs</li><li>XL Size: 48&quot;&quot; x 11' Weight: 68 lbs</li><li>36&quot;&quot; in the front and 48&quot;&quot; in the rear of the blind</li></ul><p><strong>Axe Boat Blind</strong></p><ul><li>Can be removed quickly and easily from boat</li><li>Inside boat frame design</li><li>Folds down flat to make boating and towing effortless</li></ul><p><strong>Axe Shore Blind</strong></p><ul><li>Axe Shore Blind Leg Kit (sold separately) converts the Axe boat blind into a shore blind in seconds</li></ul> [empty string] N 429.99 429.99 [empty string] 5897-DEFAULT-s.jpg [empty string] 1000 1000 B08692 121286 EMPTY EMPTY EMPTY 0 0 0 EMPTY banded/banded-axe-combo-boat-blind-xl-121286 B08692 0
10 BOTTOMLAND BANDED Banded HUNTING Hunting BOTTOMLAND|NULL|NULL 1 99.99 0 99.99 8675-DEFAULT-l.jpg 99.99 8675-DEFAULT-m.jpg BANDED SWIVEL BLIND CHAIR REG N AMAZON,EBAY [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 3934 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 60 50-to-100 0.00 [empty string] Banded "Regular" Swivel Blind Chairs <p> </p><p>Superior seating for the field. Right up there with scoring &quot;Row 1 at the 50-yard line&quot;. or &quot;Home Plate Seating&quot;, -- The Banded Swivel Blind Chair is the best seat in the game. Glide to the action with 360-degrees of swivel, and at just 12lbs, bring it anywhere. Designed for the pit blind, boat blind, or ground blind. Featuring an ultra-quiet swivel for perfect positioning to take your shot without game-spooking noise. The 3-inch thick comfort-foam seat and 2-inch thick backrest provide long-lasting comfort. The Swivel Blind Chair also folds quickly to stow and transport with ease. The seat is constructed of heavy-duty 600D water-resistant exterior. Metal framework with flared bottom for superior strength and stability. The Swivel Blind Chair by Banded combines durability with comfort like no other hunting stool.</p><p>*Disclaimer: you'll want to make sure you have a good dog, or a good friend... because like every King, you'll want to stay seated in your luxury throne.</p><p><strong>Features</strong></p><ul><li>360-degree swivel for a full range of motion</li><li>Long-wearing Dura-Max 600D water-resistant exterior</li><li>Easily folds for quick storage</li><li>Metal frame with flared bottom for superior strength and stability</li></ul><p><strong>Regular Chair Dimensions</strong></p><ul><li>Seat height: 17&quot;</li><li>Seat Width: 14&quot;</li><li>Backrest Height: 15&quot;</li><li>Seat Cushion thickness: 2&quot;</li><li>Backrest Cushion Thickness: 2&quot;</li></ul> [empty string] N 99.99 99.99 [empty string] 8675-DEFAULT-s.jpg [empty string] 1000 1000 B08704 121293 EMPTY EMPTY EMPTY 0 0 0 EMPTY banded/banded-regular-swivel-blind-chairs-121293 B08704 0
CACHED false
EXECUTIONTIME 0
SQL SELECT * FROM GetALLProducts4 ORDER BY sortposition asc