Build a recurring Community Update for one neighborhood

Why it matters

Owners rarely ask for a listing appointment out of nowhere. A useful local report that arrives on schedule gives them a reason to know your name, and a low-pressure way to raise their hand when they start thinking about a move. It also gives your reactivation messages (Part 04) something real to offer.

Step by step

1. 01

   Choose a cadence you can keep for a year

   Monthly works for neighborhoods with 5 or more sales a month. Quarterly works for smaller ones; a monthly issue with zero sales trains people to ignore you. Put the next 4 publish dates in your calendar now.

   Check: Four dated calendar blocks exist, each 45 minutes.

2. 02

   Fill the outline from your fact sheet

   Copy the outline below. Section 1 is three sentences with numbers. Section 2 lists sales (all of them if fewer than 10). Section 4 is one local fact with a link to the official source. Section 5 is the only ask.

   Check: Every number in the draft appears on your fact sheet.

3. 03

   Publish it as a page

   Create a page at a stable address such as /community/harbor-pines and replace its content each issue, keeping past issues at dated addresses (/community/harbor-pines/2026-q3). Add the home value form from the next chapter at the bottom so readers can opt in to future issues or ask for a value range.

   Check: The page loads on a phone and the sources section is visible without expanding anything.

4. 04

   Email it only to people who asked

   Send to contacts tagged cu-harbor-pines (people who opted in on the form or asked by reply). Include the first section in the email body and link to the page. CAN-SPAM still applies: accurate From and subject, your postal address, a working unsubscribe honored within 10 business days.

   Check: A test email to yourself shows the postal address and an unsubscribe link.

5. 05

   Track replies and value requests

   Tag anyone who replies or requests a value range cu-engaged and route them as seller leads (chapter 5 of this part). Count them per issue; that number tells you whether the Community Update is working.

   Check: Your CRM shows a cu-engaged count for each issue sent.

Copyable templates

# {Neighborhood} Community Update: {Month or Quarter} {Year}
Prepared by {Agent name}, {Brokerage} | {date published}

## 1. The short version (3 lines)
- {count} homes sold in {Neighborhood} between {start} and {end} ({count same period last year} a year earlier).
- {count} homes are for sale today; {count} were newly listed this period.
- {One plain sentence on what changed, with a number.}

## 2. What sold
| Street | Beds/Baths | Sq ft | Closed price | Days on market | Closed |
|--------|------------|-------|--------------|----------------|--------|
| {Elm St} | {3/2} | {1,850} | {$612,000} | {21} | {Aug 2026} |
(Show every sale when there are fewer than 10; otherwise median price, median days on market and price range.)

## 3. What's for sale and what's coming
- Active listings: {count}, priced {low} to {high}.
- Expired or withdrawn this period: {count}.

## 4. One useful local item
{A permit change, a road project date, a new park opening: a fact with a link to the official source.}

## 5. What this could mean for your home
Every home is different. If you'd like a value range for your address with the sales above as comparisons, reply or use {link to home value page}. No obligation.

## Sources
Based on information from {MLS name} for the period {start} through {end}, {property type} in {boundary}.
Not all properties were listed or sold by {Brokerage}. {Other sources with table/release names.}

{Brokerage legal name} | {Postal address} | {License #}
You're receiving this because you asked for {Neighborhood} updates. {Unsubscribe link}
Equal Housing Opportunity.

field,example,source,refresh
neighborhood_name,Harbor Pines,your boundary definition,never (fixed)
boundary_definition,"MLS subdivision ""Harbor Pines"", single-family",your saved MLS search,never (fixed)
period_start,2026-07-01,you,each issue
period_end,2026-09-30,you,each issue
closed_count,9,MLS,each issue
closed_count_prior_year,12,MLS,each issue
median_closed_price,612000,MLS,each issue
median_dom,21,MLS,each issue
sale_rows,"Elm St, 3/2, 1850, 612000, 21, 2026-08",MLS,each issue
active_count,6,MLS,each issue
new_listings,11,MLS,each issue
expired_withdrawn,2,MLS,each issue
local_item,"Seaside Blvd repaving starts Nov 3 (city notice link)",official city or county site,each issue
citation_line,"Based on information from Seaside Regional MLS for the period 07/01/2026 through 09/30/2026...",you,each issue

Try it

How to test it

1. Ask a non-agent friend to read the update for 3 minutes. They should be able to say how many homes sold and what is for sale.
2. Click the unsubscribe link in your test email. Confirm your test contact is now unsubscribed.
3. Check the page on a 390px-wide phone screen: tables scroll or stack and nothing is cut off.

Troubleshooting

Advanced technical details

Optional. You can follow every step above without these.