select m.manufacturers_id, m.manufacturers_name, m.address_key, mi.manufacturers_meta_title, mi.manufacturers_meta_descp, mp.manufacturersportion_image from manufacturers m left join manufacturers_portion mp on m.manufacturers_id = mp.manufacturers_id and mp.manufacturersportion_position = 'Left Menu', manufacturers_info mi where m.manufacturers_id = mi.manufacturers_id and m.manufacturers_id = '296'
Freeman Beauty was launched in 1976 with a vision to provide nature inspired hair care, facial masks, and bath & body essentials. Since then, Freeman Beauty has become the leader and recognized expert in facial masks with a variety of innovative, on-...trend, and award winning products! Our brand portfolio includes Freeman Feeling Beautiful facial masks, Freeman Beauty Infusion serum-infused facial masks, Freeman Feeling Legendary facial masks for men, Freeman Bare Foot pampering foot care products, Psssst! the TRUE Original Dry Shampoo, and c.Booth bath & body care products.
