FREE EXPRESS SHIPPING WITHIN AUSTRALIA FOR ALL ORDERS OVER $120*
(02) 9522-9095
Login
|
Sign Up
|
Wishlist
|
Cart
Menu
Toggle navigation
Home
About
About Us
Testimonials
Catalogues
Jewellery Insurance
Finance Options
Events
Contact Us
Shop
Shop All
Amethyst
Aquamarine
Blue Topaz
Citrine
Crystal
Cubic Zirconia
Diamond
Emerald
Garnet
Morganite
None
Onyx
Opal
Pearl
Peridot
Ruby
Sapphire
Smoky Quartz
Tanzanite
Tourmaline
Turquoise
Rings
Crystal
Diamond
None
Onyx
Gents Jewellery Mens Jewellery
Crystal
Cubic Zirconia
Diamond
None
Baby and Childrens Jewellery
Amethyst
Aquamarine
Blue Topaz
Citrine
Crystal
Cubic Zirconia
Diamond
Morganite
None
Pearl
Ruby
Turquoise
Pendants
Amethyst
Aquamarine
Blue Topaz
Citrine
Crystal
Cubic Zirconia
Diamond
Emerald
Morganite
None
Onyx
Pearl
Peridot
Ruby
Sapphire
Smoky Quartz
Tourmaline
Turquoise
Necklets
Citrine
Crystal
Cubic Zirconia
Diamond
None
Onyx
Pearl
Tanzanite
Turquoise
Bracelets
Crystal
Cubic Zirconia
Diamond
None
Bangles
Cubic Zirconia
None
Turquoise
Anklets
Amethyst
Aquamarine
Blue Topaz
Citrine
Crystal
Cubic Zirconia
Diamond
Emerald
Garnet
Morganite
None
Onyx
Pearl
Peridot
Ruby
Sapphire
Tanzanite
Turquoise
Earrings
Citrine
Crystal
Diamond
None
Chains
Crystal
Cubic Zirconia
Diamond
Garnet
None
Pearl
Smoky Quartz
Turquoise
Charm
Aquamarine
Crystal
Cubic Zirconia
Diamond
None
Body Jewellery
Cubic Zirconia
Diamond
None
Pearl
Pearl Jewellery
Crystal
Diamond
None
Opal
Pearl
Opal Jewellery
Crystal
Cubic Zirconia
None
Watches
Diamond
None
Pearl
Jewellery Cleaning Products
Sale
Shop
Shop All
Rings
Gents Jewellery Mens Jewellery
Baby and Childrens Jewellery
Pendants
Necklets
Bracelets
Bangles
Anklets
Earrings
Chains
Charm
Body Jewellery
Pearl Jewellery
Opal Jewellery
Watches
Jewellery Cleaning Products
Sale
Brands
Engagement Rings
Jewellery Facts
Services
FREE Gift Wrapping
Insurance Replacement
FREE Inspection
Lay-by
Gift Cards
Custom Design
Jewellery Remodelling
Pearl Re-threading
Jewellery Repairs
Finance Options
Watch Batteries
7 Year Diamond Guarantee
Valuations
Watch Repairs
ZipPay
Q Report
Blog
Strands
SELECT EdgeMaster.EdgeID,EdgeMaster.StockNum,EdgeMaster.SKU,EdgeMaster.CurrentPrice,EdgeMaster.RetailPrice,EdgeMaster.Images,EdgeMaster.categoryType,EdgeMaster.CategoryID,EdgeMaster.ShortMktngDesc,EdgeMaster.BrandName,EdgeMaster.MCategory,EdgeMaster.SCategory,EdgeDetailsMaster.SCategory,EdgeDetailsMaster.MCategory,EdgeDetailsMaster.MetalColor,EdgeDetailsMaster.MetalType FROM EdgeMaster JOIN EdgeDetailsMaster ON (EdgeMaster.categoryType = EdgeDetailsMaster.EdgeCategoryType and EdgeMaster.StockNum = EdgeDetailsMaster.EdgeStockNum and EdgeMaster.SKU = EdgeDetailsMaster.EdgeSKU) where EdgeMaster.MCategory='Strands' and EdgeMaster.TotalAvailQOH>0 and EdgeMaster.ProdDel not in ('y')
Filter By
Metal Color
Price
to
No products were found under this category!
×
Copyright ©2022 Pontifex Jewellers |
Terms & Conditions
24830582