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 2QB' order by fulladdress
W2 2QB - 2,691,000
- Leasehold Purpose built flat
W2 2QB - 2,775,000
- Leasehold Flat/Maisonette
W2 2QB - 1,495,000
- Leasehold Flat/Maisonette
W2 2QB - 2,261,000
- Leasehold Flat/Maisonette
W2 2QB - 3,117,000
- Leasehold Purpose built flat
W2 2QB - 1,927,000
- Leasehold Flat/Maisonette
W2 2QB - 2,573,000
- Flat/Maisonette
W2 2QB - 2,248,000
- Leasehold Flat/Maisonette
W2 2QB - 2,068,000
- Leasehold Flat/Maisonette
W2 2QB - 1,669,000
- Flat/Maisonette
W2 2QB - 2,202,000
- Leasehold Flat/Maisonette
W2 2QB - 1,518,000
- Feudal Purpose built flat
W2 2QB - 1,998,000
- Leasehold Flat/Maisonette
W2 2QB - 2,505,000
- Leasehold Flat/Maisonette
W2 2QB - 1,506,000
- Leasehold Purpose built flat
W2 2QB - 2,706,000
- Leasehold Purpose built flat
W2 2QB - 2,700,000
- Flat/Maisonette
W2 2QB - 1,982,000
- Flat/Maisonette
W2 2QB - 2,785,000
- Leasehold Flat/Maisonette
W2 2QB - 2,579,000
- Leasehold Flat/Maisonette
W2 2QB - 1,722,000
- Leasehold Flat/Maisonette
W2 2QB - 2,310,000
- Leasehold Flat/Maisonette
W2 2QB - 1,546,000
- Leasehold Flat/Maisonette
W2 2QB - 2,783,000
- Leasehold Purpose built flat
W2 2QB - 1,997,000
- Leasehold Flat/Maisonette
W2 2QB - 2,651,000
- Leasehold Flat/Maisonette