SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SW20 8EH' order by fulladdress
SW20 8EH - 849,000
- Freehold End terrace house
SW20 8EH - 992,000
- Freehold Mid terrace house
SW20 8EH - 876,000
- Freehold End terrace house
SW20 8EH - 790,000
- Freehold Mid terrace house
SW20 8EH - 751,000
- Freehold End terrace house
SW20 8EH - 750,000
- Freehold Mid terrace house
SW20 8EH - 826,000
- Freehold Mid terrace house
SW20 8EH - 883,000
- Freehold Mid terrace house
SW20 8EH - 762,000
- Freehold Terrace property
SW20 8EH - 907,000
- Freehold Mid terrace house
SW20 8EH - 786,000
- Freehold Mid terrace house
SW20 8EH - 935,000
- Freehold Mid terrace house
SW20 8EH - 839,000
- Freehold Mid terrace house
SW20 8EH - 863,000
- Freehold Terrace property
SW20 8EH - 811,000
- Freehold End terrace house
SW20 8EH - 800,000
- Freehold Terrace property
SW20 8EH - 747,000
- Freehold Terrace property
SW20 8EH - 883,000
- Freehold Mid terrace house
SW20 8EH - 738,000
- Freehold Terrace property
SW20 8EH - 806,000
- Freehold Mid terrace house
SW20 8EH - 927,000
- Freehold Mid terrace house
SW20 8EH - 959,000
- Freehold Mid terrace house
SW20 8EH - 728,000
- Freehold Mid terrace house
SW20 8EH - 819,000
- Freehold Mid terrace house
SW20 8EH - 753,000
- Freehold Terrace property
SW20 8EH - 882,000
- Freehold End terrace house
SW20 8EH - 842,000
- Freehold End terrace house
SW20 8EH - 795,000
- Freehold Terrace property
SW20 8EH - 783,000
- Freehold Terrace property
SW20 8EH - 769,000
- Freehold Mid terrace house
SW20 8EH - 918,000
- Freehold Mid terrace house
SW20 8EH - 802,000
- Freehold Mid terrace house
SW20 8EH - 852,000
- Freehold Mid terrace house
SW20 8EH - 837,000
- Freehold Semi-detached house
SW20 8EH - 825,000
- Freehold Semi-detached house
SW20 8EH - 475,000
- Leasehold Converted flat