My Office's Listings

Some or all of the listings below are provided by the Advisor Realty office.
$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,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,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
$799,900
Active

Hudson Area Single Family Home

Active

2323 US Route 9 Hudson, NY 12534

4 Bed
4 Baths
3344 sqft
MLS# 152249
Welcome to a timeless treasure in Livingston, as it holds a coveted place on the National Register of Historic Places. This distinguished property stands as a testament to the architectural excellence of 1908, boasting mission-style stucco and a clay tile roof that evokes a sense of Old World charm. On the market for the first time in more than fifty years, this unique home is ready for new owners. While still in the commercial zone, set back from the hustle and bustle of Route 9, this two-story residence offers the perfect blend of convenience and tranquility. Set on a 2.19-acre lot adjacent to a working agricultural farm, it features original Tiffany light fixtures, rich dark wood trim, and hardwood floors throughout. With four bedrooms and four bathrooms, it provides ample space and comfort for every member of the household. Entertain guests in style within the spacious living areas, featuring two cozy fireplaces, a woodstove for chilly evenings, and a formal dining room adorned with a sparkling crystal chandelier. Step out onto the side porch and unwind by the tranquil fishpond nestled amidst the lush greenery or take a refreshing dip in the backyard inground pool. Adding to the allure of this remarkable country property are a two-story barn, a shed, and a garden shed offering endless possibilities for storage, hobbies, or artistic endeavors. As a bonus there is a quaint one-story accessory house, perfect for accommodating visitors or generating rental income. Don't miss the opportunity to make this piece of history your own. Schedule your showing and discover the endless possibilities at this historic 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