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 0AP' order by fulladdress
SW4 0AP - 1,094,000
- Leasehold End terrace house
SW4 0AP - 832,000
- Leasehold Purpose built flat
SW4 0AP - 1,495,000
- Leasehold End terrace house
SW4 0AP - 1,087,000
- Feudal Purpose built flat
SW4 0AP - 1,404,000
- Leasehold Mid terrace house
SW4 0AP - 1,227,000
- Leasehold Detached property
SW4 0AP - 1,307,000
- Leasehold Detached house
SW4 0AP - 1,043,000
- Leasehold Mid terrace house
SW4 0AP - 1,072,000
- Leasehold Mid terrace house
SW4 0AP - 566,000
- Leasehold End terrace bungalow
SW4 0AP - 1,568,000
- Leasehold Mid terrace house
SW4 0AP - 1,669,000
- Leasehold End terrace house
SW4 0AP - 1,291,000
- Leasehold Mid terrace house
SW4 0AP - 1,161,000
- Leasehold Flat/Maisonette
SW4 0AP - 1,142,000
- Leasehold Converted flat
SW4 0AP - 1,196,000
- Leasehold Flat/Maisonette
SW4 0AP - 1,051,000
- Leasehold Flat/Maisonette
SW4 0AP - 1,094,000
- Leasehold Purpose built flat
SW4 0AP - 1,258,000
- Leasehold Flat/Maisonette
SW4 0AP - 620,000
- Leasehold Purpose built flat
SW4 0AP - 1,461,000
- Leasehold Flat/Maisonette
SW4 0AP - 1,151,000
- Leasehold Flat/Maisonette
SW4 0AP - 2,296,000
- Leasehold Flat/Maisonette
SW4 0AP - 1,044,000
- Leasehold Flat/Maisonette
SW4 0AP - 1,175,000
- Leasehold Flat/Maisonette
SW4 0AP - 1,141,000
- Leasehold Flat/Maisonette
SW4 0AP - 1,368,000
- Leasehold Purpose built flat
SW4 0AP - 1,021,000
- Leasehold Flat/Maisonette
SW4 0AP - 1,293,000
- Leasehold Flat/Maisonette
