SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='HR1 1SG' order by fulladdress
HR1 1SG - 616,000
- Freehold Semi-detached house
HR1 1SG - 717,000
- Freehold Semi-detached house
HR1 1SG - 817,000
- Freehold Semi-detached house
HR1 1SG - 545,000
- Freehold Detached house
HR1 1SG - 778,000
- Freehold Semi-detached house
HR1 1SG - 580,000
- Freehold Detached house
HR1 1SG - 825,000
- Freehold Semi-detached house
HR1 1SG - 921,000
- Freehold Detached house
HR1 1SG - 818,000
- Freehold Semi-detached house
HR1 1SG - 586,000
- Freehold Detached house
HR1 1SG - 836,000
- Freehold Semi-detached house
HR1 1SG - 379,000
- Freehold Detached property
HR1 1SG - 437,000
- Freehold Detached house
HR1 1SG - 530,000
- Freehold Detached house
HR1 1SG - 874,000
- Freehold Detached house
HR1 1SG - 774,000
- Freehold Detached house
HR1 1SG - 645,000
- Freehold Semi-detached house
HR1 1SG - 660,000
- Freehold Semi-detached house
HR1 1SG - 617,000
- Freehold Semi-detached house
HR1 1SG - 931,000
- Freehold Detached house
HR1 1SG - 737,000
- Freehold Semi-detached property
HR1 1SG - 615,000
- Freehold Semi-detached house
HR1 1SG - 915,000
- Freehold Detached house
HR1 1SG - 605,000
- Freehold Detached house
HR1 1SG - 540,000
- Freehold Semi-detached house
HR1 1SG - 808,000
- Freehold Detached house
HR1 1SG - 644,000
- Freehold Semi-detached house
HR1 1SG - 825,000
- Freehold Detached house
HR1 1SG - 746,000
- Freehold Detached house
HR1 1SG - 143,000
- Leasehold Flat/Maisonette
HR1 1SG - 165,000
- Leasehold Flat/Maisonette
HR1 1SG - 217,000
- Leasehold Converted flat
