Temple St Clair Logo
Search
Temple St. Clair
Locations
Shopping Bag
Categories > Pendants
Item 18K Evil Eye Pendant in emerald and blue sapphire
18K Evil Eye Pendant in emerald and blue sapphire

$2,500
18K Evil Eye Pendant in emerald and blue sapphire
$2,500
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 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 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 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 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 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 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, 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 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 Dragonfly Pendant with diamond pavé
18K Dragonfly Pendant with diamond pavé

$2,000
18K Dragonfly Pendant with diamond pavé
$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 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 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 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 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 Matisse Amulet with rock crystal, rose cut blue sapphire and diamond pavé
18K Matisse Amulet
$8,000
18K Matisse Amulet
$8,000
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 Cutout Tree Pendant with diamond pavé
18K Cutout Tree Pendant with diamond pavé...
$2,500
18K Cutout Tree Pendant with...
$2,500
Item 18K Flying Fish Amulet with rock crystal, royal blue moonstone, blue sapphire and diamond
18K Flying Fish Amulet with rock crystal, royal...
$7,500 - $22,000
More sizes available
18K Flying Fish Amulet with ...
$7,500 - $22,000
More sizes available
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 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 Small Tree of Life Pendant with diamond pavé
18K Pavé Tree of Life Pendant with diamo...
$11,000 - $19,500
More sizes available
18K Pavé Tree of Life...
$11,000 - $19,500
More sizes available
Item 18K Small Dragonfly Locket with diamond
18K Small Dragonfly Locket with diamond
$2,950
18K Small Dragonfly Locket w...
$2,950
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 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 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 sapphire and diamond

$25,000
18K Eight Ring Tolomeo Pendant with mixed sapphire and diamond
$25,000
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 Three Ring Tolomeo Pendant with diamond
18K Three Ring Tolomeo Pendant with diamond
$10,500
18K Three Ring Tolomeo Penda...
$10,500
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 with diamond
$2,950
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 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 Buddha Pendant with emerald and diamond
18K Buddha Pendant with emerald and diamond
$23,000
18K Buddha Pendant with emer...
$23,000
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 Cutout Sorcerer Pendant with diamond pavé
18K Cutout Sorcerer Pendant with diamond pav&ea...
$3,200
18K Cutout Sorcerer Pendant ...
$3,200
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 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 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 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 diam...
$6,950
Item 18K Sea Biscuit Pendant with blue sapphire and diamond pavé
18K Sea Biscuit Pendant with blue sapphire and ...
$6,500
More colors available
18K Sea Biscuit Pendant with...
$6,500
More colors available
Item 18K Flying Fish Pendant with royal blue moonstone, blue sapphire and tsavorite
18K Flying Fish Pendant with royal blue moonstone, blue sapphire and tsavorite

$5,950
18K Flying Fish Pendant with royal blue moonstone, blue sapphire and tsavor...
$5,950
Item 18k Small Cross with royal blue moonstone
18k Small Cross with royal blue moonstone
$1,500
18k Small Cross with royal b...
$1,500
Item 18K Classic Five-Stone Cross with Royal Blue Moonstone and diamond
18K Classic Five-Stone Cross with Royal Blue Mo...
$6,250
18K Classic Five-Stone Cross...
$6,250
Item 18K Classic Cross Pendant with diamond
18K Classic Cross Pendant
$1,200 - $2,950
More colors available
18K Classic Cross Pendant
$1,200 - $2,950
More colors available
Item 18K Classic Faceted Amulet with rock crystal, ruby, emerald and blue sapphire
18K Classic Faceted Amulet with oval rock cryst...
$1,250 - $3,500
More sizes available
18K Classic Faceted Amulet w...
$1,250 - $3,500
More sizes available
Item 18K Classic Light Mix Amulet with rock crystal, aquamarine, royal bluemoon stone, peridot, pink tourmaline and iolite
18K Classic Light Mix Cabochon Amulet with oval rock crystal and mixed cabochon gemstones

$3,700 - $5,500
More sizes available
18K Classic Light Mix Cabochon Amulet with oval rock crystal and mixed cabo...
$3,700 - $5,500
More sizes available
Item 18K Classic Amulet with round rock crystal
18K Classic Amulet with round rock crystal
$800
18K Classic Amulet with roun...
$800
Item 18K Classic Pearl Pendant with diamond granulation
18K Classic Pearl Pendant with diamond granulat...
$850
18K Classic Pearl Pendant wi...
$850
Item 18K Angel Pendant
18K Angel Pendant
$650 - $2,150
More sizes available
18K Angel Pendant
$650 - $2,150
More sizes available
Item 18K Angel Pendant with diamond pavé
18K Pave Angel Pendant with diamond
$1,850 - $5,400
More sizes available
18K Pave Angel Pendant with ...
$1,850 - $5,400
More sizes available
Item 18K Matisse Amulet with rock crystal and diamond pavé
18K Matisse Amulet with rock crystal - 16x11mm
$4,500
18K Matisse Amulet with rock...
$4,500
Item 18K Classic Amulet with round rock crystal and mixed sapphire pavé
18K Classic Amulet with round rock crystal and ...
$3,250
18K Classic Amulet with roun...
$3,250
Item 18K Angel Pendant with diamond
18K Angel Pendant with diamond granulation
$950 - $2,350
More sizes available
18K Angel Pendant with diamo...
$950 - $2,350
More sizes available
Item 18K Sea Star Amulet with rock crystal, Royal Blue Moonstone, blue sapphire and diamond
18K Sea Star Amulet with oval rock crystal, roy...
$6,950 - $10,500
More sizes available
18K Sea Star Amulet with ova...
$6,950 - $10,500
More sizes available
Item 18K Aries Zodiac pendant with diamond
18K Aries Zodiac pendant with diamond
$1,850
18K Aries Zodiac pendant wit...
$1,850
Item 18K Taurus Zodiac pendant with diamond
18K Taurus Zodiac pendant with diamond
$1,850
18K Taurus Zodiac pendant wi...
$1,850
Item 18K Matisse Amulet with rock crystal, rose cut blue sapphire and diamond pavé
18K Matisse Amulet with rock crystal, rose cut ...
$22,000
18K Matisse Amulet with rock...
$22,000
Item 18K Gemini Zodiac pendant with diamond
18K Gemini Zodiac pendant with diamond
$1,850
18K Gemini Zodiac pendant wi...
$1,850
Item 18K Classic Amulet with round rock crystal and diamond
18K Classic Amulet with round rock crystal and diamond

