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 >= '1141-018' and catalogpartcode <= '1203bb/10' order by ref_product.catalogpartcode,ref_product.id ;

1141-018 - Dimond Lighting - Webre 6 Light Chandelier In Matte Black And Gold Leaf

1141105 - Dimond Home - White Glass Desk

114158 - Dimond Home - Bent Glass Wall Mirror In Antique Silver Finish

114162 - Dimond Home - Metal Branch Wall Mirror

114172 - Dimond Home - Mirrored Console Table

114174 - Dimond Home - Mirrored Console Table With Clear Glass Top

114184 - Dimond Home - Antique Sunflower Wall Mirror

114187 - Dimond Home - Geometric Wall Mirror

114188 - Dimond Home - Arched Wall Mirror

1142-008 - Dimond Lighting - Chaumont 5 Light Chandelier In Antique Gold Leaf

1142-009 - Dimond Lighting - Chaumont 5 Light Flush Mount In Antique Gold Leaf

1142-010 - Dimond Lighting - Nexion 15 Light Chandelier In Black Chrome - Small

1142-011 - Dimond Lighting - Nexion 15 Light Chandelier In Black Chrome - Large

1145-003 - Sterling - Moravian Star Flush Mount - Gold 1145-003

1145-004 - Sterling - Moravian Star Flush Mount - Bronze 1145-004

1145-005 - Sterling - Moravian Star Flush Mount - Bronze With Clear Glass 1145-005

1145-006 - Sterling - Moravian Star Pendant - Gold 1145-006

1145-007 - Sterling - Moravian Star Pendant - Bronze 1145-007

1145-008 - Sterling - Moravian Star Pendant - Gold 1145-008

1145-009 - Sterling - Moravian Star Pendant - Bronze 1145-009

115-06 - Sterling - Sandyford Mirror

115-09 - Sterling - Fullerton Round Mirror

115-10 - Sterling - Franklin Oval Beveled Mirror

1151PS/10 - Cornerstone - Chatham 1 Light Mini Pendant In Oil Rubbed Bronze 1151PS/10

1151WS/10 - Cornerstone - Chatham 1 Light Sconce In Oil Rubbed Bronze 1151WS/10

1152BB/10 - Cornerstone - Chatham 2 Light Bath Bar In Oil Rubbed Bronze 1152BB/10

1153-016 - Dimond Home - Metal Wave Wall Art

1153-017 - Dimond Home - Metal Flame Table Top Scupture

1153-018 - Dimond Home - Metal Hoop Table Top Sculpture

1153-019 - Dimond Home - Metal Eye Wall Art 1153-019

1153BB/10 - Cornerstone - Chatham 3 Light Bath Bar In Oil Rubbed Bronze 1153BB/10

1153CH/10 - Cornerstone - Chatham 3 Light Chandelier In Oil Rubbed Bronze 1153CH/10

1154BB/10 - Cornerstone - Chatham 4 Light Bath Bar In Oil Rubbed Bronze 1154BB/10

1155CH/10 - Cornerstone - Chatham 5 Light Chandelier In Oil Rubbed Bronze 1155CH/10

116-002 - Sterling - Bronwood Mirror

116-005 - Sterling - Staffordshore Mirror

116832100 - Tech Lighting - SPACER

1179-001 - Dimond Home - Maison LED Mirror

1179-002 - Dimond Home - Maison Large LED Mirror

1179-003 - Dimond Home - Studio LED Mirror

1179-004 - Dimond Home - Montpellier LED Mirror

1179-005 - Dimond Home - Runway LED Mirror

1179-006 - Dimond Home - Oval LED Mirror

1179-007 - Dimond Lighting - Blabla LED Mirror

118-001 - Sterling - Wine Bottle Tray - Set Of 2 Trays

118-003 - Sterling - Set Of 2 Checked Trays

118-004 - Sterling - Set Of 2 Quartered Trays

118-008 - Sterling - Green Butterfly Clock

118-010 - Sterling - Busy Chef Clock

118-025 - Sterling - Violettes De Parme Clock

118-030 - Sterling - Vintage Reproduction Coat Stand

118-031 - Sterling - Rooster Wall Clock

118-032 - Sterling - French Wine Bottles - Wine Bottles Wall Clock

118-033 - Sterling - Bouquet Clock

118-034 - Sterling - Chateau Clock

118-036 - Sterling - Route 66 Clock

118-037 - Sterling - New York, New York Clock

118-042 - Sterling - Carte Postal Clock With Antique Cream Metal Frame

118-043 - Sterling - Chateau Renier Clock With Bronze Metal Frame

118-044 - Sterling - Kensington Station Clock With Antique Cream Metal Frame

1180-001 - Dimond Home - Kushk Rug Swatch Display Stand

11805069B - Tech Lighting - Strain Relief/ plastic cable clamp with set screw

120-008 - Sterling - Black Croc Coffee Table

1201-003 - Dimond Lighting - Stacked Geometric 1 Light Flair Pendant In Gold Plate

1201-004 - Dimond Lighting - Stacked Geometric 1 Light Slim Pendant In Gold Plate

1201PL/10 - Cornerstone - Conway 1 Light Pendant In Oil Rubbed Bronze 1201PL/10

1201PL/20 - Cornerstone - Conway 1 Light Pendant In Brushed Nickel 1201PL/20

1201PS/10 - Cornerstone - Conway 1 Light Mini Pendant In Oil Rubbed Bronze 1201PS/10

1201PS/20 - Cornerstone - Conway 1 Light Mini Pendant In Brushed Nickel 1201PS/20

1201WS/10 - Cornerstone - Conway 1 Light Bath Bar In Oil Rubbed Bronze 1201WS/10

1201WS/20 - Cornerstone - Conway 1 Light Bath Bar In Brushed Nickel 1201WS/20

1202BB/10 - Cornerstone - Conway 2 Light Bath Bar In Oil Rubbed Bronze 1202BB/10

1202BB/20 - Cornerstone - Conway 2 Light Bath Bar In Brushed Nickel 1202BB/20

1202CS/10 - Cornerstone - Conway 2 Light Semi-Flush In Oil Rubbed Bronze 1202CS/10

1202CS/20 - Cornerstone - Conway 2 Light Semi-Flush In Brushed Nickel 1202CS/20

1203-001 - Dimond Home - Leen Console

1203-003 - Dimond Home - Frankfurt Chair

1203-004 - Dimond Home - Frankfurt Desk

1203-005 - Dimond Home - Frankfurt Console

1203BB/10 - Cornerstone - Conway 3 Light Bath Bar In Oil Rubbed Bronze 1203BB/10

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