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


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: