REQUEST A TOUR If you would like to see this home without being there in person, select the "Virtual Tour" option and your agent will contact you to discuss available opportunities.
In-PersonVirtual Tour
Listed by: Houlihan Lawrence Inc.
$ 1,799,000
Est. payment | /mo
7 Beds
3 Baths
2,052 SqFt
$ 1,799,000
Est. payment | /mo
7 Beds
3 Baths
2,052 SqFt
Key Details
Property Type Vacant Land
Sub Type Farm
Listing Status Active
Purchase Type For Sale
Square Footage 2,052 sqft
Price per Sqft $876
MLS Listing ID 20252798
Bedrooms 7
Full Baths 3
Year Built 1996
Property Sub-Type Farm
Source Hudson Valley Catskills Region Multiple List Service (Ulster County Board of REALTORS®)
Property Description
Set atop 24.8 breathtaking acres with panoramic views of the Catskill Mountains, rolling horse pastures, and neighboring apple orchards, This former thoroughbred breeding farm is a rare Hudson Valley offering that seamlessly blends equestrian living, country luxury, and investment opportunity. Whether envisioned as a private retreat, a boutique boarding or training equine operation, a Hudson Valley weekend compound, a luxury short-term rental destination, a multi-generational country estate, or a long-term land investment with 4 subdivided lots, Long View Farm & Stables offers an increasingly rare combination of natural beauty, versatility, privacy, and future potential.
At the center of the property is a warm and inviting 1,476-square-foot contemporary residence featuring 3 bedrooms and 2 full baths. Vaulted cathedral ceilings, an impressive stone fireplace, and expansive windows frame the surrounding landscape and flood the home with natural light. A wrap-around porch offers the perfect setting for morning coffee overlooking the orchards or evening sunsets across the Catskills. The main level primary suite provides convenience and comfort, while additional guest rooms and flexible living space allow for home office, library, or creative studio use.
Beyond the main residence, a separate carriage house expands the property's lifestyle and income possibilities. The upper-level 1-bedroom apartment -- currently operating as a successful short-term rental -- provides approximately 900 square feet of beautifully private guest accommodations with ongoing Airbnb income potential. Below, a spacious 2.5-car garage, workshop area, laundry, and additional utility space create functionality for hobbyists, equestrians, or future expansion.
Designed for horse lovers or outdoor enthusiasts, the property includes a 6-stall barn with electric and water, tack room and a lofted hay storage.There's also a double run-in shed for additional shelter as well as multiple fenced paddocks and rolling pastureland ideal for horses, alpacas, llamas, hobby farming, or recreational use. A picturesque manmade swimmable pond completes the setting.
Already subdivided into 4 accessible parcels, the property also offers significant long-term value and flexibility for investors, multi-generational living, or future development opportunities -- an increasingly rare asset in Columbia County's highly sought-after market. With panoramic Catskill Mountain views, rolling pastures, neighboring orchards, income-producing guest accommodations, and nearly 25 acres of subdivided land in one of Columbia County's most desirable locations, this is a rare opportunity to own a truly distinctive piece of the Hudson Valley lifestyle. Privately sited just minutes from downtown Hudson's acclaimed restaurants, galleries, boutiques and cultural energy, this exceptional property captures the essence of upstate living -- peaceful, scenic, and endlessly versatile. Convenient to Amtrak and Rip Van Winkle Bridge.
At the center of the property is a warm and inviting 1,476-square-foot contemporary residence featuring 3 bedrooms and 2 full baths. Vaulted cathedral ceilings, an impressive stone fireplace, and expansive windows frame the surrounding landscape and flood the home with natural light. A wrap-around porch offers the perfect setting for morning coffee overlooking the orchards or evening sunsets across the Catskills. The main level primary suite provides convenience and comfort, while additional guest rooms and flexible living space allow for home office, library, or creative studio use.
Beyond the main residence, a separate carriage house expands the property's lifestyle and income possibilities. The upper-level 1-bedroom apartment -- currently operating as a successful short-term rental -- provides approximately 900 square feet of beautifully private guest accommodations with ongoing Airbnb income potential. Below, a spacious 2.5-car garage, workshop area, laundry, and additional utility space create functionality for hobbyists, equestrians, or future expansion.
Designed for horse lovers or outdoor enthusiasts, the property includes a 6-stall barn with electric and water, tack room and a lofted hay storage.There's also a double run-in shed for additional shelter as well as multiple fenced paddocks and rolling pastureland ideal for horses, alpacas, llamas, hobby farming, or recreational use. A picturesque manmade swimmable pond completes the setting.
Already subdivided into 4 accessible parcels, the property also offers significant long-term value and flexibility for investors, multi-generational living, or future development opportunities -- an increasingly rare asset in Columbia County's highly sought-after market. With panoramic Catskill Mountain views, rolling pastures, neighboring orchards, income-producing guest accommodations, and nearly 25 acres of subdivided land in one of Columbia County's most desirable locations, this is a rare opportunity to own a truly distinctive piece of the Hudson Valley lifestyle. Privately sited just minutes from downtown Hudson's acclaimed restaurants, galleries, boutiques and cultural energy, this exceptional property captures the essence of upstate living -- peaceful, scenic, and endlessly versatile. Convenient to Amtrak and Rip Van Winkle Bridge.
Location
State NY
County Columbia
NEARBY SCHOOL & BUSINESS
