How to track comparable sales throughout the year for appeal prep

Last updated 2026-07-11

Why do comparable sales matter so much for a property tax appeal?

Comparable sales are the strongest evidence you can bring to a property tax appeal. Your assessment is the assessor's opinion of your home's market value on a specific date. Show that similar homes sold for less around that date, and you've made the whole case. A clean table of closed sales beats a written complaint every time.

Assessors run thousands of parcels through automated valuation models. Those models are accurate on average. They're often wrong for one specific house, especially a house with a sloped lot, a bad floor plan, or deferred maintenance the algorithm can't see.

That's where your comps come in. A targeted set of closed sales near your property, each priced below your assessment, is hard for a board to wave away. Boards of equalization read written arguments all day. What moves them is three to six real sales, addresses attached, prices below your number ^[1].

The catch is timing. Most counties set appeal deadlines 30 to 90 days after they mail assessments, and most homeowners don't start gathering comps until the final week. At that point you're stuck with whatever sold recently, which may be the wrong window for your argument. Track sales all year and you get to choose the ones that support your case, with enough left over to survive a challenge or two.

What is the assessor's valuation date and why does it control which comps you can use?

The valuation date, also called the lien date or assessment date, is the single calendar day from which your home's market value is measured. Every state fixes it by statute. California uses January 1 ^[2]. Texas uses January 1 too ^[3]. Illinois uses January 1 of the prior year for most counties ^[4]. New York City uses the prior January 5 for Class 1 homes ^[5].

That date decides which sales count. Most hearing boards want comps that closed within six to twelve months of the valuation date, ideally bracketing it: some before, some after. A sale fourteen months out carries less weight. A sale two months after can still work, but you'll have to explain any market movement between the two dates.

Here's what that means in practice. If your lien date is January 1 and your appeal deadline is May 31, your best sales window runs from roughly July 1 of the prior year through June 30 of the current year. You want to be logging sales across that whole stretch, not running a Zillow search in late May.

Counties on a triennial or quadrennial reassessment cycle, like Cook County in Illinois ^[6], stretch the window of relevant sales across two years. That's more reason to keep the tracker running, not less. For Cook County specifics, see our guide to the cook county tax assessor tax bill.

Where can you find comparable sales data for free?

You have more free sources than you think. The trick is knowing which ones a board trusts. Rank them by reliability and start at the top.

Tier 1: Official transfer records County recorder or register of deeds databases are the gold standard. They hold actual deed-transfer data, recorded prices (in states that require price disclosure), and legal descriptions. Most search online by address or parcel number. In non-disclosure states the price isn't public, but the transfer itself is.

Tier 2: Assessor's sales databases Many assessors publish a sales ratio study or an arm's-length sales file listing the qualified sales they used to calibrate their model. These are the exact sales that set your value, so they're the most relevant comps you can get. California's Board of Equalization publishes assessment ratio studies statewide ^[2]. Texas requires each appraisal district to keep a sales file property owners can request ^[3].

Tier 3: Real estate portals Zillow, Redfin, and Realtor.com all show sold prices. Redfin is the most useful because its Sold tab filters by date range, property type, square footage, and distance at once. The prices come from MLS data and are usually right for standard residential sales, though off-market and distressed deals sometimes carry errors. Verify a portal price against the deed record before you put it in a formal appeal.

Tier 4: State transfer databases Several states aggregate closing data at the state level. Iowa's Real Estate Transfer Declaration database and Washington's Real Estate Excise Tax affidavit records are two examples. These sometimes surface sales the big portals miss.

For large urban counties, the assessor's own parcel search usually has a recent-sales tab. The la county property tax portal and the montgomery county property tax database both let you pull neighbor sales directly. The gwinnett county tax assessor site in Georgia exports sales data too.

How do you choose which sales are truly comparable to your home?

Comparable doesn't mean identical. It means similar enough that, after you adjust for differences, the sale price tells you something reliable about your home's value. Assessors and appraisers weigh six things.

Criteria	Typical tolerance
Distance from subject	Within 0.5 mile preferred, 1 mile acceptable in rural areas
Sale date	Within 6-12 months of valuation date
Gross living area (GLA)	Within 10-15% of subject's square footage
Lot size	Within 20% for standard residential
Bedroom and bathroom count	Within 1 of each
Condition / age	Similar condition, within 10-15 years of build year

You don't need a perfect match on every row. A sale 0.7 miles away that's otherwise nearly identical beats a sale 0.2 miles away that's 40% bigger and just remodeled. The closer you are on the whole profile, the easier it is to defend.

