$549,900
159 Currybush ConnectionRotterdam, NY 12306
Homes, condos and townhomes · MLS 11937074 · Listed 77 days ago (Aug 14, 2026)
Pond · Waterfront, relationship not specified · Waterfront details
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
Estimated monthly payment
$3,939 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 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 30, 2026, 7:01 PM UTC. Information is deemed reliable but not guaranteed; verify all details with the listing agent.