luxury houses with terrace for sale Columbia County, United States

The Philmont Collection presents a rare opportunity to acquire a 36-unit multifamily portfolio encompassing nine buildings across seven tax lots in the heart of Philmont's National Register Historic District. Spanning approximately 26,606 square feet, the collection combines immediate scale, strong in-place cash flow, historic character, and meaningful redevelopment potential within one of the Hudson Valley's most closely watched village investment markets. Strategically clustered within a few walkable blocks of one another, the portfolio includes seven stabilized income-producing assets together with two historic value-add buildings, creating a level of operational efficiency and market presence rarely available in a single acquisition. The collection comprises 36 residential units with 48 bedrooms and 28 bathrooms, offering a diverse mix of apartments and duplex residences that support broad tenant appeal and stable occupancy. The stabilized core portfolio is projected to generate approximately $350,000-$360,000 in annual NOI, providing attractive current returns while preserving opportunities for future value enhancement. Ownership has invested substantially throughout the portfolio in capital improvements, infrastructure upgrades, and operational efficiencies designed to improve long-term performance and reduce operating costs. A cornerstone asset within the collection, 62 Main Street has undergone extensive renovation, including updated residential units, restored facade improvements, enhanced insulation, conversion from central oil heat to individual electric systems, and renovated bathrooms. These improvements, together with portfolio-wide upgrades, position the collection as a well-maintained and professionally operated investment. Current operations utilize the DoorLoop management platform for leasing, maintenance coordination, rent collection, tenant communication, applications, and screening, facilitating a seamless transition for future ownership. The portfolio also includes the historic front and rear buildings at 7 Church Street, presenting a compelling redevelopment opportunity within Philmont's historic core. Subject to purchaser verification and approvals, these buildings may be eligible for substantial federal and New York State historic rehabilitation tax incentives, creating a potentially powerful avenue for future value creation and income growth. Long appreciated for its architectural character and strategic location, Philmont continues to attract investors, entrepreneurs, artists, and designers drawn to its affordability relative to neighboring Hudson, its historic building stock, and its ongoing revitalization. Significant public and private investment, adaptive reuse projects, and preservation initiatives continue to strengthen the village's long-term trajectory. Ideally situated just minutes from the Taconic State Parkway and approximately fifteen minutes from Hudson and Amtrak service to New York City, the portfolio enjoys convenient access to the Berkshires, Hawthorne Valley Farm, Art Omi, hiking trails, skiing, boating, waterfalls, acclaimed dining destinations, and the cultural amenities that define the Hudson Valley lifestyle. Combining immediate income, operational scale, historic character, redevelopment potential, and an extraordinary village-wide footprint, The Philmont Collection represents a truly uncommon opportunity to establish a meaningful position within a growing and increasingly recognized Hudson Valley market. MLS information reflects the primary parcel only. Seller reserves the right to sell individual assets or subsets of assets separately from the portfolio offering. Complete financial statements, rent rolls, parcel information, and supporting materials are available upon request. Annual tax amount reflects the entire portfolio.

Imagine never tiring of your own backyard. Nestled on one of the prettiest roads in Hillsdale, this beautiful single-level home is a front-row seat to rolling meadows, distant hills, and the quiet magic of the changing seasons. This sun-drenched, single-level home offers an effortless lifestyle framed by stunning, panoramic views. Inside, an expansive open floor plan invites the outside in. The thoughtfully appointed, updated kitchen flows seamlessly into a generous living area anchored by custom built-ins and a cozy wood-burning fireplace. Wall-to-wall windows grace the formal dining room, ensuring every meal is accompanied by breathtaking scenery. Both the living and dining rooms offer direct access to a sprawling rear deck, perfect for entertaining. A tranquil sun-room provides a versatile space, ideal for a home office or a quiet retreat. Down a private hall, the sleeping wing awaits. The primary suite is a true haven, featuring a second fireplace, a charming window seat for reading, a large walk-in closet, and an en-suite bath. Two additional well-proportioned bedrooms with ample closet space share a pristine hall bathroom. A generous two-car attached garage and a full basement offer abundant storage and convenience right off the main entry.Outside, the 8.3-acre grounds are a serene blend of manicured lawn, wild meadow, and mature plantings. The location is truly stellar: less than five minutes to Catamount Mountain Resort for year-round adventure, and just moments from

