Blog/Selecting Comps Like an Appraiser: Distance, Time,...
methodologycomparable salesappraisal

Selecting Comps Like an Appraiser: Distance, Time, and Use-Class Weighting

Selecting Comps Like an Appraiser: Distance, Time, and Use-Class Weighting

The difference between an automated valuation and an appraiser's opinion of value is not primarily computational — it is methodological. Automated valuations pick the closest five or ten transactions by date and return a number. An appraiser builds a comp set through a series of judgment calls: Is this transaction in the same use class? Does it sit in the same submarket boundary, or does it happen to be geographically proximate while occupying a functionally different location tier? Is the sale date recent enough to reflect current market conditions, or has enough time passed that a market-condition adjustment is required? Is the days-on-market figure indicating a motivated seller, which would make it a distressed comp rather than an arm's length transaction?

These are not decorative considerations. They are the analytical steps that separate a defensible value opinion from a number that happens to be calculated. For CRE investors, developers, and their lenders, understanding these steps — and building them into your own comp analysis process — produces materially better underwriting outcomes than relying on raw transaction proximity alone.

The Distance Dimension: Why Proximity Alone Is Insufficient

Geographic proximity is a necessary but insufficient condition for comp comparability. Two properties can be 0.4 miles apart and operate in entirely different market tiers. A neighborhood-service retail strip center on a high-traffic arterial and a flex-industrial building two blocks off that arterial are not comparable properties for valuation purposes, regardless of their physical proximity. Their buyer pools are different, their cap rate ranges are different, and their NOI dynamics respond to different market forces.

The more useful spatial filter is submarket boundary coherence. Submarkets in institutional CRE analysis are defined by shared supply-and-demand conditions — the same tenant universe competing for space in the same locations, the same investor buyer pool bidding on comparable deals, the same directional market trends (absorption, vacancy, rental growth) operating on all properties within the boundary. In well-documented markets like Charlotte, these submarket boundaries are relatively stable and can be cross-referenced against county assessor data, deed transfer records, and institutional survey data.

Where submarket boundaries are less clear — in outer suburban or rural-adjacent corridors — the more conservative approach is to widen the geographic search and tighten the use-class and vintage filters, rather than using geographically proximate comps that may cross a meaningful market boundary. A comp that is 1.2 miles away but on the same side of a major highway interchange, in the same product class, is a better input than a comp that is 0.3 miles away but separated by a rail line and a significant grade differential that creates a functional access constraint.

The Time Dimension: Market-Condition Adjustments Are Not Optional

CRE values are not static, and a transaction that occurred 24 months ago in a different rate environment is not a reliable comparable without a market-condition adjustment. The appraisal profession addresses this through the sales-comparison adjustment grid, where time adjustments are applied in percentage terms per month or per quarter based on observed trend data for the submarket and asset class.

For practical CRE underwriting purposes, the key discipline is to understand how the market environment shifted between your comp's sale date and your current valuation date, and to apply that adjustment explicitly rather than assuming nominal prices from different market environments are directly comparable.

Consider a realistic underwriting scenario: an acquisitions analyst is evaluating a 45,000 SF Class B office building in a Charlotte suburban corridor in late 2024. The closest recent comparable by date is a 38,000 SF Class B office sale from Q2 2022 at $142 per SF. Applying that comp without adjustment ignores the structural shift in the financing environment between Q2 2022 (near-zero base rates) and late 2024 (meaningfully higher rates). The implied buyer return expectation — and therefore the price per SF a buyer in 2024 would pay for comparable NOI — is lower in the current environment. A direct comparison without time adjustment produces an overestimate of the 2024 achievable price. The appropriate response is to either restrict the comp set to 2023–2024 transactions, apply an explicit market-condition adjustment with documented basis, or acknowledge the limitation in the underwriting narrative.

Use-Class Weighting: The Most Commonly Violated Principle

Use-class comparability is the dimension that automated valuation systems most often handle poorly. The simplest violation: using a retail strip transaction to benchmark an industrial property because both are "commercial" and both closed near the subject. More subtle violations include mixing Class A and Class B/C transactions within the same nominal use class (office, industrial, retail), and mixing single-tenant net-leased assets with multi-tenant gross-leased assets without adjusting for the implied different cap rate ranges and investor bases.

An appraiser working under USPAP (Uniform Standards of Professional Appraisal Practice) is required to document the adjustments applied to non-identical comps. The adjustment grid for the sales comparison approach typically includes line items for: sale conditions (arm's length versus distressed), financing concessions, market conditions (time), location, physical characteristics (size, age, condition), and income characteristics (occupancy, lease terms). Each adjustment is supported by market evidence — paired sales analysis where possible, or market survey data where direct paired sales are unavailable.

The practical takeaway for non-appraiser CRE analysts is that each adjustment should be documented and directionally logical. If a comp sold at a higher price-per-SF than you expect for your subject, there should be an identified reason — better location, higher occupancy, longer WALT, newer construction. If you cannot identify the reason for the price differential, the comp may not be comparable at all, or you may be missing a property characteristic that is driving the value difference.

Days-on-Market and Distressed Sale Flags

Days-on-market (DOM) is an underused screening variable in CRE comp selection. A transaction that closed after 18 months on market is a meaningfully different data point than a transaction that closed in 45 days. Extended DOM is a signal that the deal required significant price discovery — often because the asset had leasing issues, deferred maintenance, or title complications that reduced the buyer pool. Using a high-DOM transaction as a comp without adjustment or exclusion pulls your value estimate toward distressed sale conditions.

We are not saying high-DOM comps should always be excluded — in a thin market with few transactions, they may be the only available evidence. What we are saying is that a high-DOM comp warrants an explicit positive adjustment to the value it implies, reflecting that a stabilized, arm's length asset would trade at a premium to the distressed comp. That adjustment should be documented, and its absence is a significant weakness in any valuation analysis reviewed by a lender, buyer, or litigation counterparty.

Distressed sale flags include: deed-in-lieu transactions, post-foreclosure REO sales, lender-mandated disposition timelines disclosed in listing materials, and sale prices significantly below the assessor's indicated value without a clear explanation. These transactions may be useful for establishing a floor in a distressed market, but they are not arm's length market value indicators for a stabilized asset.

Building a Defensible Comp Set

A comp set that will hold up to scrutiny — from a lender's appraisal review, a buyer's counsel, or your own investment committee — typically has the following characteristics: three to five transactions minimum, all within the same use class and submarket boundary, all within the past 18–24 months (or with explicit market-condition adjustments if older), all arm's length (flagged and adjusted otherwise), and with disclosed occupancy at time of sale where obtainable.

When a comp set meeting all these criteria produces a narrow value range, you have strong market evidence. When the comp set produces a wide range despite meeting quality criteria, that range is itself a data point — it tells you the market has high variance for this asset type and location, which has implications for your hold-period risk assumptions and your pricing relative to your basis.

The discipline of building comps the way an appraiser would — with explicit criteria, documented adjustments, and transparent inclusion/exclusion logic — produces underwriting that travels. It can be explained to a lender, defended in a negotiation, and revisited after the fact to understand what the market evidence was saying at the time of the decision. That traceability is not just methodological virtue; it is a practical risk management tool for anyone making capital commitments based on value evidence.

Interested in running this analysis on your target market?