Rare investment opportunity in the heart of College Point. This semi-detached all-brick mixed-use building sits on a 25x100 lot with a 25x40 building footprint and rare M1-2 zoning. This property is a high-yield asset. The first floor is occupied by a stable commercial tenant with options to deliver vacant or keep for immediate cash flow. The second and third floors are fully renovated and delivered vacant, featuring a 2-bedroom 1.5-bathroom unit and a spacious 3-bedroom 1.5-bathroom unit respectively. The entire building has been updated internally and externally, including unit ACs, 3 separate gas meters, 3 electric meters, and 3 independent heating and hot water systems for easy management. Additional features include a detached 2-car garage with expansion potential for a warehouse, a large backyard for extra parking, and a basement with a half-bath. Prime location just 3 minutes from local dining and the Q25 bus with direct access to Main St Flushing.