Temple St Clair Logo
Search
Temple St. Clair
Locations
Shopping Bag
Item 18K Mini Horseshoe Ring in diamond pavé
18K Mini Horseshoe Ring in diamond pavé

$1,950
18K Mini Horseshoe Ring in diamond pavé
$1,950
Item 18K Angel Ring in diamond pavé
18K Angel Ring in diamond pavé
$1,950
18K Angel Ring in diamond pa...
$1,950
Item 18K Sorcerer Earrings with mixed sapphire pavé
18K Sorcerer Earrings with mixed sapphire pav&e...
$3,250
18K Sorcerer Earrings with m...
$3,250
Item 18K Small Cluster Earrings with Royal Blue Moonstone and diamond
18K Cluster Earrings with royal blue moonstone ...
$3,500 - $6,500
More sizes available
18K Cluster Earrings with ro...
$3,500 - $6,500
More sizes available
Item 18K Deer Earring in diamond
18K Deer Earring in diamond
$2,500
18K Deer Earring in diamond
$2,500
Item 18K Mini Evil Eye Ring in diamond
18K Mini Evil Eye Ring in diamond
$1,950
18K Mini Evil Eye Ring in di...
$1,950
Item 18K Mini Owl Ring in diamond pavé
18K Mini Owl Ring in diamond pavé
$1,950
18K Mini Owl Ring in diamond...
$1,950
Item 18K Evil Eye Pendant in emerald and blue sapphire
18K Evil Eye Pendant in emerald and blue sapphi...
$2,500
18K Evil Eye Pendant in emer...
$2,500
Item 18K Fan Earrings with tanzanite and diamond
18K Fan Earrings with tanzanite and diamond
$3,450
18K Fan Earrings with tanzan...
$3,450
Item 18K Mini Scarab Ring in diamond pavé
18K Mini Scarab Ring in diamond pavé
$1,950
18K Mini Scarab Ring in diam...
$1,950
Item 18K Evil Eye Pendant in diamond
18K Evil Eye Pendant in diamond
$3,250
18K Evil Eye Pendant in diam...
$3,250
Item 18K Classic Trio Earring in diamond
18K Classic Trio Earring in diamond
$2,500 - $15,000
More sizes available
18K Classic Trio Earring in ...
$2,500 - $15,000
More sizes available
Item 18K Evil Eye Earrings in emerald, blue sapphire and diamond
18K Evil Eye Earrings in emerald, blue sapphire...
$2,700
18K Evil Eye Earrings in eme...
$2,700
Item 18K Mini Clover  Ring in diamond pavé
18K Mini Clover Ring in diamond pavé

$1,950
18K Mini Clover Ring in diamond pavé
$1,950
Item 18K Lotus Post Earring in diamond
18K Lotus Post Earring in diamond
$2,200
18K Lotus Post Earring in di...
$2,200
Item 18K Double Serpent Ring with blue sapphire and diamond pavé
18K Double Serpent Ring with blue sapphire and ...
$5,400
18K Double Serpent Ring with...
$5,400
Item 18K Angel Crystal Locket with diamond
18K Angel Crystal Locket with diamond
$9,700
18K Angel Crystal Locket wit...
$9,700
Item 18K Scarab Pendant in blue sapphire, emerald and diamond
18K Scarab Pendant in blue sapphire, emerald an...
$6,500
18K Scarab Pendant in blue s...
$6,500
Item 18K Classic Trio Earrings with blue sapphire and diamond
18K Classic Trio Earrings

