SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='W1K 5HJ' order by fulladdress
W1K 5HJ - 720,000
- Leasehold Flat/Maisonette
W1K 5HJ - 0
- Leasehold Purpose built flat
W1K 5HJ - 875,000
- Leasehold Purpose built flat
W1K 5HJ - 931,000
- Leasehold Flat/Maisonette
W1K 5HJ - 779,000
- Leasehold Flat/Maisonette
W1K 5HJ - 679,000
- Leasehold Flat/Maisonette
W1K 5HJ - 773,000
- Leasehold Flat/Maisonette
W1K 5HJ - 741,000
- Leasehold Flat/Maisonette
W1K 5HJ - 803,000
- Leasehold Flat/Maisonette
W1K 5HJ - 902,000
- Leasehold Purpose built flat
W1K 5HJ - 647,000
- Leasehold Flat/Maisonette
W1K 5HJ - 685,000
- Leasehold Flat/Maisonette
W1K 5HJ - 777,000
- Leasehold Flat/Maisonette
W1K 5HJ - 768,000
- Leasehold Flat/Maisonette
W1K 5HJ - 690,000
- Leasehold Flat/Maisonette
W1K 5HJ - 698,000
- Leasehold Flat/Maisonette
W1K 5HJ - 673,000
- Leasehold Purpose built flat
W1K 5HJ - 690,000
- Freehold Flat/Maisonette
W1K 5HJ - 675,000
- Leasehold Purpose built flat
W1K 5HJ - 718,000
- Leasehold Flat/Maisonette
W1K 5HJ - 959,000
- Leasehold Purpose built flat
W1K 5HJ - 683,000
- Leasehold Flat/Maisonette