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 4DZ' order by fulladdress
TW9 4DZ - 684,000
- Leasehold Flat/Maisonette
TW9 4DZ - 1,131,000
- Leasehold Flat/Maisonette
TW9 4DZ - 709,000
- Leasehold Flat/Maisonette
TW9 4DZ - 712,000
- Leasehold Flat/Maisonette
TW9 4DZ - 1,406,000
- Feudal Purpose built flat
TW9 4DZ - 556,000
- Leasehold Purpose built flat
TW9 4DZ - 1,355,000
- Leasehold Purpose built flat
TW9 4DZ - 697,000
- Leasehold Flat/Maisonette
TW9 4DZ - 695,000
- Feudal Purpose built flat
TW9 4DZ - 666,000
- Leasehold Purpose built flat
TW9 4DZ - 670,000
- Leasehold Flat/Maisonette
TW9 4DZ - 1,415,000
- Leasehold Purpose built flat
TW9 4DZ - 577,000
- Leasehold Purpose built flat
TW9 4DZ - 720,000
- Leasehold Flat/Maisonette
TW9 4DZ - 660,000
- Leasehold Purpose built flat
TW9 4DZ - 1,268,000
- Leasehold Flat/Maisonette
TW9 4DZ - 759,000
- Leasehold Flat/Maisonette
TW9 4DZ - 659,000
- Leasehold Purpose built flat
TW9 4DZ - 697,000
- Leasehold Flat/Maisonette
TW9 4DZ - 1,963,000
- Leasehold Flat/Maisonette
TW9 4DZ - 688,000
- Leasehold Purpose built flat
TW9 4DZ - 692,000
- Leasehold Purpose built flat
TW9 4DZ - 653,000
- Leasehold Flat/Maisonette
TW9 4DZ - 777,000
- Leasehold Purpose built flat
TW9 4DZ - 1,358,000
- Leasehold Purpose built flat
TW9 4DZ - 1,852,000
- Leasehold Flat/Maisonette
TW9 4DZ - 2,370,000
- Leasehold Flat/Maisonette
TW9 4DZ - 717,000
- Leasehold Flat/Maisonette
TW9 4DZ - 662,000
- Leasehold Flat/Maisonette
TW9 4DZ - 918,000
- Leasehold Flat/Maisonette
TW9 4DZ - 566,000
- Leasehold Flat/Maisonette
TW9 4DZ - 598,000
- Leasehold Flat/Maisonette
TW9 4DZ - 693,000
- Feudal Purpose built flat
