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] BIG SHOT Big Shot HUNTING Hunting [empty string] 1 69.99 0 69.99 2181-DEFAULT-l.jpg 69.99 2181-DEFAULT-m.jpg BIG SHOT TARGET BALLISTIC 450X NEW N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 4545 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 2 50-to-100 0.00 [empty string] Big Shot Target Ballistic 450x [empty string] [empty string] N 69.99 69.99 [empty string] 2181-DEFAULT-s.jpg [empty string] 1000 1000 102 124589 EMPTY EMPTY EMPTY 0 0 0 EMPTY big-shot/big-shot-target-ballistic-450x-124589 102 0
2 [empty string] DAKOTA DECOY Dakota Decoy HUNTING Hunting [empty string] 1 189.99 0 199.99 1972-DEFAULT-l.jpg 189.99 1972-DEFAULT-m.jpg DAKOTA DECOY MALLARD FLOATER 12PK FLOCKED HEADS N AMAZON,EBAY [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 4016 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 67 150-to-200 0.00 [empty string] Dakota Decoy X-Treme Mallard Decoys - 12 Pack Flocked Heads <p>Here in the heart of Central Flyway, we are blessed with season long bunches of mallards. From our state hatched birds in October to the latest migrating flocks in December, they seem to never end! We took our time on our mallards and have designed unquestionably the most life like duck decoy on the market.</p><p>The first thing you will notice is the most life like, hand painted finish ever put on a hunting decoy. Our drakes go through a 24 step painting process, and our hens go through a 16 step painting process. This attention to detail is evident the minute you lay eyes on these decoys!</p><p>Upon further inspection you will notice the 6 different head styles in each dozen. These multiple heads come attached to the decoy, but will spin a full 360 degrees, to give your spread the most realistic look ever achieved with decoys.</p><p>These decoys are manufactured out of the same 60/40 blend of high and low density polyethylene that has been proven extra tough on our goose decoys. We are able to attain the most durable paint possible, to give you years of trouble free use. The decoys are slightly oversized, measuring 16&quot; in length. They have a weighted keel designed with the hunter in mind. We've added a cleat to the front of the keel to lengthen or shorten lines to the desired depth of water.</p><p>The decoys are packaged in dozen packs with 7 drakes with 4 unique head styles, and 5 hens with 2 head styles. One look at these and you'll agree... duck hunting will never be the same!</p> [empty string] N 199.99 199.99 [empty string] 1972-DEFAULT-s.jpg [empty string] 1000 1000 12120 131737 EMPTY EMPTY EMPTY 0 0 0 EMPTY dakota-decoy/dakota-decoy-x-treme-mallard-decoys-12-pack-flocked-heads-131737 12120 0
3 [empty string] DAKOTA DECOY Dakota Decoy HUNTING Hunting [empty string] 1 299.99 1 269.99 2253-DEFAULT-l.jpg 299.99 2253-DEFAULT-m.jpg DAKOTA DECOY FULLY FLOCKED WHITEFRONT N AMAZON,EBAY [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 4016 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 10 250-to-300 0.00 [empty string] Dakota Decoy X-Treme Speck Whitefront Flocked 6 Pack <p>Dakota Decoy Whitefront decoys are by far the most realist Speck decoys available. Our Speck decoys will bring the much expanding speck population to a halt! These decoys are built Dakota Tuff and will be the envy of all speck hunters. The decoys are a one-piece decoy for ease of hunting. The heads are molded into the body, so once you attach the base, these are truly a one piece, TANK! Our specks are constructed with our EVA blend soft material to insure they will withstand everyday abuse hunters deliver to their decoys. Decoys come in 6 packs, which include 3 feeders, 2 actives and 1 sentry. The flocking on the fully flocked decoys will help with hunters worst nightmare...Moisture! Flocked decoys look better when wet. You will not get the wet shine that painted decoys suffer. </p><p><strong>SPECIFICATIONS</strong></p><ul><li>Weight - 20 lbs</li><li>Dimensions - 24.0 x 21.0 x 17.0 inches</li></ul><p> </p><p> </p><p> </p><p> </p><p> </p> [empty string] Y 269.99 269.99 [empty string] 2253-DEFAULT-s.jpg [empty string] 1000 1000 12285 131750 EMPTY EMPTY EMPTY 0 0 0 EMPTY dakota-decoy/dakota-decoy-x-treme-speck-whitefront-flocked-6-pack-131750 12285 0
4 [empty string] DAKOTA DECOY Dakota Decoy HUNTING Hunting [empty string] 1 139.99 0 139.99 13584-DEFAULT-l.jpg 139.99 13584-DEFAULT-m.jpg DAKOTA DECOY LESSER DECOY BAG N AMAZON,EBAY [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 4016 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 4 100-to-150 0.00 [empty string] Dakota Decoy Lesser Decoy Bag <p>Dakota 12 slot lesser bag zipper top 12 individual slots to haul and protect your dakota decoy lesser floaters full bodies. Bag dimensions: 36l x 28w x 24h, slots - 9.5 x 9 x 23 built tough of heavy duty PVC!</p> [empty string] N 139.99 139.99 [empty string] 13584-DEFAULT-s.jpg [empty string] 1000 1000 12500 131753 EMPTY EMPTY EMPTY 0 0 0 EMPTY dakota-decoy/dakota-decoy-lesser-decoy-bag-131753 12500 0
5 [empty string] DAKOTA DECOY Dakota Decoy HUNTING Hunting [empty string] 1 99.99 0 119.99 964-DEFAULT-l.jpg 99.99 964-DEFAULT-m.jpg DAKOTA DECOY PINTAIL FLOATER 6 PACK N AMAZON,EBAY [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 4016 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 33 100-to-150 0.00 [empty string] Dakota Decoy X-Treme Pintail Decoys 6 Pack <p>Dakota Decoy introduces our newest member of our growing family our X-Treme Pintails!</p><p>The new pintails have detail never before seen on hunting decoys. These decoys will fool even the wariest of ducks. We've carved the fine feather detail of both the drake and hen and then proceeded to paint them to the high standards you have become accustom to from Dakota Decoy.</p><p>The decoys are constructed of our special blend of polyethylene making them virtually indestructible.</p><p>The Pintails are packaged in 6 packs with 3 drakes and 3 hens. All heads turn 360 degrees giving your spread a custom look! Decoys feature a 21&quot; fiberglass stake to get up above the vegetation. All backed by the best paint warranty in the business....if it falls or flakes off, we replace! </p><p><strong>FEATURES</strong></p><ul><li>Fine feather detail</li><li>Painted to the highest of standards</li><li>Virtually indestructible</li><li>6 Pack</li></ul><p> </p><p> </p> [empty string] N 119.99 119.99 [empty string] 964-DEFAULT-s.jpg [empty string] 1000 1000 13700 131754 EMPTY EMPTY EMPTY 0 0 0 EMPTY dakota-decoy/dakota-decoy-x-treme-pintail-decoys-6-pack-131754 13700 0
6 [empty string] DAKOTA DECOY Dakota Decoy HUNTING Hunting [empty string] 1 39.99 0 44.99 4185-DEFAULT-l.jpg 39.99 4185-DEFAULT-m.jpg DAKOTA REPLACEMENT DRAKE HEADS 7PK N AMAZON,EBAY [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 4016 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 159 25-to-50 0.00 [empty string] Dakota Decoy 7 Pack X-Treme Mallard Flocked Replacement Heads <p>The Dakota Decoy X-Treme Mallard Flocked Replacement Heads let you spend your time making memories and not replacing your decoy heads. It will also help revive your decoy spread and have those mallards flocking back into your hole. </p><p><strong>FEATURES</strong></p><ul><li>Weight 2.0 lbs</li><li>Dimensions 8.0 8.0 4.0 in</li><li>2 tall heads</li><li>3 curved heads</li><li>1 short head </li><li>1 sleeper head</li></ul><p> </p> [empty string] N 44.99 44.99 [empty string] 4185-DEFAULT-s.jpg [empty string] 1000 1000 16000 131755 EMPTY EMPTY EMPTY 0 0 0 EMPTY dakota-decoy/dakota-decoy-7-pack-x-treme-mallard-flocked-replacement-heads-131755 16000 0
7 [empty string] DAKOTA DECOY Dakota Decoy HUNTING Hunting [empty string] 1 99.99 0 109.99 4872-DEFAULT-l.jpg 99.99 4872-DEFAULT-m.jpg DAKOTA DECOY X-TREME GADWALL N AMAZON,EBAY [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 4016 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 17 100-to-150 0.00 [empty string] Dakota Decoy X-treme Gadwall 6 Pack <p>Dakota Decoy is proud to introduce their all new X-Treme Gadwall. The decoys feature the most realistic paint scheme ever seen on a Gadwall decoy. They are slightly oversized, and come in 4 unique body postures. They are packaged in 6 packs with 1 upright drake, 2 resting drakes, 1 upright hen and 2 relaxed hens. They have a weighted keel to hold them down in the windiest conditions. They feature the toughness you have learned to expect with all DD decoys! When conditions get tough... add the most &quot;ducky&quot; looking Gadwall available to your spread!</p><p><strong>SPECIFICATIONS: </strong></p><ul><li>Weight 11.0 lbs</li><li>Dimensions 20.0 17.0 13.0 in</li></ul> [empty string] N 109.99 109.99 [empty string] 4872-DEFAULT-s.jpg [empty string] 1000 1000 17500-2 131760 EMPTY EMPTY EMPTY 0 0 0 EMPTY dakota-decoy/dakota-decoy-x-treme-gadwall-6-pack-131760 17500-2 0
8 SNOW DAKOTA DECOY Dakota Decoy HUNTING Hunting SNOW|NULL|NULL 1 89.99 1 64.99 316-DEFAULT-l.jpg 89.99 316-DEFAULT-m.jpg DAKOTA DECOY X-TREME SOCKS CLOSEOUT N AMAZON,EBAY [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 4016 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 14 50-to-100 0.00 [empty string] Dakota Decoy X-Treme Snap Lock Snow & Blue Goose Socks <p><strong>BLUE GOOSE SOCKS 12 PACK</strong></p><p>Dakota Decoy is proud to announce our new X-Treme Snap Lock Blue Goose Wind Socks. These decoys feature a one piece collapsible system that offers the fastest setup and tear down times on the market. The decoys store flat taking up less room and feature a wind vane system which offers the best movement in low wind conditions. The X-treme wind socks also feature a full spine system which holds the sock open in no wind conditions and have a 28&quot; stake to keep the socks above the corn stalks. #19100</p><p><strong>SNOW GOOSE SOCKS 12 PACK</strong></p><p>Dakota Decoy is proud to announce our new X-Treme Snap Lock Snow Goose Wind Socks. These decoys feature a one piece collapsible system that offers the fastest setup and tear down times on the market. The decoys store flat taking up less room and feature a wind vane system which offers the best movement in low wind conditions. The X-treme wind socks also feature a full spine system which holds the sock open in no wind conditions and have a 28&quot; stake to keep the socks above the corn stalks. #18100</p><p><strong>NO ASSEMBLY REQUIRED!!! OPEN AND HUNT!!!</strong></p> [empty string] Y 64.99 64.99 [empty string] 316-DEFAULT-s.jpg [empty string] 1000 1000 18100 131763 EMPTY EMPTY EMPTY 0 0 0 EMPTY dakota-decoy/dakota-decoy-x-treme-snap-lock-snow-blue-goose-socks-131763 18100 0
9 BLUE DAKOTA DECOY Dakota Decoy HUNTING Hunting BLUE|NULL|NULL 1 89.99 1 64.99 4134-DEFAULT-l.jpg 89.99 4134-DEFAULT-m.jpg DAKOTA DECOY X-TREME SOCKS CLOSEOUT N AMAZON,EBAY [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 4016 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 9 50-to-100 0.00 [empty string] Dakota Decoy X-Treme Snap Lock Snow & Blue Goose Socks <p><strong>BLUE GOOSE SOCKS 12 PACK</strong></p><p>Dakota Decoy is proud to announce our new X-Treme Snap Lock Blue Goose Wind Socks. These decoys feature a one piece collapsible system that offers the fastest setup and tear down times on the market. The decoys store flat taking up less room and feature a wind vane system which offers the best movement in low wind conditions. The X-treme wind socks also feature a full spine system which holds the sock open in no wind conditions and have a 28&quot; stake to keep the socks above the corn stalks. #19100</p><p><strong>SNOW GOOSE SOCKS 12 PACK</strong></p><p>Dakota Decoy is proud to announce our new X-Treme Snap Lock Snow Goose Wind Socks. These decoys feature a one piece collapsible system that offers the fastest setup and tear down times on the market. The decoys store flat taking up less room and feature a wind vane system which offers the best movement in low wind conditions. The X-treme wind socks also feature a full spine system which holds the sock open in no wind conditions and have a 28&quot; stake to keep the socks above the corn stalks. #18100</p><p><strong>NO ASSEMBLY REQUIRED!!! OPEN AND HUNT!!!</strong></p> [empty string] Y 64.99 64.99 [empty string] 4134-DEFAULT-s.jpg [empty string] 1000 1000 19100 131765 EMPTY EMPTY EMPTY 0 0 0 EMPTY dakota-decoy/dakota-decoy-x-treme-snap-lock-snow-blue-goose-socks-131765 19100 0
10 [empty string] DAKOTA DECOY Dakota Decoy HUNTING Hunting [empty string] 1 399.99 0 399.99 13580-DEFAULT-l.jpg 399.99 13580-DEFAULT-m.jpg DAKOTA DECOYS SNAP LOCK SOCK N AMAZON,EBAY [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 4016 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 3 350-to-400 0.00 [empty string] Dakota Decoys X-Treme Snap Lock Blue Socks | Pack of 60 <p>Dakota Decoy is proud to announce our new X-Treme Snap Lock Blue Goose Wind Socks. These decoys feature a one piece collapsible system that offers the fastest setup and tear down times on the market. The decoys store flat taking up less room and feature a wind vane system which offers the best movement in low wind conditions. The X-treme wind socks also feature a full spine system which holds the sock open in no wind conditions and have a 28&quot; stake to keep the socks above the corn stalks.</p><p>No assembly required! Open and hunt!</p><p> </p><p> </p> [empty string] N 399.99 399.99 [empty string] 13580-DEFAULT-s.jpg [empty string] 1000 1000 19600 131766 EMPTY EMPTY EMPTY 0 0 0 EMPTY dakota-decoy/dakota-decoys-x-treme-snap-lock-blue-socks-pack-of-60-131766 19600 0
CACHED false
EXECUTIONTIME 0
SQL SELECT * FROM GetALLProducts4 ORDER BY sortposition asc