Skip main navigation
Active
  • $895,000

    2654 Sleepy Hollow Road, Athens, NY 12015

    3beds
    1,966sqft
    Loading
    Single Family Residence
    Built in 2026
    2.6 Acres Lot
    $880,200 Zestimate®
    $455/sqft
    $183/mo HOA

    What's special

    Open-concept floor planExpansive rear porchTimeless board-and-batten sidingClassic curb appealBeautifully appointed kitchen
    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.
    23 days
    |
    500
    |
    12
    |

    Zillow last checked:

    Listing updated:

    Listed by:

    Mahar Real Estate, LLC 518-965-1465,

    Cathleen Hamm 518-727-2635

    Source: HVCRMLS,MLS#: 20262949MLS Logo

    Loading...

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 3
      • Bathrooms: 3
      • Full bathrooms: 2
      • 1/2 bathrooms: 1
      Primary bedroom
      • Level: First
      Bedroom
      • Level: First
      Bedroom
      • Level: First
      Primary bathroom
      • Level: First
      Bathroom
      • Level: First
      Other
      • Level: First
      Dining room
      • Level: First
      Kitchen
      • Level: First
      Laundry
      • Level: First
      Living room
      • Level: First
      Heating
      • Radiant Floor
      Cooling
      • Central Air
      Features
      • Cathedral Ceiling(s), Other
      • Flooring: Tile, Wood
      • Doors: French Doors
      • Has basement: No
      • Number of fireplaces: 1
      • Fireplace features: Living Room
      Interior area
      • Total structure area: 1,966
      • Total interior livable area: 1,966 sqft
      • Finished area above ground: 1,966
      • Finished area below ground: 0

      Property

      Parking
      • Total spaces: 2
      • Parking features: Garage - Attached
      • Attached garage spaces: 2
      Accessibility
      • Accessibility features: Accessible Bedroom, Accessible Central Living Area, Accessible Closets, Accessible Common Area, Accessible Doors, Accessible Entrance, Accessible Full Bath, Accessible Hallway(s), Accessible Kitchen, Central Living Area
      Features
      • Levels: One
      • Stories: 1
      • Patio & porch: Covered, Front Porch, Rear Porch
      • Has view: Yes
      • View description: Neighborhood, Trees/Woods
      Lot
      • Size: 2.6 Acres
      Details
      • Parcel number: 19228910501400010030000000
      • Zoning: Res

      Construction

      Type & style
      • Home type: SingleFamily
      • Architectural style: Farmhouse
      • Property subtype: Single Family Residence
      Materials
      • Board & Batten Siding, Cedar, Concrete, Spray Foam Insulation
      • Foundation: Slab
      • Roof: Asphalt
      Condition
      • Under Construction
      • New construction: Yes
      • Year built: 2026

      Utilities & green energy

      • Electric: 200+ Amp Service
      • Sewer: Public Sewer
      • Water: Public
      Green energy
      • Energy efficient items: HVAC, Insulation, Water Heater

      Community & HOA

      Community
      • Features: Clubhouse, Golf, Lake, Park, Playground, Pool, Tennis Court(s)
      HOA
      • Has HOA: Yes
      • Amenities included: Basketball Court, Beach Access, Clubhouse, Dog Park, Golf Course, Picnic Area, Playground, Recreation Facilities, Sport Court, Tennis Court(s)
      • HOA fee: $183 monthly
      Location
      • Region: Athens

      Financial & listing details

      • Price per square foot: $455/sqft
      • Tax assessed value: $25,900
      • Annual tax amount: $462
      • Date on market: 6/3/2026
      • Road surface type: Paved

        Estimated market value

        $880,200

        $836,000 - $924,000

        $4,528/mo

        Price history

        DateEventPrice
        6/3/2026Listed for sale$895,000+1332%$455/sqft
        Source: HVCRMLS #20262949 Report a problem
        4/9/2026Sold$62,500+9.6%$32/sqft
        Source: Public Record Report a problem
        1/10/2025Sold$57,000-10.2%$29/sqft
        Source: HVCRMLS #153133 Report a problem
        11/16/2024Contingent$63,500$32/sqft
        Source: Columbia Greene Northern Dutchess MLS #153133 Report a problem
        10/26/2024Pending sale$63,500$32/sqft
        Source: Columbia Greene Northern Dutchess MLS #153133 Report a problem
        6/7/2024Listed for sale$63,500-2.3%$32/sqft
        Source: Columbia Greene Northern Dutchess MLS #153133 Report a problem
        6/3/2024Listing removed--
        Source: Columbia Greene Northern Dutchess MLS #146648 Report a problem
        6/1/2023Listed for sale$65,000$33/sqft
        Source: Columbia Greene Northern Dutchess MLS #146648 Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2025-- $25,900
        2024-- $25,900
        2023-- $25,900 +35.6%
        2022-- $19,100
        2021-- $19,100
        2020-- $19,100
        2019-- $19,100
        2018-- $19,100
        2017$753 $19,100 +12.4%
        2016-- $17,000
        2015-- $17,000
        2014-- $17,000
        2013-- $17,000 +4.3%
        2012-- $16,300
        2011-- $16,300
        2010-- $16,300
        2009-- $16,300
        2008-- $16,300
        2007-- $16,300
        2006-- $16,300
        2005-- $16,300
        2004-- $16,300
        2003-- $16,300 +7.2%
        2002-- $15,200
        2001-- $15,200 -19.6%
        2000-- $18,900

        Find assessor info on the county website

        Monthly payment

        Estimated monthly payment$1,822
        All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
        HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
        Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
        See how much you could borrow to make a competitive offer.

        Climate risks

        Neighborhood: Sleepy Hollow Lake

        Getting around

        0 / 100
        Car-Dependent
        9 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating

        A local agent can set up tours, give advice and negotiate with sellers.

        Browse local experts

        Similar homes

        Skip to the end of the carouselSkip to the beginning of the carousel