Smith & Wesson Model 686 Plus 3-5-7 Magnum .357 Magnum 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 = '150853' 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|
A “Collector must have” , the “3-5-7” Magnum Series features the Model 686 Plus Deluxe with custom black/silver “357” wood grips, unfluted cylinders and is available in three barrel lengths, 3” – 5” – 7”. Chambered with 7 rounds of .357 Magnum, the all stainless steel Model 686 Plus Deluxe offers compact powerful protection, sport shooting and collecting all in one.
Model: Model 686 Plus 3-5-7 Magnum® Series
Caliber: .357 Magnum, .38 S&W SPECIAL +P
Barrel Length: 3" / 7.6 cm
Overall Length: 8.3"
Front Sight: Red Ramp
Rear Sight: Adjustable White Outline
Action: Single/Double Action
Grip: Black/Silver "357" Custom Wood Grip
Weight: 37.4 oz / 1,060.3g
Cylinder Material: Stainless Steel
Barrel Material: Stainless Steel
Frame Material: Stainless Steel
Frame Finish: Satin Stainless
Purpose: Competition Shooting, Home Protection, Hunting, Recreational Shooting
|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