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 5BE' order by fulladdress
W2 5BE - 3,667,000
- Freehold Mid terrace house
W2 5BE - 1,293,000
- Share of freehold Converted flat
W2 5BE - 3,231,000
- Freehold Mid terrace house
W2 5BE - 3,041,000
- Freehold Mid terrace house
W2 5BE - 3,593,000
- Freehold Mid terrace house
W2 5BE - 3,328,000
- Freehold Terraced
W2 5BE - 3,448,000
- Freehold Terrace property
W2 5BE - 3,024,000
- Mid terrace house
W2 5BE - 3,489,000
- Freehold Mid terrace house
W2 5BE - 1,633,000
- Leasehold Converted flat
W2 5BE - 2,357,000
- Freehold Terraced
W2 5BE - 682,000
- Leasehold Flat/Maisonette
W2 5BE - 743,000
- Leasehold Converted flat
W2 5BE - 647,000
- Leasehold Converted flat
W2 5BE - 707,000
- Leasehold Converted flat
W2 5BE - 3,425,000
- Freehold Mid terrace house
W2 5BE - 3,482,000
- Freehold Mid terrace house
W2 5BE - 3,300,000
- Freehold Terrace property
W2 5BE - 3,531,000
- Freehold Mid terrace house
W2 5BE - 3,542,000
- Freehold Mid terrace house
W2 5BE - 3,495,000
- Freehold Mid terrace house
W2 5BE - 1,103,000
- Leasehold Converted flat
W2 5BE - 3,326,000
- Freehold Semi-detached house
W2 5BE - 1,129,000
- Flat/Maisonette
W2 5BE - 1,077,000
- Freehold Flat/Maisonette
W2 5BE - 1,177,000
- Flat/Maisonette
W2 5BE - 0
- Freehold Flat/Maisonette
W2 5BE - 582,000
- Leasehold Flat/Maisonette
W2 5BE - 1,111,000
- Flat/Maisonette
W2 5BE - 986,000
- Leasehold Flat/Maisonette
W2 5BE - 780,000
- Leasehold Converted flat
W2 5BE - 654,000
- Leasehold Flat/Maisonette
