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 2PY' order by fulladdress
SE1 2PY - 664,000
- Leasehold Converted flat
SE1 2PY - 1,061,000
- Leasehold Flat/Maisonette
SE1 2PY - 776,000
- Leasehold Flat/Maisonette
SE1 2PY - 861,000
- Feudal Purpose built flat
SE1 2PY - 598,000
- Leasehold Flat/Maisonette
SE1 2PY - 686,000
- Leasehold Flat/Maisonette
SE1 2PY - 843,000
- Leasehold Purpose built flat
SE1 2PY - 753,000
- Leasehold Flat/Maisonette
SE1 2PY - 643,000
- Leasehold Flat/Maisonette
SE1 2PY - 677,000
- Leasehold Purpose built flat
SE1 2PY - 634,000
- Leasehold Flat/Maisonette
SE1 2PY - 677,000
- Leasehold Purpose built flat
SE1 2PY - 835,000
- Leasehold Purpose built flat
SE1 2PY - 755,000
- Leasehold Flat/Maisonette
SE1 2PY - 741,000
- Leasehold Flat/Maisonette
SE1 2PY - 805,000
- Leasehold Flat/Maisonette
SE1 2PY - 851,000
- Leasehold Purpose built flat
SE1 2PY - 821,000
- Leasehold Flat/Maisonette
SE1 2PY - 839,000
- Leasehold Purpose built flat
SE1 2PY - 1,060,000
- Leasehold Purpose built flat
SE1 2PY - 1,194,000
- Leasehold Purpose built flat
SE1 2PY - 735,000
- Leasehold Purpose built flat
SE1 2PY - 904,000
- Leasehold Flat/Maisonette
SE1 2PY - 1,169,000
- Leasehold Flat/Maisonette
SE1 2PY - 922,000
- Leasehold Purpose built flat
SE1 2PY - 663,000
- Leasehold Flat/Maisonette
SE1 2PY - 836,000
- Leasehold Converted flat
SE1 2PY - 690,000
- Leasehold Purpose built flat
SE1 2PY - 649,000
- Leasehold Flat/Maisonette
SE1 2PY - 851,000
- Feudal Purpose built flat
SE1 2PY - 841,000
- Leasehold Flat/Maisonette
SE1 2PY - 765,000
- Leasehold Flat/Maisonette
SE1 2PY - 649,000
- Leasehold Flat/Maisonette
SE1 2PY - 830,000
- Leasehold Flat/Maisonette
SE1 2PY - 648,000
- Leasehold Flat/Maisonette
SE1 2PY - 615,000
- Leasehold Purpose built flat
SE1 2PY - 844,000
- Leasehold Flat/Maisonette
SE1 2PY - 697,000
- Leasehold Converted flat
SE1 2PY - 904,000
- Leasehold Flat/Maisonette
SE1 2PY - 679,000
- Leasehold Purpose built flat
SE1 2PY - 827,000
- Leasehold Flat/Maisonette
SE1 2PY - 615,000
- Leasehold Flat/Maisonette
SE1 2PY - 681,000
- Leasehold Purpose built flat
SE1 2PY - 849,000
- Leasehold Purpose built flat
SE1 2PY - 847,000
- Leasehold Flat/Maisonette
SE1 2PY - 732,000
- Leasehold Flat/Maisonette
SE1 2PY - 657,000
- Leasehold Flat/Maisonette
SE1 2PY - 908,000
- Leasehold Flat/Maisonette
SE1 2PY - 606,000
- Leasehold Flat/Maisonette
SE1 2PY - 619,000
- Leasehold Flat/Maisonette
SE1 2PY - 659,000
- Leasehold Flat/Maisonette
SE1 2PY - 646,000
- Leasehold Purpose built flat
SE1 2PY - 838,000
- Leasehold Flat/Maisonette
SE1 2PY - 732,000
- Leasehold Flat/Maisonette
SE1 2PY - 1,037,000
- Leasehold Purpose built flat
SE1 2PY - 690,000
- Leasehold Flat/Maisonette
SE1 2PY - 837,000
- Leasehold Purpose built flat
SE1 2PY - 633,000
- Leasehold Flat/Maisonette
SE1 2PY - 665,000
- Leasehold Flat/Maisonette
SE1 2PY - 830,000
- Leasehold Purpose built flat
SE1 2PY - 847,000
- Leasehold Purpose built flat
SE1 2PY - 667,000
- Leasehold Purpose built flat
SE1 2PY - 613,000
- Leasehold Purpose built flat
SE1 2PY - 627,000
- Leasehold Flat/Maisonette
SE1 2PY - 645,000
- Leasehold Flat/Maisonette