SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SW13 9PY' order by fulladdress
SW13 9PY - 2,169,000
- Freehold End terrace house
SW13 9PY - 894,000
- Leasehold Flat/Maisonette
SW13 9PY - 920,000
- Leasehold Terrace property
SW13 9PY - 788,000
- Leasehold Purpose built flat
SW13 9PY - 967,000
- Leasehold Purpose built flat
SW13 9PY - 821,000
- Freehold Purpose built flat
SW13 9PY - 957,000
- Leasehold Flat/Maisonette
SW13 9PY - 898,000
- Leasehold Purpose built flat
SW13 9PY - 1,873,000
- Freehold Mid terrace house
SW13 9PY - 841,000
- Leasehold Converted flat
SW13 9PY - 1,053,000
- Share of freehold Purpose built flat
SW13 9PY - 752,000
- Leasehold Purpose built flat
SW13 9PY - 945,000
- Leasehold Flat/Maisonette
SW13 9PY - 881,000
- Leasehold Flat/Maisonette
SW13 9PY - 804,000
- Leasehold Purpose built flat
SW13 9PY - 686,000
- Freehold Flat/Maisonette
SW13 9PY - 840,000
- Leasehold Purpose built flat
SW13 9PY - 914,000
- Leasehold Purpose built flat
SW13 9PY - 764,000
- Freehold Flat/Maisonette
SW13 9PY - 965,000
- Feudal Purpose built flat
SW13 9PY - 782,000
- Leasehold Flat/Maisonette
SW13 9PY - 833,000
- Leasehold Purpose built flat
SW13 9PY - 750,000
- Leasehold Flat/Maisonette
SW13 9PY - 828,000
- Leasehold Purpose built flat
SW13 9PY - 1,076,000
- Leasehold Flat/Maisonette
SW13 9PY - 1,132,000
- Leasehold Flat/Maisonette
SW13 9PY - 1,142,000
- Leasehold Flat/Maisonette
SW13 9PY - 1,325,000
- Leasehold Flat/Maisonette
SW13 9PY - 1,076,000
- Leasehold Flat/Maisonette