$4,250
More colors available
18K Classic Trio Earrings
$4,250
More colors available
Item 18K Classic Trio Earrings with Royal Blue Moonstone and diamond
18K Classic Trio Earrings
$2,300
18K Classic Trio Earrings
$2,300
Item 18K Double Serpent Ring with diamond eyes
18K Double Serpent Ring with diamond eyes
$3,500
18K Double Serpent Ring with...
$3,500
Item 18KW Classic Trio Earring in diamond
18K White Gold Classic Trio Earring in diamond
$2,500 - $5,900
More sizes available
18K White Gold Classic Trio ...
$2,500 - $5,900
More sizes available
Item 18K Vine Amulet with rock crystal and diamond
18K Vine Amulet with oval rock crystal and diam...
$1,750 - $6,950
More sizes available
18K Vine Amulet with oval ro...
$1,750 - $6,950
More sizes available
Item 18K Foglia Ring with diamond pavé
18K Foglia Ring with diamond pavé
$5,000
18K Foglia Ring with diamond...
$5,000
Item 18K Classic Amulet with rock crystal and diamond
18K Classic Amulet with oval rock crystal and d...
$1,300 - $6,500
More sizes available
18K Classic Amulet with oval...
$1,300 - $6,500
More sizes available
Item 18K Sorcerer Ring with Star Sapphire and diamond
18K Sorcerer Ring with Star Sapphire and diamon...
$4,500
18K Sorcerer Ring with Star ...
$4,500
Item 18K Piccolo Tolomeo Earrings with mixed sapphire and blue sapphire center
18K Piccolo Tolomeo Earrings with mixed sapphir...
$3,750
18K Piccolo Tolomeo Earrings...
$3,750
Item 18K Sorcerer Ring with Star Sapphire and diamond
18K Sorcerer Ring with Star Sapphire and diamon...
$4,500
18K Sorcerer Ring with Star ...
$4,500
Item 18K Classic Amulet Earrings with rock crystal and diamond granulation
18K Classic Amulet Earrings with rock crystal a...
$2,900
18K Classic Amulet Earrings ...
$2,900
Item 18K Dragonfly Locket with diamond
18K Dragonfly Locket with diamond
$6,950
18K Dragonfly Locket with di...
$6,950
Item 18K Horseshoe Pendant in diamond
18K Horseshoe Pendant in diamond
$1,750
18K Horseshoe Pendant in dia...
$1,750
Item 18K Vine Amulet Earrings with rock crystal and diamond
18K Vine Amulet Earrings with rock crystal and diamond

$5,300
18K Vine Amulet Earrings with rock crystal and diamond
$5,300
Item 18K Double Ring Spin Earrings with diamond pavé
18K Double Ring Spin Earrings with diamond pav&...
$5,950
18K Double Ring Spin Earring...
$5,950
Item 18K Sorcerer Ring with Star Sapphire and diamond
18K Sorcerer Ring with Star Sapphire and diamon...
$4,500
18K Sorcerer Ring with Star ...
$4,500
Item 18K Standing Lion Pendant with diamond
18K Standing Lion Pendant with diamond
$8,700
18K Standing Lion Pendant wi...
$8,700
Item 18K Classic Amulet with rock crystal
18K Classic Amulet with oval rock crystal
$800 - $2,250
More sizes available
18K Classic Amulet with oval...
$800 - $2,250
More sizes available
Item 18K Sorcerer Ring with Star Sapphire and diamond
18K Sorcerer Ring with Star Sapphire and diamond

$4,500
18K Sorcerer Ring with Star Sapphire and diamond
$4,500
Item 18K Classic Amulet with rock crystal, Royal Blue Moonstone and tanzanite
18K Classic Cabochon Amulet with oval rock crys...
$3,700 - $5,500
More sizes available
18K Classic Cabochon Amulet ...
$3,700 - $5,500
More sizes available
Item 18K Astrid Moonface Ring with royal blue moonstone and diamond
18K Astrid Moonface Ring with royal blue moonst...
$10,500
18K Astrid Moonface Ring wit...
$10,500
Item 18K Owl Locket with tanzanite and diamond
18K Owl Locket
$6,950
18K Owl Locket
$6,950
Item 18K Small Owl Locket with tanzanite and diamond
18K Small Owl Locket with tanzanite and diamond
$1,850
18K Small Owl Locket with ta...
$1,850
Item 18K Astrid Ring with Blue Moonstone Face and mix color sapphire
18K Astrid Ring with Blue Moonstone Face and mi...
$8,900
18K Astrid Ring with Blue Mo...
$8,900
Item 18K Mandala Cutout Earrings with diamond
18K Mandala Cutout Earrings with diamond
$2,750
18K Mandala Cutout Earrings ...
$2,750
Item 18K Classic Oval Earrings with cabochon Royal Blue Moonstone and diamond
18K Classic Cabochon Oval Earring with diamond
$2,100
18K Classic Cabochon Oval Ea...
$2,100
Item 18K Sorcerer Ring with black opal and diamond
18K Sorcerer Ring with black opal and diamond
$15,010
18K Sorcerer Ring with black...
$15,010
Item 18K Dragonfly Pendant with diamond pavé
18K Dragonfly Pendant with diamond pavé
$2,000
18K Dragonfly Pendant with d...
$2,000
Item 18K Owlet Amulet with blue sapphire and diamond pavé
18K Owl Amulet with blue sapphire and diamond p...
$3,750 - $15,500
More sizes available
18K Owl Amulet with blue sap...
$3,750 - $15,500
More sizes available
Item 18K Moonface Ring with blue sapphire
18K Moonface Ring with blue sapphire
$4,200
18K Moonface Ring with blue ...
$4,200
Item 18K Classic Cabochon Oval Earrings with Royal Blue Moonstone and diamond
18K Classic Cabochon Oval Earrings with diamond...
$3,600
18K Classic Cabochon Oval Ea...
$3,600
Item 18K Moonface ring with diamond
18K Moonface ring with diamond

