SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='UB1 3AZ' order by fulladdress
UB1 3AZ - 765,000
- Freehold Semi-detached house
UB1 3AZ - 834,000
- Semi-detached house
UB1 3AZ - 810,000
- Freehold Semi-detached house
UB1 3AZ - 259,000
- Leasehold Converted flat
UB1 3AZ - 313,000
- Share of freehold Flat/Maisonette
UB1 3AZ - 714,000
- Freehold Semi-detached house
UB1 3AZ - 703,000
- Semi-detached house
UB1 3AZ - 755,000
- Semi-detached house
UB1 3AZ - 818,000
- Semi-detached house
UB1 3AZ - 725,000
- Freehold Semi-detached house
UB1 3AZ - 801,000
- Freehold Semi-detached house
UB1 3AZ - 842,000
- Freehold Semi-detached house
UB1 3AZ - 836,000
- Freehold Semi-detached house
UB1 3AZ - 746,000
- Freehold Semi-detached house
UB1 3AZ - 702,000
- Freehold Semi-detached property
