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 OLIVE RIVERS WEST Rivers West CLOTHING Clothing>Hunting>Bottoms>Men OLIVE|NULL|NULL 1 59.99 0 79.99 12207-DEFAULT-l.jpg 59.99 12207-DEFAULT-m.jpg RIVERS WEST MNS 40 40 WP BIB N AMAZON [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 2832 .RIVERSWEST4040WATERPROBIB [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1 6 50-to-100 0.00 [empty string] Rivers West 40 40 Waterproof Bibs- 2055 <p>40/40 Waterproof Bibs.</p><p><strong>SPECIFICATIONS</strong>:</p><ul><li>100% Seam-Sealed</li><li>Ultra Packable!</li><li>Extra-Tall Back</li><li>Welted Handwarmer Pockets</li><li>Adjustable Suspenders</li><li>Boot-Cut Legs with adjustable Snap Closure</li><li>7 Belt Loops</li><li>Unlined Rain Shell</li></ul> [empty string] N 79.99 79.99 XL,M,L 12207-DEFAULT-s.jpg [empty string] 1000 1000 2055 77394 EMPTY MEN EMPTY 0 0 0 HUNTING rivers-west/rivers-west-40-40-waterproof-bibs-2055-77394 2055 0
3 REALTREE_AP RIVERS WEST Rivers West UNCATEGORIZED Uncategorized REALTREE_AP|NULL|NULL 0 79.99 1 44.99 [empty string] 79.99 [empty string] RIVERS WEST MNS 2138 PANTS N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 2832 .RIVERSWEST2138PANTS [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 2 25-to-50 0.00 [empty string] Rivers West Mns 2138 Pants [empty string] [empty string] Y 44.99 44.99 3X,2X [empty string] [empty string] 1000 1000 2138-1 77395 EMPTY EMPTY EMPTY 0 0 0 EMPTY rivers-west/rivers-west-mns-2138-pants-77395 2138-1 0
4 WIDOW_MAKER_BROWN RIVERS WEST Rivers West CLOTHING Clothing>Hunting>Bottoms>Men WIDOW_MAKER_BROWN|NULL|NULL 1 84.99 0 99.99 10116-DEFAULT-l.jpg 84.99 10116-DEFAULT-m.jpg RIVERS WEST MNS PIONEER PANT N AMAZON [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 2832 .RIVERSWESTPIONEERPANT [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1 7 50-to-100 0.00 [empty string] Rivers West Pioneer Pant - 2138 <p> Lightweight, Packable, Waterproof/Breathable, Seam-Sealed</p> [empty string] N 99.99 99.99 M,XL,2X 10116-DEFAULT-s.jpg [empty string] 1000 1000 2138-2 77396 EMPTY MEN EMPTY 0 0 0 HUNTING rivers-west/rivers-west-pioneer-pant-2138-77396 2138-2 0
5 TIMBER RIVERS WEST Rivers West CLOTHING Clothing>Hunting>Bottoms>Men TIMBER|NULL|NULL 1 99.99 0 119.99 10105-DEFAULT-l.jpg 99.99 10105-DEFAULT-m.jpg RIVERS WEST MNS ADIRONDACK PAN N AMAZON [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 2832 .RIVERSWESTADIRONDACKPANT [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1 7 100-to-150 0.00 [empty string] Rivers West Adirondack Pants - 2201 <p>Midweight, Waterproof/Breathable, Seam-Sealed</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>100% Seam-Sealed</li><li>100% Windproof</li><li>6 Suspender Buttons</li><li>2 rear Snap Pockets</li><li>Elasticized Back Waist</li><li>5 Belt Loops</li><li>2 Handwarmer Pockets</li><li>Micro-Fleece Lining</li></ul> [empty string] N 119.99 119.99 S,L,3X 10105-DEFAULT-s.jpg [empty string] 1000 1000 2201 77397 EMPTY MEN EMPTY 0 0 0 HUNTING rivers-west/rivers-west-adirondack-pants-2201-77397 2201 0
6 BREAKUP_COUNTRY RIVERS WEST Rivers West CLOTHING Clothing>Hunting>Bottoms>Women BREAKUP_COUNTRY|NULL|NULL 1 79.99 1 69.99 10128-DEFAULT-l.jpg 79.99 10128-DEFAULT-m.jpg RIVERS WEST WMS RAIN PANT LYNX N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 2832 .RIVERSWESTWMSRAINPANTLYNX [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1 1 50-to-100 0.00 [empty string] Rivers West Womens Rain Pant Lynx - 2802 <p><strong>SPECIFICATIONS:</strong></p><ul><li>- 100% Seam-Sealed</li><li>- 100% Windproof</li><li>- Form-Fitting Comfort Stretch Pant</li><li>- Jean-Styled Front Pockets</li><li>- Cargo Pockets</li><li>- Jean-Styled Rear Pockets</li><li>- 7&quot; Inseam Zippered Vents</li><li>- Belt Loops</li><li>- 12&quot; Contrast Boot Zippers w/Magnetic Closure</li><li>- Micro-Fleece Lining</li></ul> [empty string] Y 69.99 69.99 XL 10128-DEFAULT-s.jpg [empty string] 1000 1000 2802 77398 EMPTY WOMEN EMPTY 0 0 0 HUNTING rivers-west/rivers-west-womens-rain-pant-lynx-2802-77398 2802 0
7 WIDOW_MAKER_BROWN RIVERS WEST Rivers West CLOTHING Clothing>Hunting>Outerwear>Youth WIDOW_MAKER_BROWN|NULL|NULL 1 59.99 0 59.99 10108-DEFAULT-l.jpg 59.99 10108-DEFAULT-m.jpg RIVERS WEST YTH PIONEER JKT N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 2832 .RIVERSWESTPIONEERJUNIORJKT [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1 2 50-to-100 0.00 [empty string] Rivers West Pioneer Junior Jackets - 4138 <p><strong>DESCRIPTION</strong>:</p><p>The Pioneer Jacket Jr is 100% waterproof/windproof, but made with a breathable membrane, cooling Taffeta lining, and all seams fully sealed. This lightweight, early-season youth jacket fully packs into its own hood. Features include (2) handwarmer pockets, comfort-cuffs (minimize water penetration down your sleeve when arms are raised), a fixed visor-hood (rain disperses around the visor instead of dripping in front of your face and obscuring your vision), and dual snap toggles to cinch the jacket tight to your waist during inclement weather.</p><p><strong>SPECIFICATIONS</strong>:</p><ul><li>Lightweight and Ultra Packable</li><li>Packs into own Hood</li><li>Fixed Hood wi Visor</li><li>Double Storm Placket</li><li>(2) Zippered Handwarmer Pockets</li><li>Comfort Cuffs</li><li>Adjustable Snap Sides</li><li>Taffeta Lining</li></ul> [empty string] N 59.99 59.99 14/16 10108-DEFAULT-s.jpg [empty string] 1000 1000 4138 77399 OUTERWEAR YOUTH EMPTY 0 0 0 HUNTING rivers-west/rivers-west-pioneer-junior-jackets-4138-77399 4138 0
8 BLACK RIVERS WEST Rivers West CLOTHING Clothing>Hunting>Outerwear>Men BLACK|NULL|NULL 1 139.99 1 69.99 10119-DEFAULT-l.jpg 139.99 10119-DEFAULT-m.jpg RIVERS WEST MNS FULL METAL JKT N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 2832 .RIVERSWESTFULLMETALJACKET [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1 1 50-to-100 0.00 [empty string] Rivers West Full Metal Jacket - 5081 <p><strong>SPECIFICATIONS:</strong></p><p>- 100% Seam-Sealed<br />- 100% Windproof<br />- 2 Detachable Holster Rig w/Conceal Plate<br />- 2 Built-in Shoulder Harness<br />- Left or Right-Handed Compatible<br />- Cross-Draw or Strong-Side Draw Capable<br />- Zippered Chest Pocket<br />- 2 Zippered Handwarmer Pockets<br />- 2 Hidden Strong-Side Draw Pockets<br />- 2Hidden exterior zippers provide access to your firearm<br />- Comfort Cuffs<br />- Adjustable Bottom Draw-cords<br />- Taffeta Lining</p> [empty string] Y 69.99 69.99 L 10119-DEFAULT-s.jpg [empty string] 1000 1000 5081 77401 OUTERWEAR MEN EMPTY 0 0 0 HUNTING rivers-west/rivers-west-full-metal-jacket-5081-77401 5081 0
9 WIDOW_MAKER_BROWN RIVERS WEST Rivers West CLOTHING Clothing>Hunting>Outerwear>Men WIDOW_MAKER_BROWN|NULL|NULL 1 89.99 0 99.99 10112-DEFAULT-l.jpg 89.99 10112-DEFAULT-m.jpg RIVERS WEST MNS PIONEER JACKET N AMAZON [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 2832 .RIVERSWESTPIONEERJACKET [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1 7 50-to-100 0.00 [empty string] Rivers West Pioneer Jackets- 5139 <p>Rivers West Pioneer Jacket.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>100% Seam-Sealed</li><li>100% Windproof</li><li>Lightweight and ultra packable</li><li>Fixed hood with visor</li><li>Zippered handwarmer pockets</li><li>Comfort cuffs</li><li>Adjustable bottom hem</li><li>Taffeta Lined</li></ul> [empty string] N 99.99 99.99 L,3X,M 10112-DEFAULT-s.jpg [empty string] 1000 1000 5138-2 77403 OUTERWEAR MEN EMPTY 0 0 0 HUNTING rivers-west/rivers-west-pioneer-jackets-5139-77403 5138-2 0
10 TIMBER RIVERS WEST Rivers West UNCATEGORIZED Uncategorized TIMBER|NULL|NULL 1 99.99 0 119.99 10102-DEFAULT-l.jpg 99.99 10102-DEFAULT-m.jpg RIVERS WEST MNS ADIRONDACK JKT N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 2832 .RIVERSWESTADIRONDACKJKT [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1 5 100-to-150 0.00 [empty string] Rivers West Adirondack Jackets- 5201 <p>Rivers West Adirondack Jacket.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>100% Seam-Sealed</li><li>100% Windproof</li><li>Fixed Hood</li><li>2-Way Adjustable Hood</li><li>Vertical Zippered Chest pocket</li><li>Heavy Duty Center Front Zipper</li><li>Adjustable Snap Sides</li><li>2 Zippered Handwarmer Pockets</li><li>Comfort Cuffs</li><li>Micro-Fleece Lining</li></ul> [empty string] N 119.99 119.99 M,L,XL,2X 10102-DEFAULT-s.jpg [empty string] 1000 1000 5201 77405 OUTERWEAR MEN EMPTY 0 0 0 HUNTING rivers-west/rivers-west-adirondack-jackets-5201-77405 5201 0
CACHED false
EXECUTIONTIME 0
SQL SELECT * FROM GetALLProducts ORDER BY sortposition asc