If you find a better price, we'll beat it...even after delivery.
Applies to most orders. Click for details...
The WAC Lighting Shop does not collect sales tax in 49 states.

SQL MAIN=
SELECT distinct(ref_product.id),ref_product.catalogpartcode,date(lastedited) as 'ledate',imageurl,entrytype,upc FROM ref_product WHERE ref_product.EntryType IN('basepart','bundle','kit') AND ref_product.active='1' AND ref_product.manufacturerid IN(select id from lslocal.site_manufacturers where active='1') and catalogpartcode >= 'dm1942' and catalogpartcode <= 'dr18gry' order by ref_product.catalogpartcode,ref_product.id ;

DM1942 - Sterling - Darien Mirror

DM1945 - Sterling - Kingstree Mirror

DM1946 - Sterling - Brunson Mirror

DM1947 - Sterling - Fairley Mirror

DM1948 - Sterling - Sardis Mirror

DM1949 - Sterling - Ladson Mirror

DM1950 - Sterling - Princeton Mirror

DM1951 - Sterling - Helena Beveled Mirror

DM1952 - Sterling - Schaefer Mirror

DM1953 - Sterling - Valaparaiso Mirror

DM1954 - Sterling - Mya Mirror

DM1955 - Sterling - Bonneville Mirror

DM1956 - Sterling - Robeson Mirror

DM1957 - Sterling - Erhart Mirror

DM1959 - Sterling - Axton Mirror

DM1964 - Sterling - Monterey Beveled Mirror

DM1978 - Sterling - Milton Beveled Mirror

DM1980 - Sterling - Emporia Beveled Mirror

DM1986 - Sterling - White Wall Mirror

DM1987 - Sterling - Tolka Quay Mirror

DM1989 - Sterling - Fairview Beveled Mirror

DM1990 - Sterling - Merrion Mirror - Set of 2

DM1991 - Sterling - Smithfield Mirror - Set of 2

DM1992 - Sterling - Oswego Beveled Mirror

DM1993 - Sterling - Osbourne Mirror

DM1995 - Sterling - Berkeley Rocco Mirror

DM1996 - Sterling - Emery Hill Oval Mirror

DM1997 - Sterling - Emery Hill Rectangle Beveled Mirror

DM2017 - Sterling - Sumner Beveled Mirror

DM2018 - Sterling - Island Falls Mirror

DM2019 - Sterling - Monmoth Mirror

DM2021 - Sterling - Talmadge Scroll Frame Mirror

DM2022 - Sterling - Union Faux Window Mirror

DM2024 - Sterling - Gascoine Mirror

DM2025 - Sterling - Gatsby Contemporary Mirror

DM2026 - Sterling - Monte Vista Beveled Mirror

DM2028 - Sterling - Syracuse Mirror For Trump Home

DM2029 - Sterling - Ordway Mirror

DM2031 - Sterling - Rangely Beveled Mirror

DM2033 - Sterling - Centennial Genoa Mirror

DM2034 - Sterling - Arriba Beveled Mirror For Trump Home

DM2035 - Sterling - Canon Beveled Mirror

DM2036 - Sterling - La Porte Mirror For Trump Home

DM2040 - Sterling - Westcliffe Floor Mirror

DR12AFI - Monte Carlo - 12" Downrod

DR12AGB - Monte Carlo - 12" Downrod

DR12AGP - Monte Carlo - 12" Downrod

DR12BK - Monte Carlo - 12" - Downrod

DR12BP - Monte Carlo - 12" - Downrod

DR12BS - Monte Carlo - 12" - Downrod

DR12BZ - Monte Carlo - 12" - Downrod

DR12CH - Monte Carlo - 12" Downrod

DR12CHKW - Monte Carlo - 12" - Downrod

DR12EP - Monte Carlo - 12" - Downrod

DR12GR - Monte Carlo - 12" Downrod

DR12GRY - Monte Carlo - 12" - Downrod

DR12HB - Monte Carlo - 12" Downrod

DR12KOA - Monte Carlo - 12" Downrod

DR12ON - Monte Carlo - 12" Downrod

DR12OZ - Monte Carlo - 12" Downrod

DR12PN - Monte Carlo - 12" - Downrod

DR12RB - Monte Carlo - 12" Downrod

DR12RZB - Monte Carlo - 12" - Downrod

DR12RZW - Monte Carlo - 12" - Downrod

DR12TB - Monte Carlo - 12" - Downrod

DR12TI - Monte Carlo - 12" - Downrod

DR12WH - Monte Carlo - 12" - Downrod

DR12WI - Monte Carlo - 12" - Downrod

DR12WZC - Monte Carlo - 12" Downrod

DR18AFI - Monte Carlo - 18" Downrod

DR18AGB - Monte Carlo - 18" Downrod

DR18AGP - Monte Carlo - 18" Downrod

DR18BK - Monte Carlo - 18" - Downrod

DR18BP - Monte Carlo - 18" - Downrod

DR18BS - Monte Carlo - 18" - Downrod

DR18CH - Monte Carlo - 18" Downrod

DR18CHKW - Monte Carlo - 18" - Downrod

DR18EP - Monte Carlo - 18" - Downrod

DR18GR - Monte Carlo - 18" Downrod

DR18GRY - Monte Carlo - 18" Downrod

home|wac lighting part code list
policies and faq|my account|contact us
Copyright © 2010 - 2019 WAC Lighting Shop. All rights reserved.