CZ USA 75 BD 9MM 4.6" 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 = '1130' AND (upper(f.web_text) = 'CZ-USA' or upper(f.orig_text) = 'CZ-USA' or upper(a.brand) = 'CZ-USA') 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|
Designed in 1975, the CZ 75 is the flagship model of the CZ handgun line with over one million produced. An entire family of pistols is available based on the basic CZ 75 design: compacts, decockers, single action only, ambidextrous, alloy frames as well as competition pistols.
This model is a decocker version of the basic CZ 75 B model. The decocking lever mounted on the left side allows the hammer to be easily lowered on a loaded chamber for a safe, ‘hammer down’ carry.
The CZ 75 B is used by more Governments, Militaries, Police and Security agencies than any other pistol in the world. The CZ 75 is quite possibly the perfect pistol.
• Ammunition: 9mm Luger
• Magazine Capacity: 10
• Magazine Type: Double Stack
• Weight: 35.3 oz
• Overall Length: 8.1 in
• Barrel Length: 4.6 in
• Height: 5.4 in
• Width: 1.4 in
• Frame: Steel
• Grip: Plastic
• Barrel: Cold Hammer Forged
• Trigger Mech: DA/SA
• Sights: Fixed Night Sights
• Safety: Decocking Lever, Safety Stop on Hammer, Firing Pin Block 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