$4,900
18K Moonface ring with diamond
$4,900
Item 18K Dolphin Pendant with diamond pavé
18K Dolphin Pendant with diamond pavé
$2,800
18K Dolphin Pendant with dia...
$2,800
Item 18K Archival Amulet with round rock crystal and emerald
18K Archival Amulet with round rock crystal
$5,500 - $5,950
More colors available
18K Archival Amulet with rou...
$5,500 - $5,950
More colors available
Item 18K Classic Halo Pear Drop Earrings with Royal Blue Moonstone and diamond pavé
18K Classic Halo Pear Drop Earrings with Royal ...
$6,950
18K Classic Halo Pear Drop E...
$6,950
Item 18K Triple Drop Tolomeo Earrings with mixed sapphire and diamond
18K Triple Drop Tolomeo Earrings with mixed sap...
$5,200
18K Triple Drop Tolomeo Earr...
$5,200
Item 18K Small Turtle Locket with diamond pavé
18K Small Turtle Locket

$3,250 - $3,950
More colors available
18K Small Turtle Locket
$3,250 - $3,950
More colors available
Item 18K Classic Amulet with rock crystal and diamond pavé
18K Classic Amulet with oval rock crystal and d...
$2,200 - $5,600
More sizes available
18K Classic Amulet with oval...
$2,200 - $5,600
More sizes available
Item 18K Pavé Halo Pyramid Earrings with tanzanite and diamond pavé
18K Pavé Halo Pyramid Earrings with tanz...
$12,500
18K Pavé Halo Pyramid...
$12,500
Item 18K Lantern Amulet Earrings with rock crystal and diamond
18K Lantern Amulet Earrings with rock crystal a...
$3,500
18K Lantern Amulet Earrings ...
$3,500
Item 18K Spiral Turtle Locket with tanzanite, blue sapphire and diamond
18K Spiral Turtle Locket
$6,950 - $7,600
More colors available
18K Spiral Turtle Locket
$6,950 - $7,600
More colors available
Item 18K Eternity Hoop Earrings with blue sapphire
18K Eternity Hoop Earrings
$3,250 - $4,500
More colors available
18K Eternity Hoop Earrings
$3,250 - $4,500
More colors available
Item 18K Matisse Amulet with rock crystal, rose cut blue sapphire and diamond pavé
18K Matisse Amulet
$8,000
18K Matisse Amulet
$8,000
Item 18K Double Amulet Drop Earrings with rock crystal and diamond pavé
18K Double Amulet Drop Earrings with rock cryst...
$3,500
18K Double Amulet Drop Earri...
$3,500
Item 18K Mare Necklace with royal blue moonstone, blue sapphire, tsavorite and diamond
18K Mare Necklace with royal blue moonstone, bl...
$23,000
18K Mare Necklace with royal...
$23,000
Item 18K Turtle Ring with diamond pavé
18K Pavé Turtle Ring
$1,950
More colors available
18K Pavé Turtle Ring
$1,950
More colors available
Item 18K Large Pavé Halo Cutout Dragonfly Pendant with diamond
18K Pavé Halo Cutout Dragonfly Pendant w...
$1,100 - $4,500
More sizes available
18K Pavé Halo Cutout ...
$1,100 - $4,500
More sizes available
Item 18K Double Drop Earrings with Royal Blue Moonstone and diamond
18K Double Drop Earrings with diamond
$2,950
18K Double Drop Earrings wit...
$2,950
Item 18K Classic Graduated Round Necklace with Royal Blue Moonstone and diamond
18K Classic Graduated Round Necklace with Royal...
$17,500
18K Classic Graduated Round ...
$17,500
Item 18K Flying Fish Amulet with rock crystal, royal blue moonstone, blue sapphire and diamond
18K Flying Fish Amulet with rock crystal, royal blue moonstone, blue sapphire and diamond

