Property Comps,
made simple.
The Andy Comps Engine is a four-step workflow that lets you find a property, configure comparable sales filters, review matched comps with AVM valuations, and drill into full public-record detail — all powered by the RealEstateAPI.
Login
The portal requires a login before you can access any data. Open the portal in your browser and you will be directed to the login screen automatically. Enter the email address and password provided to you by your administrator.
Quick Start
In under two minutes you can have a full comps report on screen:
- Sign in with your Andy account credentials.
- On the Search page, type at least 3 characters of the subject property address and select a full address from the dropdown.
- On the Filters page, optionally enter a Max radius (e.g. 1.5 miles) and Max results (up to 200). Leave everything else blank to use the defaults.
- Click Get Comps. The portal automatically advances to the Results page.
- Review the AVM estimate cards and the sortable comps table. Click any column header to sort.
- Click Get Details on any row to see the full property record, or click Subject Details to see the subject property's record.
- Click Export to Excel to download all results as a .csv file.
Search — Find a Property
The search step finds US properties by address as you type, using live autocomplete.
How it works
- Click inside the search box and start typing a street address. Results appear after you type 3 or more characters.
- A dropdown of matching full addresses appears. Partial or city-level matches are excluded — only complete property addresses are shown.
- Click a result, or use ↑ ↓ arrow keys to highlight and Enter to select. Press Escape to close without selecting.
- Once selected, the portal advances to Step 2 · Filters automatically.
Filters — Configure the Comp Search
All filters are optional. Leaving a field blank applies the default behaviour. Combine filters to tighten or loosen the comparable pool.
Search Scope & Recency
| Field | Type | Description |
|---|---|---|
| Max radius (miles) | Decimal | Geographic search radius around the subject property. E.g. 1.5. Accepted range: 0.1 – 100 miles. |
| Max days back | Integer | Only include sales that closed within this many calendar days. E.g. 90 for the last 3 months. |
| Max results | Integer | Number of comps to return. Default is 25. Maximum is 200. Enter 200 for the largest possible result set. |
| Arms-length only | Select | Filter to arms-length (market-rate) transactions only, non-arms-length only, or both. Default: Any. |
Same-as-Subject Match
These checkboxes restrict comps to properties that exactly match the subject on the chosen attribute. Use them to enforce strict comparability.
Range Filters (min / max)
Each range filter accepts an optional minimum, maximum, or both. Leave a side blank to apply no bound on that side.
| Field | Unit | Example use |
|---|---|---|
| Bedrooms | Count | Min 3 / Max 4 for 3–4 bed comps |
| Bathrooms | Count | Min 2 for at least 2 baths |
| Year built | Year | Min 1990 / Max 2010 |
| Living sq ft | Sq ft | Min 1200 / Max 2000 |
| Lot sq ft | Sq ft | Max 10000 to exclude large lots |
| Last sale price | USD $ | Min 50000 / Max 200000 |
| MLS listing price | USD $ | Filter to active listing price range |
Boosts (Similarity Weight)
Boosts control how heavily each attribute is weighted when ranking comps by similarity to the subject. Higher = that attribute matters more. Accepted range: 1 – 50.
Results — Review Comparable Sales
After clicking Get Comps, the portal fetches matched comparables and presents them in four AVM summary cards and a full sortable table.
AVM Summary Cards
AVM Estimate
The automated valuation model (AVM) estimate for the subject property, derived from the comps returned.
AVM Low / AVM High
The low and high ends of the AVM confidence range. A tighter spread indicates higher model confidence.
Comps Returned
Total number of comparable properties matched for the current filter set. Increase Max results to 200 and reduce filters to expand this number.
Subject Summary Bar
The green bar at the top of the Results page shows the subject property's key stats: beds, baths, living sq ft, year built, and estimated value. Two action buttons sit on the right:
Subject Details
Pulls the full public-record detail for the subject property and navigates to Step 4.
← Filters
Returns to Step 2 so you can adjust filters and re-run without losing the selected property.
The Comps Table
Every matched comp is displayed as a table row. Click any column header to sort ascending; click again to sort descending. An ▲ or ▼ indicator shows the active sort.
Results Column Guide
All columns that appear in the comps table, with their meanings:
| Column | Full name | Notes |
|---|---|---|
| Dist (mi) | Distance in miles | Straight-line distance from subject to comp. Sorted ascending by default. |
| Address | Street address | Full street address of the comp property. |
| Bd | Bedrooms | Number of bedrooms. |
| Ba | Bathrooms | Number of bathrooms. |
| SqFt | Living square feet | Gross living area in square feet. |
| Year | Year built | Original construction year. |
| Lot SqFt | Lot square footage | Total lot/parcel area in square feet. |
| Est. Value | Estimated value | AVM-estimated current market value of the comp property. |
| Equity | Estimated equity | Estimated value minus open mortgage balance. |
| Eq % | Equity percentage | Equity as a percentage of estimated value. |
| Last Sale | Last sale date | Date the comp most recently transferred title. |
| MLS Sold | MLS sold price | The recorded MLS sale price from the most recent transaction. |
| Owner | Owner name | Current owner of record (individual or company name). |
| Vac | Vacant | Green dot = property is recorded as vacant. |
| Abs | Absentee owner | Green dot = owner's mailing address differs from the property address. |
| Cash | Cash buyer | Green dot = most recent purchase was a cash transaction (no mortgage recorded). |
| Details | Get property detail | Fetches the full public-record profile for this comp. See Step 4. |
Property Detail — Full Public Record
The Detail page shows the complete public-record and valuation profile for a single property.
How to reach this page
From the Results table
Click the Get Details button at the end of any comp row. The detail page loads for that specific property.
Subject Details button
Click Subject Details in the subject bar on the Results page to pull detail for the original search property.
Data sections on the detail page
Overview
Address, property ID, type, use, owner-occupied flag, absentee status, vacancy, corporate ownership.
Valuation & Equity
Estimated value, equity, equity %, open mortgage balance, AVM estimate, high-equity flag.
Characteristics
Beds, baths, living sq ft, lot sq ft, year built, stories, garage, pool, heating, A/C.
Owner
Owner 1 & 2 names, length of ownership (months), mailing address.
Last Sale
Sale date, sale amount, document type, arms-length flag, buyer and seller names.
Tax & Lot
Tax year, assessed value, market value, APN, zoning, subdivision, census tract, land use.
Demographics
Median area income, suggested rent, HUD area name.
Raw Data
Each detail page includes a View raw response expandable section at the bottom — useful for finding fields not shown in the main UI.
Exporting to Excel
The Export to Excel button appears at the top-right of the Results card. It downloads a .csv file that opens directly in Microsoft Excel, Google Sheets, or any spreadsheet application.
What's included in the export
The export contains 22 columns per comp row — more than the on-screen table — including fields that are not displayed by default:
Filename
Files are automatically named andy-comps-{address}-{date}.csv — e.g. andy-comps-700-texas-ave-2026-06-12.csv.
Tips & Tricks
Getting more comps
- Set Max results to 200 — the maximum — to receive the largest result set possible.
- Increase Max radius if the area is rural or inventory is thin. Try 3 to 5 miles.
- Increase Max days back to 180 or 365 to include older sales in low-volume markets.
- Uncheck all Same-as-subject checkboxes to cast the widest net, then sort the results table by a relevant column.
Sorting & finding the best comps
- Sort by Dist (mi) (default) to see the geographically closest comps first.
- Sort by Last Sale date descending to surface the most recent transactions at the top.
- Sort by SqFt to quickly find comps closest in size to the subject.
- Sort by MLS Sold to compare against listed/sold prices.
Navigating between steps
Troubleshooting
| Problem | Likely cause | Fix |
|---|---|---|
| AutoComplete returns no results | Address not found or too short | Type at least the house number and first few letters of the street name. Try a simpler version of the address (no unit numbers). |
| Comps returns 0 results | Filters too restrictive, or no sales in the area | Clear all filters with Reset filters, increase radius and days back, and retry. |
| AVM shows "—" values | Not enough comps for the model to produce an estimate | Broaden the search area and recency window, or remove Same-as-subject constraints. |
| Property Detail shows an error | Comp has no resolvable ID or address | Try a different comp row. Some records in the comps list may lack the detail data required by the detail endpoint. |
| Export file opens garbled in Excel | Encoding issue (rare on Windows) | In Excel, use Data → From Text/CSV and select UTF-8 encoding when importing. |
| Logged out after refresh | Session storage cleared (private/incognito tab, or browser cleared session) | Log in again. Session storage does not persist across browser restarts in some configurations. |