SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='LA9 4TE' order by fulladdress
LA9 4TE - 199,000
- Leasehold Flat/Maisonette
LA9 4TE - 231,000
- Leasehold Flat/Maisonette
LA9 4TE - 325,000
- Leasehold Flat/Maisonette
LA9 4TE - 212,000
- Leasehold Flat/Maisonette
LA9 4TE - 218,000
- Leasehold Flat/Maisonette
LA9 4TE - 375,000
- Leasehold Flat/Maisonette
LA9 4TE - 231,000
- Leasehold Flat/Maisonette
LA9 4TE - 233,000
- Leasehold Flat/Maisonette
LA9 4TE - 171,000
- Leasehold Flat/Maisonette
LA9 4TE - 358,000
- Leasehold Flat/Maisonette
LA9 4TE - 220,000
- Freehold Flat/Maisonette
LA9 4TE - 218,000
- Leasehold Flat/Maisonette
LA9 4TE - 354,000
- Leasehold Flat/Maisonette
LA9 4TE - 220,000
- Leasehold Flat/Maisonette
LA9 4TE - 340,000
- Leasehold Flat/Maisonette
LA9 4TE - 233,000
- Leasehold Flat/Maisonette
LA9 4TE - 376,000
- Leasehold Flat/Maisonette
LA9 4TE - 225,000
- Leasehold Flat/Maisonette
LA9 4TE - 247,000
- Leasehold Flat/Maisonette
LA9 4TE - 273,000
- Leasehold Flat/Maisonette
LA9 4TE - 280,000
- Leasehold Flat/Maisonette
LA9 4TE - 317,000
- Leasehold Flat/Maisonette
LA9 4TE - 238,000
- Leasehold Flat/Maisonette
LA9 4TE - 194,000
- Leasehold Flat/Maisonette
LA9 4TE - 359,000
- Leasehold Flat/Maisonette
LA9 4TE - 197,000
- Leasehold Flat/Maisonette
LA9 4TE - 352,000
- Leasehold Flat/Maisonette
LA9 4TE - 194,000
- Leasehold Flat/Maisonette
LA9 4TE - 368,000
- Leasehold Flat/Maisonette
LA9 4TE - 189,000
- Leasehold Flat/Maisonette
LA9 4TE - 229,000
- Leasehold Flat/Maisonette
LA9 4TE - 230,000
- Leasehold Flat/Maisonette
LA9 4TE - 244,000
- Leasehold Flat/Maisonette
LA9 4TE - 343,000
- Leasehold Flat/Maisonette
LA9 4TE - 228,000
- Leasehold Flat/Maisonette
LA9 4TE - 356,000
- Leasehold Flat/Maisonette
LA9 4TE - 224,000
- Leasehold Flat/Maisonette
LA9 4TE - 328,000
- Leasehold Flat/Maisonette
LA9 4TE - 224,000
- Leasehold Flat/Maisonette
LA9 4TE - 365,000
- Leasehold Flat/Maisonette
LA9 4TE - 240,000
- Leasehold Flat/Maisonette
LA9 4TE - 229,000
- Leasehold Flat/Maisonette
LA9 4TE - 248,000
- Leasehold Flat/Maisonette
LA9 4TE - 374,000
- Leasehold Flat/Maisonette
LA9 4TE - 319,000
- Leasehold Flat/Maisonette
LA9 4TE - 223,000
- Leasehold Flat/Maisonette
LA9 4TE - 242,000
- Leasehold Flat/Maisonette
LA9 4TE - 366,000
- Leasehold Flat/Maisonette
LA9 4TE - 207,000
- Leasehold Flat/Maisonette
LA9 4TE - 307,000
- Leasehold Flat/Maisonette
LA9 4TE - 221,000
- Leasehold Flat/Maisonette
LA9 4TE - 321,000
- Leasehold Flat/Maisonette
LA9 4TE - 351,000
- Leasehold Flat/Maisonette
LA9 4TE - 363,000
- Leasehold Flat/Maisonette
LA9 4TE - 218,000
- Leasehold Flat/Maisonette
LA9 4TE - 324,000
- Leasehold Flat/Maisonette
LA9 4TE - 321,000
- Leasehold Flat/Maisonette
LA9 4TE - 351,000
- Leasehold Flat/Maisonette
LA9 4TE - 218,000
- Leasehold Flat/Maisonette
LA9 4TE - 376,000
- Leasehold Flat/Maisonette