Real Estate for Sale

Save
Ask
Tour
Hide
Share
$975,000
44 Days On Site

239 Upson Road
Frankfort, NY 13340

For Sale|Single Family Residence|Active
4
Beds
2
Total Baths
2
Full Baths
2,442
SqFt
$399
/SqFt
1900
Built
County:
Herkimer
Listing courtesy of Abby Hnydowitz of Empire Homes & Commercial LLC 3158683255
Call Now: (607) 288-4881
Is this the listing for you? We can help make it yours.
(607) 288-4881
239 Upson Road239 Upson Road239 Upson Road239 Upson Road
Save
Ask
Tour
Hide
Share

Mortgage Calculator

Monthly Payment (Est.)

$4,448
Calculator powered by Showcase IDX, a Constellation1 Company. Copyright ©2025 Information is deemed reliable but not guaranteed.

A million-dollar view! Welcome to the most breathtaking 101.2 acres Upstate NY has to offer. With a panorama that spans across the Mohawk Valley and Utica, you won't wonder why the home was lovingly known for generations as "Valley View Farms". This 1800s farmhouse has undergone a complete renovation from top to bottom, featuring a stunning custom kitchen, wine and coffee bar, new second-floor bath with an entire wall of cabinetry, and a beautiful front sitting room perfect for watching the incredible sunsets. Enjoy modern conveniences like a large first-floor laundry room, full bath, and bedroom. In addition to the attached heated garage, this expansive property also includes four additional outbuildings and a portion of a silo just waiting for someone's creative ideas. Outbuildings include a fully powered two-stall garage, a barn for livestock, and another larger powered barn that is insulated and fed with water to hold more livestock, store farm machinery, and conveniently hold 1,000+ bales of hay. The fourth outbuilding, also fully powered and heated, holds a downstairs with storage, work area, and a half bath, and an upstairs with a rear entrance that features an incredible apartment. The property boasts two septic systems, two wells, and a gravity-fed spring to ensure you will never run out of water. This land consists of 80-90 immaculately kept tillable acres, 15+ acres of woods comprising maple, beech, and birch, as well as acres of fenced-in pasture for livestock. Whether you're looking to farm, escape the city life, or simply enjoy this breathtaking view, you can rest assured you can enjoy it peacefully, as this property rests adjacent to 1,000+ acres of state land and is 1 of 2 houses on the entire road. Just a short distance to Herkimer, Utica, and the NYS thruway. Contact the listing agent to schedule your showing.

Save
Ask
Tour
Hide
Share
Listing Snapshot
Price 
$975,000
Days On Site 
44 Days
Bedrooms 
4
Inside Area (SqFt) 
2,442 sqft
Total Baths 
2
Full Baths 
2
Partial Baths 
N/A
Lot Size 
101.2 Acres
Year Built 
1900
MLS® Number 
S1647990
Status 
Active
Property Tax 
$5,303
HOA/Condo/Coop Fees 
N/A
Sq Ft Source 
Public Records
Friends & Family
Recent Activity
a month agoListing first seen on site
a month agoListing updated with changes from the MLS®
General Features
Acres 
101.2
Attached Garage 
Yes
Cross Street 
Steuben Hill Rd
Foundation 
Stone
Garage 
Yes
Garage Spaces 
6
Levels 
Two
Number Of Stories 
2
Parking 
AttachedDetachedGarageHeated GarageStorageWorkshop in Garage
Property Sub Type 
Single Family Residence
Sewer 
Septic Tank
Special Circumstances 
Standard
SqFt Total 
2442
Style 
Colonial, Farmhouse, Two Story
Utilities 
Cable AvailableElectricity Connected
Water Source 
PrivateWell
Interior Features
Appliances 
DryerDishwasherElectric Water HeaterGas OvenGas RangeMicrowaveRefrigeratorWine CoolerWasher
Basement 
Full
Cooling 
Ceiling Fan(s)Other
Electric 
Circuit Breakers
Fireplace 
Yes
Fireplaces 
3
Flooring 
CarpetHardwoodLaminateVaries
Heating 
CoalOilOtherSee RemarksForced Air
Interior 
Eat-in Kitchen
Laundry Features 
Main Level
Main Level Bedrooms 
1
Save
Ask
Tour
Hide
Share
Exterior Features
Construction Details 
Aluminum SidingAttic/Crawl Hatchway(s) InsulatedVinyl Siding
Lot Features 
AgriculturalIrregular Lot
Other Structures 
Barn(s)Outbuilding
Patio And Porch 
Deck
Roof 
AsphaltMetal
Community Features
Accessibility Features 
Accessible Bedroom
Financing Terms Available 
CashConventionalFHAUSDA LoanVA Loan
MLS Area 
Schuyler-214800
School District 
Frankfort-Schuyler
Township 
Not Applicable
Schools
School District
Frankfort-Schuyler
Elementary School
Unknown
Middle School
Unknown
High School
Unknown
Listing courtesy of Abby Hnydowitz of Empire Homes & Commercial LLC 3158683255



The data relating to real estate on this website comes in part from the Internet Data Exchange (IDX) Program of NYSAMLS’s. Real estate listings held by firms other than are marked with the IDX logo and detailed information about them includes the Listing Broker’s Firm Name.

All information deemed reliable but not guaranteed and should be independently verified. All properties are subject to prior sale, change, or withdrawal. Neither the listing broker(s) nor shall be responsible for any typographical errors, misinformation, misprints, and shall be held totally harmless. © Last checked: 2025-12-14 07:09 PM UTC CNYIS, UNYREIS, WNYREIS. All rights reserved.

Cornerpin Realty

Neighborhood & Commute
Source: Walkscore
Disclosure: Community information and market data powered by Constellation Data Labs. Information is deemed reliable but not guaranteed.
Save
Ask
Tour
Hide
Share

Looking for commercial real estate? Ithaca Commercial Real Estate, Syracuse Commercial Real Estate