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 >= '464038' and catalogpartcode <= '47021/1-led' order by ref_product.catalogpartcode,ref_product.id ;

464038 - Dimond Home - Macaw Well Vase - Small

464050 - Dimond Home - Champagne Fizz Fluted Vase

464052 - Dimond Home - Slate Husk Vase - Small

464053 - Dimond Home - Slate Husk Vase - Large

464054 - Dimond Home - Corn Husk Vase - Small

464055 - Dimond Home - Corn Husk Vase - Large

464056 - Dimond Home - Milk Bouquet Cut Votive

464057 - Dimond Home - Milk Bouquet Cut Vase

464058 - Dimond Home - Jet Bouquet Cut Votive

464064 - Dimond Home - Champagne Fizz Fluted Votive - Small

464065 - Dimond Home - Champagne Fizz Fluted Votive - Large

464066 - Dimond Home - Marine Fizz Fluted Votive - Small

464067 - Dimond Home - Marine Fizz Fluted Votive - Large

464069 - Dimond Home - Frosted Glacier Tile Vase

464073 - Dimond Home - Bubble Vase Gray

464074/S2 - Dimond Home - Cobalt Ring Vase - Set of 2

464075/S2 - Dimond Home - Cobalt Ring Votives - Set of 2

464076/S2 - Dimond Home - Field Bubble Votives - Set of 2

464077 - Dimond Home - Field Bubble Vase

464078/S2 - Dimond Home - Bubble Votives - Whirl Bubble Votive - Set of 2

464079 - Dimond Home - Whirl Bubble Vase

464081/S2 - Dimond Home - Umber Matte Cut Vases - Set of 2

464083/S2 - Dimond Home - Smoke Matte Cut Vases - Set of 2

464084/S2 - Dimond Home - Smoke Ring Votive - Set of 2

466002 - Dimond Home - Oval Ring Drum Pendant In Weathered Grey

466006 - Dimond Home - White Drum Oval Ring Lamp

466045 - Dimond Home - Fish Scale Baskets - Small Natural Fish Scale Basket

466046 - Dimond Home - Fish Scale Baskets - Medium Natural Fish Scale Basket

466047 - Dimond Home - Fish Scale Baskets - Large Natural Fish Scale Basket

466051 - Dimond Home - Fish Scale Baskets - Small Fish Scale Basket In Red And Orange

466052 - Dimond Home - Fish Scale Baskets - Medium Fish Scale Basket In Red And Orange

466053 - Dimond Home - Fish Scale Baskets - Large Fish Scale Basket In Red And Orange

468-017 - Sterling - Coffee Table - Ruby & Gold Side Table

468-018 - Sterling - Vases & Jars - Mosaic Bottle - Short

468-019 - Sterling - Vases & Jars - Mosaic Bottle - Tall

468-021 - Dimond Lighting - Bark Table Lamp in Gold And Natural Linen

468-021-LED - Dimond Lighting - Bark LED Table Lamp in Gold And Natural Linen

468-022 - Dimond Lighting - Tree Branch Table Lamp in Nickel

468-022-LED - Dimond Lighting - Tree Branch LED Table Lamp in Nickel

468-023 - Dimond Lighting - Gingko Leaf - Ginkgo Leaf Table Lamp in Rose Gold

468-023-LED - Dimond Lighting - Gingko Leaf - Ginkgo Leaf LED Table Lamp in Rose Gold

468-025 - Dimond Lighting - Slate Slab Table Lamp in Gold With Natural Linen Shade

468-025-LED - Dimond Lighting - Slate Slab LED Table Lamp in Gold With Natural Linen Shade

468-026 - Dimond Lighting - Slate Slab Table Lamp in Nickel With Natural Linen Shade

468-026-LED - Dimond Lighting - Slate Slab LED Table Lamp in Nickel With Natural Linen Shade

468-030 - Dimond Lighting - Wide Leaf Table Lamp in Nickel With Natural Linen Shade

468-030-LED - Dimond Lighting - Wide Leaf LED Table Lamp in Nickel With Natural Linen Shade

468-031 - Dimond Lighting - Tall Leaf Table Lamp in Nickel With Natural Linen Shade

468-031-LED - Dimond Lighting - Tall Leaf LED Table Lamp in Nickel With Natural Linen Shade

468-032 - Dimond Lighting - Twisted Bark Table Lamp in Nickel

468-032-LED - Dimond Lighting - Twisted Bark LED Table Lamp in Nickel

468-034 - Dimond Home - Coral Bowl

468-035 - Dimond Home - Large Textured Bowl

468-037 - Dimond Home - Small Textured Bowl

468-038 - Dimond Home - Bark Tray

468-040/S2 - Dimond Home - Champagne Brown Ginkgo Wall Leaf

468-041/S2 - Dimond Home - Rose Gold Ginkgo Wall Leaf

468-043/S2 - Dimond Home - Giant Rose Gold Ginkgo Wall Leaf

468-048 - Dimond Home - Nickel Star Leaf Bowl

468-049 - Dimond Home - Rose Gold Star Leaf Bowl

468-050/S2 - Dimond Home - O Hurricane In Frosted White Mercury

468-051 - Dimond Home - Organic Metal Etched Disk Chandelier

468-055 - Dimond Home - White Mercury Bowl

468-057 - Dimond Home - Black Mercury Bowl

468001 - Dimond Home - Gilded Sea Dish - Small

468002 - Dimond Home - Gilded Sea Dish - Large

468003 - Dimond Home - Gilded Sea Hurricane - Small

468004 - Dimond Home - Gilded Sea Hurricane - Large

468005 - Dimond Home - Gilded Sea Votive

468014 - Dimond Home - Silver Leaf Tray

468016 - Dimond Home - Silver Bark Wall Sconce

468017 - Dimond Home - Colossal Silver Leaf

47010/1 - ELK Lighting - Marina 1 Light Outdoor Sconce In Hazelnut Bronze

47010/1-LED - ELK Lighting - Marina 1 Light Outdoor LED Sconce In Hazelnut Bronze

47011/1 - ELK Lighting - Marina 1 Light Outdoor Pendent In Hazelnut Bronze

47011/1-LED - ELK Lighting - Marina 1 Light Outdoor LED Pendent In Hazelnut Bronze

47020/1 - ELK Lighting - Marina 1 Light Outdoor Sconce In Matte Silver

47020/1-LED - ELK Lighting - Marina 1 Light Outdoor LED Sconce In Matte Silver

47021/1 - ELK Lighting - Marina 1 Light Outdoor Pendant In Matte Silver

47021/1-LED - ELK Lighting - Marina 1 Light Outdoor LED Pendant In Matte Silver

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