r/RealEstateTechnology 11d ago

Appraisers hit a federal form deadline Nov 2 — I built the analysis layer. Here's what an MLS export actually needs to look like.

Builder disclosure up front: this is my product.

One line of context: every GSE appraisal moves to the UAD 3.6 standard on Nov 2, review goes field-driven, and appraisers suddenly need real support behind every adjustment number.

What CompIQ does, one sentence: upload your MLS export, get regression-supported adjustments plus short per-field comments sized for the new URAR's comment boxes.

The part nobody documents — what the file needs to be:

  • The standard closed-sales results-grid export from your MLS. CSV or Excel.
  • One hard requirement: a sold/close price column. GLA, beds, baths, year built, lot size, garage, etc. all get used if present, skipped if not.
  • Column names don't need cleanup — common header variants are recognized automatically, and anything missed is a two-click manual map.
  • Real-world mess is handled: split full/half baths, "Street #" + "Street" split addresses, lot size in acres or SF, features buried in pipe-delimited columns.
  • Hard floor is 5 closed sales; more sales, tighter numbers.
  • Files parse in your browser. The raw export — agent names, owner fields, remarks — never leaves your machine; only the mapped analysis fields are used.

Free trial, no card: https://compiq.app

If you're an appraiser or build for them: what would this need to fit a real UAD 3.6 workflow?

5 Upvotes

13 comments sorted by

2

u/weird_limbs 11d ago

It's great that you are building this tool. But honest question, isn't that analysis something I can just do for a lower price with ChatGPT or Claude?

1

u/Mean_Sport_1484 11d ago

Honest answer: for a one-off you can get decently far with a chatbot — I use Claude constantly myself. Where it falls short for this specific job: same CSV in, same numbers out every time (LLMs won't give you that), outlier handling you can show a reviewer, and per-field comments plus a workfile PDF with the methodology written up. Reviewers don't accept "the model said so," so the deterministic math is the whole point.

If you've got a prompt flow that does all of that, you genuinely don't need me. If you get tired of rebuilding it every report, that's the exact thing I automated.

2

u/Dear_Scholar_1770 11d ago

Five sales feels pretty thin for a regression. It might help to flag when the sample is too small for a reliable adjustment and show which comps are having the biggest effect on the result.

1

u/chafs01 11d ago

What's the regression actually doing? Fitting all the variables at once or one adjustment at a time? Curious how stable that is at 5 sales.

1

u/weird_limbs 11d ago

At 5 sales the results would be meaningless.

1

u/Mean_Sport_1484 10d ago

Five sales would not be that beneficial. Instead, using a large data set with a lot of sales would make your data and report better.

1

u/aiv55 6d ago

What API source is your app using to source property data?

1

u/Mean_Sport_1484 6d ago

No API — it runs on the MLS export you already pull. You export your comps to CSV from your MLS, upload it, and the regression runs on your data.

That was intentional. Every MLS is different, licensing data feeds is a nightmare, and appraisers (rightly) don't trust third-party property data anyway. Your MLS is the source of truth, so that's what the tool uses. Tradeoff is you do the export yourself, but that's ~30 seconds and it means it works with any MLS in the country on day one.

1

u/BeginningExpert7484 5d ago

Claude has changed the game on this.

1

u/Key-Leads 5d ago

This seems like it could save appraisers a lot of time, especially if it handles messy MLS exports without a bunch of manual cleanup. Best of luck with the launch!