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

G-504AM - LBL Lighting - Glass Dark Amber

G-504AQ - LBL Lighting - Glass Aquamarine

G-506BR - LBL Lighting - Glass Pendant Brown Isla Small

G-508AM - LBL Lighting - Glass Mini Pavia Pend Amber

G-508BR - LBL Lighting - Glass Mini Pavia Pend Brown

G-508LT - LBL Lighting - Glass Mini Pavia Pend Latte

G-508OP - LBL Lighting - Glass Mini Pavia Pend Opal

G-509BL - LBL Lighting - Glass Mini Lily Pend Black

G-5100C - LBL Lighting - Glass Alu Bulkhead Oval Sm Fr

G-511BR - LBL Lighting - Glass Coliseum Pend Brown Red

G-511NT - LBL Lighting - Glass Coliseum Pnd Natural Alb

G-5120C - LBL Lighting - Glass Alu Bulkhead Oval Lg Fr

G-512AM - LBL Lighting - Glass Pendant Amber Isla Large

G-512AQ - LBL Lighting - Glass Pendant Aqua Isla Large

G-512CR - LBL Lighting - Glass Pendant Clear Isla Large

G-513OP-L - LBL Lighting - Glass Constellation Large Opal

G-5140C - LBL Lighting - Glass Alu Bulkhead Round Sm Fr

G-5160C - LBL Lighting - Glass Alu Bulkhead Round Lg Fr

G-5180OP - LBL Lighting - Glass Kona Susp Ii Opal

G-539AM - LBL Lighting - Glass Small Jasper Amber

G-539BR - LBL Lighting - Glass Small Jasper Brown

G-539CR - LBL Lighting - Glass Small Jasper Clear

G-539PR - LBL Lighting - Glass Small Jasper Purple

G-539SB - LBL Lighting - Glass Small Jasper Steel Blue

G-540OP - LBL Lighting - Glass Small Inner Jasper Opal

G-542IV - LBL Lighting - Glass Aquarii Ivory

G-542SB - LBL Lighting - Glass Aquarii Steel Blue

G-546PR - LBL Lighting - Glass Mini Rock Candy Amethyst

G-546SB - LBL Lighting - Glass Mini Rock Candy Stl Blue

G-546SM - LBL Lighting - Glass Mini Rock Candy Dk Smoke

G-547AM - LBL Lighting - Glass M Rock Candy Cylinder Am

G-547CR - LBL Lighting - Glass M Rock Candy Cylinder Cr

G-547PR - LBL Lighting - Glass M Rock Candy Cylinder Pr

G-547SB - LBL Lighting - Glass M Rock Candy Cylinder Sb

G-547SM - LBL Lighting - Glass M Rock Candy Cylinder Sm

G-548OP - LBL Lighting - Glass M Rock Candy Inner Op

G-548OP - Tech Lighting - Borrego Inner

G-5490BU - LBL Lighting - Glass Drop Susp Blue

G-5490OP - LBL Lighting - Glass Drop Susp Opal

G-5495SAM - LBL Lighting - Glass Tropez Suspension Amber

G-5495SCBU - LBL Lighting - Glass Tropez Suspension Blue

G-5495SGR - LBL Lighting - Glass Tropez Suspension Green

G-5495SOP - LBL Lighting - Glass Tropez Suspension Opal

G-5495SRD - LBL Lighting - Glass Tropez Suspension Red

G-5497AM - LBL Lighting - Glass Linear Wall Amber

G-5497BU - LBL Lighting - Glass Linear Wall Blue

G-5497GR - LBL Lighting - Glass Linear Wall Green

G-5497OP - LBL Lighting - Glass Linear Wall Opal

G-5497OP-L - LBL Lighting - Glass Linear Wall Opal

G-5497RD - LBL Lighting - Glass Linear Wall Red

G-5498AM - LBL Lighting - Glass Athena Wall Amber

G-5498BU - LBL Lighting - Glass Athena Wall Blue

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

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