239 Upson RoadFrankfort, NY 13340




Mortgage Calculator
Monthly Payment (Est.)
$4,448A 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.
| a month ago | Listing first seen on site | |
| a month ago | Listing updated with changes from the MLS® |
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
Search the most recent property listings
Browse current Ithaca, NY real estate listings including homes, vacant land, and lakefront properties. Find your perfect property in Tompkins County with detailed photos and pricing or view all properties by ZIP code. Updated daily.
Looking for commercial real estate? Ithaca Commercial Real Estate, Syracuse Commercial Real Estate


Did you know? You can invite friends and family to your search. They can join your search, rate and discuss listings with you.