This was kind of a tricky one, I created a custom field on the database (explained on another post) and was able to add it to the product.tpl by adding just {$imageurl}.
This variable did not work on product-list.tpl, upon some research the correct way to add this is by adding:
$product.em_mg_imageurl