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 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 Market24 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
24 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
    24 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
    24 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 →
  • 108/114 Congress Street, Saratoga Springs, NY 12866ACTIVE$1,750,000

    108/114 Congress Street, Saratoga Springs, NY 12866

    Commercial SaleMixed Use0.3 Acres

    LISTING BY KW PLATFORM

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

    5635 NY-40, Argyle, NY 12809

    3,531 SqFt155.1 Acres

    LISTING BY HOWARD HANNA CAPITAL INC

  • 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

  • 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

  • 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