The algorithm says $450,000. The market just paid $633,500. What the gap actually means.

Two numbers, August 2026

Realtors Property Resource — the National Association of REALTORS® data platform — publishes an automated valuation for every home it tracks and rolls those up into a median estimated value for each area. For Columbia County in August 2026, that figure was $449,990. In the same month, the median price of the homes that actually sold in Columbia County was $633,500.

For Copake's ZIP code, 12516, the estimated value was $407,810 and the median sold price was $460,000. The direction is the same; the gap is smaller.

The reflex is to read this as the algorithm being wrong by a third. It is not that simple, and the honest reading is more useful to a seller than the dramatic one.

Why the two numbers disagree

The estimated value is a median across every house in the county — the ones nobody is selling included. The sold price is a median across only the houses that changed hands that month, and the houses that sell in a given month are not a random sample of the housing stock. In a market like this one they skew larger, better presented, on more land, and more often bought by people arriving from the city with a specific picture in mind. August's sold median also jumped 14 percent in a single month, which tells you how few transactions it rests on.

So the gap is partly the algorithm's limits — it has never seen the kitchen, the light, or the road — and partly a difference in what is being measured. Both matter. Neither is a price.

What the rest of the data said

The numbers around the two medians tell the seller more than the medians do. Columbia County sat at 6.2 months of inventory in August — RPR's needle just to the buyer's side of balanced — with homes selling at 96 percent of their list price after a median 49 days. Copake was further into buyer's-market territory: 7.3 months of inventory, 81 days, 97 percent of list.

Dutchess County, one county south, was a different market entirely: a seller's market at 101.9 percent of list and 37 days, with a median sold price of $540,000. Greene County across the river ran the other way — a buyer's market at 96.8 percent of list, 45 days, and a median sold price of $354,950.

Across the whole Hudson Valley Catskill Region MLS — 2,926 residential sales in the twelve months to August — the sale-to-original-list ratio bottomed at 92.4 percent in February and climbed back to 98.1 percent in July. Columbia County's own twelve-month figure was 93.2 percent of original list, on 563 sales averaging 92 days on market. Set that beside RPR's 96 percent of final list and the three-point gap is the price cuts: houses that came on too high, sat, and were reduced before they sold. In Copake specifically, that ratio swung between 88 and 102 percent month to month over the past year — the signature of a small market where a single sale moves the number.

• Columbia County: balanced-to-buyer's, 6.2 months of inventory, 96% of list, 49 days, $633,500 median sold
• Copake 12516: buyer's market, 7.3 months, 97.1% of list, 81 days, $460,000 median sold
• Dutchess County: seller's market, 101.9% of list, 37 days, $540,000 median sold
• Greene County: buyer's market, 96.8% of list, 45 days, $354,950 median sold

What a seller should do with this

Treat the automated estimate as the floor of the conversation, not the answer. Then ask what the houses that actually sold near you had in common — condition, land, presentation, the specific road — and where yours sits against them. In a market at 96 percent of list with seven weeks on market, the difference between a house that is positioned and one that is merely listed is the difference between those two medians.

That is what a valuation is for: a number for your house, built from the sales the algorithm averaged away.

The full twelve-month tables behind this piece, for Columbia County, Copake and the whole MLS, are in the August Upstate Market Brief at francisnolan.com/market-brief?for=seller.