Les Pommettes
Les Pommettes
Les Pommettes
Mes Demoiselles Kashmir Dress$395.00
Tai Amethyst Hexagon and Pave Bracelet$125.00
Mes Demoiselles Loretta Cardigan in Pink$415.00
Mes Demoiselles North Sweater in Ivory$285.00
Tai Blue Rhinestone Bracelet$90.00
Mes Demoiselles Duche Vest in Navy$355.00
Humanoid Native Print Dress in Mushroom$420.00
Melinda Maria Cece Pave Earrings$68.00
Mes Demoiselles Hermione Camisole in Nude$165.00
Tai Rhinestone and Pave Bracelet$100.00
Mes Demoiselles Style Dress in Gold$485.00
Melanie Auld Trillion Stacking Ring$69.00
Mes Demoiselles Macleod Blouse in Black$225.00
Tai Snake Hinge Bracelet$150.00
Mes Demoiselles Hermione Camisole in Black$165.00
Tai Peach Rhinestone Bracelet$90.00
Mes Demoiselles Poncho in Pink$215.00
Tai Pave Heart Bracelet$75.00
Asilio White Walls Lace Crop Top in Black$175.00
Asilio Back With A Vengeance Dress$305.00
Gat Rimon Jalie Dress in Black$455.00
Mes Demoiselles Mackenzie Tunic in Brick$275.00
Gemelli Olivia Ring in Labradorite$115.00
Mes Demoiselles Kastel Skirt$235.00
Melinda Maria Tatum Bracelet$148.00
Mes Demoiselles Hermione Dress in Nude$295.00
Melinda Maria Graham Stone Ring$128.00
Mes Demoiselles Maima Cardigan$455.00
Melanie Auld Pave Bangle in Rose Gold$85.00
Mes Demoiselles Strass Sequin Jacket in Gold$495.00
Mes Demoiselles Magic Sweater in Black$345.00
Lacausa Tank Top in Grey$59.00
Stylestalker Elena Lace Shorts$105.00
Mes Demoiselles Valse Skirt in Ecru$315.00
Stark X Silk Back Tunic in Ivory$145.00
Melinda Maria Kennedy Pave Studs$128.00
Humanoid Eagle Cardigan in Snow$435.00
Les Pommettes Beaded Kaftan in Black$525.00
Tai Amethyst Rhinestone and Pave Bracelet$100.00
Mes Demoiselles Vision Top$275.00
Mes Demoiselles Vision Dress in Gold$425.00
Native Gem Titan Ring in Gold$110.00
Mes Demoiselles Lloyd Cardigan$315.00
Line & Dot Francoise Embroidered Maxi in French Blue$255.00
Kain Slouch Pocket Tank in Grey$90.00
Stylestalker Floral Pant$145.00
Cami NYC Harper Tank Top in Black$148.00
Melanie Auld Pave Deep V Ring$90.00
Stark X Linen Crew Dress in Black$215.00
Stark X Linen Crew Dress in White$215.00
Tai Moon and Star Necklace in Gold$85.00
Kain Tulip Back T-Shirt in White$145.00
Les Pommettes Kaftan in Aqua$525.00
Robindira Unsworth Blue Quartz Necklace$290.00
Ace & Jig Plaid Stripe Jacket in Blue$355.00
Stylestalker Charline Romper in Black$145.00
Melanie Auld Pave Elongated Stacking Ring in Gold$69.00
Line & Dot Floral Lace Top in Black$135.00
Les Pommettes Beaded Kaftan in Pink$525.00
Melinda Maria Marnie Necklace$128.00
Mes Demoiselles Hermione Dress in Wine$295.00
Kain Silk Slouchy Pocket Tee in Navy$95.00
Stylestalker Floral Slip Dress$145.00
The Jetset Diaries Blue Maxi Dress$385.00
Kain Textured Long Sleeve Top in White$165.00
Stark X Gauze Cami in Cream$100.00
Gemelli Pave Diamond Arrow Necklace$95.00
Lacausa Tank Dress in Heather Grey$80.00
Melinda Maria Moon & Stars Necklace$58.00
Tai Pale Green Rhinestone Bracelet$90.00
Ace & Jig Stripe Top in Navy$195.00
Tai Hexagon Crystal Open Bracelet$90.00
Melinda Maria Pyramid Necklace$148.00
Mes Demoiselles Alpha Sweater in Ivory$245.00
Lena Bernard Amethyst Earrings$100.00
Tai Rhinestone Triangle Necklace in Gold$85.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