$584,900
802 Queen Ann RoadAmsterdam, NY 12010
Farms and ranches · MLS 11776308 · Listed 167 days ago (May 16, 2026)
Koi Pond · Pond · Waterfront, relationship not specified · Waterfront details
For sale: Listed and available according to the MyStateMLS feed.
About this property
Dreaming of owning your own training facility? Well here is a once in a lifetime opportunity to own your own equestrian training center in the heart of the Capital region. Minutes to the NYS I-90. This horse farm with a 3/8 training track, loading ramp, 21 stalls 1-12x24 foaling stall, hot walker, 60x90 indoor arena,90 x180 outdoor arena, Koi pond, 5 large grass pastures with electric running to each pasture. Large run-in sheds in each pasture. Barn has an office and seperate grain and tack room. Located on farm is a camper pad for Harvest host guests. This farm is ideal to hold horse shows and clinics anytime of the year. Currently a turnkey boarding facility. Only 30 minutes to Saratoga racetrack. Also making this farm ideal is the easy workflow with access to paddocks, training track, indoor/outdoor arenas, and the barn making your job a bit easier. Outbuildings for trucks, tractors, drags, jumps, hay storage, detached garage, workshop area. Located 1 mile from the Schoharie Crossing State Historic site for trail riding, hiking, biking and kayaking along the Mohawk river. Easy access to HITS, Lake Placid, Manchester and Saratoga.
Description provided by the listing brokerage.
MLS-reported waterfront
Waterfront details
The listing reports the property as waterfront but does not say how it meets the water. Ask the listing agent whether the parcel itself adjoins the shoreline.
- Relationship to the water
- Waterfront, relationship not specified
- Water type
- Pond
- Water body
- KOI POND (as reported)Name as reported by the listing (not matched to a mapped water body)
- Frontage length
- Not provided. Ask the listing agent.
- Water access arrangement
- Not provided. Ask the listing agent.
- Docks, slips, lifts, moorings
- Not provided. Ask the listing agent.
- Dock depth
- Not provided. Ask the listing agent.
- Shoreline
- Not provided. Ask the listing agent.
- Seasonal or tidal conditions
- Not provided. Ask the listing agent.
- Boating limits (bridges, depth, open-water access)
- Not provided. Ask the listing agent.
Why this is listed as waterfront
WaterfrontYN“Yes”: The listing is marked waterfront.WaterfrontFeatures“Pond”: Describes the water without a frontage value.PropertyTypeDetail“farm-estate”: Property form used to read the frontage relationship.
Classified from fields in the MyStateMLS listing data. It has not been independently verified, and it is not a survey, title examination or legal determination of shoreline or access rights. Rules version 2026-10-29.1. How we classify waterfront
Something wrong with this classification? Report a waterfront classification issue. Questions about frontage, docks or access are best answered by Jill Cunningham of Town & Country 518 Real Estate.
Facts
- List price
- $584,900
- Original list price
- $699,900
- Status
- For sale
- Property type
- Farm or estate
- Bedrooms
- 3
- Full baths
- 2
- Interior area
- 1,512 sq ft
- Lot size
- 18 acres
- Year built
- 1997
- Stories
- 1
- Garage spaces
- 4
- County
- Montgomery County
- MLS number
- 11776308
- Annual property tax
- $2,308
Facts are reported by the listing brokerage. Items not listed were not provided; that does not mean the property lacks them.
Farm and ranch details
- Water source
- Well
- Fencing
- Fenced
Features
Interior
- Entrance Foyer
- Master Downstairs
Appliances
- Washer
- Range
- Water Heater
- Refrigerator
- Dryer
- Dishwasher
Flooring
- Laminate
- Carpet
Basement
- No Access
Heating
- Forced Air
- Baseboard
- Propane
Parking
- Driveway
Construction
- Aluminum
Roof
- Metal
- Asphalt
Water
- Well
Sewer
- Septic Tank
Location
The pin is the listing's reported coordinates and may be approximate. It is not a parcel boundary or shoreline, and no flood, wetland or hazard conclusion should be drawn from it. See more listings in Amsterdam.
Price and status history
- Original list price reported by the brokerage: $699,900
Changes observed by Waterfront Homes in MyStateMLS data since Oct 29, 2026. This is not a public-record sales history; MyStateMLS does not publish sold prices.
Estimate a monthly payment
Estimated monthly payment
$3,321 per month
An estimate for comparison only, not a loan offer or approval. Actual rates, taxes, insurance, PMI and fees depend on your lender, credit, location and loan program.
Questions to ask before you buy
Questions worth investigating for any waterfront property. They are not claims that this property has a problem or meets any condition.
- Who owns the shoreline and the land under the water, and are there easements or public-access rights along it?Ownership can stop at a high-water line, a survey line or a seawall. A title search and survey answer this, not the listing.
- Is a dock, slip, lift or mooring included, and do the rights transfer to you?Docks can be shared, leased, assigned by an association or held under a permit that does not automatically transfer.
- What permits exist for the dock, seawall or other shoreline structures, and what would new work require?Shoreline work is often regulated by local, state and federal agencies.
- How much does the water level change by season, by tide or by reservoir management?Depth at a dock in one season can differ a lot in another.
- What does flood insurance cost for this property, and what does the current flood map show?Get a quote from an insurer or agent. A flood zone is not a premium, and no zone does not mean no risk.
- What maintenance does the shoreline need (seawall, bulkhead, riprap, erosion), and what has been done recently?Shoreline structures are expensive to repair; ask for records and inspection reports.
- How are water, sewer or septic, and power provided?Waterfront septic systems and wells can have extra rules and inspections.
- How do you reach the property by road year-round, and who maintains that road?Some waterfront roads are private, seasonal or shared.
- What local rules apply: rentals, docks, boat lifts, fences, tree removal, setbacks?Rules come from the town, county, state, lake authority or association and vary widely.
Printable due-diligence checklist · Ownership budget planner · FEMA Flood Map Service Center (official flood maps; look up the address yourself)
Guides and next steps
Listing courtesy of Town & Country 518 Real Estate. Listing agent: Jill Cunningham. Listings provided by MyStateMLS.
Listing last updated by the brokerage Sep 3, 2026, 6:36 PM UTC. Waterfront Homes last received MyStateMLS data Oct 30, 2026, 4:31 PM UTC. Information is deemed reliable but not guaranteed; verify all details with the listing agent.