SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='W8 5SJ' order by fulladdress
W8 5SJ - 1,512,000
- Leasehold Flat/Maisonette
W8 5SJ - 1,731,000
- Leasehold Flat/Maisonette
W8 5SJ - 1,515,000
- Leasehold Purpose built flat
W8 5SJ - 1,589,000
- Leasehold Flat/Maisonette
W8 5SJ - 1,688,000
- Leasehold Flat/Maisonette
W8 5SJ - 1,483,000
- Leasehold Flat/Maisonette
W8 5SJ - 1,786,000
- Leasehold Flat/Maisonette
W8 5SJ - 1,782,000
- Leasehold Flat/Maisonette
W8 5SJ - 1,744,000
- Leasehold Flat/Maisonette
W8 5SJ - 1,691,000
- Leasehold Flat/Maisonette
W8 5SJ - 1,813,000
- Leasehold Flat/Maisonette
W8 5SJ - 1,660,000
- Feudal Purpose built flat
W8 5SJ - 1,878,000
- Leasehold Flat/Maisonette
W8 5SJ - 1,573,000
- Leasehold Flat/Maisonette
W8 5SJ - 1,531,000
- Leasehold Flat/Maisonette
W8 5SJ - 1,622,000
- Leasehold Purpose built flat
W8 5SJ - 1,599,000
- Leasehold Flat/Maisonette
W8 5SJ - 1,795,000
- Leasehold Flat/Maisonette
W8 5SJ - 1,849,000
- Leasehold Flat/Maisonette
W8 5SJ - 1,750,000
- Leasehold Flat/Maisonette
W8 5SJ - 1,656,000
- Leasehold Flat/Maisonette
W8 5SJ - 1,598,000
- Leasehold Flat/Maisonette
W8 5SJ - 1,513,000
- Leasehold Flat/Maisonette
W8 5SJ - 1,654,000
- Leasehold Flat/Maisonette
W8 5SJ - 2,003,000
- Leasehold Flat/Maisonette
W8 5SJ - 1,656,000
- Leasehold Converted flat
W8 5SJ - 1,762,000
- Leasehold Flat/Maisonette
W8 5SJ - 1,672,000
- Leasehold Flat/Maisonette
W8 5SJ - 2,100,000
- Leasehold Flat/Maisonette
W8 5SJ - 1,857,000
- Leasehold Flat/Maisonette
W8 5SJ - 1,827,000
- Leasehold Flat/Maisonette
W8 5SJ - 1,738,000
- Leasehold Flat/Maisonette
W8 5SJ - 1,404,000
- Leasehold Purpose built flat
W8 5SJ - 2,316,000
- Leasehold Flat/Maisonette
W8 5SJ - 1,839,000
- Leasehold Flat/Maisonette
W8 5SJ - 1,706,000
- Leasehold Flat/Maisonette
W8 5SJ - 1,739,000
- Leasehold Flat/Maisonette
W8 5SJ - 1,097,000
- Leasehold Purpose built flat
W8 5SJ - 3,675,000
- Leasehold Flat/Maisonette
W8 5SJ - 1,640,000
- Leasehold Flat/Maisonette
W8 5SJ - 2,540,000
- Leasehold Flat/Maisonette
W8 5SJ - 2,473,000
- Leasehold Flat/Maisonette
W8 5SJ - 2,080,000
- Leasehold Flat/Maisonette