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 >= '980016/s2' and catalogpartcode <= '997-aw-17' order by ref_product.catalogpartcode,ref_product.id ;

980016/S2 - Dimond Home - Small Dimpled Crystal Cubes - Set of 2

980017/S2 - Dimond Home - Large Dimpled Crystal Cubes - Set of 2

980018/S2 - Dimond Home - Square Tuxedo Crystal Pedestal Candleholders - Set of 2

980019/S2 - Dimond Home - Tuxedo Crystal - Round Crystal Tuxedo Pedestal Candleholders - Set of 2

980020/S2 - Dimond Home - Windowpane Crystal Column Candleholders - Set of 2

980021/S2 - Dimond Home - Fluted Crystal Column Candleholders - Set of 2

980024/S2 - Dimond Home - Tuxedo Crystal Votive - Set of 2

980025/S2 - Dimond Home - Round Tuxedo Crystal Candleholder - Set of2

983-001 - Dimond Lighting - Black Mercury Glass Table Lamp In Silver And Black

983-001-LED - Dimond Lighting - Black Mercury Glass LED Table Lamp In Silver And Black

983-002 - Dimond Lighting - Dimond - Antique Mercury Glass Table Lamp in Gold

983-002-LED - Dimond Lighting - Dimond - Antique Mercury Glass LED Table Lamp in Gold

983-003 - Dimond Lighting - Black Mercury Gourd Table Lamp With Pure White Shade

983-003-LED - Dimond Lighting - Black Mercury Gourd LED Table Lamp With Pure White Shade

983-004 - Dimond Lighting - Dumbell Table Lamp in Grey

983-004-LED - Dimond Lighting - Dumbell LED Table Lamp in Grey

983-005 - Dimond Lighting - Bubble Table Lamp in Clear Glass With Off White Shade

983-005-LED - Dimond Lighting - Bubble LED Table Lamp in Clear Glass With Off White Shade

983-006 - Dimond Lighting - Bubble Glass Table Lamp in Silver Mercury

983-006-LED - Dimond Lighting - Bubble Glass LED Table Lamp in Silver Mercury

983-007 - Dimond Lighting - Chain Mail Raindrop Table Lamp in Silver Mercury

983-007-LED - Dimond Lighting - Chain Mail Raindrop LED Table Lamp in Silver Mercury

983-008 - Dimond Lighting - Chain Mail Raindrop Table Lamp in Silver Mercury and Gold

983-008-LED - Dimond Lighting - Chain Mail Raindrop LED Table Lamp in Silver Mercury and Gold

983-009 - Dimond Home - 1 Light Pendant In Antique Gold Mercury Glass

983-010 - Dimond Home - Porthole Mirror In Dark Grey Stain

983-011 - Dimond Home - Clover Table In Dark Brown And Oil Rubbed Bronze

983-012 - Dimond Home - Nail-Head Banded Hurricane

983-013/S3 - Dimond Home - Mango Wood Hurricanes In White Washed Dark Grey Stain

983-014/S3 - Dimond Home - Black Mercury Drip Hurricanes

985-001 - Dimond Home - Iron Taper Wire Chair In Gold And Black

985-002 - Dimond Home - Chain Link Mirror

985-004 - Dimond Home - Coined Regency Mirror

985-005 - Dimond Home - Retro Diamond Cabinet

985-009 - Dimond Home - Retro Flat Panel Pendant

985-010 - Dimond Home - Spencer Chest

985-011 - Dimond Home - Drum Bar Table

985-017 - Dimond Home - Wide Belt Flower Mirror

985-018 - Dimond Home - Retro 1 Light Pendant In Natural Mango Wood

985-019 - Dimond Home - Diamond Cut Mirror

985-023 - Dimond Home - Retro 6-Light Spoke Pendant

985-024 - Dimond Home - Quatrefoil Brass Clad Mirror

