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

HS504AMBZ1B35MR2 - LBL Lighting - Banja Pendant - Dark Amber

HS504AMBZLEDS830MR2 - LBL Lighting - Banja Pendant - Dark Amber - LED

HS504AMSC1B35MR2 - LBL Lighting - Banja Pendant - Dark Amber

HS504AMSCLEDS830MR2 - LBL Lighting - Banja Pendant - Dark Amber - LED

HS504AQBZ1B35FSJ - LBL Lighting - Banja Pendant - Aqua

HS504AQBZ1B35MPT - LBL Lighting - Banja Pendant - Aqua

HS504AQBZ1B35MR2 - LBL Lighting - Banja Pendant - Aqua

HS504AQBZ1B35MRL - LBL Lighting - Banja Pendant - Aqua

HS504AQBZLEDS830MR2 - LBL Lighting - Banja Pendant - Aqua - LED

HS504AQSC1B35FSJ - LBL Lighting - Banja Pendant - Aqua

HS504AQSC1B35MPT - LBL Lighting - Banja Pendant - Aqua

HS504AQSC1B35MR2 - LBL Lighting - Banja Pendant - Aqua

HS504AQSC1B35MRL - LBL Lighting - Banja Pendant - Aqua

HS504AQSCLEDS830MR2 - LBL Lighting - Banja Pendant - Aqua - LED

HS504AQSCLEDS830MRL - LBL Lighting - Banja Pendant - Aqua - LED

HS504IWBZ1B35FSJ - LBL Lighting - Banja Pendant - Ivory Opaque

HS504IWBZ1B35MPT - LBL Lighting - Banja Pendant - Ivory Opaque

HS504IWBZ1B35MR2 - LBL Lighting - Banja Pendant - Ivory Opaque

HS504IWBZ1B35MRL - LBL Lighting - Banja Pendant - Ivory Opaque

HS504IWBZLEDS830MR2 - LBL Lighting - Banja Pendant - Ivory Opaque - LED

HS504IWSC1B35FSJ - LBL Lighting - Banja Pendant - Ivory Opaque

HS504IWSC1B35MPT - LBL Lighting - Banja Pendant - Ivory Opaque

HS504IWSC1B35MR2 - LBL Lighting - Banja Pendant - Ivory Opaque

HS504IWSC1B35MRL - LBL Lighting - Banja Pendant - Ivory Opaque

HS504IWSCLEDS830MR2 - LBL Lighting - Banja Pendant - Ivory Opaque - LED

HS504IWSCLEDS830MRL - LBL Lighting - Banja Pendant - Ivory Opaque - LED

HS506AMBZ1B35MR2 - LBL Lighting - Mini Isla Pendant - Amber

HS506AMSC1B35MR2 - LBL Lighting - Mini Isla Pendant - Amber

HS506AQBZ1B35FSJ - LBL Lighting - Mini Isla Pendant - Aqua

HS506AQBZ1B35MPT - LBL Lighting - Mini Isla Pendant - Aqua

HS506AQBZ1B35MR2 - LBL Lighting - Mini Isla Pendant - Aqua

HS506AQBZ1B35MRL - LBL Lighting - Mini Isla Pendant - Aqua

HS506AQSC1B35FSJ - LBL Lighting - Mini Isla Pendant - Aqua

HS506AQSC1B35MR2 - LBL Lighting - Mini Isla Pendant - Aqua

HS506AQSC1B35MRL - LBL Lighting - Mini Isla Pendant - Aqua

HS506BRBZ1B35MR2 - LBL Lighting - Mini Isla Pendant - Brown

HS506BRSC1B35MR2 - LBL Lighting - Mini Isla Pendant - Brown

HS506CRBZ1B35FSJ - LBL Lighting - Mini Isla Pendant - Clear

HS506CRBZ1B35MPT - LBL Lighting - Mini Isla Pendant - Clear

HS506CRBZ1B35MR2 - LBL Lighting - Mini Isla Pendant - Clear

HS506CRBZ1B35MRL - LBL Lighting - Mini Isla Pendant - Clear

HS506CRSC1B35FSJ - LBL Lighting - Mini Isla Pendant - Clear

HS506CRSC1B35MR2 - LBL Lighting - Mini Isla Pendant - Clear

HS506CRSC1B35MRL - LBL Lighting - Mini Isla Pendant - Clear

HS506SMBZ1B35FSJ - LBL Lighting - Mini Isla Pendant - Smoke

HS506SMBZ1B35MPT - LBL Lighting - Mini Isla Pendant - Smoke

HS506SMBZ1B35MR2 - LBL Lighting - Mini Isla Pendant - Smoke

HS506SMBZ1B35MRL - LBL Lighting - Mini Isla Pendant - Smoke

HS506SMSC1B35FSJ - LBL Lighting - Mini Isla Pendant - Smoke

HS506SMSC1B35MR2 - LBL Lighting - Mini Isla Pendant - Smoke

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

HS539BUBZ1BFSJ - LBL Lighting - Mini Jasper Pendant - Steel Blue

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