HOMESFARMSANDLAND
BuySell
    • Featured Properties
    • Property Showcases
    • Latest Blogs
      • Overview
      • Explore Open Houses
      • Discover Rental Living
      • Escape to Cabin Life
      • Unlock Multi-Family Living
      • Your Perfect Land Awaits
      • Embrace Farm Life
      • Overview
      • Find Rentals
      • Find Cabins
      • Browse Homes
      • Browse Farms
      • Browse Lands
    • Saved Properties
    • Overview
    • Buying Form
    • Buying Process
    • Mortgage Calculator
    • Overview
    • Selling Form
    • Selling Process
    • Free Home Evaluation
      • All of Otsego
      • Cooperstown
      • Oneonta
      • West Oneonta
      • Milford
      • Hartwick
      • Worcester
      • Unadilla
      • Laurens
      • Richfield Springs
      • All of Schoharie
      • Cobleskill
      • Middleburgh
      • Schoharie
      • Sharon Springs
      • Summit
      • Richmondville
      • Esperance
      • All of Chenango
      • Norwich
      • Oxford
      • Greene
      • Bainbridge
      • Sherburne
      • All of Delaware
      • Delhi
      • Stamford
      • Andes
      • Walton
      • Margaretville
      • Roxbury
      • Sidney
      • All of Greene
      • Catskill
      • Windham
      • Hunter
      • Cairo
      • Coxsackie
      • Athens
      • All of Broome
      • Binghamton
      • Vestal
      • Endicott
      • All of Oneida
      • New Hartford
      • Utica
      • Marcy
      • Clinton
      • All of Montgomery
      • Amsterdam
      • Fort Plain
      • Canajoharie
      • Fonda
      • All of Ulster
      • Kingston
      • New Paltz
      • Saugerties
      • Woodstock
      • Marlborough
    • Overview
    • Free Vendor List
    • Practical Guides
    • Need Funding?
    • Property Inspector
    • Down Payment Eligibility
    • Location Sharing?
      • Overview
      • Standard Operating Procedure
      • NYS Buyer-Seller
      • NYS Landlord-Tenant
      • Tenant Rights Notice
      • Fair Housing Notice
      • Privacy Policy
      • Location Services
      • Properties Preferences
      • Map Data Attribution
    • Who We Are
    • Meet the Team
Featured
Featured Properties
Property Showcases
Latest Blogs
Search
Advanced Search
Explore Open Houses
Discover Rental Living
Escape to Cabin Life
Unlock Multi-Family Living
Your Perfect Land Awaits
Embrace Farm Life
Search by Map
Find Rentals
Find Cabins
Browse Homes
Browse Farms
Browse Lands
Saved Properties
Buy
Buying Form
Buying Process
Mortgage Calculator
Sell
Selling Form
Selling Process
Free Home Evaluation
HOMESFARMSANDLAND
  • Otsego
  • Schoharie
  • Chenango
  • Delaware
  • Greene
  • Broome
  • Oneida
  • Montgomery
  • Ulster

Select a county to see cities

Resources
Free Vendor List
Practical Guides
Need Funding?
Property Inspector
Down Payment Eligibility
Location Sharing?
Disclosures
Standard Operating Procedure
NYS Buyer-Seller
NYS Landlord-Tenant
Tenant Rights Notice
Fair Housing Notice
Privacy Policy
Location Services
Properties Preferences
Map Data Attribution
About
Who We Are
Meet the Team

Let's Find Your Next Property.

HOMESFARMSANDLAND.COM

Kevin Lucero

Lic. Real Estate Salesperson

a Charlotteville Realty Team

Independently Owned & Operated

607-282-6242kevin@homesfarmsandland.com

Buying

  • Buying Form
  • Buying Process
  • Mortgage Calculator

Selling

  • Selling Form
  • Selling Process
  • Free Home Evaluation

About Us

  • Who We are
  • Meet the Team

Resources

  • Latest Blogs
  • Free Vendor List
  • PracticalGuides
  • Need Funding?
  • Property Inspector
  • Down Payment Eligibility

Communities

  • Otsego County
  • Schoharie County
  • Chenango County
  • Delaware County
  • Greene County
  • Broome County
  • Oneida County
  • Montgomery County
  • Ulster County

Disclosures

  • Standard Operating Procedure
  • NYS Buyer-Seller
  • NYS Landlord-Tenant
  • Tenant Rights Notice
  • Fair Housing Notice
  • Privacy Policy
  • Location Services
  • Properties Preferences
  • Map Data Attribution

© 2026 Homes, Farms & Land. All rights reserved.

Property at 239 Upson Road, Schuyler, NY 13340
ACTIVE
0
$949,900

239 Upson RoadSchuyler, NY, 13340

4 Beds2 Baths2,442 SqFt101.2 Acres
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. Contact the listing agent to schedule your showing.
1 / 50

Est. Monthly

$4,503/mo

$949,900

239 Upson Road, Schuyler, NY

4 Beds2 Baths2,442 SqFt101.2 Acres

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. Contact the listing agent to schedule your showing.

StatusActive
Property TypeResidential
Property SubtypeSingle Family Residence
Year Built1900
Total Rooms11 rooms
Days on Market61 days

Est. Monthly Payment

$4,502.50

%
%
yr

Private Mortgage Insurance

Not required

Affordability Checkoptional
$

Enter your annual income to check affordability

Property Details

Property Information

239 Upson Road

