Temple St Clair Logo
Search
Temple St. Clair
Locations
Shopping Bag
Categories > Necklaces
Item 18K Mare Necklace with royal blue moonstone, blue sapphire, tsavorite and diamond
18K Mare Necklace with royal blue moonstone, blue sapphire, tsavorite and diamond

$23,000
18K Mare Necklace with royal blue moonstone, blue sapphire, tsavorite and d...
$23,000
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 Volo Necklace with diamond
18K Volo Necklace with diamond
$20,000
18K Volo Necklace with diamo...
$20,000
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 Black Leather Cord
18K Leather Cord
$750
More colors available
18K Leather Cord
$750
More colors available
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 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 Lotus Necklace in blue moonstone and diamond
18K Lotus Necklace in blue moonstone and diamon...
$17,500
18K Lotus Necklace in blue m...
$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 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 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 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 Sole Necklace with royal blue moonstone and diamond
18K Sole Necklace with royal blue moonstone and diamond

$5,500
18K Sole Necklace with royal blue moonstone and diamond
$5,500
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 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 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 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 Classic Longchain Necklace with rose cut white sapphire - 18
18K Classic Longchain Necklace with rose cut white sapphire

$8,700 - $15,400
More sizes available
18K Classic Longchain Necklace with rose cut white sapphire
$8,700 - $15,400
More sizes available
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 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 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 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 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 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
$950
18K Ball Chain
$950
Item 18K Karina Necklace with faceted white sapphire - 18
18K Karina Necklace with faceted white sapphire
$2,600 - $3,400
More sizes available
18K Karina Necklace with fac...
$2,600 - $3,400
More sizes available
Item 18K Karina Necklace with  blue sapphire - 18
18K Karina Necklace with cabochon blue sapphire
$2,500 - $3,300
More sizes available
18K Karina Necklace with cab...
$2,500 - $3,300
More sizes available
Item 18K Small Flower Necklace with Royal Blue Moonstone and diamond
18K Small Flower Necklace with Royal Blue Moons...
$35,000
18K Small Flower Necklace wi...
$35,000
Item 18K Classic Pear Necklace with Royal Blue Moonstone and diamond
18K Classic Pear Necklace with Royal Blue Moons...
$17,000
18K Classic Pear Necklace wi...
$17,000
Item 18K Half Bib Necklace with Royal Blue Moonstone and diamond
18K Half Bib Necklace with Royal Blue Moonstone...
$9,800
18K Half Bib Necklace with R...
$9,800
Item 18K Ribbon Chain - 24
18K Ribbon Chain

$2,750 - $4,950
More sizes available
18K Ribbon Chain
$2,750 - $4,950
More sizes available
Item 18K Mini Pod Charm Necklace with diamond
18K Mini Pod Charm Necklace with diamond
$2,850
18K Mini Pod Charm Necklace ...
$2,850



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=18
								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='NECKLACES')
					GROUP BY
						group_id
					ORDER BY 
						WebProduct.sort_weight DESC
					LIMIT
						150
				Array
(
    [NavisionProductInfo] => Array
        (
            [id] => N46432-BMBSTV
            [web_name] => 18K Mare Necklace with royal blue moonstone, blue sapphire, tsavorite and diamond
            [price_retail] => 23000
            [group_id] => N46432-BMBSTV
        )

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

    [WebProductImage] => Array
        (
            [id] => 1334
            [navision_product_info_id] => N46432-BMBSTV
            [name] => 
        )

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

    [0] => Array
        (
            [group_id] => N46432-BMBSTV
        )

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

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

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

)