Les Pommettes
Les Pommettes
Foley & Keane Kimono in Blue Floral$195.00
Cleobella Zia Dress in Black$230.00
Humanoid Cement Dress in Steel$310.00
Les Pommettes Sapphire Triple Drop Earrings$325.00
Humanoid Schelp Solid Silk Dress in Sweets$395.00
Les Pommettes Gold Triangle Collar Necklace$215.00
Foley & Keane Aztec Kimono$195.00
Les Pommettes Large Bead Tassel Necklace in Black$55.00
Humanoid Dia Gaucho Pant in Ink$225.00
Les Pommettes Purple Amethyst Bangle$75.00
Flynn Skye RaRa Skirt in White Gatsby$167.00
Flynn Skye Tie Me Up Top$114.00
Les Pommettes Triple Chandelier Earrings$85.00
Foley & Keane Kimono in Green Floral$195.00
Les Pommettes Silver Navajo Tear Necklace$245.00
Flynn Skye Stevie Kimono in Stardust$160.00
Humanoid Dye Tank Dress in Chocolate$115.00
Les Pommettes Square Necklace$75.00
Wilt Uneven Hem Long Sleeve Dress in Mouse$185.00
Humanoid Black Dot Shirt Dress$345.00
Les Pommettes Evil Eye Necklace$75.00
Les Pommettes Victorian Lace Necklace$215.00
Cleobella Roxa Kimono in Black$380.00
Les Pommettes Seed Bead Tassel Necklace$75.00
Flynn Skye Scoop Back Maxi$165.00
Humanoid Jersey Keyhole Top in Nude$140.00
Les Pommettes Labradorite Bangle$75.00
Humanoid Jersey Split Dress in Nude$215.00
Cleobella Karma Kimono in Black$325.00
Wilt Shrunken Boyfriend Dress in Black$145.00
Les Pommettes Triple Teardrop Earrings$325.00
Flynn Skye Ready Romper$150.00
Wilt Asymmetric Raglan in Papaya$130.00
Les Pommettes Tassel Necklace in Salmon Pink$45.00
Spell & The Gypsy Collective Sundancer Kimono in Blush$225.00
Humanoid Cold Dye Muscle Tank in Light Grey$90.00
Les Pommettes Gold Collar Necklace$245.00
Flynn Skye Kennedy Mini Dress$161.00
Humanoid Silk Sweets Maxi Dress$495.00
Humanoid Jersey Keyhole Top In Pebble$140.00
Les Pommettes Antique Brass Tribal Coin Necklace$225.00
Flynn Skye RaRa Skirt in Navy Bouquet$167.00
Flynn Skye Anastasia Maxi Dress$191.00
Les Pommettes Green Amethyst Bangle$75.00
Flynn Skye Elle Mini Dress$180.00
Les Pommettes Buddha Gemstone Necklace with Tassel$75.00
Cleobella Raja Dress in Black$290.00
Les Pommettes Metallic Bead Tassel Necklace in Navy$55.00
Les Pommettes Brass Large Bead Necklace$45.00
Cleobella Karma Kimono in Cream$325.00
Les Pommettes Geometric Labradorite Link Necklace$325.00
Spell & The Gypsy Collective Boho Blossom Maxi Dress$300.00
Les Pommettes Mixed Bead Tassel Necklace in Slate Gray$55.00
Flynn Skye Bardot Maxi Dress in Desert Stripe$184.00
Flynn Skye Bardot Maxi Dress in Black Bouquet$184.00
Les Pommettes Lariat Rhinestone Necklace$145.00
Les Pommettes Gold Tribal Ring Necklace$195.00
Les Pommettes Mixed Bead Navajo Necklace$65.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