SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='W9 1TS' order by fulladdress
W9 1TS - 1,750,000
- Leasehold Purpose built flat
W9 1TS - 1,510,000
- Flat/Maisonette
W9 1TS - 1,086,000
- Leasehold Purpose built flat
W9 1TS - 1,822,000
- Leasehold Purpose built flat
W9 1TS - 1,221,000
- Leasehold Flat/Maisonette
W9 1TS - 1,792,000
- Leasehold Purpose built flat
W9 1TS - 1,026,000
- Leasehold Flat/Maisonette
W9 1TS - 1,121,000
- Feudal Purpose built flat
W9 1TS - 1,394,000
- Leasehold Flat/Maisonette
W9 1TS - 961,000
- Leasehold Purpose built flat
W9 1TS - 793,000
- Leasehold Flat/Maisonette
W9 1TS - 1,158,000
- Feudal Purpose built flat
W9 1TS - 1,850,000
- Flat/Maisonette
W9 1TS - 1,200,000
- Leasehold Purpose built flat
W9 1TS - 1,411,000
- Leasehold Flat/Maisonette
W9 1TS - 1,434,000
- Leasehold Flat/Maisonette
W9 1TS - 1,154,000
- Leasehold Flat/Maisonette
W9 1TS - 769,000
- Leasehold Flat/Maisonette
W9 1TS - 1,437,000
- Leasehold Purpose built flat
W9 1TS - 1,083,000
- Flat/Maisonette
W9 1TS - 1,298,000
- Leasehold Purpose built flat
W9 1TS - 1,592,000
- Leasehold Purpose built flat
W9 1TS - 996,000
- Leasehold Flat/Maisonette
W9 1TS - 1,534,000
- Flat/Maisonette
