Columbiaville NY Real Estate & Homes for Sale

This beautifully updated home in Athens, NY, offers the perfect blend of comfort and charm, nestled on a generous 1.3-acre corner lot with over 500 feet of road frontage. The property is move-in ready and features wood and tile floors, modernized kitchen and bathrooms, spacious rooms, and abundant storage. The large, fully fenced yard is ideal for relaxing, playing, or entertaining, with a deck perfect for watching river fireworks. There are two comfortable apartments for hosting guests or relatives, making this home versatile and welcoming for all. Athens, NY, is a vibrant small town with a rich community spirit and plenty of activities to keep you engaged. Enjoy music by the river all summer, fresh baguettes from the Catskill Bread Company, art shows at the Athens Cultural Center, and fun trivia nights at the local brewery. Stay active with yoga at Tenth House Health and explore the local culinary scene at Seconds Restaurant or Stewart House. For outdoor enthusiasts, there are ample opportunities for adventure, including kayaking, eagle watching, and biking. You can also take the ferry to Hudson for shopping or hop on a train to NYC for a day trip. This home is ready for your personal touches, whether you choose to live in it full-time, use it as an AirBnB, or explore other options. Embrace the peace and joy this special property in Athens has to offer.

Newly constructed, 2016 townhouse with two detached studios. The luxury townhouse is the complete package offering prime location, luxurious finishes, fine craftsmanship, an ideal open floor plan spanning 2 stories. Every surface & system is to state-of-the-art standards. Features include open high-end kitchens with sitting areas, many custom design extras, 8 bedrooms, 8 bathrooms, central AC. The courtyard studios are modern design also with AC, opening onto the enclosed garden with four garage bays below. Perfect work or guest space. The fenced-in backyard is fully landscaped with stone and slate stairways, and pathways. A true masterwork of design. Maintenance free, in turn-key condition. Walking distance to Amtrak and the restaurants and amenities on Hudson's Warren Street, and a few short blocks from the Hudson River. Investment, live/work.

Newly constructed, 2016 townhouse with detached studio. The luxury townhouse is the complete package offering prime location, luxurious finishes, fine craftsmanship, an ideal open floor plan spanning 2 stories. Every surface & system is to state-of-the-art standards. Features include open high-end kitchens with sitting areas, many custom design extras, 4 bedrooms, 4 bathrooms, central AC. The courtyard studio is of modern design also with AC, opening onto the enclosed garden with two garage bays below. Perfect work or guest space. The fenced-in backyard is fully landscaped with stone and slate stairways, and pathways. A true masterwork of design. Maintenance free, in turn-key condition. Walking distance to Amtrak and the restaurants and amenities on Hudson's Warren Street, and a few short blocks from the Hudson River. Parcel #109.44-1-20.100

LOCATION! LOCATION! LOCATION! WELCOME HOME TO THIS VERY ENERGY EFFICIENT WITH AN ULTIMATE AIR SYSTEM AND BLOWN INSULATION. 3 BED 1.5 BATH TOWNHOUSE BUILT IN 2011. ONE BLOCK FROM THE POPULAR WARREN ST. VERY BRIGHT WITH FLOOR TO CEILING WINDOWS. FRESHLY PAINTED, FENCED IN BACKYARD AND 2 PARKING SPACES. BASEMENT IS ALMOST FINISHED JUST NEEDS FLOORING. NOTHING TO DO BUT MOVE IN.

Step back in time with this 1881 2-story vintage home, filled with Old-World Charm and Character. Opportunity awaits with an interior ready for a move-in while the exterior just needs a little TLC to shine. Located in the Athens Village Historic District, near the Hudson River and a short ride to Trendy Hudson Downtown. Ideal for Nature Lovers, with Kayak launches, Hiking, and Wineries nearby. Features a front porch, exquisitely detailed entry doors, a spacious Main Level with an Open Floor plan, Large Eat-In Kitchen with a back staircase leading to the second level. Three spacious bedrooms on the second level with an updated full bath. Freshly Painted, Original Trim Work, and Newer Laminate Floors. Municipal Water & Sewer. Zoned for Residential or Special Commercial uses. Explore the Possibilities at this Prime Village location!

