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 >= 'dr36bk' and catalogpartcode <= 'drm12agp' order by ref_product.catalogpartcode,ref_product.id ;

DR36BK - Monte Carlo - 36" - Downrod

DR36BP - Monte Carlo - 36" - Downrod

DR36BS - Monte Carlo - 36" - Downrod

DR36CH - Monte Carlo - 36" Downrod

DR36CHKW - Monte Carlo - 36" - Downrod

DR36DW - Monte Carlo - 36" Downrod

DR36ES - Monte Carlo - 36" Downrod

DR36GR - Monte Carlo - 36" Downrod

DR36GRY - Monte Carlo - 36" - Downrod

DR36HB - Monte Carlo - 36" Downrod

DR36KOA - Monte Carlo - 36" Downrod

DR36ON - Monte Carlo - 36" Downrod

DR36OZ - Monte Carlo - 36" Downrod

DR36PN - Monte Carlo - 36" - Downrod

DR36RB - Monte Carlo - 36" - Downrod

DR36RZW - Monte Carlo - 36" - Downrod

DR36TB - Monte Carlo - 36" - Downrod

DR36TI - Monte Carlo - 36" - Downrod

DR36WH - Monte Carlo - 36" - Downrod

DR36WZC - Monte Carlo - 36" Downrod

DR48AGB - Monte Carlo - 48" Downrod

DR48AGP - Monte Carlo - 48" Downrod

DR48BK - Monte Carlo - 48" - Downrod

DR48BP - Monte Carlo - 48" - Downrod

DR48BS - Monte Carlo - 48" - Downrod

DR48CH - Monte Carlo - 48" Downrod

DR48CHKW - Monte Carlo - 48" - Downrod

DR48ES - Monte Carlo - 48" Downrod

DR48GR - Monte Carlo - 48" Downrod

DR48GRY - Monte Carlo - 48" - Downrod

DR48HB - Monte Carlo - 48" Downrod

DR48KOA - Monte Carlo - 48" Downrod

DR48OZ - Monte Carlo - 48" Downrod

DR48PN - Monte Carlo - 48" - Downrod

DR48RB - Monte Carlo - 48" - Downrod

DR48RZW - Monte Carlo - 48" - Downrod

DR48TB - Monte Carlo - 48" - Downrod

DR48TI - Monte Carlo - 48" - Downrod

DR48WH - Monte Carlo - 48" - Downrod

DR48WZC - Monte Carlo - 48" Downrod

DR60AGB - Monte Carlo - 60" Downrod

DR60AGP - Monte Carlo - 60" Downrod

DR60BK - Monte Carlo - 60" - Downrod

DR60BP - Monte Carlo - 60" - Downrod

DR60BS - Monte Carlo - 60" - Downrod

DR60CH - Monte Carlo - 60" Downrod

DR60CHKW - Monte Carlo - 60" - Downrod

DR60DB - Monte Carlo - 60" Downrod

DR60EP - Monte Carlo - 60" - Downrod

DR60GR - Monte Carlo - 60" Downrod

DR60GRY - Monte Carlo - 60" - Downrod

DR60KOA - Monte Carlo - 60" Downrod

DR60OZ - Monte Carlo - 60" Downrod

DR60PN - Monte Carlo - 60" - Downrod

DR60RB - Monte Carlo - 60" - Downrod

DR60RZW - Monte Carlo - 60" - Downrod

DR60TB - Monte Carlo - 60" - Downrod

DR60TI - Monte Carlo - 60" - Downrod

DR60WH - Monte Carlo - 60" - Downrod

DR60WZC - Monte Carlo - 60" Downrod

DR72AGB - Monte Carlo - 72" - Downrod

DR72AGP - Monte Carlo - 72" - Downrod

DR72BK - Monte Carlo - 72" - Downrod

DR72BP - Monte Carlo - 72" - Downrod

DR72BS - Monte Carlo - 72" - Downrod

DR72CHKW - Monte Carlo - 72" - Downrod

DR72EP - Monte Carlo - 72" - Downrod

DR72ES - Monte Carlo - 72" Downrod

DR72GR - Monte Carlo - 72" Downrod

DR72GRY - Monte Carlo - 72" - Downrod

DR72KOA - Monte Carlo - 72" - Downrod

DR72OZ - Monte Carlo - 72" Downrod

DR72PN - Monte Carlo - 72" - Downrod

DR72RB - Monte Carlo - 72" - Downrod

DR72RZW - Monte Carlo - 72" - Downrod

DR72TB - Monte Carlo - 72" - Downrod

DR72TI - Monte Carlo - 72" - Downrod

DR72WH - Monte Carlo - 72" - Downrod

DR72WZC - Monte Carlo - 72" - Downrod

DRM12AGP - Monte Carlo - 12 Minimalist Downrod - Aged Pewter

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