Sort by:  Popular Newest Name Price Price Filter by:  All On Sale
Baccarat Crystal, Shooting Star Trophy
Baccarat Crystal, Shooting Star TrophyNew
Item # 2106020B
$1,260.00
Baccarat Crystal, American Eagle
Baccarat Crystal, American EagleNew
Item # 2101470B
$1,500.00
Baccarat Crystal, Imperator Eagle
Baccarat Crystal, Imperator EagleNew
Item # 2605313B
$2,565.00
Cashs Ireland, Crystal Trophy 601
Cashs Ireland, Crystal Trophy 601New
Item # 16001C
$1,200.00
Cashs Ireland, Crystal Trophy 602
Cashs Ireland, Crystal Trophy 602New
Item # 16002C
$1,500.00
Cashs Ireland, Crystal Trophy 600
Cashs Ireland, Crystal Trophy 600New
Item # 16000C
$1,100.00
Lalique Crystal, Golden Eagle Sculpture
Lalique Crystal, Golden Eagle SculptureNew
Item # 10364100
$7,400.00
Cashs Ireland, Crystal Trophy 3
Cashs Ireland, Crystal Trophy 3New
Item # 829255C
$1,000.00
Cashs Ireland, Crystal Trophy 1
Cashs Ireland, Crystal Trophy 1New
Item # 800255C
$900.00
Cashs Ireland, Crystal Trophy 4
Cashs Ireland, Crystal Trophy 4New
Item # 858275C
$850.00
Cashs Ireland, Crystal Trophy 2
Cashs Ireland, Crystal Trophy 2New
Item # 822230C
$950.00
Cashs Ireland, Crystal Trophy 5
Cashs Ireland, Crystal Trophy 5New
Item # 851255C
$1,000.00
Cashs Ireland, Crystal Trophy 6
Cashs Ireland, Crystal Trophy 6New
Item # 679254C
$950.00
Swarovski Crystal Myriad Mahiri Sculpture
Swarovski Crystal Myriad Mahiri SculptureNew
Item # 5239445
$18,000.00
Swarovski Crystal Myriad Pegasus Sculpture
Swarovski Crystal Myriad Pegasus SculptureNew
Item # 5405969
$15,000.00
Swarovski Myriad Reka
Swarovski Myriad RekaNew
Item # 5424398
$18,000.00
Swarovski Myriad Kedari
Swarovski Myriad KedariNew
Item # 5422686
$14,000.00
Swarovski Myriad Kedari Large
Swarovski Myriad Kedari LargeNew
Item # 5484128
$29,500.00
Steuben Atkins Eagle Sculpture
Steuben Atkins Eagle SculptureNew
Item # 8496VAA
$600.00
Steuben Houston Eagle Sculpture
Steuben Houston Eagle SculptureNew
Item # 8130ST
$1,200.00
Steuben Pollard Eagle Sculpture
Steuben Pollard Eagle SculptureNew
Item # 8304VAA
$1,000.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 ' eagle|trophy|stripes|regatta|lighthouse|constellation|marigold|avondale|myriad|house of|antrim|blanaid|aideen' and p.ss_name not like '%crystalline%' and p.ss_name not like '%handbag%' and p.ss_name not like '%cufflink%' and p.ss_name not like '%clown%' and p.ss_name not like '%ladies%' and p.ss_name not like '%wallet%' and p.ss_name not like '%necklace%' and p.ss_name not like '%vodka%' and p.ss_name not like '%carafe%' and p.ss_name not like '%kitty%' and p.ss_name not like '%glasses%' and p.ss_name not like '%caviar%' group by p.ss_sku order by c desc


^ Back to Top