HOMESFARMSANDLAND
BuySell
    • Featured Properties
    • Property Showcases
    • Latest Blogs
      • Overview
      • Explore Open Houses
      • Discover Rental Living
      • Escape to Cabin Life
      • Unlock Multi-Family Living
      • Your Perfect Land Awaits
      • Embrace Farm Life
      • Overview
      • Find Rentals
      • Find Cabins
      • Browse Homes
      • Browse Farms
      • Browse Lands
    • Saved Properties
    • Overview
    • Buying Form
    • Buying Process
    • Mortgage Calculator
    • Overview
    • Selling Form
    • Selling Process
    • Free Home Evaluation
      • All of Otsego
      • Cooperstown
      • Oneonta
      • West Oneonta
      • Milford
      • Hartwick
      • Worcester
      • Unadilla
      • Laurens
      • Richfield Springs
      • All of Schoharie
      • Cobleskill
      • Middleburgh
      • Schoharie
      • Sharon Springs
      • Summit
      • Richmondville
      • Esperance
      • All of Chenango
      • Norwich
      • Oxford
      • Greene
      • Bainbridge
      • Sherburne
      • All of Delaware
      • Delhi
      • Stamford
      • Andes
      • Walton
      • Margaretville
      • Roxbury
      • Sidney
      • All of Greene
      • Catskill
      • Windham
      • Hunter
      • Cairo
      • Coxsackie
      • Athens
      • All of Broome
      • Binghamton
      • Vestal
      • Endicott
      • All of Oneida
      • New Hartford
      • Utica
      • Marcy
      • Clinton
      • All of Montgomery
      • Amsterdam
      • Fort Plain
      • Canajoharie
      • Fonda
      • All of Ulster
      • Kingston
      • New Paltz
      • Saugerties
      • Woodstock
      • Marlborough
    • Overview
    • Free Vendor List
    • Practical Guides
    • Need Funding?
    • Property Inspector
    • Down Payment Eligibility
    • Location Sharing?
      • Overview
      • Standard Operating Procedure
      • NYS Buyer-Seller
      • NYS Landlord-Tenant
      • Tenant Rights Notice
      • Fair Housing Notice
      • Privacy Policy
      • Location Services
      • Properties Preferences
      • Map Data Attribution
    • Who We Are
    • Meet the Team
Featured
Featured Properties
Property Showcases
Latest Blogs
Search
Advanced Search
Explore Open Houses
Discover Rental Living
Escape to Cabin Life
Unlock Multi-Family Living
Your Perfect Land Awaits
Embrace Farm Life
Search by Map
Find Rentals
Find Cabins
Browse Homes
Browse Farms
Browse Lands
Saved Properties
Buy
Buying Form
Buying Process
Mortgage Calculator
Sell
Selling Form
Selling Process
Free Home Evaluation
HOMESFARMSANDLAND
  • Otsego
  • Schoharie
  • Chenango
  • Delaware
  • Greene
  • Broome
  • Oneida
  • Montgomery
  • Ulster

Select a county to see cities

Resources
Free Vendor List
Practical Guides
Need Funding?
Property Inspector
Down Payment Eligibility
Location Sharing?
Disclosures
Standard Operating Procedure
NYS Buyer-Seller
NYS Landlord-Tenant
Tenant Rights Notice
Fair Housing Notice
Privacy Policy
Location Services
Properties Preferences
Map Data Attribution
About
Who We Are
Meet the Team

Let's Find Your Next Property.

HOMESFARMSANDLAND.COM

Kevin Lucero

Lic. Real Estate Salesperson

a Charlotteville Realty Team

Independently Owned & Operated

607-282-6242kevin@homesfarmsandland.com

Buying

  • Buying Form
  • Buying Process
  • Mortgage Calculator

Selling

  • Selling Form
  • Selling Process
  • Free Home Evaluation

About Us

  • Who We are
  • Meet the Team

Resources

  • Latest Blogs
  • Free Vendor List
  • PracticalGuides
  • Need Funding?
  • Property Inspector
  • Down Payment Eligibility

Communities

  • Otsego County
  • Schoharie County
  • Chenango County
  • Delaware County
  • Greene County
  • Broome County
  • Oneida County
  • Montgomery County
  • Ulster County

Disclosures

  • Standard Operating Procedure
  • NYS Buyer-Seller
  • NYS Landlord-Tenant
  • Tenant Rights Notice
  • Fair Housing Notice
  • Privacy Policy
  • Location Services
  • Properties Preferences
  • Map Data Attribution

© 2026 Homes, Farms & Land. All rights reserved.

Property at 171 Cornell Avenue, Stamford, NY 13788
ACTIVE
0
$529,000

171 Cornell AvenueStamford, NY, 13788

