Hand-picked comparables to a defensible actual cash value, with the branded Excel appraisers share.
How does an appraiser band a vehicle and back every adjustment with market data?
Ask Claude or ChatGPT for the market band on the vehicle you are appraising and get it from monthly statistics on cars that left US dealer websites, with the priced sample behind every figure. The questions below show the prompts in order, from the band to each adjustment, and the result each one returned.
Free to add. ChatGPT works on Free accounts too, with no Developer Mode.
Using a coding agent? One line:Set up MarketCheck AI Desk: https://ai.marketcheck.com/llms.txt
Last updated , from the Aug 2026 data month. Every price is the advertised asking price when the car left the dealer's website, never what it sold for.
What is the market band for this exact vehicle, and does the mileage-matched national band agree?
In Aug 2026, 2022 Honda CR-V EXs in California listed at a $25,627 median, and nationally, at 40,000 to 60,000 miles, between $25,786 and $27,584. Rank the model year's trims in your state with the low end and high end, then pull the subject trim nationally inside its mileage band.
- Prompt
For 2022 Honda CR-Vs that sold in California in August 2026, show the three best-selling trims with the low end, median and high end asking price and the median odometer.
What came back · Aug '26
$3.00 per call (1 call unit)
What came back: Band the trims in your state, Aug '26 Trim Units sold Priced sales Low end asking price Median asking price High end asking price Median odometer Thin sample EX 49 48 $23,996 $25,627 $27,089 46,605 No EX-L 38 37 $25,998 $27,799 $29,127 41,589 No Touring 19 19 $27,239 $29,998 $32,485 50,513 Yes What to do with it: The EX listed between $23,996 and $27,089 (median $25,627) on 48 priced sales, $2,172 below the EX-L.
- Follow-up prompt, in the same chat
Now the 2022 CR-V EX nationally, only cars with 40,000 to 60,000 miles like my subject: low end, median and high end.
What came back
$3.00 per call (1 call unit)
What came back: Check the subject's mileage band nationally Month Units sold Priced sales Low end asking price Median asking price High end asking price Median odometer Thin sample Aug '26 122 115 $25,786 $26,898 $27,584 49,320 No What to do with it: Nationally, 115 priced sales at 40,000 to 60,000 miles put the median at $26,898, $1,271 above the California median at a similar odometer (49,320 miles against 46,605 miles). Use that gap as the location adjustment and cite both samples.
Start this inClaude (new tab, the first prompt copied)orChatGPT (new tab, the first prompt copied)and paste the next prompts in the same chat.
How much does mileage change the asking price of the same vehicle?
About $750 for every 10,000 miles on a 2021 Toyota Camry SE in Aug 2026: nationally it listed at a $24,435 median at 30,000 to 50,000 miles, $22,978 at 50,000 to 70,000 and $21,581 at 70,000 to 90,000. Band one model year and trim by mileage and read the gaps.
- Prompt
For used 2021 Toyota Camry SEs that sold nationally in August 2026 with 30,000 to 50,000 miles, what were the low end, median and high end asking prices?
What came back
$3.00 per call (1 call unit)
What came back: Band 30,000 to 50,000 miles Month Units sold Priced sales Low end asking price Median asking price High end asking price Median odometer Aug '26 66 63 $23,639 $24,435 $24,999 42,521 What to do with it: 63 priced sales put the band at $23,639 to $24,999 around a $24,435 median at 42,521 miles.
- Follow-up prompt, in the same chat
Now the same car with 50,000 to 70,000 miles.
What came back
$3.00 per call (1 call unit)
What came back: Band 50,000 to 70,000 miles Month Units sold Priced sales Low end asking price Median asking price High end asking price Median odometer Aug '26 125 119 $21,616 $22,978 $23,825 60,162 What to do with it: At 60,162 miles the median was $22,978 on 119 priced sales, $1,457 below the lower band: about $830 for every 10,000 miles.
- Follow-up prompt, in the same chat
And with 70,000 to 90,000 miles.
What came back
$3.00 per call (1 call unit)
What came back: Band 70,000 to 90,000 miles Month Units sold Priced sales Low end asking price Median asking price High end asking price Median odometer Aug '26 158 146 $19,996 $21,581 $22,286 80,695 What to do with it: At 80,695 miles the median was $21,581, about $680 for every 10,000 miles past the middle band against $830 before it; apply the rate from the band your subject sits in.
Start this inClaude (new tab, the first prompt copied)orChatGPT (new tab, the first prompt copied)and paste the next prompts in the same chat.
How much does 4WD add to the asking price, and does it change by state?
In Aug 2026, 4WD 2020 to 2022 Toyota Tacomas listed $5,798 above rear-wheel drive in North Carolina and $4,338 above in Florida, where rear-wheel drive made up 66.1 percent of sales. Rank the model by drivetrain, with the low end and high end, in each state you appraise in.
- Prompt
For 2020 to 2022 Toyota Tacomas that sold in North Carolina in August 2026, compare 4WD and rear-wheel drive: low end, median and high end asking price and the median odometer.
What came back · Aug '26
$3.00 per call (1 call unit)
What came back: Split the model by drivetrain, Aug '26 Drivetrain Units sold Priced sales Low end asking price Median asking price High end asking price Median odometer 4WD 152 147 $32,069 $34,796 $37,793 64,569 RWD 89 87 $26,256 $28,998 $31,790 67,542 What to do with it: 4WD listed at a $34,796 median against $28,998 for rear-wheel drive, a $5,798 premium, with 2,974 fewer miles on the median 4WD odometer. Adjust for the mileage first, then for the drivetrain.
- Follow-up prompt, in the same chat
Now run the same comparison for Florida.
What came back · Aug '26
$3.00 per call (1 call unit)
What came back: Repeat it in a second state, Aug '26 Drivetrain Units sold Priced sales Low end asking price Median asking price High end asking price Median odometer RWD 285 270 $26,019 $29,172 $32,037 57,990 4WD 144 136 $30,999 $33,510 $37,250 59,798 All 2 rows · the call returned 3
What to do with it: Florida's 4WD premium was $4,338 against $5,798 in North Carolina, and rear-wheel drive made up 66.1 percent of Florida sales against 36.9 percent, so use each state's own premium.
Start this inClaude (new tab, the first prompt copied)orChatGPT (new tab, the first prompt copied)and paste the next prompts in the same chat.
Does a manual transmission add or take away value?
It depends on the model: in Aug 2026, a manual moved the median asking price of a 2018 to 2022 Toyota Tacoma TRD Off Road at 40,000 to 80,000 miles up $778, and a Jeep Wrangler Unlimited Rubicon's down $1,723. Split the exact model by transmission before you adjust.
- Prompt
For 2018 to 2022 Toyota Tacoma TRD Off Roads that sold nationally in August 2026 with 40,000 to 80,000 miles, compare manual and automatic: low end, median and high end asking price.
What came back · Aug '26
$3.00 per call (1 call unit)
What came back: Split a pickup by transmission, Aug '26 Transmission Units sold Priced sales Low end asking price Median asking price High end asking price Median odometer Automatic 852 827 $33,498 $35,368 $37,116 61,184 Manual 68 64 $34,781 $36,146 $37,998 64,018 What to do with it: The manual listed at a $36,146 median against $35,368 for the automatic, $778 more on 64 priced manual sales, with 2,834 more miles on its median odometer, so the premium holds despite the higher odometer.
- Follow-up prompt, in the same chat
Now the same comparison for 2018 to 2022 Jeep Wrangler Unlimited Rubicons, any mileage.
What came back · Aug '26
$3.00 per call (1 call unit)
What came back: Repeat it on an off-roader, Aug '26 Transmission Units sold Priced sales Low end asking price Median asking price High end asking price Median odometer Automatic 1,267 1,205 $28,987 $32,218 $34,995 56,403 Manual 57 56 $28,900 $30,495 $33,149 64,641 What to do with it: On the Wrangler Unlimited Rubicon the manual listed $1,723 below the automatic ($30,495 against $32,218) on 56 priced manual sales: whether a manual adds value depends on the model, so adjust model by model.
Start this inClaude (new tab, the first prompt copied)orChatGPT (new tab, the first prompt copied)and paste the next prompts in the same chat.
How much has the market moved since my comparable sold, with mileage held steady?
For the 2022 Nissan Rogue SV, the national median fell 12 percent from Sep 2025 to Aug 2026, but fell 5.2 percent at 40,000 to 60,000 miles: most of the raw move was odometer mix. Read 12 months of the model year and trim, repeat it inside your subject's mileage band, and time-adjust from the banded series.
- Prompt
Show the 2022 Nissan Rogue SV nationally, month by month for the 12 months to August 2026: median asking price, median odometer and sales.
What came back
$3.00 per call (1 call unit)
What came back: Read the raw 12-month series Month Units sold Priced sales Median asking price Median odometer Aug '26 606 574 $19,709 58,021 Jun '26 588 537 $20,128 56,415 Apr '26 631 578 $19,919 53,061 Feb '26 813 773 $19,988 45,600 Dec '25 921 887 $20,900 37,706 Oct '25 879 820 $21,990 36,492 Sep '25 876 814 $22,388 38,244 5 of 7 rows · the call returned 12
What to do with it: The median asking price fell 12 percent ($22,388 in Sep 2025 to $19,709 in Aug 2026) while the median odometer went from 38,244 to 58,021 miles: part of that move comes from the mileage mix.
- Follow-up prompt, in the same chat
Now the same 12 months, only cars with 40,000 to 60,000 miles.
What came back
$3.00 per call (1 call unit)
What came back: Hold the mileage band steady Month Units sold Priced sales Median asking price Median odometer Aug '26 189 178 $20,385 49,929 Jun '26 175 167 $20,991 49,319 Apr '26 177 163 $20,262 49,890 Feb '26 256 248 $19,971 49,155 Dec '25 237 233 $19,990 49,155 Oct '25 204 192 $20,991 49,710 Sep '25 251 235 $21,499 48,023 5 of 7 rows · the call returned 12
What to do with it: Held to 40,000 to 60,000 miles, the median fell 5.2 percent ($21,499 to $20,385) against 12 percent unbanded. Time-adjust an older comp with this banded series, month by month.
Start this inClaude (new tab, the first prompt copied)orChatGPT (new tab, the first prompt copied)and paste the next prompts in the same chat.
How do I band a low-volume vehicle when local sales are thin?
Widen the sample until it clears 30 priced sales, keeping the mileage. In Aug 2026, Tennessee had 13 priced 2021 Lexus GX sales; nationally, at 60,000 to 80,000 miles, 72 priced sales gave a $39,997 to $44,597 band around a $42,130 median. Cite the wider band and say why you widened it.
- Prompt
What were used 2021 Lexus GXs listed at when they sold in Tennessee in August 2026? Give the low end, median and high end.
What came back
$3.00 per call (1 call unit)
What came back: Ask for the subject's state Month State Units sold Priced sales Low end asking price Median asking price High end asking price Median odometer Thin sample Aug '26 TN 13 13 $39,550 $42,998 $44,588 62,471 Yes What to do with it: Tennessee had 13 priced sales, so the row is marked thin: use it as a direction only, and widen it before you quote a number.
- Follow-up prompt, in the same chat
Widen it to the whole country, only cars with 60,000 to 80,000 miles like my subject.
What came back
$3.00 per call (1 call unit)
What came back: Widen to the nation at the same mileage Month Units sold Priced sales Low end asking price Median asking price High end asking price Median odometer Thin sample Aug '26 74 72 $39,997 $42,130 $44,597 67,719 No What to do with it: Nationally, 72 priced sales at 60,000 to 80,000 miles put the band at $39,997 to $44,597 around a $42,130 median; Tennessee's $42,998 median sits inside it, so cite the national band and note the state figure.
Start this inClaude (new tab, the first prompt copied)orChatGPT (new tab, the first prompt copied)and paste the next prompts in the same chat.
More questions
Can I cite these figures in an appraisal?
Yes, as dated market statistics. Each answer echoes the exact filters it applied, and each row states its month, area and priced sample. Present them as listing evidence: the asking price when comparable cars left dealer websites.
Does it show individual cars or VINs?
No. It returns statistics (units, median and mean asking price, odometer, days on market) grouped by model, year, trim, seller or group, never a VIN. Pair a band with named comparables from the recently sold search when the report needs individual vehicles.
How many sales back each figure?
Every row states its units sold and its priced sample, the sales with an asking price behind every price figure. A row on fewer than 30 priced sales is marked as a thin sample: read it as a direction only. Widen to a model-year range or a neighboring state, or pool several states into one row, until the sample clears 30.
What does a call cost?
$3.00 per call unit, paid from your prepaid balance and only after a successful call; a refused or failed call costs nothing. Every prompt on this page is 1 unit ($3.00), so all 13 prompts come to 13 units ($39.00).
How current is the data?
It is monthly, and each month lands one to two months after it ends, so date-stamp every figure with its data month. The examples on this page are from Aug 2026. It covers US dealers only, back to January 2021, at most 12 months per call.
How do I get started?
Add the MarketCheck AI Desk connector to Claude or ChatGPT; it is free to add, and ChatGPT works on Free accounts too. Then paste a prompt from this page or ask in your own words, and each call is charged to your prepaid balance only when it succeeds.
Reports that answer the same need
When you want the finished read, not the raw numbers.
One VIN in full depth: valuation with the comparable evidence behind it.
Post-repair loss in value, argued from comparables you pick, by 17c or by your own percentage.
Lowest advertised price of record for a VIN (single or batch), with source and timeline.
Use cases for other segments
Dealers and remarketing
- Used-car dealersFind the models that clear fastest in your state and the sellers that outsell you in your city, with the asking price for each.
- Dealership groupsRank your group against its rivals state by state, and find the markets that turn a franchise fastest before you bid.
- Auctions and remarketingSee where a model lists highest at retail, check run-list demand and buyers, set reserves on falling models and time a consignment.
- Wholesale buyers and exportersSet a bid from the retail asking price, and see who retails a model and where it lists lowest and highest.
- Fleet and rental remarketingTime the sale of late-model fleet units and pick the states and channel that list them highest, with what each 10,000 miles costs.
- Auto brokers and car-buying servicesSee which new cars and trims list furthest below sticker, and where the used car your client wants lists for less.
Claims and valuation
- Insurance adjustersDated evidence of what vehicles like the insured's were listed at when they sold, even in a thin state, and how the market moved since.
- Public adjustersShow a carrier where its total-loss offer sits in the market band, with the right trim, mileage, model year and state behind it.
- AttorneysDated, cited market statistics for a vehicle's value on a past date, and for overpricing, price-spike and odometer claims.
Shoppers, sellers and press
- Car shoppersKnow a fair asking price, whether the higher trim is worth it, where prices are heading and what sells fastest near you.
- Private sellersPrice your own car against what cars like it were listed at when they sold at dealers, and pick the month and mileage to sell.
- Automotive journalistsCite what sold, how used prices moved, the EV share, state gaps and seasonal patterns, with the sample size behind every figure.
What the tool returns, the price of every request shape and its limits: Sold Market Data. The reports built for independent appraisers: Appraiser Desk.
Ask your own sold-market questions
Connect once, then paste a prompt from this page or ask in your own words. A standard question is $3.00, charged to your prepaid balance only when the call succeeds.