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 >= '502-1sw-led' and catalogpartcode <= '51-012/s2' order by ref_product.catalogpartcode,ref_product.id ;

502-1SW-LED - ELK Lighting - Verona 1 Light LED Pendant In Satin Nickel And Snow White Glass 502-1SW-LED

502-1YW - ELK Lighting - Verona 1 Light Pendant In Satin Nickel And Yellow Blaze Glass 502-1YW

502-1YW-LA - ELK Lighting - Verona 1 Light Pendant In Satin Nickel And Yellow Blaze Glass - Includes Recessed Lighting Kit 502-1YW-LA

502-1YW-LED - ELK Lighting - Verona 1 Light LED Pendant In Satin Nickel And Yellow Blaze Glass 502-1YW-LED

502-3BL - ELK Lighting - Verona 3 Light Pendant In Satin Nickel And Starburst Blue Glass 502-3BL

502-3ES - ELK Lighting - Verona 3 Light Pendant In Satin Nickel And Espresso Glass 502-3ES

502-3FR - ELK Lighting - Verona 3 Light Pendant In Satin Nickel And Fire Red Glass 502-3FR

502-3L-BL - ELK Lighting - Verona 3 Light Pendant In Satin Nickel And Starburst Blue Glass 502-3L-BL

502-3L-ES - ELK Lighting - Verona 3 Light Pendant In Satin Nickel And Espresso Glass 502-3L-ES

502-3L-FR - ELK Lighting - Verona 3 Light Pendant In Satin Nickel And Fire Red Glass 502-3L-FR

502-3L-SW - ELK Lighting - Verona 3 Light Pendant In Satin Nickel And Snow White Glass 502-3L-SW

502-3L-YW - ELK Lighting - Verona 3 Light Pendant In Satin Nickel And Yellow Blaze Glass 502-3L-YW

502-3SW - ELK Lighting - Verona 3 Light Pendant In Satin Nickel And Snow White Glass 502-3SW

502-3YW - ELK Lighting - Verona 3 Light Pendant In Satin Nickel And Yellow Blaze Glass 502-3YW

502-6BL - ELK Lighting - Verona 6 Light Pendant In Satin Nickel And Starburst Blue Glass 502-6BL

502-6ES - ELK Lighting - Verona 6 Light Pendant In Satin Nickel And Espresso Glass 502-6ES

502-6FR - ELK Lighting - Verona 6 Light Pendant In Satin Nickel And Fire Red Glass 502-6FR

502-6RC-BL - ELK Lighting - Verona 6 Light Pendant In Satin Nickel And Starburst Blue Glass 502-6RC-BL

502-6RC-ES - ELK Lighting - Verona 6 Light Pendant In Satin Nickel And Espresso Glass 502-6RC-ES

502-6RC-FR - ELK Lighting - Verona 6 Light Pendant In Satin Nickel And Fire Red Glass 502-6RC-FR

502-6RC-SW - ELK Lighting - Verona 6 Light Pendant In Satin Nickel And Snow White Glass 502-6RC-SW

502-6RC-YW - ELK Lighting - Verona 6 Light Pendant In Satin Nickel And Yellow Blaze Glass 502-6RC-YW

502-6SW - ELK Lighting - Verona 6 Light Pendant In Satin Nickel And Snow White Glass 502-6SW

502-6YW - ELK Lighting - Verona 6 Light Pendant In Satin Nickel And Yellow Blaze Glass 502-6YW

502019 - Pomeroy - Range Artifact Mantle Hurricane - Small

502057 - Pomeroy - Range Artifact Pillar Holder - Small

502064 - Pomeroy - Range Artifact Pillar Holder - Medium

502088 - Pomeroy - Range Artifact Mantle Hurricane - Large

502118 - Pomeroy - Range Mantle Hurricane - Small

502125 - Pomeroy - Range Mantle Hurricane - Large

502132 - Pomeroy - Cerise 15.9-Inch Pillar Holder

