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] FN HERSTAL S.A. Fn Herstal S.a. SHOOTING Shooting [empty string] 1 53.99 0 53.99 27486-DEFAULT-l.jpg 53.99 27486-DEFAULT-m.jpg FNH USA 10700012 AMMO N [empty string] [empty string] [empty string] RESTRICTION 2 [empty string] [empty string] [empty string] [empty string] [empty string] 5.7X28 [empty string] 101 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 200 50-to-100 0.00 [empty string] FN 5.7x28mm 27gr HP Lead Free 2100 FPS 50/box <ul><li>5.7X28mm 27 Grain Hollow Point</li><li>Lead-free primer and projectile</li><li>50 Rounds per box</li><li>SS198LF is fully compatible with a wide variety of FN firearms</li><li>Made in Belgium, imported by FNH USA</li></ul><p><p>Many of our images are stock photos from the manufacturer and may not necessarily represent the actual item. Please read the title and description carefully before purchasing.</p><ul><li>You must be 18 to purchase long gun ammunition &amp; 21 for hand gun ammunition.</li><li>We cannot accept returns on ammunition for safety reasons.</li><li>Make sure you use the correct ammunition in your gun.</li><li>Check your local laws and regulations before purchasing ammunition.</li><li>The purchaser is responsible for knowing his/her state laws and restrictions.</li><li>All ammunition is considered hazardous and will be shipped ground, contiguous 48 states only. A street address is required for delivery.</li></ul><p> </p><p><strong>WARNING: Cancer and Reproductive Harm</strong>: <a href="https://www.p65warnings.ca.gov" onclick="window.open(this.href);return false;" onkeypress="window.open(this.href);return false;">p65warnings.ca.gov</a></p></p> [empty string] N 53.99 53.99 [empty string] 27486-DEFAULT-s.jpg [empty string] 1000 1000 10700012 229873 EMPTY EMPTY EMPTY 0 0 0 EMPTY fn-herstal-s-a/fn-5-7x28mm-27gr-hp-lead-free-2100-fps-50-box-229873 10700012 0
2 [empty string] FN HERSTAL S.A. Fn Herstal S.a. SHOOTING Shooting [empty string] 1 49.99 0 49.99 27487-DEFAULT-l.jpg 49.99 27487-DEFAULT-m.jpg FNH USA 10700013 AMMO N [empty string] [empty string] [empty string] RESTRICTION 2 [empty string] [empty string] [empty string] [empty string] [empty string] 5.7X28 [empty string] 101 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 168 25-to-50 0.00 [empty string] FNH USA 5.7x28mm Ammunition 27 Grain Lead Free Hollow Point <p>FNH USA ammo is not only fully compatible with a wide variety of FN Firearms including the venerable Five-Seven pistol, and the P90/PS90 but also in the wide variety of aftermarket similar pattern clones. This particular cartridge uses an innovative lightweight brass jacketed aluminum core hollow point projectile. This cartridge is ideal for a self defense but can also be used for target shooting, training and plinking.</p><p><strong>FNH USA Factory Ammunition Specifications and Features:</strong></p><ul><li>FNH USA 10700013</li><li>5.7x28mm</li><li>27 Grain Lead Free Hollow Point</li><li>Lightweight Brass Jacket</li><li>Aluminum Core Hollow Point Projectile</li><li>SS195LF Lead Free Cartridge</li><li>Brass Cased</li><li>Boxer Primed</li><li>Reloadable</li><li>Uses: Target Shooting, Training, Plinking, and Self Defense</li><li>50 Round Box</li></ul><p><p>Many of our images are stock photos from the manufacturer and may not necessarily represent the actual item. Please read the title and description carefully before purchasing.</p><ul><li>You must be 18 to purchase long gun ammunition &amp; 21 for hand gun ammunition.</li><li>We cannot accept returns on ammunition for safety reasons.</li><li>Make sure you use the correct ammunition in your gun.</li><li>Check your local laws and regulations before purchasing ammunition.</li><li>The purchaser is responsible for knowing his/her state laws and restrictions.</li><li>All ammunition is considered hazardous and will be shipped ground, contiguous 48 states only. A street address is required for delivery.</li></ul><p> </p><p><strong>WARNING: Cancer and Reproductive Harm</strong>: <a href="https://www.p65warnings.ca.gov" onclick="window.open(this.href);return false;" onkeypress="window.open(this.href);return false;">p65warnings.ca.gov</a></p></p> [empty string] N 49.99 49.99 [empty string] 27487-DEFAULT-s.jpg [empty string] 1000 1000 10700013 229874 EMPTY EMPTY EMPTY 0 0 0 EMPTY fn-herstal-s-a/fnh-usa-5-7x28mm-ammunition-27-grain-lead-free-hollow-point-229874 10700013 0
3 [empty string] FN HERSTAL S.A. Fn Herstal S.a. SHOOTING Shooting [empty string] 1 59.99 1 44.99 27488-DEFAULT-l.jpg 59.99 27488-DEFAULT-m.jpg FNH USA SS197SR AMMO BOX N [empty string] [empty string] [empty string] RESTRICTION 2 [empty string] [empty string] [empty string] [empty string] [empty string] 5.7X28 [empty string] 101 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 86 25-to-50 0.00 [empty string] FNH SS197SR 5.7x28 Sporting 40 Grain V-Max 2034 fps <p>FN's uncompromising demand for quality, Federal's unmatched production standards and Hornady's superior V-Max design come together in the iconic 5.7x28mm SS197SR Sporting Cartridge. Often recognized by sight with its diminutive size and bright blue polymer tip, the SS197SR is instantly identified as the prototypical FN 5.7 round. Top of the line components include a Hornady V-Max polymer tip to provide laser like accuracy with devastating terminal performance. The SS197SR is truly a do it all cartridge. From varmint hunting and self-defense to target shooting or competition the SS197SR can do it all. When you think &quot;FN 5.7&quot;, you're really thinking of the SS197SR 5.7x28mm Sporting Cartridge.</p><p><strong>FN Herstal/Federal Cartridge 5.7x28 Sporting Round Specifications and Features:</strong></p><ul><li>FNH Item Number: SS197SR / 10700017</li><li>5.7x28mm</li><li>40 Grains</li><li>Hornady V-Max Polymer Tip Bullet</li><li>Brass Cased</li><li>Muzzle Velocity: 2034 fps</li><li>Muzzle energy: 256 ft/lbs</li><li>Uses: Varmint Hunting, Target Shooting, Competition and Self Defense</li><li>50 Round Box</li></ul><p><p>Many of our images are stock photos from the manufacturer and may not necessarily represent the actual item. Please read the title and description carefully before purchasing.</p><ul><li>You must be 18 to purchase long gun ammunition &amp; 21 for hand gun ammunition.</li><li>We cannot accept returns on ammunition for safety reasons.</li><li>Make sure you use the correct ammunition in your gun.</li><li>Check your local laws and regulations before purchasing ammunition.</li><li>The purchaser is responsible for knowing his/her state laws and restrictions.</li><li>All ammunition is considered hazardous and will be shipped ground, contiguous 48 states only. A street address is required for delivery.</li></ul><p> </p><p><strong>WARNING: Cancer and Reproductive Harm</strong>: <a href="https://www.p65warnings.ca.gov" onclick="window.open(this.href);return false;" onkeypress="window.open(this.href);return false;">p65warnings.ca.gov</a></p></p> [empty string] Y 44.99 44.99 [empty string] 27488-DEFAULT-s.jpg [empty string] 1000 1000 10700016 229875 EMPTY EMPTY EMPTY 0 0 0 EMPTY fn-herstal-s-a/fnh-ss197sr-5-7x28-sporting-40-grain-v-max-2034-fps-229875 10700016 0
4 [empty string] FN HERSTAL S.A. Fn Herstal S.a. SHOOTING Shooting [empty string] 0 79.99 0 79.99 [empty string] 79.99 [empty string] FNH USA 509 201000323 MAG N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 101 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 9 50-to-100 0.00 [empty string] FN 201000323 509 9mm Luger 24 Round Steel <table><tr><td><em><strong>Attribute</strong></em></td><td><em><strong>Value</strong></em></td></tr><tr><td>Caliber</td><td>9mm Luger</td></tr><tr><td>Capacity</td><td>24</td></tr><tr><td>Finish</td><td>Black</td></tr><tr><td>Model</td><td>509</td></tr><tr><td>Material</td><td>Steel</td></tr><tr><td>Type</td><td>Detachable</td></tr><tr><td>Model Fit</td><td>FN 509</td></tr><tr><td>Brand Fit</td><td>FN</td></tr><tr><td>Max Capacity</td><td>24</td></tr><tr><td>Manufacturer Part Number</td><td>201000323 </td></tr></table> [empty string] N 79.99 79.99 [empty string] [empty string] [empty string] 1000 1000 20-100423 229876 EMPTY EMPTY EMPTY 0 0 0 EMPTY fn-herstal-s-a/fn-201000323-509-9mm-luger-24-round-steel-229876 20-100423 0
5 [empty string] FN HERSTAL S.A. Fn Herstal S.a. SHOOTING Shooting [empty string] 1 59.99 1 39.99 12011-DEFAULT-l.jpg 59.99 12011-DEFAULT-m.jpg FNH USA 476952 MAGAZINE N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 101 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 4 25-to-50 0.00 [empty string] Magazine for FNX .40 Smith & Wesson Black 14 Round <table><tr><td><em><strong>Attribute</strong></em></td><td><em><strong>Value</strong></em></td></tr><tr><td>Made In The USA</td><td>Made In The USA</td></tr><tr><td>Caliber</td><td>.40 S&W</td></tr><tr><td>Capacity</td><td>14</td></tr><tr><td>Finish</td><td>Black</td></tr><tr><td>Caliber-Gauge</td><td>.40 S&W</td></tr><tr><td>Manufacturer Part Number</td><td>47695-2 </td></tr></table> [empty string] Y 39.99 39.99 [empty string] 12011-DEFAULT-s.jpg [empty string] 1000 1000 476952 229880 EMPTY EMPTY EMPTY 0 0 0 EMPTY fn-herstal-s-a/magazine-for-fnx-40-smith-wesson-black-14-round-229880 476952 0
6 [empty string] FN HERSTAL S.A. Fn Herstal S.a. SHOOTING Shooting [empty string] 1 59.99 0 59.99 12014-DEFAULT-l.jpg 59.99 12014-DEFAULT-m.jpg FNH USA 476954 MAGAZINE N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 101 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1 50-to-100 0.00 [empty string] Magazine for FNX .40 S&W Black 10 Round <table><tr><td><em><strong>Attribute</strong></em></td><td><em><strong>Value</strong></em></td></tr><tr><td>Made In The USA</td><td>Made In The USA</td></tr><tr><td>Caliber</td><td>.40 S&W</td></tr><tr><td>Capacity</td><td>10</td></tr><tr><td>Finish</td><td>Black</td></tr><tr><td>Caliber-Gauge</td><td>.40 S&W</td></tr><tr><td>Manufacturer Part Number</td><td>47695-4 </td></tr></table> [empty string] N 59.99 59.99 [empty string] 12014-DEFAULT-s.jpg [empty string] 1000 1000 476954 229881 EMPTY EMPTY EMPTY 0 0 0 EMPTY fn-herstal-s-a/magazine-for-fnx-40-s-w-black-10-round-229881 476954 0
7 [empty string] FN HERSTAL S.A. Fn Herstal S.a. SHOOTING Shooting [empty string] 1 59.99 1 29.99 12013-DEFAULT-l.jpg 59.99 12013-DEFAULT-m.jpg FNH USA 663302 MAGAZINE N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 101 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 2 25-to-50 0.00 [empty string] Magazine For FNS 9mm 17 Round Black <table><tr><td><em><strong>Attribute</strong></em></td><td><em><strong>Value</strong></em></td></tr><tr><td>Made In The USA</td><td>Made In The USA</td></tr><tr><td>Caliber</td><td>9mm</td></tr><tr><td>Capacity</td><td>17</td></tr><tr><td>Finish</td><td>Black</td></tr><tr><td>Caliber-Gauge</td><td>9MM LUGER</td></tr><tr><td>Manufacturer Part Number</td><td>66330-2 </td></tr></table> [empty string] Y 29.99 29.99 [empty string] 12013-DEFAULT-s.jpg [empty string] 1000 1000 663302 229882 EMPTY EMPTY EMPTY 0 0 0 EMPTY fn-herstal-s-a/magazine-for-fns-9mm-17-round-black-229882 663302 0
8 [empty string] FN HERSTAL S.A. Fn Herstal S.a. SHOOTING Shooting [empty string] 1 49.99 1 29.99 9513-DEFAULT-l.jpg 49.99 9513-DEFAULT-m.jpg FNH USA SCAR 16S MAGAZINE N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 101 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 3 25-to-50 0.00 [empty string] Magazine for SCAR 16/SCAR 16S 5.56 Flat Dark Earth 30 Round <table><tr><td><em><strong>Attribute</strong></em></td><td><em><strong>Value</strong></em></td></tr><tr><td>Made In The USA</td><td>Made In The USA</td></tr><tr><td>Caliber</td><td>5.56</td></tr><tr><td>Capacity</td><td>30</td></tr><tr><td>Finish</td><td>Flat Dark Earth</td></tr><tr><td>Caliber-Gauge</td><td>.223 REM.</td></tr><tr><td>Manufacturer Part Number</td><td>98880 </td></tr></table> [empty string] Y 29.99 29.99 [empty string] 9513-DEFAULT-s.jpg [empty string] 1000 1000 98880 229884 EMPTY EMPTY EMPTY 0 0 0 EMPTY fn-herstal-s-a/magazine-for-scar-16-scar-16s-5-56-flat-dark-earth-30-round-229884 98880 0
9 [empty string] FN HERSTAL S.A. Fn Herstal S.a. SHOOTING Shooting [empty string] 1 49.99 1 29.99 12012-DEFAULT-l.jpg 49.99 12012-DEFAULT-m.jpg FNH USA 98882 MAGAZINE N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 101 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 4 25-to-50 0.00 [empty string] Magazine for SCAR 16/SCAR 16S 5.56 Black 30 Round <table><tr><td><em><strong>Attribute</strong></em></td><td><em><strong>Value</strong></em></td></tr><tr><td>Made In The USA</td><td>Made In The USA</td></tr><tr><td>Caliber</td><td>5.56</td></tr><tr><td>Capacity</td><td>30</td></tr><tr><td>Finish</td><td>Black</td></tr><tr><td>Caliber-Gauge</td><td>.223 REM.</td></tr><tr><td>Manufacturer Part Number</td><td>98882 </td></tr></table> [empty string] Y 29.99 29.99 [empty string] 12012-DEFAULT-s.jpg [empty string] 1000 1000 98882 229885 EMPTY EMPTY EMPTY 0 0 0 EMPTY fn-herstal-s-a/magazine-for-scar-16-scar-16s-5-56-black-30-round-229885 98882 0
10 [empty string] FN HERSTAL S.A. Fn Herstal S.a. SHOOTING Shooting [empty string] 1 69.99 1 39.99 8438-DEFAULT-l.jpg 69.99 8438-DEFAULT-m.jpg FNH USA 98892 MAGAZINE N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 101 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 14 25-to-50 0.00 [empty string] FNH Magazine for SCAR 17/17S 7.62x51mm NATO Black 20 Round <table><tr><td><em><strong>Attribute</strong></em></td><td><em><strong>Value</strong></em></td></tr><tr><td>Made In The USA</td><td>Made In The USA</td></tr><tr><td>Caliber</td><td>7.62x51mm</td></tr><tr><td>Capacity</td><td>20</td></tr><tr><td>Finish</td><td>Black</td></tr><tr><td>Caliber-Gauge</td><td>7.62X51 NATO</td></tr><tr><td>Manufacturer Part Number</td><td>98892 </td></tr></table> [empty string] Y 39.99 39.99 [empty string] 8438-DEFAULT-s.jpg [empty string] 1000 1000 98892 229889 EMPTY EMPTY EMPTY 0 0 0 EMPTY fn-herstal-s-a/fnh-magazine-for-scar-17-17s-7-62x51mm-nato-black-20-round-229889 98892 0
CACHED false
EXECUTIONTIME 0
SQL SELECT * FROM GetALLProducts104 ORDER BY sortposition asc