a Sagan program · currently in private beta

Market Intelligence Agent

The weekly report scrapes competitor vacancy pages and Zillow, fuzzy-matches addresses to surface self-managed leads, tracks price changes and days-on-market by city and bedroom, and delivers a filterable dashboard with Excel export.
before

Property manager manually visits 8-10 competitor websites weekly, copies vacancy listings into Excel, calculates days on market, tracks price changes, and manually reviews Zillow to identify self-managed landlords. Process costs $1,000 per month in labor and produces spreadsheets that go stale between updates.

after

Agent scrapes all sources weekly, deduplicates properties, and delivers a filterable dashboard with summary statistics showing market positioning, pricing trends, days-on-market progression, and a list of self-managed rental properties ready for outreach. Process costs $20-30 per month and runs unattended.

real estate / property management / residential real estate / data enrichment / lead intake / reporting / ZenRows / Zillow / SQLite / Railway / SMTP /  real estate / property management / residential real estate / data enrichment / lead intake / reporting / ZenRows / Zillow / SQLite / Railway / SMTP / 
the problem

Manual market research costs $1,000 per month and takes hours every week

Property managers track competitor vacancy listings to stay competitive.

01
Manual data entry

Copying vacancy details from 8-10 competitor websites into spreadsheets every week

02
Delayed market intelligence

Spreadsheets become outdated within days, forcing re-runs before weekly team meetings

03
Lead generation gap

Identifying self-managed landlords on Zillow requires manual review and deduplication across sources

the math, if you want to look

Eliminate $1,000 per month in manual research and surface self-managed leads automatically

proof 01
Direct cost savings

Replaces $1,000 per month in manual labor with $20-30 per month in automation costs

proof 02
Weekly market positioning data

Dashboard shows where your rental prices fall relative to competitors, updated automatically every week

proof 03
Self-managed lead list

Identifies properties on Zillow not managed by tracked competitors, ready for management agreement outreach

proof 04
Actionable summary statistics

Vacancy counts by city and bedroom type, average pricing, and days-on-market trends for weekly team meetings

This agent scrapes 8-10 competitor property manager websites and Zillow weekly, deduplicates properties across sources, and delivers a filterable dashboard with summary statistics. Property managers see market positioning, pricing trends, days-on-market progression, and a list of self-managed rental properties ready for outreach. The entire process runs unattended every week and costs approximately $20-30 per month to operate.

how it works

Weekly automated scraping, deduplication, and reporting

The agent runs once per week on a schedule you set. It scrapes competitor websites and Zillow, removes duplicate properties, and delivers a dashboard with filtering, sorting, and Excel export.

step 01
Scrape competitor vacancy pages

Agent visits 8-10 competitor property manager websites you specify, extracts all listed rentals with address, rent, bedrooms, bathrooms, property type, and available date

step 02
Scrape Zillow for self-managed properties

Agent searches Zillow rental listings in your service areas (Corvallis, Albany, Philomath, Lebanon) and extracts the same property details

step 03
Deduplicate across sources

Agent removes Zillow listings that match competitor properties by property manager name or address, leaving only self-managed landlords as sales leads

step 04
Calculate market metrics

Agent tracks days listed (how long advertised) and days on market (how long available to rent), price changes week-over-week, and summary statistics by city and bedroom count

step 05
Deliver dashboard and email notification

Agent sends you an email with a link to the web dashboard, where you can filter by city, bedroom count, price, property type, and download Excel. Summary statistics show vacancy counts, average pricing, and market trends

ai agent · estimator console inputs transform outputs public preview
inputs
Competitor property manager websites +

8-10 competitor vacancy pages you specify (e.g., Corvallis Property Management, Hub City Rentals, 707 Apartments)

Zillow rental listings +

Rental listings in your service areas: Corvallis, Albany, Philomath, Lebanon

Property details from listings +

Address with unit number, rent, bedrooms, bathrooms, property type, available/move-in date, property manager name (if shown)

transformation
Extract and normalize addresses +

Parse street address, unit number, and city from each listing; normalize formatting so '123 Main St #5' matches '123 Main Street Apt 5'

Deduplicate by property manager name +

Remove Zillow listings where property manager name matches a tracked competitor (fuzzy matching handles variations like 'Corvallis Property Management LLC' vs 'Corvallis Property Mgmt')

Deduplicate by address +

Remove Zillow listings where address matches a competitor property already tracked

Calculate days listed and days on market +

Days listed counts from first appearance; days on market counts from move-in date onward (zero for pre-leasing properties with future dates)

Track price changes week-over-week +

Compare rent from previous week to current week; flag decreases as price reductions

Aggregate summary statistics +

Calculate vacancy counts by city and bedroom count, average rent per bedroom, average days on market per bedroom

outputs
Filterable web dashboard +

View all tracked properties sorted by price within bedroom categories; filter by city, bedroom count, property type, source, price range, days on market

Summary statistics panel +

Vacancy counts by city and bedroom, average rent per bedroom, average days on market per bedroom, total self-managed leads identified

Self-managed leads list +

Zillow properties not managed by tracked competitors, labeled 'Direct from Zillow', ready for outreach

Excel export +

