SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SW14 8HS' order by fulladdress
SW14 8HS - 443,000
- Leasehold Converted flat
SW14 8HS - 1,015,000
- Leasehold Purpose built flat
SW14 8HS - 992,000
- Leasehold Flat/Maisonette
SW14 8HS - 950,000
- Leasehold Flat/Maisonette
SW14 8HS - 977,000
- Leasehold Flat/Maisonette
SW14 8HS - 891,000
- Leasehold Purpose built flat
SW14 8HS - 1,151,000
- Leasehold Flat/Maisonette
SW14 8HS - 1,027,000
- Leasehold Flat/Maisonette
SW14 8HS - 937,000
- Leasehold Flat/Maisonette
SW14 8HS - 1,066,000
- Leasehold Purpose built flat
SW14 8HS - 972,000
- Leasehold Purpose built flat
SW14 8HS - 474,000
- Leasehold Purpose built flat
SW14 8HS - 1,074,000
- Leasehold Flat/Maisonette
SW14 8HS - 619,000
- Leasehold Flat/Maisonette
SW14 8HS - 1,133,000
- Leasehold Flat/Maisonette
SW14 8HS - 648,000
- Leasehold Purpose built flat
SW14 8HS - 440,000
- Leasehold Flat/Maisonette
SW14 8HS - 421,000
- Leasehold Flat/Maisonette
SW14 8HS - 456,000
- Leasehold Flat/Maisonette
SW14 8HS - 476,000
- Leasehold Purpose built flat
SW14 8HS - 490,000
- Leasehold Flat/Maisonette
SW14 8HS - 570,000
- Leasehold Purpose built flat
SW14 8HS - 581,000
- Leasehold Flat/Maisonette
SW14 8HS - 373,000
- Leasehold Flat/Maisonette
SW14 8HS - 521,000
- Leasehold Purpose built flat
SW14 8HS - 499,000
- Leasehold Converted flat
SW14 8HS - 844,000
- Leasehold Flat/Maisonette
SW14 8HS - 861,000
- Leasehold Flat/Maisonette
SW14 8HS - 693,000
- Leasehold Purpose built flat
SW14 8HS - 657,000
- Leasehold Flat/Maisonette
SW14 8HS - 964,000
- Leasehold Flat/Maisonette
SW14 8HS - 978,000
- Leasehold Flat/Maisonette
