luxury houses with pool for sale Columbia County, United States

Welcome to an exceptional Hudson Valley retreat, offering unparalleled space, comfort, and recreational amenities across 56+ private acres. This stunning 6 bedroom, 6.5 bath estate is the ultimate compound or a lucrative opportunity for investors seeking a proven Airbnb performer. Nestled in a secluded setting, the property features a swimmable pond with its own docks and bridge, plus scenic trails perfect for snowmobiling, hiking, and cross-country skiing--all from your own backyard. Designed for gatherings and entertaining, the grand open-concept living, dining, and kitchen area is anchored by a dramatic stone fireplace with a propane stove insert. The chef's kitchen is outfitted with two refrigerators, two ovens, a five-burner stove, and a wine fridge--ideal for preparing feasts for a crowd. An expansive laundry room boasts three washers and six dryers to handle large groups with ease. The indoor heated pool, personal gym, and game room, complemented by a second cozy fireplace with propane stove insert, ensures endless indoor fun, while two private cabins offer exciting renovation potential. Updated mechanicals, on-demand propane hot water, a whole house generator, and a detached two-car garage with its own well provide peace of mind and convenience. Property outfitted with 8 kayaks and a paddle boat. Sub-dividable acreage allows for future expansion or investment flexibility. Whether seeking a weekend sanctuary, a multifaceted compound, or a high-performing rental, this extraordinary property offers boundless possibilities for relaxation, recreation, and return.