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
Closed
$899,900
374 Tommy Trail #G 38, Athens, NY 12015
3beds
2,500sqft
Single Family Residence
Built in 2000
0.86 Acres Lot
$900,000 Zestimate®
$360/sqft
$-- Estimated rent
What's special
Zillow last checked: 7 hours ago
Listing updated: July 24, 2025 at 08:33am
Listed by:
Marie Wolpert 914-980-2567,
Keller Williams Realty HV Nort
Bought with:
Patricia Meyers, 49ME1117394
Lake and Mountain Realty, LLC
Source: HVCRMLS,MLS#: 156605

Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 2
- Full bathrooms: 2
Bedroom
- Level: First
Bedroom
- Level: First
Bedroom
- Level: Second
Bathroom
- Level: Second
Bathroom
- Level: First
Dining room
- Level: First
Kitchen
- Level: First
Living room
- Level: First
Other
- Level: Second
Heating
- Forced Air, Propane
Cooling
- Central Air
Appliances
- Included: Other, Water Heater, Washer, Refrigerator, Microwave, Dryer
- Laundry: Lower Level
Features
- Cathedral Ceiling(s), Entrance Foyer, High Speed Internet, Kitchen Island, Laminate Counters, Storage, Track Lighting
- Flooring: Ceramic Tile, Hardwood, Laminate
- Basement: Finished
- Number of fireplaces: 1
- Fireplace features: Double Sided, Glass Doors, Living Room, Wood Burning, Wood Burning Stove
Interior area
- Total structure area: 2,500
- Total interior livable area: 2,500 sqft
Property
Parking
- Total spaces: 2
- Parking features: Garage Faces Front, Driveway
- Garage spaces: 2
- Has uncovered spaces: Yes
Features
- Patio & porch: Deck, Porch
- Exterior features: Awning(s), Dock, Private Yard, Storage
- Pool features: Association
- Has view: Yes
- View description: Beach, Lake, Neighborhood, Park/Greenbelt, Trees/Woods, Water
- Has water view: Yes
- Water view: Lake,Water
- Waterfront features: Beach Access, Lake, Lake Front, Lake Privileges
Lot
- Size: 0.86 Acres
- Features: Lake on Lot, Cul-De-Sac, Secluded, Views, Wooded
Details
- Additional structures: Shed(s), Storage
- Parcel number: 88.19262
- Zoning description: Single Family Residential
- Special conditions: Trust
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Contemporary,Log
- Property subtype: Single Family Residence
- Attached to another structure: Yes
Materials
- Frame, Log, Wood Siding
- Foundation: Concrete Perimeter
- Roof: Asphalt,Shingle
Condition
- New construction: No
- Year built: 2000
Utilities & green energy
- Electric: 200+ Amp Service
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Cable Connected, Electricity Available, Electricity Connected, Phone Connected, Sewer Available, Water Available, Propane
Community & neighborhood
Community
- Community features: Clubhouse, Fishing, Park
Location
- Region: Athens
HOA & financial
HOA
- Has HOA: Yes
- HOA fee: $215 annually
- Amenities included: Basketball Court, Beach Rights, Boat Dock, Maintenance Grounds, Picnic Area, Pool, Tennis Court(s)
- Services included: Maintenance Grounds, Snow Removal
Other
Other facts
- Listing terms: Trust Conveyance,Trust Deed
- Road surface type: Paved