Streamlight TLR-2G, 300 Lumen Weapon Light & 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 = '69250' AND (upper(f.web_text) = 'STREAMLIGHT' or upper(f.orig_text) = 'STREAMLIGHT' or upper(a.brand) = 'STREAMLIGHT') 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|
Rail-mounted tactical light with integrated green aiming laser to guide your aim even in daylight. Mounts directly to handguns with Glock-style rails and to all MIL-STD-1913 (Picatinny) rails.
510-530nm direct drive green laser with wide operating temperature range
Green laser provides long-range targeting even in daylight
White LED delivers 300 lumens and 12,000 candela peak beam intensity
Runs 2.5 hours (LED/Laser simultaneously); Laser only function runs 17 hours
Powered by two 3V CR123A lithium batteries with 10-year storage life
Rail grip clamp system securely attaches/detaches quickly and safely with no tools and without putting your hands in front of muzzle
Mounts directly to handguns with Glock-style rails and to all MIL-STD-1913 (Picatinny) rails.
Includes keys for Glock-style, Picatinny, Beretta 90two, S&W 99 and S&W TSW and Sig P320
Durable, anodized aluminum construction with high-impact, chemical-resistant polymer laser housing
Ambidextrous momentary/steady on/off switch
User programmable strobe can be enabled/disabled
Windage and elevation adjustment screws mounted in bushings for long life and dependable zero retention
Highly accurate sight repeatability when remounting
Fits existing light bearing holsters
3.39 in. (8.61 cm); 4.72 oz (133.8 grams)
Operating temperature: -40°F to +120°F.
Lithium Battery Notice under DOCUMENTATION
Limited lifetime warranty
Assembled in USA
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$12.99 to $19.99
$19.99 to $22.99