Les Pommettes
Les Pommettes
Les Pommettes
Flynn Skye I Love You Top in Orange Burst$124.00
Stella Forest Metallic Dot Blush Top$225.00
Jens Pirate Booty Embroidered Kaftan$264.00
Blue Short Sleeve Diamond Dress$225.00
Lena Bernard Triple Labradorite Earrings$195.00
Stella Forest Mint Maxi Dress$285.00
Tai Agate & Pave Bead Bracelet$80.00
Stella Forest Black Lace Maxi Dress$435.00
Lena Bernard Tourmaline Necklace$185.00
Species By The Thousands Sun Spike Earrings$80.00
Ace & Jig Maya Dress in Chord$340.00
Lena Bernard Round Labradorite Earrings$145.00
Tai Periwinkle Triple Strand Bracelet$100.00
Stella Forest Blue Speckled Dress$265.00
Tai Celestial Bracelet$85.00
Lena Bernard Green Fan Fringe Earrings$50.00
Tularosa Kennedy Dress$186.00
Tai Turquoise Long Necklace$95.00
Blue Amethyst Embroidered Tunic$175.00
Flynn Skye Unbutton Me Skirt in Hot Tamale$168.00
FLynn Skye I Am Lolita Dress in Mauve Madness$149.00
Blue Gold Stamped Maxi Dress$275.00
Melinda Maria Round Pavé Ring$148.00
Ace & Jig Village Tank in Isle$160.00
Tai Nude Triple Strand Bracelet$100.00
31 Bits Gold Metallic Necklace$42.00
Heather Kahn Tooth Spike Necklace$195.00
Jen's Pirate Booty Embroidered Mini Dress$255.00
Tai Metallic Gold Cord Bracelet$55.00
Lena Bernard Amethyst Earrings$145.00
Lena Bernard Crescent Lapis Blue Fringe Necklace$70.00
31 Bits Triple Layered Gold Necklace$50.00
Ace & Jig Hattaras Top in Chord$240.00
Heather Kahn Brass Plate Necklace$225.00
Lena Bernard Striped Loop Fringe Earrings$65.00
Blue Emerald Bohemian Skirt$85.00
31 Bits Double Layered Turquoise Necklace$46.00
31 Bits Grey Striped Gold Bracelet$36.00
Jen's Pirate Booty El Corazon Maxi Dress$209.00
Lena Bernard Chain Fringe Necklace$295.00
Blue Floral Embroidered Blouse$165.00
Tai Striped Bracelet$50.00
Blue Indigo Lace Top Dress$275.00
Heather Kahn Kyanite Pendant Necklace$215.00
Flynn Skye Festival Romper in Starlight$150.00
Lena Bernard Wood Fringe Necklace$215.00
Flynn Skye Patty Flare Pant in Purple Punch$143.00
Melinda Maria Elephant Charm Necklace$68.00
Stella Forest Block Print Tunic$295.00
Lena Bernard Double Crescent Labradorite Necklace$175.00
Stella Forest Gold Sequin Maxi Dress$545.00
Blue Embroidered Floral Cream Dress$265.00
31 Bits Entertainer Necklace in Cream$42.00
Ace & Jig Voyage Top in Sundial$190.00
Heather Kahn Agate Scoop Necklace$195.00
Stella Forest Pink Tassel Tunic$285.00
Jen's Pirate Booty Tesoro Maxi Skirt$275.00
31 Bits Multi Turquoise Necklace$46.00
Lena Bernard Turquoise Fringe Necklace$65.00
Tularosa Payton Dress in White$168.00
31 Bits Mint Long Necklace$42.00
Ace & Jig Coastline Pants in Market$215.00
31 Bits Ivory Bracelet$14.00
Ace & Jig Racer Tank in Punch$165.00
31 Bits Grey Striped Necklace$44.00
Blue Button Back Blouse in Cream$185.00
Heather Kahn Crystal Necklace$165.00
Jens Pirate Booty Lace Crop Top$143.00
Stella Forest White Lace Tunic$265.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