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 SAGE BOB ALLEN Bob Allen UNCATEGORIZED Uncategorized SAGE|NULL|NULL 0 24.99 1 19.99 [empty string] 24.99 [empty string] BOB ALLEN 240M SHOOTING VEST N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1026 240M..BOBALLEN240MSHOOTINGVEST [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 2 15-to-20 0.00 [empty string] Bob Allen 240m Shooting Vest [empty string] [empty string] Y 19.99 19.99 2XLARGE [empty string] [empty string] 1000 1000 240M 71479 EMPTY EMPTY EMPTY 0 0 0 EMPTY bob-allen/bob-allen-240m-shooting-vest-71479 240M 0
3 BROWN BOB ALLEN Bob Allen UNCATEGORIZED Uncategorized BROWN|NULL|NULL 0 19.99 0 24.99 [empty string] 19.99 [empty string] BOB ALLEN10544 SHOTGUNNR GLV N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1026 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 2 20-to-25 0.00 [empty string] Bob Allen10544 Shotgunnr Glv [empty string] [empty string] N 24.99 24.99 MEDIUM [empty string] [empty string] 1000 1000 10544 91020 EMPTY EMPTY EMPTY 0 0 0 EMPTY bob-allen/bob-allen10544-shotgunnr-glv-91020 10544 0
4 BROWN BOB ALLEN Bob Allen UNCATEGORIZED Uncategorized BROWN|NULL|NULL 0 19.99 0 24.99 [empty string] 19.99 [empty string] BOB ALLEN 10547 SHOTGUNNR GLV N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1026 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 5 20-to-25 0.00 [empty string] Bob Allen 10547 Shotgunnr Glv [empty string] [empty string] N 24.99 24.99 XLARGE [empty string] [empty string] 1000 1000 10547 91021 EMPTY EMPTY EMPTY 0 0 0 EMPTY bob-allen/bob-allen-10547-shotgunnr-glv-91021 10547 0
5 [empty string] BOB ALLEN Bob Allen UNCATEGORIZED Uncategorized [empty string] 0 16.99 0 16.99 [empty string] 16.99 [empty string] BOB ALLEN 1521 GLOVE MED N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1026 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 6 15-to-20 0.00 [empty string] Bob Allen 1521 Glove Med [empty string] [empty string] N 16.99 16.99 MED [empty string] [empty string] 1000 1000 1521-2 91024 EMPTY EMPTY EMPTY 0 0 0 EMPTY bob-allen/bob-allen-1521-glove-med-91024 1521-2 0
6 [empty string] BOB ALLEN Bob Allen SHOOTING Shooting>Accessories>Gun Cases [empty string] 1 14.99 0 14.99 10327-DEFAULT-l.jpg 14.99 10327-DEFAULT-m.jpg BOB ALLEN BA650 SHOTGUN CASE N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1026 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 2 10-to-15 0.00 [empty string] Boyt Harness 16504 Classic Olive Green w/Khaki Panels 600D Nylon 48" Shotgun [empty string] [empty string] N 14.99 14.99 48 10327-DEFAULT-s.jpg [empty string] 1000 1000 16504 91027 GUN CASES EMPTY EMPTY 0 0 0 EMPTY bob-allen/boyt-harness-16504-classic-olive-green-w-khaki-panels-600d-nylon-48-shotgun-91027 16504 0
7 [empty string] BOB ALLEN Bob Allen SHOOTING Shooting>Accessories>Gun Cases [empty string] 1 14.99 0 14.99 10328-DEFAULT-l.jpg 14.99 10328-DEFAULT-m.jpg BOB ALLEN BA650 SHOTGUN CASE N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1026 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1 10-to-15 0.00 [empty string] Boyt Harness 16504 Classic Olive Green w/Khaki Panels 600D Nylon 48" Shotgun [empty string] [empty string] N 14.99 14.99 52 10328-DEFAULT-s.jpg [empty string] 1000 1000 16505 91028 GUN CASES EMPTY EMPTY 0 0 0 EMPTY bob-allen/boyt-harness-16504-classic-olive-green-w-khaki-panels-600d-nylon-48-shotgun-91028 16505 0
8 BRN BOB ALLEN Bob Allen UNCATEGORIZED Uncategorized BRN|NULL|NULL 0 15.99 0 15.99 [empty string] 15.99 [empty string] BOB ALLEN 27523 SHOOTING GLOVE N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1026 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 4 15-to-20 0.00 [empty string] Bob Allen 27523 Shooting Glove [empty string] [empty string] N 15.99 15.99 3XL [empty string] [empty string] 1000 1000 27523 91030 EMPTY EMPTY EMPTY 0 0 0 EMPTY bob-allen/bob-allen-27523-shooting-glove-91030 27523 0
9 [empty string] BOB ALLEN Bob Allen SHOOTING Shooting>Accessories>Gun Cases [empty string] 1 129.99 0 149.99 1607-DEFAULT-l.jpg 129.99 1607-DEFAULT-m.jpg BOB ALLEN H52SG LONG GUN N AMAZON,EBAY [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1026 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 2 100-to-150 0.00 [empty string] Boyt Single Long Gun Case <ul><li>Internal dimensions: 52&quot;&quot; x 11.5&quot;&quot; x 4.5&quot;&quot;</li><li>External dimensions: 53.5&quot;&quot; x 14&quot;&quot; x 5&quot;&quot;</li><li>Weight: 13.5 lbs.</li><li>Made in the USA</li><li>Water resistant &amp; dust proof O-ring full length gasket</li><li>Padlock compatible</li><li>All steel powder coated draw latches</li><li>Steel hinge pins</li><li>Fully stackable</li><li>4-Draw latches</li><li>Collapsible, comfort grip handle</li><li>Carry handle</li><li>No wheels</li><li>Egg crate foam (not customizable)</li><li>Compact dimensions meets most standard airline luggage/TSA requirements</li></ul> [empty string] N 149.99 149.99 [empty string] 1607-DEFAULT-s.jpg [empty string] 1000 1000 40156 91032 GUN CASES EMPTY EMPTY 0 0 0 EMPTY bob-allen/boyt-single-long-gun-case-91032 40156 0
10 [empty string] BOB ALLEN Bob Allen UNCATEGORIZED Uncategorized [empty string] 0 119.99 0 129.99 [empty string] 119.99 [empty string] BOB ALLEN H48SG CASE N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1026 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1 100-to-150 0.00 [empty string] Bob Allen H48sg Case [empty string] [empty string] N 129.99 129.99 [empty string] [empty string] [empty string] 1000 1000 H48SG 91038 EMPTY EMPTY EMPTY 0 0 0 EMPTY bob-allen/bob-allen-h48sg-case-91038 H48SG 0
CACHED false
EXECUTIONTIME 0
SQL SELECT * FROM GetALLProducts ORDER BY sortposition asc