Foreclosure Analysis
Most investors spray marketing at a list and hope. The ones who win dissect the data first.
A complete analytical methodology for any first-to-market niche, walked through with 12 months of real Knox County foreclosure data.
Most investors spray marketing at a list and hope. The ones who win dissect the data first.
A complete analytical methodology for any first-to-market niche, walked through with 12 months of real Knox County foreclosure data.
Everyone thinks first-to-market data is about speed. Getting the list first. It is not. Speed without analysis is just expensive guessing.
We pulled 12 months of foreclosure notices from Knox County, Tennessee. 537 raw records. After deduplication, 248 unique properties. Then we asked the question every investor should ask before spending a dollar on marketing: what does this data actually tell us?
The answer changed everything about how we marketed to that list. Where we focused. When we contacted. Who we prioritized. The analysis took two hours. The alternative was months of wasted outreach to properties that were never going to transact.
This page teaches the methodology. Foreclosure is the example, but the framework applies to any first-to-market niche: probate, tax sale, code violations, evictions. The lens is the same. The data changes.
First-to-market data has a cost per contract of $500 to $2,000. That is 2x to 8x cheaper than AI-scored data. But only if you know which records to prioritize. Analysis is the difference between $500 per contract and $5,000 per contract on the same list.
This analysis took two hours with Claude and an Excel file. Without it, you are flying blind on a list where 1 in 2 properties will transact. Two hours of analysis saves months of wasted outreach.
Five questions. Five lenses. Applied to any first-to-market niche, they tell you exactly where the deals are before you make a single call.
How many records exist? What is the unique property count after deduplication? What percentage have repeat notices? Volume tells you the size of the opportunity and the waste hiding in raw data. For foreclosures, Knox County had 537 raw records but only 248 unique properties. Without dedup, you would market to 289 duplicate owners.
For other niches: Probate: dedup on decedent name. Tax sale: dedup on parcel ID. Code violations: dedup on property address. The principle is the same: raw count is not real count.
What is the window from the trigger event to the transaction? When should you market? In Knox County, the median notice-to-auction window is 34 days. But 65.7% of sales happen after the auction date. The marketing sweet spot is Day 1 through Day 30: when the owner still has decision-making power.
For other niches: Probate: time from filing to executor appointment. Tax sale: time from delinquency notice to auction. Each niche has its own clock. Find it.
Which zip codes concentrate activity? Which have the highest transaction rates? Knox County data shows 5 zip codes with 19+ properties each (Tier 1), 6 with 10-18 (Tier 2), and 7 with fewer than 10 (Tier 3). Tier 1 zips get your marketing budget first.
For other niches: Probate: map by court jurisdiction. Tax sale: group by tax district. Concentration reveals where your dollars work hardest.
What equity distribution exists across the dataset? Which segments transact? Knox County sold properties have a median equity of 21.5%. Off-market properties sit at 77.2%. Lower equity correlates with higher motivation. But those 77% equity off-market properties? They are your deep prospecting targets: sitting on value, no agent, no plan.
For other niches: Probate: check for multiple liens or reverse mortgages. Tax sale: total delinquency amount relative to property value. Equity analysis reveals motivation level.
What actually happens to properties on this list? In Knox County, 27% sold, 49.6% went off market, 16.1% are currently active, and only 7.3% actually completed foreclosure. The "1 in 2 transact" figure comes from combining sold and active properties. Nearly half just disappear from the market: those are private sales, cured foreclosures, or properties waiting for you to call.
For other niches: Probate: what percentage of estates list vs. sell privately? Tax sale: what percentage cure vs. go to auction? Outcomes reveal the real conversion funnel.
537 raw records sounds like a big list. 248 unique properties is the real opportunity. That is a 53.8% deduplication rate. More than half the raw data is noise.
Most investors skip deduplication. They market to 537 records when there are only 248 unique properties. That is wasted budget on duplicate owners who get double the mail, double the calls, and form a worse impression of your business.
Executive Summary: dataset overview, timing intelligence, outcome breakdown, and equity insights.
Raw foreclosure notice: this is what the source data looks like before analysis.
From first public notice to auction, the median is 34 days. That is your marketing window. But the real story is what happens after the auction.
Notice-to-sale timing for the 67 properties that sold. Bars show percentage of total sales.
65.7% of sales happen AFTER the auction date. The auction is not the deadline. It is the starting line for most deals. Post-auction sales include REO dispositions, short sales, and delayed closings that take 6+ months.
Day 1 through 30 is your marketing window. That is when the owner still has decision-making power. After the auction, you are negotiating with banks or trustees. Different conversation, different timeline, different margins.
Timing Analysis: notice-to-auction breakdown, notice-to-sale distribution, and sold-relative-to-auction analysis.
18 zip codes. Three tiers. Your marketing budget goes to Tier 1 first, Tier 2 second, and Tier 3 only for high-equity cherry picks.
Highest volume. Mail and call first. 5 zip codes.
Secondary targets. Selective marketing. 6 zip codes.
Cherry-pick high-equity deals only. 7 zip codes.
| Zip | Properties | Sold | Active | Sold % | Med. Equity | Med. Value |
|---|---|---|---|---|---|---|
| 37917 | 29 | 9 | 6 | 31% | 68.9% | $233,900 |
| 37918 | 23 | 5 | 5 | 21.7% | 62.2% | $301,900 |
| 37914 | 21 | 4 | 4 | 19% | 68.6% | $287,500 |
| 37921 | 20 | 6 | 3 | 30% | 70.3% | $239,900 |
| 37922 | 19 | 4 | 4 | 21.1% | 70% | $433,400 |
| Zip | Properties | Sold | Active | Sold % | Med. Equity | Med. Value |
|---|---|---|---|---|---|---|
| 37920 | 17 | 4 | 0 | 23.5% | 83.9% | $276,700 |
| 37924 | 12 | 6 | 1 | 50% | 52.6% | $310,100 |
| 37931 | 12 | 4 | 3 | 33.3% | 61.5% | $371,600 |
| 37912 | 11 | 4 | 1 | 36.4% | 39.7% | $297,800 |
| 37934 | 10 | 2 | 3 | 20% | 76.4% | $459,400 |
| 37923 | 10 | 3 | 3 | 30% | 69.1% | $376,000 |
| Zip | Properties | Sold | Sold % | Med. Equity | Med. Value |
|---|---|---|---|---|---|
| 37849 | 9 | 1 | 11.1% | 56.9% | $375,900 |
| 37721 | 6 | 1 | 16.7% | 82.8% | $307,500 |
| 37915 | 6 | 2 | 33.3% | 31.7% | $241,800 |
| 37938 | 6 | 1 | 16.7% | 71.4% | $323,200 |
| 37919 | 5 | 3 | 60% | 23.5% | $420,200 |
| 37909 | 5 | 1 | 20% | 53.8% | $282,400 |
| 37932 | 5 | 2 | 40% | 41.8% | $533,400 |
Zip Code Analysis: foreclosure activity, transaction rates, and priority tier assignments by zip code.
Sold properties have a median equity of 21.5%. Off-market properties sit at 77.2%. Lower equity means more urgency. Higher equity means untapped opportunity.
These owners already transacted. Low equity means they had less to lose and more urgency to act. Study their sale prices and timelines to calibrate your offers on current prospects.
Your highest priority targets. 73 properties with 60%+ equity, no agent, no plan. They are sitting on significant value but have not been reached. Deep prospecting turns these into deals.
How long owners held the property before foreclosure. Each segment needs a different messaging approach.
Recent buyers. Overleveraged or life event.
Empathy-first approach. "We know this was not the plan. Let us help you get out whole."
Post-COVID buyers. Rate or value squeeze.
Focus on protecting what they have. Avoid shame triggers. These owners feel trapped, not lazy.
Mid-term owners. Divorce, medical, job loss.
Solution-oriented. "We can close fast and give you options." Speed is the value proposition.
Long-term owners. Aging, inherited debt.
Respect and trust. Slow play. Multiple touches. These owners need time and will not respond to pressure.
Legacy owners. Major equity, emotional attachment.
Highest equity but hardest to move. Community proof works. "Your neighbor on Oak Street worked with us last month." Average 12.6 years owned before foreclosure across the entire dataset.
Equity & Property Analysis: equity distribution by MLS status, ownership duration, and property value ranges.
Only 7.3% of properties actually complete foreclosure. The rest find a way out. You want to be that way out.
1 in 2 foreclosures transact when listed or sold. Combined sold (27%) and active (16.1%) already accounts for 43.1%.
Go off market. These are your deep prospecting targets. No agent, no listing. Private sales, cured loans, or waiting for your call.
Actually complete foreclosure. The other 92.7% find a way out. Most lists have more opportunity than investors realize.
Off market does not mean dead. It means the owner found a solution, or no solution found them yet. 123 properties in Knox County with no agent, no listing, and a foreclosure notice hanging over them. That is your call list.
Analysis without execution is academic. Here is how to take the insights and turn them into a marketing campaign.
Use Claude with the foreclosure analysis skill or build the Excel manually. The goal is the same: volume, timing, geography, equity, outcome. Two hours for a complete picture of your niche.
After deduplication and analysis, upload your property data to the CRM. Tag by tier (Tier 1/2/3) and priority (high equity off-market targets first). The screenshot below shows what uploaded property data looks like in the platform.
Once your data is in the CRM, apply the Niche Sequential Marketing cadence: Day 1 call + mailer trigger, Day 2 call + VM + text, Day 3 call + VM + text. Cheapest channel first. Always.
Property data uploaded to DataSift: cleaned, deduped, and ready for niche sequential marketing.
Open in Google Sheets to explore all 5 tabs: Executive Summary, Timing Analysis, Zip Code Analysis, Equity & Property, and the full 248-property dataset.
22% to 38% of foreclosure records have deceased owners. Standard skip tracing misses them entirely. Deep prospecting finds the decision maker.
A foreclosure notice names the borrower. If that borrower is deceased, your calls go unanswered, your mail gets returned, and your texts bounce. But the property still has equity, still has a timeline, and still needs a solution. You just need to find the right person to talk to: the executor, the personal representative, or the eldest heir.
This is where the 4-Level Deep Prospecting Framework becomes essential. Level 1 enhanced skip tracing gets you 60-70% of contacts. Level 2 public records and Level 3 genealogy research (Ancestry, FindAGrave) close the rest. Or use Claude AI to automate all three levels for $1 to $4 per record.
Foreclosures move fast. When a lead says "not interested," follow up every 15 days, not the standard 90-day quarterly. Auction pressure changes minds quickly. 20% to 30% of all platform deals come from not-interested follow-ups.
400% higher conversion when you reach a lead within one minute of the trigger event. For foreclosures, "trigger event" is the day the notice publishes. Every day you wait, another investor gets there first.
Avi applied every lens. He knew his volume, his timing, his geography, his equity, and his outcomes. The result: a $33,000 purchase that sold for $230,000.
Avi is a Blueprint C Specialist working tax foreclosures and deed of trust foreclosures in North Carolina. His filter: minimum 3 years tax delinquent. Anything less has low motivation. He deep prospects every record, pulling estate files, running genealogy searches, and building research notes that compound over months.
His biggest deal: 1.92 acres of land purchased for $33,000 all-in. Sold for $230,000 with a $30,000 down payment on a 5-year interest-only note. Net profit before interest: $197,000+. The deal came from a deed of trust foreclosure list. Not AI scoring. Not a paid lead. County data, deep analysis, and persistence.
Two types of foreclosure, same framework. Tax foreclosures go through a commissioner sale (county attorney conducts the auction after a court hearing). Deed of trust foreclosures go through a trustee sale (bank's appointed trustee sells without full court process). Both have a 20+ day notice period before the sale. Both respond to the same 5-Lens analysis.
Rate yourself 1-5 on each dimension. Be honest. The gaps show you exactly where to focus.
Click any card to reveal the definition.
Click to flip
Data sourced directly from public records at the point of the trigger event. Foreclosures, probate, tax sales, code violations, evictions. The freshest, cheapest data available. Cost per contract: $500 to $2,000.
Click to flip
Days between the first public notice and the scheduled auction date. Knox County median: 34 days. Range: 13 to 89 days. This is your primary marketing window.
Click to flip
Removing repeat records to identify unique properties. Knox County: 537 raw to 248 unique = 53.8% duplicates. Without dedup, you market to the same owner multiple times and waste budget.
Click to flip
Estimated value minus mortgage balance, divided by estimated value. Sold properties had 21.5% median equity. Off-market properties: 77.2%. Lower equity correlates with higher selling motivation.
Click to flip
Latin for "suit pending." A legal notice filed in court records signaling the beginning of a foreclosure action. This is the earliest public trigger event for foreclosure data.
Click to flip
Tax foreclosure auction conducted by a county-appointed attorney (commissioner) after a court hearing and 20+ day notice period. Used for tax delinquent properties. May include an upset bid period.
Click to flip
Deed of trust foreclosure where a substitute trustee (appointed by the bank) sells the property without going through full court process. 20+ day notice period before sale. Faster than commissioner sales.
Click to flip
Time window after a commissioner sale where higher bids can be submitted to overturn the original auction result. 10 days in North Carolina. Creates a second chance to acquire the property at auction.
Click to flip
Property no longer listed on MLS. Could mean private sale, listing withdrawn, loan cured, or foreclosure completed. 49.6% of Knox County foreclosures went off market. These are deep prospecting targets.
Click to flip
Total marketing spend divided by contracts signed. FTM niche data: $500 to $2,000. Stacked Niche: $3,000 to $5,000. AI/Predictive: $4,000 to $8,000. Analysis lowers cost per contract by targeting the right records.
Seven questions on the 5-Lens Analysis Framework. All answers are on this page.
Download the analysis, explore related guides, and apply the framework to your own market.
Download the full Excel workbook (5 tabs, 248 properties)
The 3-day call/text/mail cadence for FTM data
4-level research framework for finding decision makers
Three-tier framework: FTM, Stacked Niche, AI data
Multiple $100K+ deals from tax foreclosure data
Complete tool recommendations by blueprint
