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 >= '551-3l-md' and catalogpartcode <= '560002' order by ref_product.catalogpartcode,ref_product.id ;

551-3L-MD - ELK Lighting - Maple 3 Light Pendant In Satin Nickel And Maple Dusk Glass 551-3L-MD

551-3MA - ELK Lighting - Maple 3 Light Pendant In Satin Nickel And Maple Amber Glass 551-3MA

551-3MD - ELK Lighting - Maple 3 Light Pendant In Satin Nickel And Maple Dusk Glass 551-3MD

551-6MA - ELK Lighting - Maple 6 Light Pendant In Satin Nickel And Maple Amber Glass 551-6MA

551-6MD - ELK Lighting - Maple 6 Light Pendant In Satin Nickel And Maple Dusk Glass 551-6MD

551-6RC-MA - ELK Lighting - Maple 6 Light Pendant In Satin Nickel And Maple Amber 551-6RC-MA

551-6RC-MD - ELK Lighting - Maple 6 Light Pendant In Satin Nickel And Maple Dusk 551-6RC-MD

551222 - Pomeroy - Leif Vase Small

551246 - Pomeroy - Leif Round Vase

551253 - Pomeroy - Virginia Planter Round

551260 - Pomeroy - Virginia Vase Small

551277 - Pomeroy - Virginia Vase - Large

551307 - Pomeroy - Malaya Planter

551314 - Pomeroy - Malaya Vase 15.5-Inch

551321 - Pomeroy - Malaya Vase 25.75-Inch

551338 - Pomeroy - Malaya Vase 34.875-Inch

551345 - Pomeroy - Malaya Umbrella Stand

551352 - Pomeroy - Malaya S2 Bowls

551369 - Pomeroy - Malaya Garden Stool

551406 - Pomeroy - Leif Umbrella Stand

551413 - Pomeroy - Leif Rectangle Planter

551437 - Pomeroy - Cherub Garden Statue

551444 - Pomeroy - Cottontail Catchpot

551451 - Pomeroy - Lark Catchpot

551468 - Pomeroy - Porter Set of 2 Pots

551475 - Pomeroy - Northgate Pillar Holder Small

551482 - Pomeroy - Northgate Pillar Holder - Medium

551505 - Pomeroy - Northgate Urn

551512 - Pomeroy - Rondale Urn

551529 - Pomeroy - Harrison Pillar Holder Small

551536 - Pomeroy - Harrison Pillar Holder Large

551543 - Pomeroy - Shell Catchpot

551550 - Pomeroy - Owl Catchpot

551567 - Pomeroy - Tempest Round Planter

551574 - Pomeroy - Tempest Vase - Small

551581 - Pomeroy - Tempest Vase - Medium

551604 - Pomeroy - Tempest Stool

551611 - Pomeroy - Aquatica Set of 2 Planters

551628 - Pomeroy - Aquatica Vase Small

551659 - Pomeroy - Aquatica Stool-Table

551666 - Pomeroy - Tumbler Jar Small

551673 - Pomeroy - Tumbler Jar Medium

551680 - Pomeroy - Tumbler Jar Large

552001 - Dimond Home - Silver Vortex Hurricane

552002 - Dimond Home - Silver Vortex Bowl

552003 - Dimond Home - Gold Vortex Hurricane

552004 - Dimond Home - Gold Vortex Dish

552007 - Pomeroy - Hana Vase Small

552014 - Pomeroy - Hana Vase - Large

552038 - Pomeroy - Ripples Set of 3 Jars

552045 - Pomeroy - Cupola Set of 3 Jars

555008 - Pomeroy - Mission Waste Bin

555015 - Pomeroy - Mission Tissue Box

555077 - Pomeroy - Mission Vanity Tray - Small

555084 - Pomeroy - Mission Vanity Tray - Large

555107 - Pomeroy - Vintage Vanity Tray

5551BB/10 - Cornerstone - Shelburne 1 Light Bathbar In Oil Rubbed Bronze 5551BB/10

5552BB/10 - Cornerstone - Shelburne 2 Light Bathbar In Oil Rubbed Bronze 5552BB/10

5553BB/10 - Cornerstone - Shelburne 3 Light Bathbar In Oil Rubbed Bronze 5553BB/10

5554BB/10 - Cornerstone - Shelburne 4 Light Bathbar In Oil Rubbed Bronze 5554BB/10

555W - Lamp Works - Grand Pyramid Table Lamp In White Wash

555W-LED - Lamp Works - Grand Pyramid LED Table Lamp In White Wash

559001 - Dimond Home - Gondola Boat Basket - Small

559002 - Dimond Home - Gondola Boat Basket - Medium

559003 - Dimond Home - Gondola Boat Basket - Large

559004 - Dimond Home - Twisted Wire Dish - Small

559005 - Dimond Home - Twisted Wire Dish - Medium

559006 - Dimond Home - Twisted Wire Dish - Large

559008 - Dimond Home - Brass Scribble Bird - Small

559009 - Dimond Home - Brass Scribble Bird - Large

559010 - Dimond Home - Nickel Scribble Bird - Small

559011 - Dimond Home - Nickel Scribble Bird - Large

559150 - Pomeroy - Entrelas Vase 22.5-Inch

559174 - Pomeroy - Entrelas Decorative Plate 20-Inch

559181 - Pomeroy - Entrelas Bowl

559198 - Pomeroy - Ondine 9.5-Inch Vase

559204 - Pomeroy - Ondine 18-Inch Vase

559266 - Pomeroy - Lilia 24-Inch Vase

559280 - Pomeroy - Aquatica 20-Inch Vase

560002 - Pomeroy - Prairie Votive Mantle Lighting

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