SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SE1 2EA' order by fulladdress
SE1 2EA - 945,000
- Leasehold Flat/Maisonette
SE1 2EA - 950,000
- Leasehold Purpose built flat
SE1 2EA - 1,026,000
- Leasehold Flat/Maisonette
SE1 2EA - 922,000
- Leasehold Purpose built flat
SE1 2EA - 997,000
- Leasehold Purpose built flat
SE1 2EA - 1,002,000
- Leasehold Purpose built flat
SE1 2EA - 1,034,000
- Leasehold Flat/Maisonette
SE1 2EA - 919,000
- Leasehold Purpose built flat
SE1 2EA - 1,011,000
- Leasehold Purpose built flat
SE1 2EA - 1,014,000
- Leasehold Flat/Maisonette
SE1 2EA - 1,070,000
- Leasehold Flat/Maisonette
SE1 2EA - 968,000
- Leasehold Flat/Maisonette
SE1 2EA - 931,000
- Leasehold Purpose built flat
SE1 2EA - 937,000
- Leasehold Purpose built flat
SE1 2EA - 923,000
- Leasehold Flat/Maisonette
SE1 2EA - 986,000
- Leasehold Purpose built flat
SE1 2EA - 976,000
- Leasehold Purpose built flat
SE1 2EA - 1,002,000
- Leasehold Flat/Maisonette
SE1 2EA - 984,000
- Feudal Purpose built flat
SE1 2EA - 996,000
- Leasehold Flat/Maisonette
SE1 2EA - 1,018,000
- Leasehold Purpose built flat
SE1 2EA - 983,000
- Leasehold Flat/Maisonette
SE1 2EA - 917,000
- Feudal Purpose built flat
SE1 2EA - 951,000
- Leasehold Purpose built flat
SE1 2EA - 1,050,000
- Leasehold Flat/Maisonette
SE1 2EA - 921,000
- Leasehold Purpose built flat
SE1 2EA - 913,000
- Leasehold Purpose built flat
SE1 2EA - 878,000
- Leasehold Purpose built flat
SE1 2EA - 856,000
- Leasehold Purpose built flat
SE1 2EA - 1,053,000
- Leasehold Flat/Maisonette
SE1 2EA - 977,000
- Feudal Purpose built flat
SE1 2EA - 846,000
- Leasehold Purpose built flat
SE1 2EA - 754,000
- Leasehold Purpose built flat
SE1 2EA - 1,026,000
- Leasehold Flat/Maisonette
SE1 2EA - 1,028,000
- Leasehold Flat/Maisonette
SE1 2EA - 856,000
- Leasehold Purpose built flat
SE1 2EA - 973,000
- Leasehold Flat/Maisonette
SE1 2EA - 874,000
- Leasehold Purpose built flat
SE1 2EA - 1,044,000
- Leasehold Flat/Maisonette
SE1 2EA - 965,000
- Leasehold Purpose built flat
SE1 2EA - 1,053,000
- Leasehold Purpose built flat
SE1 2EA - 984,000
- Leasehold Flat/Maisonette
SE1 2EA - 918,000
- Leasehold Purpose built flat
SE1 2EA - 1,025,000
- Leasehold Flat/Maisonette
SE1 2EA - 2,152,000
- Leasehold Flat/Maisonette
SE1 2EA - 989,000
- Leasehold Flat/Maisonette
SE1 2EA - 896,000
- Leasehold Purpose built flat