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 >= '1453bb/10' and catalogpartcode <= '146tddelbr' order by ref_product.catalogpartcode,ref_product.id ;

1453BB/10 - Cornerstone - Kingston 3 Light Bath Bar In Oil Rubbed Bronze 1453BB/10

1453CH/10 - Cornerstone - Kingston 3 Light Chandelier In Oil Rubbed Bronze 1453CH/10

1454BB/10 - Cornerstone - Kingston 4 Light Bath Bar In Oil Rubbed Bronze 1454BB/10

1455CH/10 - Cornerstone - Kingston 5 Light Chandelier In Oil Rubbed Bronze 1455CH/10

145643 - Pomeroy - Inferno Bowl

146ARTICGGB - Tech Lighting - Shade Artic Grande Gold/Black

146ARTICGGW - Tech Lighting - Shade Artic Grande Gold/White

146ARTICGSB - Tech Lighting - Shade Artic Grande Silver/Blk

146ARTICGSW - Tech Lighting - Shade Artic Grande Silver/Wht

146BOREPGR - Tech Lighting - Boreal - Khaki Green - Replacement Component

146BOREPIV - Tech Lighting - Boreal - Ivory - Replacement Component

146BOREWGR - Tech Lighting - Boreal - Bottom Glass Diffuser - Replacement Component

146CHACLDC - Tech Lighting - Chambers Ceiling Large - Desert Clay - Replacement Component

146CHACLWH - Tech Lighting - Chambers Ceiling Large - White - Replacement Component

146CHACSDC - Tech Lighting - Chambers Ceiling Small - Desert Clay - Replacement Component

146CHACSWH - Tech Lighting - Chambers Ceiling Small - White - Replacement Component

146EDGETBK - Tech Lighting - Edge - Black Replacement Shade

146EDGETDC - Tech Lighting - Edge - Desert Clay Replacement Shade

146EDGETWH - Tech Lighting - Edge - White Replacement Shade

146KAIPOBR - Tech Lighting - Kai - Brown Shade - Replacement Component

146KAIPORD - Tech Lighting - Kai - Dark Red Shade - Replacement Component

146KAIPOWH - Tech Lighting - Kai - White Shade - Replacement Component

146KIELBK - Tech Lighting - Kiev Large - Shade,Kiev Lrg Pend Black - Replacement Component

146KIELWH - Tech Lighting - Large - Shade,Kiev Lrg Pend White - Replacement Component

146KIEPWH - Tech Lighting - Shade White - Replacement Component

146LENOXCA - Tech Lighting - Lenox - Shade,Lenox Camel - Replacement Component

146LENOXCB - Tech Lighting - Lenox - Shade,Lenox Choclate Brown - Replacement Component

146LENOXCG - Tech Lighting - Lenox - Shade,Lenox Charcoal Gray - Replacement Component

146LEXWSDC - Tech Lighting - Lexington Wall - White - Replacement Component

146LEXWSWH - Tech Lighting - Lexington Wall - Amber - Replacement Component

146LOGANCA - Tech Lighting - Logan - Logan Shade Camel - Replacement Component

146LOGANCB - Tech Lighting - Logan - Logan Shade Chocolate Brown - Replacement Component

146LOGANCG - Tech Lighting - Logan - Logan Shade Charcoal Gray - Replacement Component

146LSHUIGY - Tech Lighting - Shui Linear Chandelier - Shade,Linear Shui Gray - Replacement Component

146LSHUIOM - Tech Lighting - Shui Linear Chandelier - Shade,Linear Shui Golden Brz - Replacement Component

146LSHUIWH - Tech Lighting - Shui Linear Chandelier - Shade,Linear Shui White - Replacement Component

146MALOCBN - Tech Lighting - Madrid Large - Madrid Med Outer Cover Brown - Replacement Component

146MALOCCA - Tech Lighting - Madrid Large - Madrid Med Outer Cover Camel - Replacement Component

146MALOCTA - Tech Lighting - Madrid Large - Madrid Med Outer Cover Taupe - Replacement Component

