SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='TW1 2AR' order by fulladdress
TW1 2AR - 0
- Freehold Detached property
TW1 2AR - 571,000
- Leasehold Converted flat
TW1 2AR - 568,000
- Leasehold Converted flat
TW1 2AR - 368,000
- Leasehold Converted flat
TW1 2AR - 509,000
- Leasehold Flat/Maisonette
TW1 2AR - 542,000
- Leasehold Converted flat
TW1 2AR - 363,000
- Leasehold Converted flat
TW1 2AR - 384,000
- Leasehold Converted flat
TW1 2AR - 610,000
- Leasehold Converted flat
TW1 2AR - 753,000
- Leasehold Converted flat
TW1 2AR - 541,000
- Leasehold Converted flat
TW1 2AR - 671,000
- Leasehold Purpose built flat
TW1 2AR - 847,000
- Leasehold Converted flat
TW1 2AR - 759,000
- Leasehold Converted flat
TW1 2AR - 861,000
- Leasehold Converted flat
TW1 2AR - 616,000
- Leasehold Flat/Maisonette
TW1 2AR - 769,000
- Leasehold Converted flat
TW1 2AR - 638,000
- Leasehold Flat/Maisonette
TW1 2AR - 567,000
- Feudal Purpose built flat
TW1 2AR - 745,000
- Leasehold Converted flat
TW1 2AR - 831,000
- Leasehold Converted flat
TW1 2AR - 648,000
- Leasehold Converted flat
TW1 2AR - 718,000
- Leasehold Converted flat
TW1 2AR - 563,000
- Leasehold Purpose built flat
TW1 2AR - 500,000
- Leasehold Flat/Maisonette
TW1 2AR - 550,000
- Leasehold Purpose built flat
TW1 2AR - 535,000
- Leasehold Purpose built flat
TW1 2AR - 397,000
- Freehold Mid terrace house
TW1 2AR - 1,690,000
- Freehold Detached house
