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 7XB' order by fulladdress
SE1 7XB - 585,000
- Leasehold Purpose built flat
SE1 7XB - 910,000
- Leasehold Flat/Maisonette
SE1 7XB - 838,000
- Leasehold Flat/Maisonette
SE1 7XB - 1,034,000
- Leasehold Flat/Maisonette
SE1 7XB - 625,000
- Leasehold Converted flat
SE1 7XB - 753,000
- Leasehold Converted flat
SE1 7XB - 844,000
- Feudal Purpose built flat
SE1 7XB - 1,074,000
- Leasehold Purpose built flat
SE1 7XB - 740,000
- Leasehold Flat/Maisonette
SE1 7XB - 862,000
- Leasehold Flat/Maisonette
SE1 7XB - 836,000
- Leasehold Flat/Maisonette
SE1 7XB - 996,000
- Leasehold Purpose built flat
SE1 7XB - 690,000
- Leasehold Flat/Maisonette
SE1 7XB - 882,000
- Leasehold Purpose built flat
SE1 7XB - 796,000
- Leasehold Converted flat
SE1 7XB - 994,000
- Leasehold Purpose built flat
SE1 7XB - 727,000
- Leasehold Flat/Maisonette
SE1 7XB - 896,000
- Leasehold Purpose built flat
SE1 7XB - 878,000
- Leasehold Purpose built flat
SE1 7XB - 976,000
- Leasehold Flat/Maisonette
SE1 7XB - 574,000
- Leasehold Flat/Maisonette
SE1 7XB - 870,000
- Leasehold Flat/Maisonette
SE1 7XB - 795,000
- Leasehold Converted flat
SE1 7XB - 1,066,000
- Leasehold Flat/Maisonette
SE1 7XB - 574,000
- Leasehold Converted flat
SE1 7XB - 955,000
- Leasehold Flat/Maisonette
SE1 7XB - 863,000
- Leasehold Converted flat
SE1 7XB - 1,054,000
- Leasehold Purpose built flat
SE1 7XB - 631,000
- Leasehold Flat/Maisonette
SE1 7XB - 881,000
- Leasehold Purpose built flat
SE1 7XB - 892,000
- Leasehold Flat/Maisonette
SE1 7XB - 1,095,000
- Leasehold Purpose built flat
SE1 7XB - 684,000
- Leasehold Flat/Maisonette
SE1 7XB - 944,000
- Leasehold Converted flat
SE1 7XB - 944,000
- Leasehold Flat/Maisonette
SE1 7XB - 618,000
- Leasehold Flat/Maisonette
SE1 7XB - 904,000
- Leasehold Converted flat
SE1 7XB - 928,000
- Leasehold Converted flat
SE1 7XB - 1,049,000
- Leasehold Flat/Maisonette
SE1 7XB - 608,000
- Leasehold Flat/Maisonette
SE1 7XB - 974,000
- Leasehold Purpose built flat
SE1 7XB - 868,000
- Leasehold Flat/Maisonette
SE1 7XB - 986,000
- Leasehold Flat/Maisonette
SE1 7XB - 620,000
- Leasehold Flat/Maisonette
SE1 7XB - 857,000
- Leasehold Flat/Maisonette
SE1 7XB - 874,000
- Leasehold Flat/Maisonette
SE1 7XB - 1,085,000
- Leasehold Purpose built flat
SE1 7XB - 706,000
- Leasehold Flat/Maisonette
SE1 7XB - 908,000
- Leasehold Flat/Maisonette
SE1 7XB - 893,000
- Leasehold Converted flat
SE1 7XB - 1,822,000
- Leasehold Flat/Maisonette
SE1 7XB - 1,348,000
- Leasehold Converted flat
SE1 7XB - 1,560,000
- Leasehold Purpose built flat
SE1 7XB - 1,689,000
- Leasehold Flat/Maisonette
SE1 7XB - 1,915,000
- Leasehold Purpose built flat
SE1 7XB - 1,729,000
- Leasehold Flat/Maisonette
SE1 7XB - 1,879,000
- Leasehold Flat/Maisonette
SE1 7XB - 1,687,000
- Leasehold Flat/Maisonette
SE1 7XB - 0
- Leasehold Flat/Maisonette
SE1 7XB - 1,549,000
- Leasehold Flat/Maisonette
SE1 7XB - 2,621,000
- Leasehold Flat/Maisonette
SE1 7XB - 2,198,000
- Leasehold Flat/Maisonette
SE1 7XB - 1,093,000
- Leasehold Flat/Maisonette
SE1 7XB - 1,019,000
- Leasehold Flat/Maisonette
SE1 7XB - 562,000
- Leasehold Purpose built flat
SE1 7XB - 862,000
- Leasehold Purpose built flat
SE1 7XB - 821,000
- Leasehold Flat/Maisonette
SE1 7XB - 979,000
- Leasehold Purpose built flat
SE1 7XB - 625,000
- Leasehold Flat/Maisonette
SE1 7XB - 887,000
- Feudal Purpose built flat
SE1 7XB - 780,000
- Leasehold Purpose built flat
SE1 7XB - 959,000
- Leasehold Converted flat
SE1 7XB - 611,000
- Leasehold Flat/Maisonette
SE1 7XB - 836,000
- Leasehold Flat/Maisonette
SE1 7XB - 854,000
- Leasehold Flat/Maisonette