Les Pommettes
Les Pommettes
Les Pommettes
Decolette Smokey Quartz Braceletwas: $50.00 now: $35.00
Tai Spike Rhinestone Bangle$80.00
Tai Navy Vintage Bead Bracelet with CZ Beadswas: $370.00 now: $235.00
Evil Eye Braceletwas: $15.00 now: $10.00
Circle Cuffwas: $40.00 now: $30.00
Tai Big Infinity Bracelet in Black/Goldwas: $100.00 now: $75.00
Tai Large Teardrop Bracelet in Clear$100.00
Tai Blue Crystal Bangle$100.00
Tai Braided Cord Bracelet with Starflower Pave Emblem in Clear$110.00
Serefina Bells and Tassels Bracelet in Silver$30.00
Tai Agate & Pave Bead Bracelet$80.00
Margaret Elizabeth Labradorite Teardrop Bangle$88.00
A. V. Max Tall Bangle in Goldwas: $40.00 now: $30.00
Tai Love Braceletwas: $75.00 now: $45.00
Melanie Auld Pave Bangle in Rose Gold$85.00
Tai Pale Pink Multi Strand Bracelet$145.00
Bar Cuffwas: $55.00 now: $30.00
Tai Pave Heart Bracelet$75.00
Melinda Maria Tatum Bracelet$148.00
A. V. Max Tall Dome Bangle in Matte Goldwas: $35.00 now: $25.00
Julie Vos Versailles Scalloped Bangle$48.00
Melinda Maria Geometric Shaped Banglewas: $195.00 now: $90.00
Laurel Hill Crescent Totem Cuffwas: $70.00 now: $50.00
Rhinestone Detail Cuffwas: $45.00 now: $30.00
Tai Oxidized Silver Tube Bracelet in Black$145.00
Leaf Cuffwas: $40.00 now: $30.00
Wanderlust + Co Art Deco Starburst Gem Braceletwas: $45.00 now: $25.00
A. V. Max Tapered Cuff in Goldwas: $25.00 now: $15.00
Tai Large Gem Bracelet in Brown/Green$100.00
Tai Amazonite Beaded Bracelet with Gold/Silver and CZ$130.00
Brass Turquoise Banglewas: $215.00 now: $95.00
Laurel Hill Temple Cuffwas: $74.00 now: $50.00
Tai Snake Hinge Bracelet$150.00
Tai Black Evil Eye Beaded Bracelet$65.00
Tai Pale Green Rhinestone Bracelet$90.00
Species By The Thousands Bone Cuffwas: $70.00 now: $35.00
Tai Blue Rhinestone Bracelet$90.00
Melanie Auld Rose Gold Pave Bangle in White$85.00
Tai Aqua Crystal Hamsa Bracelet$85.00
Pearl Bangle$45.00
Tai Mixed Agate Bracelet$65.00
Tai Black and Straw Woven Bracelet with CZ Barwas: $115.00 now: $80.00
Tai Grey Hamsa Bead Bracelet$55.00
Green Amethyst Banglewas: $75.00 now: $35.00
31 Bits Ivory Bracelet$14.00
A. V. Max Tapered Cuff in Silverwas: $25.00 now: $15.00
Margaret Elizabeth Rimini Bangle$122.00
Shashi Red, White & Blue Braceletwas: $45.00 now: $23.00
Shashi Spinial Wrap Braceletwas: $64.00 now: $50.00
Shashi Spike Bracelet in Gunmetalwas: $85.00 now: $25.00
Freida & Nellie Topaz Braceletwas: $275.00 now: $45.00
Wrap Turquoise Bracelet/Necklacewas: $45.00 now: $10.00

select distinct p.products_image, pd.products_name, p.products_image, pd.products_name, p.products_id, p.products_sort, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from products_description pd, products_sort, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join specials s on p.products_id = s.products_id, products_to_categories p2c where (p.products_status = 1) and p2c.categories_id != 70 and p.products_id = p2c.products_id and products_sort.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and (p2c.categories_id = '23') and products_sort.cPath = '23' GROUP BY p.products_id order by products_sort.sortBy ASC