Les Pommettes
Les Pommettes
Spell & The Gypsy Collective Wild Ones Gown$360.00
Lionette Jeweled Headpiece$710.00
Les Pommettes Chevron Cape$85.00
Les Pommettes Medallion Necklace$195.00
Spell & The Gypsy Collective Desert Rose Kimono$185.00
Les Pommettes Sunnies in Pink$55.00
Lionette TLV Earrings in Pink$248.00
Stark X Snap Dress with Pocket in Navy$160.00
Les Pommettes Blue Leopard Clutch$125.00
Stark X Snap Dress with Pocket in Cream$160.00
Les Pommettes Jeweled Flower Necklace$215.00
Les Pommettes Open Knit Scarf in Cream$45.00
Spell & The Gypsy Collective Desert Rose Skirt in Raven$160.00
Les Pommettes Gold Tassel Necklace$215.00
Les Pommettes Persimmon Fringe Wrap$85.00
Ramy Brook Willow Chain Sweater in Grey$325.00
Les Pommettes Chain Bangle$65.00
Spell & The Gypsy Collective Wild Ones Midi$350.00
Les Pommettes Floral Sunnies in Blue$55.00
Stark X Two Tone Linen Tank Top in Navy and Black$95.00
Margaret O' Leary Aran Island Coat$395.00
Les Pommettes Tribal Clutch$85.00
Spell & The Gypsy Collective Boho Desert Rose Dress$210.00
Les Pommettes Red, White & Blue Necklace$145.00
Lulu Aquamarine Ring$185.00
Tambourine Port Dress$215.00
Lionette Dana Necklace in Earth$178.00
Stark X Two Tone Tank in Cream$85.00
Les Pommettes Rhinestone Drop Tassel Necklace$75.00
Les Pommettes Crochet Metallic Cardigan$145.00
Lionette Lilu Black & White Earrings$98.00
Nili Lotan Oversize V-Neck Raglan$440.00
Lionette Yaeli Necklace$160.00
Spell & The Gypsy Collective Lovers Forever Tee$96.00
Nicole Meng Starburst Earrings$120.00
Les Pommettes Pink Rope Clutch$65.00
Stark X Asymmetrical Linen Tee in Purple$105.00
Lionette Alexandria Necklace$535.00
Flynn Skye Perfect Pant in Floral$155.00
Ramy Brook Willow Chain Sweater in Ivory$325.00
Serefina Rhinestone Drop Collar$105.00
Stark X Linen Tank in White$75.00
Margaret O'Leary Chunky Cable Knit Pullover in Blush$495.00
Nicole Meng Parallel Lines Ring$100.00
Flynn Skye Perfect Pant in Burgundy$155.00
Les Pommettes Taupe Fringe Wrap$75.00
Stark X Asymmetrical Linen Tee in Cream$105.00
Serefina Tassle Pendant Necklace in Mustard$115.00
Tai Braided Grey Cord Bracelet With Green Stone$100.00
Ramy Brook Raven Maxi Cardigan in Grey$475.00
Tai Gray Braided Bracelet with Grey Druzy$110.00
Les Pommettes Scarf in Blush$65.00
Nicole Meng Architecture Earrings in Pink$85.00
Margaret O'Leary Slouch Sweater in Nude$330.00
Les Pommettes Iridescent Spike Necklace$85.00
Rhode Resort Sequin Kaftan in Tan$555.00
Lulu Milky Aquamarine Ring$185.00
Nicole Meng Spire Ring$70.00
Margaret O' Leary St. Moritz Cashmere Open Sweater$595.00
Nicole Meng Segment Necklace$65.00
Lionette Mio Necklace$488.00
Rhode Resort Sequin Kaftan in Fuschia$555.00
Nicole Meng Architecture Ring$50.00
Tai Braided Grey Cord Bracelet With Peach Stone$100.00
Les Pommettes Mustard Lace Knit Scarf$45.00
Serefina Simple Drop Chain$80.00
Tai Big Infinity Bracelet in Black/Gold$100.00
Les Pommettes Navajo Cape$85.00
Tai Black Facet Open Bracelet$100.00
Lionette Koti Necklace in Yellow$188.00
Les Pommettes Pullover Cape$145.00
Lionette Koti Necklace in White$188.00
Serefina Crystal Layered Necklace$140.00
Margaret O'Leary Gamer Coat$215.00
Tai Braided Beige Cord Bracelet With Peach Stone$100.00
Serefina Electric Blue African Necklace$105.00
Nicole Meng Horseshoe Ring$90.00
Lionette Gizelle Necklace$388.00
Tai Evil Eve Open Bracelet with Green$80.00
Serefina Tassle Pendant Necklace in White$115.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 = '29') and products_sort.cPath = '29' GROUP BY p.products_id order by products_sort.sortBy ASC