Summary
MARIS is the Artemis Team's master MLS dataset: 130,284 closed residential sales across Missouri and Illinois from March 2023 through March 2026. It powers CMAs, competitive intelligence, agent production tracking, and market trend analysis. Updates run on a Monday/Thursday schedule or manual weekly cadence.
Master Dataset: MARIS_Full_Market_Mar2023-Mar2026.xlsx
- 130,284 rows (104,829 MO + 25,455 IL)
- 24 columns: MLS #, Status, Current Price, Close Date, Close Price, CP/LP%, Type, Sub Type, Address, Township, Subdivision Name, City, MLS Area Major, Bedrooms Total, Bathrooms Total, Year Built, Days On Market, List Office MLS Id, Office_Name, Office_City, State_Filter, Source_Month
- 1,700 unique offices with name lookups already applied
- Filterable by state (MO/IL), office code, city, area, date, price, beds/baths, year built
Equity Deep-Dive: Equity_Breese_Highland_Production.xlsx
Focused report for Equity Realty Group's Breese (B187) and Highland (EFFR03) offices:
- Summary sheet: overall stats, year-over-year breakdown, per-agent production rankings
- All Deals sheet: 626 closed sales with full filters (auto-filter enabled, frozen header row)
- Agent Roster sheet: 31 agents across both offices
- Notes sheet: data sources and methodology
- Agent-level data populated for 235 deals (Jan 2025-Mar 2026). Older deals have office data but not individual agent attribution.
Pulling Agent-Level Data
From the Equity Spreadsheet
Open the All Deals sheet. Click the dropdown arrow on List Agent Name and select the agent. See every deal that agent listed with close price, date, address, buyer agent, and property details. Same process with Buyer Agent Name for buyer-side deals.
From the Master Spreadsheet (Office-Level)
The master has office codes but not agent IDs for the full 130K dataset. Filter List Office MLS Id to the code you want (e.g., "B187" for Equity Breese, "EFFR03" for Equity Highland). Office codes available in MARIS_Office_Roster.csv.
For Any Other Office (Browser Scrape)
Use the Cowork browser tab at mar.mlsmatrix.com. Search Closed/Residential sales with the target office code and date range. Click into the first listing detail page and run the JavaScript auto-scraper to collect List Agent, Buyer Agent, and Agent IDs from all detail pages. Save as CSV and merge with master spreadsheet data. Each office typically takes 1-5 minutes.
CMA Automation
Claude Projects Workflow
Upload MARIS_Full_Market_Mar2023-Mar2026.xlsx to a Claude project. Query in chat:
- "Build a CMA for a 3-bed, 2-bath home in Highland IL, built around 2005, price range $150K-$250K. Use sales from the last 12 months."
- "Compare average sale prices in Breese vs Highland for 2025."
- "What's the average days on market for homes over $300K in O'Fallon IL?"
- "Pull all sales by office B187 in 2025 and calculate total volume, average price, and median DOM."
Cowork Skill Approach
A cma skill can take a subject property address, find comps from the master spreadsheet using proximity filters (same city/subdivision, similar beds/baths/year built, recent sales), and generate a formatted CMA document. Comp matching: same city, +/- 1 bed, +/- 1 bath, built within 10 years, closed in last 12 months.
Update Methodology
Option A: Scheduled (Recommended)
Scheduled skill runs every Monday and Thursday at 7:00 AM:
- Open MARIS browser tab (
mar.mlsmatrix.com) - Search Closed/Residential for Missouri, last 7 days
- Export using sg179 format (Agent Single Line - Closed)
- Search Closed/Residential for Illinois, last 7 days
- Export using sg179 format
- Append new rows to master spreadsheet, match office names from roster
- Deduplicate by MLS # (keep latest version)
- Report new record count
Requires the browser to be open with a logged-in MARIS session.
Option B: Manual Weekly
Paste a single prompt block into Cowork requesting the same export/append/dedup workflow. Walk away and come back to an updated spreadsheet.
Option C: Python Script (Future)
Only viable if MARIS offers an API or RETS/RESO access. Currently MARIS Matrix has no public API -- browser-based export is the only path.
Non-Closed Listing Scrapes
For active/pending/coming soon listings, the same browser workflow applies. Uncheck Closed, check Active/Coming Soon/Withheld/Pending/Contingent, leave dates blank, export as sg179, then scrape agent data from detail pages.
Quick Reference
| Item | Value |
|---|---|
| Illinois state code | 2428 |
| Missouri state code | 2436 |
| Office ID field | Fm23_Ctrl195_TextBox (comma-separated) |
| Date format | MM/DD/YYYY-MM/DD/YYYY |
| Export format | sg179 (Agent Single Line - Closed) |
| Status code: Active | 102 |
| Status code: Closed | 105 |
File Locations
All data in Downloads/MARIS_Exports/:
- 74 monthly CSV files (37 MO + 37 IL)
- MARIS_Office_Roster.csv (2,423 offices)
- MARIS_Member_Roster.csv (5,056 agents)
- MARIS_Equity_Members.csv (97 Equity agents across 5 offices)
- Equity_Agent_Data.csv (236 scraped agent records)