Logo
Search
Temple St. Clair
Locations
Shopping Bag
Categories > The Amulet
Item 18K Vine Amulet with rock crystal and diamond
18K Vine Amulet with oval rock crystal and diamond

$1,750 - $6,950
More sizes available
18K Vine Amulet with oval rock crystal and diamond
$1,750 - $6,950
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 Amulet with round rock crystal and diamond
18K Classic Amulet with round rock crystal and ...
$1,300
18K Classic Amulet with roun...
$1,300
Item 18K Classic Amulet with rock crystal
18K Classic Amulet with oval rock crystal
$800 - $4,250
More sizes available
18K Classic Amulet with oval...
$800 - $4,250
More sizes 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 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 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 Lunar Phase Amulet in rock crystal 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 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 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 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 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 Matisse Amulet with rock crystal, rose cut blue sapphire and diamond pavé
18K Matisse Amulet

$8,000
18K Matisse Amulet
$8,000
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 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 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 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 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 crystal - 16x11mm
$1,750 - $1,900
More colors available
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 cry...
$4,500 - $8,950
More sizes available
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 Angel Crystal Locket with diamond
18K Angel Crystal Locket with diamond
$9,700
18K Angel Crystal Locket wit...
$9,700
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...
$3,700 - $5,500
More sizes available
18K Classic Light Mix Caboch...
$3,700 - $5,500
More sizes available





					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=40
								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='AMULETS')
					GROUP BY
						group_id
					ORDER BY 
						WebProduct.sort_weight DESC
					LIMIT
						150
				Array
(
    [NavisionProductInfo] => Array
        (
            [id] => P51816-E11VINE
            [web_name] => 18K Vine Amulet with rock crystal and diamond
            [price_retail] => 1750
            [group_id] => P51816-GROUP
        )

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

    [WebProductImage] => Array
        (
            [id] => 528
            [navision_product_info_id] => P51816-E11VINE
            [name] => P51816-E11VINE
        )

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

    [0] => Array
        (
            [group_id] => P51816-GROUP
        )

    [NavisionProductGroup] => Array
        (
            [total_products] => 3
            [min_price] => 1750
            [max_price] => 6950
            [web_name] => 18K Vine Amulet with oval rock crystal and diamond
            [web_product_image_id] => 1501
            [type] => SIZE
        )

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

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

    [WebProductGroupImage] => Array
        (
            [navision_product_info_id] => P51816-E27VINE
        )

    [WebProductSortImage] => Array
        (
            [navision_product_info_id] => P51816-E27VINE
        )

)