Skip main navigation
Active
    • $975,000

    239 Upson Rd, Frankfort, NY 13340

    4beds
    2,442sqft
    Farm, Single Family Residence
    Built in 1900
    101.2 Acres Lot
    $888,900 Zestimate®
    $399/sqft
    $-- HOA

    What's special

    Attached heated garageLarge first-floor laundry roomWine and coffee barStunning 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. 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.
    28 days
    |
    1,304
    |
    20
    |

    Zillow last checked: 8 hours ago

    Listing updated: January 02, 2026 at 07:02pm

    Listing by:

    Empire Homes & Commercial LLC 315-429-9404,

    Abby Hnydowitz 315-868-3255

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

    Tour with a local agent

    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
    Lot
    • Size: 101.2 Acres
    • Dimensions: 4285 x 2543
    • Features: Agricultural, Adjacent To Public Land, Irregular Lot
    Details
    • Additional structures: Barn(s), Outbuilding, Garage Apartment
    • Additional parcels included: 21480010500200010082000000
    • Parcel number: 21480010500200010083000000
    • Special conditions: Standard

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

    Estimated market value

    $888,900

    $827,000 - $942,000

    $2,113/mo

    Price history

    Price history
    DateEventPrice
    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

    Public tax history
    YearProperty taxesTax assessment
    2024-- $80,000
    2023-- $80,000
    2022-- $80,000

    Find assessor info on the county website

    BuyAbility℠ payment

    Estimated monthly payment
    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.
    Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
    See how much you could borrow to make a competitive offer.

    Boost your down payment with 6% savings match

    Earn up to a 6% match & get a competitive APY with a *. Zillow has partnered with to help get you home faster.

    Learn more*Terms apply. Match provided by Foyer. Account offered by Pacific West Bank, Member FDIC.

    Climate risks

    Neighborhood: 13340

    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.

    Skip to the end of the carouselSkip to the beginning of the carousel

    Similar homes

    Skip to the end of the carouselSkip to the beginning of the carousel
    • Loading
    • Loading

    Nearby cities

    Nearby zip codes

    Other Frankfort Topics