239 Upson Rd, Frankfort, NY, 13340
About This Home
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. Contact the listing agent to schedule your showing.
Getting Around
Car-Dependent
Very Limited Transit
Somewhat BikeableSchools
Construction
Condition
- Property condition: Resale
- Year built: 1900
Materials
- Foundation: Stone
- Roof: Asphalt,Metal
- Construction materials: Aluminum Siding,Attic/Crawl Hatchway(s) Insulated,Vinyl Siding
Type & Style
- Home type: SingleFamily
- Architectural style: Colonial,Farmhouse,Two Story
- Property subType: Farm,Single Family Residence
Interior
Appliances
- Appliances included: Dryer,Dishwasher,Electric Water Heater,Gas Oven,Gas Range,Microwave,Refrigerator,Wine Cooler,Washer
- Laundry features: Main Level
Basement
- Has basement: Yes
- Basement: Full
Bedrooms & Bathrooms
- Bedrooms: 4
- Bathrooms: 2
- Full bathrooms: 2
- Main level bathrooms: 1
- Main level bedrooms: 1
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
- Number of fireplaces: 3
- Fireplace: Yes
Heating & Cooling
- Heating features: Coal,Oil,Other,See Remarks,Forced Air,Stove
- Cooling features: Other,See Remarks
Interior Area
- Total structure area: 2,442
- Total interior livable area: 2,442 sqft
Property
Accessibility
- Accessibility features: Accessible Bedroom
Details
- Parcel number: 21480010500200010083000000
- Special condition: Standard
Features
- Levels: Two
- Stories: 2
- Patio & porch: Deck
- Exterior features: Blacktop Driveway,Deck,Play Structure
Lot
- Lot size: 101.20 Acres
- Features: Agricultural,Adjacent To Public Land,Irregular Lot
- Lot size dimensions: 4285 x 2543
Parking
- Total spaces: 6
- Parking features: Attached,Detached,Electricity,Garage,Heated Garage,Storage,Workshop in Garage,Water Available
- Has garage: Yes
- Attached garage spaces: 6
- Covered spaces: 6
Climate Risk is Financial Risk
Every home has a financial story beyond the listing price. Below, you’ll see the climate risks that could affect this property — and in Bills & Affordability, how those risks may influence repairs, insurance, utilities, and long-term value.
Biggest Threats for This Home
- Winter Weather
- Ice Storm
- Lightning
How This Home’s Risks Compare
FEMA Declared Disasters in Herkimer County and New York
Understanding the Costs
Financial advisors generally recommend spending no more than 30% of your gross household income on housing costs. In practice, many households stretch to 35% or beyond — especially in high-cost markets.
Estimated Costs Today
| Monthly | Annual | |
|---|---|---|
| Mortgage | $4,803 | $57,636 |
| Home Insurance * | $436 | $5,232 |
| Property Taxes | $1,314 | $15,768 |
| Electricity | $403 | $4,842 |
| Total | $6,956 | $83,472 |
Income You'd Need if You Spent...
New York FAIR Plan Programs
How Costs Could Change Over Time
Climate risk is quickly impacting all of the major home ownership costs. Adjust the growth rates and percentage of income spent on housing below to see how your housing costs could change over the next 10 years — and what income you'd need to keep up.
Comparing Against the Market
Price Per Sq Ft
vs Other Active Listings
Avg $/sqft
vs Homes Sold Last Month
Median $/sqft
Current Market Trends
Median Price Per Square Foot
The median price per square foot of homes sold in this area each month. Compare this to this listing's price per square foot to gauge whether the home is priced in line with recent sales.
Historicals for This Listing
Zestimate History ($/sqft)
No zestimate history available
Price History
| Date | Event | Price |
|---|---|---|
| 2026-03-26 | Listed for sale | $949,900 |
| 2026-03-26 | Listing removed | $975,000 |
| 2025-10-31 | Listed for sale | $975,000 |
| 2024-06-22 | Listing removed | -- |
| 2023-06-21 | Listed for sale | $975,000 |
| 2001-11-13 | Sold | $85,000 |
View on Zillow