SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='E6 1ES' order by fulladdress
E6 1ES - 321,000
- Freehold Flat/Maisonette
E6 1ES - 468,000
- Freehold Terraced
E6 1ES - 514,000
- Freehold Mid terrace house
E6 1ES - 487,000
- Freehold Semi-detached house
E6 1ES - 479,000
- Freehold Mid terrace house
E6 1ES - 425,000
- Freehold Terraced
E6 1ES - 486,000
- Freehold Mid terrace house
E6 1ES - 492,000
- Mid terrace house
E6 1ES - 465,000
- Freehold Mid terrace house
E6 1ES - 491,000
- Freehold Mid terrace house
E6 1ES - 249,000
- Leasehold Flat/Maisonette
E6 1ES - 480,000
- Freehold Mid terrace house
E6 1ES - 483,000
- Freehold Mid terrace house
E6 1ES - 506,000
- Freehold Mid terrace house
E6 1ES - 428,000
- Freehold Terraced
E6 1ES - 502,000
- Freehold Mid terrace house
E6 1ES - 497,000
- Freehold Mid terrace house
E6 1ES - 272,000
- Leasehold Flat/Maisonette
E6 1ES - 651,000
- Freehold End terrace house
E6 1ES - 260,000
- Leasehold Flat/Maisonette
E6 1ES - 298,000
- Leasehold Terrace property
E6 1ES - 292,000
- Leasehold Purpose built flat
E6 1ES - 256,000
- Leasehold Flat/Maisonette
E6 1ES - 252,000
- Leasehold Flat/Maisonette
E6 1ES - 248,000
- Leasehold Purpose built flat
E6 1ES - 268,000
- Leasehold Purpose built flat
E6 1ES - 276,000
- Leasehold Flat/Maisonette
E6 1ES - 282,000
- Leasehold Flat/Maisonette
E6 1ES - 282,000
- Leasehold Flat/Maisonette
E6 1ES - 273,000
- Leasehold Flat/Maisonette
E6 1ES - 277,000
- Leasehold Purpose built flat
E6 1ES - 280,000
- Leasehold Purpose built flat
E6 1ES - 289,000
- Leasehold Purpose built flat
E6 1ES - 345,000
- Leasehold Purpose built flat
