Listed by Houlihan Lawrence, Inc, Houlihan Lawrence Inc.
$1,799,000
48 County Route 14 NONE
Details
Property Type Land
Sub Type Farm
Square Footage 2,052
Year Built 1996
Land
Marketing 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.
Listing Contacts
Listed by Houlihan Lawrence, Inc, Houlihan Lawrence Inc.
Valuation Calculator
Login or Sign up to see Valuation Metrics
Sign up for Crexi to see valuation metrics for this property
Loan Amount
$0.00
Annual Debt Service
$--
$--
Annual Cash Flow
$--
$--
Valuation Metrics
0
DSCR
--
Cap Rate
--
ROI
Map
Zoning
LDR-2 ResidentialTwo FamilyLow Density Residential
View municipality zoning documents Upgrade to see the zone description and what's allowed on this property
Upgrade to search and view land use codes
View all 96 uses
View all 96 uses Last updated Mar 16, 2026 For deeper zoning details, reports are available at Zoneomics
Broker Selected Comps View More Comps
Property History
Tax History
Similar Properties
Additional Information
Name
License
Brokerage
Brokerage Phone
Brokerage Address
Is there information that looks off?



















































