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
Explore your selling options
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#: 20254467
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
| Date | Event | Price |
|---|---|---|
| 11/14/2025 | Sold | $1,325,000+1.9%$587/sqft |
Source: | ||
| 10/15/2025 | Pending sale | $1,300,000$576/sqft |
Source: | ||
| 9/30/2025 | Contingent | $1,300,000$576/sqft |
Source: | ||
| 9/18/2025 | Listed for sale | $1,300,000+356.1%$576/sqft |
Source: | ||
| 7/21/2024 | Listing removed | -- |
Source: Zillow Rentals Report a problem | ||
Public tax history
| Year | Property taxes | Tax 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
- 3/10Mary E Dardess Elementary SchoolGrades: PK-5Distance: 3.7 mi
- 4/10Chatham Middle SchoolGrades: 6-8Distance: 3.7 mi
- 7/10Chatham High SchoolGrades: 9-12Distance: 3.7 mi