Nestled in the charming Historic District of Athens, NY, this magnificent Solid Brick Church built in 1832 offers endless possibilities for a visionary owner. Steeped in history, this architectural gem presents a rare opportunity to create something truly extraordinary. Whether you dream of preserving its sacred beauty as a place of worship or envision a stunning conversion into a one-of-a-kind residence, professional office, or many other options, the choice is yours. With its soaring ceilings, intricate stained glass windows, Hardwood Floors, and bell tower, this property exudes character and charm at every turn. The main level features a Sanctuary, 2 Offices, a Conference Room, and a Study. The Walk-Out Lower Level flooded with natural light offers a Large Kitchen, a Massive Recreational Area, Bathrooms, and Utility Areas. Perfect for a variety of uses and activities! The building boasts almost 6000 square feet of space, with a one-car detached garage and ample off-street parking available. Municipal Water and Sewer. Located in a PRIME Village Location near 2nd Ave with easy access to local amenities and the picturesque Hudson River, this property is a gateway to unlimited potential. Perfect for outdoor enthusiasts with a kayak launch, hiking, and exploring trails nearby. Discover trendy Hudson NY, wineries, and more just a stone's throw away. Embrace the opportunity to bring new life to this historic treasure and create a legacy that will endure for generations to come.

Built circa 1860, Bollard Pearl House stands as a historic gem in the heart of Hudson, blending original architectural details with striking design and modern luxury. Nestled on a quiet neighborhood street, yet just a short stroll from the vibrant bustle of Warren Street's restaurants and shops, this charming residence has undergone a designer renovation. Every detail has been thoughtfully considered, from the comprehensive remodel of the kitchen and primary bathroom to the installation of new air conditioning and electric systems, and designer fixtures, to name just a few. Available fully furnished with private parking, a fenced-in yard, and wrap-around porch, the Bollard Pearl House offers idyllic neighborhood living in one of Upstate's most coveted cities.

Built circa 1860, Bollard Pearl House stands as a historic gem in the heart of Hudson, blending original architectural details with striking design and modern luxury. Nestled on a quiet neighborhood street, yet just a short stroll from the vibrant bustle of Warren Street's restaurants and shops, this charming residence has undergone a designer renovation. Every detail has been thoughtfully considered, from the comprehensive remodel of the kitchen and primary bathroom to the installation of new air conditioning and electric systems, and designer fixtures, to name just a few. Available fully furnished with private parking, a fenced-in yard, and wrap-around porch, the Bollard Pearl House offers idyllic neighborhood living in one of Upstate's most coveted cities.

A Brick Federal with pedigree, this c1820 Warren Street building was built by one of Hudson's founding fathers and later owned by the Van Rensselaer family. Comprised of three units, there is a fabulous owner's duplex taking up the top two of three floors, while a retail space and a 1BR apartment make up the first. Sited on a double lot, the backyard is wide with beautiful gardens and a three bay garage with endless potential. The house is rich in periods and history having been renovated in different eras with distinct tastes, until the current owners did a full, cohesive renovation utilizing the best local craftsmen. The upstairs duplex has an open concept third floor with vaulted ceilings and exposed ductwork. The kitchen and common spaces are here to capture a fabulous view of the Catskill range. The second floor comprises two bedrooms and an office, the master is fabulously generous and takes over the entire eastern wing. The retail space is gorgeous with big street facing windows it runs the western length of the building and has views of the garden in the back. There is also a one bedroom apartment, well appointed, well sized, and recently renovated. A chance to own part of Hudson's rich history, 239 Warren offers both a great investment and lifestyle.

