real-estate-market-alerts

name	real-estate-market-alerts
description	Proactively monitors listing activity, price changes, interest rate shifts, and market signals. Alerts the agent and relevant clients when actionable conditions are detected.
user-invocable	true
metadata	{"openclaw":{"emoji":"🔔","always":true}}

Real Estate Market Alerts Skill

Purpose

Use this skill during cron runs and heartbeat intervals to monitor real estate market conditions and trigger alerts when meaningful changes occur that require human attention or client communication.

Alert Categories & Thresholds

1. Price Reduction Alerts

Trigger: Any active listing drops price by 2% or more in target zip codes

Action:

• Log the reduction with original price, new price, % change, and DOM
• Cross-reference against active buyer clients — does this now fit someone's criteria?
• If yes: Draft immediate "price drop" alert email to matched buyers
• Alert owner if the home was a previously unsold REX listing

Client Email:

"Quick heads up — [Address] just reduced from $[X] to $[X] ([Y]% reduction). Based on what you're looking for, this might be worth a second look. Want me to schedule a showing this week?"

2. New Listing Alert

Trigger: New listing appears in target zip code(s) at or under median price

Action:

• Pull full listing details from Zillow/Redfin
• Compare to active buyer criteria in memory/CRM
• Match and send instant alert to relevant buyers
• If it's an expired listing that re-listed: Flag as outreach opportunity for sellers

3. Interest Rate Movement

Trigger: 30-year fixed rate moves more than 0.15% in either direction in a single week

Action (Rate Drop):

• Alert owner: "Rates dropped — this is a buyer activation moment"
• Draft social post: rate drop context + what it means for purchasing power
• Queue outreach to warm buyer leads in nurture: "Rates just moved — here's what that means for your purchasing power"

Action (Rate Spike):

• Alert owner: "Rates spiked — seller urgency play"
• Consider messaging to active listings: "Buyers are more rate-sensitive now — let's review pricing strategy"
• For buyers under contract: Check in on rate lock status

4. Days on Market Threshold

Trigger: Any REX-represented listing hits 21 days on market without an accepted offer

Action:

• Alert owner with showing activity report
• Prepare price reduction analysis (what price would put it in top 10% of value in its comp set?)
• Draft seller communication: "Let's talk strategy — here's what I'm seeing and what I'd recommend"

5. Competitor Activity Alert

Trigger: High volume of new listings or price reductions from a competing agent in target area

Action:

• Log pattern in memory
• Assess: Is this a supply surge? A competitor dumping listings? A seasonal shift?
• Adjust marketing messaging if inventory meaningfully increases ("More options means more negotiating power for buyers")

6. Market Shift Alert

Trigger: Months of supply crosses key thresholds (below 2.0 or above 6.0)

Action:

• Below 2.0 months: Market is critically undersupplied. Alert owner. Prepare "seller's market" campaign. Increase expired/FSBO outreach.
• Above 6.0 months: Market has softened to buyer's market. Adjust seller consultations to more aggressive pricing. Identify buyer prospects who may have been sitting out.

7. Closed Sale Alert (Neighborhood Level)

Trigger: A home closes in a target neighborhood at a price meaningfully above or below comparable REX listings

Action:

• If above: Alert seller clients with good news and use as fresh comparable data
• If below: Flag as potential pricing pressure, discuss with seller

---

Alert Output Format

Every alert sent to owner should include:

🔔 REX ALERT — [Alert Type]
Date/Time: [timestamp]
Location: [address or neighborhood]
Trigger: [what happened]
Impact: [who this affects and how]
Recommended Action: [specific next step]
Urgency: [Immediate / Today / This Week]

What REX Does NOT Alert On

• Minor DOM fluctuations under 5 days
• Price changes under 1.5% (noise, not signal)
• National news that doesn't affect local market
• Listings outside primary service geography unless specifically relevant to a known client

Learning Protocol

After 90 days of operation, analyze:

• Which alert types generated the most client responses?
• Which alerts led to appointments or deals?
• Which alerts got ignored consistently?

Adjust thresholds and focus accordingly. Store this in memory as "Alert Performance Data."

Skill Location

{baseDir}