Comparable sales comparison chart: how to build one that wins your appeal

Last updated 2026-07-09

What is a comparable sales comparison chart and why does it matter for a property tax appeal?

A comparable sales comparison chart is a table that puts your home in the first column and lines up 3 to 6 recently sold comparable properties (comps) across the rest. Each row covers one trait: sale price, square footage, lot size, year built, condition, adjusted value per square foot, and finally an indicated market value for your home. A board member reads across a single row and sees exactly where your assessed value splits from the market evidence.

This format matters because most county assessors in the United States use a sales comparison approach as the main method for valuing homes ^[1]. Copy that method on your own terms, using sales the assessor missed or weighted poorly, and you're speaking the language the board already expects. A letter saying "my house seems overpriced" loses. A two-page chart showing that the six nearest sales average $187 per square foot while your assessment implies $231 per square foot wins, or at least draws a serious counteroffer.

The chart also holds up under cross-examination. Every number ties back to a public MLS record or a deed at the county recorder's office. There's no soft opinion to swat away. The assessor's own appraiser reads the same public data and runs the same math. Your chart forces a head-to-head comparison instead of a debate about neighborhood vibes.

What makes a sale 'comparable' for property tax purposes?

Four things drive whether a sale counts as a comp: proximity, recency, physical similarity, and motivation. Each has a rule of thumb you can apply before you open a spreadsheet.

Proximity means the sale should sit within one mile of your property and inside the same neighborhood or subdivision. Assessors in dense urban areas like Cook County, Illinois often tighten this to the same block or census tract ^[2]. In rural counties with few sales, you may have to stretch to three miles. If you do, note that stretch right on the chart.

Recency is the hardest constraint. Most boards want sales that closed within 12 months of the assessment date, and many state statutes name the exact valuation date your comps must bracket. In California the lien date is January 1 of each tax year, and the Los Angeles County Assessor tells filers to use sales from the six months before and after that date when possible ^[3]. If your state uses a different date, your comps cluster around that date, not the date you filed.

Physical similarity means the same property type (single-family, not a condo), square footage within roughly 20% of your home, a similar bed and bath count, and a like-for-like lot. A sale 40% bigger than your home can still work if you make a size adjustment, but the further you stretch, the more the board discounts your chart.

Motivation means arm's-length deals only. Cut foreclosures, short sales, sales between relatives, and sales to or from a government entity. The International Association of Assessing Officers (IAAO), whose standards most state statutes track, defines a qualified sale as one "between a willing buyer and a willing seller, both fully informed, neither under compulsion to buy or sell" ^[4]. If a sale looks oddly low or high, check the deed for a $1 consideration line, which flags a non-arm's-length transfer.

How do you find comparable sales data without paying for it?

You have at least four free sources, and in most counties two of them beat anything a paid service sells.

Start with your county assessor's property search portal. Type in a sold address near yours and the assessor's card shows the recorded sale date and price, square footage, year built, and assessed value. This is the exact data the assessor used to value your home, so comps pulled from the same portal are hard for the board to reject. Find your county's portal through your state's department of revenue or the IAAO county directory ^[4].

Next is your county recorder or register of deeds. Every deed transfer is public. Many counties post searchable deed data online, and you can search by date range and street to pull every arm's-length sale from the past 12 months within a few blocks. The deed shows the sale price, or you can back it out from the documentary transfer tax stamps where the rate is published.

Third, pair Zillow's "Recently Sold" filter with Redfin's public history tab. Both pull from MLS data and show days on market, price per square foot, and prior sale history. Neither counts as authoritative for a formal appraisal, but both are fine for spotting which sales to verify. Use them to find candidates, then confirm each one in the recorder's records before it goes on your chart.

Fourth is the Federal Housing Finance Agency's House Price Index ^[5]. It won't hand you individual comps, but it gives the market trend percentage for your metro. If homes in your metro dropped 6% between the assessment date and the appeal date, that trend line belongs in your cover memo.

In big metros, the assessor's portal alone is often enough. I'd spend 30 minutes there before paying anyone a dime.

How do you structure the comparable sales comparison chart? (Template columns explained)

Below is the standard template most residential appraisers use, trimmed for a DIY tax appeal. Build it in a spreadsheet or even a Word table. Print it landscape on one page so the hearing officer never has to flip back and forth.

