ValuSignal

The Signal / AI in practice / October 6, 2026

Market analysis, built with AI

What AI-built market analysis looks like Collin County, 61,104 listings

Form 1004MC summarizes a market in three periods. We put two years of MLS data for Collin County, Texas through an AI build to show what a fuller analysis contains, which checks the appraiser still makes, and what end users could receive.

Start reading
  • Listed October 2024 to October 2026
  • Sold 30,485
  • Left the market unsold 16,550
  • Still listed or under contract 7,847
Each point is a group of listings, placed by list date and list priceMLS data as of October 5, 202610 chapters
01 / The 1004MC gridThree periods, one table

The starting point

Collin County in the 1004MC format

Fannie Mae stopped requiring Form 1004MC, the Market Conditions Addendum, in August 2018, saying its Collateral Underwriter supplies market trend information to lenders. Orrick ↗ The appraiser still analyzes market conditions, and the three-period grid remains one way to show that work. UAD 3.6 and the redesigned URAR become mandatory for new reports submitted to UCDP on or after November 2, 2026, with the exception path covered in our UAD 3.6 delay piece. Freddie Mac FAQ ↗

Here is the grid for all of Collin County, residential, with an effective date of October 5, 2026.

Inventory analysis, 1004MC format, all of Collin County. Trend compares the current 3 months with the prior 7 to 12 months; a change inside ±3% reads as stable.
MeasurePrior 7 to 12 monthsPrior 4 to 6 monthsCurrent 3 monthsTrend
Comparable sales7,8795,1494,208Declining
Absorption rate (sales per month)1,3131,7161,403Increasing
Active listings5,9237,1776,484Increasing
Months of supply4.54.24.6Stable
Median sale price$434,000$465,000$450,000Increasing
Median days on market503240Declining
Median sale price as % of list97.8%98.3%98.0%Stable

Read alone, the grid says the sales pace, active listings and prices are increasing, supply is stable, and days on market are falling. The three periods also cover different seasons. The prior 7 to 12 months run from October 2025 through early April 2026, including the slowest months for closings. The current 3 months run from July to early October, after the spring peak. Part of each trend in the right-hand column reflects the season.

The chapters below analyze the same data by month and by segment, and list the rules behind each figure. Each chart is drawn from figures the monitor calculated; none was estimated for illustration.

02 / The buildFrom exports to a monitor

The data

20 exports, 61,104 listings, written rules

The Collin County Market Monitor was built with an AI assistant from 20 MLS exports covering residential listings with activity from October 7, 2024 to October 5, 2026. The build reads every status: closed, active, pending, cancelled, expired, withdrawn and hold. Every figure recalculates when a reader filters by city, ZIP, property type, price band, or resale against new construction.

  1. 20MLS export files
  2. 65,735rows across the files
  3. 61,104listings after deduplication
  4. 34,295closed sales in two 364-day windows
  5. 23charts, plus 5 tables, in the monitor

The monitor has eight sections: a written market read with headline figures, the 1004MC grid, supply and demand, pricing, listing outcomes, distress and concessions, a breakdown by segment, and properties that sold twice. A method section states each definition. Chapter 09 lists the rules that required a decision, because those decisions are where an appraiser’s judgment enters an AI-built analysis.

03 / SupplyListings, contracts and closings

Supply and demand

1.56 new listings for every closed sale

Monthly new listings, new contracts and closed salesOctober 2024 to September 2026. October 2024 closings are a partial month and are left off.
08001,6002,4003,200Oct 24Jan 25Apr 25Jul 25Oct 25Jan 26Apr 26Jul 26
New listingsNew contractsClosed sales
New listings

From October 2025 to September 2026, sellers listed 27,008 homes in Collin County. Listings rose in both springs and fell in both Novembers and Decembers.

Closed sales

Over the same twelve months, 17,316 sales closed: 1.56 new listings for every sale.

New contracts

Contracts led closings by about two months. They peaked in April 2026 at 1,769; closings peaked in June 2026 at 1,838.

The gap

The shaded gap between listings and sales is what builds inventory each spring. Active listings peaked at 7,528 in July 2025 and 7,384 in July 2026.

