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
    • 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
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
      • 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 203 Tripp Lake Road, Warrensburg, NY 12817
      ACTIVE
      0
      $1,925,000

      203 Tripp Lake RoadWarrensburg, NY, 12817

      LandMixed Use72.12 Acres
      Positioned in the heart of the Adirondacks' thriving tourism corridor, Green Mansions Golf Course presents a rare opportunity to acquire a 72+ acre turn-key recreational and hospitality property with immediate income and exceptional future development potential. Ideally located just 20 minutes from Lake George, Bolton Landing and 30 minutes to Gore Mountain and Saratoga Springs, this property is perfectly positioned to capitalize on the region's growing year-round tourism and recreation market. The offering includes a fully operational 9-hole golf course with maintained greens and fairways, tournament capability, and an established customer base, along with a turn-key clubhouse featuring a restaurant, bar, and approximately 1,000 sq ft banquet/event area ideal for weddings, outings, and private events. Above the clubhouse is a spacious 1,300 sq ft 2-bedroom, 2-bath apartment with a deck overlooking the course, offering flexibility for owner occupancy, employee housing, or additional rental income. What truly sets this property apart is the incredible upside potential. With 9 Adirondack Park Agency approved building rights, the opportunities for expansion are substantial, including vacation homes, cabins, short-term rentals, glamping concepts, or a larger resort-style destination. Located directly on the Northern Warren Trailblazers snowmobile trail system, across the street from Tripp Lake with lake rights, and surrounded by premier hiking, boating, skiing, and outdoor recreation, the property offers unmatched four-season appeal in one of the Northeast's most sought-after destinations. Whether you envision continuing the successful golf and hospitality operation, expanding into a destination resort, or developing a high-demand vacation rental community, Green Mansions Golf Course offers the acreage, infrastructure, location, and flexibility to bring that vision to life.
      1 / 41

      Est. Monthly

      $9,124/mo

      $1,925,000

      203 Tripp Lake Road, Warrensburg, NY

      LandMixed Use72.12 Acres

      Positioned in the heart of the Adirondacks' thriving tourism corridor, Green Mansions Golf Course presents a rare opportunity to acquire a 72+ acre turn-key recreational and hospitality property with immediate income and exceptional future development potential. Ideally located just 20 minutes from Lake George, Bolton Landing and 30 minutes to Gore Mountain and Saratoga Springs, this property is perfectly positioned to capitalize on the region's growing year-round tourism and recreation market. The offering includes a fully operational 9-hole golf course with maintained greens and fairways, tournament capability, and an established customer base, along with a turn-key clubhouse featuring a restaurant, bar, and approximately 1,000 sq ft banquet/event area ideal for weddings, outings, and private events. Above the clubhouse is a spacious 1,300 sq ft 2-bedroom, 2-bath apartment with a deck overlooking the course, offering flexibility for owner occupancy, employee housing, or additional rental income. What truly sets this property apart is the incredible upside potential. With 9 Adirondack Park Agency approved building rights, the opportunities for expansion are substantial, including vacation homes, cabins, short-term rentals, glamping concepts, or a larger resort-style destination. Located directly on the Northern Warren Trailblazers snowmobile trail system, across the street from Tripp Lake with lake rights, and surrounded by premier hiking, boating, skiing, and outdoor recreation, the property offers unmatched four-season appeal in one of the Northeast's most sought-after destinations. Whether you envision continuing the successful golf and hospitality operation, expanding into a destination resort, or developing a high-demand vacation rental community, Green Mansions Golf Course offers the acreage, infrastructure, location, and flexibility to bring that vision to life.

      StatusActive
      Property TypeLand
      Property SubtypeMixed Use
      Days on Market4 days

      Est. Monthly Payment

      $9,124.45

      %
      %
      yr

      Private Mortgage Insurance

      Not required

      Affordability Checkoptional
      $

      Enter your annual income to check affordability

      Property Details

      Property Information

      203 Tripp Lake Road

      Warrensburg, NY 12817 • Warren
      —
      Beds
      —
      Baths
      —
      SqFt
      72.12
      Acres
      Status
      Active
      Property Type
      Land
      Property Subtype
      Mixed Use
      Days on Market
      4 days
      Tax History
      Estimated values, may not reflect current amounts.
      • Annual Tax Amount
        $24,671
      • School Taxes
        $6,865
      • Town/County Taxes
        $17,806
      Property History
      • Listed for sale
        May 8, 2026 • GLOBAL MLS • 202616724
        $1,925,000
      Mortgage Calculator
      Estimated monthly payment for this property
      $9,124.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
        Global MLS
      • MLS#
        202616724
      • Listing Office
        Davies-Davies & Assoc Real Est
      • Last Updated
        4 days ago

      Lot & Grounds

      • Lot Size
        72.12 acres
      • Lot Features
        • Landscaped
        • Mountain(s)
        • Road Frontage
        • Wooded
        • Views

      Type

      • Property Type
        Land
      • Property Subtype
        Mixed Use

      Condition

      • Days on Market
        4 days
      • Water
        Well
      • Sewer
        Septic Tank
      Also Listed On
      • Global MLS
        1 related listing
        Active$1,925,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 →
      • 3737 NY-196, Fort Ann, NY 12827ACTIVE$1,750,000

        3737 NY-196, Fort Ann, NY 12827

        LandMixed Use209.85 Acres

        LISTING BY HUNT ERA

      • 337 Central Avenue, Albany, NY 12206ACTIVE$1,800,000

        337 Central Avenue, Albany, NY 12206

        10,310 SqFt0.16 Acres

        LISTING BY HANNA COMMERCIAL

      • 2289 US-9, Mechanicville, NY 12118ACTIVE$1,900,000

        2289 US-9, Mechanicville, NY 12118

        LandMixed Use29.77 Acres

        LISTING BY ROOHAN REALTY

      • 106 Main Street, Boonville, NY 13309ACTIVE$1,950,000

        106 Main Street, Boonville, NY 13309

        15,000 SqFt

        LISTING BY THE O'HARA GROUP

      • 5635 NY-40, Argyle, NY 12809ACTIVE$1,990,000

        5635 NY-40, Argyle, NY 12809

        3,531 SqFt155.1 Acres

        LISTING BY HOWARD HANNA CAPITAL INC

      • 108/114 Congress Street, Saratoga Springs, NY 12866ACTIVE$1,999,999

        108/114 Congress Street, Saratoga Springs, NY 12866

        Commercial SaleMixed Use0.37 Acres

        LISTING BY KW PLATFORM

      • 585 Central Avenue, Albany, NY 12206ACTIVE$2,000,000

        585 Central Avenue, Albany, NY 12206

        Commercial SaleMixed Use0.5 Acres

        LISTING BY GUCCIARDO REAL ESTATE LLC