SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='HA3 8AY' order by fulladdress
HA3 8AY - 268,000
- Freehold Flat/Maisonette
HA3 8AY - 271,000
- Freehold Flat/Maisonette
HA3 8AY - 833,000
- Freehold Semi-detached house
HA3 8AY - 775,000
- Freehold Semi-detached house
HA3 8AY - 808,000
- Freehold Semi-detached house
HA3 8AY - 831,000
- Freehold Semi-detached house
HA3 8AY - 818,000
- Freehold Semi-detached house
HA3 8AY - 846,000
- Semi-detached house
HA3 8AY - 756,000
- Freehold Semi-detached house
HA3 8AY - 718,000
- Freehold Semi-detached house
HA3 8AY - 794,000
- Freehold Semi-detached house
HA3 8AY - 728,000
- Freehold Semi-detached house
HA3 8AY - 758,000
- Freehold Semi-detached house
HA3 8AY - 720,000
- Freehold Semi-detached house
HA3 8AY - 796,000
- Freehold Semi-detached house
HA3 8AY - 767,000
- Freehold Semi-detached house
HA3 8AY - 752,000
- Freehold End terrace house
HA3 8AY - 707,000
- Freehold Semi-detached house
HA3 8AY - 840,000
- Freehold Semi-detached property
HA3 8AY - 738,000
- Freehold Semi-detached house
HA3 8AY - 1,250,000
- Freehold Detached property
HA3 8AY - 831,000
- Freehold Semi-detached property
HA3 8AY - 0
- Freehold Semi-detached property
HA3 8AY - 732,000
- Freehold Semi-detached house
HA3 8AY - 931,000
- Freehold Detached bungalow
HA3 8AY - 262,000
- Leasehold Converted flat
HA3 8AY - 339,000
- Share of freehold Flat/Maisonette
