Les Pommettes
Les Pommettes
Ace & Jig Shore Dress$290.00
Ace & Jig Meadow Dress in Lattice$325.00
Ace & Jig Maya Dress in Chord$340.00
The Jetset Diaries Short Lived Dress in Peach$169.00
Mes Demoiselles Antique Dress$290.00
Gat Rimon Kanye Dress$225.00
Mes Demoiselles Bolivia Dress in Mixed Berry$385.00
Ace & Jig Spirit Dress in Mist$350.00
Mes Demoiselles Dara Dress in Apricot$365.00
Loup Sea Dress in Lavender$155.00
By Timo Aqua Embroidered Maxi Dress$315.00
Cleobella Zia Dress in Black$230.00
Mes Demoiselles Bolivia Dress in Ochre$385.00
Mes Demoiselles Divine Dress in Black$485.00
Mes Demoiselles Alma Dress$365.00
Mes Demoiselles Iowa Tunic$235.00
Mes Demoiselles Nymph Dress in Black$365.00
Mes Demoiselles Sage Dress$245.00
Mes Demoiselles Nymph Dress in Ruby$365.00
Mes Demoiselles Tattoo Tunic$400.00
Mes Demoiselles Eveil Tunic$170.00
Mes Demoiselles Nymph Dress in Poudre$365.00
Mes Demoiselles Elixir Dress$280.00
Gat Rimon Ludmi Stripe Dress$275.00
Mes Demoiselles Marouette Dress$255.00
Gat Rimon Yvanp Palm Tree T-Shirt Dress$225.00
Humanoid Cement Dress in Steel$310.00
Gat Rimon Tina Dress in Blue$260.00
Humanoid Brand Maxi Dress in Peach Stripe$325.00
Humanoid Silk Sweets Maxi Dress$495.00
Gat Rimon Tina Dress in Violet$260.00
Loup CoCo Dress in Black$150.00
Mes Demoiselles Antonia Dress in Black$200.00
Humanoid Neut Striped Jersey Split Dress$275.00
Humanoid Dye Tank Dress in Chocolate$115.00
Humanoid Jersey Split Dress in Nude$215.00
Humanoid Black Dot Shirt Dress$345.00
Gat Rimon Tina Dress in Ecru$260.00
Wilt Raw Slit Dress in Grey$160.00
Ace & Jig Still Water Dress in Zodiac$345.00
Humanoid Schelp Solid Silk Dress in Sweets$395.00
Flynn Skye Kennedy Mini Dress$161.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 = '34') and products_sort.cPath = '34' GROUP BY p.products_id order by products_sort.sortBy ASC