Les Pommettes
Les Pommettes
Les Pommettes
Robindira Unsworth Amazonite Tassel Necklace$185.00
31 Bits Entertainer Necklace in Cream$42.00
Jen's Pirate Booty Embroidered Mini Dress$255.00
Blue Embroidered Floral Cream Dress$265.00
Fresh Laundry Navy Stripe Tee$65.00
Stark X Keylime Maxi Dress$145.00
The Jetset Diaries White Shorts$189.00
Monrow Ribbed Grey Tank$50.00
Fresh Laundry Neon Stripe Tee$65.00
Jen's Pirate Booty Tesoro Maxi Skirt$275.00
Cleobella Sophie Embroidered Bed Jacket$294.00
Lena Bernard Chain Fringe Necklace$88.00
Tularosa Ruffle Sleeve Dress$185.00
Tularosa Dixie Dress$260.00
Monrow Ribbed White Tank$50.00
Jen's Pirate Booty El Corazon Maxi Dress$209.00
The Jetset Diaries Forever Skater Dress with Frill$289.00
Robindira Unsworth Labradorite Tassel Necklace$185.00
Robindira Unsworth Blue Quartz Necklace$290.00
Flynn Skye Patty Flare Pant in Purple Punch$143.00
Flynn Skye Stevie Kimono in Day Breeze$148.00
Monrow Basic Crew Tee in White$60.00
Stark X V Neck Linen Dress$235.00
31 Bits Multi Turquoise Necklace$46.00
Stark X Silky Cross Back Dress$135.00
The Jetset Diaries Crop Top$199.00
Faithfull The Brand Garden State Dress in Blue$135.00
Monrow V Neck Swing Tee in White$60.00
Tai Periwinkle Triple Strand Bracelet$100.00
31 Bits Grey Striped Gold Bracelet$36.00
Ace & Jig Voyage Top in Sundial$190.00
David Aubrey Leaf Pendant Necklace$145.00
Lena Bernard Amethyst Earrings$100.00
Faithfull The Brand Woodstock Playsuit in Blue$140.00
Tai Teal Pom Pom Necklace$90.00
Jens Pirate Booty Lace Crop Top$143.00
Faithfull The Brand Woodstock Playsuit in Boheme$140.00
Faithfull The Brand Garden State Dress in Boheme$135.00
Stark X Blue Striped Tee$115.00
Lulu Turquoise Rectangle Charm Necklace$295.00
Stella Forest Metallic Dot Blush Top$225.00
Tai Aqua Agate Double Strand Bracelet$85.00
Tai Peach Agate Double Strand Bracelet$90.00
Tularosa Kennedy Dress$186.00
Lena Bernard Turquoise Loop Earrings$85.00
Tai Green Pom Pom Necklace$90.00
Mickey Lynn Crest Layering Necklace$315.00
Tularosa Annabel Top$134.00
Stella Forest Block Print Tunic$295.00
Heather Kahn Agate Scoop Necklace$195.00
Tai Mustard Striped Bracelet$55.00
Stella Forest Pink Tassel Tunic$285.00
Tai Sliced Yellow Bead Bracelet$145.00
Tai Gunmetal Double Strand Charm Bracelet$110.00
Stella Forest Blue Speckled Dress$265.00
Stella Forest Gold Sequin Maxi Dress$545.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