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 >= '600mpmdlwws-leds830' and catalogpartcode <= '6042732' order by ref_product.catalogpartcode,ref_product.id ;

600MPMDLWWS-LEDS830 - Tech Lighting - Mp-Mini Delaware White, Sn-Led

600MPMDLWWZ-LEDS830 - Tech Lighting - Mp-Mini Delaware White, Bz-Led

600MPSVN03Z - Tech Lighting - Sullivan Head

600MPVBNCS - Tech Lighting - Van Buren Pendant - Clear

601033 - Pomeroy - Prairie Easel 12.5-Inch

601040 - Pomeroy - Prairie Easel 18.5-Inch

601095 - Pomeroy - Prairie Single Trivet

601101 - Pomeroy - Prairie Double Trivet

601477 - Pomeroy - Santo Fruit Basket

601484 - Pomeroy - Santo Double Plate Stand

602503 - GuildMaster - Artifacts Collage Cabinet

602509 - GuildMaster - Legacy Hall Tree

602509RS - GuildMaster - Legacy Hall Tree

602520 - GuildMaster - Waterfront Credenza

602523 - GuildMaster - Credenza With Wine Storage

602530 - GuildMaster - Heritage Hall Tree

603136 - Pomeroy - Orvieto 13.5-Inch Easel

603143 - Pomeroy - Orvieto Easel 18-Inch

603204 - Pomeroy - Court Easel 12-Inch

603211 - Pomeroy - Court Easel 16.5-Inch

603228 - Pomeroy - Kashmir Easel 6.3-Inch

603235 - Pomeroy - Kashmir Easel 10.25-Inch

603242 - Pomeroy - Kashmir Easel 15.5-Inch

603280 - Pomeroy - Hampton Easel 13In

603297 - Pomeroy - Camerena - Camarena 11-Inch Metal Chair Easel

603303 - Pomeroy - Camerena - Camarena Chair Easel 16In

603310 - Pomeroy - Camerena - Camarena Tripod Easel 6In

603327 - Pomeroy - Camerena - Camarena 8-Inch Metal Tripod Easel

603334 - Pomeroy - Camerena - Camarena Tripod Easel 13In

603341 - Pomeroy - Canopy 5-Inch Metal Easel

603389 - Pomeroy - Orvieto Easel 13.5In

603396 - Pomeroy - Orvieto Easel XL 24-Inch

603402 - Pomeroy - Canopy 13-Inch Easel In Rustic

603502 - GuildMaster - Italian Demilune Chest

603510 - GuildMaster - Library Bookcase

603513 - GuildMaster - Vaucelles Cabinet

603514 - GuildMaster - Pradana Armoire

603517 - GuildMaster - Waterfront Credenza

603709 - Pomeroy - Camerena - Camarena 6-Inch Tripod Easel

603716 - Pomeroy - Camerena - Camarena 8-Inch Tripod Easel In Rustic

603723 - Pomeroy - Canopy 5-Inch Easel In Rustic

603730 - Pomeroy - Canopy 8.8-Inch Easel

603747 - Pomeroy - Canopy 13-Inch Metal Easel

604001 - GuildMaster - European Farmhouse Display Cabinet

604008-B - GuildMaster - Reclaimed Wood - Reclaimed Louvred Cabinet

604009G - GuildMaster - Scrolled Iron Hall Cabinet

6040239 - Sterling - Large Cheval Bookcase

6040747 - Sterling - Architects - Architect foots Table-Base

6040792 - Sterling - Linea Table

6040947 - Sterling - Uptown End Table

6040995 - Sterling - Tamara Tower - Ebony

6041031 - Sterling - Uptown Side Table

6041037 - Sterling - Uptown Plant Stand

6041135 - Sterling - Tamara Sofa Back Console

6041144 - Sterling - Tamara Hall Table-Ebony

6041153 - Sterling - Tamara Side Table

6041162 - Sterling - Cinema Side Table

6041171 - Sterling - Cinema Jewelry Cabinet

6041207 - Sterling - Uptown Cocktail Table

6041216 - Sterling - Silver Leaf Linea Table P1/2

6041256 - Sterling - Cheval Demilune

6041302 - Sterling - Tamara Chest- Ebony

6041361 - Sterling - Orbis Table

6041450 - Sterling - Romana Bowfront Chest

6041787 - Sterling - Mini Flora

6041795 - Sterling - Contemporary - Mini Lini

6041WS/00 - Cornerstone - 1 Light Sconce In Satin Nickel And White Swirl Glass

604225 - Pomeroy - Carrousel Easel 5.4-Inch

6042287 - Sterling - Black Tie Table

6042317 - Sterling - Claremore Cabinet

604232 - Pomeroy - Carrousel Easel 7.9-Inch

6042325 - Sterling - Black Tie Hall Table

6042341 - Sterling - Mirage Cabinet

6042457 - Sterling - Oceana Table

6042473 - Sterling - Mirage Sideboard Ebony

604249 - Pomeroy - Carrousel Easel 10.25-Inch

6042694 - Sterling - Tamara Tower, White

6042708 - Sterling - Tamara Side, White

6042716 - Sterling - Tamara Hall, White

6042732 - Sterling - Merengue Table

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