Active listings at month end6,484 on October 5, 2026, against 6,978 a year earlier (−7.1%).
02,0004,0006,0008,000Oct 24Apr 25Oct 25Apr 26
Months of inventoryMonth-end actives divided by the trailing 3-month average of sales.
Seller’s marketBalancedBuyer’s market02468Oct 24Apr 25Oct 25Apr 26

Monthly months of inventory stayed between 3.8 and 4.8 from January 2025 through September 2026, close to the 4-month line the monitor uses between a seller’s market and a balanced one. On the headline measure, active listings on October 5 against the trailing 12-month sales pace, supply was 4.5 months, against 4.9 a year earlier. Median days on market at sale rose from 37 to 41, and median cumulative days on market across relistings rose from 47 to 51.

04 / PricingPrice, mix and ratios

Closed-sale prices

The median fell 6.3%, partly from a shift in what sold

Median sale price, last 12 months$445,000−6.3% from $474,990
Median price per square foot$194−4.9% from $204
Sale price to original list price95.2%−0.5 pts from 95.7%
Median sale price and median price per square foot, by month of closingTwo scales: price on the left, price per square foot on the right.
$400K$425K$450K$475K$500K$180$190$200$210Oct 24Jan 25Apr 25Jul 25Oct 25Jan 26Apr 26Jul 26$418,000, Dec 25
Median sale priceMedian $/sq ft (right scale)

A median sale price describes the homes that sold, and the mix of homes that sold changed. Sales under $500,000 were 59.4% of closings in the last 12 months, against 54.4% in the prior 12. Sales under $300,000 rose from 1,848 to 2,544, while sales from $500,000 to $750,000 fell from 5,162 to 4,540. Price per square foot fell less than the median, −4.9% against −6.3%, which is consistent with a shift toward smaller and lower-priced homes.

The monitor can separate those effects because it can filter. Chapter 07 shows the same figures by city, and the segment filters let an appraiser narrow to a subject’s ZIP, property type, price band and construction type before reading a trend.

Median sale-to-list ratiosSale price against the final list price, and against the original list price.
92%93%94%95%96%97%98%99%Oct 24Jan 25Apr 25Jul 25Oct 25Jan 26Apr 26Jul 26
Sale to final listSale to original list

The space between the two lines is the price cutting that happens before a sale. Buyers paid a median 98.0% of the final list price over the last 12 months and 95.2% of the original list price. The original-list ratio fell to 92.7% in December 2025 and recovered to about 96% in the spring. The share of sales closing above list price peaked at 14.6% in April 2025 and reached 13.2% in April 2026.

05 / Unsold listingsCancelled, expired and withdrawn

Listing outcomes

37% of listings that left the market did not sell

Closed-sale statistics leave out listings that did not sell. The monitor counts them: 10,280 listings were cancelled, expired or withdrawn in the last 12 months, against 8,588 in the prior 12. As a share of every listing that sold or left the market, that is 37.4%, up from 33.4%.

Listings that left the market without selling, by month, with the failed-listing rateBars count listings by status change date. The line is unsold exits divided by unsold exits plus closed sales.
03006009001,2000%20%40%60%Oct 24Jan 25Apr 25Jul 25Oct 25Jan 26Apr 26Jul 26
CancelledExpiredWithdrawn or holdFailed-listing rate (right scale)

The rate peaked at 48.4% in January 2026 and reached 45.8% in September 2026, its highest reading outside winter. Withdrawals rose from a handful a month to 122 in September 2026. The MLS added Hold and Withdrawn as separate statuses during the period, so that line reflects a change in how the MLS records listings as well as seller behavior.

57% of listings that sold or left the market had at least one price reduction, against 56% a year earlier. The median reduction on those listings ran between 4.3% and 5.8% of the original list price month to month.

06 / New buildsResale against new construction

Two markets in one county

New builds sold for less, with larger concessions and fewer failed listings

New construction was 37% of Collin County closings in the last 12 months. The monitor identifies it from the Builder flag in Special Listing Conditions. Combined, the two segments blur each other’s trends.

ResaleLast 12 monthsNew build
10,776Closed sales6,416
$499,000Median sale price$370,000
$208Median $/sq ft$168
96.2%Sale to original list92.8%
35Median days on market55
51%Sales with seller concessions81%
45%Failed-listing rate18%
20%Cash purchases10%

