Start with the agency responsible for property-code enforcement in the city or county you are researching. Look for an official case search, open-data download, or public-records request process. Ask for the fields that let you distinguish an open property case from an old complaint before matching the records to owners.
A code record tells you something about an enforcement process. It does not tell you that the owner wants to sell, what repairs will cost, or what price the house is worth.
TL;DR
- Identify the correct jurisdiction and agency before requesting a list.
- Ask for case identifiers, property references, status, and relevant dates so the records can be interpreted.
- Combine multiple cases about one property into one property record while preserving the case history.
- Verify current ownership and the owner's mailing destination, and keep outreach separate from any claim of government authority.
Find the actual records custodian
Begin on the city or county's official website. A complaint-submission form is not necessarily a database you can export. Similarly, a court citation search may answer a narrower question than a complete property-code history.
As a concrete example, Chattanooga's Code Enforcement page describes property-maintenance enforcement. The city separately provides an Open Records Center route for requesting records. Those are different functions: reporting a new problem and obtaining existing records.
Do not report a violation just to manufacture a lead. Research records that already exist and use the appropriate request process.
The Chattanooga example applies to the city, not automatically to every property with a Chattanooga postal address or to all of Hamilton County. Verify which agency has jurisdiction over the property you are researching.
Ask for a usable export, not “all distressed houses”
The following is an original request template to adapt to the agency's process. It is a request you could make, not a claim that every agency holds all these fields:
Please provide the existing electronic records for property-maintenance code cases in [jurisdiction] that are currently open, or were opened or closed between [start date] and [end date]. If maintained, please include case number, property address, parcel identifier, violation category, current status, date opened, most recent inspection date, and date closed. Please also include the field definitions and the date of the export. An existing CSV or spreadsheet is preferred if available. Please advise of any fees before processing.
Use the jurisdiction's eligibility and request rules. Chattanooga's page explains that Tennessee citizens have statutory inspection rights subject to applicable restrictions, and that agencies may also choose to provide access to others. Do not assume the same access conditions apply everywhere. Chattanooga public-records guidance
Separate complaints, cases, and properties
Read the status definitions before filtering. A report may be unverified, a case may have been resolved, and an inspection entry may be one event within a longer case. Avoid treating every row as a separate active violation or a separate house.
Illustrative example: an export contains 75 case rows associated with 40 properties. Remove the 12 properties with only closed cases. Of the remaining 28, six have unresolved property matches. That leaves 22 properties for further review, not 75 mailing recipients. Some of those 22 may share an owner, which creates another recipient-level decision later.
Keep the source case numbers so you can check a status again. When the record changes, update the current status without erasing the original observation.
Check whether the property is relevant to your buying plan
A maintenance issue and a major structural problem are different research questions. Do not infer a repair budget from the existence of a case or from the number of entries in a file.
Use a simple working table:
| Check | Decision |
|---|---|
| Correct property and jurisdiction? | Resolve mismatches before further use |
| Current case status understood? | Hold ambiguous statuses for clarification |
| Property fits your buying criteria? | Exclude properties outside your scope |
| Current owner and mailing destination checked? | Prepare outreach only after these are usable |
| Owner asked to stop? | Keep the record suppressed |
If a potential purchase moves forward, investigate the actual work, permits, and unresolved obligations for that property with the relevant professionals and agency. A marketing list is not a completed property investigation.
Keep the message about your interest in buying
Identify yourself as a prospective buyer. Do not make the piece resemble a city notice, imply you represent code enforcement, or promise to eliminate fines you have not investigated.
The owner can tell you whether a sale is relevant. Your role is to ask a clear question about a property that fits your criteria, then handle the answer respectfully.
For other sourcing methods, see Homebase's distressed-property guide. If you want ongoing neighborhood outreach, see how Homebase works.
Direct mail to the neighborhoods where you want to buy
Homebase handles direct mail to property owners in the neighborhoods where you want to buy. Enter one address to find your neighborhood and get your first neighborhood analysis free. No card required.
Analyze a neighborhood free