985-025 - Dimond Home - Large Brass Clad Ribbed Pendant

985-026 - Dimond Home - Medium Brass Clad Ribbed Pendant

985-027 - Dimond Home - Small Brass Clad Ribbed Pendant

985-032 - Dimond Home - Plaid Nail Head Cabinet

985-034 - Dimond Home - Plaid Nail Head Chest

985-037 - Dimond Home - Wooden Sundial Side Table

985-038 - Dimond Home - Wooden Sundial Coffee Table

985-039 - Dimond Home - Wooden Sundial Console Table

985-040 - Dimond Home - Oversized Porthole Mirror

985-041 - Dimond Home - Decorative Kiwi In Mango Wood And Brass

985-042 - Dimond Home - Faceted Stool With Brass Cladding

985-044 - Dimond Home - Teak And Metal Carousel Chair

985-045 - Dimond Home - Teak And Metal Carousel Table - Tall

985-046 - Dimond Home - Teak And Metal Carousel Table - Short

990-D - ELK Lighting - Tiffany Buckingham 2 Light Flushmount In Vintage Antique 990-D

990-J - ELK Lighting - Diamond Ring 2 Light Flushmount In Burnished Copper

992 - Lamp Works - Chrome LED Desk Lamp

993 - Lamp Works - Chrome LED Floor Lamp

996269 - Pomeroy - House Set of 2 Shelves

996276 - Pomeroy - Quadro Set of 3 Wall Shelves

996290 - Pomeroy - Tawny Wall Shelf

997-AW-01 - ELK Lighting - Mix-N-Match 3 Light Semi Flush In Aged Walnut 997-AW-01

997-AW-01-LED - ELK Lighting - Mix-N-Match 3 Light LED Semi Flush In Aged Walnut 997-AW-01-LED

997-AW-03 - ELK Lighting - Mix-N-Match 3 Light Semi Flush In Aged Walnut And Honey Dune Glass 997-AW-03

997-AW-03-LED - ELK Lighting - Mix-N-Match 3 Light LED Semi Flush In Aged Walnut And Honey Dune Glass 997-AW-03-LED

997-AW-04 - ELK Lighting - Mix-N-Match 3 Light Semi Flush In Aged Walnut 997-AW-04

997-AW-04-LED - ELK Lighting - Mix-N-Match 3 Light LED Semi Flush In Aged Walnut 997-AW-04-LED

997-AW-07 - ELK Lighting - Mix-N-Match 3 Light Semi Flush In Aged Walnut And Stained Glass 997-AW-07

997-AW-07-LED - ELK Lighting - Mix-N-Match 3 Light LED Semi Flush In Aged Walnut And Stained Glass 997-AW-07-LED

997-AW-09 - ELK Lighting - Mix-N-Match 3 Light Semi Flush In Aged Walnut 997-AW-09

997-AW-09-LED - ELK Lighting - Mix-N-Match 3 Light LED Semi Flush In Aged Walnut 997-AW-09-LED

997-AW-10 - ELK Lighting - Mix-N-Match 3 Light Semi Flush In Aged Walnut 997-AW-10

997-AW-10-LED - ELK Lighting - Mix-N-Match 3 Light LED Semi Flush In Aged Walnut 997-AW-10-LED

997-AW-12 - ELK Lighting - Mix-N-Match 3 Light Semi Flush In Aged Walnut 997-AW-12

997-AW-12-LED - ELK Lighting - Mix-N-Match 3 Light LED Semi Flush In Aged Walnut 997-AW-12-LED

997-AW-13 - ELK Lighting - Mix-N-Match 3 Light Semi Flush In Aged Walnut 997-AW-13

997-AW-13-LED - ELK Lighting - Mix-N-Match 3 Light LED Semi Flush In Aged Walnut 997-AW-13-LED

997-AW-17 - ELK Lighting - Mix-N-Match 3 Light Semi Flush In Aged Walnut 997-AW-17

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