Schuyler, NY 13340 • Herkimer
4
Beds
2
Baths
2,442
SqFt
101.2
Acres
Status
Active
Property Type
Residential
Property Subtype
Single Family Residence
Year Built
1900126 years ago
Total Rooms
11 rooms
Days on Market
61 days
Tax History
Estimated values, may not reflect current amounts.
  • Annual Tax Amount
    $5,303
Property History
  • Listed for sale
    Mar 26, 2026 • NYSAMLS • S1669300
    $949,900
Mortgage Calculator
Estimated monthly payment for this property
$4,502.50
Down Payment
Interest Rate
Loan Term
%
%
yearsyrs.
Affordability Checkoptional
$

Enter your annual income to see if this home fits your budget

Private Mortgage Insurance

Not required — down payment above 20%
MLS Information
  • Source
    NYSAMLS
  • MLS#
    S1669300
  • Listing Office
    Empire Homes & Commercial LLC
  • Last Updated
    26 days ago

Appliances

  • Appliances
    • Dryer
    • Dishwasher
    • Electric Water Heater
    • Gas Oven
    • Gas Range
    • Microwave
    • Refrigerator
    • Wine Cooler
    • Washer

Climate & Systems

  • Heating
    • Coal
    • Oil
    • Other
    • See Remarks
    • Forced Air
    • Stove

Interior Features

  • Flooring
    • Carpet
    • Hardwood
    • Laminate
    • Varies
  • Basement
    Full
  • 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

Parking

  • Parking Features
    • Attached
    • Detached
    • Electricity
    • Garage
    • Heated Garage
    • Storage
    • Workshop In Garage
    • Water Available
  • Garage Spaces
    6

Lot & Grounds

  • Lot Size
    101.2 acres
  • Lot Features
    • Agricultural
    • Adjacent To Public Land
    • Irregular Lot
  • Patio & Porch
    Deck
  • Exterior Features
    • Blacktop Driveway
    • Deck
    • Play Structure

Type

  • Property Type
    Residential
  • Property Subtype
    Single Family Residence
  • Architectural Style
    • Colonial
    • Farmhouse
    • Two Story

Structure

  • Construction
    • Aluminum Siding
    • Attic Crawl Hatchways Insulated
    • Vinyl Siding
  • Roof
    • Asphalt
    • Metal
  • Foundation
    Stone

Condition

  • Year Built
    1900
  • Condition
    Resale
  • Days on Market
    61 days
  • Water
    Well
  • Sewer
    Septic Tank
  • Electric
    Circuit Breakers
  • Utilities
    • Cable Available
    • Electricity Connected
    • High Speed Internet Available

607-282-6242, (607) 282-6242, or +1 607 282 6242

Kevin Lucero

Kevin Lucero

Lic. Real Estate Salesperson

CallEmail
Picked for you

Similar Properties

Handpicked listings that match what you're looking at

View all →
  • 126 E Genesee Street, Manlius, NY 13066ACTIVE$855,000

    126 E Genesee Street, Manlius, NY 13066

    7 Beds4 Baths4,064 SqFt0.47 Acres

    LISTING BY HOMECOIN.COM

  • 125 Airport Road, Oneonta, NY 13820ACTIVE$855,000

    125 Airport Road, Oneonta, NY 13820

    3 Beds3.5 Baths2,190 SqFt6.355 Acres

    LISTING BY KELLER WILLIAMS UPSTATE NY PROPERTIES

  • 1 Brookhaven Court, Wilton, NY 12866ACTIVE$857,500

    1 Brookhaven Court, Wilton, NY 12866

    3 Beds3.5 Baths2,628 SqFt0.94 Acres

    LISTING BY STERLING REAL ESTATE GROUP

  • 205 Charles Herrmann Way, Milo, NY 14527ACTIVE$859,900OPEN 5/29

    205 Charles Herrmann Way, Milo, NY 14527

    Unit • 2052 Beds2 Baths1,438 SqFt22 Acres

    LISTING BY GRIFFITH REALTY GROUP

  • 13 Holbrook Drive, Rexford, NY 12148ACTIVE$860,000

    13 Holbrook Drive, Rexford, NY 12148

    5 Beds3.5 Baths2,417 SqFt0.5 Acres

    LISTING BY REMAX SOLUTIONS

  • 1340 Crestbrook Lane, Victor, NY 14564ACTIVE$864,985

    1340 Crestbrook Lane, Victor, NY 14564

    3 Beds2.5 Baths2,297 SqFt0.67 Acres

    LISTING BY WOODSTONE REALTY

  • 10 Scarlet Street, Clifton Park, NY 12065ACTIVE$865,000

    10 Scarlet Street, Clifton Park, NY 12065

    4 Beds2.5 Baths2,662 SqFt0.64 Acres

    LISTING BY HUNT REAL ESTATE ERA

  • 100 Fish Hollow Road, Chester, NY 12853ACTIVE$865,000

    100 Fish Hollow Road, Chester, NY 12853

    3 Beds3 Baths2,381 SqFt64 Acres

    LISTING BY NAJER REALTY

  • 93 Sand Hill Road, Greenfield, NY 12833ACTIVE$868,398

    93 Sand Hill Road, Greenfield, NY 12833

    3 Beds2.5 Baths2,086 SqFt4.95 Acres

    LISTING BY CARTIER REAL ESTATE GROUP LLC

  • 2774 Oneida Street, Paris, NY 13456ACTIVE$869,000

    2774 Oneida Street, Paris, NY 13456

    4 Beds2 Baths2,592 SqFt20.6 Acres

    LISTING BY COLDWELL BANKER FAITH PROPERTIES