SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SW18 4UT' order by fulladdress
SW18 4UT - 688,000
- Freehold End terrace house
SW18 4UT - 878,000
- Freehold Mid terrace house
SW18 4UT - 753,000
- Freehold Mid terrace house
SW18 4UT - 768,000
- Freehold Mid terrace house
SW18 4UT - 813,000
- Freehold Mid terrace house
SW18 4UT - 772,000
- Freehold Mid terrace house
SW18 4UT - 822,000
- Freehold Mid terrace house
SW18 4UT - 907,000
- Freehold Mid terrace house
SW18 4UT - 900,000
- Freehold Mid terrace house
SW18 4UT - 566,000
- Freehold End terrace house
SW18 4UT - 822,000
- Freehold Mid terrace house
SW18 4UT - 831,000
- Freehold Mid terrace house
SW18 4UT - 826,000
- Freehold Mid terrace house
SW18 4UT - 832,000
- Freehold Mid terrace house
SW18 4UT - 872,000
- Freehold Semi-detached property
SW18 4UT - 914,000
- Freehold Terrace property
SW18 4UT - 650,000
- Freehold Flat/Maisonette
SW18 4UT - 1,046,000
- Freehold End terrace property
SW18 4UT - 1,065,000
- Freehold Mid terrace house
SW18 4UT - 827,000
- Freehold Mid terrace house
SW18 4UT - 1,003,000
- Freehold Mid terrace house
SW18 4UT - 475,000
- Leasehold Purpose built flat
SW18 4UT - 468,000
- Leasehold Purpose built flat
SW18 4UT - 528,000
- Leasehold Flat/Maisonette