SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='B91 2BL' order by fulladdress
B91 2BL - 850,000
- Freehold Detached property
B91 2BL - 823,000
- Freehold Detached house
B91 2BL - 856,000
- Freehold Detached house
B91 2BL - 876,000
- Freehold Detached house
B91 2BL - 844,000
- Freehold Detached house
B91 2BL - 862,000
- Freehold Detached house
B91 2BL - 759,000
- Freehold Detached property
B91 2BL - 873,000
- Freehold Detached house
B91 2BL - 809,000
- Freehold Detached house
B91 2BL - 718,000
- Freehold Detached house
B91 2BL - 743,000
- Freehold Detached house
B91 2BL - 798,000
- Freehold Detached house
B91 2BL - 855,000
- Freehold Detached house
B91 2BL - 903,000
- Freehold Detached house
B91 2BL - 844,000
- Freehold Detached house
B91 2BL - 818,000
- Freehold Detached house
B91 2BL - 797,000
- Freehold Detached house
B91 2BL - 736,000
- Freehold Detached house
B91 2BL - 770,000
- Freehold Detached house
B91 2BL - 833,000
- Freehold Detached house
B91 2BL - 952,000
- Freehold Detached house
B91 2BL - 832,000
- Freehold Detached house
B91 2BL - 896,000
- Freehold Detached house
B91 2BL - 810,000
- Freehold Detached property
B91 2BL - 301,000
- Leasehold Flat/Maisonette
B91 2BL - 322,000
- Leasehold Flat/Maisonette
B91 2BL - 329,000
- Leasehold Flat/Maisonette
B91 2BL - 295,000
- Leasehold Purpose built flat
B91 2BL - 304,000
- Leasehold Purpose built flat
B91 2BL - 326,000
- Leasehold Flat/Maisonette
B91 2BL - 305,000
- Leasehold Flat/Maisonette
B91 2BL - 305,000
- Leasehold Flat/Maisonette
B91 2BL - 311,000
- Leasehold Flat/Maisonette
B91 2BL - 345,000
- Leasehold Purpose built flat
B91 2BL - 335,000
- Leasehold Flat/Maisonette
