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 [empty string] BOWTECH Bowtech ARCHERY Archery>Accessories>Stabilizers [empty string] 1 49.99 0 49.99 5772-DEFAULT-l.jpg 49.99 5772-DEFAULT-m.jpg BOWTECH 90731TSN OCTANE N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 842 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1 25-to-50 0.00 [empty string] Bowtech 90731tsn Octane Balance X Stabilizer <p>Octane Balance-X Stabilizer 7-11&quot; Treestand Most advanced and adjustable stabilizer with it's dampening material will neutralize vibration for a noticeably smoother shot. A fully customizable length of 7&quot;-11&quot; you can choose the length and weight that is right for your bow set-up. Quick adjustability extends or retracts with just a twist to lock or unlock. Adjustable weights give you the ability to add or subtract the weights to customize your stabilizer to fit your bow performance. Advanced dampening material neutralizes any vibration in your shot. Weights included with stabilizer. Mass Weight: .4 lbs. ,Size: 7-11&quot;, Color: Treestand, Size: 7-11&quot;, Manufacturer: DIAMOND BY BOWTECH, Model: 60151</p> [empty string] N 49.99 49.99 [empty string] 5772-DEFAULT-s.jpg [empty string] 1000 1000 90731TSN 91570 STABILIZERS EMPTY EMPTY 0 0 0 EMPTY bowtech/bowtech-90731tsn-octane-balance-x-stabilizer-91570 90731TSN 0
3 SUBALPINE BOWTECH Bowtech UNCATEGORIZED Uncategorized SUBALPINE|NULL|NULL 0 849.99 0 849.99 [empty string] 849.99 [empty string] BOWTECH SOLUTION N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 842 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1 500-or-more 0.00 [empty string] Bowtech Solution [empty string] [empty string] N 849.99 849.99 [empty string] [empty string] [empty string] 1000 1000 A10616 91578 EMPTY EMPTY EMPTY 0 0 0 EMPTY bowtech/bowtech-solution-91578 A10616 0
4 BLACK BOWTECH Bowtech UNCATEGORIZED Uncategorized BLACK|NULL|NULL 1 599.99 0 599.99 7517-DEFAULT-l.jpg 599.99 7517-DEFAULT-m.jpg BOWTECH AMPLIFY N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 842 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 5 500-or-more 0.00 [empty string] Bowtech Amplify <p><strong>ADJUSTS TO ANYONE, DOMINATES EVERYTHING IN ITS CLASS</strong></p><p> </p><ul><li>Versatility and performance at a price that doesn't break the bank.</li><li>Forgiving enough for the beginner archer and deadly enough to fill the freezer.</li><li>Highly adjustable to fit virtually any archer.</li></ul><p>MASS WEIGHT<br />4.0 LBS<br />Lighter bows can be great for mobility while adding weight or dampeners can virtually eliminate vibration. <br />DRAW LENGTH<br />21&quot; - 30&quot;<br />Compound bows have an adjustable draw length range and should be set to fit your unique body size and shape. <br />DRAW WEIGHT<br />8 - 70 LBS<br />Max draw weights can typically be reduced by 10lbs. This provides comfortable draw cycles for everyone while maximizing energy. <br />SPEED<br />335 FPS<br />Today's average bow speeds offer more forgiveness on the shot than ever. Faster bows can deliver more downrange energy. <br />AXLE TO AXLE<br />31.5&quot;<br />Longer bows can increase stability while shorter bows can be better suited for maneuverability and tight spaces.<br />BRACE HEIGHT<br />6&quot;<br />A longer brace height can offer more forgiveness on the shot while a shorter brace height can make a fast bow even faster.</p> [empty string] N 599.99 599.99 [empty string] 7517-DEFAULT-s.jpg [empty string] 1000 1000 A10800 91585 EMPTY EMPTY EMPTY 0 0 0 EMPTY bowtech/bowtech-amplify-91585 A10800 0
5 BREAKUP_COUNTRY BOWTECH Bowtech UNCATEGORIZED Uncategorized BREAKUP_COUNTRY|NULL|NULL 1 599.99 0 599.99 30334-DEFAULT-l.jpg 599.99 30334-DEFAULT-m.jpg BOWTECH AMPLIFY N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 842 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 6 500-or-more 0.00 [empty string] Bowtech Amplify <p><strong>ADJUSTS TO ANYONE, DOMINATES EVERYTHING IN ITS CLASS</strong></p><p> </p><ul><li>Versatility and performance at a price that doesn't break the bank.</li><li>Forgiving enough for the beginner archer and deadly enough to fill the freezer.</li><li>Highly adjustable to fit virtually any archer.</li></ul><p>MASS WEIGHT<br />4.0 LBS<br />Lighter bows can be great for mobility while adding weight or dampeners can virtually eliminate vibration. <br />DRAW LENGTH<br />21&quot; - 30&quot;<br />Compound bows have an adjustable draw length range and should be set to fit your unique body size and shape. <br />DRAW WEIGHT<br />8 - 70 LBS<br />Max draw weights can typically be reduced by 10lbs. This provides comfortable draw cycles for everyone while maximizing energy. <br />SPEED<br />335 FPS<br />Today's average bow speeds offer more forgiveness on the shot than ever. Faster bows can deliver more downrange energy. <br />AXLE TO AXLE<br />31.5&quot;<br />Longer bows can increase stability while shorter bows can be better suited for maneuverability and tight spaces.<br />BRACE HEIGHT<br />6&quot;<br />A longer brace height can offer more forgiveness on the shot while a shorter brace height can make a fast bow even faster.</p> [empty string] N 599.99 599.99 [empty string] 30334-DEFAULT-s.jpg [empty string] 1000 1000 A10802 91587 EMPTY EMPTY EMPTY 0 0 0 EMPTY bowtech/bowtech-amplify-91587 A10802 0
6 OD_GREEN BOWTECH Bowtech UNCATEGORIZED Uncategorized OD_GREEN|NULL|NULL 1 599.99 0 649.99 7298-DEFAULT-l.jpg 599.99 7298-DEFAULT-m.jpg BOWTECH AMPLIFY N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 842 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 3 500-or-more 0.00 [empty string] Bowtech Amplify <p><strong>ADJUSTS TO ANYONE, DOMINATES EVERYTHING IN ITS CLASS</strong></p><p> </p><ul><li>Versatility and performance at a price that doesn't break the bank.</li><li>Forgiving enough for the beginner archer and deadly enough to fill the freezer.</li><li>Highly adjustable to fit virtually any archer.</li></ul><p>MASS WEIGHT<br />4.0 LBS<br />Lighter bows can be great for mobility while adding weight or dampeners can virtually eliminate vibration. <br />DRAW LENGTH<br />21&quot; - 30&quot;<br />Compound bows have an adjustable draw length range and should be set to fit your unique body size and shape. <br />DRAW WEIGHT<br />8 - 70 LBS<br />Max draw weights can typically be reduced by 10lbs. This provides comfortable draw cycles for everyone while maximizing energy. <br />SPEED<br />335 FPS<br />Today's average bow speeds offer more forgiveness on the shot than ever. Faster bows can deliver more downrange energy. <br />AXLE TO AXLE<br />31.5&quot;<br />Longer bows can increase stability while shorter bows can be better suited for maneuverability and tight spaces.<br />BRACE HEIGHT<br />6&quot;<br />A longer brace height can offer more forgiveness on the shot while a shorter brace height can make a fast bow even faster.</p> [empty string] N 649.99 649.99 [empty string] 7298-DEFAULT-s.jpg [empty string] 1000 1000 A10804 91589 EMPTY EMPTY EMPTY 0 0 0 EMPTY bowtech/bowtech-amplify-91589 A10804 0
7 OD_GREEN BOWTECH Bowtech ARCHERY Archery>Compound Bow OD_GREEN|NULL|NULL 1 1699.99 1 1449.99 18050-DEFAULT-l.jpg 1699.99 18050-DEFAULT-m.jpg BOWTECH CARBON ONE N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 842 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1 500-or-more 0.00 [empty string] Bowtech Carbon One <ul><li>A whole new look in Carbon bows. Flowing, sexy lines that stand far above the competitors.</li><li>The only carbon bow featuring the smoothest experience before, during, and after the shot.</li><li>Equipped with the DeadLock Cam System: the quickest and simplest way to achieve perfect arrow flight and repeatable accuracy.</li><li>The strategically engineered carbon riser, coupled with the Orbit Dampeners virtually eliminates all felt vibration on the shot.</li><li>Features the Integrate Mounting System dovetail for use with arrow rests equipped with IMS.</li><li>The strategically positioned Orbit Dampeners virtually eliminate vibration and noise on the shot.</li></ul><p> </p> [empty string] Y 1449.99 1449.99 [empty string] 18050-DEFAULT-s.jpg [empty string] 1000 1000 A11289 91597 EMPTY EMPTY EMPTY 0 0 0 EMPTY bowtech/bowtech-carbon-one-91597 A11289 0
8 COUNTRY_DNA BOWTECH Bowtech ARCHERY Archery>Compound Bow COUNTRY_DNA|NULL|NULL 1 1099.99 0 1099.99 18051-DEFAULT-l.jpg 1099.99 18051-DEFAULT-m.jpg BOWTECH CP30 N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 842 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1 500-or-more 0.00 [empty string] Bowtech CP30 <p><strong>MASS WEIGHT</strong><br />4.5 LBS<br />Lighter bows can be great for mobility while adding weight or dampeners can virtually eliminate vibration. Video Popup Link<br /><strong>DRAW LENGTH</strong><br />25&quot; - 30.5&quot;<br />Compound bows have an adjustable draw length range and should be set to fit your unique body size and shape. Video Popup Link<br /><strong>DRAW WEIGHT</strong><br />50, 60, 70 LBS<br />Max draw weights can typically be reduced by 10lbs. This provides comfortable draw cycles for everyone while maximizing energy. Video Popup Link<br /><strong>SPEED</strong><br />331 FPS<br />Today's average bow speeds offer more forgiveness on the shot than ever. Faster bows can deliver more downrange energy. Video Popup Link<br /><strong>AXLE TO AXLE</strong><br />30&quot;<br />Longer bows can increase stability while shorter bows can be better suited for maneuverability and tight spaces. Video Popup Link<br /><strong>BRACE HEIGHT</strong><br />6.75&quot;<br />A longer brace height can offer more forgiveness on the shot while a shorter brace height can make a fast bow even faster. </p> [empty string] N 1099.99 1099.99 [empty string] 18051-DEFAULT-s.jpg [empty string] 1000 1000 A13919 91607 EMPTY EMPTY EMPTY 0 0 0 EMPTY bowtech/bowtech-cp30-91607 A13919 0
9 [empty string] BRAGG Bragg HUNTING Hunting>Calls>Waterfowl [empty string] 1 69.99 0 69.99 16167-DEFAULT-l.jpg 69.99 16167-DEFAULT-m.jpg BRAGGIN RIGHTS BAR BREAKER N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 6087 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 2 50-to-100 0.00 [empty string] Braggin Rights Bar Breaker Speck Call <p>Here's a little about me and Bragging Rights Cut Down Calls.. I began chasing ducks at an early age with my dad and uncle in the famous Boeuf River Swamp near Columbia, La. Ever since killing my first mallard at the age of 8 years old, I've been hooked on duck hunting. As most hunters chase ducks to find the hot spot, I progressed into hunting the rice fields of North Louisiana and South Arkansas. I upped my game and started guiding in 1995. I've guided many hunters all around Louisiana and Arkansas for 26 years, and I currently guide for Arkansas County Guide Service . I have a passion for &quot;cutting&quot; down old &quot;Olt duck calls as well as other calls.. after many years I finally took my love for duck hunting and cutting &quot;Olts&quot; to a new level when I started Bragging Rights Cutdown Calls. During the off season, you can find me cutting calls at my home in Calhoun, Louisiana. </p><p> </p> [empty string] N 69.99 69.99 [empty string] 16167-DEFAULT-s.jpg [empty string] 1000 1000 BB 91664 WATERFOWL EMPTY EMPTY 0 0 0 EMPTY bragg/braggin-rights-bar-breaker-speck-call-91664 BB 0
10 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
CACHED false
EXECUTIONTIME 0
SQL SELECT * FROM GetALLProducts ORDER BY sortposition asc