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 8BA' order by fulladdress
UB10 8BA - 746,000
- Freehold Detached bungalow
UB10 8BA - 865,000
- Freehold Detached house
UB10 8BA - 903,000
- Freehold Detached bungalow
UB10 8BA - 804,000
- Freehold Detached bungalow
UB10 8BA - 814,000
- Freehold Detached bungalow
UB10 8BA - 810,000
- Freehold Detached bungalow
UB10 8BA - 777,000
- Freehold Detached property
UB10 8BA - 770,000
- Freehold Detached house
UB10 8BA - 802,000
- Freehold Semi-detached house
UB10 8BA - 835,000
- Freehold Semi-detached house
UB10 8BA - 963,000
- Freehold Detached house
UB10 8BA - 844,000
- Freehold Semi-detached house
UB10 8BA - 781,000
- Freehold Semi-detached house
UB10 8BA - 862,000
- Freehold Semi-detached property
UB10 8BA - 899,000
- Freehold Semi-detached property
UB10 8BA - 903,000
- Freehold Detached house
UB10 8BA - 845,000
- Freehold Semi-detached house
UB10 8BA - 917,000
- Freehold Detached house
UB10 8BA - 775,000
- Freehold Semi-detached house
UB10 8BA - 815,000
- Freehold Detached house
UB10 8BA - 834,000
- Freehold Semi-detached house
