Direct mail API for developers and growth teams. Read the docs →

Direct mail API for PropStream

Direct mail API for PropStream lists: export a list from My Properties, and a short script sends each owner's mailing address to Mailr, which prints your postcard and mails it with USPS, 1,000 per request. The mailing address matters: for an absentee owner, the property address reaches a tenant or an empty house.

What to mail from PropStream

When this happensMail this
You export a Pre-Foreclosures list (missed payments and a default filed by the lender)A 6x11 postcard to each owner's mailing address with your offer.
You export a Vacant list (marked vacant by the US Postal Service)The same card to the owner's mailing address, since nobody collects mail at the house.
You export Tired Landlords (non-owner-occupied, owned more than 15 years)A card to each landlord at their mailing address, naming the rental.

Set it up

  1. Build and save the list. Use PropStream's filters and lead lists (Pre-Foreclosures, Vacant, Tired Landlords, Cash Buyers and the rest) and save the properties to a list in My Properties.
  2. Export it. Open the list in My Properties, check the box at the top to select every record, and click Export to download the spreadsheet. Exports count against your plan's monthly saves and exports (25,000 on Essentials, 50,000 on Pro, 100,000 on Elite), which don't roll over.
  3. Map the owner's mailing address. The export follows the layout you see in PropStream. Open the file, find the owner name and mailing address columns, and set COLUMNS in propstream_csv.py to those headers. Keep the property address column for the card's message.
  4. Make the design. Start from blank/6x11 in the Mailr kit (/downloads/mailr-kit.zip) and write the message with {{first_name}} and {{property_street}}, as in the back.html tab. Mailr prints the owner's address, your return address, postage and the barcode in the keep-clear zone.
  5. Run with a test key, then live. Run python propstream_csv.py export.csv with your mlr_test_ key. It mails one card per owner mailing address, puts rows without one in skipped.csv, and writes piece ids to mailed.csv. Then switch to your mlr_live_ key.

Script and design: PropStream to Mailr

"""Mail the owners on a PropStream export: python propstream_csv.py export.csv
My Properties > open the list > check all > Export. Match COLUMNS to your file's first row.
"""
import csv, hashlib, sys
from pathlib import Path
from mailr_batch import address, already_mailed, report, send

COLUMNS = {
    "first": "Owner 1 First Name", "last": "Owner 1 Last Name",
    # Where the owner receives mail. For an absentee owner this is not the property.
    "line1": "Mailing Address", "line2": "Mailing Unit #", "city": "Mailing City", "state": "Mailing State",
    "zip": "Mailing Zip",
    # The property, for the card's message.
    "property": "Address",
}
DESIGN = {
    "kind": "postcard",
    "size": "6x11",
    "front": Path("mail/cash-offer/front.html").read_text(),  # from blank/6x11 in the Mailr kit
    "back": Path("mail/cash-offer/back.html").read_text(),    # uses {{first_name}} and {{property_street}}
    "from": {"name": "Sonoran Home Buyers", "line1": "1 Example Way", "city": "Phoenix", "state": "AZ", "zip": "85004"},
}

done, rows, skipped, seen = already_mailed(), [], [], set()
with open(sys.argv[1], newline="", encoding="utf-8-sig") as f:
    for r in csv.DictReader(f):
        c = {k: (r.get(col) or "").strip() for k, col in COLUMNS.items()}
        name = f"{c['first']} {c['last']}".strip() or "Current Resident"
        to, why = address(name, c["line1"], c["city"], c["state"], c["zip"], c["line2"])
        # The owner's mailing address is the record id: one card per owner, even one with several houses
        # on the list, and the same owner on next month's export is skipped.
        a = to or c
        rid = hashlib.sha256(f"{a['line1']}|{a.get('line2', '')}|{a['zip'][:5]}".upper().encode()).hexdigest()[:24]
        if rid in done or rid in seen:
            continue
        seen.add(rid)
        if why:
            skipped.append([rid, c["property"], why])
            continue
        rows.append((rid, to, {"first_name": (c["first"] or "Neighbor")[:14], "property_street": c["property"]}))

report(skipped)
send("propstream-cash-offer", DESIGN, rows)
  • PropStream's own direct mail asks whether to mail the property address, the mailing address or both. With Mailr you choose in code, and the script uses the mailing address.
  • PropStream doesn't publish the export's column names, so the names in COLUMNS are placeholders: match them to the first row of your file.
  • An owner with several properties on the list gets one card at their mailing address, naming the first property. The owner's mailing address is the record id, so next month's export skips owners already mailed as long as you keep mailed.csv.
  • PropStream's data comes from county recordings, MLS records and private sources. Mailr doesn't verify addresses or run NCOA, so check an older list first (see the Smarty page).
  • Rows with no owner name go out to Current Resident, and {{first_name}} falls back to Neighbor.
  • PropStream's terms, not Mailr's, set how you may use exported data for mail.

What it costs

Each live piece is paid from your Mailr balance, printing and postage included: a 4x6 postcard is $0.85, a 6x9 $0.89 and an 8.5x11 letter $0.95 on pay as you go, less on a plan. Test pieces are free. All prices.

Questions

PropStream already sends postcards. Why use Mailr?

PropStream's campaigns run inside PropStream. Mailr is for when the mail runs from your own code: your own HTML design, PropStream lists mixed with other sources, 1,000 owners per request, and a piece id stored with each lead in your CRM.

Does PropStream have an API?

PropStream doesn't publish developer docs for one, so this page uses the export. Anything that can read the CSV can send it to Mailr.

Mailing address or property address?

The mailing address: it's where the owner receives mail. For a rental or a vacant house, the property address reaches a tenant or no one. For an owner-occupied home the two are the same.

What about owners that are companies?

The card goes to the owner name and mailing address in the export. For corporate owners, PropStream's corporate skip tracing uses the property address to find the company's mailing address.

What does it cost?

One price per piece with printing and postage included: a 6x9 postcard is $0.89 on pay as you go and less on a plan, and the pricing page lists the 6x11. Test pieces are free and never print.

The code on this page is written against the Mailr API as it works today. Test it with your test key first; nothing prints until you use a live key.
PROPSTREAM

Mail from PropStream today

Get a free test key, send one postcard to yourself and watch it move through every status.

  • Postcards, flats and folded mailers
  • A proof before anything prints
  • Free test mode: nothing prints, nothing charges
  • A status for every piece

Get the price sheet by email

Every postcard, letter, mailer and print product on every plan, postage included.

We’ll email you the price sheet. By continuing you agree to the Terms and Privacy Policy.

Download the template kit?

mailr-kit.zip · about 310 KB · 65 text files

Only HTML, JSON and Markdown files. No programs, scripts or macros, nothing that installs or runs.