Skip main navigation
Off market
  • $1,607,385

    26 Hamburg Rd, Catskill, NY 12414

    6beds
    12,000sqft
    SingleFamily
    Built in 1903
    17.3 Acres Lot
    $-- Zestimate®
    $134/sqft
    $6,095 Estimated rent

    Home value

    Not available

    Estimated sales range

    Not available

    $6,095/mo

    Zestimate® history
    Loading...

    Owner options

    List your home for rent

    $6,095/mo

    Rent Zestimate®

    Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

    Learn more

    $6,095/mo

    Rent Zestimate®

    Refinance and save

    $11,056/mo

    Est. payment

    Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.

    See today's rates

    $11,056/mo

    Est. payment

    Explore your selling options

    Work with a Zillow partner agent

    Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.

    Get started

    List with your own agent

    Get your home in front of millions of buyers by listing it on Zillow.

    Learn how to do it

    Sell it yourself

    Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).

    List your home

    What's special

    Totally incredible Estate covering over 17 magnificent acres with one quarter of a mile Hudson River frontage. The views are breathtaking! This 12,000 sq. ft. 6 bedroom, 5 bath, 6 fireplace brick mansion has been meticulously renovated from top to bottom over the years. The current owner has traveled the world and has brought that appreciation of various schools of woodworking and architecture with him to complete this massive project. Top European craftsmen were brought in for their superb expertise and taste. Everything is top of the line in materials and workmanship. The estate has marble walkways, garden walls offering privacy and a park like setting. The spacious gourmet kitchen has a center island with a 4-foot grill for cooking and warming dishes. The refrigerator and freezer spaces are hidden in the custom cabinets. All the cabinets have crystal pulls. Just off the kitchen is a Winter Garden room with fully glassed walls and ceiling. This is radiant heated in addition to the solar effect. Besides a great room for entertaining, this space could be a botanical garden and or an artist studio. The main floor also includes a formal dining room overlooking the Hudson and outside terrace, a study with oak cabinets, shelving and ceiling. The formal living room has a wonderful Robert Adams low relief ceiling, fireplace and antique lattice work leaded glass doors. One level up brings you to the generously sized master bedroom suite with fir flooring, fire brick fireplace and a high relief ceiling. The fully lava stone bath has a double sink, large tub, shower and bidet. The walk-in cedar lined closet is enormous with a center brass folding table. The shelves are redwood with space for all your clothing needs. On the same level are two additional bedrooms and full bath.

    This property is off market, which means it's not currently listed for sale or rent on Zillow. This may be different from what's available on other websites or public sources.

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 6
    • Bathrooms: 5
    • Full bathrooms: 5
    Heating
    • Oil
    Cooling
    • Central, Wall
    Appliances
    • Included: Dishwasher, Dryer, Microwave, Range / Oven, Refrigerator, Washer
    Features
    • SMOKE DETECTOR, CARBON MONOXIDE DETECTOR, FRENCH DOORS, INSULATED WINDOWS, STORM WINDOWS, WALK IN CLOSETS, INSULATED DOORS, MASTER BATH, GARAGE DOOR OPENER
    • Flooring: Hardwood
    • Basement: FULL, WALK OUT, FINISHED, INTERIOR ACCESS, GARAGE ACCESS
    • Attic: STAND UP
    • Has fireplace: Yes
    Interior area
    • Total interior livable area: 12,000 sqft

    Property

    Parking
    • Total spaces: 2
    • Parking features: Garage - Attached
    Features
    • Exterior features: Brick
    • Has spa: Yes
    • Has view: Yes
    • View description: Water, Mountain
    • Has water view: Yes
    • Water view: Water
    Lot
    • Size: 17.30 Acres
    • Features: LEVEL, PRIVATE, WATER FRONTAGE, LANDSCAPED, MEADOW, SECLUDED, OTHER/SEE REMARKS, PARKING LOT, ADDITIONAL LAND AVAILABLE
    Details
    • Parcel number: 1926011561428

    Construction

    Type & style
    • Home type: SingleFamily
    Materials
    • brick
    • Roof: Slate
    Condition
    • Year built: 1903

    Utilities & green energy

    • Sewer: SEPTIC-INGR.

    Community & neighborhood

    Location
    • Region: Catskill

    Other

    Other facts
    • Class: RESIDENTIAL
    • For Sale: For Sale
    • FLOORS: HARDWOOD, MIXED, WOOD, CERAMIC, MARBLE, RADIANT
    • GARAGE/PARKING EXTRAS: DRIVEWAY, UNDER, 2-Car, OFF STREET, LOT-PAVED, SECURED
    • HEATING FUEL: OIL
    • KITCHEN DESCRIPTION: EAT - IN, CUSTOM CABINETS, PANTRY, GOURMET, ISLAND
    • LOT FEATURES: LEVEL, PRIVATE, WATER FRONTAGE, LANDSCAPED, MEADOW, SECLUDED, OTHER/SEE REMARKS, PARKING LOT, ADDITIONAL LAND AVAILABLE
    • PLUMBING: MIXED, COPPER
    • WATER: MUNICIPAL
    • BASEMENT: FULL, WALK OUT, FINISHED, INTERIOR ACCESS, GARAGE ACCESS
    • HOT WATER: OIL
    • PORCH: GLASS ENCLOSED, PATIO
    • Garage Capacity: Two
    • Garage Type: Garage Attached
    • APPLIANCES: DISHWASHER, DRYER, MICROWAVE, RANGE, REFRIGERATOR, WASHER, RANGE HOOD, OVEN-BUILT IN, RANGE-BUILT IN, INDOOR GRILL
    • FIREPLACE LOCATION: LIVING ROOM, OTHER/SEE REMARKS, DINING ROOM, BEDROOM
    • OTHER BUILDINGS: SHED, WORKSHOP, ADDITIONAL LIVING UNIT, OTHER/SEE REMARKS, GUEST HOUSE, ADDITIONAL GARAGE, OFFICE
    • SEWER: SEPTIC-INGR.
    • LOT/SITE: RURAL
    • INTERNET ACCESS: CABLE, PHONE LINE
    • VIEWS: WATER, MOUNTAIN, RIVER
    • WATER FEATURES: WATER FRONT, POND, RIVER, WATER ACCESS
    • FIREPLACE DESCRIPTION: BRICK
    • INTERIOR FEATURES: SMOKE DETECTOR, CARBON MONOXIDE DETECTOR, FRENCH DOORS, INSULATED WINDOWS, STORM WINDOWS, WALK IN CLOSETS, INSULATED DOORS, MASTER BATH, GARAGE DOOR OPENER
    • OTHER ROOMS: FLORIDA SUN ROOM, OFFICE, LIBRARY
    • CONSTRUCTION: BRICK
    • SIDING: BRICK
    • ELECTRICITY: CIRCUIT BREAKERS, OTHER, UNDERGROUND
    • DRIVEWAY: BLACKTOP
    • EXTERIOR FEATURES: FENCE, LANDSCAPED, FENCED FULL, STORM WINDOWS, OUTSIDE LIGHTING, PAVED WALKWAY, HOT TUB, PRIVACY FENCE
    • ATTIC: STAND UP
    • WATER WAYS: HUDSON RIVER
    • COOLING/AIR CONDITIONING: WALL UNIT
    • AMENITIES: HOT TUB, REC ROOM
    • MISCELLANEOUS FEATURES: FRENCH DOORS, BAR-WET, SECURITY SYSTEM, CENTRAL VACUUM
    • HEAT SOURCE: RADIANT
    • ROOF: SLATE
    • STYLE: ESTATE, MANSION
    • Listing Agreement: Yes
    • County: Greene County
    • Townships: Catskill

    Price history

    DateEventPrice
    12/2/2025Listing removed$7,499,000$625/sqft
    Source: Global MLS #202524937 Report a problem
    8/31/2025Listed for sale$7,499,000-6.3%$625/sqft
    Source: Global MLS #202524937 Report a problem
    8/7/2025Listing removed$7,999,999$667/sqft
    Source: HVCRMLS #20250795 Report a problem
    4/3/2025Listed for sale$7,999,999+0%$667/sqft
    Source: HVCRMLS #20250795 Report a problem
    7/29/2024Listing removed--
    Source: HVCRMLS #20240812 Report a problem

    Public tax history

    YearProperty taxesTax assessment
    2024-- $522,400
    2023-- $522,400
    2022-- $522,400

    Find assessor info on the county website

    Neighborhood: 12414

    Nearby schools

    GreatSchools rating
    Schools provided by the listing agent
    • District: Catskill School District

    Source: The MLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.