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 >= 'd351-led' and catalogpartcode <= 'dr12koa' order by ref_product.catalogpartcode,ref_product.id ;

D351-LED - Dimond Lighting - Glazed Ceramic LED Table Lamp in Blue and Off White

D353 - Dimond Lighting - Pink Pop Glass Accent Lamp in Hot Pink

D353-LED - Dimond Lighting - Pink Pop Glass LED Accent Lamp in Hot Pink

D355 - Dimond Lighting - Dimond - Glass Bottle Table Lamp In Gold Antique Mercury Glass

D355-LED - Dimond Lighting - Dimond - Glass Bottle LED Table Lamp In Gold Antique Mercury Glass

DIMCOIL150 - LBL Lighting - Debuzzing Dimming Coil - 150W

DIMCOIL300 - LBL Lighting - Debuzzing Dimming Coil - 300W

DIMCOIL600 - LBL Lighting - Debuzzing Dimming Coil - 600W

DL125-31-31 - Alico - Bilico 1 Light LED Table Lamp In Anodized Blue-Grey

DLL100-30-15 - Dimond Lighting - Shaded Modern Task Lamp

DLL200-95-32 - Dimond Lighting - Modern Disc Task Lamp

DLL300-95-85 - Dimond Lighting - Mono Disc Elbow Desk Lamp

DLL400-95-85 - Dimond Lighting - Flat Fold Desk Lamp

DM1924 - Sterling - Webster Mirror

DM1926 - Sterling - Stewart Mirror

DM1927 - Sterling - Transcend Beveled Mirror

DM1929 - Sterling - Barrets Mirror

DM1930 - Sterling - Tripoli Mirror

DM1935 - Sterling - Prentiss Beveled Mirror

DM1937 - Sterling - Porterdale Mirror

DM1938 - Sterling - Escher Mirror

DM1940 - Sterling - Offerton Beveled Mirror

DM1941 - Sterling - Miramar Mirror

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

DR12GR - Monte Carlo - 12" Downrod

DR12GRY - Monte Carlo - 12" - Downrod

DR12HB - Monte Carlo - 12" Downrod

DR12KOA - Monte Carlo - 12" Downrod

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