INVALID SQL: 0 :
SQL QUERY FAILURE: SELECT COUNT(xcart_products.productid), MIN(xcart_pricing.price) as price , xcart_products_lng.product as product_lng, xcart_products_lng.descr as descr_lng, xcart_products_lng.full_descr as fulldescr_lng, IF(xcart_variants.variantid IS NOT NULL,'Y','') as is_variant, IF(xcart_classes.classid IS NOT NULL,'Y','') as is_product_options, MIN(v_pricing.price) as v_price FROM xcart_products, xcart_pricing , xcart_featured_products, xcart_products_categories, xcart_categories LEFT JOIN xcart_products_lng ON xcart_products_lng.productid = xcart_products.productid AND xcart_products_lng.code = 'US' LEFT JOIN xcart_classes ON xcart_classes.productid = xcart_products.productid LEFT JOIN xcart_variants ON xcart_variants.productid = xcart_products.productid LEFT JOIN xcart_pricing as v_pricing ON v_pricing.variantid = xcart_variants.variantid AND v_pricing.quantity = 1 AND v_pricing.membership IN ('','') WHERE xcart_products.productid=xcart_featured_products.productid AND xcart_featured_products.avail='Y' AND xcart_featured_products.manufacturerid='56' AND xcart_pricing.productid=xcart_products.productid AND xcart_pricing.quantity=1 AND xcart_pricing.membership IN ('','') AND xcart_products.product_type <> 'C' AND xcart_products.product_type <> 'B' AND xcart_pricing.variantid = 0 AND xcart_products_categories.productid=xcart_products.productid AND xcart_products_categories.categoryid = xcart_categories.categoryid AND xcart_categories.membership IN ('','') AND xcart_categories.avail = 'Y' AND xcart_products.forsale='Y' GROUP BY xcart_products.productid
INVALID SQL: 0 :
SQL QUERY FAILURE: SELECT COUNT(xcart_products.productid), MIN(xcart_pricing.price) as price , xcart_products_lng.product as product_lng, xcart_products_lng.descr as descr_lng, xcart_products_lng.full_descr as fulldescr_lng, IF(xcart_variants.variantid IS NOT NULL,'Y','') as is_variant, IF(xcart_classes.classid IS NOT NULL,'Y','') as is_product_options, MIN(v_pricing.price) as v_price FROM xcart_products, xcart_pricing , xcart_products_categories, xcart_categories LEFT JOIN xcart_products_lng ON xcart_products_lng.productid = xcart_products.productid AND xcart_products_lng.code = 'US' LEFT JOIN xcart_classes ON xcart_classes.productid = xcart_products.productid LEFT JOIN xcart_variants ON xcart_variants.productid = xcart_products.productid LEFT JOIN xcart_pricing as v_pricing ON v_pricing.variantid = xcart_variants.variantid AND v_pricing.quantity = 1 AND v_pricing.membership IN ('','') WHERE xcart_pricing.productid=xcart_products.productid AND xcart_pricing.quantity=1 AND xcart_pricing.membership IN ('','') AND xcart_products.product_type <> 'C' AND xcart_products.product_type <> 'B' AND xcart_pricing.variantid = 0 AND xcart_products.manufacturerid IN ('56') AND xcart_products_categories.productid=xcart_products.productid AND xcart_products_categories.categoryid = xcart_categories.categoryid AND xcart_categories.membership IN ('','') AND xcart_categories.avail = 'Y' AND xcart_products.forsale='Y' GROUP BY xcart_products.productid
4VOO :: Skin Care Products :: Luxury Skin Shop
Skin Care Products :: Luxury Skin Shop
FREE Shipping on all Skin Care Products

3 Step Skin Search

Shopping Cart
Cart is empty

View cart | Checkout
  VIP Login About Us Contact Us Gift Registry
Brands | Product Type | Skin Condition | Skin Type
Skin Care Manufacture Products
Luxury Skin Shop  |  4VOO  |  4VOO Skin Care Products
 
Skin Care Products :: Brands
 Featured Brands:
 Ahava
 Barielle
 Donell
 Dremu
 Jaqua
 Jenju
 Kinara
 Moom
 Protective Nourishment
 SkinMedica

 See all Brand Names »

Skin Care Products :: Product Type
 Acne Products
 Bath Soaks/Salts
 Body Moisturizer
 Eye Creams/Gel
 Face Cream
 Facial Cleansers
 Facial Moisturizers
 Facial Toners
 Shower Gel/Body Wash
 Wrinkle Products

 See all Product Types »

Skin Care Products :: Skin Condition
 Acne
 Dry Skin
 Rosacea
 Sun Damage
 Wrinkles

 See all Skin Conditions »

Skin Care Products :: Skin Type
 Adolescent/Teens
 Combination
 Dry
 Flush
 Mature
 Men's
 Normal
 Oily
 Sensitive

 See all Skin Types »

Skin Care Products :: Special Offers
Gift certificates

Luxury Skin Shop :: VIP Profile
VIP Login
Register
Recover password

If Javascript is disabled in your browser click here.

Luxury Skin Shop :: Customer Care
Password Recovery
Shipping Fees
Delivery Speed
Privacy Policy
Return Policy
Contact Us



 
Starter Set by 4VOO
Luxury Skin Shop presents:
Starter Set by 4VOO

4VOO

4VOO (pronounced 'for vous') is an innovative skin care company offering enhancement of appearance and confidence for men. Its Distinct Man™ product line is specifically formulated for a man who is not afraid to be sexy, have fun or appreciates luxury. It's for the man who understands that his grooming, and appearance are vital to his professional and personal success.

Distinct Man™ offers four levels of men's skin care to address the specific needs of a man: shaving, skin care, cosmetic correction and enhancement and pleasure. It's been meticulously designed to meet the increasing demands of today's lifestyle and can be thrown into a gym bag or business case. 4VOO skin care products are as sexy as the man that uses them, the ultimate solution for today's distinct man.

The most beneficial and effective active ingredients available have been combined with pure botanical extracts, essential oils, and vitamins to work in synergy with a man's skin to provide optimum visible results. 4VOO men's skin care & cosmetics have been formulated to put a little beauty back into the beast. No more dark circles under the eyes, or skin irritation after shaving!

A distinct man will enjoy being reminded just how special he is each time he uses 4V00 products in his skin care and grooming regimen.

Learn More about 4VOO! »


Skin Care Featured Products
There are currently no available products available by this manufacturer.

 
 

Privacy Policy | Return Policy | Shipping Fees | Terms & Conditions | Contact Us | Site Map
Copyright © 2005-2010 Luxury Skin Shop / iTrade eCommerce, LLC  
LuxurySkinShop appreciates your business, but we will be off-line until further notice as we upgrade our inventory tracking system. Any order that has been submitted up to this date will be honored and fufilled. If there is a stock delay, then you will be notified and will receive a full refund with our apology and gift. We apologize for this inconvenience, and we shall return better, faster, and well stocked.
Hide