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 farm listing #S1720814.
Single-familyProperty Type
1900Year Built
5 acresLot Size
$369Price/Sq.Ft.
6 car garageParking
Listing by Abby Hnydowitz• Empire Homes & Commercial LLC
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.
CNYIS #S1715254
Sep 16, 2026
Listed
$899,900
$369/sq ft
CNYIS #S1669300
Sep 2, 2026
Listing Removed
—
Mar 26, 2026
Listed
$949,900
$389/sq ft
CNYIS #S1656319
Mar 29, 2026
Listing Removed
—
Mar 26, 2026
Listing Removed
—
Mar 26, 2026
Price Changed
$949,900
$389/sq ft
Jan 2, 2026
Listed
$975,000
$399/sq ft
CNYIS #S1647990
Mar 29, 2026
Listing Removed
—
Mar 26, 2026
Listing Removed
—
Mar 26, 2026
Price Changed
$949,900
$389/sq ft
Jan 4, 2026
Listing Removed
—
Jan 3, 2026
Listing Removed
—
Jan 3, 2026
Listing Removed
—
Jan 2, 2026
Listing Removed
—
Oct 31, 2025
Listed
$975,000
$399/sq ft
CNYIS #S1479660
Jun 21, 2024
Listing Removed
—
Jun 21, 2023
Listed
$975,000
$399/sq ft
Year
Property tax
Land + Additions
Assessment*
2026
$3,173
$16,500 + $63,500
$80,000
2025
$3,173 (+6.8%)
$16,500 + $63,500
$80,000
2024
$2,970 (−2.6%)
$16,500 + $63,500
$80,000
2023
$3,050 (+10.7%)
$16,500 + $63,500
$80,000
2022
$2,757 (+1.9%)
$16,500 + $63,500
$80,000
2021
$2,704 (+23.7%)
$16,500 + $63,500
$80,000
2020
$2,186 (+1.8%)
$16,500 + $63,500
$80,000
2019
$2,147 (+3.5%)
$16,500 + $63,500
$80,000
2018
$2,075 (+0.9%)
$16,500 + $63,500
$80,000
2017
$2,056 (+1.2%)
$16,500 + $63,500
$80,000
2016
$2,032 (+1.4%)
$16,500 + $63,500
$80,000
2015
$2,003 (+0.3%)
$16,500 + $63,500
$80,000
2014
$1,998
$16,500 + $63,500
$80,000
Public record
Beds
3
Baths
1
Stories
2
Lot width
600 ft.
Lot depth
—
Lot size
5 Acres
Year renovated
—
Finished Sq. Ft.
2,146
Unfinished Sq. Ft.
—
Total Sq. Ft.
2,146
Year built
1900
Style
Single Family Residential
County
Herkimer County
APN
214800A10500200010083000000
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Aug 10, 2026.
Climate risks
1/10 Flood Factor
Minimal risk of a flood reaching the building in the next 30 years
1/10 Fire Factor
Unlikely to be in a wildfire in next 30 years
1/10 Heat Factor
7 days above 92° expected this year, 15 days in 30 years
1/10 Wind Factor
1% chance of strong winds in next 30 years
2/10 Air Factor
0 unhealthy days expected this year, 1 days in 30 years
Provided by First Street
Historical weather
Frankfort, NY • 13340
Average low and high temperatures (°F)
26
15
29
14
47
28
59
37
65
47
78
57
83
62
80
56
74
50
62
40
46
32
32
18
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
92/ 100
Exceptional sunlight
Sunscore
This home receives average direct sun exposure in Frankfort. There appears to be minimal shading by surrounding buildings, terrain, and vegetation.
10.4 hrs
5.8 hrs
JuneDecember
Provided by Shadowmap
Redfin Estimate for 239 Upson Rd
$846,014
$54K under list price of $900K
Nearby comparable homes
The Redfin Estimate uses 6 recent nearby sales, priced between $250K to $375K.