Rarely does an opportunity come along that offers this level of flexibility, lifestyle, and income potential all in one exceptional property. Completely renovated from top to bottom just a few years ago, this stunning home combines modern finishes, thoughtful design, and turnkey convenience with virtually every major component already updated - allowing you to focus on enjoying the property rather than maintaining it. Whether you're seeking a spacious owner-occupied residence, a multigenerational setup, or a high-performing investment, the possibilities here are remarkable. The current upper-level short-term rental is generating over $50,000 annually and has become a favorite among guests thanks to its unique character, custom artwork, inviting atmosphere, and unbeatable location. Situated in one of Middletown's most desirable areas, you'll enjoy the ability to walk to Wesleyan University, vibrant downtown Middletown, award-winning restaurants, boutique shopping, breweries, entertainment venues, and the scenic Connecticut River waterfront and Riverwalk. Commuters will appreciate convenient access to Routes 9, 66, 91, and other major thoroughfares. Outside, the property continues to impress with extensive parking, a newly paved driveway, beautiful landscaping, multiple new decks, private patio spaces, and a luxurious outdoor retreat featuring a hot tub lounge area complete with television, privacy shades, and a resort-like feel perfect for relaxing or entertaining.