SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SW7 3LT' order by fulladdress
SW7 3LT - 4,927,000
- Leasehold Flat/Maisonette
SW7 3LT - 2,546,000
- Leasehold Flat/Maisonette
SW7 3LT - 3,385,000
- Leasehold Flat/Maisonette
SW7 3LT - 2,648,000
- Leasehold Purpose built flat
SW7 3LT - 4,049,000
- Leasehold Flat/Maisonette
SW7 3LT - 3,137,000
- Leasehold Converted flat
SW7 3LT - 3,210,000
- Leasehold Flat/Maisonette
SW7 3LT - 2,533,000
- Leasehold Flat/Maisonette
SW7 3LT - 4,199,000
- Leasehold Flat/Maisonette
SW7 3LT - 2,898,000
- Leasehold Converted flat
SW7 3LT - 3,346,000
- Leasehold Flat/Maisonette
SW7 3LT - 2,692,000
- Leasehold Flat/Maisonette
SW7 3LT - 4,000,000
- Leasehold Flat/Maisonette
SW7 3LT - 2,431,000
- Leasehold Flat/Maisonette
SW7 3LT - 3,024,000
- Leasehold Flat/Maisonette
SW7 3LT - 3,134,000
- Leasehold Flat/Maisonette
