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] 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
5 [empty string] SLOW GLOW Slow Glow HUNTING Hunting>Cameras>Accessories [empty string] 1 34.99 0 34.99 29132-DEFAULT-l.jpg 34.99 29132-DEFAULT-m.jpg SLOW GLOW MAVERICK T POST CAMERA MOUNT 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 25-to-50 0.00 [empty string] Slow Glow Maverick T Post Camera Mount <p>We took our signature Maverick T-Post Clamp and beefed it up. A larger ballhead combined with a heavy-duty tightening wheel gives our famous Maverick Mount more durability for improved performance. Wrap all that up in a new satin black or red finish and you've got the best trail camera mount in the industry.</p><p>Connect the Maverick to any device with a 1/4&quot; x 20mm thread. Perfect for trail cameras, solar panels, go-pro cameras, and of course our signature Slow Glow Hunting lights. Connects to any 3 sides of a standard t-post.</p> [empty string] N 34.99 34.99 [empty string] 29132-DEFAULT-s.jpg [empty string] 1000 1000 000158 248216 EMPTY EMPTY EMPTY 0 0 0 EMPTY slow-glow/slow-glow-maverick-t-post-camera-mount-248216 000158 0
6 [empty string] SLOW GLOW Slow Glow HUNTING Hunting>Cameras>Game & Trail [empty string] 1 369.99 0 369.99 29133-DEFAULT-l.jpg 369.99 29133-DEFAULT-m.jpg SLOW GLOW SOLR PRO BUNDLE G3 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] 3 350-to-400 0.00 [empty string] Slow Glow Solar Pro Bundle G3 <p>The SolR Pro paired with a Slow Glow Hunting Light is the ultimate combination. The SolR Pro features a powerful 5w solar panel and digital charge controller to keep your system running year-round. When in direct sunlight, the SolR Pro harnesses enough energy to run both your Slow Glow Light and a trail camera year-round. Stop replacing camera batteries every few months and go solar. SolR Pro also features a digital volt meter to monitor your battery's voltage, and provides you a USB power port to charge your phone, GoPro Camera, or other USB device in the woods where power is hard to find. </p><p>SolR Pro is designed to slide on top of a T-Post and swivel 360 degrees to face south for maximum sunlight. Then choose 1 of 6 mounting locations to mount your light, trail camera, or other accessory. We include 1 ball-head pivot mount with every SolR Pro, which allows you to swivel and tighten your light or camera exactly where you want to point it.</p><p>The Slow Glow G3 Hunting Light is our third-generation LED Hunting Light. Your G3 will stay off during the day, and turn itself on automatically at dusk to a dull 5% Training Mode. Once motion is detected in your hunting area, the Slow Glow G3 will slowly increase light intensity over a 2-minute period to avoid spooking game. Wild pigs, exotic game, and predators never realize they're being lit up. Use your light like an alarm and stalk in down wind behind the cover of your Slow Glow after motion is detected. Manually activate your light from more than 100 yards away with the included remote control. G3 easily switches between Red or Green light, and features 2 different lenses for a spot or flood beam pattern. If you hunt with Night Vision, you have to check out our Model IRG3. They'll never know what lit 'em.</p> [empty string] N 369.99 369.99 [empty string] 29133-DEFAULT-s.jpg [empty string] 1000 1000 000172 248217 GAME & TRAIL EMPTY EMPTY 0 0 0 EMPTY slow-glow/slow-glow-solar-pro-bundle-g3-248217 000172 0
7 [empty string] SLOW GLOW Slow Glow HUNTING Hunting>Cameras>Accessories [empty string] 1 34.99 0 34.99 29134-DEFAULT-l.jpg 34.99 29134-DEFAULT-m.jpg SLOW GLOW MAVERICK INFINITY CAMERA MOUNT 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] 8 25-to-50 0.00 [empty string] Slow Glow Maverick Infinity Camera Mount <p>Our newest member of the Maverick family is our INFINITY Trail Camera Mount. This ball-head mount is designed to screw into any tree or hard surface and allow full swing, tilt, and tightening of your device. Our INFINITY kit comes with 3 tree spikes, 1 custom install tool for your cordless drill, a backing nut, and a heavy duty ball-head in flat-black. </p><p>Simply chuck the installation tool into your cordless drill and thread one of the three supplied tree spikes into the tool. Place the drill on forward and screw it into the tree where you want your camera. Reverse the drill and pull the installation tool off the tree spike. Thread on the backing nut and ball-head, followed by your trail camera. Turn, swivel, tilt, and tighten the ball-head exactly where you want your camera pointing. </p> [empty string] N 34.99 34.99 [empty string] 29134-DEFAULT-s.jpg [empty string] 1000 1000 000196 248247 EMPTY EMPTY EMPTY 0 0 0 EMPTY slow-glow/slow-glow-maverick-infinity-camera-mount-248247 000196 0
8 [empty string] SLOW GLOW Slow Glow HUNTING Hunting>Cameras>Accessories [empty string] 1 24.99 0 24.99 29131-DEFAULT-l.jpg 24.99 29131-DEFAULT-m.jpg SLOW GLOW TRAIL CAMERA ADAPTOR KIT 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] 4 20-to-25 0.00 [empty string] Slow Glow Trail Camera Adaptor Kit <p>If you are looking to power a trail camera using our SolR Pro, you'll need a power cord to run from your camera into the SolR Pro and a Goose Ball Head Mount. This upgrade includes both! </p><p>There are hundreds of trail cameras out there, many of them use different size power barrels for external power. The cable we offer is used by the majority of camera companies we've researched, but not all of them. This power cord features a 4.0mmx1.7mm barrel to connect your trail camera to the SolR Pro.</p><p>You are responsible to assure the camera supports 12v accessory power, but these camera companies utilize this popular size cable: WiseEye, Spartain, Snyper, Meidase, Tactacam, and Covert.</p><p>It is important that you verify your trail camera can be powered by 12v auxiliary power. If it is not, you run the risk of damaging your camera. Do not force a barrel connector into place, if it does not fit, we sell adapter connectors. Most cameras will work with no AA batteries in-place, but some cameras will require rechargeable batteries to be installed as a backup power system.</p><p><strong>READ YOUR CAMERAS USER MANUAL TO ENSURE IT WILL WORK WITH OUR 12V AUXILIARY POWER SYSTEM.</strong> We are not responsible for damage to cameras or other accessories that are not meant for 12-volt auxiliary power.</p> [empty string] N 24.99 24.99 [empty string] 29131-DEFAULT-s.jpg [empty string] 1000 1000 000110 248248 EMPTY EMPTY EMPTY 0 0 0 EMPTY slow-glow/slow-glow-trail-camera-adaptor-kit-248248 000110 0
9 [empty string] MAXIM DEFENSE Maxim Defense UNCATEGORIZED Uncategorized [empty string] 0 1499.99 1 1399.99 [empty string] 1499.99 [empty string] MAXIM DEFENSE MD15L 5.56NATO SNIPER GRAY 16" N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] MAXIM DEFENSE [empty string] RIFLE 5.56 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 2-NIB [empty string] 2 500-or-more 0.00 [empty string] Maxim Defense Md15l 5.56nato Sniper Gray 16" [empty string] [empty string] Y 1399.99 1399.99 [empty string] [empty string] [empty string] 1000 1000 MXM-49734 251949 EMPTY EMPTY EMPTY 0 0 0 EMPTY maxim-defense/maxim-defense-md15l-5-56nato-sniper-gray-16-251949 MXM-49734 0
10 [empty string] MAXIM DEFENSE Maxim Defense UNCATEGORIZED Uncategorized [empty string] 0 1499.99 1 1429.99 [empty string] 1499.99 [empty string] MAXIM DEFENSE MD15L 5.56NATO SNIPER GRAY 16" N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] MAXIM DEFENSE [empty string] RIFLE 5.56 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 2-NIB [empty string] 2 500-or-more 0.00 [empty string] Maxim Defense Md15l 5.56nato Sniper Gray 16" [empty string] [empty string] Y 1429.99 1429.99 [empty string] [empty string] [empty string] 1000 1000 MXM-NBS-24 251951 EMPTY EMPTY EMPTY 0 0 0 EMPTY maxim-defense/maxim-defense-md15l-5-56nato-sniper-gray-16-251951 MXM-NBS-24 0
CACHED false
EXECUTIONTIME 0
SQL SELECT * FROM GetALLProducts ORDER BY sortposition asc