5 Beds4 Baths6,934 SqFt2.94 Acres
ULTIMATE CATSKILLS HOSPITALITY COMPOUND: 7-ROOM BOUTIQUE HOTEL + 5 INCOME UNITS Commercial investors and hospitality visionaries, secure a lucrative opportunity in the booming Catskills market. Historically known as the "House on the Hill," this landmark 1886 property spans 3 pristine acres of unrestricted potential in Hobart’s historic Book Village. It delivers an immediate, turnkey income revenue from five completely renovated, fully occupied independent apartments. Massive financial upside awaits an investor ready to more than double this active rental income simply by transitioning these five turnkey units into high-occupancy short-term vacation rentals. Beyond the steady apartment income, the main building is a hospitality developer’s dream: masterfully reconfigured into seven full hotel rooms, with a private, high-end luxury bathroom added to units. Complete with a large eat-in country kitchen kitchen featuring dual independent ranges, the layout is perfectly curated for an all-inclusive boutique hotel, B&B, or event compound. A massive, permanent profit driver is right at your doorstep: the region's premier wedding industry is booming, and local barn and farm venues draw massive crowds but face a severe lodging shortage. This compound perfectly captures that market as an inclusive event space to host welcome parties, morning-after brunches, & guest lodging. The striking aesthetic and natural light also make it an ideal destination for high-end commercial photoshoots and mid-week corporate retreats looking for a Upstate escape. The exceptionally guest-friendly layout includes a private rear staircase flowing straight into the kitchen, ensuring maximum privacy for guest groups. The expansive 3-acre grounds offer a magnificent blank canvas to create an enclosed resort compound complete with pathways, fire pits, curated gardens, and offshoot tiny homes or cabin rentals. Positioned in an ever-growing tourist corridor between Margaretville, Delhi, and Stamford, the location captures permanent, four-season drivers, sitting directly between 4 premier ski mountains and right off major regional snowmobile trails. Schedule your tour today!
1 / 50

Est. Monthly

$2,507/MO

$529,000

171 Cornell Avenue, Stamford, NY

5 Beds4 Baths6,934 SqFt2.94 Acres

ULTIMATE CATSKILLS HOSPITALITY COMPOUND: 7-ROOM BOUTIQUE HOTEL + 5 INCOME UNITS Commercial investors and hospitality visionaries, secure a lucrative opportunity in the booming Catskills market. Historically known as the "House on the Hill," this landmark 1886 property spans 3 pristine acres of unrestricted potential in Hobart’s historic Book Village. It delivers an immediate, turnkey income revenue from five completely renovated, fully occupied independent apartments. Massive financial upside awaits an investor ready to more than double this active rental income simply by transitioning these five turnkey units into high-occupancy short-term vacation rentals. Beyond the steady apartment income, the main building is a hospitality developer’s dream: masterfully reconfigured into seven full hotel rooms, with a private, high-end luxury bathroom added to units. Complete with a large eat-in country kitchen kitchen featuring dual independent ranges, the layout is perfectly curated for an all-inclusive boutique hotel, B&B, or event compound. A massive, permanent profit driver is right at your doorstep: the region's premier wedding industry is booming, and local barn and farm venues draw massive crowds but face a severe lodging shortage. This compound perfectly captures that market as an inclusive event space to host welcome parties, morning-after brunches, & guest lodging. The striking aesthetic and natural light also make it an ideal destination for high-end commercial photoshoots and mid-week corporate retreats looking for a Upstate escape. The exceptionally guest-friendly layout includes a private rear staircase flowing straight into the kitchen, ensuring maximum privacy for guest groups. The expansive 3-acre grounds offer a magnificent blank canvas to create an enclosed resort compound complete with pathways, fire pits, curated gardens, and offshoot tiny homes or cabin rentals. Positioned in an ever-growing tourist corridor between Margaretville, Delhi, and Stamford, the location captures permanent, four-season drivers, sitting directly between 4 premier ski mountains and right off major regional snowmobile trails. Schedule your tour today!

StatusActive
Property TypeResidential
Property SubtypeMulti Family
Year Built1886

Est. Monthly Payment

$2,507.45

%
%
yr

Private Mortgage Insurance

Not required

Affordability Checkoptional
$

Enter your annual income to check affordability

Property Details

Property Information

171 Cornell Avenue

Stamford, NY 13788 • Delaware
5
Beds
4
Baths
6,934
SqFt
2.94
Acres
Status
Active
Property Type
Residential
Property Subtype
Multi Family
Year Built
1886140 years ago
Tax History
Estimated values, may not reflect current amounts.
  • Annual Tax Amount
    $6,700
Property History
  • Listed for sale
    Jun 14, 2026 • NYSAMLS • R1690543
    $529,000
