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] UMERX GERMANY Umerx Germany FIREARMS Firearms>Tactical [empty string] 1 449.99 0 449.99 10329-DEFAULT-l.jpg 449.99 10329-DEFAULT-m.jpg WALTHER HAMMERLI TAC R1 N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] UMERX GERMANY WALTHER ARMS RIFLE 22LR [empty string] 4133 [empty string] [empty string] ITEM CAN BE ADDED TO WISH LIST [empty string] [empty string] [empty string] 2-NIB [empty string] 0 400-to-450 0.00 [empty string] Walther Hammerli Tac R1 22 LR 16.10" Threaded Barrel | Matte Black Metal & 5 Position Black Stock <p><p><strong><em><span style="color:red">PLEASE NOTE:</span> If the customer<span style="color:red"> provides the FFL </span>for the order firearms usually </em></strong><span style="color:red"><strong><em>ship in 5-7 business days</em></strong></span><strong><em>.</em> If we have to contact the FFL and obtain the license please expect<span style="color:red"> 7-14 days</span> processing time. <span style="color:red">Send all FFLs to FFL@SIMMONSSG.COM</span></strong></p></p><p>This Walther Hammerli Tac R1 rifle features a 5-position stock, aluminum upper and lower receiver, flip-up sights and a matte black finish.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>Brand Hammerli Arms</li><li>Category Rimfire Rifles</li><li>Caliber 22 LR</li><li>Barrel Length Range 16&quot; to 16.99&quot;</li><li>Model Tac R1</li><li>Stock Finish Group Black</li><li>Capacity 20+1</li><li>Stock Material Synthetic</li><li>Action Semi-Auto</li><li>OAL 35.83&quot;</li><li>Hand Right</li><li>Sights Flip Up Front &amp; Rear</li><li>Size Full Size</li><li>Barrel Finish Matte Black</li><li>Muzzle Flash Hider</li><li>Gun Platform AR-Style</li><li>Grips Black Polymer</li><li>Receiver Material Aluminum</li><li>Safety Ambidextrous</li><li>Stock Description 5 Position</li><li>Barrel Length 16.10&quot;</li><li>Max Capacity 20</li><li>Receiver Finish Matte Black</li><li>Weight 5.62 lbs</li><li>Stock Finish Black</li></ul><p><p>The purchaser of a hand gun must be 21 years of age or older. The purchaser is responsible for knowing his/her state and federal gun laws. Federal gun laws and regulations prohibits the transfer of a handgun to an out of state resident, therefore the &quot;pick up in store&quot; option is not avaliable to non Louisiana residents.</p><p>The purchaser of a long gun must be 18 years of age. The purchaser is responsible for knowing his/her state and federal gun laws.</p><p> </p><p><strong>WARNING: Cancer and Reproductive Harm:</strong> p65warnings.ca.gov</p><p> </p><p> </p> <p><strong><em><span style="color:red">PLEASE NOTE:</span> If the customer<span style="color:red"> provides the FFL </span>for the order firearms usually </em></strong><span style="color:red"><strong><em>ship in 5-7 business days</em></strong></span><strong><em>.</em> If we have to contact the FFL and obtain the license please expect<span style="color:red"> 7-14 days</span> processing time. <span style="color:red">Send all FFLs to FFL@SIMMONSSG.COM</span></strong></p></p> [empty string] N 449.99 449.99 [empty string] 10329-DEFAULT-s.jpg [empty string] 1000 1000 5760500 65888 EMPTY EMPTY EMPTY 0 0 0 TACTICAL umerx-germany/walther-hammerli-tac-r1-22-lr-16-10-threaded-barrel-matte-black-metal-5-position-black-stock-65888 5760500 0
2 BLK MISSION FT Mission Ft SHOOTING Shooting>Accessories>Magazine BLK|NULL|NULL 1 14.99 1 9.99 10258-DEFAULT-l.jpg 14.99 10258-DEFAULT-m.jpg MFT 5.56 30 ROUND BLK MAG N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 5558 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 770 5-to-10 0.00 [empty string] Standard Polymer Magazine AR-15 5.56x45mm/.223 Remington/.300 AAC Blackout Black Bagged <p>Designed for the AR15/M4 but allowing use with a wide range of non-AR15/M4 platforms.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>Brand Mission First Tactical</li><li>Category Magazines</li><li>Caliber 223 Rem</li><li>Model Extreme Duty</li><li>Capacity 30rd</li><li>Color Black</li><li>Material Polymer</li><li>Firearm Fit AR-15</li><li>Max Capacity 30</li></ul><p> </p> [empty string] Y 9.99 9.99 30 10258-DEFAULT-s.jpg [empty string] 1000 1000 EXDPM556BL 115208 MAGAZINE EMPTY EMPTY 0 0 0 EMPTY mission-ft/standard-polymer-magazine-ar-15-5-56x45mm-223-remington-300-aac-blackout-black-bagged-115208 EXDPM556BL 0
3 BLK MISSION FT Mission Ft SHOOTING Shooting>Accessories>Magazine BLK|NULL|NULL 1 14.99 1 9.99 6405-DEFAULT-l.jpg 14.99 6405-DEFAULT-m.jpg MFT 5.56 30 ROUND BLK MAG N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 5558 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 202 5-to-10 0.00 [empty string] Standard Polymer Magazine AR-15 5.56x45mm/.223 Remington/.300 AAC Blackout Black Bagged <p>Designed for the AR15/M4 but allowing use with a wide range of non-AR15/M4 platforms.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>Brand Mission First Tactical</li><li>Category Magazines</li><li>Caliber 223 Rem</li><li>Model Extreme Duty</li><li>Capacity 30rd</li><li>Color Black</li><li>Material Polymer</li><li>Firearm Fit AR-15</li><li>Max Capacity 30</li></ul><p> </p> [empty string] Y 9.99 9.99 30 6405-DEFAULT-s.jpg [empty string] 1000 1000 SCPM556BAG-BL 115210 MAGAZINE EMPTY EMPTY 0 0 0 EMPTY mission-ft/standard-polymer-magazine-ar-15-5-56x45mm-223-remington-300-aac-blackout-black-bagged-115210 SCPM556BAG-BL 0
4 [empty string] BIG GAME TREESTANDS Big Game Treestands NEW BUILDS New Builds [empty string] 1 119.99 1 99.99 33776-DEFAULT-l.jpg 119.99 33776-DEFAULT-m.jpg BIG GAME CAPTAIN XL N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1085 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1 50-to-100 0.00 [empty string] Big Game Captain XL Hang On <p>The Big Game Captain XL treestand offers optimal comfort with a 14&quot; wide x 12&quot; deep Flex-tek seat that flips back for full platform use. A flip-up footrest is included for maximum comfort as well keeping you in the field longer as you await for the opportunity of a lifetime. The platform measures 24&quot;&quot; wide by 30&quot;&quot; deep giving you a spacious amount of room. The Captain XL weighs 17 Lbs. and fastens to the tree with the included 2&quot; nylon strap. A four-point full body harness is included for security to the tree. Weight rated to 300 Lbs.</p><p><strong>Features:</strong></p><ul><li>Fully packable</li><li>Lightweight, fold flat design</li><li>Includes (1) 2&quot; Nylon Strap with Slide Buckle Fastener</li></ul><p><strong>Specifications:</strong></p><ul><li>CONSTRUCTION: Steel</li><li>FOOT PLATFORM: 24&quot; Wide x 30&quot; Deep</li><li>SEAT: 14&quot; Wide x 12&quot; Deep, Flips Back</li><li>STAND WEIGHT: 17 Lbs.</li><li>WEIGHT RATING: 300 Lbs.</li><li>SEAT STYLE: 2&quot; Thick, Sling Style</li><li>SEAT HEIGHT: 20&quot;</li><li>PACKABLE: Yes</li><li>FASTENERS: 1-2&quot; Nylon Strap with Slide Buckle</li><li>SAFETY: Fall Arrest System</li><li>MINIMUM TREE SIZE: 9&quot; Diameter</li><li>Item #BGM-FP0100</li><li>UPC: 097973002506</li></ul> [empty string] Y 99.99 99.99 [empty string] 33776-DEFAULT-s.jpg [empty string] 1000 1000 BGM-FP0100 124489 TREESTANDS LOCK-ONS EMPTY 0 0 0 STANDS & BLINDS big-game-treestands/big-game-captain-xl-hang-on-124489 BGM-FP0100 0
5 [empty string] BIG GAME TREESTANDS Big Game Treestands NEW BUILDS New Builds [empty string] 1 149.99 1 119.99 33778-DEFAULT-l.jpg 149.99 33778-DEFAULT-m.jpg BIG GAME CAPTAIN XC N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1085 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 8 100-to-150 0.00 [empty string] Big Game Captain XC Fixed Position Hang On <p>The Big Game Captain XC treestand offers optimal comfort with a 20&quot; wide x 15&quot; deep Flex-Tek seat. The flip-up seat and a flip-up footrest is included for full platform use and maximum comfort. Additional features like the 16&quot; wide x 11&quot; deep removable backrest and padded armrests make this treestand ideal for the all day hunt! The 20 LB stand fastens to the tree with the included 2&quot; nylon Stealth Strap system. A four-point full body harness is included for security to the tree. </p><p><strong>FEATURES:</strong></p><ul><li>20x15&quot;d. Flip-up Flex-Tek seat with padded armrests</li><li>16x11&quot;d. removable backrest</li><li>24x30&quot; foot platform with flip-up footrest</li><li>Durable steel construction</li><li>Packable, folds flat for easy transport</li><li>Includes 2&quot; nylon strap with side buckle</li><li>300-lb. weight capacity</li><li>20 lbs.</li></ul> [empty string] Y 119.99 119.99 [empty string] 33778-DEFAULT-s.jpg [empty string] 1000 1000 BGM-FP0150 124490 TREESTANDS LOCK-ONS EMPTY 0 0 0 STANDS & BLINDS big-game-treestands/big-game-captain-xc-fixed-position-hang-on-124490 BGM-FP0150 0
6 [empty string] BIG GAME TREESTANDS Big Game Treestands HUNTING Hunting>Stands & Blinds>Treestands>Ladder Stands [empty string] 1 319.99 1 219.99 4091-DEFAULT-l.jpg 319.99 4091-DEFAULT-m.jpg BIG GAME DEFENDER TRIPOD SALE N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1085 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 3 200-to-250 0.00 [empty string] Big Game Defender 12.5' Tripod <p>You'll have a commanding view in all directions seated on top of the Big Game Treestands The Defender Tripod Stand. Crafted of durable steel, the defender measures 12.5-ft. tall from the ground to the shooting rail. Built-in ladder allows easy entry and exit. Padded, full-surround shooting rail steadies your shots. The generous 32&quot;W x 32&quot;D platform adds comfortable leg room and a place to set your pack. Product meets industry standards recognized by TMA. Ht: 40&quot; to shooting rail. Platform size: 32&quot;W x 32&quot;D. Wt: 115 lbs. Wt. capacity: 300 Lbs.</p> [empty string] Y 219.99 219.99 [empty string] 4091-DEFAULT-s.jpg [empty string] 1000 1000 BGM-TP7000 124493 TREESTANDS LADDER STANDS EMPTY 0 0 0 STANDS & BLINDS big-game-treestands/big-game-defender-12-5-tripod-124493 BGM-TP7000 0
7 [empty string] BIG GAME TREESTANDS Big Game Treestands HUNTING Hunting>Stands & Blinds>Treestands>Ladder Stands [empty string] 1 379.99 1 279.99 12619-DEFAULT-l.jpg 379.99 12619-DEFAULT-m.jpg BIG GAME APEX TRIPOD SALE N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1085 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 5 250-to-300 0.00 [empty string] Big Game Apex Tripod <p><strong>DESCRIPTION:</strong></p><p>Get up above it all with the The Apex Tripod Stand from Big Game Treestands. This sturdy, all-steel 12.5' stand makes hunting easier with a seat and shooting rail that rotate 360 , allowing you to quickly and quietly draw a bead on any deer that crosses your path. The padded shooting rail flips back out of the way for bowhunters and comes off completely when needed. Seat: 19&quot;x14&quot;. Backrest cushion: 19&quot;x18&quot;. Platform: 36&quot; diameter. Weight: 115 lbs. Maximum weight capacity: 300 lbs.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>Heavy-duty, flexible steel tripod stand</li><li>Seat and shooting rail rotate 360 - follow game easily</li><li>12.5' tall</li><li>Padded shooting rail - flips back or removes completely</li><li>Seat: 19&quot;x14&quot;</li><li>Platform: 36&quot; diameter</li><li>Weight: 115 lbs.</li></ul> [empty string] Y 279.99 279.99 [empty string] 12619-DEFAULT-s.jpg [empty string] 1000 1000 BGM-TP9000 124494 TREESTANDS LADDER STANDS EMPTY 0 0 0 STANDS & BLINDS big-game-treestands/big-game-apex-tripod-124494 BGM-TP9000 0
8 [empty string] BIG GAME TREESTANDS Big Game Treestands UNCATEGORIZED Uncategorized [empty string] 0 199.99 0 199.99 [empty string] 199.99 [empty string] BIG GAME HUNTER HD LADDER N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1085 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 2 150-to-200 0.00 [empty string] Big Game Hunter Hd Ladder [empty string] [empty string] N 199.99 199.99 [empty string] [empty string] [empty string] 1000 1000 LS0550 124497 EMPTY EMPTY EMPTY 0 0 0 EMPTY big-game-treestands/big-game-hunter-hd-ladder-124497 LS0550 0
9 [empty string] BIG GAME TREESTANDS Big Game Treestands HUNTING Hunting>Stands & Blinds>Treestands>Ladder Stands [empty string] 1 129.99 0 129.99 7478-DEFAULT-l.jpg 129.99 7478-DEFAULT-m.jpg BIG GAME STEALTH XT N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1085 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 2 100-to-150 0.00 [empty string] Big Game Stealth XT <p>Ladder stands are great to hunt from, but what if you have to move? The Big Game Treestands Stealth XT Ladder Stand makes those decisions easier. Not only is it comfortable and stable, it's light and easy to move and install. Even though the Stealth XT features all-steel construction with crush-resistant oval steel tubing, it weighs in at only 52 lbs. Equipped with a Flex-Tek seat and backrest with padded armrests and 1&quot; removable foam seat pad, a flip-back footrest, and a padded shooting rail that flips out of the way to open a shooting lane if needed. For use on trees with minimum 9&quot; diameter. Includes support bar, 1&quot; ratchet strap, two 1&quot; stabilizer straps, and a TMA-Certified full-body harness. Height to shooting rail: 17'. Seat and backrest: 18&quot;W x 15&quot; D x 12&quot;H. Platform: 19&quot;W x 10&quot;D. Weight: 52 lbs. Maximum weight capacity: 300 lbs.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>Manufacturer model #: LS3810.</li><li>Lightweight and easy to move</li><li>Comfortable and stable</li><li>Tough all-steel construction</li><li>Flex-Tek seat and backrest</li><li>Padded armrests; removable foam seat pad</li><li>Flip-back footrest</li><li>Padded, adjustable shooting rail</li><li>Shooting rail flips back if needed</li><li>Includes support bar, ratchet strap, 2 stabilizer straps</li><li>Includes a TMA-Certified full-body harness</li></ul> [empty string] N 129.99 129.99 [empty string] 7478-DEFAULT-s.jpg [empty string] 1000 1000 LS3810 124498 TREESTANDS LADDER STANDS EMPTY 0 0 0 STANDS & BLINDS big-game-treestands/big-game-stealth-xt-124498 LS3810 0
10 [empty string] HARRIS ENGINEERING I Harris Engineering I SHOOTING Shooting>Accessories>Shooting Rests [empty string] 1 199.99 0 199.99 27884-DEFAULT-l.jpg 199.99 27884-DEFAULT-m.jpg HARRIS BIPOD HBSBR2P N AMAZON,EBAY [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 123 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1 150-to-200 0.00 [empty string] Harris Bipods Swivel BR Picatinny, 6-9", Black Steel/Aluminum, Self Leveling Legs, Rubber Feet <p>Harris bipods clamp to picatinny rail rifles, and have a sling attachment provision. Spring loaded self-leveling folding legs are quickly adjustable for height. Manufactured with heat treated steel and hard alloys, bipods have a black anodized finish.</p> [empty string] N 199.99 199.99 [empty string] 27884-DEFAULT-s.jpg [empty string] 1000 1000 HBSBR2P 137501 SHOOTING RESTS EMPTY EMPTY 0 0 0 EMPTY harris-engineering-i/harris-bipods-swivel-br-picatinny-6-9-black-steel-aluminum-self-leveling-legs-rubber-feet-137501 HBSBR2P 0
CACHED false
EXECUTIONTIME 0
SQL SELECT * FROM GetALLProducts ORDER BY sortposition asc