Sort by:  Popular Newest Name Price Price Filter by:  All On Sale
Kosta Boda Snowball Votive
Kosta Boda Snowball VotiveSale
Item # 7067350
Now Only $20.00
Orrefors Crystal, Discus Crystal Votive, Pair
Orrefors Crystal, Discus Crystal Votive, PairSale
Item # 6483162PR
Pair Only $48.00
Orrefors Crystal, Discus Crystal Votive, Single
Orrefors Crystal, Discus Crystal Votive, SingleSale
Item # 6483162
Special! Now Only $24.00
Waterford Lismore Crystal Votive
Waterford Lismore Crystal VotiveNew
Item # 107610
$65.00
Waterford Crystal Daisy Floral Votive, Single
Waterford Crystal Daisy Floral Votive, SingleSale
Item # 1052628
Now Only $29.00
Marquis by Waterford, Treviso 10" Candlestick Pair
Marquis by Waterford, Treviso 10" Candlestick PairSale
Item # 136302
Pair Now Only $96.99
Marquis by Waterford, Treviso 6" Candlestick, Pair
Marquis by Waterford, Treviso 6" Candlestick, PairSale
Item # 136477
Pair Now Only $75.99
Orrefors Crystal, Heart 5" Bowl and Votive
Orrefors Crystal, Heart 5" Bowl and VotiveSale
Item # 6719810
Now Only $24.00
Waterford Lismore 4" Candlestick, Pair
Waterford Lismore 4" Candlestick, PairNew
Item # 107632
Pair $180.00
Kosta Boda Snowball Votive Set of Three Sizes
Kosta Boda Snowball Votive Set of Three SizesSale
Item # 7067354
Set Now Only $50.00
Kosta Boda Snowball Crystal Votive, Pair
Kosta Boda Snowball Crystal Votive, PairSale
Item # 7067360PR
Pair Now Only $30.00
Orrefors Crystal Raspberry Votive, Small
Orrefors Crystal Raspberry Votive, SmallSale
Item # 6475761
Now Only $15.00
Waterford Crystal Holiday Heritage Votives, Pair
Waterford Crystal Holiday Heritage Votives, PairSale
Item # 1052652
Clearance $29.00
Nambe Metal Aquila 10" Candlesticks, Pair
Nambe Metal Aquila 10" Candlesticks, PairNew
Item # MT0002N
Pair $150.00
Orrefors Ice Cube Crystal Votive, Single
Orrefors Ice Cube Crystal Votive, SingleSale
Item # 6521864
Now Only $24.00
Ralph Lauren 888 Flagship Candle, Single
Ralph Lauren 888 Flagship Candle, SingleNew
Item # 684566225001
$75.00
Michael Aram Pine Cone Scented Candle
Michael Aram Pine Cone Scented CandleNew
Item # 160708MA
$70.00
Michael Aram Lemonwood Scented Candle
Michael Aram Lemonwood Scented CandleNew
Item # 160694MA
$70.00
Michael Aram Garland Scented Candle
Michael Aram Garland Scented CandleNew
Item # 160710MA
$70.00
Kosta Boda Brick Votive, Blue
Kosta Boda Brick Votive, BlueNew
Item # 7061032
$50.00
Orrefors Crystal Small Puck Votive
Orrefors Crystal Small Puck VotiveNew
Item # 6509362
$20.00
Kosta Boda Connect Crystal Candlestick, Pair
Kosta Boda Connect Crystal Candlestick, PairNew
Item # 7060625
Pair $155.00
Baccarat Mille Nuits Candleholders, Pair
Baccarat Mille Nuits Candleholders, PairNew
Item # 2600553B
Pair $540.00
Orrefors Carat Votive
Orrefors Carat VotiveNew
Item # 6590163
$50.00
Lalique Oceans Crystal Scented Candle
Lalique Oceans Crystal Scented CandleSale
Item # B14100L
Now Only $1,100.00
Michael Aram Palm Candleholders, Mixed Pair
Michael Aram Palm Candleholders, Mixed PairNew
Item # 174911MA
Pair $1,075.00
Michael Aram White Orchid Candleholder, Pair
Michael Aram White Orchid Candleholder, PairNew
Item # 111807MA
Pair $250.00
Michael Aram Black Orchid Candleholder, Pair
Michael Aram Black Orchid Candleholder, PairNew
Item # 110724MA
Pair $250.00
Baccarat Crystal, Red Eye Crystal Votive, Pair
Baccarat Crystal, Red Eye Crystal Votive, PairNew
Item # 2810639B
Pair $510.00
Rogaska Crystal, Adria Crystal Votive
Rogaska Crystal, Adria Crystal VotiveNew
Item # 40004529RG
$55.00
Ralph Lauren Leigh Crystal Votive
Ralph Lauren Leigh Crystal VotiveNew
Item # 682661269001
$125.00
Ralph Lauren Durban 10 1/2" Candlestick, Single
Ralph Lauren Durban 10 1/2" Candlestick, SingleNew
Item # 682601692001
Single $250.00
Baccarat Crystal, Eye Votive Gold, Boxed Pair
Baccarat Crystal, Eye Votive Gold, Boxed PairNew
Item # 2811841B
Pair $570.00
Michael Aram Magnolia Scented Candle
Michael Aram Magnolia Scented CandleNew
Item # 160695MA
$70.00
Michael Aram Dogwood Luxe Candle
Michael Aram Dogwood Luxe CandleNew
Item # 160735MA
$135.00
Michael Aram Dogwood Scented Candle
Michael Aram Dogwood Scented CandleNew
Item # 160732MA
$70.00
Nambe Geo Sabbath Candlesticks
Nambe Geo Sabbath CandlesticksNew
Item # MT0963N
$120.00
Orrefors Carat Small Votive, Single
Orrefors Carat Small Votive, SingleNew
Item # 6590161
$24.00
Galway Crystal Dune Votive
Galway Crystal Dune VotiveSale
Item # 45075
Now Only $24.95
Galway Crystal Ashford 4" Candlestick, Pair
Galway Crystal Ashford 4" Candlestick, PairSale
Item # 57405
Pair Now Only $29.95
Orrefors Carat 7 1/4" Candlestick, Pair
Orrefors Carat 7 1/4" Candlestick, PairNew
Item # 6719396
Pair $150.00
Orrefors Carat 11 5/8" Candlestick, Pair
Orrefors Carat 11 5/8" Candlestick, PairNew
Item # 6719397
Pair $250.00
Orrefors Crystal Puck Tealight Votive Large
Orrefors Crystal Puck Tealight Votive LargeSale
Item # 6509363
Now Only $20.00
Waterford Crystal Lismore Candlestick 6" Pair
Waterford Crystal Lismore Candlestick 6" PairNew
Item # 40033483
Pair $200.00
Michael Aram Twist 8.5" Candleholders Pair
Michael Aram Twist 8.5" Candleholders PairNew
Item # 144576MA
Pair $250.00
Baccarat Crystal White Eye Votive, Pair
Baccarat Crystal White Eye Votive, PairNew
Item # 2812806B
Pair $510.00
Baccarat Crystal Silver Eye Votive, Pair
Baccarat Crystal Silver Eye Votive, PairNew
Item # 2812812B
Pair $510.00
Waterford Crystal Lismore 4" Votive Pair
Waterford Crystal Lismore 4" Votive PairNew
Item # 40035011
Pair $85.00
Orrefors Carat Brass Small Candlesticks, Pair
Orrefors Carat Brass Small Candlesticks, PairNew
Item # 6719895
Pair $150.00
Orrefors Carat Brass Large Candlesticks, Pair
Orrefors Carat Brass Large Candlesticks, PairNew
Item # 6719896
Pair $250.00
Aerin Uzes Tuberose 6.7oz Candle
Aerin Uzes Tuberose 6.7oz CandleNew
Item # 18121000AE
$60.00
Aerin Caffarella Vine 6.7oz Candle
Aerin Caffarella Vine 6.7oz CandleNew
Item # 18121002AE
$60.00
Aerin Buckhorn Amber 6.7oz Candle
Aerin Buckhorn Amber 6.7oz CandleNew
Item # 18121003AE
$60.00
Aerin Salzburg Pine 6.7oz Candle
Aerin Salzburg Pine 6.7oz CandleNew
Item # 18121004AE
$60.00
Aerin Tumbatu Sandalwood 6.7oz Candle
Aerin Tumbatu Sandalwood 6.7oz CandleNew
Item # 18121005AE
$60.00
Aerin Sintra Gardenia 6.7oz Candle
Aerin Sintra Gardenia 6.7oz CandleNew
Item # 18121006AE
$60.00
Aerin Monserrate Rose 6.7oz Candle
Aerin Monserrate Rose 6.7oz CandleNew
Item # 18121007AE
$60.00
Aerin Deluxe Oversize Candle Uzes Tuberose
Aerin Deluxe Oversize Candle Uzes TuberoseNew
Item # 17220058AE
$495.00
Aerin Petal Candle Snuffer
Aerin Petal Candle SnufferNew
Item # 17120065AE
$95.00
Aerin Tulln Small Candleholder Pair
Aerin Tulln Small Candleholder PairNew
Item # 18120031AE
Pair $425.00
Ralph Lauren Bedford Grand Candle
Ralph Lauren Bedford Grand CandleNew
Item # 684713731001
$495.00
Ralph Lauren Holiday Single Wick Candle
Ralph Lauren Holiday Single Wick CandleNew
Item # 684733818001
$60.00
Michael Aram Anemone Candleholders Pair
Michael Aram Anemone Candleholders PairNew
Item # 175032MA
Pair $350.00
Michael Aram Anemone Candle
Michael Aram Anemone CandleNew
Item # 160737MA
$70.00
Michael Aram Thorn Candleholders Pair
Michael Aram Thorn Candleholders PairNew
Item # 130311MA
Pair $350.00
Michael Aram Wisteria Gold Candleholders Pair
Michael Aram Wisteria Gold Candleholders PairNew
Item # 123318MA
Pair $350.00
Ralph Lauren Holiday Grand Candle
Ralph Lauren Holiday Grand CandleNew
Item # 684713735001
$495.00
Aerin Evelina Candleholder Centerpiece Set of 4
Aerin Evelina Candleholder Centerpiece Set of 4New
Item # 19222037AE
Set $450.00
Aerin Evelina Candleholder Centerpiece Set of 8
Aerin Evelina Candleholder Centerpiece Set of 8New
Item # 19222038AE
Set $900.00
Aerin Evelina Candleholders Pair
Aerin Evelina Candleholders PairNew
Item # 19222039AE
Pair $175.00
Aerin Nendaz Holiday Scented Candle
Aerin Nendaz Holiday Scented CandleNew
Item # 17221034AE
$80.00
Aerin Gold Fluted Candle
Aerin Gold Fluted CandleNew
Item # 260346280010AE
$175.00

select o.ss_date, p.ss_created, p.ss_name, o.ss_sku, p.ss_sku, p.ss_price, p.ss_searchkeywords, p.ss_productfield1, p.ss_productfield2, p.ss_productfield3, p.ss_productfield4, p.ss_productfield5, p.ss_productfield6, p.ss_productfield7, p.ss_productfield8, p.ss_productfield10, p.ss_productfield11, p.ss_productfield12, p.ss_productfield13, p.ss_productfield14, p.ss_productfield15, p.ss_productfield16, p.ss_productfield17, p.ss_productfield18, p.ss_productfield19, ss_productdescription, ss_moreinfotext, ss_QuantityOnHand, count(o.ss_sku) as c from ss_Products p LEFT JOIN ss_MostPopular o ON o.ss_sku = p.ss_sku where p.ss_productfield4 != '' and p.ss_productfield6 != '' and p.ss_productfield12 not REGEXP '(DSC|Web|INFO|AMZ)' and p.ss_productfield3 = 'unchecked' and p.ss_name REGEXP 'candle|votive' group by p.ss_sku order by c desc


^ Back to Top