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

DR18HB - Monte Carlo - 18" Downrod

DR18KOA - Monte Carlo - 18" Downrod

DR18ON - Monte Carlo - 18" Downrod

DR18OZ - Monte Carlo - 18" Downrod

DR18PN - Monte Carlo - 18" - Downrod

DR18RB - Monte Carlo - 18" - Downrod

DR18RZW - Monte Carlo - 18" - Downrod

DR18TB - Monte Carlo - 18" - Downrod

DR18TI - Monte Carlo - 18" - Downrod

DR18WH - Monte Carlo - 18" - Downrod

DR18WZC - Monte Carlo - 18" Downrod

DR24AFI - Monte Carlo - 24" Downrod

DR24AGB - Monte Carlo - 24" Downrod

DR24AGP - Monte Carlo - 24" Downrod

DR24BK - Monte Carlo - 24" - Downrod

DR24BP - Monte Carlo - 24" - Downrod

DR24BS - Monte Carlo - 24" - Downrod

DR24CH - Monte Carlo - 24" Downrod

DR24CHKW - Monte Carlo - 24" - Downrod

DR24ES - Monte Carlo - 24" Downrod

DR24GR - Monte Carlo - 24" Downrod

DR24GRY - Monte Carlo - 24" - Downrod

DR24HB - Monte Carlo - 24" Downrod

DR24KOA - Monte Carlo - 24" Downrod

DR24ON - Monte Carlo - 24" Downrod

DR24OZ - Monte Carlo - 24" Downrod

DR24PN - Monte Carlo - 24" - Downrod

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

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

DR4BS - Monte Carlo - 4.5" Downrod

DR60AGB - Monte Carlo - 60" Downrod

DR60AGP - Monte Carlo - 60" Downrod

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