SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SL7 3HB' order by fulladdress
SL7 3HB - 732,000
- Freehold Semi-detached house
SL7 3HB - 683,000
- Freehold Semi-detached house
SL7 3HB - 808,000
- Freehold Semi-detached house
SL7 3HB - 858,000
- Freehold Semi-detached house
SL7 3HB - 742,000
- Freehold Semi-detached house
SL7 3HB - 715,000
- Freehold Semi-detached house
SL7 3HB - 724,000
- Freehold Semi-detached house
SL7 3HB - 675,000
- Freehold Semi-detached house
SL7 3HB - 705,000
- Freehold Semi-detached house
SL7 3HB - 663,000
- Freehold Semi-detached bungalow
SL7 3HB - 743,000
- Freehold Semi-detached house
SL7 3HB - 615,000
- Freehold Semi-detached bungalow
SL7 3HB - 648,000
- Freehold Semi-detached house
SL7 3HB - 834,000
- Freehold Semi-detached house
SL7 3HB - 723,000
- Freehold Semi-detached property
SL7 3HB - 710,000
- Semi-detached house
SL7 3HB - 702,000
- Freehold Semi-detached house
SL7 3HB - 879,000
- Freehold Semi-detached property
SL7 3HB - 816,000
- Freehold Semi-detached house
SL7 3HB - 788,000
- Freehold Semi-detached house
SL7 3HB - 769,000
- Freehold Semi-detached house
SL7 3HB - 895,000
- Freehold Detached house
SL7 3HB - 1,074,000
- Freehold Detached house
SL7 3HB - 980,000
- Freehold Detached property
SL7 3HB - 727,000
- Freehold Semi-detached house
SL7 3HB - 795,000
- Freehold Semi-detached house
SL7 3HB - 769,000
- Freehold Semi-detached house
SL7 3HB - 731,000
- Freehold Semi-detached house