For Sale
New
3D Tour3D Tour
House for sale at 239 Upson Rd, Frankfort, NY 13340 | MLS# S1720814 | Listing updated on 2026-10-08
Photo 1 of House for sale at 239 Upson Rd, Frankfort, NY 13340 | MLS# S1720814 | Listing updated on 2026-10-08
Photo 2 of House for sale at 239 Upson Rd, Frankfort, NY 13340 | MLS# S1720814 | Listing updated on 2026-10-08
Photo 3 of House for sale at 239 Upson Rd, Frankfort, NY 13340 | MLS# S1720814 | Listing updated on 2026-10-08
Photo 4 of House for sale at 239 Upson Rd, Frankfort, NY 13340 | MLS# S1720814 | Listing updated on 2026-10-08
46+
Beds Icon

Virtual Tour

Beds Icon

Street View

$899,900

Monthly Est:$4,479

  • Beds Icon4 Beds
  • Beds Icon
    2 Baths
  • Beds Icon2,442sqft

239 Upson Rd, Frankfort, NY 13340

$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 New York State Alliance of MLSs, Buffalo-NY

Property Details

  • Status

    Active

  • Type

    Land

  • No. of Stories

    2

  • County

    Herkimer County

  • City

    Frankfort

  • 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!

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

DateEventPrice

09/16/2026

Source: mls_logoNew York State Alliance of MLSs, Buffalo-NY #S1715254

Listed for Sale

$899,900

$369/sqft

09/16/2026

Source: mls_logoNew York State Alliance of MLSs, Buffalo-NY #S1715254

Off Market

$899,900 -5.26%

$369/sqft

05/01/2026

Source: mls_logoNew York State Alliance of MLSs, Buffalo-NY #S1656319

Listing Removed

$949,900

$389/sqft

03/26/2026

Source: mls_logoNew York State Alliance of MLSs, Buffalo-NY #S1656319

Off Market

$949,900

$389/sqft

03/26/2026

Source: mls_logoNew York State Alliance of MLSs, Buffalo-NY #S1669300

Listed for Sale

$949,900 -2.57%

$389/sqft

Show more

Nearby Homes

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