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 NATURAL NATURAL GEAR Natural Gear HUNTING Hunting NATURAL|NULL|NULL 1 29.99 0 59.99 257-DEFAULT-l.jpg 29.99 257-DEFAULT-m.jpg NATURAL GEAR MNS STORM WFOWL G N AMAZON [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 465 .NATURALGEARSTORMWATERFOWLG [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 9 50-to-100 0.00 [empty string] Natural Gear Storm Waterfowl Gloves <p>Every hunter knows how vital it is to keep your hands warm. No matter what type of prey you're stalking keeping your hands warm and dry is paramount for being ready to take that perfect shot. This insulated hunting glove will keep your hands toasty warm and is constructed of a durable 600D Hard Shell Material that won't wear out after putting it to the test over the course of a few hunts. This technical hunting glove is also waterproof, keeping your hands dry, even in the dampest conditions. The Grip palm and Insulation add another layer of durability while maintaining flexibility when it's crucial to make your shot quickly. These camo hunting gloves have Cinch Strap wrist closures ensure a snug fit to retain heat. Whether you're up against, water, snow, or ice the Natural Gear Insulated Waterfowl Glove will keep your hands warm and mobile, all you need to do is focus on the hunt.</p><ul><li>600D Hard Shell Material</li><li>Waterproof</li><li>Windproof</li><li>Flexible Grip Palm</li><li>Fixed Insulation</li><li>Cinch Strap Wrist</li><li>Draw Cord Closure</li></ul> [empty string] N 59.99 59.99 L,XL,2X 257-DEFAULT-s.jpg [empty string] 1000 1000 820 76215 EMPTY EMPTY EMPTY 0 0 0 EMPTY natural-gear/natural-gear-storm-waterfowl-gloves-76215 820 0
2 [empty string] BURR PAW Burr Paw HUNTING Hunting [empty string] 1 29.99 0 29.99 28586-DEFAULT-l.jpg 29.99 28586-DEFAULT-m.jpg BURR PAW STICKER REMOVER N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 6124 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 17 25-to-50 0.00 [empty string] Burr Paw Sticker Remover <p>Your Burr Paw Sticker/Burr Removal Tool is non-abrasive, meaning it will not damage clothing or skin. The puncture-resistant liner provides an extra layer of protection during use. Easy to maintain - after rubbing the affected area, use the cleaning card included to scrape larger stickers off the mitten. Reusable in the field or at home to keep gear, pets, and clothing clean. Gift idea - for any man or woman in your life interested in hunting, fishing, climbing, hiking, shooting, farming, ranching, ATV riding, bird watching, or conservation.</p><p><br /><strong>Specifications</strong></p><ul><li>SIMPLE BURR REMOVAL - The Burr Paw burr removal accessory tool is an easy fix for removing burrs from clothing</li><li>KEEP GEAR CLEAN - No more burrs covering your clothing, your hunting gear, or your pets fur</li><li>NON-ABRASIVE - Your Burr Paw sticker/burr removal tool is non-abrasive</li><li>GIFT IDEA - Gift idea for any man or woman in your life interested in hunting</li><li>EASY TO MAINTAIN - After rubbing the affected area, use the cleaning card included to scrape larger stickers off the mitten</li></ul> [empty string] N 29.99 29.99 [empty string] 28586-DEFAULT-s.jpg [empty string] 1000 1000 79830418799 227344 EMPTY EMPTY EMPTY 0 0 0 EMPTY burr-paw/burr-paw-sticker-remover-227344 79830418799 0
3 RT_TIMBER PRIMAL Primal HUNTING Hunting RT_TIMBER|NULL|NULL 1 129.99 0 139.99 22630-DEFAULT-l.jpg 129.99 22630-DEFAULT-m.jpg PURSUIT GEAR THE RINGER N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 6195 RA200BW [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 36 100-to-150 0.00 [empty string] Primal Treestands The Ringer Blind <ul><li>Footprint 55&quot;x55&quot; </li><li>210D RT Timber with a Black Interior PU Coating </li><li>Loop &amp; Toggle Window closures and RT Timber 50D camo mesh window coverings </li><li>Triangle Zipper Door </li><li>Includes carry bag, ground stakes, &amp; ropes</li></ul> [empty string] N 139.99 139.99 [empty string] 22630-DEFAULT-s.jpg [empty string] 1000 1000 PFHB-709 242924 EMPTY EMPTY EMPTY 0 0 0 EMPTY primal/primal-treestands-the-ringer-blind-242924 PFHB-709 0
4 RT_EXCAPE PRIMAL Primal HUNTING Hunting RT_EXCAPE|NULL|NULL 1 199.99 0 199.99 22631-DEFAULT-l.jpg 199.99 22631-DEFAULT-m.jpg PURSUIT GEAR THE OUTLOOK N AMAZON [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 6195 RA200BW [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 5 150-to-200 0.00 [empty string] Primal Treestands The Outlook Blind <p>With 270 one-way viewing windows, the Primal Outdoors Outlook 270 ground blind gives you a complete view of your surroundings without being seen! With a 60&quot; x 60&quot; footprint, the Outlook 270 is large enough to bring your favorite hunting buddy along.</p><p> </p><p><strong>FEATURES</strong></p><ul><li>Footprint 60&quot;x60&quot;</li><li>210D RT Excape W/ 270 Surround View One-Way, See-Through Silent Slide Windows and Black Interior PU Coating</li><li>Brushloops Included</li><li>Triangle Zipper Door</li><li>Includes carry bag, ground stakes, &amp; ropes</li><li>270 degree one-way viewing windows</li><li>3 full-width horizontal silent-slide shooting windows</li></ul><p><strong>DIMENSIONS</strong></p><p>76&quot; Hub to Hub shooting width</p><p>Carry weight: 15.8lbs<br />Pack size: 7.9&quot; x 7.9&quot; x 43.7&quot;<br />Height: 67&quot;</p><p>12&quot; x 4&quot; one-way rear view window with camp button and loop cover</p><p> </p> [empty string] N 199.99 199.99 [empty string] 22631-DEFAULT-s.jpg [empty string] 1000 1000 PFHB-712 242925 EMPTY EMPTY EMPTY 0 0 0 EMPTY primal/primal-treestands-the-outlook-blind-242925 PFHB-712 0
5 [empty string] PRIMAL Primal HUNTING Hunting [empty string] 1 99.99 0 99.99 22629-DEFAULT-l.jpg 99.99 22629-DEFAULT-m.jpg PURSUIT GEAR SWIVEL CHAIR N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 6195 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 7 50-to-100 0.00 [empty string] Primal Treestands Swivel Chair PTOC-272 <p>Primal Treestands PTOC-272 - Adjustable Deluxe Steel Swivel Chair - PTOC-272</p><p><strong>FEATURES</strong></p><ul><li>Seat size - 17.75&quot; x 13.5&quot;</li><li>Comfortable Black Textilene Fabric</li><li>Lightweight and Portable with Fold-in Legs</li><li>Silent Swivel Design</li><li>Adjustable Feed for uneven ground</li><li>Includes armrests</li><li>Steel construction</li></ul><p> </p> [empty string] N 99.99 99.99 [empty string] 22629-DEFAULT-s.jpg [empty string] 1000 1000 POSC-272 242926 EMPTY EMPTY EMPTY 0 0 0 EMPTY primal/primal-treestands-swivel-chair-ptoc-272-242926 POSC-272 0
6 [empty string] PRIMAL Primal HUNTING Hunting [empty string] 1 99.99 0 99.99 33428-DEFAULT-l.jpg 99.99 33428-DEFAULT-m.jpg PRIMAL ADJUSTABLE STEEL SWIVEL CHAIR XL N AMAZON [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] [empty string] [empty string] [empty string] [empty string] 2 50-to-100 0.00 [empty string] Primal Magnum Silent Swivel Blind Chair [empty string] [empty string] N 99.99 99.99 [empty string] 33428-DEFAULT-s.jpg [empty string] 1000 1000 POSC-276 252878 EMPTY EMPTY EMPTY 0 0 0 EMPTY primal/primal-magnum-silent-swivel-blind-chair-252878 POSC-276 0
CACHED false
EXECUTIONTIME 0
SQL SELECT * FROM GetALLProducts4 ORDER BY sortposition asc