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 >= '502439' and catalogpartcode <= '51-10024' order by ref_product.catalogpartcode,ref_product.id ;

502439 - Pomeroy - Aria Bowl

502460 - Pomeroy - Tanqueray Vase Large

502521 - Pomeroy - Versailles Runner

502576 - Pomeroy - Cassieo Bottle Vase 10.875-Inch

502583 - Pomeroy - Cassieo Bottle Vase 15.75-Inch

502606 - Pomeroy - Brandy Pillar Holder - Small

502613 - Pomeroy - Brandy Pillar Holder - Large

502620 - Pomeroy - Brandy Mantle Lighting

503 - Lamp Works - Aspen Bark Floor Lamp

503-LED - Lamp Works - Aspen Bark LED Floor Lamp

503610 - Pomeroy - Corona Hurricane

504068 - Pomeroy - Versailles Luna Bowl

504129 - Pomeroy - Liso Bottle Vase Small

504136 - Pomeroy - Liso Bottle Vase Large

505 - Lamp Works - Hand Applied Natural Shells Table Lamp

505-LED - Lamp Works - Hand Applied Natural Shells LED Table Lamp

5051/1 - ELK Lighting - Novelty 1 Light Prop Plane Semi Flush In Satin Nickel 5051/1

5052/2 - ELK Lighting - Novelty 2 Light Locomotive Train Semi Flush In Satin Nickel 5052/2

5056/3 - ELK Lighting - Novelty 3 Light Helicopter Pendant In Satin Nickel 5056/3

506079 - Pomeroy - Cassia Pedestal Bowl - Small

506123 - Pomeroy - Lafayette Chalise

506147 - Pomeroy - Lamaison Vase

507021 - Pomeroy - Westgate 5.9-Inch Pillar Holder

507038 - Pomeroy - Catherine Pillar Holder

507045 - Pomeroy - Guardian Pillar Holder

507076 - Pomeroy - Westgate 16.8-Inch Pillar Holder

5082/2 - ELK Lighting - Novelty 1 Light Race Car Pendant In Satin Nickel 5082/2

5084/1 - ELK Lighting - Novelty 1 Light Bi Plane Pendant In Walnut And Satin Glass 5084/1

5088/3 - ELK Lighting - Novelty 3 Light Night Sky Flushmount In Satin White Glass 5088/3

5088/3-LA - ELK Lighting - Novelty 3 Light Night Sky Flushmount In Satin White Glass With Recessed Lighting Kit 5088/3-LA

5089/3 - ELK Lighting - Novelty 3 Light Spaceman Flushmount In Satin Nickel And Matte Black 5089/3

5093/3 - ELK Lighting - Novelty 3 Light Wild Ride Pendant In Satin Nickel And Polished Chrome 5093/3

51-001 - Sterling - Decorative Accessory - Cubic Abstract Sculpture

51-002/S2 - Sterling - Accent Table - Set of 2 Angular Side Tables

51-0021 - Sterling - Set of 2 Verde Stacking Tables

51-004 - Sterling - Metal Frame Rivet Porthole Mirror

51-005/S3 - Sterling - Decorative Accessory - Set of 3 Open Structure Metal Orbs

51-0061 - Sterling - Leaopard - Leopard Drum Table

51-008 - Sterling - Rectangular Quatrefoil Bar Cart

51-0088 - Sterling - Set of 2 Austin Stacking Side Tables

51-009/S2 - Sterling - Accent Table - Set of 2 Modern Moorish Scroll Side Tables

51-0091 - Sterling - Set of 3 Beachcomber Candleholders

51-0095 - Sterling - Demille Side Table

51-0096 - Sterling - Beachcomber Bowl

51-010 - Sterling - Accent Table - Hexagon Frame Side Table

51-011/S2 - Sterling - Set of 2 Raised Frame Wall Mirrors

51-012/S2 - Sterling - Set of 2 Quatrefoil Wall Mirrors

51-013 - Sterling - Accent Table - Tripod Clock Table

51-0138 - Sterling - Set of 2 Marble Stacking Side Tables

51-014/S3 - Sterling - Set of 3 Iconic Cities Triptych

51-0148 - Sterling - Set Of 2 Lasko Mirror Trays

51-015 - Sterling - Circular Quatrefoil Bar Cart

51-016 - Sterling - Black & Gold Tray Style Console

51-017/S2 - Sterling - Decorative Accessory - Angular Study D cor

51-018 - Sterling - Candle Holder - Angular Study Pillar Light Pendant

51-019 - Sterling - Angular Study Wall D cor

51-020 - Sterling - Candle Holder - Angular Study Hexagon Pillar Light Pendant

51-0206 - Sterling - Utensil Holder

51-021 - Sterling - Accent Table - World Map Bar Cart

51-022/S2 - Sterling - Accent Table - Set of 2 Mesh Work Drum Tables

51-023 - Sterling - Accent Table - Wire Mesh Forms Bench

51-024/S2 - Sterling - Set of 2 Mirrored Hexagonal Trays

51-025/S2 - Sterling - Set of 2 Ribbed Hexagonal Mirrored Trays

51-026 - Sterling - Angular Study Hexagonal Wine Rack

51-028 - Sterling - Candle Holder - Angular Study Candelabra Pendant

51-029 - Sterling - Angular Wirework Wall Clock

51-030/S2 - Sterling - Candle Holder - Set of 2 Pillar Light Pendants

51-031 - Sterling - Corrugated Metal Wall Art

51-032 - Sterling - Accent Table - World Map Table

51-033 - Sterling - Arrow Marquee Sign

51-034 - Sterling - Star Marquee Sign

51-0673 - Sterling - Floral Scroll Console

51-10001 - Sterling - Compass Caliper - Compass And Caliper Set

51-10002 - Sterling - Compass Bookends

51-10003 - Sterling - Restoration - Wooden A Line Shelves With Metal Frame

51-10005 - Sterling - Bookend - Antique Reproduction Key Book End

51-10006 - Sterling - Chalk Outline Map Of USA On Black Canvas

51-10016 - Sterling - Metal Cart Planter With Handle

51-10018 - Sterling - Jewel Edged Mirror

51-10024 - Sterling - Oil Pump Accessory

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