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 >= '643210' and catalogpartcode <= '648410' order by ref_product.catalogpartcode,ref_product.id ;

643210 - GuildMaster - Belle Grove Credenza

643212 - GuildMaster - Parsons Sideboard

643330 - Pomeroy - Prairie Rectangle Tray - Small

643347 - Pomeroy - Prairie Rectangle Tray - Large

643385 - Pomeroy - Telluride Set of 2 Trays

643439 - Pomeroy - Mission Frame 4x6

643446 - Pomeroy - Mission Frame 5x7

643505 - GuildMaster - Artifacts Demilune Sideboard

643516 - GuildMaster - Vintage Hall Chest

643520 - GuildMaster - Fleur De Lis - Fleur-De-Lis Chest

643525 - GuildMaster - Mirror Mosaic Dresser

643530 - GuildMaster - Small Duchess Chest 643530

643538 - GuildMaster - Duchess Chest 643538

643543 - GuildMaster - Legacy Side Chest

643544 - GuildMaster - Heritage Three Drawer Chest

643545 - GuildMaster - Basil Cottage Chest

643546 - GuildMaster - Reclaimed Wood Wall Chest

643551 - GuildMaster - Secretary Chest

643552 - GuildMaster - Artifacts Collage Chest

643559 - GuildMaster - Duchess Chest 643559

643567G - GuildMaster - Wine Racks - Barrel Wine Rack

644034 - GuildMaster - Basil Cottage Chest

644037 - GuildMaster - Large Credenza

644039 - GuildMaster - Legacy Credenza

644078 - Pomeroy - Urban S3 Polished Pillar Holders

644115 - Pomeroy - Urban Hammered 4-Inch Sphere

644306 - Pomeroy - Sage Frame 4x6

644313 - Pomeroy - Sage Frame 5x7

644320 - Pomeroy - Sage Charger 14-Inch

644399 - Pomeroy - Sage 8x10 Frame

644467 - Pomeroy - Taos Set of 2 Buffet Trays

644510 - GuildMaster - Devon Chest 644510

644511 - GuildMaster - Duchess Chest 644511

644542 - Pomeroy - Ashwood Long Tray

644548 - GuildMaster - Chester House Side Chest

644565 - GuildMaster - Legacy Credenza

644569-B - GuildMaster - Reclaimed Wood Chest

644573 - Pomeroy - Burnham Tray

644603 - Pomeroy - Misson Ottoman Tray

644610 - Pomeroy - Mission Charger

644641 - Pomeroy - Taos Set of 2 Ottoman Trays

644658 - Pomeroy - Woodlands Set of 2 Boxes

644665 - Pomeroy - Telluride Set of 3 Boxes

644672 - Pomeroy - Ashwood Set of 2 Trays

644689 - Pomeroy - Burnham Charger

645365 - Pomeroy - Versailles 8x10 Frame

645402 - Pomeroy - Turbid Frame 4x6

645419 - Pomeroy - Turbid Frame 5x7

645556 - Pomeroy - Hollywood 4x6 Frame

645563 - Pomeroy - Hollywood 5x7 Frame

647031 - Pomeroy - Pierce Single Pane 4x6 Frame

647048 - Pomeroy - Pierce Single Pane 5x7 Frame

647079 - Pomeroy - Roxbury Frame 4x6

647086 - Pomeroy - Roxbury 5x7 Frame

647253 - Pomeroy - Brindle Frame 5x7

647260 - Pomeroy - Brindle Frame 4x6

647277 - Pomeroy - Brindle 8x10 Frame

647284 - Pomeroy - Toreador Frame 4x6

647291 - Pomeroy - Toreador Frame 5x7

647307 - Pomeroy - Toreador 8x10 Frame

647420 - Pomeroy - Ondine 4x6 Frame

647437 - Pomeroy - Ondine 5x7 Frame

647499 - Pomeroy - Burnham Frame 4x6

647505 - Pomeroy - Burnham Frame 5x7

647611 - Pomeroy - Bennet 4x6 Frame

647628 - Pomeroy - Daphne Frame 4x6

647659 - Pomeroy - Relin Frame 5x7

648-BC - ELK Lighting - Diamond Ring 1 Light Pendant In Burnished Copper

648-BC-LED - ELK Lighting - Diamond Ring 1 Light LED Pendant In Burnished Copper

648007 - Pomeroy - Tuxedo Frame 4x6

648014 - Pomeroy - Tuxedo Frame 5x7

648021 - Pomeroy - Pier 4x6 Frame

648038 - Pomeroy - Pier 5x7 Frame

648052 - Pomeroy - Pierce Single Pane 8x10 Frame

648137 - Pomeroy - Embossed Frames - Set of 3

648281 - Pomeroy - Westward 4x6 Frame

648298 - Pomeroy - Westward 5x7 Frame

648335 - Pomeroy - Jewell 5x7 Frame

648342 - Pomeroy - Leyton Frame 4x6

648410 - Pomeroy - Telluride Frame 4x6

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