Formatted workbook with detailed property listings (sorted by price within bedroom categories), summary statistics tab, and price change history

Weekly email notification +

Email with report summary, dashboard link, and Excel download button

draft ready for estimator review _
tech used
ZenRows web scraping with JS renderingZillow rental listing pagesSQLite historical trackingSMTP email deliveryLightweight AI tier for address normalization
tool alternatives
Apify or Browserbase instead of ZenRows for web scrapingPostgreSQL instead of SQLite for higher volumeSendGrid or AWS SES instead of direct SMTP
honest qualification

Is this for you?

built for you if
  • + Property management companies - Managing 100+ rental doors and competing on pricing and availability. You need weekly market intelligence to position your rentals competitively.
  • + Owners doing their own lead generation - You manually track competitors and want to eliminate that work while adding automated lead generation from self-managed landlords.
  • + Teams with weekly market meetings - You review market data with leasing agents and business partners every week. You need fresh, sortable data that shows pricing trends and vacancy patterns.
  • + Excel-based workflows - You download reports, print them, and review them in meetings. You want Excel export, not cloud-only dashboards.
not for you if
  • - Single-property owners - If you manage one or two rental units, the cost and complexity don't justify the benefit. This agent is built for competitive market tracking across multiple properties.
  • - Markets with fewer than 5 competitors - The value comes from tracking multiple competitors to see positioning patterns. If your market has only 1-2 property managers, manual tracking may be sufficient.
  • - Teams that don't review market data regularly - If you don't use market intelligence to make pricing or leasing decisions, this agent won't change your workflow.
  • - Fully integrated CRM workflows - This is a standalone reporting tool. If you need leads automatically pushed into your CRM or property management software, that integration would require additional development.
pricing

Scoped build plus usage-based monthly operations

to build

The agent is built to your specifications with direct URLs to competitor websites you provide. Once live, the agent runs weekly and costs approximately $20-30 per month to operate (web scraping, address normalization, email delivery). This is a fraction of the $1,000 per month you currently spend on manual research.

then
  • Initial build includes prototype with synthetic data, then integration with your actual competitor URLs and Zillow
  • Weekly scraping and dashboard hosting included in monthly operations cost
  • Excel export and email delivery included
  • Cost estimate assumes weekly scraping of 8-10 competitor sites plus Zillow; adjust if you add more sources
  • No per-property or per-lead fees; flat monthly operations cost
FAQ
How much does this agent cost to run each month?

The agent costs approximately $20-30 per month to operate after the initial build. This includes weekly web scraping, address normalization, dashboard hosting, and email delivery. This replaces the $1,000 per month you currently spend on manual market research.

What data does the agent collect from competitor websites?

The agent scrapes all listed rental properties from your competitor property manager websites weekly, extracting address with unit number, rent, bedrooms, bathrooms, property type, and available/move-in date. It also tracks price changes week-over-week and calculates two separate metrics: days listed (how long advertised) and days on market (how long available to rent).

How does the agent identify self-managed landlords on Zillow?

The agent scrapes Zillow rental listings in your service areas (Corvallis, Albany, Philomath, Lebanon) and removes any properties that match competitors you're already tracking. It matches by property manager name using fuzzy matching and by address using normalized address comparison. The remaining properties are self-managed landlords labeled as 'Direct from Zillow' and ready for outreach as sales leads.

What does the weekly dashboard show?

The dashboard displays all tracked properties with filtering by city, bedroom count, property type, price, and days on market. Properties are sorted by price within bedroom categories so you can see where your rentals fall in the market. A summary statistics panel shows vacancy counts by city and bedroom, average rent per bedroom, and average days on market. You can download all data as Excel for your team meetings.

How often does the agent run and when will I get the report?

The agent runs once per week on a schedule you set. You'll receive an email notification when the report is ready with a link to the web dashboard and a button to download Excel. The entire process runs unattended, so you have fresh market data ready for your weekly team meetings without visiting competitor websites or copying data into spreadsheets.

What's the difference between 'days listed' and 'days on market'?

Days listed counts how long a property has been advertised on the website, starting from the first day it appears. Days on market counts how long a property has been available to rent. For pre-leasing properties with a future move-in date, days listed is counting but days on market stays at zero until the move-in date arrives. This distinction helps you understand which competitors are pre-leasing effectively.

Can I export the data to Excel?

Yes. The agent generates a formatted Excel workbook every week with three tabs: detailed property listings sorted by price within bedroom categories, summary statistics showing vacancy counts and average pricing by city and bedroom, and price change history. You can download it directly from the dashboard or via a link in the weekly email notification.

What happens if a competitor website goes down or changes their structure?

If a competitor site fails to scrape during a weekly run, the agent still sends your report with data from the other sources and notes which sites failed. For example, you might see '45 properties tracked from 8 sources, 2 sites unavailable this week.' The agent continues to work with the available data rather than blocking the entire report. If a site permanently changes its structure, that's a maintenance task requiring a quick update to the scraping rules.

next step

Stop paying $1,000 per month for manual market research

This agent eliminates the weekly spreadsheet work and adds automated lead generation from self-managed landlords. You'll have fresh market positioning data every week, ready for your team meetings, plus a list of self-managed properties to contact for management agreements.