Crimson Trace Rail Master Green Laser
|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 = 'CMR-206' AND (upper(f.web_text) = 'CRIMSON TRACE' or upper(f.orig_text) = 'CRIMSON TRACE' or upper(a.brand) = 'CRIMSON TRACE') 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 CMR-206 Rail Master® is compact, yet powerful, universal green laser sight designed to fit rail-equipped pistols, rifles and shotguns. The laser sight fits onto virtually any firearm with a modern (M1913 Picatinny or Weaver-style) accessory rail. Ambidextrous control tabs allow the user to instantly activate or deactivate the laser.
The human eye processes the color green more effectively than any other color, and Crimson Trace offers the brightest green laser allowed by law, (5mW peak, 515nm, Class 3R). The CMR-206 Rail Master boasts 2 hours of (constant) run time on a single 1/3N Lithium battery, and features a 5 minute auto shut-off for power conservation.
The CMR-206 offers 3 modes of operation: Momentary, Strobe, and Constant-On. This allows the user to easily set their mode based on personal need or preference. The unit is quickly and easily user-installed in moments and can be painlessly transferred from firearm to firearm. The CMR-206 is securely fastened using Crimson Trace's Secure Lock Technology (SLT™).
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$31.99 $16.97 to $18.97