A Classic Modern Farmhouse with Incredible Views - This home has been thoughtfully updated to provide a seamless blend of style and comfort. The property features a resplendent in-ground pool, a spacious swim pond, and a three-car garage with an inviting guest suite above.The main residence welcomes you with a charming wrap-around porch and an enchanting screened porch, both perfect for enjoying the dynamic and ever-changing views. The interior is bright and lively, with each space thoughtfully designed to capture the natural beauty of the surroundings.The gourmet kitchen, a convivial hub with a grand stone fireplace, offers direct access to the screened porch and serves as the perfect backdrop for culinary exploration and social gatherings. The first floor also includes a welcoming foyer, a serene bedroom suite, and an elegant formal living room.Upstairs, the master suite is a haven of sophistication, complete with a stone fireplace and ample space for relaxation. Two additional guest bedrooms share a Jack and Jill bathroom, providing comfort and privacy for friends.The finished lower level is dedicated to leisure and repose, crafted with the ultimate goal of relaxation in mind. Here, in this tranquil setting, you'll find the peace and privacy you desire, all within a home that exudes charm and character.

All of the charm of an old farmhouse with none of the headaches. This c2005 build has sweeping views of the Catskill Mountains and loads of charm. Down a long, tree lined driveway, you're just two minutes from the historic hamlet of Germantown but you feel like you're in a world of your own. Peaceful, private and quiet, 336 Main Street truly offers the best of both worlds. Rocking chairs line the porch to watch the show as the sun sets over the mountains, a fire pit sits in the yard and hammocks hang in the trees. The eight acres have been beautifully landscaped with low maintenance, perennial gardens, and the rolling green lawn brings your eye to the mountains. A bucolic view, the only building in sight is a church steeple in the distance. Inside, you'll find high ceilings and walls of windows and glass doors to let the outside in-- the house was truly built to frame the view. The chef's kitchen is an absolute dream with a large island, a Sub Zero refrigerator, Viking gas range, two sinks and two dishwashers. A screened in porch runs the length of the house, perfect for entertaining, while there are quiet sitting rooms and an office tucked off to the side with dreamy views of the landscape and mountains. Upstairs there are three bedrooms, all ensuite. The primary has a private balcony & a large bathroom with a double vanity, a soaking tub and a large walk-in shower. The third floor has been built out with bunk beds, perfect for overflow or a place to park the kids. 336 Main is the ultimate in country living-- it leaves no stone unturned with its modern conveniences, old world charm, and those quintessential Hudson Valley pastoral views. Just 10m to Hudson & Amtrak, 15m to Rhinebeck village and 2h north of NYC.

Escape the hustle of city life and discover Bellavista Country Estate, a grand 12,000-square-foot Georgian brick residence set on over 25 private acres in the foothills of the Berkshires, ideally situated between the Hudson River Valley and the Berkshires. Offering 6 to 9 beautifully appointed bedrooms, including three full suites, five bathrooms, multiple fireplaces, and both a fully stocked eat-in kitchen and a formal dining room, the estate blends elegance and comfort with ease. Recreation and relaxation abound, with a spacious in-ground pool, a serene pond, and direct access to miles of hiking and snowshoeing trails, including those of the Old Chatham Hunt Club. Indoors, guests enjoy a full gym, a game and entertainment room with arcade favorites, a home theater, a library of hundreds of books, and a finished attic, while a 4,500-square-foot barn with foosball, ping pong, and bar space provides additional room for gatherings and events. Perfect for weddings, anniversaries, family celebrations, and private retreats, Bellavista also offers access to private chefs, caterers, and event planning support, with every detail—from fiber-optic internet and full-house generators to weekly pool and grounds maintenance—thoughtfully attended to. Since 2011, the estate has been a successful luxury rental for vacations and retreats, equally suited to private full- or part-time residence, a hybrid work-from-home escape, or an unforgettable destination getaway. Just minutes from Chatham, Hudson, and Kinderhook, and a short drive to Lenox, Stockbridge, and Great Barrington, the estate is surrounded by farm-to-table dining, art galleries, organic markets, and the renowned Crandell Theater, with easy access via the Taconic Parkway or I-87 from New York City, I-90 from Boston, Amtrak to Penn Station, or Albany International Airport.

