SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SL5 7QR' order by fulladdress
SL5 7QR - 588,000
- Freehold Semi-detached house
SL5 7QR - 686,000
- Semi-detached house
SL5 7QR - 879,000
- Freehold Semi-detached house
SL5 7QR - 1,144,000
- Freehold Detached house
SL5 7QR - 516,000
- Freehold Mid terrace house
SL5 7QR - 598,000
- Freehold Terrace property
SL5 7QR - 778,000
- Freehold Semi-detached property
SL5 7QR - 880,000
- Freehold Semi-detached house
SL5 7QR - 722,000
- Freehold Semi-detached house
SL5 7QR - 782,000
- Freehold Semi-detached house
SL5 7QR - 892,000
- Freehold Semi-detached house
SL5 7QR - 638,000
- Share of freehold Bungalow property
SL5 7QR - 782,000
- Freehold Semi-detached house
SL5 7QR - 501,000
- Freehold Mid terrace house
SL5 7QR - 554,000
- Freehold End terrace house
SL5 7QR - 1,302,000
- Freehold Detached property
SL5 7QR - 903,000
- Freehold Semi-detached house
SL5 7QR - 478,000
- Freehold Terrace property
SL5 7QR - 402,000
- Freehold Terrace property
SL5 7QR - 689,000
- Freehold Semi-detached house
SL5 7QR - 728,000
- Freehold Detached house
SL5 7QR - 1,333,000
- Freehold Detached house
SL5 7QR - 698,000
- Freehold End terrace house
SL5 7QR - 611,000
- Freehold Semi-detached house
SL5 7QR - 1,116,000
- Freehold Detached property
SL5 7QR - 1,469,000
- Freehold Detached house
SL5 7QR - 846,000
- Freehold Detached house
SL5 7QR - 1,149,000
- Freehold Detached house
SL5 7QR - 729,000
- Freehold Semi-detached house
SL5 7QR - 1,205,000
- Freehold Semi-detached house
SL5 7QR - 1,095,000
- Freehold Detached house
SL5 7QR - 935,000
- Freehold Bungalow property
