SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='TR20 9ST' order by fulladdress
TR20 9ST - 589,000
- Freehold Detached bungalow
TR20 9ST - 747,000
- Freehold Detached bungalow
TR20 9ST - 579,000
- Freehold Detached house
TR20 9ST - 556,000
- Freehold Detached house
TR20 9ST - 551,000
- Freehold Detached house
TR20 9ST - 562,000
- Freehold Detached bungalow
TR20 9ST - 544,000
- Freehold Detached bungalow
TR20 9ST - 686,000
- Freehold Detached bungalow
TR20 9ST - 859,000
- Freehold Detached house
TR20 9ST - 560,000
- Freehold Detached bungalow
TR20 9ST - 677,000
- Freehold Detached property
TR20 9ST - 217,000
- Leasehold Purpose built flat
TR20 9ST - 210,000
- Leasehold Purpose built flat
TR20 9ST - 203,000
- Leasehold Flat/Maisonette
TR20 9ST - 930,000
- Freehold Detached bungalow
TR20 9ST - 835,000
- Freehold Detached bungalow
TR20 9ST - 1,005,000
- Freehold Detached bungalow
TR20 9ST - 610,000
- Freehold Detached bungalow
TR20 9ST - 777,000
- Freehold Detached bungalow
TR20 9ST - 602,000
- Freehold Detached bungalow
TR20 9ST - 1,450,000
- Freehold Detached bungalow
TR20 9ST - 767,000
- Freehold Detached bungalow
TR20 9ST - 527,000
- Freehold Detached house
