SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='BR3 3QH' order by fulladdress
BR3 3QH - 355,000
- Leasehold Flat/Maisonette
BR3 3QH - 281,000
- Leasehold Purpose built flat
BR3 3QH - 318,000
- Leasehold Purpose built flat
BR3 3QH - 349,000
- Leasehold Purpose built flat
BR3 3QH - 774,000
- Semi-detached house
BR3 3QH - 787,000
- Freehold Semi-detached house
BR3 3QH - 798,000
- Freehold Semi-detached house
BR3 3QH - 825,000
- Freehold Semi-detached house
BR3 3QH - 803,000
- Freehold Semi-detached house
BR3 3QH - 794,000
- Freehold Semi-detached house
BR3 3QH - 770,000
- Freehold Semi-detached house
BR3 3QH - 325,000
- Freehold Flat/Maisonette
BR3 3QH - 794,000
- Freehold Semi-detached house
BR3 3QH - 773,000
- Freehold Semi-detached house
BR3 3QH - 833,000
- Freehold Semi-detached house
BR3 3QH - 805,000
- Freehold Semi-detached house
BR3 3QH - 796,000
- Freehold Semi-detached house
BR3 3QH - 864,000
- Freehold Semi-detached house
BR3 3QH - 754,000
- Freehold Semi-detached house
BR3 3QH - 796,000
- Freehold Semi-detached property
BR3 3QH - 867,000
- Freehold Semi-detached house
BR3 3QH - 799,000
- Freehold Semi-detached house
BR3 3QH - 784,000
- Freehold Semi-detached house
BR3 3QH - 746,000
- Freehold Semi-detached house
BR3 3QH - 849,000
- Leasehold Semi-detached house
BR3 3QH - 252,000
- Leasehold Flat/Maisonette
BR3 3QH - 239,000
- Leasehold Purpose built flat
BR3 3QH - 233,000
- Leasehold Converted flat
BR3 3QH - 271,000
- Leasehold Converted flat