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 >= 'g-553pr' and catalogpartcode <= 'g-695cr' order by ref_product.catalogpartcode,ref_product.id ;

G-553PR - LBL Lighting - Glass Rock Candy Cylinder Pr

G-553SB - LBL Lighting - Glass Rock Candy Cylinder Sb

G-554OP - LBL Lighting - GLASS ROCK CANDY IN CYLDR OP

G-5554AP - LBL Lighting - Glass Kona Susp Apricot

G-5554BU - LBL Lighting - Glass Kona Susp Blue

G-5554OP - LBL Lighting - Glass Kona Susp Opal

G-559BAM - LBL Lighting - Glass Omni Outr Bub D Ambr Sml

G-559BBR - LBL Lighting - Glass Omni Outr Bub Br Smk Sml

G-559BBU - LBL Lighting - Glass Omni Outr Bub Blue Sml

G-559BGR - LBL Lighting - Glass Omni Outr Bub Green Sml

G-561BBR - LBL Lighting - Glass Omni Outr Bub Br Smk Med

G-561BGR - LBL Lighting - Glass Omni Outr Bub Green Med

G-561BOP - LBL Lighting - Glass Omni Outr Bub Opal Med

G-561HFR - LBL Lighting - Glass Omni Outr Hcarv Frst Med

G-574BU - LBL Lighting - Glass Mini-Mason Pend S Blue

G-575OP - LBL Lighting - Glass Mini-Mason Inner Opal

G-576IV - LBL Lighting - Glass Aiko Pendant Ivory

G-576OP - LBL Lighting - Glass Aiko Pendant Opal

G-577BR - LBL Lighting - Glass Mini-Aiko Pendant Brown

G-577IV - LBL Lighting - Glass Mini-Aiko Pendant Ivory

G-577OP - LBL Lighting - Glass Mini-Aiko Pendant Opal

G-578GY - LBL Lighting - Glass Miyu Pendant Gray

G-582BA - LBL Lighting - Glass Sora Pnd D-Brown L-Amber

G-583CR - LBL Lighting - Glass Chill Pendant Clear

G-584BR - LBL Lighting - Glass Addison Pendant Brown

G-584CR - LBL Lighting - GLASS ADDISON PENDANT CLEAR

G-584OP - LBL Lighting - Glass Addison Pendant Opal

G-585BB - LBL Lighting - Glass Rio Pend Beige D-Brown

G-585GP - LBL Lighting - Glass Rio Pend Gray Purple

G-586BR - LBL Lighting - Glass Horizon Pend D-Brown

G-586OP - LBL Lighting - Glass Horizon Pend Opal

G-587BR - LBL Lighting - Glass Ariana Pendant Brown

G-587CR - LBL Lighting - Glass Ariana Pendant Clear

G-593BL - LBL Lighting - Glass Emi Pend Choclate Brown

G-594AM - LBL Lighting - Glass Mason Pendant Amber

G-594BR - LBL Lighting - Glass Mason Pendant Brown

G-5957-AM - LBL Lighting - Glass Kona Wall Amber

G-5957AP - LBL Lighting - Glass Kona Wall Apricot

G-5957BU - LBL Lighting - Glass Kona Wall Blue

G-5957OP - LBL Lighting - Glass Kona Wall Opal

G-595CRL - LBL Lighting - Glass Lowe Clear

G-595OPM - LBL Lighting - Glass Middle Opal

G-595OPU - LBL Lighting - Glass Upper Opal

G-598AM - LBL Lighting - GLASS INDULGENT AMBER

G-598OP - LBL Lighting - GLASS INDULGENT OPAL

G-598RD - LBL Lighting - GLASS INDULGENT RED

G-599AM - LBL Lighting - GLASS MINI-INDULGENT AMBER

G-599OP - LBL Lighting - GLASS MINI-INDULGENT OPAL

G-599RD - LBL Lighting - GLASS MINI-INDULGENT RED

G-603CR - LBL Lighting - GLASS SPRINGVIEW CLEAR

G-603SM - LBL Lighting - GLASS SPRINGVIEW SMOKE

G-604CR - LBL Lighting - GLASS MINI-SPRINGVIEW CLEAR

G-604SM - LBL Lighting - GLASS MINI-SPRINGVIEW SMOKE

G-608GO - LBL Lighting - GLASS DAHLING GRANDE GRAY-OPAL

G-623AM-BZ - LBL Lighting - GLASS M ROCK CANDY CYL WALL AM

G-623AM-SC - LBL Lighting - GLASS M ROCK CANDY CYL WALL AM

G-623CR-BZ - LBL Lighting - GLASS M ROCK CANDY CYL WALL CR

G-623OP-BZ - LBL Lighting - GLASS M ROCK CANDY CYL WALL OP

G-623OP-SC - LBL Lighting - GLASS M ROCK CANDY CYL WALL OP

G-623PR-BZ - LBL Lighting - GLASS M ROCK CANDY CYL WALL CR

G-623PR-SC - LBL Lighting - GLASS M ROCK CANDY CYL WALL CR

G-623SB-BZ - LBL Lighting - GLASS M ROCK CANDY CYL WALL SB

G-623SB-SC - LBL Lighting - GLASS M ROCK CANDY CYL WALL SB

G-623SM-BZ - LBL Lighting - GLASS M ROCK CANDY CYL WALL SM

G-625AM - LBL Lighting - GLASS ISIS PENDANT AMBER

G-625AQ - LBL Lighting - GLASS ISIS PENDANT AQUA

G-625CR - LBL Lighting - GLASS ISIS PENDANT CLEAR

G-625SM - LBL Lighting - GLASS ISIS PENDANT SMOKE

G-626FR - LBL Lighting - GLASS ISIS PENDANT INNER FROST

G-667CRFR - LBL Lighting - GLASS DUKE SUSP CR GLS-FIZZ

G-667CRMS - LBL Lighting - GLASS DUKE SUSP CR GLS-MICA

G-678CC-RH - LBL Lighting - CRYS MADEMS 13X22 STONES CLEAR

G-678CG-RH - LBL Lighting - CRYS MADEMS 13X22 STONES GOLD

G-688GR - LBL Lighting

G-688OR - LBL Lighting

G-693BU - LBL Lighting - GLASS ZOLLO PENDANT BLUE

G-693GY - LBL Lighting - GLASS ZOLLO PENDANT GRAY

G-695CC - LBL Lighting - CRYS MADEMS 13X33 STONES CLEAR

G-695CG - LBL Lighting - CRYS MADEMS 13X33 STONES GOLD

G-695CR - LBL Lighting - CRYS MADEMS 13X33 STONES CLEAR

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