SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='E1 3NQ' order by fulladdress
E1 3NQ - 798,000
- End terrace house
E1 3NQ - 856,000
- Freehold Mid terrace house
E1 3NQ - 799,000
- Mid terrace house
E1 3NQ - 808,000
- Freehold Mid terrace house
E1 3NQ - 875,000
- Freehold Semi-detached house
E1 3NQ - 812,000
- Freehold End terrace house
E1 3NQ - 823,000
- Freehold End terrace house
E1 3NQ - 796,000
- Freehold Detached house
E1 3NQ - 808,000
- Freehold Mid terrace house
E1 3NQ - 767,000
- Freehold Semi-detached house
E1 3NQ - 833,000
- Freehold End terrace house
E1 3NQ - 821,000
- Freehold Mid terrace house
E1 3NQ - 730,000
- Freehold Semi-detached house
E1 3NQ - 806,000
- Freehold Mid terrace house
E1 3NQ - 769,000
- Detached property
E1 3NQ - 824,000
- Freehold Mid terrace house
E1 3NQ - 827,000
- Freehold Mid terrace house
E1 3NQ - 803,000
- Freehold Mid terrace house
E1 3NQ - 761,000
- Mid terrace house
E1 3NQ - 748,000
- Freehold Mid terrace house
E1 3NQ - 817,000
- Freehold Terraced
E1 3NQ - 807,000
- Freehold End terrace house
E1 3NQ - 781,000
- End terrace house
E1 3NQ - 794,000
- Mid terrace house
E1 3NQ - 791,000
- Freehold Mid terrace house
E1 3NQ - 774,000
- Freehold Terrace property
