SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='TW8 8ER' order by fulladdress
TW8 8ER - 499,000
- Leasehold Flat/Maisonette
TW8 8ER - 542,000
- Feudal Purpose built flat
TW8 8ER - 409,000
- Leasehold Flat/Maisonette
TW8 8ER - 545,000
- Leasehold Purpose built flat
TW8 8ER - 822,000
- Leasehold Purpose built flat
TW8 8ER - 436,000
- Leasehold Flat/Maisonette
TW8 8ER - 844,000
- Leasehold Flat/Maisonette
TW8 8ER - 482,000
- Leasehold Purpose built flat
TW8 8ER - 445,000
- Leasehold Purpose built flat
TW8 8ER - 544,000
- Leasehold Purpose built flat
TW8 8ER - 521,000
- Leasehold Purpose built flat
TW8 8ER - 520,000
- Leasehold Flat/Maisonette
TW8 8ER - 459,000
- Leasehold Flat/Maisonette
TW8 8ER - 548,000
- Leasehold Flat/Maisonette
TW8 8ER - 534,000
- Leasehold Flat/Maisonette
TW8 8ER - 454,000
- Leasehold Purpose built flat
TW8 8ER - 547,000
- Leasehold Purpose built flat
TW8 8ER - 463,000
- Leasehold Flat/Maisonette
TW8 8ER - 619,000
- Leasehold Flat/Maisonette
TW8 8ER - 545,000
- Leasehold Purpose built flat
TW8 8ER - 459,000
- Leasehold Flat/Maisonette
TW8 8ER - 424,000
- Leasehold Flat/Maisonette
TW8 8ER - 501,000
- Leasehold Flat/Maisonette
TW8 8ER - 521,000
- Leasehold Purpose built flat
TW8 8ER - 499,000
- Leasehold Flat/Maisonette
TW8 8ER - 518,000
- Leasehold Purpose built flat
TW8 8ER - 539,000
- Leasehold Flat/Maisonette
TW8 8ER - 456,000
- Leasehold Flat/Maisonette
TW8 8ER - 519,000
- Leasehold Flat/Maisonette
TW8 8ER - 670,000
- Leasehold Flat/Maisonette
TW8 8ER - 529,000
- Leasehold Purpose built flat
TW8 8ER - 507,000
- Leasehold Purpose built flat
TW8 8ER - 417,000
- Leasehold Purpose built flat
TW8 8ER - 519,000
- Leasehold Flat/Maisonette
TW8 8ER - 521,000
- Leasehold Flat/Maisonette
TW8 8ER - 484,000
- Leasehold Purpose built flat
TW8 8ER - 431,000
- Leasehold Purpose built flat
TW8 8ER - 537,000
- Leasehold Flat/Maisonette
TW8 8ER - 582,000
- Leasehold Purpose built flat
TW8 8ER - 528,000
- Leasehold Flat/Maisonette
TW8 8ER - 455,000
- Leasehold Flat/Maisonette
TW8 8ER - 526,000
- Leasehold Purpose built flat
TW8 8ER - 568,000
- Leasehold Purpose built flat
TW8 8ER - 905,000
- Leasehold Purpose built flat
TW8 8ER - 922,000
- Leasehold Purpose built flat
TW8 8ER - 433,000
- Leasehold Flat/Maisonette
TW8 8ER - 987,000
- Leasehold Flat/Maisonette
TW8 8ER - 569,000
- Leasehold Purpose built flat
TW8 8ER - 562,000
- Leasehold Flat/Maisonette
TW8 8ER - 887,000
- Leasehold Purpose built flat