Walther P22 Angel Blue .22LR 3.42" 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 = '5120362' AND (upper(f.web_text) = 'WALTHER' or upper(f.orig_text) = 'WALTHER' or upper(a.brand) = 'WALTHER') 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|
The .22 rimfire handgun will never look the same. The P22 changed everything. Walther adapted the tactical styling and Performance Design concepts from our centerfire handguns and applied them to the .22 L.R. This created a new movement in the design of contemporary rimfire handguns … and an explosion of imitators. As a stylish, fun gun to own, the P22 is at home on the shooting range, around the camp or in a museum of modern art.
NUMBER OF MAGS: 1
MODEL: P22 California
SAFETY: Ambidextrous Manual Safety, Firing Pin Safety
TYPE: Semi-Automatic Pistol
SIGHTS: FT: 1-Dot RR: 2-Dot Windage Adjustable
BARREL LENGTH: 3.42"
SLIDE FINISH: Nickel Slide
OVERALL LENGTH: 6.26"
ACTION: Double Action '
WEIGHT: 19.6 oz
FRAME: Angel Blue
FEATURES: Loaded Chamber Indicator, Ambi-Magazine Catch
FEATURES: Interchangeable Rear Grip Panel
FEATURES: Picatinny Rail
|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