New homes closed at a median 92.8% of original list price against 96.2% for resales, and 81% of new-home sales carried seller-paid concessions against 51% of resales. The failed-listing rate for new construction was 18%, against 45% for resales. Across all sales, the median concession was about 2% of the price in most months, and the share of sales with concessions rose from 58% to 62%.

For a resale subject in a ZIP with heavy new construction, a county-wide concession rate overstates what resale sellers paid, and the monitor’s construction filter reports the two separately.

07 / Seventeen marketsCity by city

Location

Plano and Celina: the same median price, different markets

Plano and Celina each had a median sale price of $505,000 over the last 12 months. Plano had 3.2 months of supply, a median 28 days on market, and sales at 96.5% of original list price. Celina had 7.2 months of supply, 65 days on market, and 91.4% of original list. Celina’s median price was down 14.3% from the prior year, and 66% of its sales were new construction, against 4% in Plano.

The chart below places each city with at least 150 sales in the last 12 months by months of supply and the change in its median price. Select a city to read its figures.

McKinney

Seller’s market
Median sale price
$494,006−1.2%
Months of supply
3.94.4 a year ago
Closed sales
3,342−4.5%
Days on market
3837 a year ago
Sale to original list
95.3%−0.4 pts
Failed-listing rate
37%+3.8 pts
New construction share
30%of sales
Median $/sq ft
$206−2.4%
Median sale price by month, October 2024 to September 2026

Princeton had the lowest median of the large cities at $299,990, with 83% of its sales in new construction and 3.1 months of supply. City figures are for the part of each city inside Collin County, as the MLS reports it. A city with a few hundred sales can move several points on a handful of closings, which is why the monitor grays out any row with fewer than 25 sales.

Months of supply by price bandActive listings on October 5, 2026 against the trailing 12-month sales pace. The ghost bar is a year earlier.
  1. Under $300K3.4
  2. $300K to $400K3.8
  3. $400K to $500K4.5
  4. $500K to $750K4.8
  5. $750K to $1M5.8
  6. $1M to $2M6.6
  7. $2M+11.6

Supply rises with price. Homes under $300,000 had 3.4 months of supply, down from 4.6. Homes over $2 million had 11.6, up from 9.3.

08 / Sold twiceRepeat sales inside the window

Investor activity

194 value-add flips in two years

The monitor matched 417 properties that closed twice between October 2024 and October 2026 and sorted each pair by what happened between the sales. A gain of 15% or more is a value-add flip. A first sale by a builder, or a jump in year built or living area, gets its own class. The resale pairs carry addresses in the monitor; this article reports only the totals.

  1. Day 0Bought$380,000median purchase; 69% paid cash
  2. Day 98Back on the marketmedian time from purchase to relist; 85% of listings mention a renovation
  3. Day 171Resold$575,000median resale, a median gain of 48%
Where the flips wereTop ZIP codes by count of value-add flips
  1. 75023 Plano29
  2. 75075 Plano26
  3. 75252 Dallas16
  4. 75093 Plano14
  5. 75002 Allen12
  6. 75074 Plano11
  7. 75025 Plano10
  8. 75072 McKinney10
What flippers boughtValue-add flips by decade built. Median year built 1983, median size 2,352 sq ft.
  1. Pre-19601
  2. 1960s12
  3. 1970s59
  4. 1980s58
  5. 1990s27
  6. 2000s28
  7. 2010s6
  8. 2020s3

Flips clustered in older Plano, Allen, McKinney and the Collin County part of Dallas, in homes built in the 1970s and 1980s. Not every repeat sale gained: 137 pairs resold within 5% of the purchase price or at a loss, with a median change of −0.6%, and 43 homes first sold by a builder resold at a median −3.4%. Another 501 homes bought in the window were back on the market and not yet resold on October 5.

For a lender reviewing a renovation loan, or an appraiser supporting an after-repair value, these pairs are a local record of what renovated homes in the same ZIP resold for and how long the work took. The 194 pairs are a sample, and each one still needs to be verified before it is used as a comparable.

09 / The checksDecisions inside the method

The appraiser’s part

Eight decisions the build needed someone to make

