25 years in service close to half a million orders filled. Contact Us E-Mail Us  |  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.





Departments
Face Care
Make-up
Body Care
Hair Care
Tools
Sun Care
Supplements
For Men

Skin Types
Normal
Dry
Oily
Combination
Sensitive
Normal to Oily
Dry to Normal
All

Ingredients





Weekly Deals Favourites Specials
on our Forum    


Specials

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

[TEP STOP]