Free Gifts with purchase of your favourite brands. Contact Us 1 888 295 6802  |  Log-in or Register Log-in or Register
Shop with us!!! We sell the most advanced skin care anti-aging cosmetics on the market: cellex-c, phytomer, sothys, dermalogica, md formulations, decleor, valmont, kinerase, yonka, jane iredale, thalgo, yon-ka, ahava, bioelements, jan marini, peter thomas roth, murad, ddf, orlane, glominerals, StriVectin SD.

Face Care
Body Care
Hair Care
Sun Care
For Men

Skin Types
Normal to Oily
Dry to Normal


Weekly Deals Specials on our Forum


Take some time to look over these incredible savings. Buy promotional sets or our duo combinations is a great savings over buying products individually. Also make sure to click here to check out our other sale items!

List View   Grid View   Text View

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') order by p.products_order, ' at line 26

select distinctrow p.products_id, p.*, pd.*, m.restriction_zones, m.restriction_allowed, m.restriction_cart, m.restriction_strict, m.restriction_currency, IF(p.products_hide_on_zero, IF(p.products_quantity > 0, 'TRUE', 'FALSE'), 'TRUE') as show_product, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price_us, NULL) as specials_new_products_price_us, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from products p left join products_description pd on p.products_id = pd.products_id left join products_to_categories p2c on p.products_id = p2c.products_id left join specials s on p.products_id = s.products_id left join manufacturers m on m.manufacturers_id = p.manufacturers_id where p.products_status = 1 and p.products_status_message != 'gift' and p.products_status_message != 'discontinued' and p.products_parent_id = 0 and p.products_id = pd.products_id and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and s.status = 1 and p2c.categories_id in () order by p.products_order, pd.products_name, p.products_id