SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='B74 4TD' order by fulladdress
B74 4TD - 310,000
- Leasehold Flat/Maisonette
B74 4TD - 387,000
- Leasehold Flat/Maisonette
B74 4TD - 818,000
- Freehold Detached house
B74 4TD - 1,120,000
- Freehold Detached house
B74 4TD - 1,264,000
- Freehold Detached house
B74 4TD - 982,000
- Freehold Detached house
B74 4TD - 1,051,000
- Freehold Detached house
B74 4TD - 1,246,000
- Freehold Detached property
B74 4TD - 935,000
- Freehold Detached house
B74 4TD - 957,000
- Freehold Detached house
B74 4TD - 967,000
- Freehold Detached property
B74 4TD - 1,148,000
- Freehold Detached house
B74 4TD - 950,000
- Freehold Detached bungalow
B74 4TD - 1,055,000
- Freehold Detached bungalow
B74 4TD - 1,062,000
- Freehold Detached house
B74 4TD - 936,000
- Freehold Detached house
B74 4TD - 1,197,000
- Freehold Detached property
B74 4TD - 369,000
- Leasehold Flat/Maisonette
B74 4TD - 368,000
- Leasehold Flat/Maisonette
B74 4TD - 290,000
- Leasehold Flat/Maisonette
B74 4TD - 353,000
- Leasehold Flat/Maisonette
B74 4TD - 301,000
- Leasehold Flat/Maisonette
B74 4TD - 399,000
- Leasehold Flat/Maisonette
B74 4TD - 323,000
- Leasehold Flat/Maisonette
B74 4TD - 404,000
- Leasehold Flat/Maisonette
B74 4TD - 326,000
- Leasehold Flat/Maisonette
B74 4TD - 379,000
- Leasehold Flat/Maisonette
B74 4TD - 371,000
- Leasehold Flat/Maisonette
B74 4TD - 374,000
- Leasehold Flat/Maisonette
B74 4TD - 284,000
- Leasehold Purpose built flat
B74 4TD - 346,000
- Leasehold Flat/Maisonette
B74 4TD - 387,000
- Leasehold Flat/Maisonette
B74 4TD - 393,000
- Leasehold Flat/Maisonette
