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 7NG' order by fulladdress
LA9 7NG - 600,000
- Freehold Detached house
LA9 7NG - 582,000
- Freehold Detached house
LA9 7NG - 602,000
- Freehold Detached house
LA9 7NG - 392,000
- Freehold Semi-detached house
LA9 7NG - 412,000
- Freehold Semi-detached house
LA9 7NG - 592,000
- Freehold Detached house
LA9 7NG - 583,000
- Freehold Detached house
LA9 7NG - 593,000
- Freehold Detached house
LA9 7NG - 381,000
- Freehold Semi-detached house
LA9 7NG - 377,000
- Freehold Semi-detached house
LA9 7NG - 411,000
- Freehold Semi-detached house
LA9 7NG - 390,000
- Freehold Semi-detached house
LA9 7NG - 334,000
- Semi-detached house
LA9 7NG - 318,000
- Freehold Semi-detached house
LA9 7NG - 578,000
- Freehold Detached house
LA9 7NG - 273,000
- Freehold Mid terrace bungalow
LA9 7NG - 239,000
- Freehold Semi-detached bungalow
LA9 7NG - 255,000
- Freehold End terrace bungalow
LA9 7NG - 521,000
- Freehold Detached house
LA9 7NG - 506,000
- Freehold Detached house
LA9 7NG - 349,000
- Freehold Semi-detached house
LA9 7NG - 339,000
- Freehold Semi-detached house
LA9 7NG - 518,000
- Freehold Detached house
LA9 7NG - 492,000
- Freehold Detached house
LA9 7NG - 517,000
- Freehold Detached house
LA9 7NG - 418,000
- Freehold Semi-detached house
LA9 7NG - 371,000
- Freehold Semi-detached house
LA9 7NG - 370,000
- Freehold Semi-detached house
LA9 7NG - 524,000
- Freehold Detached house
LA9 7NG - 476,000
- Freehold Detached house
LA9 7NG - 485,000
- Freehold Detached house
LA9 7NG - 479,000
- Freehold Detached house
LA9 7NG - 367,000
- Semi-detached house
LA9 7NG - 367,000
- Semi-detached house
LA9 7NG - 483,000
- Freehold Detached house
LA9 7NG - 415,000
- Freehold Semi-detached house
