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 1BE' order by fulladdress
W2 1BE - 863,000
- Leasehold Flat/Maisonette
W2 1BE - 828,000
- Leasehold Flat/Maisonette
W2 1BE - 1,330,000
- Leasehold Flat/Maisonette
W2 1BE - 1,410,000
- Leasehold Flat/Maisonette
W2 1BE - 2,093,000
- Leasehold Purpose built flat
W2 1BE - 1,352,000
- Leasehold Flat/Maisonette
W2 1BE - 860,000
- Leasehold Flat/Maisonette
W2 1BE - 1,356,000
- Leasehold Flat/Maisonette
W2 1BE - 1,428,000
- Leasehold Flat/Maisonette
W2 1BE - 1,259,000
- Leasehold Flat/Maisonette
W2 1BE - 828,000
- Leasehold Flat/Maisonette
W2 1BE - 754,000
- Leasehold Flat/Maisonette
W2 1BE - 1,608,000
- Leasehold Flat/Maisonette
W2 1BE - 1,628,000
- Leasehold Flat/Maisonette
W2 1BE - 1,927,000
- Leasehold Flat/Maisonette
W2 1BE - 1,793,000
- Leasehold Purpose built flat
W2 1BE - 1,915,000
- Leasehold Flat/Maisonette
W2 1BE - 1,735,000
- Leasehold Flat/Maisonette
W2 1BE - 1,820,000
- Leasehold Flat/Maisonette
W2 1BE - 1,851,000
- Leasehold Flat/Maisonette
W2 1BE - 1,783,000
- Leasehold Flat/Maisonette
W2 1BE - 3,088,000
- Leasehold Flat/Maisonette
W2 1BE - 877,000
- Leasehold Flat/Maisonette
W2 1BE - 890,000
- Leasehold Flat/Maisonette
W2 1BE - 1,261,000
- Leasehold Flat/Maisonette
W2 1BE - 1,264,000
- Leasehold Flat/Maisonette
W2 1BE - 1,239,000
- Leasehold Flat/Maisonette
W2 1BE - 1,310,000
- Leasehold Flat/Maisonette
W2 1BE - 878,000
- Leasehold Flat/Maisonette
W2 1BE - 842,000
- Leasehold Flat/Maisonette
W2 1BE - 1,244,000
- Leasehold Flat/Maisonette
W2 1BE - 1,261,000
- Leasehold Flat/Maisonette
W2 1BE - 1,266,000
- Leasehold Flat/Maisonette
W2 1BE - 1,331,000
- Leasehold Flat/Maisonette
W2 1BE - 874,000
- Leasehold Flat/Maisonette
W2 1BE - 872,000
- Leasehold Purpose built flat
W2 1BE - 1,273,000
- Leasehold Flat/Maisonette
W2 1BE - 1,265,000
- Leasehold Flat/Maisonette
W2 1BE - 1,258,000
- Leasehold Flat/Maisonette
W2 1BE - 1,339,000
- Leasehold Flat/Maisonette
W2 1BE - 867,000
- Leasehold Flat/Maisonette
W2 1BE - 910,000
- Leasehold Flat/Maisonette
W2 1BE - 1,262,000
- Leasehold Flat/Maisonette
W2 1BE - 1,273,000
- Leasehold Purpose built flat
W2 1BE - 1,309,000
- Leasehold Flat/Maisonette
W2 1BE - 886,000
- Leasehold Flat/Maisonette
W2 1BE - 944,000
- Leasehold Flat/Maisonette
W2 1BE - 1,278,000
- Leasehold Flat/Maisonette
W2 1BE - 1,345,000
- Leasehold Flat/Maisonette
W2 1BE - 1,295,000
- Leasehold Flat/Maisonette
W2 1BE - 1,348,000
- Leasehold Flat/Maisonette
W2 1BE - 1,639,000
- Leasehold Flat/Maisonette
W2 1BE - 1,445,000
- Leasehold Flat/Maisonette
W2 1BE - 1,314,000
- Leasehold Flat/Maisonette
W2 1BE - 1,329,000
- Leasehold Flat/Maisonette
W2 1BE - 1,655,000
- Leasehold Flat/Maisonette
W2 1BE - 1,383,000
- Leasehold Flat/Maisonette
W2 1BE - 1,326,000
- Leasehold Flat/Maisonette
W2 1BE - 1,294,000
- Leasehold Purpose built flat
W2 1BE - 1,944,000
- Leasehold Flat/Maisonette
W2 1BE - 1,672,000
- Leasehold Flat/Maisonette
W2 1BE - 1,840,000
- Leasehold Flat/Maisonette
W2 1BE - 1,701,000
- Leasehold Flat/Maisonette
W2 1BE - 1,933,000
- Leasehold Flat/Maisonette
W2 1BE - 1,700,000
- Leasehold Flat/Maisonette
W2 1BE - 1,755,000
- Leasehold Flat/Maisonette
W2 1BE - 1,657,000
- Leasehold Flat/Maisonette
W2 1BE - 942,000
- Leasehold Flat/Maisonette
W2 1BE - 1,270,000
- Leasehold Flat/Maisonette
W2 1BE - 866,000
- Leasehold Flat/Maisonette
W2 1BE - 1,272,000
- Leasehold Flat/Maisonette
W2 1BE - 1,331,000
- Leasehold Flat/Maisonette