GREENE
241 Campbell Rd, Windham, NY 12496
$1,799,000
- MLS ID: 20231374
- Remarks: Extraordinary, impressive and stunning, this custom-built luxury Yellow Pines log home will captivate and entertain your family and guests. Available fully furnished and can be an excellent, profitable and turnkey air bnb business which also includes "Super Host" status. At the entrance of your driveway you are greeted by stoic buck statues which will set the tone to the theme of your visit. Take in the year-round panoramic mountain views of "Antler Ridge Estates" on your grand and spacious wraparound deck surrounded by this beautifully landscaped property. If entering through the two car garage with automatic doors and a security system, you'll notice some well thought out additions such as being heated, having wood cabinets, a refrigerator and a utility sink which could allow this space to serve many purposes. The living room is the showstopper! A two story stone fireplace is the focal point of a room that can provide plenty of seating to comfortably converse and relax in front of a glowing warm fire. The living room is connected to the kitchen via a formal dining for those special meals. The gourmet kitchen stands out with stainless steel appliances, extensive granite counter tops and a large island that can seat six. There is a lounging area right off the kitchen so you can keep the conversations going while prepping and cooking your latest culinary adventure. There is a large main bedroom on the first floor, which also accesses the wrap around deck which is equppied with a heart shaped two person jetted tub, stall shower, two sinks, more granite counter tops and a vast walk in closet. The prominent stair case in the living room brings you to a second story loft that greets you with the potential for more comfortable seating overlooking the fireplace and living room below. The second floor boasts three more large bedrooms, storage and another full bath all perfectly balanced between a modern look and rustic feel. The immense finished basement offers so much opportunity to customize it to your own taste and hobbies but is currently set up as an impressive game room. There is an additional bedroom in the walk out basement as well with ceramic tiled floors, recessed lighting, a mainly open layout and so much versatile space. A 2022 hot tub right outside the basement allows you to soak your stress and troubles away. A sizable paver patio gives plenty of space for extensive outdoor seating, cooking, and conversation. Outdoor lighting and firepits make for a great night time atmosphere. Everything is included to utilize "Antler Ridge Estates" as a primary home, secondary residence or investment opportunity. Although you are 4 miles from Windham Mountain ski resort which can provide many trails to ski and snowboard and a snowtubing park as well, this isn't just a seasonal getaway. Think kayaking, golfing, fishing, canoeing, bike park, sky ride and many walking and hiking trails. Restaurants, farms and all the views, especially in the fall, will help show what a spectacular location this is. It's not just a luxury log home, it's a lifestyle.
- Listing Category: Residential
- Status Category: Active
- Area, sq ft: 5367 sq ft
- Zone: 01
- Acreage: 6.18
- Year built: 2005
- Age: 11-20
- Bedrooms: Five
- Bathrooms: 4
- Full Baths: Three
- Half Baths: One
- Living Room Level: 1
- Dining Room Level: 1
- Kitchen Level: 1
- Family Room Level: B
- Bedroom 1 Level: 1
- Bedroom 2 Level: 2
- Bedroom 3 Level: 2
- Bedroom 4 Level: 2
- Den Level: 1
- Basement Level: B
- Other 1 Level: B
- SqFt 1st: 1789
- SqFt 2nd: 1789
- SqFt 3rd: 1789
- Living Room Room Size: 25'10 X19'9
- Family Room Room Size: 36'2x35'5
- Kitchen Room Size: 14'7x13'10
- Dining Room Room Size: 19'x12'7
- Den Room Size: 13'6x 12'3
- Bedroom 1 Room Size: 14'x14'5
- Bedroom 2 Room Size: 14'6x21'
- Bedroom 3 Room Size: 13'9x13'10
- Bedroom 4 Room Size: 23'6x13'3
- Other Room 1 Size: 11'11x11'4
- Basement: Finished, Full, Walk Out, Interior Access
- Other Rooms: Bedroom, Den, Loft, Utility Room, Media Room, Playroom, Main Bedroom, First Floor Bedroom
- Amenities: Garden Area, Hot Tub, Play Area
INTERIOR FEATURES
- Kitchen Description: Gourmet
- Appliances: Dishwasher, Dryer, Microwave, Range Hood, Refrigerator, Washer
- Flooring: Ceramic, Hardwood
- Fireplace Description: Stone, Wood
- Fireplace Location: Living Room
- Cooling/Air Conditioning: Ceiling Fan
- Additional Interior Features: Insulated Doors, Insulated Windows, Dig.l Program Thermostat, Walk In Closets, Skylights, Master Bath, Whirlpool Tub, Garage Door Opener, Smoke Detector, Carbon Monoxide Detector
UTILITIES
- Heat Source: Baseboard, Zoned
- Heating Fuel: Oil
- Hot Water: Oil
- Water: Drilled Well
- Plumbing: Mixed
- Electricity: Circuit Breakers, Underground, 200 Amps
- Sewer: Septic-ingr.
- Utility Level: B
EXTERIOR FEATURES
- Garage Type: Carport Attached
- Garage/Parking Extras: Driveway, Off Street, 2-car
- Driveway: Gravel
- Style: Log
- Style: Log
- Construction: Log
- Porch: Deck, Open, Patio
- Roof: Asph Shingle
- Lot Features: Landscaped, Slope-gently
- Views: Mountain, Panoramic
- Water Features: Stream
- Additional Exterior Features: Hot Tub, Landscaped, Outside Lighting
- Lot Dimensions: Irreg
- Lot: 14
LOCATION DETAILS
- Area/Town: Greene
- School District: Wind-ash-jewett
- Lot/Site: Rural
- County: Greene County
- Directions: From Nys Thruway Exit 21 Catskill: Take Route 23 West Towards Windham. Make A Right On Campbell Rd. House Is On The Left #241.
LISTED BY
- Office Name: Howard Hanna Rand Realty
- Agent First Name: Philip
- Agent Last Name: Kelly
View on map / Neighborhood
This Greene County property is located in Ashland and has been listed on Grist Mill Real Estate. This property is listed at $1,799,000. It has Five bedrooms, 4 and is 5367 sq ft in area. The property was built in 2005.