Shopping Bag

0 Items

Please add a product to your shopping bag in order to checkout.

Free US Standard Shipping Over $50!

Total $0.00

Excl. Shipping & Taxes

My Promo Codes

Available Promo Codes: 0

No promo codes are available.

Free US Standard Shipping Over $50!

In-Salon Treatments

SELECT a.*, as opt_id, b.opt_value, b.opt_price, b.opt_price_value, b.opt_discount, b.travel_size, b.value_size, b.best_seller, b.new_arrival, b.featured_img as opt_featured_img, b.opt_stock_qty, 5 as catId, 'in-salon-treatments' as catSlug, 'In-Salon Treatments' as catTitle FROM lakme_product a, lakme_product_options b, lakme_product_category c WHERE a.status='active' AND b.status='active' AND c.status='active' AND AND FIND_IN_SET(,a.pdt_category) AND c.remove_link<>1 AND find_in_set('5', a.pdt_category) AND b.opt_default=1 GROUP BY ORDER BY a.sort_order ASC, a.title ASC

0 items on list

Explore our products or search for an item you’d like to add.