Skip to main content
Serving Buyers & Sellers in Columbia County, NY

374 Tommy Trail G 38, Athens, NY 12015 (MLS# 156605)


$899,900
374 Tommy Trail G 38
Athens, NY 12015
MLS# 156605
Status: Closed
3 beds  |  2 baths  |  2500 sqft


Photo 1
  1 / 60  
Photo 1 Photo 2 Photo 3 Photo 4 Photo 5 Photo 6 Photo 7 Photo 8 Photo 9 Photo 10 Photo 11 Photo 12 Photo 13 Photo 14 Photo 15 Photo 16 Photo 17 Photo 18 Photo 19 Photo 20 Photo 21 Photo 22 Photo 23 Photo 24 Photo 25 Photo 26 Photo 27 Photo 28 Photo 29 Photo 30 Photo 31 Photo 32 Photo 33 Photo 34 Photo 35 Photo 36 Photo 37 Photo 38 Photo 39 Photo 40 Photo 41 Photo 42 Photo 43 Photo 44 Photo 45 Photo 46 Photo 47 Photo 48 Photo 49 Photo 50 Photo 51 Photo 52 Photo 53 Photo 54 Photo 55 Photo 56 Photo 57 Photo 58 Photo 59 Photo 60

Property Description
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

Details
Contract Information
Property Attached YN: Yes
Listing Agreement: Exclusive Right To Sell
Owner Name: William and Joann Sillery Trust
Current Price: $899,900
Original List Price: 899900
Sold Price: $899,900
Status: Closed
Listing Contract Date: 2025-04-07
Property Sub Type: Single Family Residence
Location, Tax, and Legal
911 Address: 374 Tommy Trail, Athens NY 12015
Unit Number: G 38
School District: Coxsackie - Athens Central School District
General Tax: 0
School Tax: 6972
Town Tax: 3614
Village Tax: 0
Tax Annual Amount: 0
Tax Year: 2025
Assessors Full Market Value: 610900
Tax Assessed Value: 252000
Parcel Number: 88.19-2-62
Tax Exemptions YN: No
Zoning Description: Single Family Residential
Directions: Route 385 to main Sleepy Hollow entrance. Make a right at the stop sign onto Sleepy Hollow Road. First left onto Tommy Trail. Log home at the end on right.
General Property Information
Rooms Total: 8
Bathrooms Half: 0
Lot Size Acres: 0.86
Association YN: Yes
Accessibility Features YN: Yes
Association Fee: 215
New Construction YN: No
Association Fee Frequency: Annually
Garage YN: Yes
Attached Garage YN: No
Garage Spaces: 2
Waterfront YN: Yes
Flood Plain YN: No
Senior Community YN: No
Sign On Property YN: No
Disclaimer: Information not guaranteed.
Basement YN: Yes
Fireplace YN: Yes
Fireplaces Total: 1
Spa YN: No
List Price/SqFt: 359.96
Sold Price/SqFt: 359.96
Bedrooms Total: 3
Bathrooms Total: 2
Bathrooms Full: 2
Living Area: 2500
Year Built: 2000
Remarks and Miscellaneous
CGR Public Historical Remarks: Existing Lease Type: Net, Three Quarter Bathrooms: 1, Quarter Bathrooms: 0, Value Range Price: 0.00, Other Buildings: 2-1/2 Car Garage, 2nd Floor: 0, 3rd Floor: 0, Access: Other, Add Rooms First Flr: 0, Add Rooms Other Flr: 0, Add Rooms Secnd Flr: 0, Ag District Discl: No, Ag District: No, Basement Comments: walk out finished basement, Basement SqFt: 0, Certificate of Occ: Yes, Color: Honey stained logs, FIPS Code: 39, Green Features: No, Lead Paint Rep Avail: No, Lease Type: Net, Monthly Common Lease $: 0, Monthly Maintenance Charges $: 0, Pond/Stream: lakefront, stream also, Special Conditions: None/Unknown, Views: Local, Water Rights: Yes, Year Built Exception: 0
Public Remarks: 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
Status Change Information
Status Change Timestamp: 2025-07-24
Concessions: No
Buyer Financing: Conventional
Major Change Timestamp: 2025-07-24T15:33:42Z
Major Change Type: Status Change
Purchase Contract Date: 2025-05-08
Close Date: 2025-07-23
Close Price: 899900
Accessory Dwelling Unit Information
ADU Rented YN: No
Appliances
Dryer: 1
Microwave: 1
Refrigerator: 1
Washer: 1
Water Heater: 1
Other: 1
Architectural Style
Contemporary: 1
Log: 1
Association Amenities
Basketball Court: 1
Beach Rights: 1
Boat Dock: 1
Maintenance Grounds: 1
Picnic Area: 1
Pool: 1
Tennis Court(s): 1
Association Fee Includes
Maintenance Grounds: 1
Snow Removal: 1
Basement
Finished: 1
Community Features
Clubhouse: 1
Fishing: 1
Park: 1
Construction Materials
Frame: 1
Log: 1
Wood Siding: 1
Cooling
Central Air: 1
Electric
200+ Amp Service: 1
Exterior Features
Awning(s): 1
Dock: 1
Private Yard: 1
Storage: 1
Fireplace Features
Double Sided: 1
Glass Doors: 1
Living Room: 1
Wood Burning: 1
Wood Burning Stove: 1
Flooring
Ceramic Tile: 1
Hardwood: 1
Laminate: 1
Foundation Details
Concrete Perimeter: 1
Heating
Forced Air: 1
Propane: 1
Interior Features
Cathedral Ceiling(s): 1
Entrance Foyer: 1
High Speed Internet: 1
Kitchen Island: 1
Laminate Counters: 1
Storage: 1
Track Lighting: 1
Laundry Features
Lower Level: 1
Listing Terms
Trust Conveyance: 1
Trust Deed: 1
Lot Features
Cul-De-Sac: 1
Lake on Lot: 1
Secluded: 1
Views: 1
Wooded: 1
Other Structures
Shed(s): 1
Storage: 1
Parking Features
Driveway: 1
Garage Faces Front: 1
Patio And Porch Features
Deck: 1
Porch: 1
Plumbing
Copper: 1
Pool Features
Association: 1
Possession
Close Of Escrow: 1
Road Frontage Type
Private Road: 1
Road Surface Type
Paved: 1
Roof
Asphalt: 1
Shingle: 1
Sewer
Public Sewer: 1
Special Listing Conditions
Trust: 1
Structure Type
House: 1
Utilities
Cable Connected: 1
Electricity Available: 1
Electricity Connected: 1
Phone Connected: 1
Sewer Available: 1
Water Available: 1
Propane: 1
View
Beach: 1
Lake: 1
Neighborhood: 1
Park/Greenbelt: 1
Trees/Woods: 1
Water: 1
Water Source
Public: 1
Waterfront Features
Beach Access: 1
Lake: 1
Lake Front: 1
Lake Privileges: 1
Window Features
Casement Window(s): 1
Documents Available
Building Restrictions: 1
Drawing/Plans: 1
Seller's Disclosure: 1
Survey: 1
Showing Requirements
Appointment Only: 1
Listing Agent Must Accompany: 1
No Sign: 1
Showing Information
Showing Attended YN: Yes
Showing Instructions: Please use showing time.
Room Types
Bathroom: 1
Bathroom Level: First
Bedroom: 1
Dining Room: 1
Dining Room Level: First
Family Room: 1
Kitchen: 1
Kitchen Level: First
Living Room: 1
Living Room Level: First
Other Room: 1
Other Room Level: Second
Location Tax and Legal
Street Number: 374
Street Name: Tommy Trail
County: Greene
State: NY
Zip Code: 12015
Town (Taxable): Coxsackie
Property Features
Appliances: Dryer; Microwave; Refrigerator; Washer; Water Heater; Other
Architectural Style: Contemporary; Log
Association Amenities: Basketball Court; Beach Rights; Boat Dock; Maintenance Grounds; Picnic Area; Pool; Tennis Court(s)
Association Fee Includes: Maintenance Grounds; Snow Removal
Basement: Finished
Community Features: Clubhouse; Fishing; Park
Construction Materials: Frame; Log; Wood Siding
Cooling: Central Air
Electric: 200+ Amp Service
Exterior Features: Awning(s); Dock; Private Yard; Storage
Fireplace Features: Double Sided; Glass Doors; Living Room; Wood Burning; Wood Burning Stove
Flooring: Ceramic Tile; Hardwood; Laminate
Foundation Details: Concrete Perimeter
Heating: Forced Air; Propane
Interior Features: Cathedral Ceiling(s); Entrance Foyer; High Speed Internet; Kitchen Island; Laminate Counters; Storage; Track Lighting
Laundry Features: Lower Level
Listing Terms: Trust Conveyance; Trust Deed
Lot Features: Cul-De-Sac; Lake on Lot; Secluded; Views; Wooded
Other Structures: Shed(s); Storage
Parking Features: Driveway; Garage Faces Front
Patio And Porch Features: Deck; Porch
Plumbing: Copper
Pool Features: Association
Possession: Close Of Escrow
Road Frontage Type: Private Road
Road Surface Type: Paved
Roof: Asphalt; Shingle
Sewer: Public Sewer
Special Listing Conditions: Trust
Structure Type: House
Utilities: Cable Connected; Electricity Available; Electricity Connected; Phone Connected; Sewer Available; Water Available; Propane
View: Beach; Lake; Neighborhood; Park/Greenbelt; Trees/Woods; Water
Water Source: Public
Waterfront Features: Beach Access; Lake; Lake Front; Lake Privileges
Window Features: Casement Window(s)
Showing Requirements: Appointment Only; Listing Agent Must Accompany; No Sign
Documents Available: Building Restrictions; Drawing/Plans; Seller's Disclosure; Survey
Room Types: Bathroom; Bedroom; Dining Room; Family Room; Kitchen; Living Room; Other Room
Room Information
Room Name Level
Bathroom
BathroomSecond
BathroomFirst
Family Room
Other Room
Other RoomSecond
BedroomSecond
BedroomFirst
BedroomFirst
Living RoomFirst
Dining RoomFirst
KitchenFirst

Listing Courtesy of Keller Williams Realty HV Nort
Listing Agent: Marie Wolpert

Information deemed reliable but not guaranteed.