SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SW3 2QH' order by fulladdress
SW3 2QH - 4,556,000
- Freehold Terrace property
SW3 2QH - 4,764,000
- Freehold Mid terrace house
SW3 2QH - 4,565,000
- Freehold Terraced
SW3 2QH - 4,680,000
- Freehold Mid terrace house
SW3 2QH - 4,463,000
- Freehold Mid terrace house
SW3 2QH - 5,398,000
- Freehold Terrace property
SW3 2QH - 4,495,000
- Freehold Mid terrace house
SW3 2QH - 4,940,000
- Freehold Mid terrace house
SW3 2QH - 4,405,000
- Freehold Terrace property
SW3 2QH - 5,381,000
- Freehold Terraced
SW3 2QH - 4,317,000
- Freehold Mid terrace house
SW3 2QH - 4,739,000
- Freehold Mid terrace house
SW3 2QH - 4,738,000
- Freehold Terraced
SW3 2QH - 4,184,000
- Freehold Mid terrace house
SW3 2QH - 4,434,000
- Freehold Mid terrace house
SW3 2QH - 4,196,000
- Freehold Terraced
SW3 2QH - 4,147,000
- Freehold Terrace property
SW3 2QH - 3,400,000
- Freehold Terrace property
SW3 2QH - 4,611,000
- Freehold Terrace property
