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 2FB' order by fulladdress
SE1 2FB - 655,000
- Leasehold Flat/Maisonette
SE1 2FB - 631,000
- Leasehold Purpose built flat
SE1 2FB - 702,000
- Leasehold Purpose built flat
SE1 2FB - 721,000
- Leasehold Purpose built flat
SE1 2FB - 695,000
- Leasehold Purpose built flat
SE1 2FB - 699,000
- Leasehold Purpose built flat
SE1 2FB - 654,000
- Leasehold Flat/Maisonette
SE1 2FB - 638,000
- Leasehold Flat/Maisonette
SE1 2FB - 706,000
- Feudal Flat/Maisonette
SE1 2FB - 706,000
- Leasehold Flat/Maisonette
SE1 2FB - 620,000
- Leasehold Flat/Maisonette
SE1 2FB - 1,035,000
- Leasehold Flat/Maisonette
SE1 2FB - 1,027,000
- Leasehold Flat/Maisonette
SE1 2FB - 695,000
- Leasehold Flat/Maisonette
SE1 2FB - 632,000
- Leasehold Flat/Maisonette
SE1 2FB - 693,000
- Leasehold Flat/Maisonette
SE1 2FB - 665,000
- Leasehold Flat/Maisonette
SE1 2FB - 609,000
- Leasehold Flat/Maisonette
SE1 2FB - 657,000
- Leasehold Purpose built flat
SE1 2FB - 763,000
- Leasehold Purpose built flat
SE1 2FB - 828,000
- Leasehold Flat/Maisonette
SE1 2FB - 645,000
- Leasehold Purpose built flat
SE1 2FB - 814,000
- Leasehold Converted flat
SE1 2FB - 696,000
- Leasehold Flat/Maisonette
SE1 2FB - 723,000
- Leasehold Flat/Maisonette
SE1 2FB - 752,000
- Feudal Purpose built flat
SE1 2FB - 709,000
- Leasehold Purpose built flat
SE1 2FB - 614,000
- Feudal Purpose built flat
SE1 2FB - 687,000
- Leasehold Purpose built flat
SE1 2FB - 699,000
- Leasehold Purpose built flat
SE1 2FB - 750,000
- Leasehold Flat/Maisonette
SE1 2FB - 715,000
- Leasehold Purpose built flat
SE1 2FB - 592,000
- Leasehold Purpose built flat
SE1 2FB - 963,000
- Leasehold Flat/Maisonette
SE1 2FB - 806,000
- Leasehold Converted flat
SE1 2FB - 712,000
- Leasehold Purpose built flat
SE1 2FB - 851,000
- Leasehold Flat/Maisonette
SE1 2FB - 772,000
- Leasehold Flat/Maisonette
SE1 2FB - 607,000
- Leasehold Flat/Maisonette
SE1 2FB - 809,000
- Leasehold Flat/Maisonette
SE1 2FB - 785,000
- Leasehold Converted flat
SE1 2FB - 752,000
- Leasehold Purpose built flat
SE1 2FB - 856,000
- Leasehold Purpose built flat
SE1 2FB - 666,000
- Leasehold Purpose built flat
SE1 2FB - 821,000
- Leasehold Converted flat
SE1 2FB - 808,000
- Leasehold Purpose built flat
SE1 2FB - 897,000
- Leasehold Flat/Maisonette
SE1 2FB - 781,000
- Leasehold Converted flat
SE1 2FB - 746,000
- Leasehold Purpose built flat
SE1 2FB - 693,000
- Leasehold Purpose built flat
SE1 2FB - 710,000
- Leasehold Purpose built flat
SE1 2FB - 691,000
- Leasehold Converted flat
SE1 2FB - 699,000
- Leasehold Purpose built flat