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-5498op' and catalogpartcode <= 'g-623am-bz' order by ref_product.catalogpartcode,ref_product.id ;

G-5498OP - LBL Lighting - Glass Athena Wall Opal

G-549AM - LBL Lighting - Glass Briolette Pendant Amber

G-549FR - LBL Lighting - Glass Briolette Pendant Frost

G-549SM - LBL Lighting - Glass Briolette Pendant Smoke

G-550OP - LBL Lighting - Artica Pendant Opal

G-550TP - LBL Lighting - Artica Pendant Taupe

G-551AM - LBL Lighting - Glass Large Jasper Amber

G-551BR - LBL Lighting - Glass Large Jasper Brown

G-551CR - LBL Lighting - Glass Large Jasper Clear

G-551SB - LBL Lighting - Glass Large Jasper Steel Blue

G-553CR - LBL Lighting - Glass Rock Candy Cylinder Cr

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

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

G-553SM - LBL Lighting - Glass Rock Candy Clinder Sm

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-574CR - LBL Lighting - Glass Mini-Mason Pend Clear

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-578BR - LBL Lighting - Glass Miyu Pendant Dark Brown

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

G-578SB - LBL Lighting - Glass Miyu Pendant Steel Blue

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

G-583AM - LBL Lighting - Glass Chill Pendant Amber

G-583BU - LBL Lighting - Glass Chill Pendant Blue

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-585BG - LBL Lighting - Glass Rio Pend Brown Gray

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-586SB - LBL Lighting - Glass Horizon Pend Steel Blue

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-593IB - LBL Lighting - Glass Emi Pend Ivory Brown

G-593YP - LBL Lighting - Glass Emi Pend Gray Purple

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

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

G-594CR - LBL Lighting - Glass Mason Pendant Clear

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-616GO - LBL Lighting - GLASS DAHLING GRAY-OPAL

G-621GO - LBL Lighting - GLASS MINI-DAHLING GRAY-OPAL

G-622GO - LBL Lighting - GLASS DAHLING WALL GRAY-OPAL

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

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