Skip main navigation
Active
    • $899,900

    239 Upson Rd, Frankfort, NY 13340

    4beds
    2,442sqft
    Farm, Single Family Residence
    Built in 1900
    101.2 Acres Lot
    $818,200 Zestimate®
    $369/sqft
    $-- HOA

    What's special

    Attached heated garageFour additional outbuildingsLarge first-floor laundry roomWine and coffee barFully powered two-stall garageBarn for livestockStunning custom kitchen
    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.
    43 days
    372
    26

    Zillow last checked:

    Listing updated:

    Listed by:

    Empire Homes & Commercial LLC 315-429-9404,

    Abby Hnydowitz 315-868-3255

    Source: NYSAMLSs,MLS#: S1715254MLS LogoOriginating MLS: Mohawk Valley

      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
      • Has view: Yes
      • View description: Slope View
      Lot
      • Size: 101.2 Acres
      • Dimensions: 4285 x 2543
      • Features: Agricultural, Adjacent To Public Land, Irregular Lot, Wooded
      Details
      • Additional structures: Barn(s), Outbuilding, Garage Apartment
      • Additional parcels included: 21480010500200010082000000
      • Parcel number: 21480010500200010083000000
      • Special conditions: Standard
      • Horses can be raised: Yes
      • Horse amenities: Horses Allowed

      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: $369/sqft
      • Tax assessed value: $80,000
      • Annual tax amount: $5,303
      • Date on market: 9/16/2026
      • Cumulative days on market: 326 days
      • Listing terms: Cash,Conventional,FHA,USDA Loan,VA Loan

        Estimated market value

        $818,200

        $769,000 - $859,000

        $2,308/mo

        Price history

        DateEventPrice
        9/16/2026Listed for sale$899,900-5.3%$369/sqft
        Source: NYSAMLSs #S1715254 Report a problem
        9/3/2026Listing removed$949,900$389/sqft
        Source: NYSAMLSs #S1669300 Report a problem
        3/26/2026Listed for sale$949,900-2.6%$389/sqft
        Source: NYSAMLSs #S1669300 Report a problem
        3/26/2026Listing removed$975,000$399/sqft
        Source: NYSAMLSs #S1656319 Report a problem
        10/31/2025Listed for sale$975,000$399/sqft
        Source: NYSAMLSs #S1647990 Report a problem
        6/22/2024Listing removed--
        Source: NYSAMLSs #S1479660 Report a problem
        6/21/2023Listed for sale$975,000+1047.1%$399/sqft
        Source: NYSAMLSs #S1479660 Report a problem
        11/13/2001Sold$85,000$35/sqft
        Source: Agent Provided Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2025-- $80,000
        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

        Monthly payment

        Estimated monthly payment$1,822
        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.
        See how much you could borrow to make a competitive offer.
        Get pre-qualified

        Climate risks

        Neighborhood: 13340

        Getting around

        0 / 100
        Car-Dependent
        1 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating
        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.

        A local agent can set up tours, give advice and negotiate with sellers.

        Browse local experts

        Similar homes

              Nearby cities

              Nearby zip codes

              Other Frankfort Topics

                Search
                Updates
                Favorites
                Plan
                Inbox