$7,500 - $22,000
More sizes available
18K Flying Fish Amulet with rock crystal, royal blue moonstone, blue sapphi...
$7,500 - $22,000
More sizes available
Item 18K Cutout Tree Pendant with diamond pavé
18K Cutout Tree Pendant with diamond pavé...
$2,500
18K Cutout Tree Pendant with...
$2,500
Item 18K Volo Necklace with diamond
18K Volo Necklace with diamond
$20,000
18K Volo Necklace with diamo...
$20,000
Item 18K Medium Granulated Hoop Earrings
18K Granulated Hoop Earrings
$1,950
18K Granulated Hoop Earrings
$1,950
Item 18K Sea Star Amulet with rock crystal and diamond pavé
18K Starfish Amulet with oval rock crystal and ...
$3,950 - $7,250
More sizes available
18K Starfish Amulet with ova...
$3,950 - $7,250
More sizes available
Item 18K Small Tree of Life Pendant with diamond pavé
18K Pavé Tree of Life Pendant with diamond

$11,000 - $19,500
More sizes available
18K Pavé Tree of Life Pendant with diamond
$11,000 - $19,500
More sizes available
Item 18K Evil Eyelash Amulet in oval rock crystal, blue sapphire and diamond
18K Evil Eyelash Amulet in oval rock crystal, b...
$3,700 - $6,700
More sizes available
18K Evil Eyelash Amulet in o...
$3,700 - $6,700
More sizes available
Item 18K Evil Eyelash Ring in sapphire and diamond
18K Evil Eyelash Ring in sapphire and diamond
$6,500
18K Evil Eyelash Ring in sap...
$6,500
Item 18K Classic Jean D'Arc Link Necklace with peridot and diamond
18K Classic Jean D'Arc Link Necklace
$29,500 - $69,000
More colors available
18K Classic Jean D'Arc Link ...
$29,500 - $69,000
More colors available
Item 18K Evil Eye Necklace in white sapphire and diamond
18K Evil Eye Necklace in white sapphire and dia...
$7,500
18K Evil Eye Necklace in whi...
$7,500
Item 18K Double Ring Spin Earrings
18K Double Ring Spin Earrings
$1,950
18K Double Ring Spin Earring...
$1,950
Item 18K Small Dragonfly Locket with diamond
18K Small Dragonfly Locket with diamond
$2,950
18K Small Dragonfly Locket w...
$2,950
Item 18K Black Leather Cord
18K Leather Cord
$750
More colors available
18K Leather Cord
$750
More colors available
Item 18K Pavé Halo Mandala Cutout Pendant with diamond
18K Pavé Halo Mandala Cutout Pendant wit...
$2,500
18K Pavé Halo Mandala...
$2,500
Item 18K Foglia Earrings with diamond pavé
18K Foglia Earrings with diamond pavé
$4,750
18K Foglia Earrings with dia...
$4,750
Item 18K Double Link Scarab Necklace in diamond
18K Double Link Scarab Necklace in diamond
$16,000
18K Double Link Scarab Neckl...
$16,000
Item 18K Wing Pendant with Royal Blue Moonstone and diamond
18K Wing Pendant with Royal Blue Moonstone and ...
$2,500
18K Wing Pendant with Royal ...
$2,500
Item 18K Pavé Sea Star Earrings with diamond
18K Pavé Sea Star Earrings
$2,500
18K Pavé Sea Star Ear...
$2,500
Item 18K Classic Arno Chain - 32
18K Classic Arno Chain

