SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='BR1 4BJ' order by fulladdress
BR1 4BJ - 356,000
- Feudal Converted flat
BR1 4BJ - 378,000
- Feudal Converted flat
BR1 4BJ - 1,195,000
- Freehold Semi-detached house
BR1 4BJ - 1,222,000
- Freehold Semi-detached house
BR1 4BJ - 1,352,000
- Freehold Detached property
BR1 4BJ - 1,203,000
- Freehold Semi-detached house
BR1 4BJ - 1,151,000
- Freehold Semi-detached house
BR1 4BJ - 1,012,000
- Freehold Semi-detached house
BR1 4BJ - 1,050,000
- Freehold Semi-detached house
BR1 4BJ - 1,082,000
- Freehold Semi-detached house
BR1 4BJ - 1,303,000
- Freehold Semi-detached house
BR1 4BJ - 1,243,000
- Freehold Semi-detached house
BR1 4BJ - 1,019,000
- Freehold Semi-detached house
BR1 4BJ - 981,000
- Freehold Semi-detached house
BR1 4BJ - 411,000
- Leasehold Converted flat
BR1 4BJ - 421,000
- Freehold Semi-detached property
BR1 4BJ - 1,226,000
- Freehold Semi-detached house
BR1 4BJ - 1,040,000
- Freehold Semi-detached house
BR1 4BJ - 1,155,000
- Freehold Semi-detached property
BR1 4BJ - 993,000
- Freehold Semi-detached house
BR1 4BJ - 1,090,000
- Freehold Semi-detached house
BR1 4BJ - 362,000
- Leasehold Purpose built flat
BR1 4BJ - 364,000
- Leasehold Converted flat
BR1 4BJ - 265,000
- Leasehold Converted flat
