This sounds like a very promising piece of real estate in a highly desirable location! The proximity to the University of Florida and UF Health facilities significantly increases its value and potential for various developments.
The U7 zoning in the City of Gainesville offers a wide range of possibilities, making it attractive to different types of investors and developers. The permitted uses you mentioned (multifamily, commercial, QSR, hotels/motels, medical offices) cover a broad spectrum of potential revenue-generating projects.
The unique feature of having access roads at both the front and the back is a significant advantage. This could indeed facilitate better traffic flow and open up creative design options for any future development on the lot. The fact that it was previously approved for a Comfort Suites hotel in 2007 also indicates that the site has been considered suitable for hospitality purposes in the past.
Finally, the existing leased billboard structure provides an immediate stream of income, which is a definite plus for any potential buyer or developer.
If you have any specific questions about this property, such as potential valuation, zoning regulations in more detail, or comparisons to other properties, please feel free to ask!