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 9LA' order by fulladdress
SW4 9LA - 897,000
- Leasehold Detached house
SW4 9LA - 5,058,000
- Freehold Semi-detached house
SW4 9LA - 542,000
- Leasehold Converted flat
SW4 9LA - 1,177,000
- Leasehold Terrace property
SW4 9LA - 784,000
- Leasehold Flat/Maisonette
SW4 9LA - 1,084,000
- Leasehold Purpose built flat
SW4 9LA - 1,170,000
- Leasehold Converted flat
SW4 9LA - 903,000
- Leasehold Purpose built flat
SW4 9LA - 1,201,000
- Leasehold Mid terrace house
SW4 9LA - 1,042,000
- Freehold Purpose built flat
SW4 9LA - 918,000
- Leasehold Flat/Maisonette
SW4 9LA - 1,002,000
- Freehold Mid terrace house
SW4 9LA - 804,000
- Leasehold Flat/Maisonette
SW4 9LA - 830,000
- Leasehold Converted flat
SW4 9LA - 4,814,000
- Freehold Semi-detached house
SW4 9LA - 834,000
- Leasehold Converted flat
SW4 9LA - 824,000
- Leasehold Flat/Maisonette
SW4 9LA - 4,696,000
- Freehold Semi-detached house
SW4 9LA - 725,000
- Leasehold Purpose built flat
SW4 9LA - 375,000
- Leasehold Flat/Maisonette
SW4 9LA - 463,000
- Leasehold Flat/Maisonette
SW4 9LA - 407,000
- Leasehold Converted flat
SW4 9LA - 427,000
- Leasehold Flat/Maisonette
SW4 9LA - 445,000
- Leasehold Flat/Maisonette
SW4 9LA - 422,000
- Leasehold Converted flat
SW4 9LA - 406,000
- Leasehold Flat/Maisonette
SW4 9LA - 381,000
- Leasehold Flat/Maisonette
SW4 9LA - 738,000
- Leasehold Converted flat
SW4 9LA - 380,000
- Leasehold Flat/Maisonette
SW4 9LA - 445,000
- Leasehold Flat/Maisonette
SW4 9LA - 383,000
- Leasehold Flat/Maisonette
SW4 9LA - 412,000
- Leasehold Flat/Maisonette
SW4 9LA - 453,000
- Leasehold Flat/Maisonette
SW4 9LA - 739,000
- Leasehold Flat/Maisonette
SW4 9LA - 763,000
- Leasehold Purpose built flat
SW4 9LA - 764,000
- Leasehold Purpose built flat
SW4 9LA - 442,000
- Leasehold Flat/Maisonette
SW4 9LA - 367,000
- Leasehold Flat/Maisonette
SW4 9LA - 417,000
- Leasehold Flat/Maisonette
SW4 9LA - 446,000
- Leasehold Purpose built flat
SW4 9LA - 425,000
- Leasehold Purpose built flat
SW4 9LA - 464,000
- Leasehold Converted flat
