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.
Active
$975,000
239 Upson Rd, Frankfort, NY 13340
4beds
2,442sqft
Farm, Single Family Residence
Built in 1900
101.2 Acres Lot
$864,200 Zestimate®
$399/sqft
$-- HOA
What's special
Attached heated garageLarge first-floor laundry roomWine and coffee barStunning custom kitchen
- 74 days |
- 925 |
- 30 |
Zillow last checked: 7 hours ago
Listing updated: January 02, 2026 at 07:02pm
Listing by:
Empire Homes & Commercial LLC 315-429-9404,
Abby Hnydowitz 315-868-3255
Source: NYSAMLSs,MLS#: S1656319
Originating MLS: Mohawk Valley
Originating MLS: Mohawk ValleyTour with a local agent
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 2
- Full bathrooms: 2
- Main level bathrooms: 1
- Main level bedrooms: 1
Heating
- Coal, Oil, Other, See Remarks, Forced Air, Stove
Cooling
- Other, See Remarks
Appliances
- Included: Dryer, Dishwasher, Electric Water Heater, Gas Oven, Gas Range, Microwave, Refrigerator, Wine Cooler, Washer
- Laundry: Main Level
Features
- Breakfast Bar, Ceiling Fan(s), Dry Bar, Separate/Formal Dining Room, Eat-in Kitchen, Separate/Formal Living Room, Kitchen Island, Quartz Counters, Storage, Natural Woodwork, Bedroom on Main Level
- Flooring: Carpet, Hardwood, Laminate, Varies
- Basement: Full
- Number of fireplaces: 3
Interior area
- Total structure area: 2,442
- Total interior livable area: 2,442 sqft
Video & virtual tour
Property
Parking
- Total spaces: 6
- Parking features: Attached, Detached, Electricity, Garage, Heated Garage, Storage, Workshop in Garage, Water Available
- Attached garage spaces: 6
Accessibility
- Accessibility features: Accessible Bedroom
Features
- Levels: Two
- Stories: 2
- Patio & porch: Deck
- Exterior features: Blacktop Driveway, Deck, Play Structure
Lot
- Size: 101.2 Acres
- Dimensions: 4285 x 2543
- Features: Agricultural, Adjacent To Public Land, Irregular Lot
Details
- Additional structures: Barn(s), Outbuilding, Garage Apartment
- Additional parcels included: 21480010500200010082000000
- Parcel number: 21480010500200010083000000
- Special conditions: Standard
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Colonial,Farmhouse,Two Story
- Property subtype: Farm, Single Family Residence
Materials
- Aluminum Siding, Attic/Crawl Hatchway(s) Insulated, Vinyl Siding
- Foundation: Stone
- Roof: Asphalt,Metal
Condition
- Resale
- Year built: 1900
Utilities & green energy
- Electric: Circuit Breakers
- Sewer: Septic Tank
- Water: Well
- Utilities for property: Cable Available, Electricity Connected, High Speed Internet Available
Community & HOA
Location
- Region: Frankfort
Financial & listing details
- Price per square foot: $399/sqft
- Tax assessed value: $80,000
- Annual tax amount: $5,303
- Date on market: 1/2/2026
- Cumulative days on market: 137 days
- Listing terms: Cash,Conventional,FHA,USDA Loan,VA Loan
Estimated market value
$864,200
$804,000 - $925,000
$2,072/mo
Price history
Price history
| Date | Event | Price |
|---|---|---|
| 10/31/2025 | Listed for sale | $975,000$399/sqft |
Source:  NYSAMLSs #S1647990 Report a problem | ||
| 6/22/2024 | Listing removed | -- |
Source: NYSAMLSs #S1479660 Report a problem | ||
| 6/21/2023 | Listed for sale | $975,000+1047.1%$399/sqft |
Source: NYSAMLSs #S1479660 Report a problem | ||
| 11/13/2001 | Sold | $85,000$35/sqft |
Source: Agent Provided Report a problem | ||
Public tax history
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2024 | -- | $80,000 |
| 2023 | -- | $80,000 |
| 2022 | -- | $80,000 |
| 2021 | -- | $80,000 |
| 2020 | -- | $80,000 |
| 2019 | -- | $80,000 |
| 2018 | -- | $80,000 |
| 2017 | $2,029 | $80,000 |
| 2016 | -- | $80,000 |
| 2015 | -- | $80,000 |
| 2014 | -- | $80,000 |
| 2013 | -- | $80,000 |
| 2012 | -- | $80,000 |
| 2011 | -- | $80,000 |
| 2010 | -- | $80,000 |
| 2009 | -- | $80,000 |
| 2008 | -- | $80,000 |
| 2007 | -- | $80,000 |
| 2006 | -- | $80,000 |
Find assessor info on the county website
BuyAbility℠ payment
Estimated monthly payment
All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
See how much you could borrow to make a competitive offer.
Boost your down payment with 6% savings match
Earn up to a 6% match & get a competitive APY with a *. Zillow has partnered with to help get you home faster.
Learn more*Terms apply. Match provided by Foyer. Account offered by Pacific West Bank, Member FDIC.Climate risks
Neighborhood: 13340
Nearby schools
GreatSchools rating
- 4/10Frankfort Schuyler Elementary SchoolGrades: PK-6Distance: 5.8 mi
- 5/10Frankfort Schuyler Middle SchoolGrades: 6-8Distance: 5.6 mi
- 6/10Frankfort Schuyler Central High SchoolGrades: 9-12Distance: 5.6 mi
Schools provided by the listing agent
- District: Frankfort-Schuyler
Source: NYSAMLSs. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
Local experts in 13340
- New York
- Herkimer County
- Frankfort
- 13340
- 239 Upson Rd
Nearby cities
Nearby zip codes
Other Frankfort Topics
