SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='LS16 8BH' order by fulladdress
LS16 8BH - 715,000
- Freehold Detached house
LS16 8BH - 667,000
- Freehold Detached house
LS16 8BH - 677,000
- Freehold Detached house
LS16 8BH - 655,000
- Freehold Detached house
LS16 8BH - 674,000
- Freehold Detached house
LS16 8BH - 640,000
- Freehold Detached house
LS16 8BH - 613,000
- Freehold Detached house
LS16 8BH - 704,000
- Freehold Detached house
LS16 8BH - 635,000
- Freehold Detached house
LS16 8BH - 668,000
- Freehold Detached house
LS16 8BH - 538,000
- Freehold Detached house
LS16 8BH - 625,000
- Freehold Detached house
LS16 8BH - 706,000
- Freehold Detached property
LS16 8BH - 834,000
- Freehold Detached house
LS16 8BH - 592,000
- Freehold Detached house
LS16 8BH - 588,000
- Freehold Detached property
LS16 8BH - 565,000
- Freehold Detached house
LS16 8BH - 618,000
- Freehold Detached house
LS16 8BH - 659,000
- Freehold Detached house
