Attention all savvy investors, Airbnb aficionados, and cash-flow chasers: this is not your average upstate property. This fully renovated, mixed-use beauty in the heart of Middleburgh is part turnkey income stream, part lifestyle play—and 100 ready to impress your portfolio.
Let's talk numbers: five fully dialed-in apartments, thoughtfully designed and primed for short-term or long-term rental domination. Each one-bedroom unit has ductless heat/AC, in-unit laundry, dishwashers, and the kind of clean, modern finish tenants will happily pay for. Four units share a common entrance; one gets its own private access.
Then there's the cherry on top: a stylish commercial storefront currently home to one of the town's most beloved coffee shops and bakeries. That means a built-in anchor tenant, consistent monthly income, and community clout. Whether you keep the scones flowing or reimagine the space, this is exactly the kind of mixed-use setup that checks every investor box: residential + commercial = stability and flexibility, all under one beautifully updated roof.
Speaking of updates—this isn't a landlord-special reno. The building has been gutted and rebuilt with modern systems, plumbing, electric, HVAC, and more, while keeping just enough historic character to charm your tenants. It's clean, compliant, and cruising into your cap rate sweet spot.
Located right in the center of walkable, friendly Middleburgh, your tenants will enjoy quaint shops, local eats, and community events year-round. You? You'll enjoy diversified income streams and that elusive combo of lifestyle and ROI.
The numbers make sense, the setup is solid, and the hard work is already done. All that's missing is the investor who sees the potential and takes the leap. Floor plans and financials are ready when you are.
This isn't just real estate. It's a recession-resistant, revenue-generating, rural dream machine.
Active
$690,000
320 Main Street, Middleburgh, NY 12122
5beds
6baths
4,646sqft
Multi Family
Built in 1927
-- sqft lot
$668,800 Zestimate®
$149/sqft
$-- HOA
What's special
Stylish commercial storefrontModern systemsClean modern finishFive fully dialed-in apartmentsHistoric characterIn-unit laundry
- 35 days
- on Zillow |
- 515 |
- 47 |
Zillow last checked: 7 hours ago
Listing updated: July 02, 2025 at 06:56am
Listing by:
Anatole House LLC 845-943-4177,
Arlena Armstrong-Petock 412-760-0176
Source: HVCRMLS,MLS#: 20252686

Travel times
Tour with a buyer's agent
Tour with a buyer's agent
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 5
- Bathrooms: 6
Appliances
- Included: Washer/Dryer, Refrigerator, Range, Dishwasher
Interior area
- Total structure area: 4,646
- Total interior livable area: 4,646 sqft
- Finished area above ground: 4,646
- Finished area below ground: 0
Property
Lot
- Size: 2,613.6 Square Feet
Details
- Parcel number: 13
- Zoning: Com1
Construction
Type & style
- Home type: MultiFamily
- Property subtype: Multi Family
Condition
- New construction: No
- Year built: 1927
Community & HOA
Location
- Region: Middleburgh
Financial & listing details
- Price per square foot: $149/sqft
- Tax assessed value: $278,300
- Annual tax amount: $12,166
- Date on market: 7/2/2025
- Loading
- Loading