SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='BD23 1LS' order by fulladdress
BD23 1LS - 499,000
- Freehold Semi-detached property
BD23 1LS - 548,000
- Freehold Semi-detached house
BD23 1LS - 540,000
- Freehold Semi-detached house
BD23 1LS - 839,000
- Freehold Detached property
BD23 1LS - 618,000
- Freehold Detached property
BD23 1LS - 578,000
- Freehold Semi-detached property
BD23 1LS - 425,000
- Freehold Bungalow property
BD23 1LS - 837,000
- Freehold Detached house
BD23 1LS - 1,066,000
- Freehold Detached house
BD23 1LS - 526,000
- Freehold Semi-detached property
BD23 1LS - 703,000
- Freehold Detached house
BD23 1LS - 485,000
- Freehold Semi-detached property
BD23 1LS - 587,000
- Freehold Detached house
BD23 1LS - 419,000
- Freehold Semi-detached house
BD23 1LS - 540,000
- Freehold Detached property
BD23 1LS - 568,000
- Freehold Semi-detached house
BD23 1LS - 535,000
- Freehold Semi-detached house
BD23 1LS - 575,000
- Freehold Semi-detached house
BD23 1LS - 533,000
- Freehold Semi-detached house
BD23 1LS - 543,000
- Freehold Semi-detached house
BD23 1LS - 519,000
- Freehold Semi-detached house
BD23 1LS - 475,000
- Freehold Semi-detached house
BD23 1LS - 552,000
- Freehold Detached house
BD23 1LS - 583,000
- Freehold Semi-detached house
