Quick Albany NY MLS Search

Browse All Albany NY Waterfront Properties for Sale

979 County Route 401, Westerlo
$350,777
3 Beds ⋅ 2 Baths ⋅ 202627472 MLS
Looking for a country property with flexibility, space, and income potential? Welcome to 979 County Route 401 in Westerlo. Originally a single-family home and now legally converted to a two-family residence, this unique property offers a spacious one-bedroom apartment on the first floor and a four-bedroom apartment on the second floor, making it ideal for owner-occupants, multigenerational living, an in-law setup, or investors seeking rental income. Set on approximately 3 picturesque acres in the Village of Westerlo, the property enjoys a peaceful setting with Basic Creek flowing along the rear of the land. Full of charm and character, the home features abundant storage throughout, a huge walkout basement, a welcoming full-length front porch, and two enclosed porches perfect for enjoying the surrounding countryside. Additional highlights include a pellet stove in the first-floor living room, a kerosene space heater in the first-floor bedroom, two barns (one ideal for garage parking and storage, while the older barn is being sold as-is), and ample space for RVs, campers, trailers, or recreational equipment. An existing RV hookup provides added convenience for travelers or guests. Whether you're searching for a spacious country home, a property that accommodates extended family, or an investment opportunity with income-producing potential, this versatile Westerlo property offers a rare combination of flexibility, acreage, and rural charm.

979 County Route 401, Westerlo

979 County Route 401, Westerlo
$350,777
5 Beds ⋅ 2 Baths ⋅ 202627413 MLS
Looking for a country property with flexibility, space, and income potential? Welcome to 979 County Route 401 in Westerlo. Originally a single-family home and now legally converted to a two-family residence, this unique property offers a spacious one-bedroom apartment on the first floor and a four-bedroom apartment on the second floor, making it ideal for owner-occupants, multigenerational living, an in-law setup, or investors seeking rental income. Set on approximately 3 picturesque acres in the Village of Westerlo, the property enjoys a peaceful setting with Basic Creek flowing along the rear of the land. Full of charm and character, the home features abundant storage throughout, a huge walkout basement, a welcoming full-length front porch, and two enclosed porches perfect for enjoying the surrounding countryside. Additional highlights include a pellet stove in the first-floor living room, a kerosene space heater in the first-floor bedroom, two barns (one ideal for garage parking and storage, while the older barn is being sold as-is), and ample space for RVs, campers, trailers, or recreational equipment. An existing RV hookup provides added convenience for travelers or guests. Whether you're searching for a spacious country home, a property that accommodates extended family, or an investment opportunity with income-producing potential, this versatile Westerlo property offers a rare combination of flexibility, acreage, and rural charm.

979 County Route 401, Westerlo

450 State Route 146, Altamont
$675,000
4 Beds ⋅ 4 Baths ⋅ 202623385 MLS
Same incredible home. Same amazing features. Now offered at a new price! If you've been looking for a home that has room for everyone, space to entertain, and a backyard you'll never want to leave, this one checks all the boxes!With five bedrooms, four-and-a-half bathrooms, and a layout that offers incredible flexibility, there's room for everything from working from home to hosting the whole family. Three upstairs bedrooms each have their own private full bathroom and walk-in closet, while the first floor offers two additional bedrooms, a formal dining room, laundry, and a half bath.The great room is truly something special, featuring soaring cathedral ceilings, a floor-to-ceiling stone fireplace, and a custom bar that's ready for your next get-together. The updated eat-in kitchen brings style and function together with brand-new quartz countertops, a new backsplash, and updated appliances.When it's time to unwind, head outside to your own private retreat with an in-ground pool, patio, and peaceful views backing up to Black Creek. With the pool liner replaced in 2024 and pump in 2026, summer plans practically make themselves!Plus, major updates like a new heating system and electrical panel in 2025, along with updated windows, flooring, fixtures, and a mini-split system, mean there's plenty to love beyond the beautiful spaces.All this, conveniently located near Indian Ladder Farms, Tawasentha Park, local restaurants, scenic trails, and everything that makes the Guilderland area so special.Come see what makes this property so unique.

450 State Route 146, Altamont

6700 Dunnsville Road, Altamont
$5,900,000
202618009 MLS
An extraordinary offering in the heart of the Helderberg foothills, Altamont Orchards represents over 57 years of family farming legacy and one of the most diverse, income-producing agricultural estates in Upstate New York. Situated on historic land deeded as far back as 1792, this multi-faceted property delivers rare depth across hospitality, recreation, retail, and agricultural operations. This remarkable offering encompasses a spectacular working orchard, a beloved farm market and farm stand complete with a bakery, specialty foods, greenhouse, and gift shop, all drawing loyal customers season after season. A craft brewery tenant operating on-site adds yet another layer of energy and income to an already exceptional portfolio and a private residential home provides a live-where-you-work lifestyle on this compound. And then there's the crown jewel, the adjacent Orchard Creek Golf Course, an acclaimed 18-hole championship par-71 public course and proud recipient of NYS Course of the Year. Host unforgettable gatherings here in the three-season banquet space, welcome diners to the full-service Cider House Restaurant, and entertain guests in the signature clubhouse. From dining to pick-your-own apple experiences to championship golf and grand event hosting, this is the rare property where history, community, and opportunity converge. The next steward of this property inherits not just land, but a legacy generations in the making.

6700 Dunnsville Road, Altamont

Start Your Search

©2019 Global Multiple Listing Service, Inc. The data relating to real estate on this website comes in part from the Internet Data Exchange program of the GMLS. All information is deemed reliable but not guaranteed and should be independently verified. All properties subject to prior sale, change, or withdrawal. Neither listing broker(s), GMLS shall be responsible for any typographical errors, misinformation, or misprints, and shall be held totally harmless from any damages arising from reliance upon these data. IDX information is provided exclusively for consumers’ personal, non-commercial use and may not be used for any purpose other than to identify prospective properties they may be interested in purchasing. Data last updated

Albany Waterfront Real Estate

Our website features the best real estate search for waterfront properties available in Albany and surrounding areas. It is the only site you will ever need! It is easy-to-use and updated by the official Realtor®’s database every 15 minutes. 

You can save searches, and get daily email alerts of new listings, price changes, sold data, and market reports. Our Interactive Map Search allows you to view properties on a map or refine your search by drawing the boundaries around the area you desire. 

Curious about what’s happening in your neighborhood? You can create a custom market report to see what’s active, under contract, and sold in your neighborhood! 

Considering selling or refinancing your home? Get an INSTANT property valuation now!

Contact us today to find out how we can be of assistance to you!

How much is your home worth?

Get instant property value now!