SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='WS4 2EB' order by fulladdress
WS4 2EB - 497,000
- Freehold Detached house
WS4 2EB - 522,000
- Freehold Semi-detached house
WS4 2EB - 553,000
- Freehold Semi-detached house
WS4 2EB - 674,000
- Freehold Semi-detached house
WS4 2EB - 638,000
- Freehold Semi-detached property
WS4 2EB - 592,000
- Freehold Detached house
WS4 2EB - 633,000
- Freehold Detached house
WS4 2EB - 602,000
- Freehold Detached house
WS4 2EB - 576,000
- Freehold Detached house
WS4 2EB - 556,000
- Freehold Detached property
WS4 2EB - 601,000
- Freehold Detached house
WS4 2EB - 630,000
- Freehold Detached property
WS4 2EB - 677,000
- Freehold Detached property
WS4 2EB - 429,000
- Freehold Detached house
WS4 2EB - 387,000
- Freehold Detached house
WS4 2EB - 190,000
- Leasehold Flat/Maisonette
WS4 2EB - 192,000
- Leasehold Flat/Maisonette
WS4 2EB - 193,000
- Leasehold Flat/Maisonette
WS4 2EB - 192,000
- Leasehold Flat/Maisonette
WS4 2EB - 188,000
- Leasehold Flat/Maisonette
WS4 2EB - 180,000
- Leasehold Flat/Maisonette
WS4 2EB - 191,000
- Leasehold Flat/Maisonette
WS4 2EB - 192,000
- Leasehold Flat/Maisonette
WS4 2EB - 190,000
- Leasehold Flat/Maisonette
WS4 2EB - 185,000
- Leasehold Flat/Maisonette
WS4 2EB - 179,000
- Leasehold Flat/Maisonette
WS4 2EB - 195,000
- Leasehold Flat/Maisonette
WS4 2EB - 183,000
- Leasehold Flat/Maisonette
WS4 2EB - 187,000
- Leasehold Flat/Maisonette
WS4 2EB - 185,000
- Leasehold Flat/Maisonette
WS4 2EB - 189,000
- Leasehold Flat/Maisonette
WS4 2EB - 204,000
- Leasehold Flat/Maisonette
WS4 2EB - 169,000
- Leasehold Purpose built flat
WS4 2EB - 182,000
- Leasehold Flat/Maisonette
WS4 2EB - 191,000
- Leasehold Flat/Maisonette
WS4 2EB - 182,000
- Leasehold Flat/Maisonette
WS4 2EB - 183,000
- Leasehold Purpose built flat
WS4 2EB - 196,000
- Leasehold Flat/Maisonette
WS4 2EB - 183,000
- Leasehold Flat/Maisonette
WS4 2EB - 183,000
- Leasehold Purpose built flat
WS4 2EB - 148,000
- Leasehold Flat/Maisonette
WS4 2EB - 135,000
- Leasehold Flat/Maisonette
WS4 2EB - 154,000
- Leasehold Flat/Maisonette
WS4 2EB - 143,000
- Leasehold Flat/Maisonette
WS4 2EB - 153,000
- Leasehold Flat/Maisonette
WS4 2EB - 144,000
- Leasehold Flat/Maisonette