Discover a unique investment opportunity with this two-unit property located on scenic New Britain Avenue in charming Unionville, Connecticut. Offering 3 bedrooms, 2 bathrooms, and 1,668 sq ft of living space, this rare find sits on a prime lot bordering the Farmington River, delivering the feel of waterfront living—without the typical price tag. The property’s desirable location offers easy access to Farmington High School, local shopping at The Highland Park Market, and recreation at nearby Suburban Park. Whether you're an investor or owner-occupant, this quiet yet convenient setting offers the perfect balance of small-town charm and connectivity. Outside, enjoy a private yard with river views, an inground pool, and an upper deck ideal for entertaining. Inside, the first-floor unit features hardwood floors and a layout suited for flexibility—live in one unit and rent the other, generate dual rental income, or convert into a single-family home. Additional highlights include public water and sewer, simplifying maintenance. While the property needs updates and is being sold as-is, the strong rental potential, riverside setting, and investment upside make this a standout opportunity in Farmington Valley real estate. Don't miss your chance to turn this diamond in the rough into a high-performing asset or a charming riverside retreat.