SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='N20 0EU' order by fulladdress
N20 0EU - 987,000
- Freehold Detached house
N20 0EU - 824,000
- Freehold Mid terrace house
N20 0EU - 878,000
- Freehold End terrace house
N20 0EU - 814,000
- Freehold Mid terrace house
N20 0EU - 851,000
- Freehold Mid terrace house
N20 0EU - 809,000
- Freehold End terrace house
N20 0EU - 855,000
- Freehold Detached house
N20 0EU - 791,000
- Freehold End terrace house
N20 0EU - 823,000
- Freehold End terrace house
N20 0EU - 819,000
- Freehold End terrace house
N20 0EU - 952,000
- Freehold Semi-detached house
N20 0EU - 793,000
- Freehold Mid terrace house
N20 0EU - 824,000
- Freehold Mid terrace house
N20 0EU - 784,000
- Freehold Mid terrace house
N20 0EU - 841,000
- Freehold End terrace house
N20 0EU - 789,000
- Freehold Mid terrace house
N20 0EU - 793,000
- Freehold End terrace house
N20 0EU - 784,000
- Freehold Mid terrace house
N20 0EU - 794,000
- Freehold Mid terrace house
N20 0EU - 788,000
- Freehold End terrace house
N20 0EU - 796,000
- Freehold Mid terrace house
N20 0EU - 995,000
- Freehold Detached house
N20 0EU - 804,000
- Freehold End terrace house
N20 0EU - 821,000
- Freehold Semi-detached house
N20 0EU - 786,000
- Freehold Mid terrace house
N20 0EU - 812,000
- Freehold End terrace house
N20 0EU - 871,000
- Freehold End terrace house
N20 0EU - 804,000
- Freehold Mid terrace house
N20 0EU - 783,000
- Freehold End terrace house
N20 0EU - 805,000
- Freehold Mid terrace house
N20 0EU - 812,000
- Freehold Mid terrace house
N20 0EU - 802,000
- Freehold Terrace property
N20 0EU - 965,000
- Freehold Semi-detached house
N20 0EU - 785,000
- Freehold End terrace house
N20 0EU - 801,000
- Freehold End terrace house
N20 0EU - 790,000
- Freehold Mid terrace house
N20 0EU - 791,000
- Freehold End terrace house
N20 0EU - 825,000
- Freehold Semi-detached house
N20 0EU - 827,000
- Freehold End terrace house
N20 0EU - 809,000
- Freehold Mid terrace house
N20 0EU - 804,000
- Freehold End terrace house