Located in a prime area north of the foothill, this property has plenty of potential but requires some TLC