(02) 9522-9095
Login
|
Sign Up
|
Wishlist
|
Cart
Menu
Toggle navigation
Home
About
About Us
Testimonials
Trade
Catalogues
Jewellery Insurance
Finance Options
Events
Contact Us
Shop
Rings
Mens Jewellery
Pendants
Necklets
Bangles
Bracelets
Baby and Childrens Jewellery
Anklets
Earrings
Chains
Charm
Body Jewellery
Pearl Jewellery
Opal Jewellery
Watches
Jewellery Cleaning Products
Keyrings
Cufflinks
Shop All
Shop
Rings
Gents Jewellery Mens Jewellery
Pendants
Necklets
Bangles
Bracelets
Baby and Childrens Jewellery
Anklets
Earrings
Chains
Charm
Body Jewellery
Pearl Jewellery
Opal Jewellery
Watches
Jewellery Cleaning Products
Keyrings
Cufflinks
Shop All
Argyle
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
Q Report
ZipPay
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!
×
Item Successfully Added to Cart
Copyright ©2021 Pontifex Jewellers |
Terms & Conditions
12073073