Skip to main content

Listing Details

Save
Ask
Tour
Hide
Share
$5,900,000
8 Days On Site

6700 Dunnsville Road
Guilderland, NY 12009

For Sale|Mixed Use|Active
0
Beds
0
Total Baths
7,267
SqFt
$812
/SqFt
1999
Built
County:
Albany
Listing courtesy of Allen T Olmsted of Canaan Realty
Call Now: (518) 512-7784
Is this the listing for you? We can help make it yours.
(518) 512-7784
6700 Dunnsville Road6700 Dunnsville Road6700 Dunnsville Road6700 Dunnsville Road
Save
Ask
Tour
Hide
Share

Mortgage Calculator

Monthly Payment (Est.)

$26,918
Calculator powered by Showcase IDX, a Constellation1 Company. Copyright ©2026 Information is deemed reliable but not guaranteed.

An extraordinary offering in the heart of the Helderberg foothills, Altamont Orchards represents over 57 years of family farming legacy and one of the most diverse, income-producing agricultural estates in Upstate New York. Situated on historic land deeded as far back as 1792, this multi-faceted property delivers rare depth across hospitality, recreation, retail, and agricultural operations. This remarkable offering encompasses a spectacular working orchard, a beloved farm market and farm stand complete with a bakery, specialty foods, greenhouse, and gift shop, all drawing loyal customers season after season. A craft brewery tenant operating on-site adds yet another layer of energy and income to an already exceptional portfolio and a private residential home provides a live-where-you-work lifestyle on this compound. And then there's the crown jewel, the adjacent Orchard Creek Golf Course, an acclaimed 18-hole championship par-71 public course and proud recipient of NYS Course of the Year. Host unforgettable gatherings here in the three-season banquet space, welcome diners to the full-service Cider House Restaurant, and entertain guests in the signature clubhouse. From dining to pick-your-own apple experiences to championship golf and grand event hosting, this is the rare property where history, community, and opportunity converge. The next steward of this property inherits not just land, but a legacy generations in the making.

Save
Ask
Tour
Hide
Share
Listing Snapshot
Price 
$5,900,000
Days On Site 
8 Days
Bedrooms 
N/A
Inside Area (SqFt) 
7,267 sqft
Total Baths 
N/A
Full Baths 
N/A
Partial Baths 
N/A
Lot Size 
162 Acres
Year Built 
1999
MLS® Number 
202618009
Status 
Active
Property Tax 
$76,669
HOA/Condo/Coop Fees 
N/A
Sq Ft Source 
N/A
Friends & Family
Recent Activity
a week agoListing first seen on site
a week agoListing updated with changes from the MLS®
General Features
Acres 
162
Additional Property Use 
OtherMixed Use
Cross Street 
Route 146
Parking 
Off StreetGravel
Parking Spaces 
200
Property Sub Type 
Mixed Use
Security 
Other
Sewer 
Septic Tank
SqFt Total 
7267
Style 
CommercialOther
Water Source 
Public
Zoning 
Rural
Interior Features
Cooling 
Other
Flooring 
OtherCarpetConcrete
Heating 
Other
Interior 
Other
Save
Ask
Tour
Hide
Share
Exterior Features
Construction Details 
OtherAluminum SidingBlockVinyl SidingWood Siding
Exterior 
Other
Lot Features 
OtherViewsPrivateLevelLandscapedWaterfront
Other Structures 
Barn(s)Outbuilding
Patio And Porch 
PorchPatio
Roof 
Other
Waterfront 
Yes
Waterfront Features 
CreekWaterfront
Community Features
Financing Terms Available 
Cash
School District 
Guilderland
Schools
School District
Guilderland
Elementary School
Unknown
Middle School
Unknown
High School
Guilderland
Listing courtesy of Allen T Olmsted of Canaan Realty



Listing information is provided by Participants of the Global MLS. IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed. Copyright 2026, Global MLS.
Last checked: 2026-06-03 08:01 PM UTC

Neighborhood & Commute
Source: Walkscore
Save
Ask
Tour
Hide
Share