Mortgage Calculator
Estimated monthly payment for this property
$2,507.45
Down Payment
Interest Rate
Loan Term
%
%
yearsyrs.
Affordability Checkoptional
$

Enter your annual income to see if this home fits your budget

Private Mortgage Insurance

Not required — down payment above 20%
MLS Information
  • Source
    NYSAMLS
  • MLS#
    R1690543
  • Listing Office
    Jewett and Jewett LLC
  • Last Updated
    18 minutes ago

Appliances

  • Appliances
    • Oil Water Heater
    • Propane Water Heater

Climate & Systems

  • Heating
    • Propane
    • Oil
    • Steam

Interior Features

  • Flooring
    • Hardwood
    • Varies
  • Basement
    Full
  • Interior Features
    Attic

Parking

  • Parking Features
    • Gravel
    • Unpaved

Lot & Grounds

  • Lot Size
    2.94 acres
  • Lot Features
    • Cul De Sac
    • Irregular Lot
    • Residential Lot
  • Exterior Features
    Propane Tank Leased

Type

  • Property Type
    Residential
  • Property Subtype
    Multi Family

Structure

  • Construction
    • Attic Crawl Hatchways Insulated
    • Frame
    • Structural Insulated Panels
    • Vinyl Siding
  • Roof
    • Membrane
    • Metal
    • Rubber
    • Rolled Hot Mop

Condition

  • Year Built
    1886
  • Condition
    Resale
  • Water
    Connected
  • Sewer
    Connected
  • Utilities
    • Sewer Connected
    • Water Connected
Also Listed On
  • NYSAMLS
    1 related listing
    Active$529,000

607-282-6242, (607) 282-6242, or +1 607 282 6242

Kevin Lucero

Kevin Lucero

Lic. Real Estate Salesperson

CallEmail
Picked for you

Similar Properties

Handpicked listings that match what you're looking at

View all →
  • 272 Linden Street, Rochester, NY 14620ACTIVE$479,900

    272 Linden Street, Rochester, NY 14620

    3 Beds4 Baths4,418 SqFt0.1053 Acres

    LISTING BY AGENCY 1 LLC

  • 0 E Seneca Road, Ulysses, NY 14886ACTIVE$480,000

    0 E Seneca Road, Ulysses, NY 14886

    LandMulti Family16.04 Acres

    LISTING BY WARREN REAL ESTATE OF ITHACA INC.

  • 709 Clarendon Street, Syracuse, NY 13210ACTIVE$483,000

    709 Clarendon Street, Syracuse, NY 13210

    Unit • 117 Beds2 Baths2,744 SqFt0.1146 Acres

    LISTING BY ACROPOLIS REALTY GROUP LLC

  • 155 Church Avenue, Ballston Spa, NY 12020ACTIVE$489,999

    155 Church Avenue, Ballston Spa, NY 12020

    7 Beds5.5 Baths2,400 SqFt0.5 Acres

    LISTING BY SARATOGA REAL PROPERTY, INC.

  • 918 Danby Road, Ithaca Town, NY 14850ACTIVE$495,000

    918 Danby Road, Ithaca Town, NY 14850

    Unit • 1-28 Beds3.5 Baths2,859 SqFt0.5 Acres

    LISTING BY KELLER WILLIAMS REALTY

  • 714 Union Street, Schenectady, NY 12305ACTIVE$495,000

    714 Union Street, Schenectady, NY 12305

    6 Beds5 Baths2,932 SqFt0.09 Acres

    LISTING BY ADVANCED PROPERTY MANAGEMENT

  • 40 Princeton Place, Orchard Park, NY 14127ACTIVE$499,000

    40 Princeton Place, Orchard Park, NY 14127

    5 Beds4 Baths3,176 SqFt0.2479 Acres

    LISTING BY EXCHANGE REAL ESTATE INC.

  • 1712 Como Park Boulevard, Lancaster, NY 14043ACTIVE$499,000

    1712 Como Park Boulevard, Lancaster, NY 14043

    6 Beds3 Baths2,268 SqFt0.32 Acres

    LISTING BY WN YBY OWNER.COM

  • 560 Clarendon Street, Syracuse, NY 13210ACTIVE$499,000

    560 Clarendon Street, Syracuse, NY 13210

    Unit • 647 Beds3 Baths2,990 SqFt0.1004 Acres

    LISTING BY UNIVERSITY HILL REALTY LTD

  • 556 Clarendon Street, Syracuse, NY 13210ACTIVE$499,000

    556 Clarendon Street, Syracuse, NY 13210

    Unit • 587 Beds3 Baths3,162 SqFt0.1004 Acres

    LISTING BY UNIVERSITY HILL REALTY LTD