SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='B92 0BD' order by fulladdress
B92 0BD - 575,000
- Freehold Detached house
B92 0BD - 381,000
- Freehold Terrace property
B92 0BD - 588,000
- Freehold Detached house
B92 0BD - 358,000
- Freehold Mid terrace house
B92 0BD - 681,000
- Freehold Detached house
B92 0BD - 363,000
- Freehold Mid terrace house
B92 0BD - 602,000
- Freehold Detached house
B92 0BD - 562,000
- Freehold Detached bungalow
B92 0BD - 361,000
- Leasehold End terrace house
B92 0BD - 181,000
- Leasehold Flat/Maisonette
B92 0BD - 186,000
- Freehold Flat/Maisonette
B92 0BD - 192,000
- Leasehold Purpose built flat
B92 0BD - 189,000
- Leasehold Purpose built flat
B92 0BD - 811,000
- Freehold Detached house
B92 0BD - 188,000
- Leasehold Flat/Maisonette
B92 0BD - 192,000
- Leasehold Purpose built flat
B92 0BD - 186,000
- Leasehold Purpose built flat
B92 0BD - 187,000
- Leasehold Purpose built flat
B92 0BD - 189,000
- Leasehold Flat/Maisonette
B92 0BD - 190,000
- Leasehold Flat/Maisonette
B92 0BD - 182,000
- Leasehold Purpose built flat
B92 0BD - 186,000
- Leasehold Purpose built flat
B92 0BD - 546,000
- Leasehold Detached house
B92 0BD - 194,000
- Leasehold Purpose built flat
B92 0BD - 189,000
- Leasehold Purpose built flat
B92 0BD - 191,000
- Leasehold Purpose built flat
B92 0BD - 600,000
- Freehold Detached bungalow
B92 0BD - 443,000
- Freehold Semi-detached house
B92 0BD - 666,000
- Freehold Detached bungalow
B92 0BD - 560,000
- Freehold Detached property
B92 0BD - 0
- Freehold Semi-detached house
