SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='TW7 7LB' order by fulladdress
TW7 7LB - 386,000
- Freehold Detached bungalow
TW7 7LB - 500,000
- Leasehold Flat/Maisonette
TW7 7LB - 254,000
- Leasehold Flat/Maisonette
TW7 7LB - 248,000
- Leasehold Purpose built flat
TW7 7LB - 651,000
- Freehold Semi-detached house
TW7 7LB - 579,000
- Semi-detached house
TW7 7LB - 587,000
- Freehold End terrace house
TW7 7LB - 370,000
- Freehold Detached bungalow
TW7 7LB - 324,000
- Leasehold Purpose built flat
TW7 7LB - 584,000
- Freehold Semi-detached house
TW7 7LB - 215,000
- Leasehold Purpose built flat
TW7 7LB - 324,000
- Leasehold Purpose built flat
TW7 7LB - 277,000
- Leasehold Purpose built flat
TW7 7LB - 178,000
- Leasehold Purpose built flat
TW7 7LB - 242,000
- Leasehold Purpose built flat
TW7 7LB - 322,000
- Leasehold Purpose built flat
TW7 7LB - 392,000
- Freehold Terraced bungalow
TW7 7LB - 592,000
- Freehold End terrace house
TW7 7LB - 580,000
- Freehold Mid terrace house
TW7 7LB - 550,000
- Freehold End terrace house
TW7 7LB - 449,000
- Leasehold Purpose built flat
TW7 7LB - 243,000
- Leasehold Flat/Maisonette
TW7 7LB - 260,000
- Leasehold Purpose built flat
TW7 7LB - 408,000
- Feudal Purpose built flat
TW7 7LB - 251,000
- Leasehold Purpose built flat
TW7 7LB - 244,000
- Leasehold Flat/Maisonette
TW7 7LB - 737,000
- Freehold Semi-detached house
TW7 7LB - 582,000
- Semi-detached house
TW7 7LB - 595,000
- Freehold End terrace house
TW7 7LB - 291,000
- Leasehold Flat/Maisonette
TW7 7LB - 208,000
- Leasehold Flat/Maisonette
TW7 7LB - 237,000
- Leasehold Purpose built flat
TW7 7LB - 331,000
- Leasehold Purpose built flat
TW7 7LB - 326,000
- Leasehold Purpose built flat
TW7 7LB - 578,000
- Freehold End terrace house
TW7 7LB - 274,000
- Leasehold Detached house
TW7 7LB - 253,000
- Leasehold Purpose built flat
TW7 7LB - 371,000
- Freehold Detached bungalow
TW7 7LB - 582,000
- Freehold End terrace house
TW7 7LB - 571,000
- Freehold Mid terrace house
TW7 7LB - 569,000
- Freehold Mid terrace house
TW7 7LB - 561,000
- Freehold End terrace house
TW7 7LB - 612,000
- Freehold Semi-detached property
TW7 7LB - 692,000
- Freehold Detached house
TW7 7LB - 266,000
- Leasehold Flat/Maisonette
TW7 7LB - 253,000
- Leasehold Purpose built flat
TW7 7LB - 519,000
- Leasehold End terrace house
TW7 7LB - 264,000
- Leasehold Purpose built flat
TW7 7LB - 266,000
- Leasehold Purpose built flat
TW7 7LB - 436,000
- Leasehold Purpose built flat
TW7 7LB - 372,000
- Freehold Bungalow property
TW7 7LB - 263,000
- Leasehold Purpose built flat
TW7 7LB - 236,000
- Leasehold Purpose built flat