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 >= '4003/6+3amb' and catalogpartcode <= '406-1fr-la' order by ref_product.catalogpartcode,ref_product.id ;

4003/6+3AMB - ELK Lighting - Opulence 9 Light Chandelier In Antique White And Amber Crystal

4003/6+3AQ - ELK Lighting - Opulence 9 Light Chandelier In Antique White And Aqua Crystal

4003/6+3CL - ELK Lighting - Opulence 9 Light Chandelier In Antique White And Clear Crystal

4003/6+3LM - ELK Lighting - Opulence 9 Light Chandelier In Antique White And Lime Crystal

4003/6+3RS - ELK Lighting - Opulence 9 Light Chandelier In Antique White And Rose Crystal

400704 - Pomeroy - Canal Spheres - Set of 3

400735 - Pomeroy - Canal Mirror

400742 - Pomeroy - Canal 4-Inch Sphere

401 - Lamp Works - Cigar Pendant In White

401-LED - Lamp Works - Cigar LED Pendant In White

4010/2AMB - ELK Lighting - Opulence 2 Light Wall Sconce In Rust And Amber Crystal

4010/2AQ - ELK Lighting - Opulence 2 Light Wall Sconce In Rust And Aqua Crystal

4010/2CL - ELK Lighting - Opulence 2 Light Wall Sconce In Rust And Clear Crystal

4010/2LM - ELK Lighting - Opulence 2 Light Wall Sconce In Rust And Lime Crystal

4010/2RS - ELK Lighting - Opulence 2 Light Wall Sconce In Rust And Rose Crystal

401022 - Pomeroy - Prescott Lantern

401039 - Pomeroy - Claremont Lantern

4011/3AMB - ELK Lighting - Opulence 3 Light Chandelier In Rust And Amber Crystal

4011/3AQ - ELK Lighting - Opulence 3 Light Chandelier In Rust And Aqua Crystal

4011/3CL - ELK Lighting - Opulence 3 Light Chandelier In Rust And Clear Crystal

4011/3LM - ELK Lighting - Opulence 3 Light Chandelier In Rust And Lime Crystal

4011/3RS - ELK Lighting - Opulence 3 Light Chandelier In Rust And Rose Crystal

401169 - Pomeroy - Willow Floor Hurricane Small

401176 - Pomeroy - Willow Floor Hurricane Medium

401183 - Pomeroy - Willow Floor Hurricane Large

4012/5AMB - ELK Lighting - Opulence 5 Light Chandelier In Rust And Amber Crystal

4012/5AQ - ELK Lighting - Opulence 5 Light Chandelier In Rust And Aqua Crystal

4012/5CL - ELK Lighting - Opulence 5 Light Chandelier In Rust And Clear Crystal

4012/5LM - ELK Lighting - Opulence 5 Light Chandelier In Rust And Lime Crystal

4012/5RS - ELK Lighting - Opulence 5 Light Chandelier In Rust And Rose Crystal

401299 - Pomeroy - Revere Lantern

4013/6+3AMB - ELK Lighting - Opulence 9 Light Chandelier In Rust And Amber Crystal

4013/6+3AQ - ELK Lighting - Opulence 9 Light Chandelier In Rust And Aqua Crystal

4013/6+3CL - ELK Lighting - Opulence 9 Light Chandelier In Rust And Clear Crystal

4013/6+3LM - ELK Lighting - Opulence 9 Light Chandelier In Rust And Lime Crystal

4013/6+3RS - ELK Lighting - Opulence 9 Light Chandelier In Rust And Rose Crystal

401305 - Pomeroy - Bali Lantern - Small

401329 - Pomeroy - Taos Small Lantern In Burned Copper

401336 - Pomeroy - Taos Large Lantern In Burned Copper

401343 - Pomeroy - Taos Small Lantern In Antique White

401350 - Pomeroy - Taos Large Lantern In Antique White

401367 - Pomeroy - Bali Lantern

401374 - Pomeroy - Bali 4-Inch Decorative Sphere

401527 - Pomeroy - Hathaway Set of 3 Nesting Lanterns

401534 - Pomeroy - Jackson Square S3 Nesting Lanterns

401541 - Pomeroy - Candice Lantern In Antique Azure

401558 - Pomeroy - Candice Lantern In Antique Wheat

401640 - Pomeroy - Ballantine Lantern

401657 - Pomeroy - Caruth Lantern

401664 - Pomeroy - Cooperstown Lantern

401671 - Pomeroy - Alpine Set of 2 Lanterns

401688 - Pomeroy - Calico Hotel Hurricane

402 - Lamp Works - Cigar Swingarm Wall Sconce In White

402-LED - Lamp Works - Cigar LED Swingarm Wall Sconce In White

4021/1 - ELK Lighting - Elise 1 Light Pendant In Rust And Clear Crystal

402449 - Pomeroy - Clifton Lantern - Small

402456 - Pomeroy - Clifton Lantern Large

403 - Lamp Works - Cigar Floor Lamp In Satin Nickel And White

403-LED - Lamp Works - Cigar LED Floor Lamp In Satin Nickel And White

4040/3 - ELK Lighting - Elise 3 Light Chandelier In Antique White

4041/3 - ELK Lighting - Minique - Elise 3 Light Chandelier In Antique White

4041/3-LA - ELK Lighting - Minique - Elise 3 Light Chandelier In Antique White - Includes Recessed Lighting Kit

404276 - Pomeroy - Malta Hurricane Small

404283 - Pomeroy - Malta Hurricane Large

4050/2 - ELK Lighting - Rosavita 2 Light Wall Sconce In Antique White And Pink

4051/1 - Dimond Lighting - Mary-Kate and Ashley Rosavita Table Lamp in White and Pink

4051/1-LED - Dimond Lighting - Mary-Kate and Ashley Rosavita LED Table Lamp in White and Pink

4052/3 - ELK Lighting - Rosavita 3 Light Semi Flush In Antique White And Pink

4052/3-LA - ELK Lighting - Rosavita 3 Light Semi Flush In Antique White And Pink - Includes Recessed Lighting Kit

4053/3 - ELK Lighting - Rosavita 3 Light Chandelier In Antique White And Pink

4053/3-LA - ELK Lighting - Rosavita 3 Light Chandelier In Antique White And Pink - Includes Recessed Lighting Kit

4054/5 - ELK Lighting - Rosavita 5 Light Chandelier In Antique White And Pink

406-1BL - ELK Lighting - Classico 1 Light Pendant In Dark Rust And Starburst Blue Glass 406-1BL

406-1BL-LA - ELK Lighting - Classico 1 Light Pendant In Dark Rust And Starburst Blue Glass - Includes Recessed Lighting Kit 406-1BL-LA

406-1BL-LED - ELK Lighting - Classico 1 Light LED Pendant In Dark Rust And Starburst Blue Glass 406-1BL-LED

406-1ES - ELK Lighting - Classico 1 Light Pendant In Dark Rust And Espresso Glass 406-1ES

406-1ES-LA - ELK Lighting - Classico 1 Light Pendant In Dark Rust And Espresso Glass - Includes Recessed Lighting Kit 406-1ES-LA

406-1ES-LED - ELK Lighting - Classico 1 Light LED Pendant In Dark Rust And Espresso Glass 406-1ES-LED

406-1FR - ELK Lighting - Classico 1 Light Pendant In Dark Rust And Fire Red Glass 406-1FR

406-1FR-LA - ELK Lighting - Classico 1 Light Pendant In Dark Rust And Fire Red Glass - Includes Recessed Lighting Kit 406-1FR-LA

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