Search
Agricultural Estate with Golf Course
For Sale
$5,900,000

6700 Dunnsville Road, Guilderland, NY 12009

COMMERCIAL - Other - Guilderland, NY

Property Size7,267 SF
Lot Size162.00 Acres
Price / SF$811.89
Days on Market94

Property Features for 6700 Dunnsville Road

General Information

Property type Commercial Sale
Property subtype Other
Zoning Rural
Parking 200
Parking features Off Street
Patio and Porch features Porch, Patio
Lot features Views, Private, Level, Landscaped
High school Guilderland
Elementary school district Guilderland
Middle school district Guilderland
High school district Guilderland
Directions From Guilderland head west on Route 20/Western Ave for about 6 miles. Turn left onto NY 397S/Dunnsville Rd for about 1.3 miles. Property is on the left
Standard status Active
APN 013089 25.00-2-34.12
Size 7,267 SF
Lot size 162.00 Acres

Taxes and HOA fees

Tax Annual Amount 76669

Utilities

Sewer type Septic Tank
Water source Public
Water front features Creek
Water front 1

Building Details

Year built 1999
Floors in Building 2
Flooring type Carpet, Concrete
Building materials Aluminum Siding, Block, Vinyl Siding, Wood Siding
Architectural style Other
Additional Structures Outbuilding
Listing Agency: Canaan Realty
Listed By: Allen T Olmsted · License #37OL0750434
Added: May 26 Changed: Aug 4 Last Checked: Aug 27 at 2:06AM
MLS# 202618009

Copyright © 2026 Global MLS, Inc. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.

Investment Insights

Based on property information with market context.

This offering presents a diverse, income-producing agricultural estate with a working orchard and multiple on-site hospitality and retail components. The property includes a farm market and farm stand with a bakery, specialty foods, a greenhouse, and a gift shop, alongside a craft brewery tenant operating on-site. A private residential home is also part of the compound.

Located at 6700 Dunnsville Road in Guilderland, New York, the estate sits on historic land deeded as far back as 1792 and is described as being in the Helderberg foothills. Zoning is listed as Rural.

Adjacent to the property is Orchard Creek Golf Course, an 18-hole public course described as a championship par-71 and noted in the remarks as a recipient of NYS Course of the Year. The course operations include three-season banquet space for gatherings, a full-service Cider House Restaurant, and a clubhouse.

Key Highlights

  • On‑site orchard creek feature
  • Year built: 1999
  • Public water and septic tank sewer service

Property Analytics

Current Use

Golf courses & driving ...

Suggested Use

Top Pick Auto Repair Shop Auto Parts Store Garden Center Restaurant Travel Agency Department Store

Score = modeled unmet demand for each use within ~1 mi (higher = bigger opportunity). Zoning and permitted uses should be independently verified with local authorities.

Lease Details

Turnkey business
Opportunity

Location Intelligence

Trade Area within ½ mile

9
Businesses Nearby

Demographics for 12009, NY

7,874
Population
3,238
Households
2.4
Avg Household Size
45
Median Age
53%
College-Educated
96%
High-School Grad
52.6 sq mi
ZIP Area
150
Density / Sq Mi
$114,352
Median Household Income
$54,128
Median Earnings
$1,282
Median Rent
$321,500
Median Home Value

Market

Vacancy Rate% for Industrial in Northeast region

5.4% 2019
4.6% 2020
3.2% 2021
3.3% 2022
5.3% 2023
6.6% 2024
7.6% 2025
Rey
Questions? Ask Rey
Realmo’s AI knows this listing — price, zoning, demand, history. Ask anything.

Frequently Asked Questions

What type of property is this?
Farm - Multi-faceted agricultural and hospitality estate featuring a working orchard and an adjacent 18-hole golf course.
Where is this farm located?
The property is located at 6700 Dunnsville Road Guilderland, NY.
What is the asking price?
The asking price for this property is $5,900,000.
What are key features of this property?
This property features: On‑site orchard creek feature; Year built: 1999; Public water and septic tank sewer service
More about this property
Thanks! Your message was sent.
Error! Your message wasn't sent.
Please enter your name
Please enter email
Please enter the email in the correct format
Please enter phone
Please enter the number in the correct format
Please enter message