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

DR24RB - Monte Carlo - 24" - Downrod

DR24RZW - Monte Carlo - 24" - Downrod

DR24TB - Monte Carlo - 24" - Downrod

DR24TI - Monte Carlo - 24" - Downrod

DR24WH - Monte Carlo - 24" - Downrod

DR24WZC - Monte Carlo - 24" Downrod

DR36AGB - Monte Carlo - 36" Downrod

DR36AGP - Monte Carlo - 36" Downrod

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

DR36WI - 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

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