4174 Hamilton Ave Cincinnati, OH 45223

This 100% occupied mixed-use investment property is located in Cincinnati's vibrant Northside neighborhood. The property, totaling 1591 square feet, features a fully leased ground-floor retail space occupied by Beardo's Curiosities, a well-established local tenant. The second floor comprises a leased residential apartment. Situated along the highly trafficked Hamilton Avenue corridor, this asset benefits from excellent visibility, strong pedestrian activity, and proximity to a diverse mix of neighborhood amenities. The property is located in Cincinnati’s Northside neighborhood, a vibrant and eclectic community known for its artsy atmosphere, diverse dining options, and independent retail scene. The area benefits from strong foot traffic and excellent connectivity, with easy access to I-74 and public transit routes that link it to downtown Cincinnati and surrounding neighborhoods. Northside's walkability, active community events, and growing population of young professionals and creatives make it a highly desirable location for businesses looking to tap into a dynamic, engaged customer base. The neighborhood’s ongoing revitalization and mixed-use development trend further enhance its appeal for commercial investment. This offering presents an attractive opportunity for investors seeking a stabilized commercial component with additional residential upside in a dynamic urban setting.