First time available in 22 years! ln the heart of historic Hudson, on the prime 500 block just steps off Warren, come make this sunny, double-lot, 2-unit your own. A gracious side lawn with mature trees leads to ample, off-street parking in the rear. Very unusually for downtown Hudson, the property also boasts a detached, five-bay garage, providing space for 4 cars, with one bay as a workshop/studio. Looking to create more cash flow? Consider adding a second story above the garage to create two additional apartment units. For the current residence, to the left of the entrance foyer, you'll find the main +/-1,600, two-floor unit with exposure on three sides + three bedrooms and a full bath. And off the foyer to the right, you have a separate, studio apartment with its own full bath. The building also benefits from a new, high-efficiency, on-demand natural gas furnace. So many live/work possibilities! The current owner has loved calling 15-17 N Fifth home for the past two+ decades, now it's your turn to bring your new creative vision to the property.

Charming Home in Hudson - Welcome to your own charming oasis in the heart of Hudson! This delightful home offers the perfect blend of character, comfort, and convenience in a sought-after location. Built in the 1900s and situated within walking distance to Warren Street - shops, restaurants, and cafes - or you can simply enjoy the serenity of a private backyard with a hot tub. Step inside to discover a cozy and welcoming well-maintained home highlighted by wood floors and an abundance of natural light. There's a spacious living room, a cute country kitchen that's both functional and stylish, and a separate dining area that offers a perfect setting for enjoying meals or entertaining guests. A bedroom off the kitchen which could also be an office plus a half-bath and convenient washer/dryer finish off the ground floor. Upstairs you'll find a full bathroom and three nice-sized bedrooms, each boasting tons of character. Windows fill each room with natural light, providing a sunny and cheerful ambience. Outside, the fenced backyard with a deck is a haven for outdoor living, perfect for grilling and entertaining. The covered front porch adds to the curb appeal and provides a welcoming entrance for guests. Additional features include off-street parking for added convenience and on-demand water for efficiency. Furnishings available for purchase separately. Hudson has become one of the most popular towns in the Hudson Valley with nationally-recognized restaurants, hotels, and numerous artisan shops and boutiques - all within walking distance! Minutes to the Amtrak station, traveling to and from NYC is a breeze. Other nearby towns to explore include Catskill (10 minutes), Red Hook (25 mins), Rhinebeck (35 mins).

Get in while the prices are still low for these 55 and over Mobile Home Park Manufactured homes. These 3 br 2 bath brand new manubactured homes START at $148,000 with many styles and options to choose from.Conveniently located to all. Please note that pictures shown are NOT actual homes but merely suggestions or examples of different homes available, double wides may be possible on some lots. Different upgrades and ammenities available for additional cost. For example can build garage for additional cost, etc.Lot rents include taxes and may vary depending upon size of lot/home, starting at $629/mo , some pets may be possible

One of Hudson's most unique, important Warren Street multi-use buildings, strategically located in the prime 500 Warren Street block. Complete gut renovation 2022. First floor, operating retail space and an office currently rented. Second and third floors are renovated apartments. P-stone patio/parking area in back off Prison Alley,AboveGrade:5084,EQUIPMENT:Carbon Monoxide Detector,Smoke Detectors,FLOORING:Ceramic Tile,Wood,FOUNDATION:Brick,Stone,Level 1 Desc:RETAIL. OFFICE BA-1, STORAGE, FITTING ROOMS,Level 2 Desc:BR-1 BR-1 BA-2 LR DR KITCH PORCH/DECK,Level 3 Desc:BR-3 BR-4 BA-3 LR DR KITCH,OTHERROOMS:Professional Suite,ROOF:Rubber

