Welcome to your dream lakefront retreat! Nestled on a private, oversized lot with 225 feet of direct lake frontage, this beautiful log home at Sleepy Hollow Lake offers the perfect blend of rustic charm and modern comfort.Step inside to a spacious three-bedroom, three-bath layout featuring a breathtaking great room with soaring cathedral ceilings, exposed beams, and expansive windows that frame stunning lake views. The open-concept design flows seamlessly into a warm and inviting kitchen and dining area ideal for entertaining or simply enjoying the tranquility of lakeside living.The primary suite is located in the lofted second floor, offering a private haven with serene views and a full bath. The finished basement provides generous additional living space perfect for a media room, guest accommodations, or recreation area. A rare, oversized three-level garage offers incredible storage, parking, and workshop potential.Enjoy lakeside living to the fullest with your own private dock, perfect for boating, fishing, swimming, or simply relaxing by the water.Located within the desirable Sleepy Hollow Lake community, a private motorboat lake development, residents enjoy access to a wide array of amenities including two swimming pools, tennis and pickleball courts, basketball courts, children's play areas, a lodge, and a tennis clubhouse. Miles of quiet roads throughout the community are ideal for walking, running, or biking in a peaceful, scenic setting.All of this, conveniently located just minutes from Athens, Coxsackie, Hudson, Windham, Hunter, Albany, and Kingston and only 2 hours from New York City, making it the perfect year-round residence or weekend escape.This is more than just a homei t's a lifestyle. Come experience the best of lakefront living at 374 Tommy Trail.CLOSING MUST BE AFTER AUGUST 1, 2025
Pending
$899,900
374 Tommy Trl #G-38, Athens, NY 12015
3beds
2,500sqft
Deeded, Single Family Residence
Built in 2000
0.86 Acres Lot
$876,200 Zestimate®
$360/sqft
$-- HOA
What's special
Expansive windowsModern comfortBeautiful log homePrivate dockPrivate oversized lotFinished basementSerene views
- 19 days
- on Zillow |
- 1,298 |
- 106 |
Zillow last checked: 7 hours ago
Listing updated: April 23, 2025 at 02:49am
Listing by:
Keller Williams Hudson Valley 845-481-2700,
Marie V. Wolpert 914-980-2567
Source: Columbia Greene Northern Dutchess MLS,MLS#: 156605
Originating MLS: Columbia County & Northern Dutchess MLS

Travel times
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 3
- Full bathrooms: 2
- 3/4 bathrooms: 1
Heating
- Forced Air, Hot Air
Cooling
- Has cooling: Yes
Appliances
- Included: Clothes Dryer, Clothes Washer, Microwave, Refrigerator, Oven, Water Heater (Propane)
Features
- Flooring: Ceramic Tile, Hardwood, Laminate
- Windows: Casement
- Basement: Finished
- Number of fireplaces: 1
- Fireplace features: Living Room
Interior area
- Total structure area: 2,500
- Total interior livable area: 2,500 sqft
Property
Parking
- Total spaces: 2
- Parking features: Detached
- Garage spaces: 2
Features
- Has private pool: Yes
- Has view: Yes
- View description: Local, Neighborhood, Park/Greenbelt, Water, Trees/Woods, Beach
- Has water view: Yes
- Water view: Lake,Water,Beach
- Waterfront features: Lakefront, Stream Also
Lot
- Size: 0.86 Acres
Details
- Parcel number: 88.19-2-62
- Zoning: Single Family Residential
- Zoning description: Single Family Residential
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Contemporary,Log Cabin
- Property subtype: Deeded, Single Family Residence
Materials
- Frame, Log, Wood Siding
- Foundation: Poured Concrete
- Roof: Asphalt,Shingle
Condition
- Excellent
- Year built: 2000
Utilities & green energy
- Electric: 200+ Amp Service
- Sewer: Community
- Water: Community
Community & HOA
HOA
- Has HOA: Yes
Location
- Region: Athens
Financial & listing details
- Price per square foot: $360/sqft
- Tax assessed value: $252,000
- Annual tax amount: $10,586
- Price range: $899.9K - $899.9K
- Date on market: 4/7/2025
- Electric utility on property: Yes
- Road surface type: Paved
- Loading