SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SW1X 9HD' order by fulladdress
SW1X 9HD - 2,710,000
- Leasehold Purpose built flat
SW1X 9HD - 2,526,000
- Leasehold Flat/Maisonette
SW1X 9HD - 7,849,000
- Leasehold Flat/Maisonette
SW1X 9HD - 1,617,000
- Leasehold Flat/Maisonette
SW1X 9HD - 2,877,000
- Leasehold Flat/Maisonette
SW1X 9HD - 2,416,000
- Leasehold Flat/Maisonette
SW1X 9HD - 3,386,000
- Leasehold Flat/Maisonette
SW1X 9HD - 2,335,000
- Leasehold Flat/Maisonette
SW1X 9HD - 3,375,000
- Leasehold Flat/Maisonette
SW1X 9HD - 3,313,000
- Leasehold Flat/Maisonette
SW1X 9HD - 2,331,000
- Leasehold Flat/Maisonette
SW1X 9HD - 3,922,000
- Leasehold Flat/Maisonette
SW1X 9HD - 3,369,000
- Leasehold Flat/Maisonette
SW1X 9HD - 1,903,000
- Feudal Purpose built flat
