SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='WS11 1JZ' order by fulladdress
WS11 1JZ - 138,000
- Leasehold Converted flat
WS11 1JZ - 117,000
- Leasehold Flat/Maisonette
WS11 1JZ - 397,000
- Freehold Detached house
WS11 1JZ - 399,000
- Freehold Detached house
WS11 1JZ - 121,000
- Leasehold Flat/Maisonette
WS11 1JZ - 445,000
- Freehold Detached house
WS11 1JZ - 427,000
- Freehold Detached bungalow
WS11 1JZ - 142,000
- Leasehold Purpose built flat
WS11 1JZ - 396,000
- Freehold Detached house
WS11 1JZ - 124,000
- Leasehold Converted flat
WS11 1JZ - 272,000
- Freehold Semi-detached house
WS11 1JZ - 338,000
- Freehold Detached bungalow
WS11 1JZ - 355,000
- Freehold Semi-detached house
WS11 1JZ - 169,000
- Freehold Mid terrace house
WS11 1JZ - 134,000
- Leasehold Purpose built flat
WS11 1JZ - 182,000
- Freehold End terrace house
WS11 1JZ - 159,000
- Freehold Terrace property
WS11 1JZ - 321,000
- Freehold Semi-detached house
WS11 1JZ - 237,000
- Freehold Semi-detached house
WS11 1JZ - 468,000
- Freehold Detached house
WS11 1JZ - 381,000
- Freehold Detached property
WS11 1JZ - 349,000
- Freehold Detached property
WS11 1JZ - 337,000
- Freehold Detached house
WS11 1JZ - 334,000
- Freehold Detached house
WS11 1JZ - 348,000
- Freehold Detached house
WS11 1JZ - 444,000
- Freehold Detached house
WS11 1JZ - 262,000
- Freehold Semi-detached house
WS11 1JZ - 364,000
- Freehold Detached property
WS11 1JZ - 271,000
- Freehold Detached property
WS11 1JZ - 106,000
- Leasehold Flat/Maisonette
WS11 1JZ - 105,000
- Leasehold Flat/Maisonette
WS11 1JZ - 123,000
- Leasehold Flat/Maisonette
WS11 1JZ - 114,000
- Leasehold Flat/Maisonette
WS11 1JZ - 124,000
- Leasehold Flat/Maisonette
WS11 1JZ - 104,000
- Leasehold Flat/Maisonette
