SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SW2 5TX' order by fulladdress
SW2 5TX - 394,000
- Leasehold Purpose built flat
SW2 5TX - 345,000
- Leasehold Purpose built flat
SW2 5TX - 385,000
- Leasehold Purpose built flat
SW2 5TX - 312,000
- Leasehold Purpose built flat
SW2 5TX - 375,000
- Leasehold Purpose built flat
SW2 5TX - 340,000
- Leasehold Purpose built flat
SW2 5TX - 350,000
- Feudal Purpose built flat
SW2 5TX - 400,000
- Leasehold Flat/Maisonette
SW2 5TX - 369,000
- Leasehold Purpose built flat
SW2 5TX - 338,000
- Leasehold Purpose built flat
SW2 5TX - 340,000
- Leasehold Purpose built flat
SW2 5TX - 386,000
- Leasehold Purpose built flat
SW2 5TX - 370,000
- Leasehold Purpose built flat
SW2 5TX - 373,000
- Leasehold Purpose built flat
SW2 5TX - 403,000
- Leasehold Purpose built flat
SW2 5TX - 360,000
- Leasehold Purpose built flat
SW2 5TX - 410,000
- Leasehold Flat/Maisonette
SW2 5TX - 406,000
- Leasehold Flat/Maisonette
SW2 5TX - 314,000
- Leasehold Purpose built flat
SW2 5TX - 332,000
- Leasehold Flat/Maisonette
SW2 5TX - 404,000
- Leasehold Purpose built flat
SW2 5TX - 406,000
- Leasehold Converted flat
SW2 5TX - 304,000
- Leasehold Flat/Maisonette
SW2 5TX - 401,000
- Freehold Purpose built flat
SW2 5TX - 391,000
- Leasehold Purpose built flat
SW2 5TX - 344,000
- Leasehold Purpose built flat
SW2 5TX - 328,000
- Leasehold Purpose built flat
SW2 5TX - 380,000
- Leasehold Purpose built flat
SW2 5TX - 325,000
- Leasehold Purpose built flat
SW2 5TX - 387,000
- Leasehold Purpose built flat
SW2 5TX - 350,000
- Leasehold Flat/Maisonette
SW2 5TX - 312,000
- Leasehold Flat/Maisonette
SW2 5TX - 404,000
- Leasehold Purpose built flat
SW2 5TX - 399,000
- Leasehold Purpose built flat
SW2 5TX - 407,000
- Leasehold Purpose built flat
SW2 5TX - 328,000
- Leasehold Converted flat
SW2 5TX - 390,000
- Leasehold Purpose built flat
SW2 5TX - 397,000
- Leasehold Flat/Maisonette
SW2 5TX - 322,000
- Leasehold Flat/Maisonette
SW2 5TX - 326,000
- Leasehold Flat/Maisonette
SW2 5TX - 385,000
- Leasehold Purpose built flat
SW2 5TX - 376,000
- Leasehold Purpose built flat
SW2 5TX - 385,000
- Leasehold Purpose built flat
SW2 5TX - 404,000
- Leasehold Flat/Maisonette
SW2 5TX - 334,000
- Leasehold Purpose built flat
SW2 5TX - 393,000
- Leasehold Purpose built flat
SW2 5TX - 634,000
- Leasehold Purpose built flat
SW2 5TX - 620,000
- Leasehold Purpose built flat
SW2 5TX - 587,000
- Leasehold Purpose built flat
SW2 5TX - 752,000
- Leasehold Purpose built flat
SW2 5TX - 623,000
- Leasehold Purpose built flat
SW2 5TX - 584,000
- Leasehold Purpose built flat
SW2 5TX - 579,000
- Leasehold Converted flat
SW2 5TX - 669,000
- Leasehold Converted flat
SW2 5TX - 639,000
- Leasehold Purpose built flat