Welcome to a rare duplex opportunity in Cincinnati's historic Mohawk District, perched above Over-the-Rhine and offering incredible city views. Enjoy a highly walkable location with easy access to the Brewery District, TQL Stadium, Findlay Market, and countless restaurants, breweries, shops, and entertainment venues. Numerous recent improvements and major updates make this property an exceptional value and provide peace of mind for years to come. Unit 1 features a comfortable one-bedroom layout highlighted by a beautifully renovated bathroom that feels like a private urban oasis. Unit 2 offers 2 bedrooms, 1 bath, stylish modern dcor, and an inviting living space. As an added bonus, the thoughtfully selected furnishings in Unit 2 are included, creating a turnkey opportunity for an owner-occupant, investor, or short-term rental operator. Whether you're looking to expand your portfolio or own a piece of one of Cincinnati's most vibrant neighborhoods, 404 Mohawk Street delivers!