$1,300
18K Classic Amulet with round rock crystal and diamond
$1,300
Item 18K Lantern Amulet with rock crystal and blue sapphire
18K Lantern Amulet with rock crystal - 16x11mm
$1,750 - $1,900
More colors available
18K Lantern Amulet with rock...
$1,750 - $1,900
More colors available
Item 18K Dragonfly Amulet with rock crystal and diamond pavé
18K Dragonfly Amulet with oval rock crystal and...
$2,950
18K Dragonfly Amulet with ov...
$2,950
Item 18K Scorpio Zodiac pendant with diamond
18K Scorpio Zodiac pendant with diamond
$1,850
18K Scorpio Zodiac pendant w...
$1,850
Item 18K Leo Zodiac pendant with diamond
18K Leo Zodiac pendant with diamond
$1,850
18K Leo Zodiac pendant with ...
$1,850
Item 18K Lotus Amulet in rock crystal and diamond
18K Lotus Amulet in rock crystal and diamond

$4,500 - $8,950
More sizes available
18K Lotus Amulet in rock crystal and diamond
$4,500 - $8,950
More sizes available
Item 18K Virgo Zodiac pendant with diamond
18K Virgo Zodiac pendant with diamond
$1,850
18K Virgo Zodiac pendant wit...
$1,850
Item 18K Cancer Zodiac pendant with diamond
18K Cancer Zodiac pendant with diamond
$1,850
18K Cancer Zodiac pendant wi...
$1,850
Item 18K Libra Zodiac pendant with diamond
18K Libra Zodiac pendant with diamond
$1,850
18K Libra Zodiac pendant wit...
$1,850
Item 18K Capricorn Zodiac pendant with diamond
18K Capricorn Zodiac pendant with diamond
$1,850
18K Capricorn Zodiac pendant...
$1,850
Item 18K Sagittarius Zodiac pendant with diamond
18K Sagittarius Zodiac pendant with diamond
$1,850
18K Sagittarius Zodiac penda...
$1,850
Item 18K Aquarius Zodiac pendant with diamond
18K Aquarius Zodiac pendant with diamond
$1,850
18K Aquarius Zodiac pendant ...
$1,850
Item 18K Pisces Zodiac pendant with diamond
18K Pisces Zodiac pendant with diamond
$1,850
18K Pisces Zodiac pendant wi...
$1,850
Item 18K Lunar Phase Amulet in rock crystal, blue sapphire and diamond pavé
18K Lunar Amulet with oval rock crystal and dia...
$2,750 - $3,750
More sizes available
18K Lunar Amulet with oval r...
$2,750 - $3,750
More sizes available
Item 18K Moonface Pendant with crystal, mix sapphire, and diamond
18K Moonface Pendant with crystal, mix sapphire...
$3,750
18K Moonface Pendant with cr...
$3,750
Item 18K Large Pod Pendant with diamond
18K Large Pod Pendant with diamond
$2,600
18K Large Pod Pendant with d...
$2,600
Item 18K Flower Serpent Amulet with rock crystal, royal blue moonstone, blue sapphire, and diamond
18K Flower Serpent Amulet with rock crystal, ro...
$8,500
18K Flower Serpent Amulet wi...
$8,500
Item 18K Cosmos Pendant with diamond
18K Cosmos Pendant with diamond
$4,950
18K Cosmos Pendant with diam...
$4,950
Item 18K Cosmos Pendant with royal blue moonstone, tsavorite, tanzanite, pink tourmaline and diamond
18K Cosmos Pendant with royal blue moonstone, tsavorite, tanzanite, pink tourmaline and diamond

$7,950
18K Cosmos Pendant with royal blue moonstone, tsavorite, tanzanite, pink to...
$7,950
Item 18K Flower Serpent Amulet with rock crystal, royal blue moonstone, blue sapphire, tsavorite,and diamond
18K Flower Serpent Amulet with rock crystal, ro...
$19,500
18K Flower Serpent Amulet wi...
$19,500
Item 18K Sorcerer Crystal Locket in mix sapphires and diamond
18K Sorcerer Crystal Locket in mix sapphires an...
$11,500
18K Sorcerer Crystal Locket ...
$11,500



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_classification_id=17
								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 and (  NavisionProductInfo.classification='PENDANTS')
					GROUP BY
						group_id
					ORDER BY 
						WebProduct.sort_weight DESC
					LIMIT
						150
				Array
(
    [NavisionProductInfo] => Array
        (
            [id] => P36148-EYEEMBS
            [web_name] => 18K Evil Eye Pendant in emerald and blue sapphire
            [price_retail] => 2500
            [group_id] => P36148-EMBSEYE
        )

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

    [WebProductImage] => Array
        (
            [id] => 1461
            [navision_product_info_id] => P36148-EYEEMBS
            [name] => 
        )

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

    [0] => Array
        (
            [group_id] => P36148-EMBSEYE
        )

    [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] => 19
        )

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

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

)