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 9PA' order by fulladdress
SL5 9PA - 730,000
- Freehold Detached house
SL5 9PA - 702,000
- Freehold Detached house
SL5 9PA - 733,000
- Freehold Semi-detached house
SL5 9PA - 779,000
- Freehold Semi-detached house
SL5 9PA - 1,116,000
- Freehold Detached bungalow
SL5 9PA - 927,000
- Freehold Detached property
SL5 9PA - 1,044,000
- Freehold Detached house
SL5 9PA - 524,000
- Semi-detached bungalow
SL5 9PA - 768,000
- Freehold Semi-detached house
SL5 9PA - 697,000
- Freehold Semi-detached house
SL5 9PA - 812,000
- Freehold Semi-detached house
SL5 9PA - 821,000
- Freehold Semi-detached house
SL5 9PA - 658,000
- Freehold Semi-detached house
SL5 9PA - 631,000
- Freehold Semi-detached house
SL5 9PA - 782,000
- Freehold Semi-detached house
SL5 9PA - 704,000
- Freehold Semi-detached house
SL5 9PA - 1,113,000
- Freehold Detached house
SL5 9PA - 1,087,000
- Freehold Detached house
SL5 9PA - 1,265,000
- Freehold Detached house
