Under contractVirtual tour

$549,900

4 beds4,606 sq ft43 acres

159 Currybush ConnectionRotterdam, NY 12306

Homes, condos and townhomes · MLS 11937074 · Listed 76 days ago (Aug 14, 2026)

Pond · Waterfront, relationship not specified · Waterfront details

Report a problem

Under contract: The seller has accepted an offer with conditions. Some sellers still accept backup offers.

About this property

Welcome to this expansive 4-bedroom, 3-bath home offering over 4,606 square feet of living space, situated on 8.85 beautiful acres in the Schalmont School District. This unique country property offers tremendous space, privacy, and potential. The home features a large kitchen with an open dining area, an oversized living room with a wood-burning fireplace, and a two-level family room with a wood stove. A 4-season sunroom overlooks the in-ground pool, providing a wonderful space to enjoy the views year-round. Decks extend along three sides of the home, offering additional outdoor living space to relax and take in the peaceful country setting. Upstairs, you'll find two additional unfinished bedrooms waiting to be completed, with a full bath, offering the potential to transform this into a 6-bedroom home. Additional features include skylights throughout, fruit trees, a pond, and beautiful country views. With plenty of room to enjoy the outdoors right outside your door, this property is ideal for those seeking privacy, recreation, or simply the tranquility of country living. While the home could benefit from some updating, its exceptional size, desirable setting, in-ground pool, pond, and has endless potential! This Home comes with Two Additional Parcels of Land SBL #36.-3-49, is 1.15 Acres Directly Across the Street from the Home and features a Three Sided Poll Barn for Tractors & Equipment storage, and SBL # 46.-4-2.11 is 33.27 Acres Directly Adjacent to the Main Home. This sale will include all Three Parcels as one Package Deal 43.27 Acres in Total. The sale includes three separately deeded parcels totaling approximately 43.27 acres. In addition to the 8.85-acre parcel on which the home is situated, the property includes a 1.15-acre parcel directly across the street featuring a pole barn/carport, as well as a 33.27-acre parcel directly adjacent to the home. The combined annual school and property taxes for the two additional parcels are approximately $3,357.24, in addition to the taxes on the main 8.85-acre parcel.

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
Not provided. Ask the listing agent.
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 “house”: 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 Angelo Campagnano of Miranda Real Estate Group Inc.

Facts

List price
$549,900
Status
Under contract
Property type
House
Bedrooms
4
Full baths
2
Half baths
1
Interior area
4,606 sq ft
Lot size
43 acres (1,884,841 sq ft)
Year built
1980
County
Schenectady County
MLS number
11937074
Annual property tax
$12,003

Facts are reported by the listing brokerage. Items not listed were not provided; that does not mean the property lacks them.

Features

Interior

  • Master Downstairs

Appliances

  • Washer
  • Range
  • Water Heater
  • Refrigerator
  • Dryer
  • Dishwasher

Flooring

  • Tile
  • Carpet

Basement

  • Unfinished
  • Finished
  • Bilco Doors

Heating

  • Hot Water
  • Baseboard
  • Oil

Parking

  • Driveway

Construction

  • Brick

Roof

  • Asphalt

Sewer

  • Septic Tank

Lot

  • Corner Lot

Virtual tours

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 Rotterdam.

Price and status history

    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

    $109,980
    Illustrative. Replace with a quote from your lender.
    From the listing. Taxes can change after a sale.
    Get a quote; rates vary widely by location.
    Manufactured homes on a leased lot.
    Applied only while the loan is over 80% of the price. Illustrative.

    Estimated monthly payment

    $3,939 per month

    Principal and interest$2,781
    Property tax$1,000
    Homeowners insurance$158
    Loan amount$439,920
    Total interest over the term$561,094

    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.

    1. 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.
    2. 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.
    3. 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.
    4. 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.
    5. 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.
    6. 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.
    7. How are water, sewer or septic, and power provided?Waterfront septic systems and wells can have extra rules and inspections.
    8. How do you reach the property by road year-round, and who maintains that road?Some waterfront roads are private, seasonal or shared.
    9. 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 Miranda Real Estate Group Inc. Listing agent: Angelo Campagnano. Listings provided by MyStateMLS.

    Listing last updated by the brokerage Aug 19, 2026, 12:50 PM UTC. Waterfront Homes last received MyStateMLS data Oct 29, 2026, 9:31 PM UTC. Information is deemed reliable but not guaranteed; verify all details with the listing agent.