SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SW10 0RR' order by fulladdress
SW10 0RR - 720,000
- Leasehold Converted flat
SW10 0RR - 1,093,000
- Leasehold Purpose built flat
SW10 0RR - 1,503,000
- Leasehold Flat/Maisonette
SW10 0RR - 977,000
- Leasehold Purpose built flat
SW10 0RR - 708,000
- Leasehold Purpose built flat
SW10 0RR - 1,706,000
- Leasehold Flat/Maisonette
SW10 0RR - 1,572,000
- Leasehold Purpose built flat
SW10 0RR - 771,000
- Leasehold Flat/Maisonette
SW10 0RR - 1,835,000
- Leasehold Flat/Maisonette
SW10 0RR - 964,000
- Leasehold Flat/Maisonette
SW10 0RR - 782,000
- Leasehold Flat/Maisonette
SW10 0RR - 879,000
- Leasehold Flat/Maisonette
SW10 0RR - 1,428,000
- Leasehold Flat/Maisonette
SW10 0RR - 1,381,000
- Leasehold Flat/Maisonette
SW10 0RR - 1,506,000
- Leasehold Flat/Maisonette
SW10 0RR - 1,498,000
- Leasehold Flat/Maisonette
SW10 0RR - 1,001,000
- Leasehold Flat/Maisonette
SW10 0RR - 1,993,000
- Leasehold Flat/Maisonette
SW10 0RR - 2,242,000
- Leasehold Flat/Maisonette
SW10 0RR - 1,360,000
- Leasehold Flat/Maisonette
SW10 0RR - 947,000
- Leasehold Flat/Maisonette
SW10 0RR - 1,272,000
- Leasehold Flat/Maisonette
SW10 0RR - 1,544,000
- Leasehold Flat/Maisonette
SW10 0RR - 1,310,000
- Feudal Purpose built flat
SW10 0RR - 2,182,000
- Leasehold Flat/Maisonette
SW10 0RR - 670,000
- Leasehold Flat/Maisonette
SW10 0RR - 747,000
- Leasehold Purpose built flat
SW10 0RR - 1,654,000
- Leasehold Flat/Maisonette
SW10 0RR - 1,509,000
- Leasehold Flat/Maisonette
SW10 0RR - 1,513,000
- Leasehold Flat/Maisonette
SW10 0RR - 784,000
- Leasehold Flat/Maisonette
SW10 0RR - 920,000
- Leasehold Purpose built flat
SW10 0RR - 1,783,000
- Leasehold Flat/Maisonette
SW10 0RR - 757,000
- Leasehold Converted flat
SW10 0RR - 1,591,000
- Leasehold Flat/Maisonette
SW10 0RR - 1,438,000
- Leasehold Flat/Maisonette
SW10 0RR - 1,406,000
- Leasehold Flat/Maisonette
SW10 0RR - 2,064,000
- Leasehold Flat/Maisonette
SW10 0RR - 1,416,000
- Leasehold Flat/Maisonette
SW10 0RR - 1,507,000
- Leasehold Purpose built flat
SW10 0RR - 1,289,000
- Leasehold Flat/Maisonette
SW10 0RR - 1,367,000
- Leasehold Flat/Maisonette
SW10 0RR - 913,000
- Leasehold Purpose built flat
SW10 0RR - 1,208,000
- Leasehold Flat/Maisonette
SW10 0RR - 2,855,000
- Leasehold Flat/Maisonette
SW10 0RR - 2,499,000
- Leasehold Flat/Maisonette
SW10 0RR - 605,000
- Leasehold Flat/Maisonette
SW10 0RR - 1,222,000
- Leasehold Converted flat
SW10 0RR - 1,419,000
- Leasehold Flat/Maisonette
SW10 0RR - 767,000
- Leasehold Flat/Maisonette