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

620317 - Pomeroy - Burnham Pillar Plate Large

620386 - Pomeroy - Balfour Pillar Plate

620393 - Pomeroy - Prado Pillar Holder - Extra Large

620546 - Pomeroy - Balfour Pillar Plate - Large

620638 - Pomeroy - Paisley Pillar Holder Mini

620645 - Pomeroy - Deveraux Hurricane

620652 - Pomeroy - Deveraux Vase

620676 - Pomeroy - Paisley Set of 3 Short Pillar Holders

620690 - Pomeroy - Dorado Set of 2 Pillar Holders

621000 - Pomeroy - Arch Set of 3 Lighting

621017 - Pomeroy - Canal Street Pillar Holder

621024 - Pomeroy - Canal Street Hurricane

621031 - Pomeroy - Santana Votive

621048 - Pomeroy - Teton Pillar Holder

621055 - Pomeroy - Tejas Pillar Holder

621215 - Pomeroy - Illuminati Hurricane

621222/S4 - Pomeroy - Horse Shoe Set of 4 Votives

621239/S2 - Pomeroy - Horse Shoe Set of 2 Hurricanes

621246/S4 - Pomeroy - Lasso Set of 4 Votives

621253/S2 - Pomeroy - Lasso Set of 2 Pillar Holders

621260/S3 - Pomeroy - Cimarron Set of 3 Lighting

621307/S3 - Pomeroy - Haus Set of 3 Lanterns

621314/S2 - Pomeroy - Tejas Set of 2 Hanging Lighting

621321/S2 - Pomeroy - Pueblo Set of 2 Pillar Holders

621338/S2 - Pomeroy - Rodeo Set of 2 Lighting

621345 - Pomeroy - Mirebella Mantle Hurricane - Small

621352 - Pomeroy - Mirebella Mantle Hurricane - Large

621369 - Pomeroy - Rodeo Votive Centerpiece

621376 - Pomeroy - Rodeo Round Centerpiece

621383/S2 - Pomeroy - Tuscon Set of 2 Small Luminarias

621390 - Pomeroy - Tuscon Large Lantern

621413/S3 - Pomeroy - Tonal Set of 3 Pillar Holders

621420 - Pomeroy - Modern Pillar Holder - Small

621437 - Pomeroy - Modern Pillar Holder - Large

621444 - Pomeroy - Hacienda Mantle Lighting

621451 - Pomeroy - Bangle Buffet Hurricane

621604/S2 - Pomeroy - Emerson Set of 2 Pillar Holders

621611/S2 - Pomeroy - Emerson Set of 2 Hurricanes

622001 - GuildMaster - Lake Front Display Shelf

622113 - Pomeroy - Paisley Easel 13-Inch

622120 - Pomeroy - Paisley Easel 21-Inch

623003 - GuildMaster - Basket Shelves

623501 - GuildMaster - Round Top Display Cabinet

623503 - GuildMaster - Barley Twist Shelf

624508 - GuildMaster - Tall Spindle Shelf

625001 - Dimond Home - Sea Glass Knight Pillar Candle Holder - Small

625002 - Dimond Home - Sea Glass Knight Pillar Candle Holder - Medium

625003 - Dimond Home - Sea Glass Knight Pillar Candle Holder - Large

625004 - Dimond Home - Peridot Glass Knight Pillar Candle Holder - Small

625005 - Dimond Home - Peridot Glass Knight Pillar Candle Holder - Medium

625006 - Dimond Home - Peridot Glass Knight Pillar Candle Holder - Large

625007 - Dimond Home - Tall Clear Glass Knight Pillar Candle Holder - Small

625008 - Dimond Home - Tall Clear Glass Knight Pillar Candle Holder - Large

625010 - Dimond Home - Tall Plum Glass Knight Pillar Candle Holder - Large

625015 - Dimond Home - Clear Glass Knight Pillar Candle Holder - Small

625016 - Dimond Home - Clear Glass Knight Pillar Candle Holder - Medium

625017 - Dimond Home - Clear Glass Knight Pillar Candle Holder - Large

625024 - Dimond Home - Ice Bucket With Horn Handle - Small

625025 - Dimond Home - Ice Bucket With Horn Handle - Large

625026 - Dimond Home - Small Silver Sea Star

625027 - Dimond Home - Large Silver Sea Star

625028 - Dimond Home - Small Silver Sea Urchin

625029 - Dimond Home - Large Silver Sea Urchin

627032 - Dimond Home - Lava Saucer - Small

627033 - Dimond Home - Lava Saucer - Medium

627034 - Dimond Home - Lava Saucer - Large

628115 - Pomeroy - Cavalos Easel 10-Inch

628450 - Pomeroy - Hamptons 21-Inch Easel

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