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 >= '146tdilldc' and catalogpartcode <= '151-003/s2' order by ref_product.catalogpartcode,ref_product.id ;

146TDILLDC - Tech Lighting - Illume - Desert Clay Replacement Shade

146TDILLWH - Tech Lighting - Illume - White Replacement Shade

146TDMADBK - Tech Lighting - Madison - Black - Replacement Component

146TDMADBR - Tech Lighting - Madison - Chocolate Brown - Replacement Component

146TDMADDC - Tech Lighting - Madison - Desert Clay - Replacement Component

146TDMADRD - Tech Lighting - Madison - Red - Replacement Component

146TDMADWH - Tech Lighting - Madison - White - Replacement Component

146TOPOMGY - Tech Lighting - Shade Topo Large Maple Gray

146TOPOMWH - Tech Lighting - Shade Topo Large Maple White

146TOPOWWH - Tech Lighting - Shade Topo Large Walnut White

146TOPSMGY - Tech Lighting - Shade, Heather Gray, Maple

146TOPSWGY - Tech Lighting - Shade, Heather Gray, Walnut

146TOPSWWH - Tech Lighting - Shade, White, Walnut

146TRIMGDC - Tech Lighting - Trimble Grande - Desert Clay - Replacement Component

146TRIMGWH - Tech Lighting - Trimble Grande - White - Replacement Component

146TRIMPBR - Tech Lighting - Trimble - Trimble Brown - Replacement Component

146TRIMPDC - Tech Lighting - Trimble - Trimble Desert Clay - Replacement Component

146TRIMPWH - Tech Lighting - Trimble - Trimble White - Replacement Component

146TRINSML - Tech Lighting - Trinidad - Shade,Trinidad Smoke Linen - Replacement Component

146TRINTWD - Tech Lighting - Trinidad - Shade,Trinidad Tweed - Replacement Component

146TRINTWH - Tech Lighting - Trinidad - Shade,Trinidad Thatched White - Replacement Component

146TRINWHB - Tech Lighting - Trinidad - Shade,Trinidad White Braid - Replacement Component

146TRINWHL - Tech Lighting - Trinidad - Shade,Trinidad White Linen - Replacement Component

146WCDRADC - Tech Lighting - Fabric Drake Shade Linen

146WCMCLRL - Tech Lighting - Shade,Wc Mini-Claremont Clay

146WCMCLRW - Tech Lighting - Shade,Wc Mini-Claremont White

146WCSUTTL - Tech Lighting - Shade,Wc Sutton Linen

146WCSUTTW - Tech Lighting - Shade,Wc Sutton White

146WCWEBTL - Tech Lighting - Webster Wall Clay (For Cage)

146WCWEBTW - Tech Lighting - Webster Wall White (For Cage )

146WCWEBWL - Tech Lighting - Webster Wall Clay

146WCWEBWW - Tech Lighting - Webster Wall White

146WESTFOG - Tech Lighting - Shade Weston Pendant Fog

146WESTSAN - Tech Lighting - Shade Weston Pendant Sand

148-001 - Sterling - Tullycarnet - Thoroughbred Table

148-003 - Sterling - Dandelion - Pom Martini Table(Large)

148-004 - Sterling - Strongman Table

148-009 - Sterling - Ming Horse Statue

148-015 - Sterling - Ensemble Sculpture

148-016 - Sterling - Chorus Line Sculpture

148-018 - Sterling - High Seheeler - Climbers Statue

148-020 - Sterling - Troupe Sculpture

148-022 - Sterling - Tumble Dancers Statues

148-023 - Sterling - Bramble Candlestick

148-024 - Sterling - Ring Dancers - Ring Dancer Statues

148-026 - Sterling - Photo finish Sculpture

148-030 - Sterling - High Flyers Statue

148027 - Dimond Home - Staghorn Coral Sculpture

148028 - Dimond Home - Staghorn Coral Sculpture

1481005 - Dimond Home - Silver Thicket Table

149-013 - Sterling - Paris Scene Oil On Canvas

149-019 - Sterling - Friesian Oil On Canvas

149-029 - Sterling - Oversized Piranha Oil On Canvas

149-031 - Sterling - Pastel Peacock - Oversized Oil On Canvas

149-041 - Sterling - Together I - Oversized Oil On Canvas

149-043 - Sterling - Together II - Oversized Oil On Canvas

14PRR62AGPD - Monte Carlo - 62 Prairie Fan - Aged Pewter

150-003 - Sterling - Draper - Retro Book Rack

150-004 - Sterling - Draper - Retro Sideboard

150-007 - Sterling - Simone - Elegance Basin Cabinet - Big

150-008 - Sterling - Elegance Mirror With Shelves

150-009 - Sterling - Simone - Elegance Rack Tower

150-012 - Sterling - Baroque Side Chair

150-021 - Sterling - Vina - Chest 6 Drawers With Iron Frames

150-026 - Sterling - Hazel - Cabinet 2 Doors With Resin Accent

150017 - Dimond Home - Hand Carved Coffee Table

150024 - Dimond Home - 4-Drawer Flat File Cabinet

150027 - Dimond Home - Hand Carved Coffee Table

1501WS/10 - Cornerstone - Williamsport 1 Light Sconce In Oil Rubbed Bronze 1501WS/10

1501WS/20 - Cornerstone - Williamsport 1 Light Wall Scone In Brushed Nickel 1501WS/20

1502WS/10 - Cornerstone - Williamsport 2 Light Wall Sconce In Oil Rubbed Bronze 1502WS/10

1502WS/20 - Cornerstone - Williamsport 2 Light Wall Sconce In Brushed Nickel 1502WS/20

1503CH/10 - Cornerstone - Williamsport 3 Light Chandelier In Oil Rubbed Bronze 1503CH/10

1505CH/10 - Cornerstone - Williamsport 5 Light Chandelier In Oil Rubbed Bronze 1505CH/10

1509CH/10 - Cornerstone - Williamsport 9 Light Chandelier In Oil Rubbed Bronze 1509CH/10

150WSPULLBL - Tech Lighting - Shade Ws Pull Large Rub. Black

150WSPULLWH - Tech Lighting - Shade Ws Pull Large Rub. White

151-001/S2 - Sterling - Figure In Black And White I And Ii - Fine Art Print Under Glass

151-002/S4 - Sterling - Waterways Of Venice I, II, III, IV - Print Under Glass

151-003/S2 - Sterling - Desert Form V, VI - Print Under Glass

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