Meprolight Mepro FT Bullseye, S&W Shield
|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 = '0631213108' AND (upper(f.web_text) = 'MEPROLIGHT' or upper(f.orig_text) = 'MEPROLIGHT' or upper(a.brand) = 'MEPROLIGHT') 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|
Based on an optical illumination patent, the MEPRO FT Bullseye is an extremely small, low profile, optical pistol sight. Similar to reflex sights, using the MEPRO FT Bullseye provides the shooter with an aim point in the form of an illuminated dot and circle Bullseye. Shooters can enjoy intuitive and fast target acquisition.
The Fiber-optic Tritium combination enables instant and accurate shooting in all lighting conditions with no batteries needed.
The Fiber-optic used in bright light or day shooting and the premium-grade Tritium provides instant illumination at night or in low-light conditions.
The MEPRO FT Bullseye installation is simple and easy on existing pistol dovetails, eliminates the need for a front sight and fits most existing holsters.
Smallest optical sight in the world based on patented optical illumination.
Superior visibility in all lighting conditions.
No front sight needed.
Fast and intuitive target acquisition.
Fits most existing holsters.
Simple, easy installation on existing pistol dovetail.
No Batteries – No Switches – Always On - Always Ready.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$26.97 to $40.99
$8.49 to $14.99