Location, Location, Location. Introducing an extraordinary, rare opportunity in real estate! This remarkable 10 unit multifamily property, built on a 0.5 acre double lot, boasts over 200 feet of water frontage, offering stunning waterfront views. Eight of the units feature spacious 2 bedrooms and 2 bathrooms, while the remaining two units offer cozy 1 bedroom and 1 bathroom layoutsall overlooking the water. Imagine the allure of waking up to serene water vistas from every window. Walkable distance from Treasure Island beach, famous John's Pass and Hubbard's Marina, where you'll find shopping, waterfront dining, and a variety of water activities. This property promises endless possibilities for rentals, whether long term leases or lucrative vacation rental ventures. Don't miss out on this prime investment opportunity! New concrete Seawall and new windows installed in 2023.