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 3UD' order by fulladdress
SW2 3UD - 315,000
- Leasehold Purpose built flat
SW2 3UD - 349,000
- Leasehold Flat/Maisonette
SW2 3UD - 301,000
- Leasehold Flat/Maisonette
SW2 3UD - 233,000
- Leasehold Flat/Maisonette
SW2 3UD - 326,000
- Leasehold Converted flat
SW2 3UD - 382,000
- Leasehold Purpose built flat
SW2 3UD - 359,000
- Leasehold Flat/Maisonette
SW2 3UD - 378,000
- Leasehold Flat/Maisonette
SW2 3UD - 386,000
- Leasehold Purpose built flat
SW2 3UD - 320,000
- Leasehold Purpose built flat
SW2 3UD - 251,000
- Leasehold Purpose built flat
SW2 3UD - 319,000
- Share of freehold Purpose built flat
SW2 3UD - 385,000
- Leasehold Converted flat
SW2 3UD - 385,000
- Leasehold Flat/Maisonette
SW2 3UD - 417,000
- Leasehold Converted flat
SW2 3UD - 365,000
- Leasehold Purpose built flat
SW2 3UD - 303,000
- Leasehold Flat/Maisonette
SW2 3UD - 228,000
- Leasehold Flat/Maisonette
SW2 3UD - 362,000
- Leasehold Purpose built flat
SW2 3UD - 379,000
- Leasehold Purpose built flat
SW2 3UD - 334,000
- Leasehold Purpose built flat
SW2 3UD - 315,000
- Leasehold Purpose built flat
SW2 3UD - 322,000
- Leasehold Flat/Maisonette
SW2 3UD - 327,000
- Leasehold Flat/Maisonette
SW2 3UD - 310,000
- Leasehold Flat/Maisonette
SW2 3UD - 433,000
- Leasehold Flat/Maisonette
SW2 3UD - 371,000
- Leasehold Purpose built flat
SW2 3UD - 369,000
- Leasehold Purpose built flat
SW2 3UD - 299,000
- Leasehold Flat/Maisonette
SW2 3UD - 211,000
- Leasehold Flat/Maisonette
SW2 3UD - 326,000
- Leasehold Purpose built flat
SW2 3UD - 313,000
- Leasehold Purpose built flat
SW2 3UD - 335,000
- Leasehold Purpose built flat
SW2 3UD - 354,000
- Leasehold Flat/Maisonette
SW2 3UD - 315,000
- Leasehold Purpose built flat
SW2 3UD - 325,000
- Leasehold Purpose built flat
SW2 3UD - 492,000
- Leasehold Purpose built flat
SW2 3UD - 202,000
- Leasehold Flat/Maisonette
SW2 3UD - 299,000
- Leasehold Flat/Maisonette
SW2 3UD - 313,000
- Leasehold Flat/Maisonette
SW2 3UD - 364,000
- Leasehold Purpose built flat
SW2 3UD - 335,000
- Leasehold Flat/Maisonette