Enjoy the best of country life gazing across the rolling hills toward the Taconic Mountains through oversized windows that frame the landscape like artwork. This light-filled home offers an open living layout designed for both relaxation and entertaining.Inside, you'll find warm character and thoughtful details, including reclaimed vintage oak floors that add richness and authenticity throughout. The spacious living areas flow seamlessly, bringing in natural light and surrounding views at every turn.Step outside to your own private setting featuring a large deck - perfect for morning coffee or evening gatherings - and a peaceful private pond that enhances the property's serene, country feel. Ideally located just minutes from the Taconic State Parkway and the charming village of Millerton, you'll enjoy convenient access while still feeling worlds away. Millerton is known for its quaint shops, inviting cafés, and small-town charm, as well as access to the scenic Harlem Valley Rail Trail - perfect for walking, biking, and enjoying the surrounding countryside.A 3D Walkthrough Tour is available in the digital Lookbook or by request.

Newly completed and set on 11.7 private acres in the heart of Hillsdale, this architect-designed 4-bedroom, 4-bath modernist residence combines striking contemporary architecture with sweeping pastoral and mountain views in every direction. Arriving via a long private driveway, rolling lawns and open fields unfold toward a home defined by bold geometric forms, expansive walls of glass, and a seamless connection to the surrounding landscape. Just minutes from the Hamlet of Hillsdale, Catamount Mountain Resort, Great Barrington, and Hudson, the property offers a rare balance of architectural refinement, privacy, and access to the region’s most desirable destinations. The residence is centered around a dramatic great room with a soaring 20-foot vaulted ceiling and a wood-burning fireplace clad in richly toned chestnut marble. Floor-to-ceiling glass and oversized Arcadia sliding doors dissolve the boundary between interior and exterior, opening onto more than 540 square feet of covered outdoor living space designed for year-round entertaining and relaxed outdoor living. Throughout the home, natural light shifts across clean architectural lines and warm materiality, reinforcing a strong connection between structure and landscape. The kitchen serves as both a design centerpiece and functional workspace, featuring custom walnut cabinetry crafted by a Brooklyn cabinetmaker, integrated Fisher & Paykel and Bosch appliances, an oversized monolithic island, and a 48-inch double-oven gas range. A fully equipped butler’s pantry and bar area provides additional prep space, storage, second dishwasher, and additional refrigeration, allowing the main kitchen to remain clean and open for entertaining. The primary suite is a private retreat with vaulted ceilings, a custom dressing room, and a spa-like bath finished in dramatic Calacatta Violetta marble, featuring a soaking tub, oversized shower, and fluted glass steel-framed doors. Upstairs, a second ensuite bedroom offers its own walk-in closet and marble-appointed bath, complemented by an additional guest bedroom suite. A versatile fourth bedroom on the main level provides flexible use as a guest suite, office, media room, or wellness space with direct access to the outdoor terrace. Designed for high-performance modern living, the home includes spray foam insulation, high-performance windows, forced-air heating and central air conditioning, on-demand hot water, Lutron lighting controls, remote-access thermostats, generator hookup readiness, and a detached heated 26' x 26' two-car garage. Located just minutes from Catamount Mountain Resort and within easy reach of Great Barrington and Hudson, the home places owners at the center of the Hudson Valley and Berkshires lifestyle. Days might begin with coffee overlooking the fields, followed by a visit to the Saturday farmers market, skiing at Catamount, or hiking nearby trails. Afternoons can be spent browsing Hudson’s celebrated design and antique shops or exploring the galleries, bookstores, and restaurants of Great Barrington. Evenings bring performances at local theaters and live music venues, or a quiet return home as the light settles across the landscape. The setting balances architectural refinement, outdoor recreation, and cultural depth in equal measure. A rare expression of contemporary Hudson Valley living, where architecture, light, and landscape are held in perfect balance. An adjoining 6.73-acre parcel is also available for purchase, offering the opportunity to expand the estate or create a private family compound. (listing agent has a financial interest in the property)