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

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

Layout spacer

    Layout spacer

      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 123 Forest Lake Road, Warrensburg, NY 12817
      ACTIVE
      0
      $659,000

      123 Forest Lake RoadWarrensburg, NY, 12817

      5 Beds4 Baths2,594 SqFt3.43 Acres
      Charming and fully renovated, this private retreat sits on 3.43 serene acres and features a 3-bedroom, 3-bath main home with a finished basement, alongside a 2-bedroom, 1-bath guest house complete with a 3-car garage and a screened-in porch. The combined living space is approximately 4,000 square feet. Enjoy the tranquility of a secluded setting that's still close to amenities, making it ideal as a getaway home or an Airbnb, with flexible living spaces and exceptional potential for rental income.
      1 / 54

      Est. Monthly

      $3,124/mo

      $659,000

      123 Forest Lake Road, Warrensburg, NY

      5 Beds4 Baths2,594 SqFt3.43 Acres

      Charming and fully renovated, this private retreat sits on 3.43 serene acres and features a 3-bedroom, 3-bath main home with a finished basement, alongside a 2-bedroom, 1-bath guest house complete with a 3-car garage and a screened-in porch. The combined living space is approximately 4,000 square feet. Enjoy the tranquility of a secluded setting that's still close to amenities, making it ideal as a getaway home or an Airbnb, with flexible living spaces and exceptional potential for rental income.

      StatusActive
      Property TypeResidential
      Property SubtypeSingle Family Residence
      Year Built1991
      Total Rooms14 rooms
      Days on Market116 days

      Est. Monthly Payment

      $3,123.64

      %
      %
      yr

      Private Mortgage Insurance

      Not required

      Affordability Checkoptional
      $

      Enter your annual income to check affordability

      Property Details

      Property Information

      123 Forest Lake Road

      Warrensburg, NY 12817 • Warren
      5
      Beds
      4
      Baths
      2,594
      SqFt
      3.43
      Acres
      Status
      Active
      Property Type
      Residential
      Property Subtype
      Single Family Residence
      Year Built
      199135 years ago
      Total Rooms
      14 rooms
      Days on Market
      116 days
      Tax History
      Estimated values, may not reflect current amounts.
      • Annual Tax Amount
        $10,395
      Property History
      • Listed for sale
        Jan 22, 2026 • GLOBAL MLS • 202610907
        $659,000
      Mortgage Calculator
      Estimated monthly payment for this property
      $3,123.64
      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
        Global MLS
      • MLS#
        202610907
      • Listing Office
        Schermerhorn Realty Group LLC
      • Last Updated
        113 days ago

      Appliances

      • Appliances
        • Range
        • Refrigerator
        • Washer
        • Dishwasher
        • Dryer
        • Microwave
        • Tankless Water Heater
        • Oven

      Climate & Systems

      • Heating
        • Baseboard
        • Hot Water
        • Radiant
        • Zoned

      Interior Features

      • Basement
        • Full
        • Finished
        • Heated

      Parking

      • Parking Features
        • Off Street
        • Driveway
      • Parking Spaces
        10
      • Garage Spaces
        3

      Lot & Grounds

      • Lot Size
        3.43 acres
      • View
        Pond
      • Exterior Features
        Lighting

      Type

      • Property Type
        Residential
      • Property Subtype
        Single Family Residence
      • Architectural Style
        Raised Ranch

      Structure

      • Construction
        • Other
        • Vinyl Siding

      Condition

      • Year Built
        1991
      • Days on Market
        116 days
      • Water
        Well
      • Sewer
        Septic Tank

      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 →
      • 70 Chase Meadow Trail Lot 100, Mendon, NY 14472ACTIVE$594,900

        70 Chase Meadow Trail Lot 100, Mendon, NY 14472

        4 Beds2.5 Baths2,338 SqFt

        LISTING BY HOWARD HANNA

      • 35 Thunder Ridge Drive, Rush, NY 14543ACTIVE$595,000

        35 Thunder Ridge Drive, Rush, NY 14543

        3 Beds2.5 Baths2,486 SqFt1.42 Acres

        LISTING BY JUDY'S BROKER NETWORK LLC

      • 44 Crescent Hill Road, Perinton, NY 14534ACTIVE$595,000

        44 Crescent Hill Road, Perinton, NY 14534

        5 Beds3.5 Baths3,644 SqFt1.4 Acres

        LISTING BY HOWARD HANNA

      • 2367 Hess Road, Newfane, NY 14008ACTIVE$595,000

        2367 Hess Road, Newfane, NY 14008

        4 Beds2.5 Baths2,412 SqFt52.3 Acres

        LISTING BY HUNT REAL ESTATE CORPORATION

      • 1944 State Route 28 OLD FORGE, Webb, NY 13420ACTIVE$595,000OPEN 5/22

        1944 State Route 28 OLD FORGE, Webb, NY 13420

        3 Beds2.5 Baths1,807 SqFt1.6 Acres

        LISTING BY KELLER WILLIAMS REALTY GATEWAY

      • 460 Stover Road, Tyrone, NY 14815ACTIVE$595,000

        460 Stover Road, Tyrone, NY 14815

        3 Beds2 Baths1,040 SqFt0.12 Acres

        LISTING BY KEUKA LAKE & LAND REALTY

      • 311 Ortner Road, Bennington, NY 14040ACTIVE$595,000

        311 Ortner Road, Bennington, NY 14040

        4 Beds2 Baths1,525 SqFt17.13 Acres

        LISTING BY RIVELLINO REALTY

      • 1569 Hoosick Road, Brunswick, NY 12180ACTIVE$595,000

        1569 Hoosick Road, Brunswick, NY 12180

        3 Beds2.5 Baths3,444 SqFt18.8 Acres

        LISTING BY HOULIHAN LAWRENCE

      • 265 Nine Mile Tree Road, Mayfield, NY 12078ACTIVE$595,000

        265 Nine Mile Tree Road, Mayfield, NY 12078

        3 Beds2 Baths1,700 SqFt1.16 Acres

        LISTING BY ROOHAN REALTY

      • 149 Peck Road, Windham, NY 12496ACTIVE$595,000

        149 Peck Road, Windham, NY 12496

        3 Beds2.5 Baths1,545 SqFt5.2 Acres

        LISTING BY GILCREST PROPERTIES