SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SW1A 2EP' order by fulladdress
SW1A 2EP - 2,657,000
- Leasehold Flat/Maisonette
SW1A 2EP - 1,804,000
- Leasehold Flat/Maisonette
SW1A 2EP - 1,633,000
- Leasehold Flat/Maisonette
SW1A 2EP - 3,171,000
- Leasehold Flat/Maisonette
SW1A 2EP - 1,385,000
- Leasehold Flat/Maisonette
SW1A 2EP - 1,059,000
- Leasehold Flat/Maisonette
SW1A 2EP - 1,849,000
- Leasehold Flat/Maisonette
SW1A 2EP - 1,178,000
- Leasehold Flat/Maisonette
SW1A 2EP - 1,679,000
- Leasehold Flat/Maisonette
SW1A 2EP - 3,216,000
- Leasehold Flat/Maisonette
SW1A 2EP - 3,653,000
- Leasehold Flat/Maisonette
SW1A 2EP - 1,672,000
- Leasehold Flat/Maisonette
SW1A 2EP - 3,317,000
- Leasehold Flat/Maisonette
SW1A 2EP - 1,472,000
- Leasehold Flat/Maisonette
SW1A 2EP - 3,318,000
- Leasehold Flat/Maisonette
SW1A 2EP - 1,852,000
- Leasehold Flat/Maisonette
SW1A 2EP - 2,020,000
- Leasehold Flat/Maisonette
SW1A 2EP - 3,878,000
- Leasehold Flat/Maisonette
SW1A 2EP - 1,664,000
- Leasehold Purpose built flat
SW1A 2EP - 1,624,000
- Leasehold Flat/Maisonette
SW1A 2EP - 1,458,000
- Leasehold Flat/Maisonette
SW1A 2EP - 2,331,000
- Leasehold Flat/Maisonette
SW1A 2EP - 2,629,000
- Leasehold Flat/Maisonette
SW1A 2EP - 1,445,000
- Leasehold Flat/Maisonette
SW1A 2EP - 3,716,000
- Leasehold Flat/Maisonette
SW1A 2EP - 1,795,000
- Leasehold Purpose built flat
SW1A 2EP - 1,879,000
- Leasehold Purpose built flat
SW1A 2EP - 1,701,000
- Leasehold Flat/Maisonette
SW1A 2EP - 3,237,000
- Leasehold Purpose built flat
SW1A 2EP - 3,818,000
- Leasehold Flat/Maisonette
SW1A 2EP - 3,639,000
- Leasehold Flat/Maisonette
SW1A 2EP - 2,231,000
- Leasehold Flat/Maisonette
SW1A 2EP - 4,640,000
- Leasehold Flat/Maisonette
SW1A 2EP - 1,910,000
- Leasehold Flat/Maisonette
SW1A 2EP - 1,535,000
- Leasehold Flat/Maisonette
SW1A 2EP - 1,481,000
- Leasehold Flat/Maisonette
SW1A 2EP - 4,596,000
- Leasehold Flat/Maisonette