Pre-Foreclosure Tracking

Input Parameters

Processing Methodology

The Pre-Foreclosure Tracker processes data through a four-stage pipeline:

Stage 1 — Apify Actor Execution. Each morning, the configured Apify actor collection executes against the target county sources. Separate actors are maintained for:

• County recorder document search (NOD, NOD release, Lis Pendens, trustee's deed)

• County court electronic filing systems (civil division for judicial foreclosure states)

• Third-party foreclosure auction scheduling platforms (Auction.com, county trustee sites)

• REO listing databases for downstream stage tracking

Actors are updated monthly to maintain compatibility with county website changes. If a county recorder site undergoes a structural change that breaks extraction, a manual backup protocol triggers a notification to the Hawary AI maintenance team within 24 hours.

Stage 2 — Record Normalization. Raw filing data from county sources is normalized into a standardized record format:

• Filing type classification (NOD / Lis Pendens / NTS / REO)

• Document recording date vs. filing date (both captured)

• Property legal description converted to street address via assessor lookup

• Case number or document number for official reference

• Lender/plaintiff name

• Loan amount (from original deed of trust or mortgage record)

Stage 3 — Property Enrichment. Each filing is cross-referenced with county assessor data to add:

• Current ownership name and mailing address (non-property-address mailing = out-of-state flag)

• Assessed value and last recorded sale

• Estimated current market value (from recent comparable sales via MLS data pull)

• Estimated loan balance (original loan amount adjusted for estimated payments made based on origination date and standard amortization; payoff assumed full balance until confirmed)

• Estimated equity calculation: Estimated Market Value − Estimated Loan Balance

• Days on foreclosure timeline since first filing

• Estimated days to auction (where auction date is scheduled)

Stage 4 — Stage Classification and CRM Push. Each property is classified into one of four pipeline stages:

Properties at the "Auction Scheduled" stage with fewer than 30 days remaining are automatically tagged as URGENT and trigger an immediate CRM notification to the assigned acquisition team member.

Output Format

Daily Feed Summary:

```

Pre-Foreclosure Daily Feed

Counties Monitored: Maricopa County, AZ | Pinal County, AZ

Feed Date: [Date]

New Filings Today: 23

Stage Breakdown: NOD (11) | Lis Pendens (6) | Auction Scheduled (4) | REO (2)

Above Equity Minimum ($30K): 19 properties

```

Per-Property Record:

Conservative Bias Methodology

1. Filing Confirmation Required. A property is added to the feed only after the filing is confirmed against the official primary source — the county recorder's indexed document system or the court's electronic filing system. If a filing appears on a third-party aggregator but cannot be confirmed on the primary source, it is held in a "Pending Confirmation" queue and not pushed to CRM until primary source confirmation is achieved (typically within 1–3 days as county systems update).

1. Equity Estimation. Estimated equity uses the lower of assessed value or estimated market value. The loan balance estimate uses full original loan balance as the default conservative assumption when an official payoff figure is not available. This means estimated equity shown is a floor — actual equity may be higher.

1. No Rumor or Hearsay Sources. Court documents, recording office documents, and official auction scheduling platforms are the only data sources used. Social media, neighborhood reports, and investor forums are never used as signals.

1. Stage Changes Require Re-Confirmation. When a property is flagged as moving to a new stage (e.g., from NOD to Auction Scheduled), the new stage must be confirmed against a primary source before the CRM record is updated.

CRM Integration

GoHighLevel:

• Creates contact + opportunity in "Pre-Foreclosure" pipeline

• Stage tag matches foreclosure pipeline stage: Stage-NOD, Stage-LisPendens, Stage-AuctionScheduled, Stage-REO

• Urgency tag applied: URGENT for auction within 30 days

• Stage change triggers automated workflow (configurable: SMS/email/task assignment)

• Daily feed summary pushed as conversation note to admin contact

HubSpot:

• Creates Deal in custom "Pre-Foreclosure Leads" pipeline

• Custom properties: Filing Stage, Filing Date, Estimated Equity, Days to Auction, Lender Name

• Stage change triggers workflow enrollment

Salesforce:

• Opportunity created in Pre-Foreclosure Acquisition stage

• Custom object: Foreclosure Filing Record attached to Opportunity

• Alert task auto-created for URGENT properties