Always drop non-arm's-length sales: foreclosure auctions, family transfers, short sales, deals between related businesses. Those prices don't reflect the open market, and the assessor's rep will pounce the second you show one. Most assessors' sales files tag these with a qualified or disqualified code, so use that flag.

Lot size is the wild card. In dense urban subdivisions where every lot is a quarter acre, it barely moves price. In suburban markets with one-to-three-acre lots, a 50% lot-size gap can swing price 10% or more. Learn how your local market treats lot size before you decide how hard to weight it.

What does a year-round comp tracking spreadsheet look like?

You don't need software. A Google Sheet or an Excel file with two tabs does the job: one for raw sales data, one for your summary comparison. That's the whole system.

Raw sales tab, one row per sale:

• Address
• Sale date
• Sale price
• Price per square foot (calculated)
• Gross living area (sq ft)
• Lot size (sq ft or acres)
• Beds / Baths
• Year built
• Distance from your property (in miles; Google Maps gives this in about ten seconds)
• Sale type (arm's-length, foreclosure, family, etc.)
• Source (county recorder URL, Redfin link, MLS number if available)
• Notes (condition issues, additions, pool, garage, and so on)

Summary comparison tab: Pull your three to six best comps into a side-by-side table with your home in the first column. Calculate your home's value using price-per-square-foot logic. Say four comps average $195 per square foot and your home is 1,800 square feet. Indicated value is $351,000. If your assessment says $415,000, you have a documented $64,000 gap to argue.

Update the raw tab every two to four weeks. Set a calendar reminder. It takes about fifteen minutes a session once the setup is built. By the time your appeal window opens, you'll have twenty to forty logged sales and can pick the six that bracket your value best.

The TaxFightBack appeal kit includes a pre-built version of this spreadsheet with the formulas already loaded, which saves about an hour of setup if you want a head start.

How often should you pull new sales and what's the minimum data you need?

Pull new sales once a month while your valuation date is six months or more out. Pull weekly in the two months before your appeal deadline. Most county recorder databases post transfers within two to four weeks of closing, so a weekly check catches new sales fast.

The floor for a credible appeal is three comparable sales ^[1]. Three is what most boards accept. Six is comfortable because it gives you slack: lose two to the assessor's objections and your argument still holds. You want enough that losing a couple doesn't sink you.

Thin neighborhood? You have two moves. First, widen your search radius one step at a time, and note why the wider area is comparable (same school district, same zoning, similar construction age). Second, reach for a slightly older sale and apply a time adjustment using published local price-index data. The FHFA House Price Index ^[7] is free and broken out by metro area, and it gives you a defensible percentage to argue that values moved X% between the older sale and your valuation date.

Rural properties in low-volume counties are the hard case. You may have to go out 12 to 24 months and two to five miles. Write down every expansion decision in your notes column so you can explain your selection out loud at the hearing.

Which counties and states have the best free online sales databases?

Access is all over the map. Some states hand you a searchable, exportable database. Others make you file a records request and wait. Here's the honest lay of the land.

Strong public access: Texas appraisal district sites (like the Bexar County system; see our bexar county tax assessor guide) usually let you search comps right inside the district's CAMA system, filtering by neighborhood code, square footage, and sale date. Florida's property appraiser sites are just as detailed and often export CSV files. California varies by county. Los Angeles publishes property data through its assessor portal, which we cover in the los angeles county property tax guide.

Restricted access: Non-disclosure states don't require sale prices on public deeds. That list includes Texas (odd, given the CAMA access above), Indiana, Idaho, Kansas, Louisiana, Mississippi, Missouri, Montana, New Mexico, North Dakota, Utah, and Wyoming ^[8]. You can still find sales through the assessor's own qualified-sales files, through Redfin and Zillow (which pull MLS data agents enter), and through state assessment ratio studies.

Minnesota's Hennepin County runs one of the cleanest comp databases anywhere. The assessor's parcel viewer searches sales by property type, date, and geographic area in a few clicks. Our hennepin county property tax guide walks through it.

If your county's online tools are thin, call the assessor's office and ask for a recent arm's-length sales file or a comparable sales printout for your neighborhood. Many offices email a spreadsheet on request. It's public record, and you're entitled to it.

How do you make adjustments when your comps aren't a perfect match?

No comp matches your home exactly, so you adjust. Formal appraisers run paired-sales analysis to price each difference. For a residential appeal you can lean on price-per-square-foot logic plus a few plain-English notes, and boards accept it.

The basic method: calculate each comp's price per square foot, apply that ratio to your home's square footage, and average across your comps. If the average indicated value lands well below your assessment, that's your argument in one number.

For bigger differences, name them. If a comp has a pool and yours doesn't, say so. Boards understand a qualitative adjustment even without an exact dollar figure. A note that reads "comp at 215 Oak St has an inground pool (estimated $25,000 to $40,000 based on appraiser data); adjusted indicated value for subject is $X" shows you did the thinking.

Where you should not freelance: sale date. Don't adjust for time unless you can back it with published index data (FHFA HPI ^[7] or a local market report from a named brokerage). Boards get suspicious when a homeowner's self-calculated time adjustment happens to make their comp look better. Use the FHFA's free quarterly release and cite it by name.

The safest adjustment is gross living area. Price per square foot is intuitive, widely accepted, and easy to document. Lead with it and build out from there.

What are non-disclosure states and how do you work around them?

In roughly a dozen non-disclosure states ^[8], the recorded deed doesn't show the sale price, so you can't confirm a number from the deed alone. Harder, not impossible. Three workarounds do the job.

First, get the assessor's own sales file. Most assessors keep an internal list of qualified arm's-length sales used for mass appraisal, and state public-records laws usually require them to share it. Ask for it by name. Indiana's Gateway portal, for one, publishes county-level sales ratio data even though Indiana is non-disclosure.

Second, use MLS-reported prices from Redfin or Zillow. Agents enter closing data into the MLS, so these prices aren't always exact, but they're usually close and get accepted in many hearing rooms. Note the source in your spreadsheet so nobody has to ask.

Third, use your state's assessment ratio study. States publish these yearly, and they carry enough aggregate sales data to argue that your neighborhood's assessments run systematically high. The IAAO (International Association of Assessing Officers) sets the standards for ratio studies ^[9], and most states follow them, which means the methodology is auditable.

Missouri is a non-disclosure state, and St. Louis County owners hit this wall all the time. Our st louis county personal property tax guide covers how local practitioners get around it.

How do you organize your comps into a presentation the hearing board will accept?

Format wins hearings. A board sees dozens of appeals in one morning, so your job is to make their job easy: clear table, clear math, clear ask. Do that and you're already ahead of most of the room.

The standard format is a one-page comp grid. Columns: property address, sale date, sale price, square footage, price per square foot, beds/baths, year built, distance. Put your home in the first row with your assessed value in the sale-price column so the gap is visual. Bottom row: averages for each numeric column, then a calculated indicated market value for your home.

Behind the grid, attach the backup: printouts of each comp from the county recorder or assessor's portal, Redfin or Zillow sold-listing pages, and a simple map (a Google Maps screenshot is fine) showing each comp's distance from your home.

Label everything. Every page gets your parcel number and the tax year you're appealing. Board members shuffle paper all day, and unlabeled pages get lost.

Bring three copies: one for the board, one for the assessor's rep at the table, one for yourself. If the hearing is virtual, have a PDF ready to screen-share or email on the spot.

Rehearse the pitch to ninety seconds: "My assessment is $X. These five sales show similar homes sold for an average of $Y in the twelve months around the valuation date, suggesting a market value of $Z. I'm asking for a reduction to $Z." That's the whole case. Everything else is backup.

What mistakes do first-time appellants make with comparable sales?

The number one mistake is using a Zestimate as a comp. A Zestimate is an estimate of current market value, not evidence of what a comparable home actually sold for. Boards toss them on sight. Bring real closed sales.

Second most common: not checking that sales were arm's-length. Slip a foreclosure or a family transfer into your grid without flagging it and the assessor's rep will catch it, then question everything else you brought.

Third: pulling cheaper comps from a different neighborhood. If your home sits in a sought-after school district and your comps are across the boundary in another zone, the assessor has a one-sentence rebuttal. Neighborhood lines matter.

Fourth: skipping adjustments for obvious differences. Show a 1,400 sq ft comp against your 2,100 sq ft home with no mention of the gap and it looks like you either missed it or hoped the board would. Name the difference and explain why the comp still supports your value.

Fifth: waiting until the last week. Start tracking in the final seven days and you're stuck with whatever happened to sell. Year-round tracking is what lets you pick the best evidence instead of settling for the only evidence.

How do appeal deadlines affect when you need to start tracking?

Start the day your assessment notice lands, and if your state offers a pre-assessment informal review, start before that. The tighter your window, the earlier you have to be ready.

Most states mail assessments between January and April, with appeal deadlines 30 to 90 days out ^[10]. Some states run informal review periods before the formal deadline, and those are often faster and cheaper. Texas appraisal districts hold informal conferences before the Appraisal Review Board hearing; walking your comp sheet into that meeting can settle the whole thing without a formal hearing ^[3].

Here's a rough deadline table by cycle type:

State cycle	Assessment mailed	Informal review	Formal deadline
Annual (e.g., TX, CA)	Jan-Apr	Varies	30-90 days after notice
Biennial (e.g., OH)	Every 2 years	Available in some counties	30-90 days after notice
Triennial (e.g., IL/Cook)	Every 3 years	Yes, in many townships	30 days after notice published [4]

Deadlines vary at the county level inside every state. Verify your exact date against your county assessor's website or the notice itself, not a state average.

California's Santa Clara County, for example, has Proposition 8 decline-in-value review windows that run on a different clock than the standard appeal timeline. Our santa clara property tax guide has those specifics.

The core rule holds: if your window is 30 days, you need comps lined up before the notice arrives, not after. Year-round tracking is the only way to guarantee it.

Frequently asked questions

Can I use Zillow sold prices as evidence in a property tax appeal?

Yes, with caveats. Zillow sold prices come from MLS data entered by agents and are usually accurate for standard residential sales. Many hearing boards accept them as supporting evidence. Verify the price against the county recorder's deed record when you can, note the source clearly in your documentation, and exclude any sales Zillow flags as off-market or distressed. A Redfin sold-listing printout with date, price, and property details is often cleaner to present.

How many comparable sales do I need for a property tax appeal?

Three is the accepted minimum for most boards of equalization. Six gives you enough redundancy that losing one or two to the assessor's objections doesn't gut your case. If your neighborhood is thinly traded and you find only two arm's-length sales, document why and expand your radius with a written note on why the wider area is reasonable. Quality beats quantity: two excellent comps outrank five weak ones.

What is an arm's-length sale and why does it matter for comp research?

An arm's-length sale is a transaction between unrelated parties, with no duress, where both buyer and seller act in their own interest. Foreclosure auctions, family transfers, short sales, below-market estate sales, and deals between business partners generally don't qualify. Using non-arm's-length sales as comps is the most common mistake appellants make. Most assessors' sales files mark each sale qualified or disqualified for exactly this reason.

How do I find comparable sales in a non-disclosure state where deed prices aren't public?

Request the assessor's arm's-length sales file directly; most state public-records laws require the office to provide it. Use Redfin or Zillow, which pull MLS closing prices agents voluntarily enter. Check your state's assessment ratio study, published annually. These workarounds aren't perfect, but they give you enough documented comparable sales to build a credible appeal even when recorded deeds hide the price.

How far back can comparable sales be for a property tax appeal?

Most boards prefer sales within six to twelve months of the valuation date, bracketing it on both sides. Sales older than twelve months are still usable but need a time-adjustment explanation backed by a published price index like the FHFA House Price Index, which is free and broken out by metro area. Document the method and cite the index by name. A board can reject an unexplained time adjustment, but a cited, methodical one usually holds.

What's the difference between the valuation date and the appeal deadline?

The valuation date (or lien date) is the specific calendar day from which market value is measured, often January 1. The appeal deadline is the last day to file your challenge, usually 30 to 90 days after the notice is mailed. Your comps need to bracket the valuation date, not the appeal deadline. This matters because the most recent sales before your deadline may sit months ahead of the valuation date and count for less than older sales closer to January 1.

Can I appeal using sales of homes that are slightly different from mine?

Yes, and you almost have to, because no two homes are identical. The standard move is to name the differences, apply a simple price-per-square-foot adjustment for size, and note the rest (pool, garage, condition) qualitatively. Boards know comps require judgment. What kills your credibility is pretending differences don't exist. A comp 15% larger than your home, presented honestly with a noted size adjustment, beats a comp you cherry-picked by ignoring the obvious.

What is a sales ratio study and how can I use it in an appeal?

A sales ratio study compares assessed values to actual sale prices across a county or state. Most state departments of revenue or equalization publish one annually. It can show that your county's assessments run systematically above market, which supports a blanket argument that assessments county-wide are inflated. Reference the study's stated ratio alongside your individual comps to show both a specific and a systemic problem. The IAAO sets the methodology these studies follow.

How do I track sales if my county's online database is outdated or incomplete?

Four fallbacks: call the assessor's office and ask for a recent sales printout for your neighborhood code (a public-records request, usually honored); use Redfin's sold filter, which often updates faster than county portals; check the county recorder's online deed index for recent transfers, then verify prices through MLS sources; and ask whether the assessor's office has a data-services contact who can export a sales file in CSV. Many larger counties do.

Should I hire an appraiser or can I build my own comp table for a residential appeal?

For most residential appeals, a well-documented self-prepared comp table works. Boards see homeowner-prepared evidence daily and judge it on the merits. A licensed appraisal is stronger, especially above $1 million or for complex properties, but it costs $400 to $800 and may not pay off against a $3,000 over-assessment. The math: if a correction saves $500 a year in taxes, a $600 appraisal breaks even in year two. DIY comps break even immediately.

How do I calculate price per square foot from comparable sales?

Divide the sale price by the gross living area in square feet. A home that sold for $320,000 with 1,600 square feet has a price per square foot of $200. Apply that to your home's square footage for an indicated market value. Average across three to six comps for a steadier figure. Use the same square footage source for every property, either the assessor's records or MLS data, so the comparison stays consistent.

What is the FHFA House Price Index and how do I use it to adjust old comps?

The Federal Housing Finance Agency's House Price Index tracks home price changes by metro area and state, quarterly. It's free at fhfa.gov. If your best comp sold fourteen months before your valuation date, look up the HPI for your metro and calculate the percentage change between the sale quarter and the valuation-date quarter. Apply that percentage to the comp's price. Document the specific HPI series and release date. That turns a stale comp into a defensible adjusted one.

Do property tax appeal boards give more weight to recent sales or nearby sales?

It depends on the board and the market, but most weight recency and proximity roughly equally. A sale nine months ago one block away usually beats a sale last month a mile away in a different subdivision. The ideal comp is both recent and nearby. When you can't get both, document your reasoning: one sentence on why you prioritized proximity over recency, or the reverse. That transparency makes your selection look principled, not arbitrary.

Can I start tracking comparable sales before I receive my assessment notice?

Absolutely, and it's the smartest move you can make. Your state's valuation date is fixed by statute and public knowledge. Start logging relevant sales six to twelve months before your notice is due. By the time it arrives, you may already have a complete comp set. If the assessed value looks wrong, you file immediately instead of burning your whole appeal window on research.

Sources

1. International Association of Assessing Officers (IAAO), Standard on Mass Appraisal of Real Property: Boards of equalization regularly consider comparable sales evidence; three comparable sales is the generally accepted minimum for residential appeals
2. California State Board of Equalization, Assessment Appeals Manual: California's assessment lien date is January 1; the BOE publishes annual assessment ratio studies by county
3. Texas Property Tax Code, Section 41.41 and Section 25.19, Texas Comptroller of Public Accounts: Texas assessment date is January 1; appraisal districts must maintain sales files and property owners may request them; informal conferences available before ARB hearings
4. Illinois Property Tax Appeal Board, Rules and Procedures: Illinois uses January 1 of the prior year as the assessment date; Cook County operates on a triennial reassessment cycle; appeal deadline is 30 days after the assessment publication notice
5. New York City Department of Finance, Property Tax Assessment Overview: New York City uses January 5 of the prior calendar year as the valuation date for Class 1 residential properties
6. Cook County Assessor's Office, Reassessment Cycle Information: Cook County Illinois follows a triennial reassessment schedule, meaning properties in each of the three districts are reassessed once every three years
7. Federal Housing Finance Agency, House Price Index (HPI): FHFA publishes free quarterly House Price Index data broken down by metropolitan statistical area, usable to calculate time adjustments for comparable sales
8. National Association of Realtors, Non-Disclosure States Reference: Approximately 12 states do not require sale prices to be disclosed on public deed records, including Indiana, Idaho, Kansas, Louisiana, Mississippi, Missouri, Montana, New Mexico, North Dakota, Utah, Wyoming, and Texas
9. International Association of Assessing Officers (IAAO), Standard on Ratio Studies: The IAAO publishes methodology standards for assessment ratio studies; most states use these standards in their annual ratio study publications
10. Lincoln Institute of Land Policy, Significant Features of the Property Tax: Appeal Deadlines by State: Most states set formal appeal deadlines 30 to 90 days after assessment notices are mailed, with variation at the county level
11. Uniform Standards of Professional Appraisal Practice (USPAP), The Appraisal Foundation: USPAP standards define arm's-length sales as transactions between unrelated parties acting in their own interest without duress, the standard used to qualify comparable sales
12. U.S. Census Bureau, American Community Survey, Housing Units and Values: Background data on residential property stock and value distributions by county used to contextualize assessment levels