$6,750 - $12,000
More sizes available
18K Classic Arno Chain
$6,750 - $12,000
More sizes available
Item 18K Piccolo Tolomeo Pendant with Royal Blue Moonstone and diamond
18K Piccolo Tolomeo Pendant with Royal Blue Moo...
$2,400
18K Piccolo Tolomeo Pendant ...
$2,400
Item 18K Eight Ring Tolomeo Pendant with mixed sapphire and diamond
18K Eight Ring Tolomeo Pendant with mixed sapph...
$25,000
18K Eight Ring Tolomeo Penda...
$25,000
Item 18K Vine Ring
18K Vine Ring
$1,950
More sizes available
18K Vine Ring
$1,950
More sizes available
Item 18K Sea Star Earrings with Royal Blue Moonstone and diamond
18K Sea Star Earrings with Royal Blue Moonstone...
$3,950
18K Sea Star Earrings with R...
$3,950
Item 18K Lotus Necklace in blue moonstone and diamond
18K Lotus Necklace in blue moonstone and diamond

$17,500
18K Lotus Necklace in blue moonstone and diamond
$17,500
Item 18K Cleo Necklace with royal blue moonstone and blue sapphire
18K Cleo Necklace with royal blue moonstone and...
$30,000
18K Cleo Necklace with royal...
$30,000
Item 18K Mare Drop Earrings with royal blue moonstone, blue sapphire, tsavorite and diamond
18K Mare Drop Earrings with royal blue moonston...
$8,750
18K Mare Drop Earrings with ...
$8,750
Item 18K Three Ring Tolomeo Pendant with mixed sapphire and diamond
18K Three Ring Tolomeo Pendant with mixed sapph...
$10,000
18K Three Ring Tolomeo Penda...
$10,000
Item 18K Sorcerer Pendant with mixed sapphire pavé
18K Sorcerer Pendant with mixed sapphire pav&ea...
$2,750
18K Sorcerer Pendant with mi...
$2,750
Item 18K Classic Oval Chain - 18
18K Classic Oval Chain
$3,700 - $6,500
More sizes available
18K Classic Oval Chain
$3,700 - $6,500
More sizes available
Item 18k Evil Eye Ring in emerald and blue sapphire
18k Evil Eye Ring in emerald and blue sapphire
$3,250
18k Evil Eye Ring in emerald...
$3,250
Item 18K Angel Earrings with diamond granulation
18K Angel Earrings with diamond
$1,750 - $2,700
More sizes available
18K Angel Earrings with diam...
$1,750 - $2,700
More sizes available
Item 18K Three Ring Tolomeo Pendant with diamond
18K Three Ring Tolomeo Pendant with diamond
$10,500
18K Three Ring Tolomeo Penda...
$10,500
Item 18K Classic Round Chain - 24
18K Classic Round Chain
$4,100 - $5,400
More sizes available
18K Classic Round Chain
$4,100 - $5,400
More sizes available
Item 18K Lion Ring with diamond
18K Lion Ring with diamond
$4,950
18K Lion Ring with diamond
$4,950
Item 18K Owl Face Ring with emerald and blue sapphire
18K Owl Face Ring with emerald and blue sapphir...
$6,700
18K Owl Face Ring with emera...
$6,700
Item 18K Cleo Drop Necklace with royal blue moonstone and sapphire
18K Cleo Drop Necklace with royal blue moonston...
$19,500
18K Cleo Drop Necklace with ...
$19,500
Item 18K Sorcerer Ring in mixed sapphire and diamond
18K Sorcerer Ring in mixed sapphire and diamond

