# Changelog of Sold Prices Forensics — Cross-Border Comp Data API (`sian.agency/sold-prices-forensics-scraper`) Actor

- **URL**: https://apify.com/sian.agency/sold-prices-forensics-scraper/changelog.md
- **Full Actor documentation**: https://apify.com/sian.agency/sold-prices-forensics-scraper.md

## Changelog

All notable changes to Sold Prices Forensics — Cross-Border Comp Data API will be documented in this file.

### \[2026-07-03]

#### 🔧 Improvements

- **Instant try-it-out defaults** — the input form now prefills a real US subject property (`1875 AVONDALE Circle, Jacksonville, FL 32205`, Zillow), so a first run works out of the box. Starting the actor with an empty input performs the same small demo lookup instead of failing.

### \[2026-05-21]

#### 🎉 Sold Prices Forensics — Launch!

- **Cross-Border Sold Prices in One CSV** — pull historical sold-price comparables from Zillow (US), Rightmove (UK) and Zoopla (UK) in a single normalized dataset. The only multi-platform sold-prices actor on the Apify Store.
- **Per-Address Forensic Lookup** — `byAddress` mode returns the full sale history for a US or UK subject property, the dataset RICS surveyors and US appraisers build manually in a day.
- **UK Area Sweep for Comps** — `byArea` mode sweeps a UK neighbourhood, town or postcode (Hampstead, SW1A, Manchester) across Rightmove and Zoopla for comparable-sales evidence.
- **Repeat-Sale Rows Preserved** — properties with multiple historical sales emit one row per sale event, keyed by `sourceId + saleDate` — Case-Shiller-style repeat-sale analysis works out of the box.
- **Currency Declared Per Row** — every row tags `currency` (USD / GBP) and `country` (us / uk). No silent FX, no guessing — cross-border investors own the conversion step.
- **Normalized 20-Field Schema** — identical column shape across Zillow, Rightmove and Zoopla rows. No per-source parsers, no schema reconciliation.
- **Subject-Address Summary Row** — `byAddress` mode emits a joinable summary row per resolved address carrying property attributes (UPRN, ZPID, postcode, beds, baths, tenure).
- **Year-Range Filter** — `yearFrom` / `yearTo` bound the sale-year window cleanly across all three platforms in one filter.
- **Auto-Pagination on UK Area Sweeps** — drains Rightmove and Zoopla area feeds until exhausted, respecting `maxResults` and the FREE-tier safety net.
- **Cross-Platform Disambiguation** — the `sourcePlatform` column lets you filter to one source (e.g. Zoopla only) or keep cross-source rows for validation.

#### 💎 User Benefits

- **For appraisers and RICS surveyors**: replaces a day of manual Land Registry / portal scraping with a single run.
- **For mortgage underwriters and AVM teams**: drop-in CSV for comp packs and hedonic regression — no schema mapping work.
- **For cross-border investors**: London Hampstead vs. Brooklyn DUMBO in one dataset, native currency declared per row.
- **For data scientists**: bulk-friendly sold-price training data across three platforms with identical schema.
- **For insurance valuers and probate solicitors**: forensic per-address lookup for properties no longer listed.
- **Regulated-buyer pricing posture** — premium-tier BRONZE $0.012/row that passes procurement at appraisal firms and lenders.
- **FREE tier opportunity** — evaluate the full schema against your AVM or appraisal workflow with 25 rows per run, no credit card.

#### 🎯 Use Cases

- Mortgage underwriters generating 12-month comp packs for a subject property's neighbourhood (US or UK).
- RICS surveyors building Red Book appraisals with subject-property sale history + area comps in one run.
- Cross-border investors comparing 10-year sold-price velocity across US and UK markets.
- Data scientists training AVM models on multi-platform sold-price comparables with normalized features.
- Insurance valuers pulling historical sale data for reinstatement quotes on properties no longer listed.
- Probate solicitors documenting "last recorded sale" benchmarks for executor sale and damage-claim work.
- Property tax consultants assembling comp evidence packages for assessment appeals.
- Journalists and market researchers tracking neighbourhood-level price evolution and gentrification curves.

#### 🗺 Honest v1.0 Scope (Not Roadmap Vapor)

This v1.0 ships the three platforms where the upstream data path is **forensics-grade and reliable**:

- **Zillow** (US per-address sale history)
- **Rightmove** (UK area comparable-sales)
- **Zoopla** (UK per-address forensic + UK area comparable-sales)

Two platforms were deliberately **dropped from v1.0** rather than shipped half-broken:

- **Redfin** — the historical sold-prices data path returns redacted prices through this feed (the numeric price is replaced with a redaction marker), which makes the data unusable for valuation work. On the v1.1 backlog if the redaction lifts.
- **Idealista** (Spain / Italy / Portugal) — no unit-level historical-transactions endpoint exists; Spanish/Italian/Portuguese public records do not publish per-property sold prices through Idealista's data path. On the v1.1 backlog if a historical endpoint becomes available.

We chose to ship the honest version: three reliable platforms with one normalized schema, instead of a four- or five-platform actor where some sources silently degrade your downstream pipeline.

#### 🔭 v1.1 Backlog

- **Redfin coverage** — when the upstream restores numeric sold prices.
- **Idealista coverage (ES / IT / PT)** — when a historical-transactions endpoint becomes available.
- **Listing-price history** — Zoopla's parallel "asking price over time" series, kept separate from transaction prices.
- **Address normalization helpers** — optional libpostal-style normalization step for cross-country comp matching.