Views - Primary on Main
Address
239 Upson Road, Schuyler, NY
Price
$ 899,900
Property Attributes
- MLS#S1715254
- TypeSingle Family
- Listing Status Active
- CountyHERKIMER
- CitySchuyler
- AreaSchuyler
- Zip13340
- StyleColonial,Farmhouse,TwoStory
- Year Built1900
- Taxes$ 5303
- Price$ 899,900
- Bedrooms4
- Full Bathrooms2
- Half Bathrooms0
- Sqr Footage2442
- Lot Size101.2 Acres
Data Source:
Central New York Information Services (CNYIS)
Property 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. Contact the listing agent to schedule your showing.
| Price History | |
|---|---|
| 9/16/2026 | Listed $899,900 |
General Features
| Sewer | SepticTank |
|---|---|
| Heating | Coal,Oil,Other,SeeRemarks,ForcedAir,Stove |
| Cooling | Other,SeeRemarks |
| Utilities | CableAvailable,ElectricityConnected,HighSpeedInternetAvailable |
| Possession | CloseOfEscrow |
| Roof | Asphalt,Metal |
| Appliances | Dryer,Dishwasher,ElectricWaterHeater,GasOven,GasRange,Microwave,Refrigerator,WineCooler,Washer |
| Garage Spaces | 6.0 |
| Patio/Porch Features | Deck |
| Architectural Style | Colonial,Farmhouse,TwoStory |
| Construction Materials | AluminumSiding,AtticCrawlHatchwaysInsulated,VinylSiding |
| School District | Frankfort-Schuyler |
| Year Built | 1900 |
| Electric | CircuitBreakers |
| View | SlopeView |
| Stories Count | 2 |
| Township | Not Applicable |
| Levels | Two |
| Property Subtype | SingleFamilyResidence |
| Accessibility | AccessibleBedroom |
| Additional Parcels Description | 214800-105-002-0001-008-200-0000 |
| County | Herkimer |
| Property Type | Residential |
| Attached Garage | Yes |
| Garage Y/N | Yes |
| Other Structures | Barns,Outbuilding,GarageApartment |
| Total Rooms | 11 |
| Full Baths | 2 |
| Status | Active |
| Directions | From Herkimer take Steuben Hill Rd to Upson Rd |
| City | Schuyler |
| Senior Community Y/N | No |
| High School District | Frankfort-Schuyler |
| MLS Area | Schuyler-214800 |
| Lot Size Units | Acres |
| Lot Size Square Feet | 217800.0 |
| Year Built Details | Existing |
| Tax Annual Amount | 5303.0 |
| Property Condition | Resale |
| Virtual Tour | https://www.propertypanorama.com/instaview/syr/S1715254 |
| Standard Status | Active |
| Middle/Junior School District | Frankfort-Schuyler |
| Elementary School District | Frankfort-Schuyler |
| Tax Assessed Value | 80000 |
| TaxOtherAnnualAssessmentAmount | 0.0 |
| Tax Lot | 8 |
Interior Features
| Interior Amenities | BreakfastBar,CeilingFans,DryBar,SeparateFormalDiningRoom,EatInKitchen,SeparateFormalLivingRoom,KitchenIsland,QuartzCounters,Storage,NaturalWoodwork,BedroomOnMainLevel |
|---|---|
| Basement | Full |
| Flooring | Carpet,Hardwood,Laminate,Varies |
| Total Fireplaces | 3 |
| Total Stories | 2 |
| Basement (Y/N) | Yes |
| Heating Y/N | Yes |
| Fireplace Y/N | Yes |
| Laundry Features | MainLevel |
| Total Bedrooms | 4 |
| Main Level Bedrooms | 1 |
| Main Level Bathrooms | 1 |
| Total Baths | 2 |
Exterior Features
| Exterior Amenities | BlacktopDriveway,Deck,PlayStructure |
|---|---|
| Parking Features | Attached,Detached,Electricity,Garage,HeatedGarage,Storage,WorkshopInGarage,WaterAvailable |
| Lot Features | Agricultural,AdjacentToPublicLand,IrregularLot,Wooded |
| Water Source | Well |
| Lot Size Area | 101.2 |
| Foundation Details | Stone |
| Building Area Total | 2442.0 |
| Lot Dimensions | 4285X2543 |
| Lot Size Acres | 101.2 |
| Waterfront Y/N | No |
| Horse Y/N | Yes |
| Horse Amenities | HorsesAllowed |
Amenities
- Foreclosure
- Views
- Short Sale
- New Construction
- Adult 55+
- Lease To Own
- No HOA Fees
- Furnished
- Primary On Main
- Air Conditioning
- Seller Finance
- Green
- Fixer Upper
- Horse
- Golf
- Fireplace
- Deck
- Garage
- Basement
- Pool
Property vs Single Family Average in 13340
Price
Taxes
Year Built
The Greater Syracuse Association of REALTORS ®: The data relating to real estate on this web site comes in part from the Internet Data Exchange (IDX) Program of the CNYIS, powered by CNYIS. Real estate listings held by firms other than Berkshire Hathaway HomeServices Zambito, REALTORS® - Medina, are marked with the IDX logo and detailed information about them includes the Listing Broker's Firm Name. All information deemed reliable but not guaranteed and should be independently verified. All properties
The data relating to real estate on this web site comes in part from the Internet Data Exchange (IDX) Program of NYSAMLS. Real estate listings held by firms other than Berkshire Hathaway HomeServices Zambito, REALTORS® - Medina, are marked with the IDX logo and detailed information about them includes the Listing Brokers Firm Name.
Disclaimer: All information deemed reliable but not guaranteed and should be independently verified. All properties are subject to prior sale, change or withdrawal.
