2005-built, prime location mixed-use building situated in the bustling neighborhood of Flushing, NY along busy main throughway Northern Blvd. This well-maintained property consists of a ground-floor retail space occupied by a long standing pharmacy with long term lease in place. Basement is an internet cafe w lease till 2026. Four upper floor residential free-market rental apartments: two 3-bedroom, 2-bathroom units and two duplex 2-bedroom, 2-bathroom units. The property has a strong and long-term tenant base, with good-paying tenants and almost never had any vacancy. Rents can go up at next renew. The building is easy to manage and well-maintained, providing a hassle-free investment opportunity for potential buyers. Flushing is a rapidly growing neighborhood, known for its diverse culture and thriving business district. This mixed-use property presents a significant appreciation potential, as the area continues to develop and attract new businesses and residents.