SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SW4 7QN' order by fulladdress
SW4 7QN - 731,000
- Leasehold Converted flat
SW4 7QN - 866,000
- Freehold Semi-detached house
SW4 7QN - 670,000
- Leasehold Flat/Maisonette
SW4 7QN - 723,000
- Leasehold Converted flat
SW4 7QN - 544,000
- Leasehold Flat/Maisonette
SW4 7QN - 791,000
- Leasehold Converted flat
SW4 7QN - 741,000
- Leasehold Flat/Maisonette
SW4 7QN - 754,000
- Leasehold Flat/Maisonette
SW4 7QN - 691,000
- Leasehold Converted flat
SW4 7QN - 698,000
- Leasehold Converted flat
SW4 7QN - 754,000
- Leasehold Flat/Maisonette
SW4 7QN - 519,000
- Leasehold Flat/Maisonette
SW4 7QN - 706,000
- Leasehold Flat/Maisonette
SW4 7QN - 634,000
- Freehold Terrace property
SW4 7QN - 661,000
- Leasehold Purpose built flat
SW4 7QN - 641,000
- Leasehold Purpose built flat
SW4 7QN - 543,000
- Leasehold Converted flat
SW4 7QN - 671,000
- Leasehold Converted flat
SW4 7QN - 666,000
- Leasehold Flat/Maisonette
SW4 7QN - 697,000
- Leasehold Converted flat
SW4 7QN - 753,000
- Leasehold Converted flat
SW4 7QN - 752,000
- Leasehold Flat/Maisonette
SW4 7QN - 661,000
- Freehold Terrace property
SW4 7QN - 796,000
- Leasehold Converted flat
SW4 7QN - 791,000
- Leasehold Converted flat
SW4 7QN - 768,000
- Leasehold Converted flat
SW4 7QN - 612,000
- Leasehold Converted flat
SW4 7QN - 565,000
- Leasehold Converted flat
SW4 7QN - 525,000
- Leasehold Flat/Maisonette
SW4 7QN - 765,000
- Leasehold Converted flat
SW4 7QN - 473,000
- Leasehold Converted flat
SW4 7QN - 548,000
- Leasehold Flat/Maisonette
SW4 7QN - 515,000
- Leasehold Purpose built flat
SW4 7QN - 681,000
- Leasehold Converted flat
SW4 7QN - 520,000
- Leasehold Flat/Maisonette
SW4 7QN - 513,000
- Leasehold Flat/Maisonette
SW4 7QN - 761,000
- Leasehold Flat/Maisonette
SW4 7QN - 735,000
- Leasehold Flat/Maisonette
SW4 7QN - 926,000
- Leasehold Flat/Maisonette
SW4 7QN - 843,000
- Leasehold Converted flat
SW4 7QN - 664,000
- Leasehold Flat/Maisonette
SW4 7QN - 678,000
- Leasehold Converted flat
SW4 7QN - 916,000
- Freehold Mid terrace house
SW4 7QN - 636,000
- Leasehold Converted flat
SW4 7QN - 942,000
- Freehold Mid terrace house
SW4 7QN - 556,000
- Freehold Converted flat
SW4 7QN - 977,000
- Freehold Mid terrace house
SW4 7QN - 640,000
- Feudal Converted flat
SW4 7QN - 1,223,000
- Freehold End terrace house
