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 1AP' order by fulladdress
SE1 1AP - 900,000
- Leasehold Purpose built flat
SE1 1AP - 695,000
- Leasehold Purpose built flat
SE1 1AP - 650,000
- Leasehold Flat/Maisonette
SE1 1AP - 1,304,000
- Leasehold Flat/Maisonette
SE1 1AP - 1,030,000
- Leasehold Purpose built flat
SE1 1AP - 1,329,000
- Leasehold Flat/Maisonette
SE1 1AP - 1,362,000
- Leasehold Flat/Maisonette
SE1 1AP - 1,235,000
- Leasehold Purpose built flat
SE1 1AP - 912,000
- Leasehold Flat/Maisonette
SE1 1AP - 974,000
- Leasehold Flat/Maisonette
SE1 1AP - 891,000
- Leasehold Purpose built flat
SE1 1AP - 934,000
- Leasehold Flat/Maisonette
SE1 1AP - 640,000
- Leasehold Flat/Maisonette
SE1 1AP - 636,000
- Leasehold Flat/Maisonette
SE1 1AP - 640,000
- Leasehold Purpose built flat
SE1 1AP - 616,000
- Feudal Purpose built flat
SE1 1AP - 865,000
- Leasehold Purpose built flat
SE1 1AP - 916,000
- Leasehold Flat/Maisonette
SE1 1AP - 942,000
- Leasehold Flat/Maisonette
SE1 1AP - 900,000
- Leasehold Purpose built flat
SE1 1AP - 644,000
- Leasehold Flat/Maisonette
SE1 1AP - 914,000
- Leasehold Flat/Maisonette
SE1 1AP - 646,000
- Leasehold Flat/Maisonette
SE1 1AP - 643,000
- Leasehold Flat/Maisonette
SE1 1AP - 645,000
- Leasehold Flat/Maisonette
SE1 1AP - 644,000
- Leasehold Flat/Maisonette
SE1 1AP - 882,000
- Leasehold Purpose built flat
SE1 1AP - 943,000
- Leasehold Flat/Maisonette
SE1 1AP - 938,000
- Leasehold Flat/Maisonette
SE1 1AP - 653,000
- Leasehold Flat/Maisonette
SE1 1AP - 640,000
- Leasehold Flat/Maisonette
SE1 1AP - 967,000
- Leasehold Flat/Maisonette
SE1 1AP - 974,000
- Leasehold Flat/Maisonette
SE1 1AP - 658,000
- Leasehold Flat/Maisonette
SE1 1AP - 654,000
- Leasehold Flat/Maisonette
SE1 1AP - 658,000
- Leasehold Flat/Maisonette
SE1 1AP - 940,000
- Leasehold Purpose built flat
SE1 1AP - 941,000
- Leasehold Flat/Maisonette
SE1 1AP - 941,000
- Leasehold Purpose built flat
SE1 1AP - 698,000
- Leasehold Flat/Maisonette
SE1 1AP - 652,000
- Feudal Purpose built flat
SE1 1AP - 990,000
- Leasehold Flat/Maisonette
SE1 1AP - 769,000
- Leasehold Flat/Maisonette
SE1 1AP - 1,105,000
- Leasehold Flat/Maisonette
SE1 1AP - 1,100,000
- Leasehold Flat/Maisonette
SE1 1AP - 768,000
- Leasehold Flat/Maisonette
SE1 1AP - 1,073,000
- Leasehold Purpose built flat
SE1 1AP - 899,000
- Leasehold Flat/Maisonette
SE1 1AP - 644,000
- Leasehold Flat/Maisonette
SE1 1AP - 649,000
- Leasehold Purpose built flat
SE1 1AP - 1,139,000
- Leasehold Flat/Maisonette
SE1 1AP - 1,139,000
- Leasehold Flat/Maisonette
SE1 1AP - 643,000
- Leasehold Flat/Maisonette
SE1 1AP - 1,091,000
- Leasehold Flat/Maisonette
SE1 1AP - 768,000
- Leasehold Flat/Maisonette
SE1 1AP - 1,299,000
- Leasehold Purpose built flat
SE1 1AP - 671,000
- Leasehold Purpose built flat
SE1 1AP - 653,000
- Leasehold Flat/Maisonette
SE1 1AP - 940,000
- Leasehold Purpose built flat
SE1 1AP - 1,022,000
- Leasehold Flat/Maisonette
SE1 1AP - 801,000
- Leasehold Flat/Maisonette
SE1 1AP - 681,000
- Leasehold Flat/Maisonette
SE1 1AP - 880,000
- Leasehold Flat/Maisonette
SE1 1AP - 914,000
- Leasehold Flat/Maisonette
SE1 1AP - 997,000
- Leasehold Flat/Maisonette
SE1 1AP - 653,000
- Leasehold Flat/Maisonette
SE1 1AP - 1,048,000
- Leasehold Flat/Maisonette
SE1 1AP - 1,497,000
- Leasehold Purpose built flat