🏘️ Flip Buyers - User Guide

📋 Overview

Each row is one investor entity. Columns:

• Name — entity name (LLC, person, trust). Click the row to see SOS registration info and full deal history.
• Type — LLC, Person, or Trust.
• Deals — how many confirmed flips this entity has completed.
• Avg Profit — average profit per flip (sell price − buy price).
• Avg Hold — months between buy and sell, averaged.
• Last Deal — month of the most recent confirmed flip.
• Location — city & state of the most recent flip.
• Counties — every county this entity has flipped in.

🔍 How buyers are detected

A nightly job queries our property data provider for cash-buyer entities active in the last 3 years (configurable). For each candidate, we pull full transaction history and confirm a flip when:

• The entity bought, then sold the same property.
• Hold period was between 2 and 30 months.
• Sell price differs from buy price by at least $5,000 (filters out paper transfers).
• The transaction was arm's-length (filters out gift/intra-family transfers).
• The seller is not an institution (banks, FNMA/FHLMC, HUD, trustees, mortgage servicers excluded).

Confirmed flippers are upserted into the buyers table; their deals are added to the deal history. LLCs are then enriched with California Secretary of State filings to surface the registered agent name and mailing address.

🎛️ Filters & sorting

• County — defaults to Los Angeles. Switch to any market with confirmed buyers.
• Type — LLC / Individual / Trust.
• Min deals — defaults to 2+ to hide one-off transactions.
• Category — Investors only by default. Switch to Lenders, Trustees, or All to surface edge cases like REO trustees and bridge lenders.

Sortable columns: click any column header (Name, Type, Deals, Avg Profit, Avg Hold, Last Deal, Location). Click again to flip direction.

Saved filters: your filter and sort selections are remembered between sessions per user.

🗺️ Map & profit colors

Every confirmed flip with coordinates appears on the map as a colored pill labeled with its profit number. Markers cluster automatically when zoomed out. Click any pill to see the address, buy/sell dates and prices, the buyer, and a link to view that buyer in the list.

Colors:

• Dark green — profit ≥ $200k
• Light green — profit $50k – $200k
• Amber — profit $0 – $50k
• Red — loss (< $0). Note: many losses are data-quality artifacts (bundle purchases split across multiple unit rows). We're cleaning these up over time.

👤 Buyer details

Click a buyer's row to expand a panel showing:

• SOS registration: status, standing (Good / Suspended / Inactive), state of formation, filing date.
• Registered agent name, with a flag if the agent is a commercial filing service.
• Mailing / physical address on record.
• Every confirmed flip: address, buy/sell dates, buy/sell prices, profit, and hold months.

Phone numbers for registered agents are not currently displayed pending review of contact policy. Use the mailing address and agent name for skip-tracing.

📋 Add to CRM

Click the + CRM button on any row to add this buyer to your CRM as a cash buyer. The buyer's name, entity type, preferred counties, and avg profit get pre-populated. You'll be prompted for an email if you have one; otherwise a placeholder email is used.

Find Deals on the same row jumps to the On Market Deals page filtered to this buyer's county and price range, so you can see what inventory matches what this investor actually buys.

🤖 Asking Scout

The Scout chat panel on this page can answer questions about the buyers you're viewing:

• "Who's the top flipper in Los Angeles right now?"
• "Show me LLC flippers averaging over $200k profit."
• "What's the deal history for Balboa West LLC?"
• "Tell me everything about this buyer." (after clicking a row)

Scout has tools to search the buyer database directly, so it can answer queries beyond what's on screen.

⚠️ Data caveats

• Coverage is partial. Buyer discovery costs API credits, so we run sync against one county at a time. Counties with few buyers may simply not have been scanned recently.
• Bundle purchases. When an investor buys multiple condo units in one deed for a combined price, our ingestion sometimes attaches the full bundle price to each unit, producing fake losses. We split these proportionally; if you spot one we missed, let us know.
• Trusts and family transfers. Some "flips" are intra-family transfers that look arm's-length on paper. The Trustee filter category isolates these so you can review or skip them.
• SOS data is California-only for now. LLCs from other states show name and counties but no agent / mailing address.