search_transactions
Search Polish real estate transactions from the national RCN registry (7M+ records).
Returns transaction details: address, date, price, area, price/m², property type.
Use list_locations first to find valid location names.
Example: search for apartments in Mokotów sold in 2024 above 500,000 PLN.
get_price_statistics
Get price per m² statistics by location for residential apartments in Poland.
Note: only covers residential units (lokale mieszkalne). For other property types, use search_transactions.
'Warszawa'/'Kraków'/'Łódź' auto-expand to all sub-districts (Warszawa=19, Kraków=5, Łódź=6). Other names use partial match.
get_price_distribution
Get price distribution histogram showing how many transactions fall into each price range.
Useful for understanding the overall market price structure in Poland.
search_by_area
Search real estate transactions within a geographic radius.
Provide latitude/longitude coordinates and a radius in km.
Example: find apartment sales within 2km of Warsaw's Palace of Culture (lat 52.2317, lng 21.0060).
Area filters (minArea/maxArea) work for all propertyType values via COALESCE(usable_area_m2, parcel_area).
get_market_overview
Get a comprehensive overview of the Polish real estate transaction database.
Returns: total transaction count, date range, breakdown by property type and market type, top locations, price statistics.
list_locations
List available locations (cities and districts) in the database.
Returns administrative districts - for most cities, the district name equals the city name.
For Warsaw: returns district names (Mokotów, Śródmieście, Wola, etc.), not 'Warszawa'.
For Kraków: returns sub-districts (Kraków-Podgórze, Kraków-Śródmieście, etc.).
Use the search parameter to filter by name.