SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SW10 9RL' order by fulladdress
SW10 9RL - 2,394,000
- Leasehold Flat/Maisonette
SW10 9RL - 1,541,000
- Leasehold Purpose built flat
SW10 9RL - 2,280,000
- Leasehold Flat/Maisonette
SW10 9RL - 1,599,000
- Leasehold Flat/Maisonette
SW10 9RL - 2,958,000
- Leasehold Flat/Maisonette
SW10 9RL - 1,681,000
- Leasehold Purpose built flat
SW10 9RL - 2,314,000
- Leasehold Purpose built flat
SW10 9RL - 1,539,000
- Leasehold Flat/Maisonette
SW10 9RL - 2,289,000
- Leasehold Flat/Maisonette
SW10 9RL - 2,427,000
- Leasehold Flat/Maisonette
SW10 9RL - 1,833,000
- Leasehold Flat/Maisonette
SW10 9RL - 1,684,000
- Leasehold Flat/Maisonette
SW10 9RL - 1,741,000
- Leasehold Flat/Maisonette
SW10 9RL - 1,776,000
- Leasehold Purpose built flat
SW10 9RL - 1,762,000
- Leasehold Flat/Maisonette
SW10 9RL - 1,813,000
- Leasehold Flat/Maisonette
SW10 9RL - 1,263,000
- Leasehold Purpose built flat
SW10 9RL - 1,847,000
- Leasehold Purpose built flat
SW10 9RL - 1,530,000
- Leasehold Flat/Maisonette
SW10 9RL - 1,578,000
- Leasehold Purpose built flat
SW10 9RL - 1,432,000
- Leasehold Purpose built flat
SW10 9RL - 1,608,000
- Leasehold Flat/Maisonette
SW10 9RL - 1,637,000
- Leasehold Flat/Maisonette
SW10 9RL - 1,435,000
- Leasehold Flat/Maisonette
SW10 9RL - 1,764,000
- Leasehold Flat/Maisonette
SW10 9RL - 1,923,000
- Leasehold Flat/Maisonette
SW10 9RL - 1,827,000
- Leasehold Purpose built flat
SW10 9RL - 1,722,000
- Leasehold Flat/Maisonette
SW10 9RL - 1,542,000
- Leasehold Flat/Maisonette
SW10 9RL - 1,438,000
- Leasehold Flat/Maisonette
SW10 9RL - 1,712,000
- Leasehold Purpose built flat
SW10 9RL - 1,535,000
- Leasehold Purpose built flat
SW10 9RL - 2,025,000
- Leasehold Flat/Maisonette
SW10 9RL - 1,721,000
- Leasehold Flat/Maisonette
