Sharon FronkRealtor® · Howard Hanna
LoadingSold · listed at $399,900
Rotterdam, NY 12150 · Schenectady County
Beautifully updated side-by-side duplex overlooking the Mohawk River. This spacious property offers two bright and inviting 2-bedroom apartments, each with just over 1,000 sq ft of comfortable living space. The main level of each unit has been fully remodeled, featuring a modern kitchen with bar seating, brand-new stainless steel appliances, a generous living room, and a stylish updated half bath. Upstairs, each apartment includes two well-sized bedrooms and an updated full bathroom. Both units also come with their own private basement--complete with a washer and dryer. Brand-new garage doors have been installed on the 2-car garage with additional off-street parking available on the recently repaved driveway. Enjoy a spacious backyard with tranquil views of the Mohawk River and surrounding mountains, all set in a peaceful Upstate NY location. The home has been thoughtfully maintained and upgraded, featuring new energy-efficient windows, a 2-year-old asphalt shingle roof, and new high-efficiency hot water heaters installed in 2024 and 2025. New septic installed in '26. Whether you're looking to enjoy one unit as an owner-occupant or seeking a turnkey investment property, this duplex offers outstanding flexibility and immediate income potential. No flood insurance required.
23 facts pulled straight from the MLS listing.
Google Maps view. Pan, zoom, click a pin to read about a business or place.
Plan a multi-stop route from this address: drop-off the kid, hit the office, head home. Live traffic from Google.
Try a preset
The district this address is assigned to. Ratings and reviews are hosted on GreatSchools.
Assigned districts can change and are not guaranteed. Confirm enrollment boundaries with the district directly before relying on them.
Rotterdam is in Schenectady County, NY. There are currently 68 active listings here, ranging from $10,000 to $2,150,000. Listings in this address fall under the Schalmont school district.
See Sharon's Rotterdam community guide
Sharon represents buyers for this property. Your tour, offer, and inquiries go through her, not the listing brokerage.
Find Advisors · Listed by Donald D Baker (34640)
Contact: 216-374-6711
MLS #202616001 · Source: Global MLS, Inc.
IDX information is provided exclusively for consumers' personal, non-commercial use, that it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing, and that the data is deemed reliable but is not guaranteed accurate by the MLS. Sharon Fronk Real Estate is committed to compliance with the Fair Housing Act and provides equal opportunity in housing.
Real numbers from current MLS data. Not a third-party estimate.
Every change captured by Global MLS since this listing went live.
