Skip main navigation
Closed
  • $1,325,000

    123 Waltermire Road, Ghent, NY 12075

    3beds
    2,258sqft
    Single Family Residence
    Built in 1850
    19.8 Acres Lot
    $1,365,400 Zestimate®
    $587/sqft
    $4,231 Estimated rent

    Home value

    $1,365,400

    $1.07M - $1.76M

    $4,231/mo

    Zestimate® history
    Loading...

    Owner options

    List your home for rent

    $4,231/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

    $4,231/mo

    Rent Zestimate®

    Refinance and save

    $8,963/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

    $8,963/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

    In a mix of classic upstate and artist-designed modern architecture, this 20-acre Columbia County parcel offers the best of both worlds. Located on a quiet road just a short distance from Hudson, Art Omi, and Bartlett House, this house feels both private and conveniently accessible. Two separate barns to use as office, studio space, or storage. Large glass windows make up half of the house. The land surrounding the house features open fields, active meadows, a pond, and wooded areas perfect for exploration. This home is three stories with the ability to have two bedrooms on the entry level. The main bedroom has a working fireplace, a spacious closet, and an adjacent bathroom. The third floor has a bedroom, studio space, and its own bathroom. The main magic happens in the glass kitchen and dining space, with Western light coming in during golden hour. The third bedroom is best suited as a guest bedroom, office space, or spare room. The kitchen leads out to the back gravel deck for easy outdoor meals and hosting. Original wide board flooring in the top two floors of the original house. Second fireplace and built-in pizza oven in the downstairs living room. In a mix of classic upstate and artist-designed modern architecture, this 20-acre Columbia County parcel offers the best of both worlds. Located on a quiet road just a short distance from Hudson, Art Omi, and Bartlett House, this house feels both private and conveniently accessible. Two separate barns to use as office, studio space, or storage. Large glass windows make up half of the house. The land surrounding the house features open fields, active meadows, a pond, and wooded areas perfect for exploration. This home is three stories with the ability to have two bedrooms on the entry level. The main bedroom has a working fireplace, a spacious closet, and an adjacent bathroom. The third floor has a bedroom, studio space, and its own bathroom. The main magic happens in the glass kitchen and dining space, with Western light coming in during golden hour. The third bedroom is best suited as a child's room, guest bedroom, office space, or spare room. The kitchen leads out to the back gravel deck for easy outdoor meals and hosting. Original wide board flooring in the top two floors of the original house. Second fireplace and built-in pizza oven in the downstairs living room.

    Zillow last checked: 8 hours ago

    Listing updated: November 17, 2025 at 04:54am

    Listed by:

    Anastasja Robinson 415-539-5064,

    Nicole Vidor Real Estate Inc.

    Bought with:

    Eva Reece, 10401379708

    Houlihan Lawrence Inc.

    Source: HVCRMLS,MLS#: 20254467MLS Logo

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 3
    • Bathrooms: 3
    • Full bathrooms: 3
    Heating
    • Fireplace(s), Oil, Pellet Stove
    Cooling
    • Wall/Window Unit(s)
    Appliances
    • Included: Wine Cooler, Washer/Dryer Stacked, Washer, Stainless Steel Appliance(s), Refrigerator, Freezer, Double Oven, Dishwasher, Convection Oven, Built-In Range
    • Laundry: Common Area
    Features
    • High Ceilings
    • Flooring: Combination, Concrete, Hardwood
    • Has basement: No
    • Number of fireplaces: 2
    • Fireplace features: Pellet Stove, Wood Burning
    Interior area
    • Total structure area: 2,258
    • Total interior livable area: 2,258 sqft
    • Finished area above ground: 2,258
    • Finished area below ground: 0

    Property

    Features
    • Levels: Tri-Level
    • Stories: 3
    • Has view: Yes
    • View description: Hills, Pond, Trees/Woods
    • Has water view: Yes
    • Water view: Pond
    Lot
    • Size: 19.80 Acres
    • Features: Pond on Lot, Gentle Sloping, Meadow, Wooded
    Details
    • Additional structures: Barn(s), Workshop
    • Parcel number: 84.15.110
    • Zoning: RA1 C -

    Construction

    Type & style
    • Home type: SingleFamily
    • Architectural style: Modern
    • Property subtype: Single Family Residence
    Materials
    • Concrete, Glass, Stone, Wood Siding
    • Foundation: Combination
    • Roof: Asphalt
    Condition
    • New construction: No
    • Year built: 1850

    Utilities & green energy

    • Electric: 200+ Amp Service
    • Sewer: Septic Tank
    • Water: Well
    • Utilities for property: Propane

    Community & neighborhood

    Location
    • Region: Ghent

    Other

    Other facts
    • Listing terms: Contract
    • Road surface type: Asphalt

    Price history

    DateEventPrice
    11/14/2025Sold$1,325,000+1.9%$587/sqft
    Source: HVCRMLS #20254467 Report a problem
    10/15/2025Pending sale$1,300,000$576/sqft
    Source: HVCRMLS #20254467 Report a problem
    9/30/2025Contingent$1,300,000$576/sqft
    Source: HVCRMLS #20254467 Report a problem
    9/18/2025Listed for sale$1,300,000+356.1%$576/sqft
    Source: HVCRMLS #20254467 Report a problem
    7/21/2024Listing removed--
    Source: Zillow Rentals Report a problem

    Public tax history

    YearProperty taxesTax assessment
    2024-- $459,900
    2023-- $459,900
    2022-- $459,900 +28.8%

    Find assessor info on the county website

    Neighborhood: 12075

    Nearby schools

    GreatSchools rating