$3,250
18K Sorcerer Ring in mixed sapphire and diamond
$3,250
Item 18K Piccolo Tolomeo Pendant with mixed sapphire and diamond
18K Piccolo Tolomeo Pendant with mixed sapphire...
$1,750
18K Piccolo Tolomeo Pendant ...
$1,750
Item 18K Small Sorcerer Locket with diamond
18K Small Sorcerer Locket with diamond
$2,950
18K Small Sorcerer Locket wi...
$2,950
Item 18K Angel Earrings
18K Angel Earrings
$2,200
18K Angel Earrings
$2,200
Item 18K Sole Necklace with royal blue moonstone and diamond
18K Sole Necklace with royal blue moonstone and...
$5,500
18K Sole Necklace with royal...
$5,500
Item 18K Scarab Ring in diamond
18K Scarab Ring

$3,250
More colors available
18K Scarab Ring
$3,250
More colors available
Item 18K Angel Earrings with diamond pavé
18K Angel Earrings with diamond pavé
$3,700
18K Angel Earrings with diam...
$3,700
Item 18K Small Crescent Moon Pendant with Royal Blue Moonstone, blue sapphire and diamond
18K Crescent Moon Pendant
$1,500
18K Crescent Moon Pendant
$1,500
Item 18K Moon Face Luna Pendant with Royal Blue Moonstone and sapphire
18K Moon Face Luna Pendant with Royal Blue Moon...
$7,200
18K Moon Face Luna Pendant w...
$7,200
Item 18K Classic Link Necklace with peridot, Royal Blue Moonstone, aquamarine, iolite and diamond
18K Classic Link Necklace with peridot, Royal B...
$52,000
18K Classic Link Necklace wi...
$52,000
Item 18K Arcadia Ring with emerald and diamond
18K Arcadia Ring with emerald and diamond
$45,000
18K Arcadia Ring with emeral...
$45,000
Item 18K Evil Eye Necklace in blue sapphire and diamond
18K Evil Eye Necklace in blue sapphire and diam...
$12,500
18K Evil Eye Necklace in blu...
$12,500
Item 18K Moonface Pendant with rock crystal and diamond
18K Moonface Pendant with carved rock crystal a...
$650 - $1,850
More sizes available
18K Moonface Pendant with ca...
$650 - $1,850
More sizes available
Item 18K Mare Ring with royal blue moonstone, blue sapphire, tsavorite and diamond
18K Mare Ring with royal blue moonstone, blue s...
$2,950
18K Mare Ring with royal blu...
$2,950
Item 18K Extra Small Oval Chain - 18
18K Extra Small Oval Chain
$1,550 - $2,600
More sizes available
18K Extra Small Oval Chain
$1,550 - $2,600
More sizes available
Item 18K Buddha Pendant with emerald and diamond
18K Buddha Pendant with emerald and diamond
$23,000
18K Buddha Pendant with emer...
$23,000
Item 18K Scarab Ring in blue sapphire and emerald
18K Scarab Ring in blue sapphire and emerald
$6,500
18K Scarab Ring in blue sapp...
$6,500
Item 18K Small Round Chain - 18
18K Small Round Chain
$1,250 - $2,150
More sizes available
18K Small Round Chain
$1,250 - $2,150
More sizes available
Item 18K Evil Eye Drop Earring in blue sapphire, emerald and diamond
18K Evil Eye Drop Earring in blue sapphire, emerald and diamond

$8,700
18K Evil Eye Drop Earring in blue sapphire, emerald and diamond
$8,700
Item 18K Athena Owl Ring with blue green tourmaline, Royal Blue Moonstone, emerald, blue sapphire and diamond
18K Athena Owl Ring
$37,000
More colors available
18K Athena Owl Ring
$37,000
More colors available
Item 18K Buddha Pendant with ruby and diamond
18K Buddha Pendant with ruby and diamond
$23,000
18K Buddha Pendant with ruby...
$23,000
Item 18K Evil Eye Drop Earring in diamond
18K Evil Eye Drop Earring in diamond
$3,500
18K Evil Eye Drop Earring in...
$3,500
Item 18K Cutout Sorcerer Pendant with diamond pavé
18K Cutout Sorcerer Pendant with diamond pav&ea...
$3,200
18K Cutout Sorcerer Pendant ...
$3,200
Item 18K Mosaic Ring with emerald, ruby, blue sapphire and diamond
18K Mosaic Ring with emerald, ruby, blue sapphire and diamond

