SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='W2 2QG' order by fulladdress
W2 2QG - 888,000
- Leasehold Purpose built flat
W2 2QG - 592,000
- Leasehold Flat/Maisonette
W2 2QG - 720,000
- Leasehold Flat/Maisonette
W2 2QG - 497,000
- Leasehold Purpose built flat
W2 2QG - 602,000
- Leasehold Flat/Maisonette
W2 2QG - 673,000
- Leasehold Flat/Maisonette
W2 2QG - 599,000
- Leasehold Purpose built flat
W2 2QG - 905,000
- Leasehold Flat/Maisonette
W2 2QG - 580,000
- Leasehold Flat/Maisonette
W2 2QG - 581,000
- Leasehold Flat/Maisonette
W2 2QG - 525,000
- Leasehold Flat/Maisonette
W2 2QG - 824,000
- Leasehold Flat/Maisonette
W2 2QG - 505,000
- Leasehold Flat/Maisonette
W2 2QG - 499,000
- Leasehold Purpose built flat
W2 2QG - 623,000
- Leasehold Flat/Maisonette
W2 2QG - 487,000
- Leasehold Purpose built flat
W2 2QG - 839,000
- Leasehold Flat/Maisonette
W2 2QG - 685,000
- Leasehold Purpose built flat
W2 2QG - 490,000
- Leasehold Purpose built flat
W2 2QG - 544,000
- Leasehold Flat/Maisonette
W2 2QG - 578,000
- Leasehold Flat/Maisonette
W2 2QG - 493,000
- Leasehold Flat/Maisonette
W2 2QG - 901,000
- Leasehold Flat/Maisonette
W2 2QG - 687,000
- Leasehold Flat/Maisonette
W2 2QG - 496,000
- Leasehold Purpose built flat
W2 2QG - 503,000
- Leasehold Flat/Maisonette
W2 2QG - 512,000
- Leasehold Flat/Maisonette
W2 2QG - 466,000
- Leasehold Flat/Maisonette
W2 2QG - 673,000
- Leasehold Purpose built flat
W2 2QG - 626,000
- Leasehold Flat/Maisonette
W2 2QG - 580,000
- Share of freehold Flat/Maisonette
W2 2QG - 566,000
- Leasehold Flat/Maisonette
