SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='UB10 8ST' order by fulladdress
UB10 8ST - 824,000
- Freehold Semi-detached property
UB10 8ST - 619,000
- Freehold Semi-detached bungalow
UB10 8ST - 851,000
- Freehold Detached bungalow
UB10 8ST - 843,000
- Freehold Detached house
UB10 8ST - 790,000
- Freehold Detached bungalow
UB10 8ST - 819,000
- Freehold Bungalow property
UB10 8ST - 761,000
- Freehold Semi-detached bungalow
UB10 8ST - 799,000
- Freehold Semi-detached property
UB10 8ST - 697,000
- Freehold Bungalow property
UB10 8ST - 653,000
- Freehold Semi-detached bungalow
UB10 8ST - 679,000
- Freehold Detached bungalow
UB10 8ST - 853,000
- Freehold Semi-detached house
UB10 8ST - 740,000
- Freehold Detached property
UB10 8ST - 761,000
- Freehold Detached bungalow
UB10 8ST - 723,000
- Freehold Semi-detached bungalow
UB10 8ST - 703,000
- Freehold Semi-detached bungalow
UB10 8ST - 824,000
- Freehold Detached bungalow
UB10 8ST - 703,000
- Freehold Semi-detached bungalow
UB10 8ST - 804,000
- Freehold Detached house
UB10 8ST - 728,000
- Freehold Detached property
UB10 8ST - 831,000
- Freehold Detached house
UB10 8ST - 937,000
- Freehold Detached bungalow
UB10 8ST - 889,000
- Freehold Detached bungalow
UB10 8ST - 944,000
- Freehold Detached property
UB10 8ST - 893,000
- Freehold Detached house
UB10 8ST - 821,000
- Freehold Detached property
UB10 8ST - 770,000
- Freehold Detached property
UB10 8ST - 870,000
- Freehold Detached bungalow
UB10 8ST - 897,000
- Freehold Detached bungalow
UB10 8ST - 760,000
- Freehold Semi-detached house
