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.
Active
$465,000
751 Odell Lake Rd, Stamford, NY 12167
2beds
1,456sqft
Farm, Single Family Residence
Built in 1840
20.9 Acres Lot
$-- Zestimate®
$319/sqft
$-- HOA
What's special
Modern updates throughoutFruit treesFresh paintBerry bushes
- 249 days |
- 704 |
- 39 |
Zillow last checked: 9 hours ago
Listing updated: February 17, 2026 at 02:33pm
Listing by:
Keller Williams Upstate NY Properties 607-652-3311,
Gillian Karg 212-748-9413
Source: NYSAMLSs,MLS#: R1622169
Originating MLS: Otsego-Delaware
Originating MLS: Otsego-DelawareTour with a local agent
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 2
- Bathrooms: 2
- Full bathrooms: 1
- 1/2 bathrooms: 1
- Main level bathrooms: 1
- Main level bedrooms: 1
Heating
- Electric, Baseboard
Appliances
- Included: Built-In Range, Built-In Oven, Dryer, Dishwasher, Electric Cooktop, Electric Water Heater, Refrigerator, Washer
Features
- Ceiling Fan(s), Cathedral Ceiling(s), Kitchen Island, Kitchen/Family Room Combo, Bedroom on Main Level
- Flooring: Hardwood, Varies
- Basement: Partial
- Number of fireplaces: 1
Interior area
- Total structure area: 1,456
- Total interior livable area: 1,456 sqft
Property
Parking
- Total spaces: 2
- Parking features: Detached, Garage, Circular Driveway
- Garage spaces: 2
Features
- Levels: Two
- Stories: 2
- Exterior features: Dirt Driveway, Gravel Driveway
Lot
- Size: 20.9 Acres
- Dimensions: 734 x 1418
- Features: Agricultural, Irregular Lot
Details
- Parcel number: 1238890400000001094000
- Special conditions: Standard
- Horses can be raised: Yes
- Horse amenities: Horses Allowed
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Farmhouse,Two Story
- Property subtype: Farm, Single Family Residence
Materials
- Frame
- Foundation: Stone
- Roof: Metal
Condition
- Resale
- Year built: 1840
Utilities & green energy
- Sewer: Septic Tank
- Water: Well
- Utilities for property: High Speed Internet Available
Community & HOA
Location
- Region: Stamford
Financial & listing details
- Price per square foot: $319/sqft
- Tax assessed value: $50,288
- Annual tax amount: $6,322
- Date on market: 7/15/2025
- Cumulative days on market: 198 days
- Listing terms: Cash,Conventional,FHA,USDA Loan,VA Loan
Estimated market value
Not available
Estimated sales range
Not available
Not available
Price history
Price history
| Date | Event | Price |
|---|---|---|
| 9/15/2025 | Price change | $465,000-2.1%$319/sqft |
Source:  NYSAMLSs #R1622169 Report a problem | ||
| 7/15/2025 | Listed for sale | $475,000-4%$326/sqft |
Source: NYSAMLSs #R1622169 Report a problem | ||
| 7/9/2025 | Listing removed | $495,000$340/sqft |
Source: NYSAMLSs #R1594274 Report a problem | ||
| 6/27/2025 | Price change | $495,000-5.7%$340/sqft |
Source: NYSAMLSs #R1594274 Report a problem | ||
| 3/20/2025 | Listed for sale | $525,000+1.2%$361/sqft |
Source: NYSAMLSs #R1594274 Report a problem | ||
| 9/5/2023 | Sold | $519,000-3.9%$356/sqft |
Source: NYSAMLSs #R1462799 Report a problem | ||
| 7/25/2023 | Pending sale | $539,990$371/sqft |
Source: NYSAMLSs #R1462799 Report a problem | ||
| 7/24/2023 | Contingent | $539,990$371/sqft |
Source:  Columbia Greene Northern Dutchess MLS #145855 Report a problem | ||
| 7/19/2023 | Pending sale | $539,990$371/sqft |
Source:  OneKey® MLS as distributed by MLS GRID #H6240930 Report a problem | ||
| 5/25/2023 | Price change | $539,990-1.8%$371/sqft |
Source:  Global MLS #202314273 Report a problem | ||
| 5/11/2023 | Pending sale | $550,000$378/sqft |
Source: NYSAMLSs #R1462799 Report a problem | ||
| 5/11/2023 | Contingent | $550,000$378/sqft |
Source: Columbia Greene Northern Dutchess MLS #145855 Report a problem | ||
| 4/4/2023 | Listed for sale | $550,000$378/sqft |
Source: Global MLS #202314273 Report a problem | ||
| 11/22/2022 | Listing removed | -- |
Source: ODBR #135947 Report a problem | ||
| 8/9/2022 | Listed for sale | $550,000+257.1%$378/sqft |
Source: ODBR #135947 Report a problem | ||
| 9/19/2018 | Sold | $154,000+71.1%$106/sqft |
Source: Public Record Report a problem | ||
| 5/3/2013 | Sold | $90,000$62/sqft |
Source: Public Record Report a problem | ||
Public tax history
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2024 | -- | $50,288 +27.2% |
| 2023 | -- | $39,535 |
| 2022 | -- | $39,535 |
| 2021 | -- | $39,535 |
| 2020 | -- | $39,535 +14.5% |
| 2019 | -- | $34,535 |
| 2018 | -- | $34,535 |
| 2017 | $3,156 | $34,535 |
| 2016 | -- | $34,535 |
| 2015 | -- | $34,535 +8.3% |
| 2014 | -- | $31,900 -5.9% |
| 2013 | -- | $33,900 |
| 2012 | -- | $33,900 |
| 2011 | -- | $33,900 +6.3% |
| 2010 | -- | $31,900 |
| 2009 | -- | $31,900 |
| 2008 | -- | $31,900 |
| 2007 | -- | $31,900 |
| 2006 | -- | $31,900 +10% |
| 2005 | -- | $29,000 |
| 2004 | -- | $29,000 +7.4% |
| 2003 | -- | $27,000 |
| 2002 | -- | $27,000 |
| 2001 | -- | $27,000 |
| 2000 | -- | $27,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: 12167
Nearby schools
GreatSchools rating
- 8/10Stamford Central SchoolGrades: PK-12Distance: 2.6 mi
Schools provided by the listing agent
- District: Stamford
Source: NYSAMLSs. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
Local experts in 12167
- New York
- Delaware County
- Stamford
- 12167
- 751 Odell Lake Rd
Nearby cities
Nearby zip codes
Other Stamford Topics
