15 Trout Creek RoadGermantown, NY 12526MLS Number 4827597

  • Price: $564,900
  • Est. Mortgage of $/month
$/month over payments
Federal 30-year interest rate: 4.94% last updated on Nov 15, 2018
* All Figures are estimates. Check with your bank or proposed mortgage company for actual interest rates.
This product uses the FRED® API but is not endorsed or certified by the Federal Reserve Bank of St. Louis.
  • 5Bedrooms
  • 1.76Acreage
  • 5Bathroom
  • 1992Year Built

The original owner/builder of this stunning custom designed private retreat has taken meticulous care of this property, and it shows everywhere you look. Set well back from the road, you will marvel at the long tree lined driveway that leads to the picturesque estate like grounds that feature a 4,000 sq ft main residence and separate caretakers cottage. Highlights: Gourmet kitchen with custom cabinetry, granite counter tops and stainless appliances; Master bedroom suite with hardwood floors, sitting area, and master bath featuring a jetted tub and steam shower; 4 additional spacious bedrooms; 3rd floor game room with full bath; Walk out lower level rec room and workshop; 2 Zone central air with individual compressors; 5 zone heating; All solid wood interior doors; Security system; Lush landscaping with pergola, koi pond, and many specimen trees; Red Hook Schools; Caretaker Cottage features a living room, bedroom, full kitchen with dining area, and loft. This is a very special property.

Listed by Renee Revson of Realty Executives W.S.R.

Ask A Question

Do not fill in this field:

More Info

Basic Information

  • List Price$564,900
  • MLS Number4827597
  • Property TypeSingle Family
  • Square Feet5084
  • Bedrooms5
  • Bathroom5
  • Broker NameRealty Executives W.S.R.
  • List Agent Full NameRenee Revson


  • Acreage1.76


  • Sewer DescriptionSeptic
  • GarbagePrivate
  • Heating FuelOil Above Ground
  • Heating TypeBase Board, Hot Water
  • Heating Zones5
  • HotwaterElectric Stand Alone


  • Zip12526
  • Address15 Trout Creek Road
  • High School DistrictRed Hook
  • Junior HighLinden Avenue
  • Building Number15
  • StreetTrout Creek Road
  • CityClermont
  • StateNY
  • CountyColumbia County
  • Elementary SchoolMill Road
  • High SchoolRed Hook


  • Virtual TourClick Here
  • StatusACT
  • Air ConditioningCentral
  • View Count2


  • Siding DescriptionBrick, Stone, Stucco, Wood
  • Property StyleTudor
  • Construction DescriptionFrame
  • Basement DescriptionFull, Walk Out
  • Attic DescriptionFull, Partially Finished, Walkup
  • Fireplaces1
  • Year Built1992


  • Amenities
    • Balcony
    • Eat in Kitchen
    • Formal Dining Room
    • Foyer
    • Granite Countertops
    • Hardwood Floors As Seen
    • Master Bath
    • Out Building
    • Patio
    • Porch
    • Powder Room
    • Privacy
    • Security System
    • Sky Light
    • View
    • Walk In Closet
    • Walk Out Basement
    • Wall To Wall Carpet
  • Baths Half1
  • Baths Full4
  • Included
    • Attic Fan
    • Ceiling Fan
    • Chandelier(s)
    • Dishwasher
    • Dryer
    • Garage Door Opener
    • Garage Remote
    • Oven/Range
    • Refrigerator
    • Washer
    • Water Conditioner Owned

Your Local Office

Houlihan Lawrence

Houlihan Lawrence

237 Mamaroneck Avenue,
White Plains, NY 10605

Germantown, NY Demographics

There is no data available

Germantown, NY Real Estate Market Data

There is no data available

Germantown, NY Schools

School NameDistanceTypeGrades

Copyright 2018 Hudson Gateway Multiple Listing Service, Inc. (“HGMLS”), All rights reserved. This information is deemed reliable but not guaranteed. The data relating to real estate for sale on this web site comes in part from the IDX Program of HGMLS. Subject to errors, omissions, prior sale, change or withdrawal without notice. This web site is updated daily.


Do not fill in this field:

Do not fill in this field:

Do not fill in this field:

Do not fill in this field:

Do not fill in this field:

Do not fill in this field:


Do not fill in this field: