SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='TW15 2RU' order by fulladdress
TW15 2RU - 316,000
- Leasehold Flat/Maisonette
TW15 2RU - 281,000
- Leasehold Flat/Maisonette
TW15 2RU - 797,000
- Freehold Detached house
TW15 2RU - 801,000
- Freehold Detached property
TW15 2RU - 475,000
- Freehold Terrace property
TW15 2RU - 500,000
- Freehold End terrace house
TW15 2RU - 562,000
- Freehold Detached house
TW15 2RU - 455,000
- Freehold Mid terrace house
TW15 2RU - 517,000
- Freehold End terrace house
TW15 2RU - 704,000
- Freehold Semi-detached house
TW15 2RU - 690,000
- Freehold Semi-detached house
TW15 2RU - 594,000
- Freehold Detached house
TW15 2RU - 307,000
- Leasehold Converted flat
TW15 2RU - 694,000
- Freehold Semi-detached house
TW15 2RU - 696,000
- Freehold Semi-detached house
TW15 2RU - 718,000
- Freehold Semi-detached house
TW15 2RU - 305,000
- Leasehold Converted flat
TW15 2RU - 301,000
- Leasehold Converted flat
TW15 2RU - 307,000
- Freehold Converted flat
TW15 2RU - 299,000
- Leasehold Converted flat
TW15 2RU - 605,000
- Freehold Semi-detached house
TW15 2RU - 297,000
- Leasehold Flat/Maisonette
TW15 2RU - 295,000
- Leasehold Converted flat
TW15 2RU - 337,000
- Leasehold Converted flat
