SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='TW9 4DX' order by fulladdress
TW9 4DX - 919,000
- Leasehold Flat/Maisonette
TW9 4DX - 941,000
- Leasehold Flat/Maisonette
TW9 4DX - 703,000
- Leasehold Purpose built flat
TW9 4DX - 735,000
- Leasehold Flat/Maisonette
TW9 4DX - 593,000
- Leasehold Flat/Maisonette
TW9 4DX - 843,000
- Leasehold Flat/Maisonette
TW9 4DX - 723,000
- Leasehold Flat/Maisonette
TW9 4DX - 833,000
- Leasehold Flat/Maisonette
TW9 4DX - 654,000
- Leasehold Purpose built flat
TW9 4DX - 839,000
- Leasehold Flat/Maisonette
TW9 4DX - 750,000
- Leasehold Flat/Maisonette
TW9 4DX - 1,230,000
- Leasehold Purpose built flat
TW9 4DX - 1,892,000
- Leasehold Flat/Maisonette
TW9 4DX - 760,000
- Leasehold Flat/Maisonette
TW9 4DX - 736,000
- Leasehold Flat/Maisonette
TW9 4DX - 948,000
- Leasehold Flat/Maisonette
TW9 4DX - 1,338,000
- Leasehold Purpose built flat
TW9 4DX - 1,147,000
- Leasehold Flat/Maisonette
TW9 4DX - 833,000
- Leasehold Flat/Maisonette
TW9 4DX - 659,000
- Leasehold Purpose built flat
TW9 4DX - 914,000
- Leasehold Flat/Maisonette
TW9 4DX - 652,000
- Leasehold Flat/Maisonette
TW9 4DX - 694,000
- Leasehold Purpose built flat
TW9 4DX - 591,000
- Leasehold Flat/Maisonette
TW9 4DX - 834,000
- Leasehold Flat/Maisonette
TW9 4DX - 678,000
- Leasehold Flat/Maisonette
TW9 4DX - 668,000
- Leasehold Flat/Maisonette