SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SW6 3SU' order by fulladdress
SW6 3SU - 4,395,000
- Freehold Terrace property
SW6 3SU - 3,801,000
- Freehold Mid terrace house
SW6 3SU - 4,122,000
- Freehold Terraced
SW6 3SU - 4,343,000
- Freehold Mid terrace house
SW6 3SU - 4,205,000
- Freehold End terrace house
SW6 3SU - 3,679,000
- Freehold Terraced
SW6 3SU - 2,819,000
- Freehold Terrace property
SW6 3SU - 3,958,000
- Freehold Terraced
SW6 3SU - 3,603,000
- Freehold Mid terrace house
SW6 3SU - 4,162,000
- Freehold Terraced
SW6 3SU - 4,349,000
- Freehold Mid terrace house
SW6 3SU - 4,059,000
- Freehold Terraced
SW6 3SU - 4,222,000
- Freehold Terraced
SW6 3SU - 3,636,000
- Freehold Mid terrace house
SW6 3SU - 3,826,000
- Freehold Mid terrace house
SW6 3SU - 3,902,000
- Freehold Mid terrace house
SW6 3SU - 4,667,000
- Freehold Mid terrace house
SW6 3SU - 3,989,000
- Mid terrace property
SW6 3SU - 2,959,000
- Freehold Mid terrace house
SW6 3SU - 3,897,000
- Freehold Mid terrace house
SW6 3SU - 3,917,000
- Freehold Mid terrace house
SW6 3SU - 2,794,000
- Freehold Semi-detached house
SW6 3SU - 4,105,000
- Freehold Terraced
SW6 3SU - 4,499,000
- Freehold Semi-detached house
SW6 3SU - 4,441,000
- Freehold Mid terrace house
SW6 3SU - 4,097,000
- Freehold End terrace house
SW6 3SU - 3,659,000
- Freehold Terraced