SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SW16 6QA' order by fulladdress
SW16 6QA - 440,000
- Freehold Purpose built flat
SW16 6QA - 422,000
- Leasehold Flat/Maisonette
SW16 6QA - 474,000
- Leasehold Purpose built flat
SW16 6QA - 451,000
- Leasehold Purpose built flat
SW16 6QA - 476,000
- Leasehold Purpose built flat
SW16 6QA - 451,000
- Leasehold Purpose built flat
SW16 6QA - 523,000
- Leasehold Purpose built flat
SW16 6QA - 468,000
- Leasehold Purpose built flat
SW16 6QA - 427,000
- Leasehold Flat/Maisonette
SW16 6QA - 477,000
- Leasehold Converted flat
SW16 6QA - 444,000
- Leasehold Purpose built flat
SW16 6QA - 468,000
- Leasehold Purpose built flat
SW16 6QA - 395,000
- Leasehold Flat/Maisonette
SW16 6QA - 413,000
- Leasehold Flat/Maisonette
SW16 6QA - 453,000
- Leasehold Flat/Maisonette
SW16 6QA - 505,000
- Leasehold Purpose built flat
SW16 6QA - 438,000
- Leasehold Purpose built flat
SW16 6QA - 437,000
- Freehold Purpose built flat
SW16 6QA - 461,000
- Leasehold Purpose built flat
SW16 6QA - 390,000
- Leasehold Flat/Maisonette
SW16 6QA - 436,000
- Leasehold Purpose built flat
SW16 6QA - 445,000
- Leasehold Flat/Maisonette
SW16 6QA - 394,000
- Freehold Purpose built flat
SW16 6QA - 419,000
- Leasehold Flat/Maisonette
SW16 6QA - 469,000
- Leasehold Purpose built flat
SW16 6QA - 449,000
- Leasehold Purpose built flat
SW16 6QA - 433,000
- Leasehold Flat/Maisonette
SW16 6QA - 439,000
- Leasehold Purpose built flat
SW16 6QA - 417,000
- Leasehold Purpose built flat
SW16 6QA - 445,000
- Leasehold Purpose built flat
SW16 6QA - 436,000
- Leasehold Purpose built flat
SW16 6QA - 451,000
- Leasehold Flat/Maisonette
SW16 6QA - 382,000
- Leasehold Converted flat
SW16 6QA - 426,000
- Freehold Flat/Maisonette
SW16 6QA - 426,000
- Leasehold Purpose built flat
SW16 6QA - 449,000
- Leasehold Flat/Maisonette
SW16 6QA - 423,000
- Freehold Purpose built flat
SW16 6QA - 465,000
- Leasehold Purpose built flat
SW16 6QA - 405,000
- Leasehold Purpose built flat
SW16 6QA - 451,000
- Leasehold Converted flat
SW16 6QA - 431,000
- Leasehold Purpose built flat
SW16 6QA - 522,000
- Leasehold Purpose built flat
SW16 6QA - 432,000
- Freehold Flat/Maisonette
SW16 6QA - 444,000
- Leasehold Purpose built flat
SW16 6QA - 470,000
- Leasehold Purpose built flat
SW16 6QA - 450,000
- Leasehold Purpose built flat
SW16 6QA - 437,000
- Leasehold Converted flat
SW16 6QA - 438,000
- Leasehold Converted flat
SW16 6QA - 433,000
- Leasehold Purpose built flat