My Office's Listings

Some or all of the listings below are provided by the Advisor Realty office.
$1,450,000
Active

Gallatin Area Single Family Home

Active

174 County Route 11 Gallatin, NY 12567

4 Bed
3 Baths
1952 sqft
MLS# 150538
Virtual Tour
Welcome to Gallatin Homestead, an amazing country property comprised of 57.44 Acres, 2 Homes and multiple outbuildings. The property is made up of 47+/- acres of woodland, a 6+/- acre hay field and about 4 acres of area surrounding the homes and outbuildings. A natural stream flows through the property and is the delineation between the woodland and developed area. Home #1 is a Sidehall Colonial with addition. The home features 4 bedrooms, 3 baths and includes details such as solid oak doors, maple hardwood floors and wood stove insert in the living room fireplace. This home has a 38'x31' detached 3 car garage/workshop with large second floor.Home #2 is an Eyebrow Colonial with large front porch. This home features 5 bedrooms, 2 baths and includes details such as oak and maple hardwood flooring and wood burning stove in the living room. This home has a detached 24'x24' 2 car garage with second floor storage and firewood lean-to off the rear.The property also includes a massive 5 Bay 60'x120'x16' barn with 14' doors constructed in 2013. Within the barn, there is a 16'x18' office, 20'x34' machine shop and 18'x28' storage area all with loft space overhead. Radiant heating throughout with energy efficient spray foam insulation.A 18'x18' building with a 60kVA Onan Generator supplies energy to all structures on the property in the event of a power outage.On the edge of the 6+/- acre field is a partially enclosed pole barn, currently rented by the neighbor for storage.This property would make an incredible estate or compound with some updating and TLC. It is well suited for the outdoor enthusiast between the expansive workshop space and beautiful woodland with stream, natural rock outcroppings and nature trails. 18 miles to Hudson, 14 miles to Red hook and only 5.5 miles from the Taconic State Parkway.
Listing by: COLUMBIA COUNTY / Coldwell Banker Advisor Realty / Jason Walch
$1,450,000
Active

Gallatin Area Multi-Family Home

Active

174 County Route 11 Gallatin, NY 12567

9 Bed
5 Baths
3800 sqft
MLS# 150511
Virtual Tour
Welcome to Gallatin Homestead, an amazing country property comprised of 57.44 Acres, 2 Homes and multiple outbuildings. The property is made up of 47+/- acres of woodland, a 6+/- acre hay field and about 4 acres of area surrounding the homes and outbuildings. A natural stream flows through the property and is the delineation between the woodland and developed area. Home #1 is a Sidehall Colonial with addition. The home features 4 bedrooms, 3 baths and includes details such as solid oak doors, maple hardwood floors and wood stove insert in the living room fireplace. This home has a 38'x31' detached 3 car garage/workshop with large second floor.Home #2 is an Eyebrow Colonial with large front porch. This home features 5 bedrooms, 2 baths and includes details such as oak and maple hardwood flooring and wood burning stove in the living room. This home has a detached 24'x24' 2 car garage with second floor storage and firewood lean-to off the rear.The property also includes a massive 5 Bay 60'x120'x16' barn with 14' doors constructed in 2013. Within the barn, there is a 16'x18' office, 20'x34' machine shop and 18'x28' storage area all with loft space overhead. Radiant heating throughout with energy efficient spray foam insulation.A 18'x18' building with a 60kVA Onan Generator supplies energy to all structures on the property in the event of a power outage.On the edge of the 6+/- acre field is a partially enclosed pole barn, currently rented by the neighbor for storage.This property would make an incredible estate or compound with some updating and TLC. It is well suited for the outdoor enthusiast between the expansive workshop space and beautiful woodland with stream, natural rock outcroppings and nature trails. 18 miles to Hudson, 14 miles to Red hook and only 5.5 miles from the Taconic State Parkway.
Listing by: COLUMBIA COUNTY / Coldwell Banker Advisor Realty / Jason Walch
$1,199,000
Active

Hudson Area Multi-Family Home

Active

809 Warren Street Hudson, NY 12534

