Zev Z17 Duty Stripped Slide with RMR Cut, 3rd Gen Black
|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 = 'SLD-Z17-3G-DUTY-RMR-BLK' AND (upper(f.web_text) = 'ZEV TECH' or upper(f.orig_text) = 'ZEV TECH' or upper(a.brand) = 'ZEV TECH') 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 Duty slides feature the same worksmanship and quality that ZEV is known for with a functionally driven design and utilitarian coating for the no-nonsense shooter who is looking to complete a new frame build or to enhance the functionality of their Glock. The black nitride finish provides a durable coating and the patented ZEV RMR cut enables the use of red dot sights using an RMR installation footprint.
Machined from 17-4 Stainless steel billet
Lowered ejection port to aid in ejection of brass
Match grade, precision milled tolerances that are tighter than factory
Improved accuracy and grouping performance upon installation
DLC or PVD coatings offered have a Rockwell hardness rating above that of factory coatings
Channel liner comes installed in all Glock compatible slides
NOTE: ZEV RMR Cover Plate NOT included. Sold Seperately.
Material: 17-4 Stainless Steel
Finish: Black Nitride
• Glock 17 (1st - 3rd Gen)
• Glock 17C (1st - 3rd Gen)
• Glock 17L (1st - 3rd Gen)
• Glock 34 (1st - 3rd Gen)
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review