Field	Subject (your home)	Comp 1	Comp 2	Comp 3	Comp 4	Comp 5
Address	123 Main St	456 Oak Ave	789 Elm Blvd	321 Pine Rd	654 Cedar Ln	987 Maple Dr
Sale date	N/A (assessment date)	mm/dd/yy	mm/dd/yy	mm/dd/yy	mm/dd/yy	mm/dd/yy
Sale price	Assessed value	$XXX,XXX	$XXX,XXX	$XXX,XXX	$XXX,XXX	$XXX,XXX
Living area (sq ft)	X,XXX	X,XXX	X,XXX	X,XXX	X,XXX	X,XXX
Lot size (sq ft)	X,XXX	X,XXX	X,XXX	X,XXX	X,XXX	X,XXX
Year built	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX
Beds / Baths	X / X	X / X	X / X	X / X	X / X	X / X
Condition	Average	Average	Good	Average	Average	Poor
$/sq ft (unadjusted)	$XXX	$XXX	$XXX	$XXX	$XXX	$XXX
Size adjustment	N/A	$+/-	$+/-	$+/-	$+/-	$+/-
Condition adjustment	N/A	$+/-	$+/-	$+/-	$+/-	$+/-
Adjusted sale price	N/A	$XXX,XXX	$XXX,XXX	$XXX,XXX	$XXX,XXX	$XXX,XXX
Adjusted $/sq ft	N/A	$XXX	$XXX	$XXX	$XXX	$XXX
Indicated value for subject	$XXX,XXX

The bottom "Indicated value" row is the average (or the median, if one comp is an outlier) of the adjusted sale prices. That number is your argument. If your assessed value is $320,000 and your five comps produce an indicated value of $271,000, you have a 15% over-assessment and a strong case.

A chart built this way takes about two hours once you have the raw sale data. The most common mistake is skipping the adjustment rows and just averaging unadjusted prices. Boards know the math. An unadjusted average that happens to favor you gets challenged. An adjusted average that still favors you is far harder to dismiss.

The data sources shift a bit by county, but the structure holds. Los Angeles County property tax appeals go to the Assessment Appeals Board, which posts a comp submission worksheet on its site. Cook County tax assessor tax bill filers submit through the Cook County Assessor's online portal, which has its own evidence upload fields.

How do you make dollar adjustments between comps and your home?

Adjustments are the step most DIY filers skip, which is exactly why they lose more often. The idea is plain. If a comp sold for $300,000 with a two-car garage and your home has none, you subtract the value of that garage from the comp's price to make it apples-to-apples.

The adjustment always runs toward your home. Ask one question: "If this comp were identical to my home, what would it have sold for?" Bigger comp than your home? Subtract from the comp's price. Better condition than your home? Subtract. Smaller lot than your home? Add.

Where do the dollar amounts come from? Three defensible sources:

