2654 Sleepy Hollow Rd
Description
With an extensive local portfolio in Greene and Columbia counties, this home will be set on a private 2.59 acre lot within the desirable Sleepy Hollow Lake community. This thoughtfully designed residence offers a perfect blend of elegance,...Experience timeless design, quality craftsmanship, and modern comfort in this exceptional new construction to be built home by Paul R. Szafran Carpentry, Inc. (Explore more from Paul R Szafran Carpentry Inc by checking out https://www.paulrszafrancarpentry.com)
With an extensive local portfolio in Greene and Columbia counties, this home will be set on a private 2.59 acre lot within the desirable Sleepy Hollow Lake community. This thoughtfully designed residence offers a perfect blend of elegance, accessibility, and peaceful Hudson Valley living. Located 2.5 hours from NYC, 20 minutes from Hudson's shining Warren Street, and only 15 minutes from Main Street Catskill. Windham Mountain sits a 25 minute drive away making winters full of excitement and upstate wonder. Inside, an open-concept floor plan is highlighted by dramatic scissor trusses soaring above the kitchen and living areas, creating a stunning sense of grandeur and architectural character. A cozy fireplace anchors the living room, making it an inviting space to gather year-round. The beautifully appointed kitchen features quartz countertops with an oversized island and seamless access to the outdoors through elegant French doors that open to the expansive rear porch, an ideal setting for entertaining or enjoying the tranquil wooded surroundings. Sprawling covered front and back porches extend the living space outdoors and provide the perfect place to relax and take in the serenity of the property. The spacious primary suite serves as a private retreat, complete with an ensuite bathroom designed for comfort and convenience. Tiled bathrooms throughout the home offer durability and a refined finish. Central air conditioning ensures year-round comfort. Showcasing timeless board-and-batten siding, the home's exterior delivers classic curb appeal that complements its natural surroundings. Cedar tone accents hug the porch posts, and meticulously surround the doors and garage. Designed for both convenience and versatility, the spacious attached two-car garage offers abundant room for vehicles, storage, hobbies, and recreational gear, complementing the home's thoughtful design and comfortable lifestyle. Built on a slab-on-grade foundation, this thoughtfully designed home offers easy, single-level living, low maintenance ownership, and seamless indoor-outdoor flow. Efficiency central! Exterior walls are concrete ICF block providing top of the line efficiency. Closed cell spray foam insulation will keep the home feeling just right. Radiant heated flors throughout home with on demand hot water heater running off of the same unit. Designed with accessibility in mind, the home is ADA accessible, providing ease of movement and long-term livability without compromising style and luxury. This to be built home can be finished inside with your taste directly with the builder. Photos rendered.
- Listed by Cathleen Hamm • Mahar Real Estate, LLCP: (518)-727-2635 C: (518)-727-2635 cathleenhammre@gmail.com
Property Details for 2654 Sleepy Hollow Road
Property Details for 2654 Sleepy Hollow Road
| Status | Active |
|---|---|
| MLS # | 20262949 |
| Days on Market | 12 |
| Taxes | $462 / year |
| HOA Fees | $2,196 / year |
| Condo/Co-op Fees | - |
| Property Type | Single Family |
| MLS Type | Residential / Single Family Residence |
| Year Built | 2026 |
| Lot Size | 2.60 AC / 113,256 SF |
| County | Greene County |
Location
Building Information for 2654 Sleepy Hollow Road
Payment Calculator
$4,681 per month
30 year fixed, 6.36% Interest
$4,460
$39
$183
Know your buying power with a preapproval and custom rate in minutes
1Property Information for 2654 Sleepy Hollow Road
- Directions: From Rip Van Winkle Bridge, head North on NY-23, turn right onto Spring Street, left onto Union Street, right onto Hillside Drive, left onto Sleepy Hollow Road.
- Township: Athens
- MLS Area Major: Athens
- County: Greene
- Latitude: 42.292559
- Longitude: -73.813112
- MLS Area Major: Athens
- Sign On Property YN: No
- Association YN: Yes
- Association Fee: $183.00
- Association Fee Frequency: Monthly
- Parcel Number: 19228910501400010030000000
- Tax Block: 1
- Tax Legal Description: SHL PH 2 LOT 412
- Tax Annual Amount: $462.00
- Association YN: Yes
- Association Fee: $183.00
- Association Fee Frequency: Monthly
- Attached Garage YN: Yes
- Garage YN: Yes
- Garage Spaces: 2.0
- Garage YN: Yes
- Attached Garage YN: Yes
- Garage Spaces: 2.0
- New Construction YN: Yes
- Lot Size Acres: 2.6
- Above Grade Finished Area: 1966.0
- Below Grade Finished Area: 0.0
- Living Area: 1966.0
- Lot Size Area: 2.6
- Lot Size Units: Acres
- Lot Size Square Feet: 113256.0
- Above Grade Finished Area: 1966.0
- Below Grade Finished Area: 0.0
- Lot Size Acres: 2.6
- Farmhouse: Yes
- Cedar: Yes
- Spray Foam Insulation: Yes
- Under Construction: Yes
- House: Yes
- Owner Name: Paul R. Szafran Carpentry, Inc.
- Total Floor Plans Count: 0
- Property Type: Residential,Single Family Residence
- Year Built: 2026
- Property Sub Type: Single Family Residence
- New Construction YN: Yes
- Page: 162
- Section: 1
- Close Of Escrow: Yes
- HVAC: Yes
- Insulation: Yes
- Tax Assessed Value: 25900.0
- Tax Lot: 3
- Seller Owned: Yes
- Public Sewer: Yes
- Public: Yes
- Stories: 1
- Basketball Court: Yes
- Beach Access: Yes
- Clubhouse: Yes
- Dog Park: Yes
- Golf Course: Yes
- Picnic Area: Yes
- Playground: Yes
- Recreation Facilities: Yes
- Sport Court: Yes
- Tennis Court(s): Yes
- Golf: Yes
- Lake: Yes
- Front Porch: Yes
- Rear Porch: Yes
- Basement YN: No
- Fireplaces Total: 1
- Fireplace YN: Yes
- Room Total: 10
- Bathrooms Total (Integer): 3
- Bathrooms Total (Decimal): 2.5
- Bathrooms Total (Notational): 2.1
- Cooling: Yes
- Heating: Yes
- Bedrooms Total: 3
- Bathrooms Full: 2
- Bathrooms Half: 1
- Bathrooms Half: 1.0
- Fireplace YN: Yes
- Accessible Bedroom: Yes
- Accessible Central Living Area: Yes
- Accessible Closets: Yes
- Accessible Common Area: Yes
- Accessible Doors: Yes
- Accessible Entrance: Yes
- Accessible Full Bath: Yes
- Accessible Hallway(s): Yes
- Accessible Kitchen: Yes
- Central Living Area: Yes
- Central Air: Yes
- French Doors: Yes
- Living Room: Yes
- Tile: Yes
- Wood: Yes
- Slab: Yes
- Radiant Floor: Yes
- Cathedral Ceiling(s): Yes
- One: Yes
- Bathroom: Yes
- Bathroom Level: First
- Dining Room Level: First
- Laundry Level: First
- Living Room Level: First
- Primary Bathroom: Yes
- Primary Bedroom Level: First
- Sign On Property YN: No
- Occupant Type: Owner
- Occupant Name: *** NEW LISTING ***
- Occupant Type: Owner
- Occupant Name: *** NEW LISTING ***
Property History for 2654 Sleepy Hollow Road
| Date | Event & Source | Price | Appreciation |
|---|---|---|---|
| Mar 13, 2026 | Sold (Public Record) Public Record #1936263704 | $62,500 | +8.2% / yr |
| Jan 9, 2025 | Sold (Public Record) Public Record #1549833535 | $57,000 | — |
| Date | Event & Source | Price |
|---|---|---|
| 03/13/2026 | Sold (Public Record) Public Record #1936263704 | $62,500 +8.2% / yr |
| 01/09/2025 | Sold (Public Record) Public Record #1549833535 | $57,000 |
For completeness, we often displays two records for one sale: the MLS record and the public record.
Public Records for 2654 Sleepy Hollow Road
Schools near 2654 Sleepy Hollow Road
Rating | School | Type | Grades | Distance |
|---|---|---|---|---|
| Public - | PK to 4 | |||
| Public - | 4 to 8 | |||
| Public - | 9 to 12 | |||
| Public - | K to 4 |
Rating | School | Distance |
|---|---|---|
Edward J Arthur Elementary School PublicPK to 4 | ||
Coxsackie Athens Middle School Public4 to 8 | ||
Coxsackie Athens High School Public9 to 12 | ||
Coxsackie Elementary School PublicK to 4 |
School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.
Similar Homes
Explore Nearby Homes
- Stockport Homes for Sale
- Athens Village Homes for Sale
- Greenport Homes for Sale
- Lorenz Park Homes for Sale
- Sleepy Hollow Lake Homes for Sale
- Jefferson Heights Homes for Sale
- Catskill Village Homes for Sale
- Coxsackie Village Homes for Sale
- Livingston Homes for Sale
- Claverack-Red Mills Homes for Sale
- Kiskatom Homes for Sale
- Cairo Hamlet Homes for Sale
- Germantown Hamlet Homes for Sale
- Kinderhook Village Homes for Sale
- Clermont Homes for Sale
- Hudson Homes for Sale
- Coxsackie Homes for Sale
- Catskill Homes for Sale
- Athens Homes for Sale
- Leeds Homes for Sale
- Stottville Homes for Sale
- Stuyvesant Homes for Sale
- Claverack Homes for Sale
- Ghent Homes for Sale
- Cairo Homes for Sale
- Stuyvesant Falls Homes for Sale
- West Coxsackie Homes for Sale
- South Cairo Homes for Sale
- New Baltimore Homes for Sale
- Germantown Homes for Sale
- 12051 Homes for Sale
- 12534 Homes for Sale
- 12451 Homes for Sale
- 12414 Homes for Sale
- 12173 Homes for Sale
- 12058 Homes for Sale
- 12192 Homes for Sale
- 12172 Homes for Sale
- 12042 Homes for Sale
- 12174 Homes for Sale
- 12075 Homes for Sale
- 12482 Homes for Sale
- 12526 Homes for Sale
- 12106 Homes for Sale
- 12513 Homes for Sale
No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of any information, descriptions or measurements (including square footage measurements and property condition), such should be independently verified through appropriate means, including, but not limited to, in person inspection and public records, and Compass International Holdings, its subsidiaries, affiliates and independently owned and operated franchisees, and their affiliated agents and associated third parties expressly disclaim any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. Offers of compensation are subject to change at the seller's discretion. No financial or legal advice provided. Equal Housing Opportunity.
Listing Courtesy of Mahar Real Estate, LLC
The source of the displayed data is either the property owner or public record provided by non-governmental third parties. It is believed to be reliable but not guaranteed. This information is provided exclusively for consumers’ personal, non-commercial use. The data relating to real estate for sale or lease on this webpage comes from the the IDX Program of OneKey® MLS, Columbia Greene Northern Dutchess MLS, Hudson Valley Catskill Regional MLS and Ulster County Board of REALTORS. Real estate listings held by brokerage firms other than Compass are marked with a OneKey® MLS, Columbia Greene Northern Dutchess MLS, Hudson Valley Catskill Regional MLS or Ulster County Board of REALTORS Logo. Use of these search facilities other than by a consumer seeking to purchase or lease real estate is prohibited. The accuracy of all information is deemed reliable but not guaranteed and should be verified through personal inspection by and/or with appropriate professionals. The data contained herein is copyrighted by the IDX Program of OneKey® MLS, Columbia Greene Northern Dutchess MLS, Hudson Valley Catskill Regional MLS and Ulster County Board of REALTORS and is protected by all applicable copyright laws. Any unauthorized dissemination of this information is in violation of copyright laws and is strictly prohibited. Information Copyright 2026, OneKey® MLS, Columbia Greene Northern Dutchess MLS, Hudson Valley Catskill Regional MLS and Ulster County Board of REALTORS. All rights reserved. Data last updated: 06/03/2026 05:01 PM