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

HS506CRSC1B35MR2 - LBL Lighting - Mini Isla Pendant - Clear

HS506SMBZ1B35MPT - LBL Lighting - Mini Isla Pendant - Smoke

HS506SMBZ1B35MR2 - LBL Lighting - Mini Isla Pendant - Smoke

HS506SMSC1B35MR2 - LBL Lighting - Mini Isla Pendant - Smoke

HS508AMBZ1B50MPT - LBL Lighting - Mini Pavia Pendant - Amber

HS508AMBZ1B50MR2 - LBL Lighting - Mini Pavia Pendant - Amber

HS508AMBZ1B50MRL - LBL Lighting - Mini Pavia Pendant - Amber

HS508AMBZLEDS830MPT - LBL Lighting - Mini Pavia Pendant - Amber - LED

HS508AMBZLEDS830MR2 - LBL Lighting - Mini Pavia Pendant - Amber - LED

HS508AMBZLEDS830MRL - LBL Lighting - Mini Pavia Pendant - Amber - LED

HS508AMSC1B50MPT - LBL Lighting - Mini Pavia Pendant - Amber

HS508AMSC1B50MR2 - LBL Lighting - Mini Pavia Pendant - Amber

HS508AMSC1B50MRL - LBL Lighting - Mini Pavia Pendant - Amber

HS508AMSCLEDS830MPT - LBL Lighting - Mini Pavia Pendant - Amber - LED

HS508AMSCLEDS830MR2 - LBL Lighting - Mini Pavia Pendant - Amber - LED

HS508AMSCLEDS830MRL - LBL Lighting - Mini Pavia Pendant - Amber - LED

HS508BRBZ1B50FSJ - LBL Lighting - Mini Pavia Pendant - Brown

HS508LTBZ1B50MR2 - LBL Lighting - Mini Pavia Pendant - Latte

HS508LTBZLEDS830MR2 - LBL Lighting - Mini Pavia Pendant - Latte - LED

HS508LTSC1B50MR2 - LBL Lighting - Mini Pavia Pendant - Latte

HS508LTSCLEDS830MR2 - LBL Lighting - Mini Pavia Pendant - Latte - LED

HS509AMBZ1B10MR2 - LBL Lighting - Mini Lily Pendant - Amber

HS509AMSC1B10MR2 - LBL Lighting - Mini Lily Pendant - Amber

HS509OPBZ1B10MR2 - LBL Lighting - Mini Lily Pendant - Opal

HS509OPSC1B10MR2 - LBL Lighting - Mini Lily Pendant - Opal

HS509RDBZ1B10MR2 - LBL Lighting - Mini Lily Pendant - Red

HS509RDSC1B10MR2 - LBL Lighting - Mini Lily Pendant - Red

HS511OPBZ1B50MR2 - LBL Lighting - Coliseum Pendant - Opal

HS511OPBZLEDS830MR2 - LBL Lighting - Coliseum Pendant - Opal - LED

HS511OPSC1B50MR2 - LBL Lighting - Coliseum Pendant - Opal

HS511OPSCLEDS830MR2 - LBL Lighting - Coliseum Pendant - Opal - LED

HS524CRSC76 - LBL Lighting - Bling Chandelier - Clear

HS539BUBZ1BMPT - LBL Lighting - Mini Jasper Pendant - Steel Blue

HS539BUBZ1BMR2 - LBL Lighting - Mini Jasper Pendant - Steel Blue

HS539BUSC1BMR2 - LBL Lighting - Mini Jasper Pendant - Steel Blue

HS539CRBZ1BMPT - LBL Lighting - Mini Jasper Pendant - Clear

HS539CRBZ1BMR2 - LBL Lighting - Mini Jasper Pendant - Clear

HS539CRSC1BMR2 - LBL Lighting - Mini Jasper Pendant - Clear

HS542BUBZ1BFSJ - LBL Lighting - Aquarii Pendant - Steel Blue

HS542BUBZ1BMR2 - LBL Lighting - Aquarii Pendant - Steel Blue

HS542BUBZ1BMRL - LBL Lighting - Aquarii Pendant - Steel Blue

HS542BUBZLEDS830FSJ - LBL Lighting - Aquarii Pendant - Steel Blue - LED

