Seller's Agent in 2025
Arlena Armstrong
Anatole House LLC
(412) 760-0176
108 Total Sales
Estimated Value: $674,847
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.
Last Agent to Sell the Property
Country Boy Realty License #10311204132 Listed on: 12/06/2021
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| 320 Main St Owners Llc | $140,000 | None Available | |
| Slammin Apartments Llc | $140,000 | Jon Kosich | |
| A & P Sons Realty Llc | $195,000 | Michael Shultes | |
| Leather Charles | $172,750 | Michael Shultes |
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Open | 320 Main St Owners Llc | $330,000 | |
| Previous Owner | Slammin Apartments Llc | $105,000 | |
| Previous Owner | A & P Sons Realty Llc | $136,500 |
| Date | Event | Price | List to Sale | Price per Sq Ft | Prior Sale |
|---|---|---|---|---|---|
| 10/07/2025 10/07/25 | Price Changed | $649,000 | -5.9% | $140 / Sq Ft | |
| 07/02/2025 07/02/25 | For Sale | $690,000 | +392.9% | $149 / Sq Ft | |
| 12/02/2021 12/02/21 | Sold | $140,000 | 0.0% | $30 / Sq Ft | |
| 07/17/2021 07/17/21 | Off Market | $140,000 | -- | -- | |
| 03/17/2021 03/17/21 | Price Changed | $169,900 | -5.6% | $37 / Sq Ft | |
| 02/27/2021 02/27/21 | For Sale | $179,900 | 0.0% | $39 / Sq Ft | |
| 10/01/2020 10/01/20 | Pending | -- | -- | -- | |
| 07/26/2020 07/26/20 | For Sale | $179,900 | +28.5% | $39 / Sq Ft | |
| 01/30/2017 01/30/17 | Sold | $140,000 | -6.7% | $30 / Sq Ft | View Prior Sale |
| 11/18/2016 11/18/16 | Pending | -- | -- | -- | |
| 06/20/2016 06/20/16 | For Sale | $150,000 | -- | $32 / Sq Ft |
| Year | Tax Paid | Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. | Land | Improvement |
|---|---|---|---|---|
| 2024 | $16,585 | $278,300 | $7,100 | $271,200 |
| 2023 | $14,031 | $278,300 | $7,100 | $271,200 |
| 2022 | $5,573 | $110,000 | $7,100 | $102,900 |
| 2021 | $6,131 | $110,000 | $7,100 | $102,900 |
| 2020 | $8,608 | $110,000 | $7,100 | $102,900 |
| 2019 | $6,740 | $110,000 | $7,100 | $102,900 |
| 2018 | $6,740 | $110,000 | $7,100 | $102,900 |
| 2017 | $8,390 | $145,000 | $7,100 | $137,900 |
| 2016 | $8,305 | $145,000 | $7,100 | $137,900 |
| 2015 | -- | $145,000 | $7,100 | $137,900 |
| 2014 | -- | $145,000 | $7,100 | $137,900 |
Seller's Agent in 2025
Arlena Armstrong
Anatole House LLC
(412) 760-0176
108 Total Sales
Seller's Agent in 2021
Matthew Loder
Country Boy Realty
(518) 378-1235
24 in this area
559 Total Sales
Source: Global MLS
MLS Number: 202024040
APN: 433801-106-015-0004-013-000-0000