Analysis of bid and actual prices in Sedlcany

This work deals with the analysis and assessment of the offer and actual prices of housing units in the town of Sedlcany. This city is located in the Central Bohemia region, in the Pribram district. The subject of the analysis is the monitored period of two years, from December 2020 to November 2022. The analysis is supported by data from the real estate portals Sreality.cz and Reas.cz, where the offer and actual prices are found, which are entered in the real estate cadastre in purchase contracts. Furthermore, the analysis is based on a local investigation and information from the public portal of the Czech Statistical Office, the Land Registry and the website of the city of Sedlcany, more specifically on their flood plan. Within the monitored period, there are a total of 46 bid advertisements at an average price of 53,619 CZK per 1 square meter. For actual prices, 53 price data are calculated with an average purchase price of CZK 47,884 per 1 square meter. The total average prices differ, but also their development, for which a regression function is always created. Due to the development of the number of offers and their prices, also due to the presence of new housing units among older properties, the reliability value of the offer price model is very low. A higher reliability value can be observed for real prices, where the impact of housing units from the newly completed construction of an apartment building can again be seen. The goal of the work is achieved through an overall analysis and assessment with the conclusions that new buildings have a large impact on prices. The subject of further research will be adding information to the overall context of the issue.