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
- 378 days |
- 292 |
- 24 |
Zillow last checked:
Listing updated:
Listed 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-DelawareFacts & 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: 483 days
- Listing terms: Cash,Conventional,FHA,USDA Loan,VA Loan
Estimated market value
Not available
Estimated sales range
Not available
Not available
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:  HVCRMLS #145855 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
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | -- | $50,288 |
| 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
Monthly payment
Climate risks
Neighborhood: 12167
Nearby schools
GreatSchools rating
- 9/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.
- $385,3004 bd2 ba1.1k sqft884 Odell Lake Rd, Stamford, NY 12167Off Market
- $191,2004 bd1 ba1.2k sqft993 Odell Lake Rd, Stamford, NY 12167Off Market
- $175,0003 bd2 ba1.5k sqft2185 Peters Rd, Stamford, NY 12167Sold
- $608,9753 bd2 ba1.2k sqft11 Eklund Rd, Stamford, NY 12167Off Market
- $636,6383 bd1 ba2.1k sqft581 Odell Lake Rd, Stamford, NY 12167Off Market
- $281,2003 bd1 ba1k sqft1027 Odell Lake Rd, Stamford, NY 12167Off Market
- $225,9004 bd1 ba2.2k sqft1149 Odell Lake Rd, Stamford, NY 12167Off Market
- $145,6253 bd1 ba864 sqft1815 Peters Rd, Stamford, NY 12167Off Market
A local agent can set up tours, give advice and negotiate with sellers.
Similar homes
- $399,0003 bd2 ba2.1k sqft8 Van Dyke Ave, Stamford, NY 12167For Sale
MLS ID #R1688062, Benjamin Holscher, Listing by: The Holscher Group. NYSAMLSs - $380,0003 bd2 ba1.3k sqft302 Churchill Rd, Stamford, NY 12167For Sale
MLS ID #R1692010, Ann F. Kochersberger, Listing by: Windstar Realty Group LLC. NYSAMLSs - $529,0002 bd2 ba1.5k sqft400 Souer Rd, Stamford, NY 12167For Sale
MLS ID #R1697293, Evelyn Kuhn, Listing by: Keller Williams Upstate NY Properties. NYSAMLSs - $535,0004 bd3 ba1.8k sqft122 Eagle Lane, Stamford, NY 12167Active
MLS ID #20263824, Quinn Hagstrand, Listing by: BHHS HUDSON VALLEY PROP-WDST. HVCRMLS - $549,9003 bd2 ba2k sqft108 Wildberry Drive, Stamford, NY 12167ActiveMLS ID #202620451, Jessica L Becker, Listing by: Howard Hanna Capital Inc. Global MLS
- $359,0003 bd2 ba1.3k sqft31754 State Highway 23, Stamford, NY 12167For SaleMLS ID #R1670261, Evelyn Kuhn, Listing by: Keller Williams Upstate NY Properties. NYSAMLSs
- $499,9953 bd2 ba1.6k sqft1601 Narrow Notch Rd, Hobart, NY 13788For SaleMLS ID #R1678892, Joy Giannicchi, Listing by: Keller Williams Upstate NY Properties. NYSAMLSs
- $239,0003 bd3 ba1.4k sqft37 Harper St, Stamford, NY 12167For SaleMLS ID #R1692833, Diane Taylor, Listing by: Keller Williams Upstate NY Properties. NYSAMLSs
- $269,0002 bd1 ba1.1k sqft144 Easy St, Stamford, NY 12167For SaleMLS ID #R1683525, Susan L. Miller, Listing by: Windstar Realty Group LLC. NYSAMLSs
- $325,0003 bd2 ba1.3k sqft591 Cape Horn Rd, Stamford, NY 12167For SaleMLS ID #R1691428, Elizabeth A. McGuire, Listing by: Keller Williams Upstate NY Properties. NYSAMLSs
- $499,0003 bd2 ba1.3k sqft321 Allen Rd, Jefferson, NY 12093For SaleMLS ID #R1678830, Evelyn Kuhn, Listing by: Keller Williams Upstate NY Properties. NYSAMLSs
- $325,0004 bd2 ba1.5k sqft415 Cape Horn Rd, Stamford, NY 12167For SaleMLS ID #R1688254, Debbie Falcone, Listing by: Coldwell Banker Timberland Properties. NYSAMLSs
- $279,0004 bd3 ba2k sqft30 River St, Stamford, NY 12167For SaleMLS ID #R1695898, Inna Sobel, Listing by: Atelier Properties LLC. NYSAMLSs
- $329,0003 bd2 ba1.5k sqft22439 State Highway 23, Harpersfield, NY 13786For SaleMLS ID #R1680448, Diane Taylor, Listing by: Keller Williams Upstate NY Properties. NYSAMLSs
- $440,0005 bd2 ba1.5k sqft23599 State Highway 23, Harpersfield, NY 13786For SaleMLS ID #R1632320, Robert J. Schneider, Listing by: Coldwell Banker Timberland Properties. NYSAMLSs
- $495,0005 bd3 ba1.7k sqft364 Smith Rd, Worcester, NY 12197For SaleMLS ID #R1679532, William Alton, Listing by: Country Boy Realty. NYSAMLSs
- $340,0002 bd2 ba1.5k sqft298 Meade Rd, Charlotteville, NY 12036For SaleMLS ID #R1699348, Christy L. Dahms, Listing by: Charlotteville Realty, LLC. NYSAMLSs
- $350,0003 bd2 ba1k sqft372 Windsong Rd, Harpersfield, NY 13786For SaleMLS ID #R1683613, Susan L. Miller, Listing by: Windstar Realty Group LLC. NYSAMLSs
- $515,0005 bd3 ba2k sqft2240 Scotch Hill Rd, Bloomville, NY 13739For SaleMLS ID #R1691990, Michael Morgenfruh, Listing by: Frank Lumia Real Estate Plus! LLC. NYSAMLSs
- $325,0002 bd2 ba1.3k sqft1510 Town Brook Rd, Hobart, NY 13788For SaleMLS ID #R1692472, Megan Avery, Listing by: Keller Williams Upstate NY Properties. NYSAMLSs
