Active real estate companies carrying at least one outstanding charge registered at Companies House. In property a charge is usually a mortgage, so this separates the financed estate from the unencumbered one across the whole UK rather than one city. The count of outstanding, part-satisfied and satisfied charges is included, which distinguishes a company on its first facility from one with a long borrowing history. The register records that a charge exists and who holds it, never how much is owed.
| Company Name | Company Number | Incorporated | Status | Sic Code | Sic Description | Post Town | Postcode | Size Band | Mort Outstanding | Mort Part Satisfied | Mort Satisfied |
|---|---|---|---|---|---|---|---|---|---|---|---|
| INLET PROPERTIES LIMITED | 02266918 | 1988-06-13 | Active | 68100 | Buying and selling of own real estate | LUTON | LU1 2SJ | Micro | 7 | 0 | 24 |
| MOUNTAIN PROPERTY SERVICES LIMITED | 02265845 | 1988-06-08 | Active | 68100 | Buying and selling of own real estate | EPSOM | KT18 7ET | Small | 1 | 0 | 4 |
| STOKE-ON-TRENT REGENERATION LIMITED | 02265579 | 1988-06-08 | Active | 68100 | Buying and selling of own real estate | LONDON | SW1E 5LB | Subsidiary (exempt) | 3 | 0 | 9 |
| OAKHURST (EAST ANGLIA) LIMITED | 02265454 | 1988-06-07 | Active | 68100 | Buying and selling of own real estate | IPSWICH | IP1 3JB | Small | 6 | 0 | 0 |
| COUNTERCLAIM LIMITED | 02262510 | 1988-05-26 | Active | 68100 | Buying and selling of own real estate | LONDON | N14 6NZ | Small | 3 | 0 | 6 |
| ELTHORNE INVESTMENTS LIMITED | 02261980 | 1988-05-25 | Active | 68100 | Buying and selling of own real estate | EXETER | EX2 7XE | Small | 1 | 0 | 1 |
| LYNWOOD PARK LIMITED | 02261474 | 1988-05-24 | Active | 68100 | Buying and selling of own real estate | EASTLEIGH | SO53 3AL | Small | 9 | 0 | 60 |
| METROPOLITAN & COUNTY HOLDINGS LIMITED | 02261046 | 1988-05-23 | Active | 68100 | Buying and selling of own real estate | LONDON | NW4 4DJ | Small | 1 | 0 | 2 |
| N J DAVIES & PARTNERS LIMITED | 02260841 | 1988-05-20 | Active | 68100 | Buying and selling of own real estate | NORTHAMPTON | NN6 9DJ | Micro | 3 | 0 | 4 |
Prepared by DataSteak from Companies House, October 2026 snapshot. Original data published by the source; the cut, cleaning and typing are ours.
Source: Companies House · Office for National Statistics · See Attributions for licensing information.
12 fields, with types, how much of each is filled in, and a real example from the data.
| Column | Type | Populated | Example |
|---|---|---|---|
| company_name | Text | 100% | INLET PROPERTIES LIMITED |
| company_number | Text | 100% | 02266918 |
| incorporated | Date | 100% | 1988-06-13 |
| status | Text | 100% | Active |
| sic_code | Text | 100% | 68100 |
| sic_description | Text | 100% | Buying and selling of own real estate |
| post_town | Text | 99% | LUTON |
| postcode | Text | 100% | LU1 2SJ |
| size_band | Text | 100% | Micro |
| mort_outstanding | Number | 100% | 7 |
| mort_part_satisfied | Number | 100% | 0 |
| mort_satisfied | Number | 100% | 24 |
Measured from this product's own query rather than the dataset as a whole, so it describes what you would actually be buying.
Companies incorporated in the last 90 days with a registered address in the London postal…
£249.00 · View → IT & TechnologyActive companies in the London postal areas whose primary SIC code sits in division 62 or…
£199.00 · View → MixedCompanies in the London postal areas currently marked as proposed for strike off, meaning…
£249.00 · View →It's generated on demand. When you buy, the query runs against the live data and builds your file right then, so it's current as of your purchase. You download it straight away.
A one-off download of this exact cut, all 247,544 rows and every column shown above, as a CSV file that opens in Excel or Google Sheets. It's a snapshot of the data as it is today. It does not include ongoing updates or API access, neither of which is available yet.
Yes, on request. We can turn on API access for this dataset against your account, and you issue your own key from your dashboard. It returns the same data as the file, over HTTP, in JSON, with the edition date on every response so your systems can tell when there is something new to pull.
It is not a live feed. The data changes when the register is refreshed, roughly monthly, and the API serves whatever the current edition is. Access is arranged per dataset rather than bought from the site, so ask us and we will set it up.
Yes. The preview above is real data, and the 15-row sample download gives you every column so you can check the format and quality first.
Yes. A commercial and internal-business licence is included. Redistribution as-is is restricted; enterprise redistribution rights are available on request.
The price shown includes UK VAT at 20%, so it is the amount you pay with nothing added at the end, and checkout shows the split before you commit. A VAT invoice is raised and emailed automatically when payment goes through, carrying our VAT number and the tax breakdown, so a UK VAT-registered business can reclaim the VAT without asking us for anything. More on pricing and licensing.
247,544 rows, generated fresh on download.