$15,000
18K Mosaic Ring with emerald, ruby, blue sapphire and diamond
$15,000
Item 18K Bombe Ring with Royal Blue Moonstone and diamond
18K Bombe Ring with Royal Blue Moonstone and di...
$7,500
18K Bombe Ring with Royal Bl...
$7,500
Item 18K Classic Longchain Necklace with rose cut white sapphire - 18
18K Classic Longchain Necklace with rose cut wh...
$8,700 - $15,400
More sizes available
18K Classic Longchain Neckla...
$8,700 - $15,400
More sizes available
Item 18K Sorcerer Locket with blue sapphire and diamond
18K Sorcerer Locket with blue sapphire and diam...
$6,950
18K Sorcerer Locket with blu...
$6,950
Item 18K Classic Cushion Ring with royal blue moonstone and blue sapphire
18K Classic Cushion Ring with royal blue moonst...
$15,500
18K Classic Cushion Ring wit...
$15,500
Item 18K Scarab Earring in blue sapphire and diamond
18K Scarab Earring
$2,950
More colors available
18K Scarab Earring
$2,950
More colors available
Item 18K Small Classic Five-Stone Cross with pearl and diamond
18K Small Classic Five-Stone Cross with pearl a...
$1,750
18K Small Classic Five-Stone...
$1,750
Item 18K Classic Longchain Necklace with rose cut mixed sapphire - 24
18K Classic Longchain Necklace with rose cut mi...
$12,600 - $16,800
More sizes available
18K Classic Longchain Neckla...
$12,600 - $16,800
More sizes available
Item 18K Sea Star Pendant with diamond pavé
18K Sea Star Pendant with diamond pavé
$1,300
18K Sea Star Pendant with di...
$1,300
Item 18K Karina Necklace with emerald - 18
18K Karina Necklace with Emerald
$3,500 - $3,950
More sizes available
18K Karina Necklace with Eme...
$3,500 - $3,950
More sizes available
Item 18K Scarab Earring in diamond
18K Scarab Earring in diamond
$1,850
18K Scarab Earring in diamon...
$1,850
Item 18K Crown Ring with Royal Blue Moonstone
18K Crown Ring with Royal Blue Moonstone
$6,500
18K Crown Ring with Royal Bl...
$6,500
Item 18K Small Sea Star Locket with diamond
18K Small Sea Star Locket with diamond
$2,950
18K Small Sea Star Locket wi...
$2,950
Item 18K Mermaid Locket with diamond
18K Mermaid Locket with diamond

$6,950
18K Mermaid Locket with diamond
$6,950
Item 18K Lariat Necklace with Royal Blue Moonstone, tanzanite and diamond
18K Lariat Necklace with Royal Blue Moonstone, ...
$32,000
18K Lariat Necklace with Roy...
$32,000
Item 18K Small Sea Biscuit Ring with tsavorite and diamond pavé
18K Sea Biscuit Ring with tsavorite and diamond...
$7,500
18K Sea Biscuit Ring with ts...
$7,500
Item 18K Karina Necklace with ruby - 18
18K Karina Necklace with cabochon ruby
$2,350 - $3,100
More sizes available
18K Karina Necklace with cab...
$2,350 - $3,100
More sizes available
Item 18K Turtle Earrings with diamond pavé
18K Turtle Earrings with diamond pavé
$5,200
18K Turtle Earrings with dia...
$5,200
Item 18K Sea Biscuit Pendant with blue sapphire and diamond pavé
18K Sea Biscuit Pendant with blue sapphire and diamond pavé

$6,500
More colors available
18K Sea Biscuit Pendant with blue sapphire and diamond pavé
$6,500
More colors available
Item 18K Amulet Necklace with rock crystal and diamond
18K Amulet Necklace with rock crystal and diamo...
$5,400 - $9,500
More sizes available
18K Amulet Necklace with roc...
$5,400 - $9,500
More sizes available
Item 18K Ball Chain - 16
18K Ball Chain with 2" Extender
$1,050 - $1,200
More sizes available
18K Ball Chain with 2" Exten...
$1,050 - $1,200
More sizes available
Item 18K Bellina Bangle with Royal Blue Moonstone and diamond
18K Bellina Bangle with diamond
$4,200
18K Bellina Bangle with diam...
$4,200
Item 18K Classic Oval Ring with pink tourmaline and diamond
18K Classic Oval Ring with pink tourmaline and ...
$9,800
18K Classic Oval Ring with p...
$9,800
Item 18K Scarab Drop Earring in diamond
18K Scarab Drop Earring in diamond
$2,750
18K Scarab Drop Earring in d...
$2,750



