Real Estate Actual Price

Personal Taiwan real estate transaction price lookup MVP. The Web/PWA and MCP tools share the same SQLite database and query logic, and no OpenAI API key is required.

Phase 1 Features

• Import official real estate transaction CSV ZIP files from the Ministry of the Interior's Department of Land Administration (current period or historical quarters)

• Search by address, administrative district, and community/building text recognizable within the address

• Display transaction date, unit price, total price, floor area (ping), floor level, building age, and building type

• Calculate counts, median unit price, average, highest, lowest, and monthly trends for the past 1 year / 3 years

• Provide search_transactions, get_market_stats, list_areas, get_data_status MCP tools

• Mobile-friendly responsive Web/PWA

Local Startup on Windows

Use Python 3.11–3.14; the following commands will use the Python version currently working on this computer.

python -m venv .venv
.\.venv\Scripts\Activate.ps1
python -m pip install -e ".[dev]"
python scripts\sync_data.py --current
python web.py

Browse to http://127.0.0.1:5000. The first sync imports only the current period data; if you need complete three-year statistics, also import the last 12 completed quarters, for example:

python scripts\sync_data.py --season 112S3 --season 112S4 --season 113S1 --season 113S2 --season 113S3 --season 113S4 --season 114S1 --season 114S2 --season 114S3 --season 114S4 --season 115S1 --season 115S2

You can also import only specific counties/cities to shorten the time:

python scripts\sync_data.py --current --city 臺北市 --city 新北市

Repeated imports will update based on the official case number and will not accumulate duplicates.

Render Public PWA (Six Special Municipalities Demo Version)

The repository includes render.yaml and Dockerfile. After creating a Web Service on Render and connecting this repository, choose the Free plan; during build, it will download and import the current official data for Taipei City, New Taipei City, Taoyuan City, Taichung City, Tainan City, and Kaohsiung City. Once complete, Render will provide an HTTPS URL that can be opened from a mobile phone and installed as a PWA.

Render's free service sleeps after 15 minutes of inactivity, and the first reopening takes about one minute; each redeployment re-downloads the six municipalities' data. This public demo version does not provide an MCP endpoint; MCP and the full local database remain for personal computer use.

MCP Server

python mcp_server.py

By default, it provides http://127.0.0.1:8001/mcp via Streamable HTTP. You can first check it with MCP Inspector:

npx @modelcontextprotocol/inspector@latest

ChatGPT developer mode cannot connect directly to a general localhost; according to OpenAI's official documentation, personal local testing should use Secure MCP Tunnel, or deploy /mcp to a publicly accessible HTTPS endpoint. Phase 1 does not include public deployment and verification.

Testing

python -m pytest

Data Sources and Limitations

The main data source is the Ministry of the Interior's Department of Land Administration "Actual Information on Real Estate Transaction Cases" Open Data. Current static data is usually published on the 1st, 11th, and 21st of each month; the dynamic query website may be more recent. The data is declared and de-identified content; addresses may only go down to road section, number range, or land lot number. Existing completed building data has no reliable, unified community name field, so community/building name search uses text matching against addresses and remarks, which may miss results or incorrectly match same-name entries. Building age is estimated from the available building completion year/month; when missing, it is shown as unknown. Unit price is converted from the official per-square-meter field to per-ping; when parking spaces or special transactions are included, the remarks should still be read, and this should not be regarded as appraisal or investment advice.

Official sources:

• https://data.gov.tw/dataset/25119

• https://plvr.land.moi.gov.tw/DownloadOpenData