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 2DQ' order by fulladdress
W2 2DQ - 655,000
- Leasehold Flat/Maisonette
W2 2DQ - 573,000
- Leasehold Flat/Maisonette
W2 2DQ - 739,000
- Leasehold Flat/Maisonette
W2 2DQ - 596,000
- Leasehold Flat/Maisonette
W2 2DQ - 578,000
- Leasehold Flat/Maisonette
W2 2DQ - 755,000
- Leasehold Flat/Maisonette
W2 2DQ - 716,000
- Leasehold Flat/Maisonette
W2 2DQ - 636,000
- Leasehold Flat/Maisonette
W2 2DQ - 771,000
- Leasehold Flat/Maisonette
W2 2DQ - 587,000
- Leasehold Purpose built flat
W2 2DQ - 581,000
- Leasehold Flat/Maisonette
W2 2DQ - 567,000
- Leasehold Flat/Maisonette
W2 2DQ - 784,000
- Leasehold Flat/Maisonette
W2 2DQ - 702,000
- Leasehold Flat/Maisonette
W2 2DQ - 575,000
- Leasehold Purpose built flat
W2 2DQ - 0
- Leasehold Purpose built flat
W2 2DQ - 651,000
- Leasehold Purpose built flat