Research Working Paper 01Exploratory analysisVerification ongoing
The Price of Staying: How Housing Prices and Borrowing Costs Changed Across DC Condominium and Residential-House Transactions, 2015–2025
An exploratory working paper on what recorded DC condominium and house sales cost in real terms — and what financing a median-priced purchase implied as mortgage rates rose.
- Author
- Azmera Abraham
- Publication date
- Reading time
- 11 minutes
Abstract
Using 80,985 candidate qualified sales recorded in the District of Columbia's CAMA (Computer Assisted Mass Appraisal) data from 2015 to 2025, this working paper compares how transaction prices and illustrative borrowing costs changed for condominiums and residential houses. After adjusting for inflation, the median condominium transaction price in 2024 was 15.4% lower than in 2015, while the median residential-house price was 8.6% higher (2024 dollars). Fixed-basket checks that hold the 2015 mix of unit sizes or bedroom counts constant point in the same direction. Over 2015–2025, modeled monthly principal-and-interest payments on a median-priced purchase rose from $1,664 to about $2,400 for condominiums and from $2,569 to about $5,056 for houses. These are descriptive, exploratory results: they are not repeat-sales appreciation estimates, they do not establish causes, and key data definitions are still being verified with the DC Office of Tax and Revenue.
Key findings
- 1
Real prices, 2015–2024 (CPI-adjusted, 2024 dollars): the median condominium transaction price fell 15.4%, while the median residential-house price rose 8.6%. These are changes in median transaction prices, not repeat-sales appreciation for identical homes.
- 2
Fixed-basket checks point the same way: holding the 2015 size mix constant, the 2024 real index (2015 = 100) was 82.5 for condominiums and 105.5 for houses; holding the bedroom mix constant, 81.7 and 110.5.
- 3
Illustrative payments, 2015–2025 (nominal, modeled): with 20% down and a 30-year fixed loan at annual average Freddie Mac rates, monthly principal and interest on a median-priced purchase rose from $1,664 to about $2,400 for a condominium and from $2,569 to about $5,056 for a house.
- 4
Nominal medians, 2015 vs. 2025: condominiums $443,750 and $470,000; residential houses $685,000 and $990,000.
- 5
Coverage: of 80,985 candidate qualified sales, about 96% matched a current residential (42,500) or condominium (35,268) assessment record; 3,217 did not match and are excluded from segment results.
Why this question
For many households in the District, the decision to buy — or to stay put rather than move — turns on two numbers: the price of a home and the cost of borrowing to pay for it. Both changed substantially over the past decade, but not in the same way, and not equally for condominiums and houses.
This working paper asks a deliberately narrow question: how did recorded transaction prices for DC condominiums and residential houses change between 2015 and the mid-2020s, and what would a median-priced purchase have implied for monthly borrowing costs at the start and end of the period?
It is the first working paper in The Price of Staying research series. It covers Washington, DC only; Northern Virginia and suburban Maryland remain part of the series' planned scope. The analysis is exploratory. Its purpose is to establish a careful, documented baseline — and to be explicit about what the data can and cannot support — before any stronger claims are made.
Data and workflow
The analysis starts from the District's public property-assessment data and adds three national reference series: consumer prices, mortgage rates and a repeat-sales house price index. Each step is documented so the work can be checked and repeated.
- 01Transactions. Draw sales recorded in DC's CAMA (Computer Assisted Mass Appraisal) data on Open Data DC (opens in a new tab), keeping sales marked as qualified: 80,985 candidate qualified sales dated 2015–2025.
- 02Matching. Link each sale by its SSL (square, suffix and lot) identifier to the current CAMA residential and condominium assessment tables.
- 03Segmentation. Assign matched sales to a condominium or residential-house segment; set aside sales that match neither.
- 04Inflation adjustment. Express prices in 2024 dollars using annual BLS Consumer Price Index (opens in a new tab) values, through 2024.
- 05Fixed-basket checks. Recompute the 2015–2024 comparison while holding the 2015 mix of unit sizes — and, separately, of bedroom counts — constant.
- 06Mortgage scenarios. Model monthly principal and interest on the median-priced purchase in 2015 and 2025 using annual average Freddie Mac PMMS (opens in a new tab) rates.
- 07Context. Read the results alongside the FHFA House Price Index (opens in a new tab), a repeat-sales benchmark that measures something different from median transaction prices.
Figure 1
How candidate sales matched to current assessment records
Candidate qualified DC sales dated 2015–2025, by match to the current CAMA residential and condominium tables.
Candidate qualified sales, 2015–202580,985
- Matched · residential houses
- 42,50052.5%
- Matched · condominiums
- 35,26843.5%
- Unmatched · excluded
- 3,2174%
View data table for How candidate sales matched to current assessment records
| Group | Sales | Share of total |
|---|---|---|
| Matched · residential houses | 42,500 | 52.5% |
| Matched · condominiums | 35,268 | 43.5% |
| Unmatched · excluded | 3,217 | 4% |
| Candidate qualified sales, 2015–2025 | 80,985 | 100% |
About 96% of candidate sales matched a current assessment record: 42,500 to the residential table and 35,268 to the condominium table. The remaining 3,217 sales matched neither table and are excluded from the segment results. Because matching uses today's assessment tables, a property's segment reflects its current classification, not necessarily its classification at the time of sale.
Real prices diverged by property type, 2015–2024
After adjusting for inflation, the median condominium transaction price in 2024 was 15.4% lower than in 2015, measured in 2024 dollars. The median residential-house transaction price was 8.6% higher. In constant dollars, the typical recorded condominium sale became less expensive over the period, while the typical recorded house sale became more expensive.
A change in the median can reflect a change in what sold — smaller units, a different bedroom mix, different buildings or neighborhoods — as much as a change in what comparable homes are worth. The fixed-basket checks address part of that concern by holding the 2015 mix of unit sizes, or of bedroom counts, constant and asking how prices moved within those groups. Comparison cells required at least 30 sales.
Figure 2
Real transaction prices, 2015 vs. 2024
Index, 2015 = 100, CPI-adjusted to 2024 dollars. Each line connects two observations; intermediate years are not shown.
Condominiums
Residential houses
- Median price
- Size basket
- Bedroom basket
View data table for Real transaction prices, 2015 vs. 2024
| Segment | Measure | 2015 | 2024 | Note |
|---|---|---|---|---|
| Condominiums | Median price | 100 | 84.6 | Median transaction price, −15.4% real |
| Condominiums | Size basket | 100 | 82.5 | 2015 coverage 98.8% |
| Condominiums | Bedroom basket | 100 | 81.7 | 2015 coverage 100% |
| Residential houses | Median price | 100 | 108.6 | Median transaction price, +8.6% real |
| Residential houses | Size basket | 100 | 105.5 | 2015 coverage 100% |
| Residential houses | Bedroom basket | 100 | 110.5 | 2015 coverage 100% |
Both checks point the same way as the medians. On the size basket, the 2024 real index (2015 = 100) was 82.5 for condominiums and 105.5 for houses; on the bedroom basket, 81.7 and 110.5. Coverage of 2015 sales was 98.8% for the condominium size basket and 100% for the other three.
These checks reduce the role of limited composition differences; they do not remove it. They do not control for neighborhood, building, condition or renovation, and they are not repeat-sales estimates. The results describe how recorded transaction prices changed by segment. They should not be read as appreciation — or depreciation — of identical properties.
Borrowing costs rose faster than prices, 2015–2025
The payment illustration changes both the period and the units. It runs from 2015 to 2025 and is expressed in nominal dollars, because it is meant to show what a buyer would have faced at the time rather than a constant-dollar comparison. It should not be compared directly with the 2015–2024 real figures above.
In nominal terms, the median condominium price was $470,000 in 2025, compared with $443,750 in 2015. The median residential-house price was $990,000, compared with $685,000.
Figure 3
Illustrative monthly mortgage payment, 2015 vs. 2025
Principal and interest on each segment's median-priced purchase, nominal dollars per month. Modeled examples, not actual household payments.
Condominium
Nominal median price: $443,750 (2015) · $470,000 (2025)
Residential house
Nominal median price: $685,000 (2015) · $990,000 (2025)
View data table for Illustrative monthly mortgage payment, 2015 vs. 2025
| Segment | 2015 | 2025 | Context |
|---|---|---|---|
| Condominium | $1,664 | ≈$2,400 | Nominal median price: $443,750 (2015) · $470,000 (2025) |
| Residential house | $2,569 | ≈$5,056 | Nominal median price: $685,000 (2015) · $990,000 (2025) |
Assuming a 20% down payment and a 30-year fixed-rate loan at the annual average Freddie Mac rate, the modeled monthly principal-and-interest payment on a median-priced condominium rose from $1,664 in 2015 to about $2,400 in 2025. Because the nominal condominium median rose only modestly, most of that increase within the scenario comes from the higher mortgage rate. For a median-priced house, higher prices and higher rates compound: the modeled payment rose from $2,569 to about $5,056, roughly doubling.
These are modeled examples, not the payments actual households made. They exclude property taxes, insurance, HOA or condominium fees, maintenance and closing costs — and condominium fees in particular can be a meaningful share of monthly housing cost. An individual buyer's payment depends on their down payment, credit, loan product and timing.
What is still being verified
Several definitions that matter for the results are being confirmed with the DC Office of Tax and Revenue (OTR). Until that work is complete, the findings should be treated as provisional.
- The qualified-sale code. The analysis treats the CAMA QUALIFIED value "Q" as a qualified sale. That interpretation has not yet been independently documented by OTR, so the sample is described as candidate qualified sales, not confirmed arm's-length transactions.
- Historical classification. Segments are assigned from the current CAMA assessment snapshot. The open question is whether contemporaneous 2015–2025 classifications can be reconstructed, which would catch later conversions and reclassifications.
- Unmatched sales. The 3,217 candidate sales that match no current residential or condominium record are under review.
If verification changes the sample or definitions, the results will be revised and the changes noted on this page.
What this means
For real-estate practitioners
- Treat condominiums and houses as different markets. Over this period their real transaction prices moved in opposite directions; a single District-wide figure would blur that.
- Price is only half of the affordability picture. Even where real condominium prices fell, the modeled cost of financing a median-priced purchase rose. Separating price movements from rate movements makes conversations with buyers and sellers clearer.
- Read medians carefully. Median sale prices describe what traded, not what an individual home is worth. The fixed-basket checks help, but neighborhood and condition still matter.
For data-science hiring managers
This paper is also a worked example of applied analytics on administrative data:
- Entity resolution with a reported match rate — linking 80,985 transactions to current assessment tables by parcel identifier, with unmatched records counted rather than silently dropped.
- Careful unit handling — CPI-adjusted comparisons with a stated base year, kept separate from nominal scenario modeling.
- Sensitivity analysis — testing a headline result against composition effects, with minimum cell sizes and coverage reported.
- Explicit assumptions and limits — modeled payments labeled as scenarios, causal claims avoided, and an open verification log with the data publisher.
The headline numbers are deliberately modest in what they claim. The durable value is a documented pipeline that can be audited, corrected and extended to Northern Virginia and suburban Maryland.
Methods
Sample. Sales recorded in DC CAMA data, dated 2015–2025 and marked "Q" in the QUALIFIED field: 80,985 candidate qualified sales. "Candidate" signals that the qualified-sale definition has not yet been independently documented by the DC Office of Tax and Revenue (OTR).
Matching and segmentation. Sales were linked by SSL (square, suffix and lot) identifier to the current CAMA residential and condominium assessment tables. 42,500 matched a residential record and 35,268 a condominium record — about 96% combined. 3,217 matched neither and are excluded from segment results.
Real price comparison (2015–2024). Median transaction prices for each segment were converted to 2024 dollars using annual BLS CPI. The comparison ends in 2024 because annual 2025 CPI was incomplete in the extracted research data. Results are changes in median transaction prices, not a repeat-sales index.
Fixed-basket sensitivity. The 2015–2024 comparison was repeated holding the 2015 mix of sales constant — by unit size in one version and by bedroom count in the other — to reduce the influence of shifts in what sold. Comparison cells required at least 30 sales. Results are reported as a 2024 real index (2015 = 100), with the share of 2015 sales covered.
Payment scenarios (2015–2025). Monthly principal and interest on each segment's nominal median price, assuming a 20% down payment and a 30-year fixed-rate mortgage at the annual average Freddie Mac PMMS rate for the year. Property taxes, insurance, HOA or condominium fees, maintenance and closing costs are excluded.
Context. The FHFA House Price Index provides repeat-sales context. This paper does not report FHFA index values, and its median-based results are not directly comparable with a repeat-sales index. American Community Survey data from the U.S. Census Bureau are a contextual source for the wider series; household-income comparisons are not part of this paper's results.
Data sources
- Source (opens in a new tab)
FHFA House Price Index
Federal Housing Finance Agency — Repeat-sales index tracking single-family house price changes.
Repeat-sales index used as context only; not used to compute Phase 1 results.
- Source (opens in a new tab)
Primary Mortgage Market Survey
Freddie Mac — Weekly survey of average mortgage rates.
Annual average 30-year fixed rates for 2015 and 2025; national averages, not DC-specific rates.
- Source (opens in a new tab)
Consumer Price Index
U.S. Bureau of Labor Statistics — Price change measures used for inflation adjustment.
Annual CPI used for 2015–2024 real comparisons; annual 2025 CPI was incomplete in the extracted research data.
- Portal · opendata.dc.gov (opens in a new tab)
DC CAMA sales, residential & condominium records
Open Data DC · DC Office of Tax and Revenue — Computer Assisted Mass Appraisal (CAMA) sales records plus the current residential and condominium assessment tables. Linked at the portal level; individual dataset pages are not listed.
District of Columbia · sales dated 2015–2025 · current assessment snapshot
Limitations
- Current classification applied to historical sales. Segments come from the current CAMA assessment snapshot, not contemporaneous 2015–2025 classifications. Properties converted, subdivided or reclassified since their sale may be assigned to the wrong segment or left unmatched.
- Qualified-sale definition not yet documented. The "Q" code has not been independently documented by DC OTR. Sales are candidate qualified, not proven arm's-length transactions.
- Medians are not repeat sales. Changes in median price combine price movement with changes in the mix of properties sold. They do not measure appreciation for identical homes.
- Partial composition controls. Fixed baskets adjust for unit size or bedroom count only — not neighborhood, building, condition, renovation or amenities.
- Real comparison ends in 2024. Annual 2025 CPI was incomplete in the extracted data, so 2025 appears only in nominal terms.
- Two-point comparisons. Figures compare start and end years only. Intermediate years are not shown and should not be inferred from the lines between points.
- Modeled payments. Payment figures are scenarios under stated assumptions, not actual household payments, loan terms or total housing costs.
- Unmatched sales excluded. 3,217 candidate sales (about 4%) are not in segment results; if they differ systematically, segment medians could shift.
- Descriptive, not causal. The analysis does not identify why prices or payments changed.
Report & reproducibility
The full research report and the reproducibility package are not yet hosted publicly while key definitions are verified with DC OTR. Both are available on request through Media & Contact. No private or personal data is published with this paper.
Sources & citations
- Open Data DC. Computer Assisted Mass Appraisal (CAMA) sales, residential and condominium datasets. Government of the District of Columbia; data from the DC Office of Tax and Revenue. Portal-level link — specific dataset pages are not listed. https://opendata.dc.gov/
- U.S. Bureau of Labor Statistics. Consumer Price Index (CPI). Annual values used to express prices in 2024 dollars. https://www.bls.gov/cpi/
- Freddie Mac. Primary Mortgage Market Survey (PMMS), 30-year fixed-rate mortgage; annual averages. https://www.freddiemac.com/pmms
- Federal Housing Finance Agency. House Price Index (HPI). Used as repeat-sales context; no FHFA values are reported in this paper. https://www.fhfa.gov/data/hpi
- U.S. Census Bureau. American Community Survey (ACS), via data.census.gov. Contextual source for the wider series. Portal-level link. https://data.census.gov/