Welcome to Antler Ridge Estates Where Luxury Meets Nature.Discover a stunning log home in Antler Ridge Estates, a 5,500+ sq ft tri-level masterpiece blending rustic charm with modern luxury. Whether you're dreaming of a forever home, a serene getaway, or a lucrative investment, this yellow pine estate delivers. With breathtaking mountain views and a 5-Star Super Host Airbnb rating, it generates an impressive annual vacation rental income annually.Step Inside Your Mountain Escape:The home's heart exudes warmth and elegance, featuring 30-ft beamed ceilings and a two-story masonry fireplace. A formal dining area flows into a chef-inspired kitchen, complete with stainless steel appliances, granite countertops, and an 8-ft island perfect for gathering. This retreat offers five spacious bedrooms, including a first-floor primary ensuite with a luxurious jetted tub, walk-in closet, and deck access ideal for mornings spent enjoying the peaceful surroundings.An Entertainer's Dream:The lower level provides a sprawling game room, fifth bedroom, bathroom, and easy access to the brand-new hot tub. The heated two-car garage, complete with wood cabinets, a sink, and extra fridge, ensures convenience, while a home security system offers peace of mind.Outside, extensive updates in 2022 and 2023 include a new putting green, swing set, stone patios, firepit, and landscaped yard. Whether hosting BBQs or sipping coffee in the fresh mountain breeze, the outdoor space is perfect for relaxing or entertaining.Unbeatable Catskills Location:Enjoy the best of both worlds, seclusion and convenience.Located just 5 minutes from Windham Mountain Club, local dining, shopping, and golf courses, this home offers easy access to outdoor adventures. Plus, it's only 2.5 hours from NYC, making it an ideal vacation escape or work-from-home haven.A Smart Investment with a proven Airbnb track record, this property combines personal retreat and premium revenue potential. Don't miss your chance to own this ultimate upstate retreat. Schedule a showing today!
For sale
Price cut: $51K (2/3)
$1,499,000
241 Campbell Rd, Ashland, NY 12407
5beds
5,080sqft
Deeded, Single Family Residence
Built in 2005
6.18 Acres Lot
$1,445,400 Zestimate®
$295/sqft
$-- HOA
What's special
Two-story masonry fireplaceStunning log homeHeated two-car garageBreathtaking mountain viewsDeck accessStone patiosWalk-in closet
- 82 days
- on Zillow |
- 394 |
- 23 |
Zillow last checked: 7 hours ago
Listing updated: April 10, 2025 at 08:12am
Listing by:
Coldwell Banker Village Green 518-734-4200,
Regina Tortorella 914-466-0329,
Aaron Joseph Perer 845-514-0186,
Coldwell Banker Village Green
Source: Columbia Greene Northern Dutchess MLS,MLS#: 155926
Originating MLS: Columbia County & Northern Dutchess MLS

Travel times
Tour with a buyer’s agent
Tour with a buyer’s agent
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 5
- Bathrooms: 4
- Full bathrooms: 3
- 1/2 bathrooms: 1
Heating
- Baseboard
Appliances
- Included: Clothes Dryer, Clothes Washer, Dishwasher, Wall Oven, Refrigerator, Water Heater (Electric)
Features
- Flooring: Tile, Wood
- Windows: Double Hung
- Basement: Walk-Out Access
- Number of fireplaces: 1
- Fireplace features: Living Room
Interior area
- Total structure area: 5,080
- Total interior livable area: 5,080 sqft
Video & virtual tour
Property
Parking
- Total spaces: 2
- Parking features: Attached
- Attached garage spaces: 2
Features
- Levels: Tri Level
- Has view: Yes
- View description: Catskills, Country, Far Reaching, Mountain(s), Park/Greenbelt, Trees/Woods
Lot
- Size: 6.18 Acres
Details
- Parcel number: 77.00-1-14.22
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Log Cabin
- Property subtype: Deeded, Single Family Residence
Materials
- Log, Wood Siding
- Foundation: Poured Concrete
- Roof: Asphalt,Shingle
Condition
- Excellent
- Year built: 2005
Utilities & green energy
- Electric: 200+ Amp Service
- Sewer: Septic Tank
- Water: Well
Community & HOA
Community
- Security: Security System
Location
- Region: Ashland
Financial & listing details
- Price per square foot: $295/sqft
- Tax assessed value: $745,200
- Annual tax amount: $20,633
- Price range: $1.5M - $1.5M
- Date on market: 2/3/2025
- Electric utility on property: Yes
- Road surface type: Paved
- Loading
- Loading