Located on a quiet cul-de-sac, this 1875 Victorian home boasts 5 bedrooms, all with ensuite bathrooms, a large living room, library, dining room and an additional guest powder room as well as a fully equipped kitchen. Modern touches were added in 2008 when the property was converted into a bed and breakfast, which operated successfully for over 12 years. Two wood burning fireplaces and two gas fireplaces create the perfect atmosphere in winter, and plenty of outdoor space are ideal for entertaining in warmer weather. Period details are found throughout the property including a sweeping front staircase, pocket doors and inlaid hardwood floors. While the home is move in ready, some TLC offers the buyer an opportunity to apply their own creative touches to make this historic house your home. (interior photographs are staged),AboveGrade:3900,Cooling:Attic Fan,EQUIPMENT:Carbon Monoxide Detector,Smoke Detectors,ExteriorFeatures:Landscaped,FLOORING:Ceramic Tile,Parquet,Wood,FOUNDATION:Stone,Heating:Gas,InteriorFeatures:French Doors,Level 1 Desc:LR, DR, KIT, LIB, BR BA,Level 2 Desc:BR, BR, BR, BR, BA BA BA BA,ROOF:Metal,Rubber

This is a must-see property, Located in Historic Hudson and just an easy commute form NYC. This building was built in 1959 it features a commercial store front, newly refinished hardwood floors, updated half bathroom, open floor plan, high ceilings and large front windows with beautiful views of Park Pl Park. Above the commercial space you have 3 1, bedroom apartments above which could be rented year-round or as vacation rentals. The 2 Front apartments are ready to rent. The Back apartment still needs updating. Updates for this property include heating hot. water system, new roof, front stairs and much more. This is a must see.

Turnkey Hudson multifamily only 5 minutes to Warren St. Plenty of of off-street parking. 4 recently renovated units include new windows, appliances, updated baths and kitchens plus other upgrades. All units separately metered. Off street parking for 4 cars. Outbuilding features a two bedroom, loft-style, duplex apartment with a garage space that could be easily repurposed as a studio for your creative endeavors. The builder of renowned NYC restaurants including Balthazar, Pastis, Diner, Marlow & Sons, Reynard and The Ides at the Wythe Hotel, presents this turnkey Hudson 4-family, just minutes to Warren Street. Three of the units are in the main building, of which two have been recently renovated, including new windows, appliances, and updated baths and kitchens. The 3rd floor apartment is currently being renovated as well. All feature greenspace views across the street. The 4th apartment is in a separate, newly renovated outbuilding with a 2BR, 1 full bath duplex apartment and a garage space that could be easily repurposed as a studio. This is the perfect opportunity for a house hacker! All units separately metered. New renovations also include new roof and electric service. Off street parking for 4 cars.

Nestled on desirable Union Street in Hudson, a short stroll from vibrant Warren Street, Olive House stands as a captivating turn-key two-family home. Recently upgraded with clean design elements, new systems, and a renovated backyard, this home retains the coveted allure of its circa 1930s charm. Offering numerous possibilities for expansion and use, Olive House presents a rare move-in ready opportunity brimming with potential. Live in one unit while generating rental income from the other, utilize as an artist live-work space, or easily convert to a grand single-family dwelling in one of Upstate New York's most sought-after locations.

Nestled on desirable Union Street in Hudson, a short stroll from vibrant Warren Street, Olive House stands as a captivating turn-key two-family home. Recently upgraded with clean design elements, new systems, and a renovated backyard, this home retains the coveted allure of its circa 1930s charm. Offering numerous possibilities for expansion and use, Olive House presents a rare move-in ready opportunity brimming with potential. Live in one unit while generating rental income from the other, utilize as an artist live-work space, or easily convert to a grand single-family dwelling in one of Upstate New York's most sought-after locations.

Nestled on desirable Union Street in Hudson, a short stroll from vibrant Warren Street, Olive House stands as a captivating turn-key two-family home. Recently upgraded with clean design elements, new systems, and a renovated backyard, this home retains the coveted allure of its circa 1930s charm. Offering numerous possibilities for expansion and use, Olive House presents a rare move-in ready opportunity brimming with potential. Live in one unit while generating rental income from the other, utilize as an artist live-work space, or easily convert to a grand single-family dwelling in one of Upstate New York's most sought-after locations.

