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-469fr' and catalogpartcode <= 'g-5498bu' order by ref_product.catalogpartcode,ref_product.id ;

G-469FR - LBL Lighting - Glass Mojave Frost

G-469GR - LBL Lighting - Glass Mojave Green

G-469PR - LBL Lighting - Glass Mojave Amethyst

G-471AR - LBL Lighting - Glass Nave Crush Amber-Red

G-471BG - LBL Lighting - Glass Nave Crush Blue-Green

G-472AM - LBL Lighting - Glass, Cylia Pendant Amber

G-472BU - LBL Lighting - Glass, Cylia Pendant Blue

G-472OP - LBL Lighting - Glass, Cylia Pendant Opal

G-483AM - LBL Lighting - Glass, Mojave Wall Amber

G-483FR - LBL Lighting - Glass, Mojave Wall Frost

G-484LT - LBL Lighting - Glass Pavia Wall Latte

G-484OP - LBL Lighting - Glass Pavia Wall Opal

G-486OO - LBL Lighting - Glass Mia Bath Opal Opal

G-488AM - LBL Lighting - Glass Mojave Amber

G-488FR - LBL Lighting - Glass Mojave White

G-489AM - LBL Lighting - Glass Pavia Suspension Amber

G-489BR - LBL Lighting - Glass Pavia Suspension Brown

G-489LT - LBL Lighting - Glass Pavia Suspension Latte

G-490AM - LBL Lighting - Glass, Ruffle Suspension Amber

G-490LT - LBL Lighting - Glass, Ruffle Suspension Latte

G-491OP - LBL Lighting - Inner Glass

G-496OP - LBL Lighting - Glass Dover Bath Opal

G-504AM - LBL Lighting - Glass Dark Amber

G-504AQ - LBL Lighting - Glass Aquamarine

G-504IW - LBL Lighting - Glass Ivory Opaque

G-506AQ - LBL Lighting - Glass Pendant Aqua Isla Small

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

G-506CR - LBL Lighting - Glass Pendant Clear 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-542OP - LBL Lighting - Glass Aquarii Opal

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

G-545CR - LBL Lighting - Glass Mini Isis Pendant Clear

G-546CR - LBL Lighting - Glass Mini Rock Candy Clear

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

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