146MAMOCBN - Tech Lighting - Madrid Medium - Madrid Med Outer Cover Brown - Replacement Component

146MAMOCCA - Tech Lighting - Madrid Medium - Madrid Med Outer Cover Camel - Replacement Component

146MAMOCTA - Tech Lighting - Madrid Medium - Madrid Med Outer Cover Taupe - Replacement Component

146MARSHFG - Tech Lighting - Marshall Shade Fog

146MARSHGY - Tech Lighting - Shade,Marshall Grey Herringbn

146MARSHSA - Tech Lighting - Marshall Shade Sand

146MARTICGW - Tech Lighting - Shade Mini-Artic Gold/White

146MARTICSB - Tech Lighting - Shade Mini-Artic Silver/Black

146MASOCBN - Tech Lighting - Madrid - Wool Covering Chocolate Brown - Replacement Component

146MASOCCA - Tech Lighting - Madrid - Wool Covering Camel - Replacement Component

146MASOCTA - Tech Lighting - Madrid - Wool Covering Taupe - Replacement Component

146MDILLWH - Tech Lighting - Mini Dillon - White Shade - Replacement Component

146MERCEBN - Tech Lighting - Chocolate Brown

146MERCEBR - Tech Lighting - Mercer Suspension - Chocolate Brown - Replacement Component

146MERCEDC - Tech Lighting - Mercer Suspension - Desert Clay - Replacement Component

146MERCEWH - Tech Lighting - Mercer Suspension - White - Replacement Component

146MULCLBN - Tech Lighting - Mulberry Pendant - Chocolate Brown - Replacement Component

146MULCLDC - Tech Lighting - Mulberry Ceiling Large - Desert Clay - Replacement Component

146MULCLOG - Tech Lighting - Mulberry Pendant - Olive Green - Replacement Component

146MULCLWH - Tech Lighting - Mulberry Ceiling Large - White - Replacement Component

146MULCSDC - Tech Lighting - Mulberry Ceiling Small - Desert Clay - Replacement Component

146MULCSWH - Tech Lighting - Mulberry Ceiling Small - White - Replacement Component

146PALMTDC - Tech Lighting - Palma Table - Desert Clay

146PALMTWH - Tech Lighting - Palma Table - White Fabric

146SABRWCA - Tech Lighting - Sable Wall Round - Camel - Replacement Shade

146SABRWCB - Tech Lighting - Sable Wall Round - Choc Brown - Replacement Shade

146SABRWIV - Tech Lighting - Sable Wall Round - Ivory - Replacement Shade

146SABRWST - Tech Lighting - Sable Wall Round - Stone - Replacement Shade

146SABSWCA - Tech Lighting - Sable Wall Square - Camel - Replacement Shade

146SABSWCB - Tech Lighting - Sable Wall Square - Choc Brown - Replacement Shade

146SABSWCG - Tech Lighting - Sable Wall Square - Charcoal Grey - Replacement Shade

146SABSWST - Tech Lighting - Sable Wall Square - Stone - Replacement Shade

146SPIRLCA - Tech Lighting - Spire Chandelier - Shade,Spire Lrg Camel - Replacement Component

146SPIRLCG - Tech Lighting - Spire Chandelier - Shade,Spire Lrg Charcoal Gray - Replacement Component

146SPIRLCH - Tech Lighting - Spire Chandelier - Shade,Spire Lrg Chocolate - Replacement Component

146SPIRMCA - Tech Lighting - Spire Chandelier - Shade,Spire Med Camel - Replacement Component

146SPIRMCG - Tech Lighting - Spire Chandelier - Shade,Spire Med Charcoal Gray - Replacement Component

146SPIRMCH - Tech Lighting - Spire Chandelier - Shade,Spire Med Chocolate - Replacement Component

146SPIRSCA - Tech Lighting - Spire Chandelier - Shade,Spire Sml Camel - Replacement Component

146SPIRSCH - Tech Lighting - Spire Chandelier - Shade,Spire Sml Chocolate - Replacement Component

146TDDELBR - Tech Lighting - Delancey Pendant - Chocolate Brown - Replacement Component

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