Smith & Wesson M&P Shield 9MM 3" Barrel
|SQL||SELECT DISTINCT a.style_id, max(CASE WHEN m.description IS NULL OR RTRIM(LTRIM(m.description)) = '' THEN a.web_desc ELSE m.description END) as realname, sum(c.qoh+c.qc) as overallqoh, max(a.picture_id) as picture_id, max(a.of8) as of8, max(b.sku_id) as sku_id, max(b.sku_of7) as sku_of7, max(b.scale_entry_id) as scaleid, max(b.attr2_entry_id) as attr2id, max(b.attr1_entry_id) as attr1id, max(a.style) as style, max(r.package_id) as usepackage, max(a.web_style) as webStyle, max(m.capacity) as capacity, max(m.webstyle_sort) as webstyle_sort, max(a.NON_INVT) as NON_INVT FROM tb_styles a LEFT JOIN tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id) LEFT JOIN tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id AND NOT (c.qoh < 1 AND a.of8 in (?,?,?,?,?,?,?,?)) AND NOT (c.qoh < 1 AND a.of8='INACTIVE') AND c.store_id in(49,90,4) ) LEFT JOIN web_product_information m WITH (NOLOCK) ON (a.style_id = m.style_id) LEFT JOIN dbo.tb_inet_names f WITH (NOLOCK) on (f.orig_text = a.brand and f.field_name='BRAND') LEFT JOIN tb_package r WITH (NOLOCK) on (r.sku_id=b.sku_id) INNER JOIN web_all_products wb WITH (NOLOCK) ON (wb.style_id = a.style_id) WHERE a.web_style = '187021' AND (upper(f.web_text) = 'SMITH AND WESSON' or upper(f.orig_text) = 'SMITH AND WESSON' or upper(a.brand) = 'SMITH AND WESSON') GROUP BY a.style_id,a.of8 HAVING (sum(c.qoh+c.qc) > 0 OR a.of8='STK') ORDER BY max(m.webstyle_sort), a.style_id|
Smith & Wesson’s new M&P SHIELD™ is a slim, concealable, lightweight, striker-fired polymer pistol. Available in 9mm and .40 S&W, the new M&P SHIELD features a slim design combined with the proven and trusted features found in the M&P Pistol Series. From the pistol’s easily concealed one-inch profile to its optimized 18-degree grip angle, the M&P SHIELD offers professional-grade features that provide consumers with simple operation and reliable performance. Chambered in 9mm and .40 S&W for proven stopping power, the M&P SHIELD features a high-strength polymer frame with a black, durable, corrosion resistant finish, coated stainless steel slide and barrel. Both models are standard with a 3.1-inch barrel, which contributes to an overall length of 6.1 inches and an unloaded weight of 19 ounces. For fast tracking and smooth target acquisition, the M&P SHIELD is standard with a 5.3-inch sight radius and has been enhanced with a short, consistent trigger pull measuring 6.5 pounds. Featuring a quick and audible reset made possible by the striker-fired action, the M&P SHIELD allows multiple rounds to be placed on target both consistently and accurately.
ALL BACKED BY OUR SMITH & WESSON LIFETIME SERVICE POLICY.
Model: M&P9 SHIELD™
Capacity: 7 Round & 8 Round
Action: Striker Fire
Barrel Length: 3.1" / 7.874 cm
Front Sight: White Dot
Rear Sight: White 2-Dot
Overall Length: 6.1" / 15.5 cm
Frame Width: .95" / 2.413 cm
Overall Height: 4.6" / 11.684 cm
Weight: 19.0 oz / 538.7 g
Barrel/Slide: Stainless Steel
Frame Material: Polymer
Barrel/Slide Finish: Black 68 HRc
Trigger Pull: 6.5 lbs. +/-
Sight Radius: 5.3" / 13.3 cm
Safeties: Magazine Safety, Single Sided Thumb Safety
|ATTENTION: Federal law requires that we ship firearms to an FFL dealer on your behalf. Federal law requires that you must be 21 years old to purchase handguns, firearm receivers/actions/lowers and pistol grip-only shotguns. In CA, buyers of long guns must be 21 years old unless exempted by law. Check your local laws for any restrictions before ordering. For safety reasons, we do not accept returns on firearms. Additional items ordered at the same time as firearms will be shipped to the billing address. Pricing on firearms does not reflect governmental or dealer fees for mandated background checks and/or dealer transfer fees; these fees will be charged by the FFL dealer you select during the checkout process. See FFL dealer for details.|
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review