- Home
- Collections
- Necklaces
Necklaces
Personalize your style with our necklaces that make a statement. Layer our stunning gold, silver and two-tone necklaces and look effortlessly chic.
SELECT DISTINCT `e`.*, `cat_index`.`position` AS `cat_index_position`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `stock_status_index`.`stock_status` AS `is_salable` FROM `km7_catalog_product_entity` AS `e`
INNER JOIN `km7_catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id='5'
INNER JOIN `km7_catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0
LEFT JOIN `km7_cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1
INNER JOIN `km7_catalog_product_index_eav` AS `layered_nav_style` ON `layered_nav_style`.`entity_id` = `e`.`entity_id` AND `layered_nav_style`.`attribute_id` = '157' AND `layered_nav_style`.`store_id` = '1' AND `layered_nav_style`.`value` IN (106) ORDER BY `e`.`created_at` DESC, `e`.`created_at` DESC
LIMIT 15 OFFSET 15
Refine items
Showing 15 items
Sort by
-
Adding to your Wishlist Removing from your Wishlist
Breathtaking Necklace SetÂ
$21,200.11 -
Adding to your Wishlist Removing from your Wishlist
Unbelievably Beautiful Necklace
$18,765.69 -
Adding to your Wishlist Removing from your Wishlist
Dazzling Diamond Necklace
$9,197.39 -
Adding to your Wishlist Removing from your Wishlist
Gorgeous Glittering Necklace
$5,041.24 $4,890.00 -
Adding to your Wishlist Removing from your Wishlist
Designer Diamond Neckpiece
$12,053.51 -
Adding to your Wishlist Removing from your Wishlist
Angelic Diamond Necklace
$15,880.61 -
Adding to your Wishlist Removing from your Wishlist
Mandala Art Choker
$10,196.31 -
Adding to your Wishlist Removing from your Wishlist
Queens Pastime Neckpiece
$3,284.94 -
Adding to your Wishlist Removing from your Wishlist
Dapper Diva Neckpiece
$3,109.58 -
Adding to your Wishlist Removing from your Wishlist
Tasseled Ruby And Diamonds Necklace Set
$7,581.69 $7,354.24 -
Adding to your Wishlist Removing from your Wishlist
The Rhythm Of The Rubies Choker Set
$21,962.59 -
Adding to your Wishlist Removing from your Wishlist
From The Queen's Treasures
$17,512.99 -
Adding to your Wishlist Removing from your Wishlist
Heavily Studded Pearl And Emerald Choker Set
$21,115.39 $20,059.62 -
Adding to your Wishlist Removing from your Wishlist
Forest of Diamonds And Emeralds
$6,167.68 -
Adding to your Wishlist Removing from your Wishlist
Sparkling Leafy Emerald Necklace
$4,672.18
You chose United States of America(USA) as shipping country and trying to checkout with currency INR. So, please click the below button to change the currency to USD.
You chose India as shipping country and trying to checkout with currency USD. So, please click the below button to change the currency to INR.
Sign In
Create New Account