Active Listings

Some or all of the listings below are provided by the Advisor Realty office.
$649,900
Active

Hudson Area Single Family Home

Active

2323 US Route 9 Hudson, NY 12534

4 Bed
4 Baths
3344 sqft
MLS# 155209
Burroughs-Foland Farm - A Timeless Treasure in Livingston - Prime Commercial Opportunity - 2 Houses -Discover a unique opportunity with this historic property, proudly listed on the National Register of Historic Places. Built-in 1908, this mission-style home combines Old World charm with modern potential, featuring a stucco facade and classic clay tile roof. On the market for the first time in over fifty years, this architectural gem is ready to be transformed by its next owner.Located in a prime commercial zone, this property offers an exceptional business opportunity with its convenient setting just off the lively Route 9. Set on a 2.19-acre lot adjacent to a working agricultural farm, the home provides a perfect blend of accessibility and tranquility. Inside, original Tiffany light fixtures, rich dark wood trim, and elegant hardwood floors add to its timeless appeal. With four bedrooms and four bathrooms, the space is adaptable to a variety of business needs.Entertain clients or guests in style within the spacious living areas, featuring two cozy fireplaces, a woodstove for chilly evenings, and a formal dining room highlighted by a dazzling crystal chandelier. The side porch, tranquil fishpond, and inground pool offer inviting outdoor spaces for relaxation or events.Adding to its commercial allure, the property includes a one-story, 820 sq. ft. accessory house, a two-story, 40' x 32' barn, an 18' x 20' shed, and a small garden shed, providing ample storage or workspace for business endeavors. The charming one-story accessory house offers potential for office space, guest accommodations, or rental income.Seize the chance to own a piece of history while capitalizing on its commercial potential. Schedule a showing today and explore the endless possibilities that await at this historic Livingston property.Property is Agent Owned.The home and accessory buildings are in need of some updates and repairs.Some furniture in the home is for sale. If client is interested in purchasing any pieces, please advise listing agent.
Listing by: COLUMBIA COUNTY / Coldwell Banker Advisor Realty / Laurel Jurkowski
$595,000
Active

Rhinebeck Area Single Family Home

Active

22 Beacham Road Rhinebeck, NY 12572

3 Bed
3 Baths
2028 sqft
MLS# 881419
Charming and Secluded Home in Highly Sought-After Location - First Time on Market in 36 Years Nestled in a quiet, serene setting just 7-10 minutes from the heart of Rhinebeck, this beautifully maintained one-owner home offers comfort, privacy, and timeless charm. Built in 1988, the property has been lovingly cared for over the decades and is now ready for its next chapter. Charming curb appeal with lovely flower beds as you arrive to the front entrance. Step inside to discover a warm, light-filled living room featuring large windows that bathe the space in natural light. The newly remodeled kitchen showcases stainless steel appliances, granite countertops, and ample cabinet space for all your culinary needs. A spacious dining area opens through sliding doors to a generous composite deck—perfect for outdoor entertaining or quiet mornings with coffee while taking in the peaceful mountain views. Upstairs, the home features a primary bedroom with a full en-suite bath, plus two additional bedrooms and another full bathroom. Downstairs offers a versatile living space ideal for in-laws, guests, or a home office. It includes a second kitchen, living room, office area, half bath, and a private entrance—along with easy access to a 6-person hot tub for relaxing under the stars. Set back from the road by a 340-foot winding driveway, this home provides exceptional privacy. Additional features include an attached two-car garage, 2 year old boiler and a full-house generator for peace of mind during storms, and deeded lake rights to nearby Round Lake—just a short walk away. This exceptional property is on the market for the first time in 36 years—and it's been well worth the wait.
Listing by: ONEKEY / Coldwell Banker Advisor Realty / Margaret Williams
$595,000
Active

Rhinebeck Area Single Family Home

Active

22 Beacham Rhinebeck, NY 12572

3 Bed
3 Baths
2028 sqft
MLS# 20252622
Charming and Secluded Home in Highly Sought-After Location - First Time on Market in 36 Years Nestled in a quiet, serene setting just 7-10 minutes from the heart of Rhinebeck, this beautifully maintained one-owner home offers comfort, privacy, and timeless charm. Built in 1988, the property has been lovingly cared for over the decades and is now ready for its next chapter. Charming curb appeal with lovely flower beds as you arrive to the front entrance. Step inside to discover a warm, light-filled living room featuring large windows that bathe the space in natural light. The newly remodeled kitchen showcases stainless steel appliances, granite countertops, and ample cabinet space for all your culinary needs. A spacious dining area opens through sliding doors to a generous composite deck—perfect for outdoor entertaining or quiet mornings with coffee while taking in the peaceful mountain views. Upstairs, the home features a primary bedroom with a full en-suite bath, plus two additional bedrooms and another full bathroom. Downstairs offers a versatile living space ideal for in-laws, guests, or a home office. It includes a second kitchen, living room, office area, half bath, and a private entrance—along with easy access to a 6-person hot tub for relaxing under the stars. Set back from the road by a 340-foot winding driveway, this home provides exceptional privacy. Additional features include an attached two-car garage, a full-house generator for peace of mind during storms, and deeded lake rights to nearby Round Lake—just a short walk away. This exceptional property is on the market for the first time in 36 years—and it's been well worth the wait.
Listing by: ULSTER / Coldwell Banker Advisor Realty / Margaret Williams