3CRE is pleased to present a 100% occupied, mixed-use investment property located in the vibrant Northside neighborhood of Cincinnati. The property 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. This offering presents an attractive opportunity for investors seeking a stabilized commercial component with additional residential upside in a dynamic urban setting. 4034 Hamilton Avenue 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.