SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='W2 1PB' order by fulladdress
W2 1PB - 632,000
- Leasehold Flat/Maisonette
W2 1PB - 1,108,000
- Leasehold Flat/Maisonette
W2 1PB - 1,169,000
- Leasehold Purpose built flat
W2 1PB - 902,000
- Leasehold Flat/Maisonette
W2 1PB - 1,054,000
- Leasehold Flat/Maisonette
W2 1PB - 816,000
- Leasehold Flat/Maisonette
W2 1PB - 841,000
- Leasehold Flat/Maisonette
W2 1PB - 838,000
- Leasehold Flat/Maisonette
W2 1PB - 836,000
- Leasehold Flat/Maisonette
W2 1PB - 1,143,000
- Leasehold Flat/Maisonette
W2 1PB - 1,109,000
- Leasehold Flat/Maisonette
W2 1PB - 1,155,000
- Leasehold Flat/Maisonette
W2 1PB - 1,126,000
- Leasehold Flat/Maisonette
W2 1PB - 1,110,000
- Flat/Maisonette
W2 1PB - 1,140,000
- Flat/Maisonette
W2 1PB - 895,000
- Leasehold Purpose built flat
W2 1PB - 1,030,000
- Leasehold Purpose built flat
W2 1PB - 1,075,000
- Leasehold Flat/Maisonette
W2 1PB - 1,157,000
- Leasehold Purpose built flat
W2 1PB - 857,000
- Leasehold Flat/Maisonette
W2 1PB - 1,042,000
- Leasehold Purpose built flat
W2 1PB - 1,242,000
- Leasehold Flat/Maisonette
W2 1PB - 1,098,000
- Leasehold Flat/Maisonette
W2 1PB - 886,000
- Leasehold Flat/Maisonette
W2 1PB - 877,000
- Leasehold Purpose built flat
W2 1PB - 822,000
- Leasehold Flat/Maisonette
W2 1PB - 1,061,000
- Leasehold Flat/Maisonette
W2 1PB - 1,149,000
- Leasehold Purpose built flat
W2 1PB - 1,096,000
- Leasehold Flat/Maisonette
W2 1PB - 909,000
- Leasehold Flat/Maisonette
W2 1PB - 1,074,000
- Leasehold Flat/Maisonette
W2 1PB - 828,000
- Leasehold Flat/Maisonette
W2 1PB - 1,053,000
- Leasehold Purpose built flat
W2 1PB - 839,000
- Leasehold Flat/Maisonette
W2 1PB - 1,039,000
- Leasehold Flat/Maisonette
W2 1PB - 1,138,000
- Leasehold Purpose built flat
W2 1PB - 877,000
- Leasehold Flat/Maisonette
W2 1PB - 1,098,000
- Leasehold Flat/Maisonette
W2 1PB - 1,051,000
- Leasehold Purpose built flat
W2 1PB - 1,093,000
- Leasehold Purpose built flat
W2 1PB - 918,000
- Leasehold Flat/Maisonette
W2 1PB - 1,096,000
- Leasehold Purpose built flat
W2 1PB - 1,191,000
- Leasehold Flat/Maisonette
W2 1PB - 1,049,000
- Leasehold Flat/Maisonette
W2 1PB - 1,081,000
- Flat/Maisonette
W2 1PB - 1,083,000
- Leasehold Flat/Maisonette
W2 1PB - 833,000
- Leasehold Flat/Maisonette
W2 1PB - 999,000
- Leasehold Flat/Maisonette
W2 1PB - 1,032,000
- Leasehold Flat/Maisonette
W2 1PB - 1,171,000
- Leasehold Flat/Maisonette
W2 1PB - 1,206,000
- Leasehold Purpose built flat
W2 1PB - 1,063,000
- Leasehold Flat/Maisonette
W2 1PB - 1,105,000
- Leasehold Flat/Maisonette
W2 1PB - 1,179,000
- Leasehold Purpose built flat
W2 1PB - 1,255,000
- Leasehold Flat/Maisonette
W2 1PB - 1,089,000
- Leasehold Flat/Maisonette
W2 1PB - 1,081,000
- Leasehold Flat/Maisonette
W2 1PB - 1,208,000
- Leasehold Flat/Maisonette
W2 1PB - 1,130,000
- Leasehold Flat/Maisonette
W2 1PB - 1,153,000
- Leasehold Flat/Maisonette
W2 1PB - 1,056,000
- Flat/Maisonette
W2 1PB - 1,139,000
- Leasehold Flat/Maisonette