Sig Sauer P226 Pellet Gun .177 Caliber CO2
Out Of Stock
|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) ) 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 = 'air-226f-177-12g-16-bk' AND (upper(f.web_text) = 'SIG SAUER' or upper(f.orig_text) = 'SIG SAUER' or upper(a.brand) = 'SIG SAUER') 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|
MODEL: P226 ASP
OPERATING SYSTEM: 12 Gram CO2
CALIBER: .177 cal
MUZZLE VELOCITY: up to 450 fps*
TRIGGER WEIGHT: 7 lb DA / 4 lb SA (31 N / 18 N)
STOCK TYPE: Metal
ACCESSORY RAIL: M1913
MAGS INCLUDED: (1) 16rd (8x2) Pellet/BB Mag
OVERALL LENGTH: 8.25 in (210 mm)
WEIGHT: 2.4 lb (1 kg)
Chambered in .177 pellet or steel BB, this CO2 powered, next-generation air pistol has been engineered specifically to closely measure up to the most popular SIG original model platforms in weight and handling as well as standards of performance. Features include 16-round 8x2 rotary magazine, built-in picatinny rail mount, rifled steel barrel and white dot sights. Perfected for practice with every advantage built in, these airguns are the economic, authentic answer to training more often, more effectively. The P226 Air Pistol puts seriously comparable handling within reach for more frequent inexpensive training, indoors or out.
Please Note: CO2 and pellets are sold separately.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review