*RARE* Mixed-Use Opportunity ...Prime Investment or End-User in the Heart of Valley Stream. Ideal for supplemental rental income or owner occupancy. This can also be an excellent opportunity for extended multigenerational living. This 2138 sq ft. Structure has it all! One side of the property boasts a 3 bedroom 2 full bath apartment including- living room, dining room, kitchen w/ granite counters & outdoor exit, 1st floor bedroom & full bath. 2nd floor includes 2 additional bedrooms, full bath & attic space. There also is a full basement with 1/2 bath for endless opportunities. This property is zoned/legal and is currently configured as a dentist office. The dental side includes a separate entrance for office, waiting room, reception area, 2 exam rooms w/sinks, lab & 1/2 bath. Also includes access to basement. Other highlights include a Backyard perfect for entertaining, wood floors & conveniently located near transportation, local shops & all major roadways. Whether you're expanding your business or seeking a solid investment opportunity, this property delivers location, functionality, and long-term value. Don't miss this rare chance to secure a prime mixed-use space with endless potential.