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

HS378OPPC1B20MR2 - LBL Lighting - Lily Pendant - Opal

HS378OPSC1B20MR2 - LBL Lighting - Lily Pendant - Opal

HS378RDBZ1B20MR2 - LBL Lighting - Lily Pendant - Red

HS378RDPC1B20MR2 - LBL Lighting - Lily Pendant - Red

HS378RDSC1B20MR2 - LBL Lighting - Lily Pendant - Red

HS379AMBZ1B50MR2 - LBL Lighting - Mini-Veneto Pendant - Amber

HS379AMSC1B50MR2 - LBL Lighting - Mini-Veneto Pendant - Amber

HS379MOBZ1B50MR2 - LBL Lighting - Mini-Veneto Pendant - Mocha

HS379MOSC1B50MR2 - LBL Lighting - Mini-Veneto Pendant - Mocha

HS381BZ1A50FSJ - LBL Lighting - Hover Pendant

HS381BZ1A50MPT - LBL Lighting - Hover Pendant

HS381BZ1A50MR2 - LBL Lighting - Hover Pendant

HS381BZ1A50MRL - LBL Lighting - Hover Pendant

HS381SC1A50FSJ - LBL Lighting - Hover Pendant

HS381SC1A50MR2 - LBL Lighting - Hover Pendant

HS381SC1A50MRL - LBL Lighting - Hover Pendant

HS390CR16SC1LAMFSJ - LBL Lighting - Neutron Pendant - Clear Cylinder - Amber LED

HS390CR16SC1LAMMR2 - LBL Lighting - Neutron Pendant - Clear Cylinder - Amber LED

HS390CR16SC1LBUFSJ - LBL Lighting - Neutron Pendant - Clear Cylinder - Blue LED

HS390CR16SC1LBUMR2 - LBL Lighting - Neutron Pendant - Clear Cylinder - Blue LED

HS390CR16SC1LGRMR2 - LBL Lighting - Neutron Pendant - Clear Cylinder - Green LED

HS390CR16SC1LRDMR2 - LBL Lighting - Neutron Pendant - Clear Cylinder - Red LED

HS390CR16SC1LRGMR2 - LBL Lighting - Neutron Pendant - Clear Cylinder

HS390CR16SC1LWHMR2 - LBL Lighting - Neutron Pendant - Clear Cylinder - Cool White LED

HS390CR16SC1LWWMR2 - LBL Lighting - Neutron Pendant - Clear Cylinder - Warm White LED

HS390FR16SC1LAMFSJ - LBL Lighting - Neutron Pendant - Frosted Cylinder - Amber LED

HS390FR16SC1LAMMPT - LBL Lighting - Neutron Pendant - Frosted Cylinder - Amber LED

HS390FR16SC1LAMMR2 - LBL Lighting - Neutron Pendant - Frosted Cylinder - Amber LED

HS390FR16SC1LAMMRL - LBL Lighting - Neutron Pendant - Frosted Cylinder - Amber LED

HS390FR16SC1LBUFSJ - LBL Lighting - Neutron Pendant - Frosted Cylinder - Blue LED

HS390FR16SC1LBUMPT - LBL Lighting - Neutron Pendant - Frosted Cylinder - Blue LED

HS390FR16SC1LBUMR2 - LBL Lighting - Neutron Pendant - Frosted Cylinder - Blue LED

HS390FR16SC1LBUMRL - LBL Lighting - Neutron Pendant - Frosted Cylinder - Blue LED

HS390FR16SC1LGRFSJ - LBL Lighting - Neutron Pendant - Frosted Cylinder - Green LED

HS390FR16SC1LGRMPT - LBL Lighting - Neutron Pendant - Frosted Cylinder - Green LED

HS390FR16SC1LGRMR2 - LBL Lighting - Neutron Pendant - Frosted Cylinder - Green LED

HS390FR16SC1LGRMRL - LBL Lighting - Neutron Pendant - Frosted Cylinder - Green LED

HS390FR16SC1LRDFSJ - LBL Lighting - Neutron Pendant - Frosted Cylinder - Red LED

HS390FR16SC1LRDMPT - LBL Lighting - Neutron Pendant - Frosted Cylinder - Red LED

