Discovered in 1736, Avene's thermal spring water has been used to effectively treat serious dermatological conditions such as atopic dermatitis, psoriasis, eczema and burns. Over 150 clinical studies demonstrate the soothing properties of Avene thermal spring water. Its unique composition makes Avene thermal spring water ideally suited for the care and management of sensitive skin. Dermatological hydrotherapy utilizes the therapeutic properties of natural spring water to address a variety of skin disorders. The unique composition of Avene thermal spring water in conjunction with the treatment techniques offered at the Avene Hydrotherapy Center have been proven beneficial in alleviating dermatological conditions including atopic dermatitis, psoriasis, eczema and burns.
This Brand is no longer available on our Candian site but is still available on our US site, please click here to shop through our US store.
0 Products Found
SELECT top 20 * from ( select min(CAID) as idProduct, min(CAprice) as price, max(groupMax) as maxPrice, min(groupMin) as minPrice, max(CAlistprice) as listPrice, min(description) as description, min(prodName) as prodName , min(inventory.CAimageUrl) as imageURL, sum(sold365) as sales, min(prodGroupItems.prodGroupID) as prodGroupID, min(gCount.groupCount) as groupCount, min(prodGroups.divider) as divider, min(prodGroups.name) as groupName, sum(count) as count , avg(avgstars) as avgstars, min(CA_callOrder) as IH_callOrder, min(CA_showPrice) as IH_ShowPrice, min(CA_CAllOrderPrice) as callOrderPrice, min(brands.idbrand) as idbrand, min(brands.brandName) as brandName, min(freezes) as freezes, min(aerosol) as aerosol, min(leaks) as leaks, min(podeclined) as podeclined, max(freeGiftID) as freeGiftID, max(CATreshHold) as treshHold FROM [dbo].[inventory] left join brands on brands.idbrand = inventory.idbrand left join prodGroupItems on prodGroupItems.itemID = inventory.itemID left join prodGroups on prodGroupItems.prodGroupID = prodGroups.prodGroupID left join (select prodGroupId, count(prodGroupID) as groupCount, min(CAprice) as groupMin, max(CAprice) as groupMax from prodGroupItems left join inventory on inventory.itemID = prodGroupItems.itemID Where CAActive = 1 group by prodGroupID) as gCount on gCount.prodGroupId = prodGroups.prodGroupID left join (SELECT itemID, COUNT(stars) AS COUNT, round(cast(SUM([stars]) as float)/COUNT([stars]) *2,0)/2 AS avgstars FROM pcReviews WHERE active=1 group by itemID) as reviews on reviews.itemID = inventory.itemID left join freegifts on freeGifts.itemID = inventory.itemID WHERE [inventory].[active]=-1 and CAID <>0 and CAActive= 1 and brands.CABlock = 0 and inventory.CABlock=0 and ((inventory.caPrescription<>1 and inventory.caPrescription<>4) or inventory.caPrescription is null) and ((inventory.usPrescription<>1 and inventory.usPrescription<>4) or inventory.usPrescription is null) AND (newItemBlock = 0 or usPrescription = 0) and brands.CAAvail = 1 AND freeGiftID is null AND brands.IDBrand in (21) group by CASE When prodGroupItems.prodgroupID is null then cast(newID() as varchar(255)) ELSE cast(prodGroupItems.prodgroupID as varchar(255)) END ) as tempAll
You may like one of these Products
Pink Exfoliating Bath Glove, 1 pieces
La Roche Posay Anthelios XL Melt-in Cream SPF 60, 100ml/3.3 fl oz
EltaMD UV Clear Broad-Spectrum SPF 46, 48g/1.7 oz
Compressed Sponges, 2 pieces
Eternal Skincare is Vancouver's diamond standard in skincare and beauty's best an incredible selection of high-tech, hands-on aesthetic and medi-spa services, paired with specialty, niche, and amazingly effective beauty brands! Read More >