- Overview
- Description
- Property Details
- Location
- Facts & Features
- Getting Around
- Nearby Homes
$899,900
Monthly Est:$4,479
4 Beds
- 2 Baths
2 full baths
2,442sqft
239 Upson Rd, Frankfort, NY 13340
$899,900
$4,479/moEst:
Get Pre-Approved
Farm
Built in 1900
$-- HOA
5 acres lot
$369/sq.ft
Description
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. Most recently the owners have completely revamped the master with fresh paint and beautiful new flooring. 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. Please also see residential listing #S1715254.
- Houzeo last checked: 12 hours ago
- Listing updated: October 8, 2026 at 5:02 am
- Listing Provided by: Abby Hnydowitz (315) 868-3255 DRE #10401370397 | Empire Homes & Commercial LLC (315) 429-9404
- Source: New York State Alliance of MLSs, Buffalo-NY | MLS#: S1720814

Property Details
Status
Active
Type
Land
No. of Stories
2
County
City
Neighborhood
--
Year Built
1900
HOA Fees
-
Finished Area
2,442 sqft
Lot Size
5 acres lot
Basement Area
- sqft
MLS Name
New York State Alliance of MLSs, Buffalo
MLS Number
S1720814
MLS Status
Active
Days on Market
1

Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
Download App
Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
Location
Facts & Features
Rooms
Bedrooms & bathrooms
Bedrooms: 4
Bathrooms: 2
Interior
Sewer
Septic Tank
Interior Features
Breakfast Bar, Ceiling Fans, Dry Bar, Separate Formal Dining Room, Eat In Kitchen, Separate Formal Living Room, Kitchen Island, Quartz Counters, Storage, Natural Woodwork, Bedroom On Main Level
Appliances
Dryer, Dishwasher, Electric Water Heater, Gas Oven, Gas Range, Microwave, Refrigerator, Wine Cooler, Washer
Exterior Features
Blacktop Driveway, Deck, Play Structure
Flooring
Carpet, Hardwood, Laminate, Varies
Cooling
Other, See Remarks, Window Units
Heating
Coal, Oil, Other, See Remarks, Wood, Forced Air, Stove
Construction
Year Built
Year Built: 1900
Home type
Farm
Property Condition
Resale
Foundation Details
Stone
Architectural Style
Colonial, Farmhouse, Two Story
Roof
Asphalt, Metal
Construction Materials
Aluminum Siding, Attic Crawl Hatchways Insulated, Vinyl Siding
Utilities & Energy
Water Source
Spring, Well
Laundry Features
Main Level
Utilities
Electricity Available, Phone Available, Sewer Available, Water Available, Cable Available, Electricity Connected, High Speed Internet Available
Basement
Full
Parking Features
Attached, Detached, Electricity, Garage, Heated Garage, Storage, Workshop In Garage, Water Available
Electric
Circuit Breakers
Other Features
Community Features
Trails Paths
Patio And Porch Features
Deck
Lot Features
Adjacent To Public Land, Irregular Lot, Rural Lot, Secluded, Tillable, Cleared, Gentle Sloping, Rolling Slope, Spring
Disclosures
Agricultural District
Price History
| Date | Event | Price |
|---|---|---|
09/16/2026 Source: | Listed for Sale | $899,900 $369/sqft |
09/16/2026 Source: | Off Market | $899,900 -5.26% $369/sqft |
05/01/2026 Source: | Listing Removed | $949,900 $389/sqft |
03/26/2026 Source: | Off Market | $949,900 $389/sqft |
03/26/2026 Source: | Listed for Sale | $949,900 -2.57% $389/sqft |
Show more
Nearby Homes
Find Homes by Property Features in Frankfort, NY
Based on data from the New York State Alliance of MLSs (CNYIS, Inc., UNYREIS and WNYREIS) through Sep 30, 2026, 03:45PM.. All information is provided exclusively for consumers’ personal, non-commercial use. It may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The data is deemed reliable by is not guaranteed accurate by the MLS. This website may not include listings or property addresses of sellers who have directed their listing brokers to withhold their listing or their property address from display on the Internet. All information provided is deemed reliable but is not guaranteed and should be independently verified. © 2026 the New York State Alliance of MLSs. All Rights Reserved.
Advertising Broker: Derek Greene | The Greene Realty Group
