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 3TD' order by fulladdress
SW6 3TD - 2,987,000
- Freehold Mid terrace house
SW6 3TD - 2,878,000
- Freehold Mid terrace house
SW6 3TD - 2,684,000
- Freehold Mid terrace house
SW6 3TD - 2,616,000
- Freehold Purpose built flat
SW6 3TD - 3,100,000
- Freehold Mid terrace house
SW6 3TD - 3,419,000
- Freehold Terrace property
SW6 3TD - 3,430,000
- Freehold Mid terrace house
SW6 3TD - 1,976,000
- Feudal Terrace property
SW6 3TD - 1,255,000
- Leasehold Converted flat
SW6 3TD - 1,695,000
- Leasehold Mid terrace house
SW6 3TD - 3,772,000
- Freehold Mid terrace house
SW6 3TD - 2,821,000
- Mid terrace house
SW6 3TD - 2,965,000
- Freehold Mid terrace house
SW6 3TD - 3,675,000
- Freehold Mid terrace house
SW6 3TD - 1,227,000
- Leasehold Converted flat
SW6 3TD - 2,917,000
- Freehold Mid terrace house
SW6 3TD - 2,844,000
- Freehold Mid terrace house
SW6 3TD - 2,812,000
- Freehold Mid terrace house
SW6 3TD - 3,769,000
- Freehold Mid terrace house
SW6 3TD - 3,008,000
- Freehold Mid terrace house
SW6 3TD - 2,541,000
- Freehold Mid terrace house
SW6 3TD - 2,757,000
- Freehold End terrace house
SW6 3TD - 2,962,000
- Freehold End terrace house
SW6 3TD - 2,913,000
- Freehold Mid terrace house
SW6 3TD - 2,647,000
- Freehold Mid terrace house
SW6 3TD - 2,798,000
- Freehold Mid terrace house
SW6 3TD - 3,467,000
- Freehold Mid terrace house
SW6 3TD - 3,329,000
- Freehold Mid terrace house
SW6 3TD - 2,959,000
- Freehold Mid terrace house
SW6 3TD - 2,854,000
- Freehold End terrace house
SW6 3TD - 3,009,000
- Freehold Terrace property
SW6 3TD - 3,225,000
- Freehold Detached house
SW6 3TD - 2,937,000
- Freehold Mid terrace house
SW6 3TD - 3,012,000
- Freehold Mid terrace house
SW6 3TD - 3,098,000
- Freehold Terrace property
SW6 3TD - 2,983,000
- Freehold Mid terrace house
SW6 3TD - 3,220,000
- Freehold Mid terrace house