1. Paired sales analysis. Find two sales that differ in only one feature (one has a pool, one doesn't), and the price gap is your adjustment. This is the strongest method and fully reproducible from public data.

2. The assessor's own cost schedule. Most county assessors publish contributory values for specific features (finished basement per sq ft, fireplace, deck) in their assessment manual or on their portal. Using the assessor's own numbers is clean, because they can't argue with them.

3. Published ranges from the IAAO or state appraisal boards. The IAAO's "Standard on Sales Ratio Studies" and many state assessment guides publish typical adjustment ranges ^[4]. A bathroom addition in most markets runs $10,000 to $20,000; a garage bay runs $15,000 to $25,000. These are rough proxies, but they're published and citable.

Keep your total net adjustment for any single comp under 25% of its sale price. A comp that needs a 40% adjustment is too different to trust. Boards know this and will flag it.

In hot markets like Maricopa property tax appeals or San Diego property tax hearings, the assessor's reps are trained appraisers who pick apart unsupported adjustments. One sentence in your cover memo naming each adjustment amount and its source takes two minutes and heads off the most common objection.

How many comps do you need on the chart?

Three is the floor most boards accept. Five is the sweet spot. Past seven you're doing extra work for little gain, unless the comps line up with unusual uniformity.

The lower bound is about credibility. One comp could be a fluke. Two might look cherrypicked. Three independent sales pointing the same direction are hard to write off as coincidence. The IAAO recommends a minimum of three sales in residential sales comparison work ^[4].

Five beats three for one reason: resilience. If the assessor's rep knocks out one comp as non-arm's-length or too different, you still have four. If two fall (rare, but it happens), you still have three. Go in with exactly three and one challenge leaves you thin.

If your market truly has fewer than three qualifying sales in the past 12 months within a reasonable distance, say so in the chart header. Spell out the search radius and time range you used, why you had to widen it, and the market conditions behind it (low inventory, rural area). Boards in low-turnover counties have seen this before and will weigh an expanded search if you document your reasoning.

What if your assessed value is for a different date than the sale prices you found?

This is one of the most overlooked traps in DIY appeals, and it wrecks otherwise solid charts.

Every state names an assessment date or valuation date that fixes what a property's market value is supposed to reflect. In Texas it's January 1 of the tax year ^[6]. In New York it varies by locality, most commonly July 1 of the prior year for counties outside New York City ^[7]. In Florida it's January 1 ^[8]. If all your comps sold in the months after that date, the board can argue that conditions changed and those later sales don't line up.

The fix is a time adjustment row. Use the FHFA House Price Index for your metro ^[5] to figure the percentage change in prices between each comp's sale date and the assessment date. Apply that percentage to the comp's sale price before any other adjustment. Formal appraisers call this a market conditions adjustment, and it's standard practice.

Here's the math. Assessment date is January 1, 2024. A comp sold July 1, 2024. Prices in your metro rose 3% over that stretch. Multiply the comp's sale price by 0.97 to bring it back to the January 1 date. Cite the FHFA index in your chart footnotes.

Georgia homeowners in Gwinnett County tax assessor or Cherokee County tax assessor jurisdiction should confirm the county date, though Georgia uses January 1 statewide under O.C.G.A. § 48-5-2 ^[9].

How do you present your chart at the hearing to maximize your chances?

Presentation counts. A sloppy printout with handwritten corrections tells the board you didn't take this seriously. A clean, stapled packet says the opposite.

Bring five copies at minimum: one for each board member (most residential boards seat three), one for the assessor's rep, one for you. Some counties want evidence filed in advance, sometimes 5 to 10 business days before the hearing, so check local rules. Bexar County tax assessor hearings have pre-submission deadlines that will bite you if you show up expecting to hand the board evidence on the day of.

Order the packet like this: (1) a one-paragraph cover summary stating your assessed value, your indicated value from the chart, and the dollar difference; (2) the comparison chart; (3) backup printouts for each comp (the assessor's property card and the recorded sale price). Three sections. Don't bury the board in paper.

At the hearing, walk the board through the chart in under three minutes. State the assessment date, point to your five comps, name the adjusted average, and ask for a reduction to that number or below. If you have one comp that's nearly a twin of your home and sold recently well below your assessment, lead with it, then say the others confirm it.

Don't argue neighborhood trends or where the market heads next year. Stick to the chart. Every word that isn't about the chart dilutes your case.

In counties with large assessment departments, like Lake County property tax in Illinois or Madison County tax assessor in Alabama, the assessor's rep is often a trained appraiser. Your job isn't to out-appraise them. Your job is to show that their own comparable sales data, pulled from the same public sources they use, points to a lower value.

If you want a pre-built spreadsheet with the adjustment rows and data validation already in place, the TaxFightBack DIY appeal kit includes a comparable sales comparison chart template plus county-specific filing instructions. That said, the structure above is everything you need to build one from scratch.

What are the most common mistakes on comparable sales charts that cause appeals to fail?

The number one mistake is using distressed sales: foreclosures, bank-owned properties, estate sales under probate, or homes dumped below list because the seller had to move. These aren't arm's-length transactions, and the board will toss them. Build your case around a bank REO that sold 25% below market and your indicated value is artificially low. The board will catch it.

Second is ignoring the assessment date. Comps that are 18 months old with no time adjustment look suspect. Show a comp from two years back without explaining why you reached that far, and the board assumes you were fishing for a friendly number.

Third is inconsistent condition ratings. Rate your home "Average," rate all your comps "Average" with no condition adjustment, and then let slip that your home needs a new roof, and the rep flags the gap. Be honest about condition. If your home sits below average, say so and take the adjustment in your favor.

Fourth is leaning on one data source. Comps pulled only from Zillow can carry wrong sale prices, because Zillow sometimes shows list price, not the closed number. Verify every comp in the public deed records.

Fifth is leaving your own home's data out of the first column. Boards see charts where the filer packed in comps but left the subject column mostly blank. Without your home's square footage, condition, and year built in the same table, the adjustments make no sense.

Georgia filers should read the Georgia Department of Revenue's Local Assessment Officials training materials, which describe exactly what a properly built comp grid looks like from the assessor's side ^[9]. Thirty minutes of reading prevents most of the mistakes above.

Does the same chart work for commercial property or is residential different?

The structure is similar, but commercial comp analysis runs more complex and usually needs income data next to the sales data. For small commercial properties (strip retail, a small office, a duplex or four-plex), a modified residential chart works fine if you adjust for gross leasable area instead of raw square footage and add a row for cap rate and gross rent multiplier.

For larger commercial properties, assessors lean on an income capitalization approach as the primary method, and a sales comparison chart plays backup. If you own commercial property and are building a comp chart, hunt for sale prices expressed as price per leasable square foot and as an implied cap rate, more than total sale price. A 10,000 sq ft retail strip that sold for $2 million only compares to yours if you also know the rent roll and occupancy at the time of sale.

The IAAO publishes a separate standard for commercial property assessment ^[4]. Most assessors with heavy commercial stock, like St. Louis County personal property tax or Coweta County tax assessor jurisdictions, post their own commercial valuation guidelines online. Read those before you build any commercial comp chart, because the selection criteria differ from residential.

For a standard single-family appeal, the residential template throughout this article is exactly what you need. Don't overbuild it.

How do you handle a market where there are almost no recent sales?

Low-turnover markets are genuinely harder, and no trick makes the problem vanish. Your options, in order of preference:

Widen the time window to 24 months and apply a time adjustment to each comp using the FHFA index. Document it in the chart header. Most boards in slow markets have seen this and accept it.

Widen the geographic radius. In a low-density rural area, two to three miles may be necessary. Document the reasoning again. Note what radius came up empty and why you had to go further.

Pull sales from the same assessor neighborhood code. County assessors group properties into mass appraisal neighborhoods, and those codes often show on your property card. Sales inside the same neighborhood code are defensible even past one mile.

If you can find even two qualifying sales, bring them. State in your cover memo that low inventory is a known condition of the local market (cite an FHFA or local MLS market report) and that your two comps are the total qualifying universe. Two is thin, but it beats zero, and a well-documented two-comp presentation beats an undocumented three-comp one.

Nobody has reliable national data on how low-comp markets change appeal success rates. The closest research is the Lincoln Institute of Land Policy's work on assessment uniformity, which shows rural and low-turnover markets carry higher assessment-to-sale-price variance than urban markets ^[10]. That means over-assessments are actually more common there, and boards in those places tend to give more room on comp selection.

Frequently asked questions

Can I use Zillow estimates as comps on my chart?

No. Zillow's Zestimate is an automated valuation model, not a recorded sale. Boards require actual closed sale prices backed by deed records. Use Zillow only to spot candidate addresses, then verify each sale price in your county recorder's public records before anything goes on your chart.

How far back in time can my comparable sales be?

Most boards prefer sales within 12 months of the assessment date. Some state statutes set this explicitly. If you can't find three qualifying sales within 12 months, go back 24 months with a documented market conditions adjustment on each comp. Beyond 24 months is possible but weakens the chart badly and needs strong justification.

What if the assessor has better comps than mine?

Ask for the assessor's comp list before your hearing. In most states, the assessor's evidence is discoverable once you file. If their comps are genuinely stronger, settle for a partial reduction rather than press for the full amount. A partial reduction is real money and costs nothing to negotiate.

Do I need to hire an appraiser to build a comparable sales chart?

Not for a residential appeal in most counties. A licensed appraisal costs $400 to $700 and adds credibility, but the comparable sales method is publicly documented and you can build the chart yourself from county portal data. Most DIY filers win meaningful reductions without a formal appraisal. Save the appraisal for appeals over $1,000 in potential tax savings.

How do I find the assessment date for my county?

Check your county assessor's website or your state's department of revenue property tax section. Common dates are January 1 (Texas, Georgia, Florida, California), July 1 (many New York localities), and April 1 (Maine). Your assessment notice often states the valuation date. The IAAO keeps a state-by-state summary of assessment dates.

What is the difference between a comparable sales chart and a sales ratio study?

A comparable sales chart presents 3 to 6 individual sale prices adjusted to indicate a specific value for your home. A sales ratio study is a statistical analysis comparing assessed values to sale prices across many properties to measure systemwide accuracy. Both are valid appeal evidence, but the comparable sales chart is more practical for an individual hearing.

Should I include my own home's purchase price on the chart?

Yes, if you bought within the past 12 to 24 months at arm's length. Your own purchase price is technically the best comp for your property, because it's identical to the subject. List it in the subject column as a note. If you paid less than the assessed value, that's powerful, self-contained evidence.

How do I adjust for a comp that has a pool and my home doesn't?

Subtract the contributory value of the pool from that comp's sale price. That value runs $10,000 to $30,000 depending on market and pool type, per paired-sales data in most metro areas. Best source: find two nearby sales, one with a pool and one without, otherwise similar. The price gap is your adjustment. Or use the assessor's own cost schedule for pool values.

What happens if the board ignores my chart?

Request a written decision and the specific reasons the board rejected your evidence. If the decision reads arbitrary or fails to address your chart, you generally have the right to appeal to a state tax court or administrative tribunal within a statutory window, often 30 to 90 days from the written decision. Document everything in writing.

Can I submit a comparable sales chart for a second appeal if I lost the first one?

Yes, in most states. If new sales data surfaced after your first hearing, or if you can show the board misapplied the comparable sales method, use a revised chart at the next level. State tax court proceedings typically accept the same comparable sales evidence, and some states allow new evidence that wasn't available at the first hearing.

How do I handle comps that sold significantly higher than my assessment?

Include them anyway and adjust honestly. Leaving out unfavorable comps looks like cherrypicking and burns your credibility. If all six comps point above your assessment, reconsider whether you actually have an over-assessment case. Your goal is accuracy, more than winning. A chart honest about mixed evidence beats one that's suspiciously one-sided.

Is a comparable sales comparison chart different from what a realtor's CMA shows?

Structurally similar, but a CMA (comparative market analysis) prices a home for listing, not to challenge a tax assessment. The key differences: a CMA uses list prices and pending sales, while a tax appeal chart must use closed, recorded sale prices only. A CMA also usually skips dollar adjustments by feature, which you must include for a tax appeal chart to hold up.

Sources

1. International Association of Assessing Officers (IAAO), Standard on Mass Appraisal of Real Property: Sales comparison approach is the primary method used by most assessors for residential property valuation
2. Cook County Assessor's Office, Residential Assessment Guidelines: Cook County assessor weighs comps within the same neighborhood or tract most heavily
3. Los Angeles County Assessor, Assessment Appeals Process: California lien date is January 1 and LA County instructs use of sales bracketing that date
4. International Association of Assessing Officers (IAAO), Standard on Sales Ratio Studies: IAAO defines a qualified sale and recommends a minimum of three sales in residential sales comparison; defines arm's-length transaction as between willing, informed, uncompelled parties
5. Federal Housing Finance Agency, House Price Index: FHFA HPI provides metro-level and state-level home price change percentages usable for time adjustments
6. Texas Tax Code § 23.01, Texas Comptroller of Public Accounts: Texas property assessment date is January 1 of the tax year
7. New York State Department of Taxation and Finance, Property Taxes and Assessments: New York assessment dates vary by locality; most counties outside NYC use July 1 of the prior year as valuation date
8. Florida Department of Revenue, Property Tax Oversight: Florida property tax assessment date is January 1 of each year
9. Georgia Department of Revenue, Local Government Services (Property Tax): Georgia uses a January 1 assessment date statewide under O.C.G.A. 48-5-2; publishes Local Assessment Officials training materials describing comp grids
10. Lincoln Institute of Land Policy, Property Tax Assessment Uniformity Research: Rural and low-turnover markets show higher assessment-to-sale-price variance than urban markets, indicating more frequent over-assessments
11. California State Board of Equalization, Property Taxes: California assessment appeals procedures and comp submission guidance for homeowners