Item 18K Tree of Life Pendant with diamond pavé
18K Pavé Tree of Life Pendant with diamond
$11,000 - $19,500
More sizes available
Item 18K Large Cutout Dragonfly Pendant with diamond
18K Large Cutout Dragonfly Pendant with diamond
$1,100
Item 18K Dragonfly Pendant with diamond pavé
18K Dragonfly Pendant with diamond pavé
$2,000
Item 18K Wing Pendant with Royal Blue Moonstone and diamond
18K Wing Pendant with Royal Blue Moonstone and diamond
$2,500
Item 18K Standing Lion Pendant with diamond
18K Standing Lion Pendant with diamond
$8,700
Item 18K Sea Star Pendant with diamond pavé
18K Sea Star Pendant with diamond pavé
$1,300
Item 18K Small Turtle Locket with diamond pavé
18K Small Turtle Locket with diamond pavé
$3,950
Item 18K Spiral Turtle Locket with tanzanite, blue sapphire and diamond
18K Spiral Turtle Locket with tanzanite, blue sapphire and diamond
$6,950
Item 18K Owl Locket with mixed garnet and diamond
18K Owl Locket with mixed garnet and diamond
$7,500
Item 18K Angel Pendant, 10mm
18K Angel Pendant
$650 - $2,150
More sizes available
Item 18K Angel Pendant with diamond - 10mm
18K Angel Pendant with diamond granulation
$950 - $2,350
More sizes available
Item 18K Owl Face Pendant with diamond pavé
18K Owl Face Pendant with diamond pavé
$1,850
Item 18K Pavé Angel Pendant with diamond - 10mm
18K Pave Angel Pendant with diamond
$1,850 - $5,400
More sizes available
Item 18K Three Ring Tolomeo Pendant with diamond
18K Three Ring Tolomeo Pendant with diamond
$10,500
Item 18K Three Ring Tolomeo Pendant with mixed colored sapphire and diamond
18K Three Ring Tolomeo Pendant with mixed colored sapphire and diamond
$10,000
Item 18K Piccolo Tolomeo Pendant with mixed sapphire and diamond
18K Piccolo Tolomeo Pendant with mixed sapphire and diamond
$1,750
Item 18K Small Crescent Moon Pendant with Royal Blue Moonstone, blue sapphire and diamond
18K Crescent Moon Pendant
$1,500
Item 18K Eight Ring Tolomeo Pendant with mixed sapphire and diamond
18K Eight Ring Tolomeo Pendant with mixed sapphire and diamond
$25,000
Item 18K Piccolo Tolomeo Pendant with Royal Blue Moonstone and diamond
18K Piccolo Tolomeo Pendant with Royal Blue Moonstone and diamond
$2,400
Item 18K Medium Sea Star Pendant with Royal Blue Moonstone and diamond
18K Sea Star Pendant with royal blue moonstone and diamond
$2,200 - $4,700
More sizes available
Item 18K Sorcerer Pendant with mixed sapphire pavé
18K Sorcerer Pendant with mixed sapphire pavé
$2,750
Item 18K Classic Five-Stone Cross with Royal Blue Moonstone and diamond
18K Classic Five-Stone Cross with Royal Blue Moonstone and diamond
$6,250
Item 18K Cutout Sorcerer Pendant with diamond pavé
18K Cutout Sorcerer Pendant with diamond pavé
$3,200
Item 18K Small Pavé Halo Cutout Dragonfly Pendant with diamond
18K Small Pavé Halo Cutout Dragonfly Pendant with diamond
$1,100
Item 18K Cutout Tree Pendant with diamond pavé
18K Cutout Tree Pendant with diamond pavé
$2,500
Item 18K Moonface Pendant with rock crystal and diamond - 10mm
18K Moonface Pendant with carved rock crystal and diamond granulation
$650 - $1,850
More sizes available
Item 18K Pear Drop Pendant with Royal Blue Moonstone and diamond pavé
18K Pave Halo Pear Drop Pendant
$2,750
Item 18K Small Clover Pendant with tsavorite and diamond
18K Clover Pendant
$2,400
Item 18K Heart Pendant with rock crystal and diamond pavé - 10mm
18K Heart Pendant with rock crystal heart and diamond pavé
$1,700 - $2,750
More sizes available
Item 18K Cancer Zodiac pendant with diamond
18K Cancer Zodiac pendant with diamond
$1,850
web exclusive
Item 18K Sitting Fox Pendant with diamond pavé
18K Sitting Fox Pendant with diamond pavé
$3,500
Item 18K Taurus Zodiac pendant with diamond
18K Taurus Zodiac pendant with diamond
$1,850
web exclusive
Item 18k Small Cross with royal blue moonstone
18k Small Cross with royal blue moonstone
$1,500
Item 18K Small Sea Star Locket with diamond
18K Small Sea Star Locket with diamond
$2,950
Item 18K Leo Zodiac pendant with diamond
18K Leo Zodiac pendant with diamond
$1,850
web exclusive
Item 18K Moonface Pendant with rock crystal and diamond pavé - 10mm
18K Moonface Pendant with carved rock crystal and diamond pave
$1,650
Item 18K Aquarius Zodiac pendant with diamond
18K Aquarius Zodiac pendant with diamond
$1,850
web exclusive
Item 18K Sagittarius Zodiac pendant with diamond
18K Sagittarius Zodiac pendant with diamond
$1,850
web exclusive
Item 18K Blossom Pendant with Royal Blue Moonstone and diamond
18K Blossom Pendant with Royal Blue Moonstone and diamond
$6,500
Item 18K Classic Pearl Pendant with diamond granulation
18K Classic Pearl Pendant with diamond granulation
$850
Item 18K Athena Owl Pendant with diamond pavé
18K Athena Owl Pendant with diamond pavé
$3,500
Item 18K Capricorn Zodiac pendant with diamond
18K Capricorn Zodiac pendant with diamond
$1,850
web exclusive
Item 18K Virgo Zodiac pendant with diamond
18K Virgo Zodiac pendant with diamond
$1,850
web exclusive
Item 18K Sea Star Pendant with tanzanite and diamond
18K Sea Star Pendant
$3,750
Item 18K Braided Heart Pendant with rock crystal and diamond - 10mm
18K Braided Heart Pendant with heart rock crystal and diamond granulation
$750 - $1,900
More sizes available
Item 18K Small Sorcerer Locket with diamond
18K Small Sorcerer Locket with diamond
$2,950
Item 18K Horseshoe Pendant with blue sapphire and diamond
18K Horseshoe Pendant
$1,500
Item 18K Libra Zodiac pendant with diamond
18K Libra Zodiac pendant with diamond
$1,850
web exclusive
Item 18K Tree of Life Locket withdiamond
18K Tree of Life Locket withdiamond
$6,950
Item 18K Aries Zodiac pendant with diamond
18K Aries Zodiac pendant with diamond
$1,850
web exclusive
Item 18K Slithering Serpent Pendant with diamond pavé
18K Slithering Serpent Pendant with diamond pavé
$3,950
Item 18K Scorpio Zodiac pendant with diamond
18K Scorpio Zodiac pendant with diamond
$1,850
web exclusive
Item 18K Buddha Pendant with emerald and diamond
18K Buddha Pendant with emerald and diamond
$23,000
Item 18K Gemini Zodiac pendant with diamond
18K Gemini Zodiac pendant with diamond
$1,850
web exclusive
Item 18K Fiori Cross Pendant with diamond
18K Fiori Cross Pendant with diamond
$2,300
Item 18K Classic Cross Pendant with blue sapphire
18K Classic Cross Pendant
$1,050
Item 18K Pisces Zodiac pendant with diamond
18K Pisces Zodiac pendant with diamond
$1,850
web exclusive


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
Subscribe: