Smith & Wesson M442 .38 Spl 2" Barrel, Internal Lock
|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 = '162810-B' 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 J-Frame revolvers have had your back since 1950. These small revolvers were designed to fire a full power round and are as simple and easy to use as they are reliable. Available in various calibers and with three diverse hammer designs, it is no surprise that the Smith & Wesson J-Frame has become the most popular, small-frame, defense revolver on the market.
The Model 442 is a variation of the Model 42 Centennial Airweight® that integrates the time-tested features of the original with modern advancements. This lightweight, enclosed hammer revolver is a favorite back-up and concealed carry firearm.
• Lightweight alloy frame for easy carry
• Stainless steel barrel
• Carbon steel cylinder
• Snag-Free enclosed hammer
• Rated for continuous +P Use
• INTERNAL LOCK
Model: Model 442 Revolver - No Internal Lock
Caliber: 38 S&W SPECIAL +P
Safety: Internal Lock
Front Sight: Integral
Rear Sight: Fixed
Action: Double Action Only
Grip: Black Polymer
Cylinder Material: Carbon Steel
Barrel Material: Stainless Steel
Frame Material: Aluminum Alloy
Barrel Length: 1.875" (4.8 cm)
Weight: 14.6 oz.
|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