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 2JJ' order by fulladdress
E6 2JJ - 491,000
- Mid terrace house
E6 2JJ - 512,000
- Freehold Mid terrace house
E6 2JJ - 515,000
- Freehold Terraced
E6 2JJ - 499,000
- Mid terrace house
E6 2JJ - 577,000
- Mid terrace house
E6 2JJ - 537,000
- Freehold Mid terrace house
E6 2JJ - 621,000
- Freehold Mid terrace house
E6 2JJ - 344,000
- Freehold Flat/Maisonette
E6 2JJ - 297,000
- Leasehold Flat/Maisonette
E6 2JJ - 607,000
- Freehold Mid terrace house
E6 2JJ - 549,000
- Freehold Terraced
E6 2JJ - 520,000
- Freehold Terrace property
E6 2JJ - 532,000
- Freehold Mid terrace house
E6 2JJ - 487,000
- Mid terrace house
E6 2JJ - 299,000
- Leasehold Converted flat
E6 2JJ - 300,000
- Leasehold Converted flat
E6 2JJ - 419,000
- Freehold Mid terrace house
E6 2JJ - 448,000
- Freehold Mid terrace house
E6 2JJ - 468,000
- Freehold End terrace house
E6 2JJ - 499,000
- Mid terrace house
E6 2JJ - 574,000
- Freehold Mid terrace house
E6 2JJ - 527,000
- Freehold Mid terrace house
E6 2JJ - 483,000
- Freehold Mid terrace house
E6 2JJ - 517,000
- Freehold Mid terrace house
E6 2JJ - 474,000
- Mid terrace house
E6 2JJ - 561,000
- Mid terrace house
E6 2JJ - 500,000
- Freehold Mid terrace house
E6 2JJ - 580,000
- Mid terrace house
E6 2JJ - 571,000
- Freehold Terraced
E6 2JJ - 608,000
- Freehold Mid terrace house
E6 2JJ - 344,000
- Leasehold Flat/Maisonette
E6 2JJ - 526,000
- Mid terrace house
E6 2JJ - 292,000
- Leasehold Converted flat
E6 2JJ - 512,000
- Freehold Mid terrace house
E6 2JJ - 479,000
- Freehold Mid terrace house
E6 2JJ - 336,000
- Freehold Flat/Maisonette
E6 2JJ - 292,000
- Feudal Converted flat
