Coldwell Banker Home Page
Local Realty Service Provided By: Coldwell Banker Integrity Real Estate
Property view
Listing view 2
Listing view 3

239 Upson Road, 
Frankfort, NY 13340

$975,000


4

Beds


2

Baths


2,442

Sq Ft


Single Family


Virtual Tour

Active

Listed by

Abby Hnydowitz

Empire Homes & Commercial LLC.

315-429-9404

Last updated:

November 10, 2025, 04:48 PM

MLS#

S1647990

Source:

NY GENRIS

About This Home

239 Upson Road

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.

Home Facts

Single Family

2 Baths

4 Bedrooms

Built in 1900

Price Summary

975,000

$399 per Sq. Ft.

MLS #:

S1647990

Last Updated:

November 10, 2025, 04:48 PM

Added:

11 day(s) ago


Rooms & Interior

Bedrooms

Total Bedrooms:

4

Bathrooms

Total Bathrooms:

2

Full Bathrooms:

2

Interior

Living Area:

2,442 Sq. Ft.


Structure

Structure

Architectural Style:

Colonial, Farmhouse, Two Story

Building Area:

2,442 Sq. Ft.

Year Built:

1900


Lot

Lot Size (Sq. Ft):

4,408,272


Finances & Disclosures

Finances

Price:

$975,000

Price per Sq. Ft:

$399 per Sq. Ft.

Source:NY GENRIS
The information being provided by New York State Alliance Of Mlss is for the consumer’s personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The information is deemed reliable but not guaranteed and should therefore be independently verified. © 2025 New York State Alliance Of Mlss All rights reserved.

Contact an Agent

Yes, I would like more information from Coldwell Banker. Please use and/or share my information with a Coldwell Banker agent to contact me about my real estate needs.

By clicking Contact I agree a Coldwell Banker Agent may contact me by phone or text message including by automated means and prerecorded messages about real estate services, and that I can access real estate services without providing my phone number. I acknowledge that I have read and agree to the Terms of Use and Privacy Notice.

 

Contact an Agent

Yes, I would like more information from Coldwell Banker. Please use and/or share my information with a Coldwell Banker agent to contact me about my real estate needs.

By clicking Contact I agree a Coldwell Banker Agent may contact me by phone or text message including by automated means and prerecorded messages about real estate services, and that I can access real estate services without providing my phone number. I acknowledge that I have read and agree to the Terms of Use and Privacy Notice.