Just a short drive from the top of the quaint and historic Hudson River town of Athens, you'll find this solid, southern-facing 1950's ranch with oak hardwood floors on 6 full acres. So many possibilities - bring you creativity! Plus, with current 3-acre zoning, why not consider subdividing? You could then update the current ranch, and add a new-build on your adjoining, new 3-acre lot as well. With Athens permitting Airbnb, you could reside in one and offset your carry by renting the other. Additional noteworthy features include: brick fireplace with a wood-stove insert...new 8-person jacuzzi (installed in 2021 for $17,000)...spacious rear and side yards...and a detached 2-car garage. Additional upgrades include: new furnace (2020)...new 200-amp electrical service + separate sub-panel to garage...stainless steel range in kitchen...and new full-size washer & dryer.

Discover the timeless elegance of this Edwardian-era gem in Hudson, NY. Built in 1908, this stately residence joins historic charm with modern comfort.With four bedrooms, two bathrooms, an office, high ceilings, first floor parlors and fireplace this home provides for both daily living and entertaining. Ascend to the walk-up attic, spanning over 500 square feet, and let your imagination soar.Upgrades include a seamless 40 year metal roof, solar panels for energy efficiency, durable aluminum siding, new back porch room, new kitchen and new bathrooms. Tucked away in the detached garage behind the house up the hill, discover the charming cabin room featuring a wood stove, rear west facing balcony and own entrance. It's the perfect spot to unwind and reconnect with nature.

Discover the timeless elegance of this Edwardian-era gem in Hudson, NY. Built in 1908, this stately residence joins historic charm with modern comfort, offering a captivating blend of old-world grandeur and contemporary convenience. With four bedrooms, two bathrooms, an office, high ceilings, first floor parlors and fireplace this home provides for both daily living and entertaining. Ascend to the walk-up attic, spanning over 500 square feet, and let your imagination soar - whether a cozy retreat, artist's studio, or peaceful sanctuary, the possibilities are endless. Upgrades include a seamless 40 year metal roof, solar panels for energy efficiency, durable aluminum siding, new back porch room, new kitchen and new bathrooms. Adorned with gleaming hardwood floors, the interior exudes a warm and inviting ambiance. Additionally, tucked away in the detached garage behind the house up the hill, discover the charming cabin room featuring a wood stove, rear west facing balcony and own entrance. It's the perfect spot to unwind and reconnect with nature without leaving the comfort of home. Just a block from upper Warren St and mile from the Hudson Amtrak station, commuting to New York City or nearby destinations is effortless. Explore the eclectic shops, gourmet restaurants, and cultural attractions of Hudson, all within reach. Don't miss your chance to make this treasure your own - schedule a showing today and embark on a journey through the enchanting past and present of Hudson living! (Public Square Footage does not count Attic or Sunroom)

