*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.
Sold for $830,000
Zillow last checked:
Listing updated:
Bought with:
Non Member-MLS
Buyer Representation Office
Source: OneKey® MLS as distributed by MLS GRID,MLS#: 1015897
Price history
| Date | Event | Price |
|---|---|---|
| 9/10/2026 | Sold | $830,000-2.2%$388/sqft |
Source:  OneKey® MLS as distributed by MLS GRID #1015897 Report a problem | ||
| 7/19/2026 | Pending sale | $849,000$397/sqft |
Source: OneKey® MLS as distributed by MLS GRID #1015897 Report a problem | ||
| 6/25/2026 | Listed for sale | $849,000+42350%$397/sqft |
Source: OneKey® MLS as distributed by MLS GRID #1015897 Report a problem | ||
| 3/7/2010 | Listing removed | $2,000$1/sqft |
Source: Prudential Real Estate #2264091 Report a problem | ||
| 2/25/2010 | Listed for sale | $2,000$1/sqft |
Source: Prudential Real Estate #2264091 Report a problem | ||
Nearby homes
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$851,800
