SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='BA2 4QZ' order by fulladdress
BA2 4QZ - 720,000
- Freehold Mid terrace house
BA2 4QZ - 810,000
- Freehold End terrace house
BA2 4QZ - 705,000
- Freehold Mid terrace house
BA2 4QZ - 777,000
- Freehold Mid terrace house
BA2 4QZ - 758,000
- Freehold Mid terrace house
BA2 4QZ - 798,000
- Freehold Mid terrace house
BA2 4QZ - 816,000
- Freehold Mid terrace house
BA2 4QZ - 833,000
- Freehold Mid terrace house
BA2 4QZ - 870,000
- Freehold Semi-detached house
BA2 4QZ - 808,000
- Freehold Mid terrace house
BA2 4QZ - 777,000
- Freehold Terrace property
BA2 4QZ - 729,000
- Freehold Mid terrace house
BA2 4QZ - 824,000
- Freehold Mid terrace house
BA2 4QZ - 839,000
- Freehold End terrace house
BA2 4QZ - 907,000
- Freehold End terrace house
BA2 4QZ - 915,000
- Freehold Mid terrace house
BA2 4QZ - 843,000
- Freehold Mid terrace house
BA2 4QZ - 787,000
- Freehold Mid terrace house
BA2 4QZ - 767,000
- Freehold Mid terrace house
BA2 4QZ - 927,000
- Freehold Mid terrace house
BA2 4QZ - 878,000
- Freehold Mid terrace house
BA2 4QZ - 928,000
- Freehold Mid terrace house
BA2 4QZ - 788,000
- Freehold Mid terrace house
BA2 4QZ - 786,000
- Freehold Detached house
BA2 4QZ - 767,000
- Freehold Terrace property
BA2 4QZ - 776,000
- Freehold Mid terrace house
BA2 4QZ - 821,000
- Freehold Mid terrace house
BA2 4QZ - 302,000
- Leasehold Converted flat
BA2 4QZ - 851,000
- Freehold Mid terrace house
BA2 4QZ - 794,000
- Freehold Mid terrace house
BA2 4QZ - 828,000
- Freehold Mid terrace house
BA2 4QZ - 874,000
- Freehold End terrace house
BA2 4QZ - 779,000
- Freehold Detached property
BA2 4QZ - 721,000
- Freehold Mid terrace house
BA2 4QZ - 787,000
- Freehold Mid terrace house
BA2 4QZ - 870,000
- Freehold Semi-detached property
