Active
MLS# R1622169
$465,000
Price
2
Beds
2
Baths
1,456
Living Area (Sq.Ft.)
20.9
Lot Area (Acres)
$465,000
Price
2
Beds
2
Baths
1,456
Living Area (Sq.Ft.)
20.9
Lot Area (Acres)
ALL OFFERS CONSIDERED! Turnkey, fully furnished 5-star Airbnb set on 20+ recreational acres with Catskill Mountain views, a pond, fruit trees, berry bushes, and 500+ planted Christmas trees (income potential!). Beautifully renovated 1840s farmhouse featuring 2 beds, 1.5 baths, fresh paint, and modern updates throughout. Major upgrades include new LP Smart Siding, new electric baseboard heaters, and a new 50-gallon hot water heater, plus brand new septic, new flooring in both bedrooms, and new gutters & French drains. Property includes a 3-bay, 3-story barn/garage with electric and water lines run (ready to connect), plus a road to a covered RV pad with electric hookups. Proven Airbnb income with additional RV pad rental potential. Minutes to Stamford Village, 30 min to Oneonta, 3 hrs to GWB, 1 hr 20 min to Albany, and 3 ski mountains within 40 min.
Status
Active
Property Type
Residential
Property Sub Type
SingleFamilyResidence
Year Built
1840
Parcel Number
123889-040-000-0001-094-000
Unit Number
--
Lot Features
Agricultural, Irregular Lot
Levels
Two
Building Area Source
Other
Lot Size Dimensions
734X1418
Stories
2
Bath Rooms Full
1
Bath Rooms Half
1
Main Level Bathrooms
1
Main Level Bedrooms
1
Property Condition
Resale
Elementary School District
Stamford
Middle Or Junior School District
Stamford
High School District
Stamford
Location

Listing Agent
Gillian Karg
Listing Office
Keller Williams Upstate NY Properties
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
2025-07-15
Fire Places Total
1
Interior Features
Ceiling Fans, Cathedral Ceilings, Kitchen Island, Kitchen Family Room Combo, Bedroom On Main Level
Flooring
Hardwood, Varies
Fire Place
true
Heating
true
Heating Features
Electric, Baseboard
Appliances
Built In Range, Built In Oven, Dryer, Dishwasher, Electric Cooktop, Electric Water Heater, Refrigerator, Washer
Garage
true
Garage Spaces
2
Architectural Style
Farmhouse, Two Story
Exterior Features
Dirt Driveway, Gravel Driveway
Water Source
Well
Sewer
SepticTank
Roof
Metal
Utilities
High Speed Internet Available
Parking Features
Detached, Garage, Circular Driveway
Foundation Details
Stone
Basement
Partial
Construction Materials
Frame
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.

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.