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 7PJ' order by fulladdress
SE1 7PJ - 1,115,000
- Leasehold Converted flat
SE1 7PJ - 752,000
- Leasehold Flat/Maisonette
SE1 7PJ - 901,000
- Leasehold Flat/Maisonette
SE1 7PJ - 936,000
- Leasehold Flat/Maisonette
SE1 7PJ - 717,000
- Leasehold Flat/Maisonette
SE1 7PJ - 753,000
- Leasehold Flat/Maisonette
SE1 7PJ - 1,304,000
- Leasehold Flat/Maisonette
SE1 7PJ - 757,000
- Leasehold Purpose built flat
SE1 7PJ - 732,000
- Leasehold Converted flat
SE1 7PJ - 697,000
- Leasehold Flat/Maisonette
SE1 7PJ - 908,000
- Leasehold Flat/Maisonette
SE1 7PJ - 894,000
- Leasehold Converted flat
SE1 7PJ - 672,000
- Leasehold Converted flat
SE1 7PJ - 748,000
- Leasehold Flat/Maisonette
SE1 7PJ - 874,000
- Leasehold Flat/Maisonette
SE1 7PJ - 702,000
- Leasehold Flat/Maisonette
SE1 7PJ - 919,000
- Leasehold Flat/Maisonette
SE1 7PJ - 902,000
- Leasehold Converted flat
SE1 7PJ - 666,000
- Leasehold Purpose built flat
SE1 7PJ - 843,000
- Leasehold Flat/Maisonette
SE1 7PJ - 758,000
- Leasehold Flat/Maisonette
SE1 7PJ - 706,000
- Leasehold Flat/Maisonette
SE1 7PJ - 1,229,000
- Leasehold Flat/Maisonette
SE1 7PJ - 946,000
- Leasehold Flat/Maisonette
SE1 7PJ - 603,000
- Leasehold Flat/Maisonette
SE1 7PJ - 578,000
- Leasehold Purpose built flat
SE1 7PJ - 892,000
- Leasehold Flat/Maisonette
SE1 7PJ - 938,000
- Leasehold Flat/Maisonette
SE1 7PJ - 639,000
- Leasehold Flat/Maisonette
SE1 7PJ - 745,000
- Leasehold Flat/Maisonette
SE1 7PJ - 828,000
- Leasehold Flat/Maisonette
SE1 7PJ - 1,335,000
- Leasehold Converted flat
SE1 7PJ - 917,000
- Leasehold Flat/Maisonette
SE1 7PJ - 747,000
- Leasehold Flat/Maisonette
SE1 7PJ - 890,000
- Leasehold Flat/Maisonette
SE1 7PJ - 1,065,000
- Leasehold Flat/Maisonette
SE1 7PJ - 776,000
- Leasehold Flat/Maisonette
SE1 7PJ - 778,000
- Leasehold Flat/Maisonette
SE1 7PJ - 1,268,000
- Leasehold Flat/Maisonette
SE1 7PJ - 878,000
- Leasehold Flat/Maisonette
SE1 7PJ - 771,000
- Leasehold Flat/Maisonette
SE1 7PJ - 687,000
- Leasehold Flat/Maisonette
SE1 7PJ - 943,000
- Leasehold Flat/Maisonette
SE1 7PJ - 846,000
- Leasehold Flat/Maisonette
SE1 7PJ - 687,000
- Leasehold Flat/Maisonette
SE1 7PJ - 663,000
- Leasehold Converted flat
SE1 7PJ - 1,282,000
- Leasehold Flat/Maisonette
SE1 7PJ - 815,000
- Leasehold Converted flat
SE1 7PJ - 788,000
- Leasehold Flat/Maisonette
SE1 7PJ - 951,000
- Leasehold Flat/Maisonette
SE1 7PJ - 925,000
- Leasehold Flat/Maisonette
SE1 7PJ - 690,000
- Leasehold Flat/Maisonette
SE1 7PJ - 609,000
- Leasehold Flat/Maisonette
SE1 7PJ - 677,000
- Leasehold Flat/Maisonette
SE1 7PJ - 886,000
- Leasehold Flat/Maisonette
SE1 7PJ - 1,242,000
- Leasehold Flat/Maisonette
SE1 7PJ - 815,000
- Leasehold Purpose built flat
SE1 7PJ - 442,000
- Leasehold Flat/Maisonette