SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SW1P 2FE' order by fulladdress
SW1P 2FE - 943,000
- Leasehold Flat/Maisonette
SW1P 2FE - 952,000
- Leasehold Flat/Maisonette
SW1P 2FE - 1,517,000
- Leasehold Flat/Maisonette
SW1P 2FE - 1,568,000
- Leasehold Flat/Maisonette
SW1P 2FE - 1,999,000
- Leasehold Purpose built flat
SW1P 2FE - 1,784,000
- Leasehold Flat/Maisonette
SW1P 2FE - 2,253,000
- Leasehold Flat/Maisonette
SW1P 2FE - 1,978,000
- Leasehold Flat/Maisonette
SW1P 2FE - 2,598,000
- Leasehold Flat/Maisonette
SW1P 2FE - 929,000
- Leasehold Flat/Maisonette
SW1P 2FE - 1,530,000
- Leasehold Flat/Maisonette
SW1P 2FE - 1,575,000
- Leasehold Flat/Maisonette
SW1P 2FE - 2,070,000
- Leasehold Flat/Maisonette
SW1P 2FE - 1,566,000
- Feudal Purpose built flat
SW1P 2FE - 2,472,000
- Leasehold Flat/Maisonette
SW1P 2FE - 2,144,000
- Leasehold Flat/Maisonette
SW1P 2FE - 2,268,000
- Feudal Purpose built flat
SW1P 2FE - 962,000
- Leasehold Flat/Maisonette
SW1P 2FE - 1,651,000
- Leasehold Flat/Maisonette
SW1P 2FE - 3,154,000
- Leasehold Flat/Maisonette
SW1P 2FE - 3,728,000
- Leasehold Flat/Maisonette
SW1P 2FE - 3,068,000
- Leasehold Flat/Maisonette
SW1P 2FE - 1,491,000
- Leasehold Flat/Maisonette
SW1P 2FE - 4,314,000
- Leasehold Flat/Maisonette
SW1P 2FE - 1,487,000
- Leasehold Flat/Maisonette
SW1P 2FE - 2,206,000
- Leasehold Flat/Maisonette
SW1P 2FE - 887,000
- Leasehold Flat/Maisonette
SW1P 2FE - 916,000
- Leasehold Flat/Maisonette
SW1P 2FE - 1,745,000
- Leasehold Flat/Maisonette
SW1P 2FE - 871,000
- Leasehold Purpose built flat
SW1P 2FE - 1,472,000
- Leasehold Flat/Maisonette
SW1P 2FE - 1,473,000
- Leasehold Flat/Maisonette
SW1P 2FE - 1,368,000
- Leasehold Flat/Maisonette
SW1P 2FE - 1,984,000
- Leasehold Flat/Maisonette
SW1P 2FE - 1,800,000
- Leasehold Flat/Maisonette
SW1P 2FE - 942,000
- Leasehold Flat/Maisonette
SW1P 2FE - 965,000
- Leasehold Flat/Maisonette
SW1P 2FE - 1,457,000
- Leasehold Flat/Maisonette
SW1P 2FE - 974,000
- Leasehold Purpose built flat
SW1P 2FE - 1,525,000
- Leasehold Flat/Maisonette
SW1P 2FE - 2,029,000
- Leasehold Flat/Maisonette
SW1P 2FE - 934,000
- Leasehold Flat/Maisonette
SW1P 2FE - 1,747,000
- Leasehold Flat/Maisonette
SW1P 2FE - 924,000
- Leasehold Flat/Maisonette
SW1P 2FE - 1,527,000
- Leasehold Flat/Maisonette
SW1P 2FE - 1,361,000
- Leasehold Flat/Maisonette
SW1P 2FE - 1,960,000
- Leasehold Flat/Maisonette
SW1P 2FE - 1,831,000
- Leasehold Flat/Maisonette
SW1P 2FE - 925,000
- Leasehold Flat/Maisonette
SW1P 2FE - 930,000
- Leasehold Flat/Maisonette
SW1P 2FE - 1,977,000
- Leasehold Flat/Maisonette
SW1P 2FE - 1,485,000
- Leasehold Flat/Maisonette
SW1P 2FE - 1,965,000
- Leasehold Flat/Maisonette