Case study

Funda Data: Two Years of Monthly Home Sales by Franchise Territory

A marketing agency works for a real-estate franchise network whose branches each cover a set of postcodes. Every month the agency analyses one list: the homes sold in the previous month inside each branch's territory, with address, postcode, town and price. The list has to cover every branch and arrive on a fixed day.

The work started with Belgium on Immoweb. The client defined a sale simply: a for-sale listing that has left the portal during the month. Funda was added on the same terms two months later, and for more than a year and a half the project has run on Funda alone.

Funda Data: Two Years of Monthly Home Sales by Franchise Territory

How a sale shows up in Funda data

Each month starts from a full snapshot of every for-sale listing, and anything newly listed during the month is added to it day by day. Any property from that month-old set that is missing from a fresh full snapshot before delivery goes into the file as sold.

The daily additions matter: a home listed on the 5th and gone by the 25th appears in neither monthly snapshot. It also explains the first file. A sale can only be detected against an earlier snapshot, so the first Belgian file covered a partial month and held 19,000 properties.

From postcode to branch, one tab per territory

Each branch owns a list of postcodes supplied by the client. We match every sold home to its branch and write each branch to its own Excel tab, sorted by price from high to low. A branch the client added on a Thursday was in the following Monday's file. When the network redrew its branch map, the next file followed the new map.

The file follows the client's rules on what counts. Addresses are split into street and house number, postcode and town. Homes built in 2024 or later are excluded as new builds, and so are listings with no construction year. The same house can sit on a portal under more than one link, so duplicates are removed on street address plus postcode, not on the URL.

Funda data on the first Monday of every month

Funda has changed its pages more than once since the project began. We handle that on our side: records keep the same shape, so the client's Excel file and its tabs stay the same from month to month. Each month's file goes out on the first Monday of the next month.

What the client has now

The agency receives its sold-homes file on a monthly schedule, by FTP and email: Belgium for the first seven months, the Netherlands on Funda for more than two years. The last eleven files each went out on the first Monday. Each has a tab per branch, sorted by price, with new builds and duplicates already removed.

See our Funda scraper, our Immoweb scraper and more real estate data projects. To track sold or delisted homes for your own territories, browse our sample datasets or send us your postcode list.

Talk to us to find out how we can help you

Let us take your work with data to the next level and outrank your competitors.

  1. 1

    Make a request

    You tell us which website(s) to scrape, what data to capture, how often to repeat etc.

  2. 2

    Analysis

    An expert analyzes the specs and proposes a lowest cost solution that fits your budget.

  3. 3

    Work in progress

    We configure, deploy and maintain jobs in our cloud to extract data with highest quality. Then we sample the data and send it to you for review.

  4. 4

    You check the sample

    If you are satisfied with the quality of the dataset sample, we finish the data collection and send you the final result.

Get in touch with us

Tell us more about you and your project information.

Which sites, which fields, how often. A couple of lines is enough.

This form is protected by Google reCAPTCHA, which loads when you start filling it in; the Google Privacy Policy and Terms of Service apply. If you prefer not to use it, email us at info@scrapeit.io. Privacy & Cookie Policy

We reply within 1 business day. No obligation.