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 >= '605035g' and catalogpartcode <= '609381' order by ref_product.catalogpartcode,ref_product.id ;

605035G - GuildMaster - Hall Trees - Metal And Wood Hall Tree

6050379 - Sterling - Gothic In Antique Silver Leaf

6050387 - Sterling - Lilliput In Schribner Black

6050395 - Sterling - Cocktail In Scuyler Silver

6050409 - Sterling - Dahila In Antique Silver Leaf

6050468 - Sterling - Lotus In Bright Silver Leaf

6050514 - Sterling - Mirage In Gloss Black

6050522 - Sterling - Lilliput In Schribner Red

6050676 - Sterling - Trump Home Easton

6050678 - Sterling - Trump Home Alta

6050679 - Sterling - Set Of 2 Horizonte Mirror

6050680 - Sterling - Set Of 2 Ciaro Mirror

6050681 - Sterling - Set Of 2 Kennedy Mirror

605208 - Pomeroy - Sleigh 6.5-Inch Easel

605215 - Pomeroy - Sleigh 9-Inch Easel

605222 - Pomeroy - Sleigh 12-Inch Easel

605376 - Pomeroy - Carrousel Hotel Easel

605406 - Pomeroy - Leif Large Easel

605413 - Pomeroy - Leif Hotel Easel

6070671 - Sterling - Film Goddess Chair

607073 - Pomeroy - Tejas Cookbook Holder

6070744 - Sterling - Da Vinci Bench

6070809 - Sterling - Pullman Chair

6070922 - Sterling - Alexis Side Chair

6070930 - Sterling - Alexis Barstool

6070973 - Sterling - Cosmo Bench

6071031 - Sterling - Lassiter Chair

6071058 - Sterling - Wallace Chair

6071066 - Sterling - Tiga Chair

6071082 - Sterling - New Gregory Chair

6071090 - Sterling - New Hudson Chair

6071171 - Sterling - Holguin Chair

6071198 - Sterling - Penelope Accent Bench

6071201 - Sterling - Vaughn Corner Chair Settee

6071244 - Sterling - Blakemore Side Chair

6071252 - Sterling - Blakemore Arm Chair

6071279 - Sterling - Edmond Chair

6071398 - Sterling - Marianne Arm Chair

6071399 - Sterling - Marianne Wing Chair

6071401 - Sterling - Mcgill Ottoman

607240 - Pomeroy - Mission Server

607257 - Pomeroy - Mission Buffet Server

607264 - Pomeroy - Mission Triple Server

607295 - Pomeroy - Winston Chalkboard

607486 - Pomeroy - Mission Chip And Dip

607592 - Pomeroy - Campagne Dome Large

607608 - Pomeroy - Burnham Triple Server

607615 - Pomeroy - Burnham Serving Bowl - Large

607622 - Pomeroy - Burnham Bowl Small

607639 - Pomeroy - Telluride Server 15.375-Inch

607646 - Pomeroy - Telluride Server 19.375-Inch

607653 - Pomeroy - Telluride Server Large

607660 - Pomeroy - Telluride Set of 3 Botanas

607677 - Pomeroy - Tejas Set of 2 Serving Bowls

607691 - Pomeroy - Campagne Dome Small

608315 - Pomeroy - Soho Individual Appetizer Bowl

608322 - Pomeroy - Soho Set of 3 Appetizer Bowls

608414 - Pomeroy - Reef Salad Set

608421 - Pomeroy - Reef Serving Tray

608438 - Pomeroy - Reef Tidbit Tray

608445 - Pomeroy - Reef Tiered Triple Server

608452 - Pomeroy - Reef Chip And Dip

608490 - Pomeroy - Campagne 4 Server

608506 - Pomeroy - Campagne Tidbit Tray

608513 - Pomeroy - Stanton Triple Server

608520 - Pomeroy - Stanton Chip And Dip

609183 - Pomeroy - Telluride Serving Board Long

609190 - Pomeroy - Telluride Serving Board Large

609251 - Pomeroy - Strap Napkin Ring

609268 - Pomeroy - Tejas Set of 3 Jars

609275 - Pomeroy - Calico Set of 3 Lanterns

609305 - Pomeroy - Sierra Table

609312 - Pomeroy - Mariano Set of 2 Bowls

6093191 - Sterling - Leonardo Bench

609329 - Pomeroy - Mariano Double Utility

609343 - Pomeroy - Burnham Set of 4 Relish Spoons

609350 - Pomeroy - Burnham Set of 2 Salad Fork And Spoon

609367 - Pomeroy - Burnham Set of 4 Spreaders

609374 - Pomeroy - Solis Cake Stand

609381 - Pomeroy - Solis Chip And Dip

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