Active
239 Upson Road, Schuyler NY 13340
MLS# S1656319
$975,000
Price
4
Beds
2
Baths
2,442
Living Area (Sq.Ft.)
101.2
Lot Area (Acres)
$975,000
Price
4
Beds
2
Baths
2,442
Living Area (Sq.Ft.)
101.2
Lot Area (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. 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.
Status
Active
Property Type
Residential
Property Sub Type
SingleFamilyResidence
Year Built
1900
Parcel Number
214800-105-002-0001-008-300-0000
Unit Number
--
Lot Features
Agricultural, Adjacent To Public Land, Irregular Lot
Levels
Two
Building Area Source
PublicRecords
Lot Size Dimensions
4285X2543
Stories
2
Bath Rooms Full
2
Main Level Bathrooms
1
Main Level Bedrooms
1
Property Condition
Resale
Elementary School District
Frankfort-Schuyler
Middle Or Junior School District
Frankfort-Schuyler
High School District
Frankfort-Schuyler
Location
Listing Agent
Abby Hnydowitz
Listing Office
Empire Homes & Commercial LLC
Owner Name
--
Owner Phone
--
Possession
CloseOfEscrow
Special Listing Conditions
Standard
Listing Terms
Cash, Conventional, F H A, Usda Loan, Va Loan
Listing Agreement
ExclusiveRightToSell
Listing Contract Date
2026-01-02
Fire Places Total
3
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
Flooring
Carpet, Hardwood, Laminate, Varies
Laundry Features
Main Level
Fire Place
true
Cooling Features
Other,SeeRemarks
Heating
true
Heating Features
Coal, Oil, Other, See Remarks, Forced Air, Stove
Accessibility Features
Accessible Bedroom
Appliances
Dryer, Dishwasher, Electric Water Heater, Gas Oven, Gas Range, Microwave, Refrigerator, Wine Cooler, Washer
Electric
Circuit Breakers
Garage
true
Garage Spaces
6
Architectural Style
Colonial, Farmhouse, Two Story
Exterior Features
Blacktop Driveway, Deck, Play Structure
Water Source
Well
Sewer
SepticTank
Roof
Asphalt, Metal
Other Structures
Barns,Outbuilding,GarageApartment
Utilities
Cable Available, Electricity Connected, High Speed Internet Available
Parking Features
Attached, Detached, Electricity, Garage, Heated Garage, Storage, Workshop In Garage, Water Available
Attached Garage
true
Foundation Details
Stone
Basement
Full
Construction Materials
Aluminum Siding, Attic Crawl Hatchways Insulated, Vinyl Siding
Patio And Porch Features
Deck
No schools found
Information deemed reliable but not guaranteed. IDX data © 2019 REIS MLS. All rights reserved. The data relating to real estate for sale on this web site comes in part from the Broker Reciprocity Program of the REIS MLS. Real estate listings held by brokerage firms and are marked with the Broker Reciprocity logo or the Broker Reciprocity thumbnail logo (a little black house) and detailed information about them includes the name of the listing brokers. Realoq is not a Multiple Listing Service, nor does it offer MLS access. This website is a service of Realoq, a service company Participant of the REIS MLS. Information deemed reliable but not guaranteed. Data updated daily; data last updated .
Digital Millennium Copyright Act (DMCA) Notice
The Digital Millennium Copyright Act of 1998, 17 U.S.C. § 512 (the "DMCA"), provides recourse for copyright owners who believe that material appearing on the Internet infringes their rights under U.S. copyright law. If you believe in good faith that any content or material made available in connection with our website or services infringes your copyright, you (or your agent) may send us a notice requesting that the content or material be removed, or access to it blocked. Notices and counter-notices should be sent in writing by mail to DMCA Designated Agent.
The DMCA requires that your notice of alleged copyright infringement include the following information: (1) description of the copyrighted work that is the subject of claimed infringement; (2) description of the alleged infringing content and information sufficient to permit us to locate the content; (3) contact information for you, including your address, telephone number and e-mail address; (4) a statement by you that you have a good faith belief that the content in the manner complained of is not authorized by the copyright owner, or its agent, or by the operation of any law; (5) a statement by you, signed under penalty of perjury, that the information in the notification is accurate and that you have the authority to enforce the copyrights that are claimed to be infringed; and (6) a physical or electronic signature of the copyright owner or a person authorized to act on the copyright owner's behalf. Failure to include all of the above information may result in the delay of the processing of your complaint.
Listed By
Information deemed reliable but not guaranteed. IDX data © 2019 REIS MLS. All rights reserved. The data relating to real estate for sale on this web site comes in part from the Broker Reciprocity Program of the REIS MLS. Real estate listings held by brokerage firms and are marked with the Broker Reciprocity logo or the Broker Reciprocity thumbnail logo (a little black house) and detailed information about them includes the name of the listing brokers. Realoq is not a Multiple Listing Service, nor does it offer MLS access. This website is a service of Realoq, a service company Participant of the REIS MLS. Information deemed reliable but not guaranteed. Data updated daily; data last updated .
Digital Millennium Copyright Act (DMCA) Notice
The Digital Millennium Copyright Act of 1998, 17 U.S.C. § 512 (the "DMCA"), provides recourse for copyright owners who believe that material appearing on the Internet infringes their rights under U.S. copyright law. If you believe in good faith that any content or material made available in connection with our website or services infringes your copyright, you (or your agent) may send us a notice requesting that the content or material be removed, or access to it blocked. Notices and counter-notices should be sent in writing by mail to DMCA Designated Agent.
The DMCA requires that your notice of alleged copyright infringement include the following information: (1) description of the copyrighted work that is the subject of claimed infringement; (2) description of the alleged infringing content and information sufficient to permit us to locate the content; (3) contact information for you, including your address, telephone number and e-mail address; (4) a statement by you that you have a good faith belief that the content in the manner complained of is not authorized by the copyright owner, or its agent, or by the operation of any law; (5) a statement by you, signed under penalty of perjury, that the information in the notification is accurate and that you have the authority to enforce the copyrights that are claimed to be infringed; and (6) a physical or electronic signature of the copyright owner or a person authorized to act on the copyright owner's behalf. Failure to include all of the above information may result in the delay of the processing of your complaint.