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 2PX' order by fulladdress
SE1 2PX - 892,000
- Leasehold Flat/Maisonette
SE1 2PX - 667,000
- Leasehold Converted flat
SE1 2PX - 977,000
- Feudal Converted flat
SE1 2PX - 716,000
- Leasehold Flat/Maisonette
SE1 2PX - 999,000
- Feudal Converted flat
SE1 2PX - 1,032,000
- Leasehold Converted flat
SE1 2PX - 737,000
- Leasehold Flat/Maisonette
SE1 2PX - 1,011,000
- Leasehold Flat/Maisonette
SE1 2PX - 1,030,000
- Leasehold Flat/Maisonette
SE1 2PX - 772,000
- Leasehold Converted flat
SE1 2PX - 801,000
- Leasehold Flat/Maisonette
SE1 2PX - 935,000
- Leasehold Converted flat
SE1 2PX - 1,029,000
- Leasehold Converted flat
SE1 2PX - 687,000
- Leasehold Flat/Maisonette
SE1 2PX - 869,000
- Leasehold Flat/Maisonette
SE1 2PX - 967,000
- Leasehold Converted flat
SE1 2PX - 662,000
- Leasehold Converted flat
SE1 2PX - 1,052,000
- Leasehold Flat/Maisonette
SE1 2PX - 807,000
- Feudal Converted flat
SE1 2PX - 770,000
- Leasehold Converted flat
SE1 2PX - 780,000
- Leasehold Converted flat
SE1 2PX - 576,000
- Leasehold Flat/Maisonette
SE1 2PX - 1,062,000
- Leasehold Converted flat
SE1 2PX - 679,000
- Leasehold Flat/Maisonette
SE1 2PX - 755,000
- Leasehold Converted flat
SE1 2PX - 806,000
- Leasehold Converted flat
SE1 2PX - 1,010,000
- Leasehold Converted flat
SE1 2PX - 958,000
- Leasehold Converted flat
SE1 2PX - 623,000
- Leasehold Purpose built flat
SE1 2PX - 1,051,000
- Leasehold Flat/Maisonette
SE1 2PX - 976,000
- Leasehold Purpose built flat
SE1 2PX - 830,000
- Leasehold Converted flat
SE1 2PX - 1,106,000
- Leasehold Converted flat
SE1 2PX - 821,000
- Leasehold Converted flat
SE1 2PX - 1,077,000
- Leasehold Converted flat
SE1 2PX - 677,000
- Leasehold Converted flat
SE1 2PX - 1,095,000
- Leasehold Converted flat
SE1 2PX - 829,000
- Leasehold Converted flat
SE1 2PX - 800,000
- Leasehold Flat/Maisonette
SE1 2PX - 1,720,000
- Freehold End terrace house
SE1 2PX - 1,625,000
- Freehold Mid terrace house
SE1 2PX - 1,616,000
- Freehold Mid terrace house
SE1 2PX - 1,734,000
- Freehold Mid terrace house
SE1 2PX - 1,957,000
- Freehold Terrace property
SE1 2PX - 686,000
- Leasehold Flat/Maisonette
SE1 2PX - 689,000
- Leasehold Flat/Maisonette
SE1 2PX - 1,583,000
- Leasehold Flat/Maisonette
SE1 2PX - 682,000
- Leasehold Converted flat
SE1 2PX - 970,000
- Leasehold Flat/Maisonette
SE1 2PX - 628,000
- Leasehold Converted flat
SE1 2PX - 972,000
- Leasehold Converted flat