Rare Opportunity to own a mid use property! This exceptional six-unit property offers breathtaking views with just steps away from the Quinnipiac River in a prime, highly desirable location. Each unit has been completely renovated with modern finishes including brand-new flooring, updated kitchens, granite counters, stainless steel appliances, and in-unit laundry hookups-making this a turnkey investment. The property features 5 spacious 2-bedroom units, and one 1-bedroom unit, with the unique bonus of 1 unit zoned for commercial use-ideal for a home office, small business, or flexible live/work setup. Each unit has their own deck, with amazing views. This home was completely renovated in 2005 with all gas furnaces, electrical, thermopane windows and so much more! This home features a large driveway for off street parking. With its unbeatable location, stunning river views and thoughtful updates throughout, this is a rare find for investors or owner-occupants seeking both comfort and potential income. Don't miss out!