SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='W14 0RR' order by fulladdress
W14 0RR - 1,441,000
- Leasehold Purpose built flat
W14 0RR - 1,753,000
- Leasehold Purpose built flat
W14 0RR - 1,757,000
- Leasehold Purpose built flat
W14 0RR - 1,432,000
- Leasehold Purpose built flat
W14 0RR - 1,365,000
- Leasehold Purpose built flat
W14 0RR - 1,356,000
- Leasehold Flat/Maisonette
W14 0RR - 1,379,000
- Leasehold Purpose built flat
W14 0RR - 1,368,000
- Leasehold Flat/Maisonette
W14 0RR - 1,313,000
- Leasehold Purpose built flat
W14 0RR - 1,141,000
- Leasehold Purpose built flat
W14 0RR - 683,000
- Leasehold Flat/Maisonette
W14 0RR - 1,336,000
- Leasehold Flat/Maisonette
W14 0RR - 1,319,000
- Leasehold Flat/Maisonette
W14 0RR - 1,266,000
- Leasehold Flat/Maisonette
W14 0RR - 1,273,000
- Leasehold Purpose built flat
W14 0RR - 741,000
- Leasehold Flat/Maisonette
W14 0RR - 1,443,000
- Leasehold Purpose built flat
W14 0RR - 1,313,000
- Leasehold Converted flat
W14 0RR - 1,124,000
- Leasehold Purpose built flat
W14 0RR - 689,000
- Leasehold Flat/Maisonette
W14 0RR - 1,462,000
- Leasehold Purpose built flat
W14 0RR - 1,199,000
- Leasehold Purpose built flat
W14 0RR - 844,000
- Leasehold Purpose built flat
W14 0RR - 1,516,000
- Leasehold Flat/Maisonette
W14 0RR - 1,347,000
- Leasehold Purpose built flat
W14 0RR - 672,000
- Leasehold Purpose built flat
W14 0RR - 1,203,000
- Leasehold Purpose built flat
W14 0RR - 1,479,000
- Leasehold Flat/Maisonette
W14 0RR - 685,000
- Leasehold Purpose built flat
W14 0RR - 1,100,000
- Leasehold Terrace property