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 >= '166-004' and catalogpartcode <= '17042/1alm-led' order by ref_product.catalogpartcode,ref_product.id ;

166-004 - Dimond Home - Wide Urn Planter In Gloss White

166-005 - Dimond Home - Oversized Planter - Oversized Oval Planter in Gold Leaf

166-006 - Dimond Home - Oversized Planter - Oversized Oval Planter in Silver Leaf

166-007 - Dimond Home - White Ribbed Planter

166-008 - Dimond Home - Black Ribbed Planter

166-009 - Dimond Home - Modern Forms Planter In White

166-010 - Dimond Home - Modern Forms Planter In Black

166-011 - Dimond Home - Swirl Planter - Swirl Table Planter - White

166-012 - Dimond Home - Swirl Planter - Swirl Table Planter - Gold Leaf

166-013 - Dimond Home - Swirl Planter - Swirl Table Planter - Silver Leaf

166-014 - Dimond Home - Poppy Planter - White

166-015 - Dimond Home - Poppy Planter - Gold

166-016 - Dimond Home - Poppy Planter - Silver

167-001 - Dimond Home - Ceramic Jars - Large White Ceramic Jar With Raised Polka Dots

167-003/S2 - Dimond Home - Gold Giraffe Sculpture

167-004/S2 - Dimond Home - Accordion Crackled Blue Jars

167-005 - Dimond Home - Accordion Crackled Blue Pot

167-006 - Dimond Home - Textured Ceramic Jewelry Box

167-010 - Dimond Home - Ceramic Basket Weave Trophy

167-011 - Dimond Home - Perforated Multi-Hexagonal Stand

167-012 - Dimond Home - Tribal Styled Geometric Gold Plate

167521 - GuildMaster - Wooden Cathedral Artifact

168-001 - Dimond Home - Natural Fiber Triptych

168-004 - Dimond Home - Natural Fibers-On-Foil Wall Decor

168-005 - Dimond Home - Natural Mineral Table Top Display

168-006 - Dimond Home - Sea Shell Table Top Display

168-007 - Dimond Home - Natural Mineral Wall D cor - Lavender

168-009 - Dimond Home - Natural Mineral Wall Decor

168-010 - Dimond Home - Sea Fan Wall Decor

168-011 - Dimond Home - Sea Urchin Wall Decor

168-012 - Dimond Home - Feather Swirl Wall Decor

169-001 - Dimond Lighting - Antique Bottle Table Lamp In Antique Mercury Glass

169-002 - Sterling - 18 Aged Mercury Glass Bottle

169-003 - Sterling - 12 Aged Mercury Glass Bottle

169-004 - Sterling - 18 Aqua Antique Mercury Glass Bottle

169-005 - Sterling - 12 Aqua Antique Mercury Glass Bottle

169-006 - Sterling - 13 Aqua Antique Mercury Glass Bottle

169-007/S4 - Sterling - Set of Four 8 Mouth Blown Mercury Glass Bottle

169-008/S4 - Sterling - Set of Four 10 Mouth Blown Mercury Glass Bottle

169-009 - Sterling - Oversized Antique Mercury Glass Bottle

169-012 - Sterling - Coffee Table - Natural Mango Wood Slatted Accent Table

169-013 - Sterling - Vase - Weathered Glass Bottle

169-014 - Dimond Lighting - Antique Bottle Table Lamp In Antique Mercury Glass

169-015 - Dimond Lighting - Weathered Glass Bottle Lamp With White Faux Silk Shade

169006S - GuildMaster - Set of 4 Carved Wall Plaques

169050S - GuildMaster - Tuscan Sunflower

169554 - GuildMaster - Reflections

170-001/S3 - Sterling - Set of 3 Antique Book Trunks

170-002/S3 - Sterling - Linen Covered Travelers Trunks

170-003/S3 - Sterling - Set of 3 Travelers Storage Trunks

170-004 - Sterling - Trunk - Tall Travelers Chest

170-005/S2 - Sterling - Trunk - Set of 2 Travelers Cabinets

170-006 - Sterling - Travelers Mirror

17027/1 - Dimond Lighting - Elysburg 1 Light Floor Lamp In Aged Bronze

17027/1-LED - Dimond Lighting - Elysburg 1 Light LED Floor Lamp In Aged Bronze

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