An AI assistant can write the code that reads the exports and draws the charts. The method still contains choices that change the numbers, and each one has to be made by someone who knows the MLS and the assignment, then recorded. These are the eight in this monitor.

  1. 01

    Duplicates

    The 20 exports overlap. 65,735 rows were deduplicated on MLS number to 61,104 listings.

  2. 02

    Placeholder prices

    Three listings with a list price under $20,000 or over $50 million were removed.

  3. 03

    Keying errors

    Nine closings with a sale-to-list ratio outside 50% to 150%, such as a $5,999 close, stay in the counts and are left out of price and ratio medians.

  4. 04

    Partial month

    Closings in the export start October 7, 2024, so October 2024 is left off every closing-based line, and both year-over-year windows are 364 days long.

  5. 05

    Status vocabulary

    In this data the MLS shows Hold from August 2025 and Withdrawn from November 2025. The two are combined, and the rise in withdrawals is read with that change in mind.

  6. 06

    Inventory definition

    Active, Active Contingent and Active KO count as active; Coming Soon does not. The October 5, 2026 count matches the export exactly: 6,484.

  7. 07

    Resale matching

    Repeat sales are matched on street number, street name, unit and ZIP. Parcel numbers were tested and rejected as the key because builders reuse master parcels across lots.

  8. 08

    Coverage

    MLS-listed activity only. Off-market and for-sale-by-owner transactions are not in the data.

Advisory Opinion 41, adopted April 23, 2026, treats tool output as an input to the appraiser’s analysis. The appraiser evaluates the tool, the data it relies on, and the output, and output that supports an opinion belongs in the workfile. We covered AO-41 in The 2.2% number. For a build like this one, that means checking the method against the MLS rules, spot-checking figures against the source export (the active count above matches it exactly), and keeping the export, the code and the method notes with the assignment.

MLS data comes with license terms. Check what your MLS allows before putting an export into an AI tool, and before showing MLS-derived figures to a client.

10 / For the clientWhat an end user could receive

The deliverable

What a client-facing market addendum could include

A lender, an AMC reviewer or a borrower reading an appraisal sees the market conclusion and the support the appraiser chose to include. An AI-built monitor changes how much support is practical to include. Three parts of this one could go to a client as an addendum or a link.

Segment view

The subject’s market, filtered

The grid, charts and ratios recalculated for the subject’s city or ZIP, property type, price band and construction type, with the segment and its sample size stated.

  • Example: Plano, last 12 months
  • 2,416 closed sales
  • 3.2 months of supply
  • 96.5% of original list
Written read

A narrative generated from the figures

Over the last 12 months, all of Collin County recorded 17,192 closed sales, up 0.5% from 17,103 in the prior 12 months. The median sale price was $445,000 (−6.3% year over year) and the median price per square foot was $194 (−4.9%).

On Oct 5, 2026 there were 6,484 active listings, down 7.1% from 6,978 a year earlier, and 1,307 listings under contract. At the trailing 12-month sales pace that is 4.5 months of supply, against 4.9 a year ago.

Reproduced from the monitor’s county read. The wording is fixed; the numbers fill in from whatever filters are set.
Method

Definitions a reviewer can test

Every measure defined, every exclusion counted, and the data source and coverage stated, so a reviewer can reproduce a figure or question a choice.

  • 12 definitions
  • 8 recorded decisions
  • 1 MLS as the data source

The written read matters because it is deterministic. The monitor fills a fixed sentence template from calculated figures, so the narrative cannot state a number the data does not contain. Asking a chatbot to describe a market from memory carries the risk we covered in AI hallucinations: what has improved, and what has not.

The market conclusion stays with the appraiser. With a monitor like this attached, a client can see the analysis behind that conclusion, and a reviewer’s question about a narrower segment can be answered by setting a filter.

Building something similar?

Using AI for market analysis in your own assignments?Tell us what data you start from, how you check the output, and what your clients have said about it.

Source: MLS exports, Collin County, residential property type, 20 files deduplicated on MLS number, data as of October 5, 2026. Last 12 months is October 7, 2025 to October 5, 2026; the prior 12 months is October 8, 2024 to October 6, 2025. Figures describe MLS-listed activity only. This article reports aggregates and publishes no address or individual sale. It is general information, not appraisal, legal or compliance advice.

The Signal / Monthly briefing

Track AI in appraisal, with sources.

One sourced briefing in the first week of each month.

Unsubscribe in one click. We don't sell your email or share it with sponsors. Privacy Policy

Found this useful? Share it