5 Bed
4 Baths
3314 sqft
MLS# 152026
Virtual Tour
Nestled along Hudson's coveted upper Warren Street, this enchanting home stands as a testament to meticulous restoration and timeless elegance. Once a bustling three-family, it now stands as a grand single-family with an in-law apartment, blending historic charm with modern allure. Upon entering you see exposed fireplaces (one working) and an expansive space that seamlessly blend. A brand-new open kitchen, joined to the back entrance, beckons for entertainment. Rounding out the first floor is a powder room and grand wet bar. Step outside to discover a rear deck overlooking a private garden oasis a tranquil haven complete with a soothing hot tub, inviting year-round relaxation The second floor includes four bedrooms accompanied by two baths, including a luxurious primary bath boasting a spacious shower and standalone tub. Above the primary suite is a third floor garret office/gym nook space with a large cedar closet. Beyond its residential charm, this property presents a myriad of opportunities. The only known house on Warren street with a driveway and garage. A fully renovated one-bedroom apartment offers potential for rental income, while its location invites entrepreneurial spirits to redefine its future. Whether as a trendy retail space, chic b&b, the canvas is yours to paint. Schedule your tour today!
Listing by: COLUMBIA COUNTY / Coldwell Banker Advisor Realty / Daniel "Dan" Mahar
$1,199,000
Active

Hudson Area Single Family Home

Active

809 Warren Street Hudson, NY 12534

5 Bed
4 Baths
3314 sqft
MLS# 152029
Virtual Tour
Nestled along Hudson's coveted upper Warren Street, this enchanting home stands as a testament to meticulous restoration and timeless elegance. Once a bustling three-family, it now is a grand single-family with an in-law apartment, blending historic charm with modern allure. Upon entering you see exposed fireplaces (one working) and an expansive space that seamlessly blend. A brand-new open kitchen, joined to the back entrance, beckons for entertainment. Rounding out the first floor is a powder room and grand wet bar. Step outside to discover a rear deck overlooking a private garden oasis a tranquil haven complete with a soothing hot tub, inviting year-round relaxation The second floor has four bedrooms accompanied by two baths, including a luxurious primary bath boasting a spacious shower and standalone tub. Above the primary suite is a third floor garret office/gym nook space with a large cedar closet. Beyond its residential charm, this property presents a myriad of opportunities. The only known house on Warren street with a driveway and garage. A fully renovated one-bedroom apartment offers potential for rental income, while its location invites entrepreneurial spirits to redefine its future. Whether as a trendy retail space, chic b&b, the canvas is yours to paint. Schedule your tour today!
Listing by: COLUMBIA COUNTY / Coldwell Banker Advisor Realty / Daniel "Dan" Mahar
$995,000
Active

Hudson Area Single Family Home

Active

248 Blue Hill Road Hudson, NY 12534

3 Bed
3 Baths
4825 sqft
MLS# 146954
Virtual Tour
Welcome to Griffin Estate, a unique custom home located ONLY 5 minutes south of downtown Hudson. Architectural details including custom entryways, red cedar vaulted ceilings and rough cut beams can be found throughout. The home boasts an indoor pool perfect for year-round swimming, a 1/2 acre pond with a picturesque covered bridge and 8.8 acres of park-like property. With 4,825 square feet of finished living space, the home features an en suite primary bedroom + 2 guest bedrooms on the second floor. The guest bathroom has a steam shower and oversized jacuzzi tub. An incredible suspended staircase leads you to the finished basement which has potential for a fourth bedroom suite. Spacious sunken living room with wood-burning fireplace (currently gas log set) and large picture windows to let in plenty of natural light. The kitchen is well designed for chefs; with stainless appliances, ample countertop space, large pantry, pot filler and two sided fireplace shared with the family room and dining room. The sunroom is perfect for entertaining with billiards table and direct access to the private deck. Including mature gardens and koi pond, a bluestone path leads you from the covered patio to a secret gazebo surrounded by flowering shrubs and gorgeous view overlooking the pond and Blue Hill.The 2 car garage, studio/workshop and basement add an additional 1,692 square feet of practical space to the home's already expansive area. The home generates solar energy with a solar tracker system installed in 2014. Many recent updates including new architectural shingle roof and insulated glass garage doors in 2021 (Please inquire for complete list of updates). Conveniently located just 4 miles south of Hudson/Amtrak and only 8 miles to either the Taconic State Parkway or the NYS Thruway. Listing Agent is related to seller.
Listing by: COLUMBIA COUNTY / Coldwell Banker Advisor Realty / Ryan Wexler