OLIVER WISWALL HUDSON RIVER HOUSE c1835 Indulge in the allure of mesmerizing views that will captivate your senses and imagination. Perched atop Mt. Merino, the iconic Oliver Wiswall House stands as a beacon of timeless elegance, offering commanding forever vistas of the majestic Hudson River. Originally built in 1835 by one of Hudson's esteemed mayors and founder of Greenport, this historic Greek Revival masterpiece is steeped in a rich tapestry of heritage. Set on 39 acres this residence commands not only the tranquil Hudson River but also offers sweeping panoramas that encompass the iconic Athens lighthouse and the picturesque Catskill Mountains painting the horizon. Rarely does an opportunity arise to own a piece of history so deeply entrenched in the fabric of the region. Step inside to discover a meticulous and thoughtful restoration, where every detail has been methodically preserved and enhanced. From the grandeur of the classic brick Greek Revival architecture to the intricate details of stately moldings, marble fireplaces, and most original doors and windows, the Oliver Wiswall House exudes an air of timeless sophistication. The interior layout features a gracious center hall entry leading to the formal living room, library and formal dining room all adorned with iconic moldings and meticulous craftsmanship that effortlessly blends historic charm with modern comforts all bathed in natural light pouring in countless oversized windows. A seamless transition takes you to the later postmodernism addition, where a grand great room awaits boasting curved, soaring ceilings a chef-worthy open kitchen, gracious dining round, fantasy mud room, pantry, and laundry area, all thoughtfully designed to complement the home's historic grandeur. With four bedrooms and three and a half baths, including the upstairs sumptuous primary suite, guest en-suite, and two additional bedrooms and bath, all flooded with natural light, high ceilings and offering captivating river views, this home is a sanctuary of comfort and luxury. Step outside onto multi-level decks and a patio, where you can immerse yourself in the mesmerizing expanse of the river's beauty. Whether you're a star-gazer or simply seeking a tranquil retreat, the Oliver Wiswall House offers the perfect sanctuary amidst its sprawling lawns and panoramic views. Just moments to Hudson, Amtrak and to all the Hudson Valley has to offer while just 2 hrs to NYC

Make this Kinderhook Victorian Farmhouse your home with 3 beds, 2.5 baths, screened porch, a rocking chair front porch and a spacious outdoor paver patio surrounded by lush plantings of Hydrangeas, Lilacs, Fruit Trees and plenty of room to garden more. A short stroll to the center of Kinderhook and all it has to offer. As you walk into the center hall, you are greeted with a graceful and original curved stairway that leads to 3 bedrooms, laundry room, a spacious and airy bathroom with both a shower and pedestal tub which looks out to the gardens. The primary bedroom also has an en-suite showered bathroom. On the main foor, the North Sitting room boasts a modern gas stove and a Jack-and-Jill 1/2 bath that also opens to the dining room. If the 1/2 bath were locked or walled off, the sitting room could be converted to a bedroom with 1/2 bath. To the South of the stairway are the 2nd sitting room and dining room that has served many a dinner. Off the dining room is the entry to the attached screened porch with entraces to the fenced side yard as well as the large patio. Built in 1900's, this sweet home captures the sunset on the NW facing rocking chair front portch and SE facing morning sun from the walled paver patio, garden, and expansive back yard. The single garage is a rear entry, with a paved parking turn-around and parking for 2 or 3 more cars. Even with the fenced vegetable garden, the property has plenty of space for a pool, pool house and/or large gardening shed or greenhouse. The Village of Kinderhook boasts a very active community life with a Saturday Farmers Market, the Kinderhook Memorial Library, a Garden Club and the home to the Columbia County Historical Society and the Museum and Historical Buildings. For the art lovers and collectors, check out The School as well as several smaller galleries, new eating establishements such as Morningbird, Aviary, Saisonnier and more to come!,AboveGrade:1640,APPLIANCES:Water Softener,Basement:Interior Access,Sump Pump,Below Grnd Sq Feet:750,ExteriorFeatures:Outside Lighting,FLOORING:Wood,FOUNDATION:Masonry,Heating:Zoned,Level 1 Desc:KITCHEN, DINING RM, LIVING RM, DEN, SCREENED PORCH, 1/2 BATH,Level 2 Desc:PRIMARY BED, EN SUITE BATH, 2 BEDROOMS, 1 FULL BATH,ROOF:Asphalt Shingles,Unfinished Square Feet:750

Welcome to a world of opportunity in Athens. This three-bedroom home has recently been meticulously renovated top to bottom, ready for its new owners to move right in. With brand new appliances, gas furnace, and water tank, this property offers modern convenience and comfort. Access to the bedrooms upstairs is possible via two separate staircases, and outside you can enjoy the ambiance of a gentle stream right at your doorstep. Discover the tranquility of 1309 Schoharie Turnpike- your perfect retreat awaits.