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-782br' and catalogpartcode <= 'g13075' order by ref_product.catalogpartcode,ref_product.id ;

G-782BR - LBL Lighting - GLASS DIA PENDANT BROWN

G-782CR - LBL Lighting - GLASS DIA PENDANT CLEAR

G-782GY - LBL Lighting - GLASS DIA PENDANT CHARCOAL

G-783BR - LBL Lighting - GLASS MINI-DIA PENDANT BROWN

G-783CR - LBL Lighting - GLASS MINI-DIA PENDANT CLEAR

G-783GY - LBL Lighting - GLASS MINI-DIA PENDANT CHARCOL

G-788SM - LBL Lighting - GLASS MOON DANCE 13 OUTD SMOKE

G-789SM - LBL Lighting - GLASS MOON DANCE 18 OUTD SMOKE

G-793BU - LBL Lighting - GLASS KENDALL PEND PEACOCK BLU

G-793SM - LBL Lighting - GLASS KENDALL PEND SMOKE

G-794OP - LBL Lighting - GLASS TINDRA PEND OPAL

G-794SM - LBL Lighting - GLASS TINDRA PEND SMOKE

G-795AM - LBL Lighting - OUTER GLASS PAIGE PENDANT AMBER

G-795CR - LBL Lighting - OUTER GLASS PAIGE PENDANT CLEAR

G-795SM - LBL Lighting - OUTER GLASS PAIGE PENDANT SMOKE

G-796BU - LBL Lighting - GLASS MINI-AKARI P STEEL BLUE

G-796SM - LBL Lighting - GLASS MINI-AKARI P SMOKE

G-797BU - LBL Lighting - GLASS AKARI PENDANT STEEL BLUE

G-797SM - LBL Lighting - GLASS AKARI PENDANT SMOKE

G-798EG - LBL Lighting - GLASS LILAH PENDANT EGGPLANT

G-798GY - LBL Lighting - GLASS LILAH PENDANT GRAY

G-823OP - LBL Lighting - GLASS RANIA BATH OPAL

G-824OP - LBL Lighting - GLASS ALBAN BATH OPAL

G-827SM - LBL Lighting - GLASS MOON DANCE OD FLSH SMOKE

G-828OP - LBL Lighting - OUTER GLASS PAIGE PENDANT INNER OPAL

G-834BU - LBL Lighting - GLASS ADARA PEND STEEL BLUE

G-834FR - LBL Lighting - GLASS ADARA PEND FROST

G-834SM - LBL Lighting - GLASS ADARA PEND SMOKE

G-849CR - LBL Lighting - GLASS SPHERE PENDANT CLEAR

G-849FR - LBL Lighting - GLASS SPHERE PENDANT FROST

G-849SM - LBL Lighting - GLASS SPHERE PENDANT SMOKE

G-859BL - LBL Lighting - GLASS MINI-ZURI PENDANT BLACK

G-859CP - LBL Lighting - GLASS MINI-ZURI PENDANT COPPER

G-859SI - LBL Lighting - GLASS MINI-ZURI PENDANT SILVER

G-869CR - LBL Lighting - GLASS ANELLA FLUSH CLEAR

G-869OP - LBL Lighting - GLASS ANELLA FLUSH OPAL

G-869SM - LBL Lighting - GLASS ANELLA FLUSH SMOKE

G-873CR - LBL Lighting - GLASS PRECIP FLUSH CLEAR

G-881CR - LBL Lighting - GLASS VARIA PENDANT CLEAR

G-881SM - LBL Lighting - GLASS VARIA PENDANT SMOKE

G-884GD - LBL Lighting - GLASS TRISTA PENDANT GOLD

G-885GD - LBL Lighting - GLASS TRISTA PENDANT GOLD

G-887GY - LBL Lighting - Glass Mini Miyu Gray

G-887SB - LBL Lighting - Glass Mini Miyu steel blue

G-888OP - LBL Lighting - Mini Miyu inner glass white

G-888OP - Tech Lighting - Inner White Glass

G-889FR - LBL Lighting - GLASS BRIOLETTE frost

G-889SM - LBL Lighting - GLASS BRIOLETTE smoke

G-935BU - LBL Lighting - Glass Monty Susp Blue

G-935MO - LBL Lighting - Glass Monty Susp Mocha

G-935OP - LBL Lighting - Glass Monty Susp Opal

G-935RD - LBL Lighting - Glass Monty Susp Red

G-936MO - LBL Lighting - Glass Monty Wall Mocha

G-936OP - LBL Lighting - Glass Monty Wall Opal

G-936RD - LBL Lighting - Glass Monty Wall Red

G-942CR - LBL Lighting - Karif glass clear

G-942OP - LBL Lighting - Karif glass opan

G-942SM - LBL Lighting - Karif glass smoke

G-944CR - LBL Lighting - Sphere Glass clear

G-953-SM - LBL Lighting - Smoke glass

G-953-WH - LBL Lighting - Clear glass

G-994-WH - LBL Lighting - White case/clear

G-AP10AM - LBL Lighting - Glass Bora Wall Amber

G-AP10OP - LBL Lighting - Glass Bora Wall Opal

G-AP11AM - LBL Lighting - Glass Iris Wall Amber

G-AP12AM - LBL Lighting - Glass Zeffiro Wall Amber

G-AP12OP - LBL Lighting - Glass Zeffiro Wall Opal

G-AP13OP - LBL Lighting - Glass Aliseo Wall Opal

G-AP14OP - LBL Lighting - Glass Mistral Wall Opal

G-AP19OC - LBL Lighting - Glass Taitu Wall Opal

G-AP24AM - LBL Lighting - Glass Wave Wall Amber

G-AP24OP - LBL Lighting - Glass Wave Wall Opal

G-LF6110-LG - LBL Lighting - Large Outer Frosted Glass

G-LF6110CONE - LBL Lighting - Inner Cone Frosted Glass

G-MT-FR - LBL Lighting - Glass Batons Frost

G-SL1851 - LBL Lighting - Glass, Baybridge Frost

G-TWINTUBE - LBL Lighting - Glass Twin Tube Frost

G1014 - Monte Carlo - Glass- Frost

G13038 - LBL Lighting - Glass Nikko Frost

G13075 - LBL Lighting - Glass Maro Frost

G13075 - Tech Lighting - Glass Maro Frost

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