502149 - Pomeroy - Cerise 18.5-Inch Pillar Holder

502293 - Pomeroy - Melrose Centerpiece

502439 - Pomeroy - Aria Bowl

502460 - Pomeroy - Tanqueray Vase Large

502521 - Pomeroy - Versailles Runner

502576 - Pomeroy - Cassieo Bottle Vase 10.875-Inch

502583 - Pomeroy - Cassieo Bottle Vase 15.75-Inch

502606 - Pomeroy - Brandy Pillar Holder - Small

502613 - Pomeroy - Brandy Pillar Holder - Large

502620 - Pomeroy - Brandy Mantle Lighting

503 - Lamp Works - Aspen Bark Floor Lamp

503-LED - Lamp Works - Aspen Bark LED Floor Lamp

503610 - Pomeroy - Corona Hurricane

504068 - Pomeroy - Versailles Luna Bowl

504129 - Pomeroy - Liso Bottle Vase Small

504136 - Pomeroy - Liso Bottle Vase Large

505 - Lamp Works - Hand Applied Natural Shells Table Lamp

505-LED - Lamp Works - Hand Applied Natural Shells LED Table Lamp

5051/1 - ELK Lighting - Novelty 1 Light Prop Plane Semi Flush In Satin Nickel 5051/1

5052/2 - ELK Lighting - Novelty 2 Light Locomotive Train Semi Flush In Satin Nickel 5052/2

5056/3 - ELK Lighting - Novelty 3 Light Helicopter Pendant In Satin Nickel 5056/3

506079 - Pomeroy - Cassia Pedestal Bowl - Small

506123 - Pomeroy - Lafayette Chalise

506147 - Pomeroy - Lamaison Vase

507021 - Pomeroy - Westgate 5.9-Inch Pillar Holder

507038 - Pomeroy - Catherine Pillar Holder

507045 - Pomeroy - Guardian Pillar Holder

507076 - Pomeroy - Westgate 16.8-Inch Pillar Holder

5082/2 - ELK Lighting - Novelty 1 Light Race Car Pendant In Satin Nickel 5082/2

5084/1 - ELK Lighting - Novelty 1 Light Bi Plane Pendant In Walnut And Satin Glass 5084/1

5088/3 - ELK Lighting - Novelty 3 Light Night Sky Flushmount In Satin White Glass 5088/3

5088/3-LA - ELK Lighting - Novelty 3 Light Night Sky Flushmount In Satin White Glass With Recessed Lighting Kit 5088/3-LA

5089/3 - ELK Lighting - Novelty 3 Light Spaceman Flushmount In Satin Nickel And Matte Black 5089/3

5093/3 - ELK Lighting - Novelty 3 Light Wild Ride Pendant In Satin Nickel And Polished Chrome 5093/3

51-001 - Sterling - Decorative Accessory - Cubic Abstract Sculpture

51-002/S2 - Sterling - Accent Table - Set of 2 Angular Side Tables

51-0021 - Sterling - Set of 2 Verde Stacking Tables

51-004 - Sterling - Metal Frame Rivet Porthole Mirror

51-005/S3 - Sterling - Decorative Accessory - Set of 3 Open Structure Metal Orbs

51-0061 - Sterling - Leaopard - Leopard Drum Table

51-008 - Sterling - Rectangular Quatrefoil Bar Cart

51-0088 - Sterling - Set of 2 Austin Stacking Side Tables

51-009/S2 - Sterling - Accent Table - Set of 2 Modern Moorish Scroll Side Tables

51-0091 - Sterling - Set of 3 Beachcomber Candleholders

51-0095 - Sterling - Demille Side Table

51-0096 - Sterling - Beachcomber Bowl

51-010 - Sterling - Accent Table - Hexagon Frame Side Table

51-011/S2 - Sterling - Set of 2 Raised Frame Wall Mirrors

51-012/S2 - Sterling - Set of 2 Quatrefoil Wall Mirrors

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