320 Main Street, Middleburgh

$690,000

5 Beds
6 Baths
4,646 Sqft
.06 Acre
0 Garage

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.

Essential Information
MLS® #20252686
Price$690,000
Bedrooms5
Bathrooms6.00
Square Footage4,646
Acres0.06
Year Built1927
TypeResidential Income
Sub-TypeMulti Family
StyleRowhouse
StatusActive
Community Information
Address320 Main Street
AreaMiddleburgh
CityMiddleburgh
CountySchoharie
StateNY
Zip Code12122
Appliances

Washer/Dryer, Refrigerator, Range, Dishwasher

School Information
DistrictMiddleburgh
Additional Information
ZoningCom1
Listing Details
AgentArlena Armstrong-petock
Listing Courtesy of Anatole House LLC
LISTING MAP

Get directions to this property:

Ulster County Board of Realtors Logo The data relating to real estate on this website comes in part from the IDX of the Multiple Listing Service of Ulster County, Inc. Real estate listings held by brokerage firms other than Flemming Realty are marked with IDX logo and the detailed information about them includes the name of the listing broker.

Copyright © 2025 by the Multiple Listing Service of Ulster County, Inc. All Rights Reserved.

All information provided is deemed reliable but is not guaranteed and should be independently verified.

IDX information is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.