Scroll Up


					SELECT
						NavisionProductInfo.id, NavisionProductInfo.web_name, NavisionProductInfo.price_retail, NavisionProductInfo.group_id,
						WebProductSort.sort_weight, WebProductSort.web_product_image_id,
						WebProductImage.id, WebProductImage.navision_product_info_id, WebProductImage.name,
						WebProduct.sort_weight, WebProduct.status, WebProduct.exclusive,
						IFNULL(NavisionProductInfo.group_id,UUID()) as group_id,
						NavisionProductGroup.total_products, NavisionProductGroup.min_price, NavisionProductGroup.max_price, NavisionProductGroup.web_name, NavisionProductGroup.web_product_image_id, NavisionProductGroup.type,
						NavisionClassification.web_sort_weight, NavisionCollection.web_sort_weight, NavisionProductInfo.id,
						WebProductGroupImage.`navision_product_info_id`,
						WebProductSortImage.`navision_product_info_id`
					FROM
						navision_product_infos NavisionProductInfo
							LEFT JOIN web_products WebProduct on NavisionProductInfo.id=WebProduct.navision_product_info_id
							LEFT JOIN web_product_images WebProductImage on NavisionProductInfo.id=WebProductImage.navision_product_info_id AND WebProductImage.primary="YES"
							LEFT JOIN navision_product_groups NavisionProductGroup ON NavisionProductInfo.group_id=NavisionProductGroup.navision_product_info_id
								LEFT JOIN web_product_images WebProductGroupImage ON NavisionProductGroup.web_product_image_id=WebProductGroupImage.id
							LEFT JOIN navision_collections NavisionCollection on NavisionProductInfo.collection_1=NavisionCollection.name
							LEFT JOIN navision_classifications NavisionClassification on NavisionProductInfo.classification=NavisionClassification.name
							LEFT JOIN web_product_sorts WebProductSort on NavisionProductInfo.group_id=WebProductSort.navision_product_info_id AND WebProductSort.navision_collection_id=0
								LEFT JOIN web_product_images WebProductSortImage ON WebProductSort.web_product_image_id=WebProductSortImage.id
					WHERE
						(NavisionProductInfo.status='ACTIVECORE' or NavisionProductInfo.status='ACTIVESPEC' or NavisionProductInfo.status='NEWCOLL') and NavisionProductInfo.number_in_stock>0 and NavisionProductInfo.price_retail>0
					GROUP BY
						group_id
					ORDER BY 
						WebProduct.sort_weight desc
					LIMIT
						150
				Array
(
    [NavisionProductInfo] => Array
        (
            [id] => R11827-PVHORSE
            [web_name] => 18K Mini Horseshoe Ring in diamond pavé
            [price_retail] => 1950
            [group_id] => R11827
        )

    [WebProductSort] => Array
        (
            [sort_weight] => 
            [web_product_image_id] => 
        )

    [WebProductImage] => Array
        (
            [id] => 1414
            [navision_product_info_id] => R11827-PVHORSE
            [name] => 
        )

    [WebProduct] => Array
        (
            [sort_weight] => 86
            [status] => 
            [exclusive] => NO
        )

    [0] => Array
        (
            [group_id] => R11827
        )

    [NavisionProductGroup] => Array
        (
            [total_products] => 
            [min_price] => 
            [max_price] => 
            [web_name] => 
            [web_product_image_id] => 
            [type] => 
        )

    [NavisionClassification] => Array
        (
            [web_sort_weight] => 0
        )

    [NavisionCollection] => Array
        (
            [web_sort_weight] => 7
        )

    [WebProductGroupImage] => Array
        (
            [navision_product_info_id] => 
        )

    [WebProductSortImage] => Array
        (
            [navision_product_info_id] => 
        )

)