SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='LS17 8XW' order by fulladdress
LS17 8XW - 505,000
- Freehold Detached house
LS17 8XW - 448,000
- Freehold Detached property
LS17 8XW - 373,000
- Freehold Detached bungalow
LS17 8XW - 484,000
- Freehold Detached house
LS17 8XW - 499,000
- Freehold Detached house
LS17 8XW - 454,000
- Freehold Detached house
LS17 8XW - 406,000
- Freehold Detached bungalow
LS17 8XW - 529,000
- Freehold Detached property
LS17 8XW - 494,000
- Freehold Detached property
LS17 8XW - 479,000
- Freehold Detached house
LS17 8XW - 491,000
- Freehold Detached house
LS17 8XW - 493,000
- Freehold Detached house
LS17 8XW - 539,000
- Freehold Detached house
LS17 8XW - 440,000
- Freehold Detached house
LS17 8XW - 606,000
- Freehold Detached house
LS17 8XW - 178,000
- Leasehold Purpose built flat
LS17 8XW - 491,000
- Freehold Detached house
LS17 8XW - 174,000
- Leasehold Purpose built flat
LS17 8XW - 505,000
- Freehold Detached house
LS17 8XW - 182,000
- Leasehold Flat/Maisonette
LS17 8XW - 451,000
- Freehold Detached house
LS17 8XW - 179,000
- Leasehold Purpose built flat
LS17 8XW - 454,000
- Freehold Detached house
LS17 8XW - 338,000
- Leasehold Semi-detached property
LS17 8XW - 182,000
- Leasehold Flat/Maisonette
LS17 8XW - 437,000
- Freehold Detached bungalow
LS17 8XW - 183,000
- Leasehold Purpose built flat
LS17 8XW - 180,000
- Leasehold Purpose built flat
LS17 8XW - 454,000
- Freehold Detached bungalow
LS17 8XW - 506,000
- Freehold Detached bungalow
LS17 8XW - 564,000
- Freehold Detached house
LS17 8XW - 569,000
- Freehold Detached property
LS17 8XW - 555,000
- Freehold Detached house
LS17 8XW - 433,000
- Freehold Detached bungalow
