Skip main navigation
For sale
    • Price cut: $75K (9/3)
    $584,900

    802 Queen Anne Rd, Amsterdam, NY 12010

    3beds
    1,512sqft
    Manufactured Home, Farm
    Built in 1997
    17.7 Acres Lot
    $617,700 Zestimate®
    $387/sqft
    $-- HOA

    What's special

    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.
    116 days
    1,455
    42

    Zillow last checked:

    Listing updated:

    Listed by:

    Town & Country 518 Real Estate 518-225-8205,

    Jill Cunningham 518-225-8205

    Source: My State MLS,MLS#: 11776308

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 3
      • Bathrooms: 2
      • Full bathrooms: 2
      Rooms
      • Room types: Breakfast Room, Den, Dining Room, En Suite, First Floor Bathroom, First Floor Master Bedroom, Formal Room, Kitchen, Laundry Room, Living Room
      Kitchen
      • Features: Open, Laminate Counters
      Basement
      • Area: 0
      Heating
      • Propane, Baseboard, Forced Air
      Cooling
      • Wall/Window Unit(s)
      Appliances
      • Included: Dishwasher, Dryer, Refrigerator, Oven, Washer, Water Heater
      Features
      • Flooring: Carpet, Laminate
      • Basement: No Access
      • Number of fireplaces: 1
      • Fireplace features: Pellet Stove
      Interior area
      • Total structure area: 1,512
      • Total interior livable area: 1,512 sqft
      • Finished area above ground: 1,512

      Property

      Parking
      • Total spaces: 4
      • Parking features: Driveway, Detached
      • Garage spaces: 4
      • Has uncovered spaces: Yes
      Features
      • Stories: 1
      • Patio & porch: Deck
      • Fencing: Fenced
      • Has view: Yes
      • View description: Farm, Pond, Scenic
      • Has water view: Yes
      • Water view: Pond
      • Waterfront features: Pond
      • Body of water: Koi Pond
      Lot
      • Size: 17.7 Acres
      • Features: Equestrian Property, Room For Tennis, Trees
      Details
      • Additional structures: Shed(s), Barn(s), General Outbuilding, Riding Ring, Stable(s)
      • Parcel number: 39.28.1
      • Lease amount: $0

      Construction

      Type & style
      • Home type: MobileManufactured
      • Property subtype: Manufactured Home, Farm
      Materials
      • Aluminum Siding
      • Roof: Asphalt,Metal
      Condition
      • New construction: No
      • Year built: 1997

      Utilities & green energy

      • Electric: Amps(150)
      • Sewer: Private Septic
      • Water: Well

      Community & HOA

      HOA
      • Has HOA: No
      Location
      • Region: Amsterdam

      Financial & listing details

      • Price per square foot: $387/sqft
      • Annual tax amount: $2,308
      • Date on market: 5/20/2026
      • Date available: 05/16/2026
      • Listing agreement: Exclusive

        Estimated market value

        $617,700

        $587,000 - $649,000

        Not available

        Price history

        DateEventPrice
        9/3/2026Price change$584,900-11.4%$387/sqft
        Source: My State MLS #11776308 Report a problem
        7/21/2026Price change$659,900-5.7%$436/sqft
        Source: My State MLS #11776308 Report a problem
        5/21/2026Listed for sale$699,900+175%$463/sqft
        Source: My State MLS #11776308 Report a problem
        9/12/2018Listing removed$254,500$168/sqft
        Source: JUDITH ANN REALTY INC #10482310 Report a problem
        5/15/2018Pending sale$254,500$168/sqft
        Source: JUDITH ANN REALTY INC #10482310 Report a problem
        4/16/2018Listed for sale$254,500$168/sqft
        Source: JUDITH ANN REALTY INC #10482310 Report a problem

        Public tax history

        Tax history is unavailable.

        Monthly payment

        Estimated monthly payment$1,822
        All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
        HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
        See how much you could borrow to make a competitive offer.
        Get pre-qualified

        Climate risks

        Neighborhood: 12010

        Getting around

        1 / 100
        Car-Dependent
        23 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating
        Schools provided by the listing agent
        • District: Amsterdam City School District

        Source: My State MLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.

        A local agent can set up tours, give advice and negotiate with sellers.

        Browse local experts

        Similar homes

            Nearby cities

            Nearby zip codes

            Other Amsterdam Topics

              Search
              Updates
              Favorites
              Plan
              Inbox