HS390FR16SC1LRDMR2 - LBL Lighting - Neutron Pendant - Frosted Cylinder - Red LED

HS390FR16SC1LRDMRL - LBL Lighting - Neutron Pendant - Frosted Cylinder - Red LED

HS390FR16SC1LRGFSJ - LBL Lighting - Neutron Pendant - Frosted Cylinder

HS390FR16SC1LRGMPT - LBL Lighting - Neutron Pendant - Frosted Cylinder

HS390FR16SC1LRGMR2 - LBL Lighting - Neutron Pendant - Frosted Cylinder

HS390FR16SC1LRGMRL - LBL Lighting - Neutron Pendant - Frosted Cylinder

HS390FR16SC1LWHMR2 - LBL Lighting - Neutron Pendant - Frosted Cylinder - Cool White LED

HS390FR16SC1LWWMR2 - LBL Lighting - Neutron Pendant - Frosted Cylinder - Warm White LED

HS402BRBZ1B20MPT - LBL Lighting - Allie Pendant - Brown

HS402BRBZ1B20MR2 - LBL Lighting - Allie Pendant - Brown

HS402BRBZ1B20MRL - LBL Lighting - Allie Pendant - Brown

HS402BRSC1B20MPT - LBL Lighting - Allie Pendant - Brown

HS402BRSC1B20MR2 - LBL Lighting - Allie Pendant - Brown

HS402BRSC1B20MRL - LBL Lighting - Allie Pendant - Brown

HS4420F410SC120 - LBL Lighting - Twilight 20 Chandelier - Flite Paper

HS446OPBZ1B35MR2 - LBL Lighting - Finestra Pendant - Opal

HS446OPSC1B35MR2 - LBL Lighting - Finestra Pendant - Opal

HS446RDBZ1B35MR2 - LBL Lighting - Finestra Pendant - Red

HS446RDSC1B35MR2 - LBL Lighting - Finestra Pendant - Red

HS447CRSC1B10FSJ - LBL Lighting - Bling Pendant - Clear

HS447CRSC1B10MR2 - LBL Lighting - Bling Pendant - Clear

HS447CRSC1B10MRL - LBL Lighting - Bling Pendant - Clear

HS451ONBZ1B50FSJ - LBL Lighting - Onyx Cone Pendant - Incandescent

HS451ONBZ1B50MPT - LBL Lighting - Onyx Cone Pendant - Incandescent

HS451ONBZ1B50MR2 - LBL Lighting - Onyx Cone Pendant - Incandescent

HS451ONBZ1B50MRL - LBL Lighting - Onyx Cone Pendant - Incandescent

HS451ONBZLEDS830FSJ - LBL Lighting - Onyx Cone Pendant - LED

HS451ONBZLEDS830MPT - LBL Lighting - Onyx Cone Pendant - LED

HS451ONBZLEDS830MR2 - LBL Lighting - Onyx Cone Pendant - LED

HS451ONBZLEDS830MRL - LBL Lighting - Onyx Cone Pendant - LED

HS451ONSC1B50FSJ - LBL Lighting - Onyx Cone Pendant - Incandescent

HS451ONSC1B50MR2 - LBL Lighting - Onyx Cone Pendant - Incandescent

HS451ONSC1B50MRL - LBL Lighting - Onyx Cone Pendant - Incandescent

HS451ONSCLEDS830FSJ - LBL Lighting - Onyx Cone Pendant - LED

HS451ONSCLEDS830MPT - LBL Lighting - Onyx Cone Pendant - LED

HS451ONSCLEDS830MR2 - LBL Lighting - Onyx Cone Pendant - LED

HS451ONSCLEDS830MRL - LBL Lighting - Onyx Cone Pendant - LED

HS455LTOPBZ1B50MR2 - LBL Lighting - Rachel Pendant - Latte/Opal

HS455LTOPBZLEDS830MR2 - LBL Lighting - Rachel Pendant - Latte/Opal - LED

HS455LTOPSC1B50MR2 - LBL Lighting - Rachel Pendant - Latte/Opal

HS455LTOPSCLEDS830MR2 - LBL Lighting - Rachel Pendant - Latte/Opal - LED

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