HS542BUBZLEDS830MPT - LBL Lighting - Aquarii Pendant - Steel Blue - LED

HS542BUBZLEDS830MR2 - LBL Lighting - Aquarii Pendant - Steel Blue - LED

HS542BUBZLEDS830MRL - LBL Lighting - Aquarii Pendant - Steel Blue - LED

HS542BUSC1BFSJ - LBL Lighting - Aquarii Pendant - Steel Blue

HS542BUSC1BMR2 - LBL Lighting - Aquarii Pendant - Steel Blue

HS542BUSC1BMRL - LBL Lighting - Aquarii Pendant - Steel Blue

HS542BUSCLEDS830FSJ - LBL Lighting - Aquarii Pendant - Steel Blue - LED

HS542BUSCLEDS830MPT - LBL Lighting - Aquarii Pendant - Steel Blue - LED

HS542BUSCLEDS830MR2 - LBL Lighting - Aquarii Pendant - Steel Blue - LED

HS542BUSCLEDS830MRL - LBL Lighting - Aquarii Pendant - Steel Blue - LED

HS542IVBZ1BFSJ - LBL Lighting - Aquarii Pendant - Ivory

HS542IVBZ1BMR2 - LBL Lighting - Aquarii Pendant - Ivory

HS542IVBZ1BMRL - LBL Lighting - Aquarii Pendant - Ivory

HS542IVBZLEDS830FSJ - LBL Lighting - Aquarii Pendant - Ivory - LED

HS542IVBZLEDS830MPT - LBL Lighting - Aquarii Pendant - Ivory - LED

HS542IVBZLEDS830MR2 - LBL Lighting - Aquarii Pendant - Ivory - LED

HS542IVBZLEDS830MRL - LBL Lighting - Aquarii Pendant - Ivory - LED

HS542IVSC1BFSJ - LBL Lighting - Aquarii Pendant - Ivory

HS542IVSC1BMR2 - LBL Lighting - Aquarii Pendant - Ivory

HS542IVSC1BMRL - LBL Lighting - Aquarii Pendant - Ivory

HS542IVSCLEDS830FSJ - LBL Lighting - Aquarii Pendant - Ivory - LED

HS542IVSCLEDS830MPT - LBL Lighting - Aquarii Pendant - Ivory - LED

HS542IVSCLEDS830MR2 - LBL Lighting - Aquarii Pendant - Ivory - LED

HS542IVSCLEDS830MRL - LBL Lighting - Aquarii Pendant - Ivory - LED

HS542OPBZ1BMR2 - LBL Lighting - Aquarii Pendant - Opal

HS542OPBZLEDS830MR2 - LBL Lighting - Aquarii Pendant - Opal - LED

HS542OPSC1BMR2 - LBL Lighting - Aquarii Pendant - Opal

HS542OPSCLEDS830MR2 - LBL Lighting - Aquarii Pendant - Opal - LED

HS545AMBZ1BMR2 - LBL Lighting - Mini Isis Cylinder Pendant - Amber

HS545AMBZLEDS830MR2 - LBL Lighting - Mini Isis Cylinder Pendant - Amber - LED 8W 80 CRI 3000k

HS545AMSC1BMR2 - LBL Lighting - Mini Isis Cylinder Pendant - Amber

HS545AMSCLEDS830MR2 - LBL Lighting - Mini Isis Cylinder Pendant - Amber - LED 8W 80 CRI 3000k

HS545AQBZ1BMPT - LBL Lighting - Mini Isis Cylinder Pendant - Aqua

HS545AQBZ1BMR2 - LBL Lighting - Mini Isis Cylinder Pendant - Aqua

HS545AQBZLEDS830MR2 - LBL Lighting - Mini Isis Cylinder Pendant - Aqua - LED 8W 80 CRI 3000k

HS545AQSC1BMR2 - LBL Lighting - Mini Isis Cylinder Pendant - Aqua

HS545AQSCLEDS830MR2 - LBL Lighting - Mini Isis Cylinder Pendant - Aqua - LED 8W 80 CRI 3000k

HS545CRBZ1BMPT - LBL Lighting - Mini Isis Cylinder Pendant - Clear

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