SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SW5 0RL' order by fulladdress
SW5 0RL - 3,457,000
- Freehold Flat/Maisonette
SW5 0RL - 2,329,000
- Freehold Mid terrace house
SW5 0RL - 2,254,000
- Freehold Mid terrace house
SW5 0RL - 2,341,000
- Freehold Terraced
SW5 0RL - 2,245,000
- Freehold Terrace property
SW5 0RL - 1,796,000
- Freehold Detached house
SW5 0RL - 2,293,000
- Freehold Terraced
SW5 0RL - 2,171,000
- Freehold End terrace house
SW5 0RL - 2,275,000
- Freehold Terrace property
SW5 0RL - 2,126,000
- Mid terrace house
SW5 0RL - 2,406,000
- Freehold Mid terrace house
SW5 0RL - 2,276,000
- Freehold Terrace property
SW5 0RL - 2,397,000
- Freehold Mid terrace house
SW5 0RL - 1,227,000
- Mid terrace house
SW5 0RL - 623,000
- Leasehold Flat/Maisonette
SW5 0RL - 2,176,000
- Mid terrace property
