SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='W1S 3NB' order by fulladdress
W1S 3NB - 3,935,000
- Leasehold Flat/Maisonette
W1S 3NB - 4,273,000
- Leasehold Flat/Maisonette
W1S 3NB - 4,142,000
- Leasehold Flat/Maisonette
W1S 3NB - 4,274,000
- Leasehold Flat/Maisonette
W1S 3NB - 4,325,000
- Leasehold Flat/Maisonette
W1S 3NB - 4,605,000
- Leasehold Flat/Maisonette
W1S 3NB - 4,080,000
- Leasehold Flat/Maisonette
W1S 3NB - 4,005,000
- Leasehold Flat/Maisonette
W1S 3NB - 4,668,000
- Leasehold Flat/Maisonette
W1S 3NB - 5,582,000
- Leasehold Flat/Maisonette
W1S 3NB - 3,926,000
- Leasehold Flat/Maisonette
W1S 3NB - 3,920,000
- Leasehold Flat/Maisonette
W1S 3NB - 4,505,000
- Leasehold Flat/Maisonette
W1S 3NB - 3,947,000
- Leasehold Flat/Maisonette
W1S 3NB - 3,795,000
- Leasehold Flat/Maisonette
W1S 3NB - 5,012,000
- Leasehold Flat/Maisonette
W1S 3NB - 4,189,000
- Leasehold Flat/Maisonette
W1S 3NB - 4,177,000
- Leasehold Flat/Maisonette
W1S 3NB - 4,578,000
- Leasehold Flat/Maisonette
W1S 3NB - 4,914,000
- Leasehold Purpose built flat
W1S 3NB - 4,227,000
- Leasehold Flat/Maisonette
W1S 3NB - 4,106,000
- Leasehold Flat/Maisonette
W1S 3NB - 5,354,000
- Leasehold Flat/Maisonette
W1S 3NB - 4,191,000
- Leasehold Flat/Maisonette
W1S 3NB - 4,136,000
- Leasehold Flat/Maisonette
W1S 3NB - 4,783,000
- Leasehold Flat/Maisonette
W1S 3NB - 4,819,000
- Leasehold Flat/Maisonette
W1S 3NB - 4,662,000
- Leasehold Flat/Maisonette
W1S 3NB - 4,621,000
- Leasehold Flat/Maisonette
W1S 3NB - 4,693,000
- Leasehold Flat/Maisonette
W1S 3NB - 5,336,000
- Leasehold Flat/Maisonette
W1S 3NB - 4,877,000
- Leasehold Flat/Maisonette
W1S 3NB - 4,733,000
- Leasehold Flat/Maisonette
W1S 3NB - 4,932,000
- Leasehold Flat/Maisonette
W1S 3NB - 4,571,000
- Leasehold Flat/Maisonette
W1S 3NB - 4,549,000
- Leasehold Flat/Maisonette
W1S 3NB - 4,616,000
- Leasehold Flat/Maisonette