239 Upson Rd

2,442 Sq. Ft.
$399 / Sq. Ft.
2,442
Sq. Ft.
$399
per 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...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.

Property Details for 239 Upson Road

Styles Of Residence
Colonial, Farmhouse, Two Story
On Waterfront
No
Parking Description
Attached, Detached, Electricity, Garage, Heated Garage, Storage, Workshop In Garage, Water Available
Nearest Cross Street
Steuben Hill Rd
LISTING UPDATED: 01/02/2026 10:02 PM

Property Details for 239 Upson Road

StatusActive
MLS #S1656319
Days on Market6
Taxes$5,303 / year
HOA Fees-
Condo/Co-op Fees-
Compass TypeSingle Family
MLS TypeResidential / Single Family Residence
Year Built1900
Lot Size5.00 AC / 217,800 SF
CountyHerkimer County

Location

Listing Courtesy of Empire Homes & Commercial LLC
Add your commute

Building Information for 239 Upson Road

Stories2Year Built1900Building Size-Lot Size5.00 AC / 217,800 SF

Payment Calculator

$5,194 per month

30 year fixed, 6.15% Interest

Principal and Interest

$4,752

Property Taxes

$442

HOA Dues

$0

The Payment Calculator is for illustrative purposes only.

Property Information for 239 Upson Road

Summary
Location and General Information
  • Accessibility: Accessible Bedroom
  • Elementary School District: Frankfort-Schuyler
  • High School District: Frankfort-Schuyler
  • Middle Or Junior School District: Frankfort-Schuyler
  • Village: Not Applicable
  • Human YN: No
Parking
  • Attached Garage YN: Yes
  • Garage Spaces per Apt: 6.00
  • Garage YN: Yes
Taxes and HOA Information
  • Area NYSWIS Code: Schuyler-214800
  • Tax Annual Amount: $5,303.00
Property
Lot Information
  • Additional Parcels Description: 214800-105-002-0001-008-200-0000
  • Building Area Source: Public Records
  • Building Area Total: 2442.0
  • Land Features: Agricultural, Adjacent To Public Land, Irregular Lot
  • Num Of Acres: 101.2
  • Lot Size Area: 101.2
  • Lot Size Square Feet: 217800.0
  • Lot Size Units: Acres
  • Parcel Number: 214800-105-002-0001-008-300-0000
  • Lot Number: 8
Property and Assessments
  • Property Condition: Resale
  • Senior Community YN: No
  • Assessed Value: $80,000
  • Year Built: 1900
  • Year Built Description: Existing
Utilities
  • Electric Service: Circuit Breakers
  • Sewer Description: Septic Tank
  • Utilities Available: Cable Available, Electricity Connected, High Speed Internet Available
  • Water Supply: Well
Interior and Exterior Features
Exterior Features
  • Construction Materials: Aluminum Siding, Attic Crawl Hatchways Insulated, Vinyl Siding
  • Exterior Features: Blacktop Driveway, Deck, Play Structure
  • Foundation Description: Stone
  • Other Structures: Barns, Outbuilding, Garage Apartment
  • Patio And Porch Features: Deck
  • Roof Description: Asphalt, Metal
Interior Features
  • Appliances: Dryer, Dishwasher, Electric Water Heater, Gas Oven, Gas Range, Microwave, Refrigerator, Wine Cooler, Washer
  • Basement Description: Full
  • Basement YN: Yes
  • Num Of Possible Bedrooms: 4
  • HVAC Type: Other, See Remarks
  • Num Fireplaces Total Calculated: 3
  • Fireplace YN: Yes
  • Floor Description: Carpet, Hardwood, Laminate, Varies
  • Heating: Coal, Oil, Other, See Remarks, Forced Air, Stove
  • Heating YN: Yes
  • 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
  • Laundry Features: Main Level
  • Levels: Two
  • Sq Ft Total: 2442.0
  • Main Level Bathrooms: 1
  • Num Bedrooms 1 St Floor: 1
  • Num Of Rooms: 11
Multi Family
Multi-Family Information
  • Number Of Units Total: 0
  • Stories: 2
  • Stories Total: 2

Property History for 239 Upson Road

DateEvent & SourcePriceAppreciation
Jan 2, 2026

POM

WNYREIS #S1647990

Jan 2, 2026

TOM

WNYREIS #S1647990

Jan 2, 2026

Listed (Active)

WNYREIS #S1656319

$975,000
Oct 31, 2025

Listed (Active)

WNYREIS #S1647990

$975,000
Jun 21, 2024

Expired

WNYREIS #S1479660

Jun 21, 2023

Listed (Active)

WNYREIS #S1479660

$975,000
DateEvent & SourcePrice
01/02/2026

POM

WNYREIS #S1647990

01/02/2026

TOM

WNYREIS #S1647990

01/02/2026

Listed (Active)

WNYREIS #S1656319

$975,000
10/31/2025

Listed (Active)

WNYREIS #S1647990

$975,000
06/21/2024

Expired

WNYREIS #S1479660

06/21/2023

Listed (Active)

WNYREIS #S1479660

$975,000

For completeness, Compass often displays two records for one sale: the MLS record and the public record.

Public Records for 239 Upson Road

Taxable ValueLand$16,500Additions$63,500Total$80,000
Tax Record2024$2,479 ($207 / month)
Home Facts
Beds3Baths1Total Finished SqFt2,146 SqFtAbove Grade Finished SqFt2,146 SqFtStories2Lot Size217,800 SqFtStyleSingle Family ResidenceYear Built1900ZoningRACountyHERKIMERAPN214800 105.2-1-8.3

Schools near 239 Upson Road

This home is within Frankfort-Schuyler Central School District.
Rating
School
Type
Grades
Distance
Public - PK to 6
Public - 6 to 8
Public - 9 to 12
Rating
School
Distance
Frankfort Schuyler Elementary School
PublicPK to 6

Frankfort Schuyler Middle School
Public6 to 8

Frankfort Schuyler Central High School
Public9 to 12

School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.

Similar Homes

Similar Sold Homes

239 Upson Road is a single family home for sale in Schuyler, NY 13340. This property was listed for sale on January 2, 2026 by Empire Homes & Commercial LLC, it's currently listed at $975,000. This listing's school district is Frankfort-Schuyler Central School District. Nearby schools include Frankfort Schuyler Elementary School, Frankfort Schuyler Middle School and Frankfort Schuyler Central High School. 239 Upson Road is a 4-bed, 2-bath, 2,442 sqft single family home built in 1900.

No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of descriptions or measurements (including square footage measurements and property condition), such should be independently verified, and Compass, Inc., its subsidiaries, affiliates and their agents and associated third parties expressly disclaims any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. Offers of compensation are subject to change at the discretion of the seller. No financial or legal advice provided. Equal Housing Opportunity.

Listing Courtesy of Empire Homes & Commercial LLC

Based on information from one of the following Multiple Listing Services: WNYREIS and Greater Binghamton Association of REALTORS. Information being provided is for the visitor's personal, noncommercial use and may not be used for any purpose other than to identify prospective properties visitor may be interested in purchasing. The data contained herein is copyrighted by WNYREIS and Greater Binghamton Association of REALTORS is protected by all applicable copyright laws. Any dissemination of this information is in violation of copyright laws and is strictly prohibited. Property information referenced on this web site comes from the Internet Data Exchange (IDX) program of the MLS. This web site may reference real estate listing(s) held by a brokerage firm other than the broker and/or agent who owns this web site. For the avoidance of doubt, the accuracy of all information, regardless of source, is deemed reliable but not guaranteed and should be personally verified through personal inspection by and/or with the appropriate professionals.