SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='LA1 5LB' order by fulladdress
LA1 5LB - 648,000
- Freehold Detached house
LA1 5LB - 542,000
- Freehold Detached house
LA1 5LB - 438,000
- Freehold Detached house
LA1 5LB - 502,000
- Freehold Detached house
LA1 5LB - 566,000
- Freehold Detached house
LA1 5LB - 673,000
- Freehold Detached property
LA1 5LB - 602,000
- Freehold Detached house
LA1 5LB - 666,000
- Freehold Detached property
LA1 5LB - 515,000
- Freehold Detached house
LA1 5LB - 523,000
- Freehold Detached house
LA1 5LB - 618,000
- Freehold Detached house
LA1 5LB - 560,000
- Freehold Semi-detached house
LA1 5LB - 561,000
- Freehold Semi-detached house
LA1 5LB - 519,000
- Freehold Detached house
LA1 5LB - 533,000
- Freehold Detached house
LA1 5LB - 518,000
- Freehold Detached house
LA1 5LB - 147,000
- Leasehold Flat/Maisonette
LA1 5LB - 666,000
- Freehold Detached house
LA1 5LB - 155,000
- Leasehold Flat/Maisonette
LA1 5LB - 626,000
- Freehold Detached house
LA1 5LB - 169,000
- Leasehold Flat/Maisonette
LA1 5LB - 693,000
- Freehold Detached house
LA1 5LB - 554,000
- Freehold Detached house
LA1 5LB - 198,000
- Leasehold Flat/Maisonette
LA1 5LB - 641,000
- Freehold Detached house
LA1 5LB - 164,000
- Leasehold Purpose built flat
LA1 5LB - 514,000
- Freehold Detached house
LA1 5LB - 228,000
- Leasehold Flat/Maisonette
LA1 5LB - 529,000
- Freehold Detached house
LA1 5LB - 233,000
- Leasehold Flat/Maisonette
LA1 5LB - 367,000
- Freehold End terrace house
LA1 5LB - 241,000
- Leasehold Flat/Maisonette
LA1 5LB - 549,000
- Freehold Detached house
LA1 5LB - 357,000
- Freehold Mid terrace house
LA1 5LB - 273,000
- Leasehold Flat/Maisonette
LA1 5LB - 504,000
- Freehold Detached house
LA1 5LB - 256,000
- Leasehold Flat/Maisonette
LA1 5LB - 367,000
- Freehold Terrace property
LA1 5LB - 263,000
- Leasehold Purpose built flat
LA1 5LB - 373,000
- Freehold Mid terrace house
LA1 5LB - 278,000
- Leasehold Flat/Maisonette
LA1 5LB - 348,000
- Freehold End terrace house
LA1 5LB - 226,000
- Leasehold Purpose built flat
LA1 5LB - 576,000
- Freehold Detached house
LA1 5LB - 230,000
- Leasehold Flat/Maisonette
LA1 5LB - 230,000
- Leasehold Purpose built flat
LA1 5LB - 227,000
- Leasehold Flat/Maisonette
LA1 5LB - 270,000
- Leasehold Flat/Maisonette
LA1 5LB - 248,000
- Leasehold Flat/Maisonette
LA1 5LB - 681,000
- Freehold Detached property
LA1 5LB - 266,000
- Leasehold Flat/Maisonette
LA1 5LB - 230,000
- Leasehold Purpose built flat
LA1 5LB - 229,000
- Leasehold Flat/Maisonette
LA1 5LB - 220,000
- Leasehold Flat/Maisonette
LA1 5LB - 256,000
- Leasehold Purpose built flat
LA1 5LB - 680,000
- Freehold Detached house
LA1 5LB - 283,000
- Leasehold Flat/Maisonette
LA1 5LB - 235,000
- Leasehold Flat/Maisonette
LA1 5LB - 282,000
- Leasehold Flat/Maisonette
LA1 5LB - 231,000
- Leasehold Flat/Maisonette
LA1 5LB - 544,000
- Freehold Detached house
LA1 5LB - 307,000
- Leasehold Flat/Maisonette
LA1 5LB - 247,000
- Leasehold Flat/Maisonette
LA1 5LB - 558,000
- Freehold Detached property
